C#

Question

how to insert values into database using c#?

Arun Kurmi · Answer

himaliya 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:Calibrisans-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;}