C#

Question

how to insert values into database using c#?

Arun Kurmi · Answer

hi,maliya rama this is simple...... Note-suppose you want to add name and age in database in windows application. follow following steps- 1.Create a database table having to columns as :name and age. 2.design a window form with 2 textbox(1 for name and another for age), 1 button and a lable. 3.add name space: using System.Data.SqlClient; 4.code on button : string strInsert = "Insert into insertTable([name],[age])values"; strInsert = strInsert + "('" +textBox1.Text + "', "+textBox2.Text + ")"; //MessageBox.Show("Query is:" + strInsert); SqlConnection con = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=ArunDB;Integrated Security=True;Pooling=False"); //this is different for you. //copy connection string form your database and paste here //goto database >rightclick>property>copy connection string and paste here con.Open(); SqlCommand cmd = new SqlCommand(strInsert, con); int x = cmd.ExecuteNonQuery(); label1.Text = "Rows inserted are:" + x; con.Close(); ---------------------------------------------- This is my first reply please give your feedback. And also welcome suggestion from you and other members.

Satyapriya Nayak · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 @ Page Language ="C#" AutoEventWireup ="true" CodeBehind ="Default.aspx.cs" Inherits ="Radio_button_values._Default" %> DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> html xmlns ="http://www.w3.org/1999/xhtml" > head runat ="server"> title > Untitled Page title > head > body > form id ="form1" runat ="server"> div > table align ="center"> tr > td colspan ="2"> h3 > Registraion h3 > td > tr > tr > td > Name: td > td > asp : TextBox ID ="txtName" runat ="server"> asp : TextBox > td > tr > tr > td > Email td > td > asp : TextBox ID ="txtEmail" runat ="server"> asp : TextBox > td > tr > tr > td > Gender td > td > asp : RadioButtonList ID ="rbtGender" runat ="server" RepeatDirection ="Horizontal"> asp : ListItem > Male asp : ListItem > asp : ListItem > Female asp : ListItem > asp : RadioButtonList > td > tr > tr > td align ="center" colspan ="2"> asp : Button ID ="btn_register" runat ="server" Text ="Register" onclick ="btn_register_Click" /> td > tr > tr > td align ="center" colspan ="2"> asp : Label ID ="lblmsg" runat ="server"> asp : Label > td > tr > table > div > form > body > html > using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Radio_button_values { public partial class _Default : System.Web.UI. Page { string strConnString = ConfigurationManager .ConnectionStrings[ "ConnectionString" ].ConnectionString; SqlCommand com; protected void btn_register_Click( object sender, EventArgs e) { SqlConnection con = new SqlConnection (strConnString); com = new SqlCommand (); com.Connection = con; com.CommandType = CommandType .Text; com.CommandText = "insert into login values(@Name,@Email,@Gender)" ; com.Parameters.Clear(); com.Parameters.AddWithValue( "@Name" , txtName.Text); com.Parameters.AddWithValue( "@Email" , txtEmail.Text); com.Parameters.AddWithValue( "@gender" , rbtGender.SelectedValue); if (con.State == ConnectionState .Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = "Data entered successfully!!!" ; } } } /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;}