4
Answers

how to connect database file in my asp.net project

Deekshaa Singh Chauhan

Deekshaa Singh Chauhan
6y
618
1
I have restored database when i connect sql it shows server name blank i entered [.] dot it connect.
when i run my asp.net web application its show instance error.
 
my connection string is:
  1. <add name="WarehouseWebsiteString" connectionString="Data Source=hostingmssql10;Network Library=dbmssocn;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=bea3de-warehousebissdscom; Encrypt=no;Initial Catalog=bea3de-warehousebissdscom; Password=1234;"providerName="System.Data.SqlClient"/>  
i have create login page using database but it not login give error in web.config file:
  1. <?xml version="1.0"?>  
  2. <configuration>  
  3. <appSettings>  
  4. <add key="warehouse_DataAccessLayerType" value="warehouse.DataAccessLayer.SQLDataAccess"/>  
  5. </appSettings>  
  6. <connectionStrings>  
  7. <!--<add name="WarehouseWebsiteString" connectionString="Data Source=BISWEBSERVER\SQLSERVER2005; DataBase=Warehouse; User Id=sa; Password=xfiles_76;"/>-->  
  8. <add name="WarehouseWebsiteString" connectionString="Data Source=hostingmssql06;Network Library=dbmssocn;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=bea3de-warehousebissdscom; Encrypt=no;Initial Catalog=bea3de-warehousebissdscom; Password=1234;"  
  9. providerName="System.Data.SqlClient"/>  
  10. </connectionStrings>  
  11. <system.web>  
  12. <globalization culture="en-US"/>  
  13. <compilation debug="true" targetFramework="4.5"/>  
  14. <authentication mode="Windows"/>  
  15. <customErrors mode="Off"/>  
  16. <pages theme="Theme1" maintainScrollPositionOnPostBack="true" controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>  
  17. </system.web>  
  18. <system.webServer>  
  19. <directoryBrowse enabled="true"/>  
  20. </system.webServer>  
  21. </configuration>  
i'm doing this in login.aspcx.cs:
  1. using System;  
  2. using System.Collections.Generic;  
  3. using System.Linq;  
  4. using System.Web;  
  5. using System.Web.UI;  
  6. using System.Web.UI.WebControls;  
  7. using System.Web.Security;  
  8. using System.Data.SqlClient;  
  9. using System.Web.Configuration;  
  10. public partial class AdminLogin : System.Web.UI.Page  
  11. {  
  12. SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["WarehouseWebsiteString"].ToString());  
  13. protected void Page_Load(object sender, EventArgs e)  
  14. {  
  15. error.Visible = false;  
  16. }  
  17. protected void imgBtnLogin_Click(object sender, ImageClickEventArgs e)  
  18. {  
  19. try  
  20. {  
  21. using (con = new SqlConnection(WebConfigurationManager.ConnectionStrings["WarehouseWebsiteString"].ToString()))  
  22. {  
  23. con.Open();  
  24. string qry = "select * from tblLoginDetails where UserName='" + txtUserName.Text + "' and Password='" + txtPassword.Text + "'";  
  25. SqlCommand cmd = new SqlCommand(qry, con);  
  26. int count = Convert.ToInt32(cmd.ExecuteScalar());  
  27. if (count == 1)  
  28. {  
  29. Session["UserName"] = txtUserName.Text.Trim();  
  30. Response.Redirect("~/Admin/Default.aspx");  
  31. error.Visible = false;  
  32. }  
  33. else  
  34. {  
  35. error.Visible = true;  
  36. }  
  37. }  
  38. con.Close();  
  39. }  
  40. catch (Exception ex)  
  41. {  
  42. Response.Write(ex.Message);  
  43. }  
  44. }  
  45. }  
what can i do i dont understand where mistak how to sove this
Answers (4)
Next Recommended Forum