Click here to Skip to main content
14,266,113 members
Rate this:
Please Sign up or sign in to vote.
See more:
protected void Button1_Click(object sender, EventArgs e)

        SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\gnani\websites\iconlabssite part2\App_Data\maindatabase.mdf;Integrated Security=True;");
        SqlCommand insert = new SqlCommand("insert into regform(username, password, mobileno,emailid) values(@username, @password, @phoneno,@emailid)", conn);
        insert.Parameters.AddWithValue("@username", TextBox1.Text);
        insert.Parameters.AddWithValue("@password", TextBox2.Text);
        insert.Parameters.AddWithValue("@phoneno", TextBox4.Text);
        insert.Parameters.AddWithValue("@emailid", TextBox5.Text);
        catch (Exception ex)
            LMsg.ForeColor = System.Drawing.Color.Red;
            LMsg.Text = "Error when saving on database";
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox3.Text = "";
        TextBox4.Text = "";
        TextBox5.Text = "";
        TextBox6.Text = "";
Updated 23-Dec-13 19:07pm
JoCodes 24-Dec-13 1:08am
Any error you got?
Karthik_Mahalingam 24-Dec-13 2:01am
error message ??
member 8888995 24-Dec-13 3:50am
Please paste your error.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Have a look here: SQL Server Connection Strings for ASP.NET Web Applications[^], choose your version of MS SQL Server and check if the connection string is properly set.
Member 12373536 6-Mar-16 18:05pm
Pls some one should help me out here...i am doing my school project and my php is not connecting to my data base...
Here is my code

why here is the error msg

Warning: mysql_connect(): Access denied for user 'u562528242_love'@'localhost' (using password: YES) in /home/u562528242/public_html/project/loveword/database.php on line 10 MySQL connect failed. Access denied for user 'u562528242_ delh'@'localhost' (using password: YES)

Pls some one help me out..
Maciej Los 6-Mar-16 18:28pm
You should post it as new question. Do not post comments not related to solution.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100