i want 2 pass values(enterd in textbox)to table in sql
server without using stored procedure in c#.plz tell me
code with an example.
Answer Posted / ranjeet kumar panda
SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;
SQlDataAdapter da;
string sqlstr;
Connection String......
//using DataReader
sqlstr="insert into tablename(Colname) values
("+textBox1.Text+")";
if(con.state==ConnectionState.Open)
con.Close();
cmd.CommandText=sqlstr;
con.Opem();
cmd.ExecuteNonQuery();
//using DataSet
.........
........
da.Fill(ds,"tablename");
DataRow drw=ds.Tables[0].NewRow();
drw[0]=textBox1.Text;
ds.Table[0].Rows.Add(drw);
SqlCommandBuilder cb=new SqlCommandBuilder(da);
da.Update(ds,"tablename");
//Using LinqToSql (.Net 3.5)
DataContextName dc=new DataContextName();
//Lets a Control to bind the data
DataGridView1.DataSource=dc.GetTable<tablename>;
//create an object of class(i.e table)
tablename obj=new tablename();
obj.colname=textBox1.Text;
dc.tablenames.InsertOnSubmit(obj);//'s' in tablenames
//is essential
dc.SubmitChanges();
Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is ado.net tutorial?
Explain the different row versions available in table?
What is the difference between ado.net and entity framework?
What is an ADO.Net?
What is the difference between OLEDB Provider and SqlClient?
What is a sqldataadapter?
Which namespaces are used for data access?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What are the data providers used in ado.net
What is a string variable?
What are different layers of ADO.Net?
What is ole word?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What does executenonquery () method return?
What is the use of connection object in ado.net?