how to connect database in asp .net using c#

 Web Config.
<connectionstrings> <add name="mycon" connectionString="Data Source=SQL Server name;Initial Catalog=Database;Integrated Security=True" providerName="System.Data.SqlClient"/></connectionStrings>

C# Coding
using System; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { SqlConnection mycon; SqlCommand mycmd; protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, System.EventArgs e) { mycon = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ToString()); mycon.Open(); mycmd = new SqlCommand("insert into Table name values (@ values, @ values)", mycon); mycmd.Parameters.Add(new SqlParameter("@ values", TextBox1.Text)); mycmd.Parameters.Add(new SqlParameter("@ values", TextBox2.Text)); mycmd.ExecuteNonQuery(); } }

.Net Code
<div> <table width="900" cellpadding="5" border="1px" align="center" bgcolor="white"> <tr> <td> <asp:Label ID="Label9" runat="server" Text="Label" Font-Names="verdana" Font-Size="15px">Name </asp:Label></td> <td > <asp:TextBox ID="TextBox1" runat="server" Width="525px"></asp:TextBox></td> </tr> <tr> <td> <asp:Label ID="Label11" runat="server" Text="Label" Font-Names="verdana" Font-Size="15px">Email </asp:Label></td> <td> <asp:TextBox ID="TextBox2" runat="server" Width="525px"></asp:TextBox> </td> </tr> </table> </div> </form>

Author:- Mr. Ashish Soni