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 |
What are ACID properties of a transaction in DBMS (Database Management System)?
What are controls in windows forms?
what is acomponent in windows applications?
Which method of the messagebox class is used to display a message in the message box?
What is boxing and how it is done internally?
Which property of textbox cannot be changed at runtime?
What is form design?
What is the use of OLE?
Explain how save rerecord in the database?
how barcode create in the report
Explain how insert record in the database?
For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this?