Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 14560 Views
- Softcon, Tecra, I also Faced
- E-Mail Answers
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
How is it possible to get 2 tables of data at a time by using data reader?
Is datareader faster than datatable?
What is the difference between connected and disconnected environment?
What are the ado.net objects?
Do you use stored procedure in ado.net?
What are the ado.net components?
What is read only and forward only in ado.net?
Compare Data Reader & Dataset in ado.net?
What is difference between datagridview and datagrid control in winforms?
How do you merge 2 datasets into the third dataset in a simple manner?
What is two way data binding android?
Does entity framework use ado.net?
What is a dynaset in access?
What is the functionality of data provider in ado.net?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
