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.
Answers were Sorted based on User's Feedback
Answer / bala
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication4
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs
e)
{
String ConnectionString = "Data
Source=ServerName;Initial Catalog=DatabaseName;Integrated
Security=true";
String Query = "insert into tablename values('"
+ textBox1.Text + "')";
SqlConnection Con = new SqlConnection
(ConnectionString) ;
Con.Open();
SqlCommand Cmd = new SqlCommand(Query, Con);
Cmd.ExecuteNonQuery();
Cmd.Dispose();
Con.Close();
}
}
}
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / michael and tubax
sqlconnection con=new sqlconnection
("server=servername;datasource=databasename;uid=sa;pwd=passw
ord);
con.open();
sqlcommand cmd=new sqlcommand("insert into tblname values
('"+txtname.text+"','"+txtage.text+"'",con);
cmd.executnonquery();
con.close();
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / 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 |
Answer / srinivas shahukaru
we havwe differnt ways to pass data to back end .we can pass
data in dis way also
cmd.Command Type=CommandType.Text;
then we can pass values values using inserrtquery in sql
server... insert into tablename values ('textbox1.text,...);
Is This Answer Correct ? | 8 Yes | 5 No |
Answer / sandeep singh shekhawat
Solution1:
SqlConnection con=new SqlConnection("Data Source=./SqlExpress;Database=Test;Integrated Security= true;")
SqlDataAdapter adp=new SqlDataAdapter("insert into employee values(@Id,@Name)",con);
dap.SelectCommand.Parameters.AddwithValue("@Id",TextBox1.Text);
dap.SelectCommand.Parameters.AddWithValue("@Name",TextBox2.Text);
for this sql Connection define globally and after that all code write on button click event.
Solution2
SqlConnection con=new SqlConnection("Data Source=./SqlExpress;Database=Test;Integrated Security= true;")
SqlCommand cmd=new SqlCommand("insert into emp values(@Id,@Name)",con)
cmd.Parameter.AddWithValue("@Id",TextBox1.Text);
cmd.Parameter.AddwithValue("@Name",TextBox2.Text);
if(con.State==ConnectionState.Closed)
con.Open();
cmd.ExecuteNonQuery();
Is This Answer Correct ? | 6 Yes | 3 No |
How can we serialize the dataset object?
What are the Features of a dataset
How can we check that some changes have been made to dataset since it was loaded?
What is the executescalar method?
What is the advantage of ado.net?
WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE
what is a dataview?why is it used for?
How to sort the data in Datatable
What is disconnected scenario in entity framework?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
how to display empty table to datagrid