Interested to Buy Any Domain ? << Click Here >> for more details...
how save recoreed in the database
- 4 Answers
- 7504 Views
- Wipro, I also Faced
- E-Mail Answers
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 is a fillable form?
What is the advantage of a form?
How many navigational features are provided by visual studio.net ide?
Explain the difference between listbox and combo box?
how can u split a column header in gridview using C#.net
what are container objects?
What?s the difference between the System.Web.UI.WebControls.DataGrid and System.Windows.Forms.DataGrid?
How to use the FindControl() function to preselect an item in my dropdownlist?
What is the difference between desktop application and windows application?
Which property of the progressbar control specifies the amount to increment the current value of the control?
what is the Difference between listbox and combo box?
If you are calling three SPs from a window application how do u check for the performance of the SPS ?
1 Answers Accenture, BirlaSoft,
Dot Net Framework 
