How to Establish database(sql) Connection to receive the data from textfields using c#?

Question

I want to establish the database connection for receiving the data from the Textfields and store that data in database records. For that, up to now I have tried:

I have created the .mdf database files and in that I have created the table with name as Table1 and I have placed the two textfields and submit button, with the following code : data.aspx

<b>Username:<asp:TextBox ID="TextBox1" runat="server" BackColor="AliceBlue">
</asp:TextBox><br/>
<b>Lastname:<asp:TextBox ID="TextBox2" runat="server" BackColor="AliceBlue">
</asp:TextBox><br/>
<asp:Button ID="Button1" runat="server" Text="Submit" OnClick="SubmitBtn_Click"/>

and the code file is as follows: data.aspx.cs

using System.Web.Configuration;
using System.Data.SqlClient;
protected void SubmitBtn_Click(object sender, EventArgs e)
{
    string connectionStrings = "Data Source=|SQLEXPRESS;Integrated                       
   Security=True; Connect Timeout=30;User Instance=True;";

    using (SqlConnection sqlConnection = new SqlConnection(connectionStrings))
{
    string insertStatement = "INSERT INTO Table1(column1,column2) 
                              VALUES (@col1, @col2)";
    SqlCommand sqlCommand = new SqlCommand(insertStatement, sqlConnection);
    sqlCommand.Parameters.AddWithValue("@col1", TextBox1.Text);
    sqlCommand.Parameters.AddWithValue("@col2", TextBox2.Text);
    sqlConnection.Open();
    sqlCommand.ExecuteNonQuery();
    try
    {
        sqlConnection.Open();
        sqlCommand.ExecuteNonQuery();

    }
    finally
    {
        sqlConnection.Close();
    }
}


}

and I have also the configuration files as follows to establish connection the code for that is as follows: web.config

<?xml version="1.0"?>
<configuration>
<system.web>
    <compilation debug="true" targetFramework="4.0" />

</system.web>
</configuration>

but for that code I am getting this error after clicking the submit button:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

and also the exception:

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Can any one help me?

Enable the SqlServerBrowser.. it listens to the requests ...also check if the TCP/IP protocol is not disabled somehow for SQL Server — Bhrugesh Patel, Dec 21 '12 at 15:05
There is problem while enabling the SqlServer Browser but both tcp/ip are enabled — user1918566, Dec 21 '12 at 15:20
Ya the problem was overcomed and SqlServerBrowser was running but there is no change in getting my past exception while running the code — user1918566, Dec 21 '12 at 15:30
not a programer-like but try this..picked up from a blog.." This worked for me. Hope it helps someone else to. When setting up a connection trough wizard: 1. in Add Connection window click on Advanced button 2. Locate Data Source property and delete it." — Bhrugesh Patel, Dec 21 '12 at 15:53

CoffeeCode · Answer 1 · 2012-12-21T14:43:53.930

3

Check if you sql server instance is running. Goto Start->SQL Server Configuration Manager
And check if your sql server instance has been started.

Or try changing your connection string to

string connectionStrings = "Data Source=.\SQLEXPRESS;
 Initial Catalog=databaseName Integrated Security=True;";

edited Dec 21 '12 at 14:43

answered Dec 21 '12 at 14:28

CoffeeCode

4,296
9
40
55

under SqlServerConfigurationManager->SqlServerservices the Sqlserver is running...and remaining SqlServerBrowser and SqlServerAgent both are stopped – user1918566 Dec 21 '12 at 14:38
are you connecting to the right database? is you database name correct? – CoffeeCode Dec 21 '12 at 15:18
Yes it is...MicrosoftSqlServer2008 and i am using the MySqlversion 5.1 in my systme – user1918566 Dec 21 '12 at 15:27
didn't work with MySQL. try checking in the internet if your mysql connection string is correct – CoffeeCode Dec 21 '12 at 15:35

score 0 · Answer 2 · edited May 23 '17 at 11:48

The exception is thrown because your SQL Server instance is not actually reachable, or your SQL Server instance is not started, or there's a firewall blocking the request for the default 1433 port, to reach remotely the SQL Server instance.

Read the documentation page: http://msdn.microsoft.com/en-us/library/ms177440.aspx

Remember to check your connection string. The connection string you wrote:

"Data Source=|SQLEXPRESS;Integrated                       
   Security=True; Connect Timeout=30;User Instance=True;"

I think it's not correct. If you're connecting to your local 2nd SQL instance, named SQLEXPRESS, this is the correct connection string:

"Data Source=.\SQLEXPRESS;Integrated                       
   Security=True; Connect Timeout=30;User Instance=True;"

Furthermore, you're using the setting Integrated Security=True;. This means that you're trying to connect using your Windows credentials. Are you sure you have the rights to connect with your Windows credentials? If not, remove this setting and add your username and password, like in this connection string:

"Data Source=.\SQLEXPRESS;User Id=sa; Password=sa123; Connect Timeout=30;"

Read this interesting question about the use of Integrated Security setting.

Also, your SQLEXPRESS instance seems to be a user instance. Is this instance enabled?

How to Establish database(sql) Connection to receive the data from textfields using c#?

2 Answers2