how save recoreed in the database
Answers were Sorted based on User's Feedback
Answer / ajrun
Dim Query
Query="insert into TableName(username)values('" &
txt_username.text & "')"
Dim cmd as sqlclient.sqlcommand=new
sqlclient.sqlcommand(Query,connection)
cmd.ExecuteNonquery()
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vishnu
System.Data.SqlClient.SqlConnection sqlConnection1 =
new System.Data.SqlClient.SqlConnection("YOUR CONNECTION
STRING");
System.Data.SqlClient.SqlCommand cmd = new
System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT Region (RegionID,
RegionDescription) VALUES (5, 'NorthWestern')";
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venky
string cns=@"server=.\SQLEXPRESS;Database=emp;Integrated Security=SSPI";
cn=new SqlConnection(cns);
string sql = "select * from mytable";
DataSet ds = new DataSet();
SqlDataAdapter adpt=new SqlDataAdapter(sql,cn);
adpt.Fill(ds,"emp1");
.....after altering table....
sqlcommandbuilder cbdr=new sqlcommandbuilder(adpt);
adpt.Update(ds,"emp1");
your changes automaically save into databases...
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / y.gangi reddy
SqlConnection cn = new SqlConnection("user id=sa;pwd=xxx;database=yyy;data source=.");
SqlDataAdapter da = new SqlDataAdapter("select * from tablename", cn);
DataSet ds = new DataSet();
da.Fill(ds, "tablename");
Is This Answer Correct ? | 1 Yes | 2 No |
how barcode print on the win form
Is it possible to set a shortcut key for label?
how to call constructor in abstract class
How many types of dialog boxes windows provides?
What is an example of form?
Which property of textbox cannot be changed at runtime?
what is the Difference between listbox and combo box?
What is the full form of gac?
What is a windows based application?
What?s the difference between the System.Web.UI.WebControls.DataGrid and System.Windows.Forms.DataGrid?
How do you customize the column content inside the datagrid?
What are the properties of datacontrol?