Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#..

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

i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#..

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

i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#..

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

i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#..

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

i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#..

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

Post New Answer



More ADO.NET Interview Questions

What are the steps you will take to improve performance?

0 Answers  


What does ado stand for?

0 Answers  


how to keep track of index in listbox items.

2 Answers  


What is ado or jdbc?

0 Answers  


what is the syntax code to oledb to connect oracle

6 Answers   IBM,






What is namespace in ado.net?

0 Answers  


How do you connect to sql server database without using sqlclient?

0 Answers  


Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

0 Answers  


What are different layers of ADO.Net?

0 Answers  


What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

0 Answers  


What is the difference between an ADO.NET Dataset and an ADO Recordset?

0 Answers  


What is ado.net connection?

0 Answers  






Categories