how to connect and querysql ASP.NET BY USING C# CODE

[eme2008]

Hello everyone,

I was wondering if anyone could tell me how to connect and query sql databases in ASP.NET
Using C# code
I try to use this code, but there is some mistake in the code lead to an error message

You must first withdraw from sqlDataadapter toolbar to connect to the structural language queries

using System.Data;

using System.Data.SqlClient;


                                 {          string n1,n2,n3,n4;
            n1=TextBox1.Text;
            n2=TextBox2.Text;
            n3=TextBox3.Text;
            n4=TextBox4.Text;

            Conn1.Open();
            Adapter1.InsertCommand=new SqlCommand("Insert Into TEST1 Values('"+n1+"','"+n2+"','"+n3+"','"+n4+"')",Conn1);
            Adapter1.InsertCommand.ExecuteNonQuery();
            Conn1.Close();

}

Thank you in advance

[eme2008]

Hello everyone,

I was wondering if anyone could tell me how to connect and query sql databases in ASP.NET
Using c # code
I try to use this code, but there is some mistake in the code lead to an error message

You must first withdraw from sqlDataadapter toolbar to connect to the structural language queries

using System.Data;

using System.Data.SqlClient;

{ string n1,n2,n3,n4;
n1=TextBox1.Text;
n2=TextBox2.Text;
n3=TextBox3.Text;
n4=TextBox4.Text;

Conn1.Open();
Adapter1.InsertCommand=new SqlCommand("Insert Into TEST1 Values('"+n1+"','"+n2+"','"+n3+"','"+n4+"')",Conn1);
Adapter1.InsertCommand.ExecuteNonQuery();
Conn1.Close();

}

Thank you in advance

[sagar.deshmukh]

I think you must try this code-----

using System.Data;
using System.Data.SqlClient;
{
string n1,n2,n3,n4;
n1=TextBox1.Text;
n2=TextBox2.Text;
n3=TextBox3.Text;
n4=TextBox4.Text;

string qr=Insert Into TEST1 Values('"+n1+"','"+n2+"','"+n3+"','"+n4+"')";

SqlConnection scon=new SqlConnection("server=your computername;uid=sa;pwd=sqlpassword;database=databasename");

SqlDataAdapter sda=new SqlDataAdapter(qr,scon);

DataSet ds=new DataSet();

sda.Fill(ds);

next to this bind it to your dataview or datagrid....

Hope this code will be helpfull

}

[binoj_daniel]

You can read a VB.NET example here..

More ASP.NET Interview Questions