Answer / anand

SqlConnection con = new SqlConnection();

con.ConnectionString = "data source=anand\\sqlexpress.
initial catalog=Database1;integrated security=sspi;";

SqlCommand myCommand = new SqlCommand();

myCommand.CommandText = "Insert into
usr(firstname,lastname,dob,phno,email,Address,state,bgroup)
Values('" + firstname.Text + "','" + lastname.Text + "'," +
dob.Text + "," + phno.Text + ",'" + email.Text + "','" +
Address.Text + "','" + state.Text + "','" + bgroup.Text + "')";

myCommand.Connection = con;

con.Open();

myCommand.ExecuteNonQuery();

con.Close();

Answer / balakumar

string strconn = @"Data Source=localhost;
Initial Catalog=Bala;
Trusted_Connection=yes;";
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
string insertcommand = "insert into Employee
values('" + TextBox1.Text + "','" + TextBox2.Text + "','" +
TextBox3.Text + "')";
SqlCommand cmd = new SqlCommand(insertcommand, conn);
cmd.ExecuteNonQuery();
conn.Close();

Answer / surendra

How to Insert two TextBoxs values in to one column sql database using C# coding

Answer / thualsi

insertBox("(Text1.Text)")+("(Text1.Text)");

Answer / mmm

almost all the posted answers above are correct(85%).

Answer / ghanshyam verma

c# question in type

Answer / jeevananth

try
{
SqlConnecion cn=new SqlConnection("Data
source=.;database=Studentdetail;uid=sa;pwd=sa");
SqlCommand cmd=new SqlCommand();
cn.Open();
string qry;
qry="insert into Table values('"+ TextBox1.Text +"','"+
TextBox2.Text +"')";
cmd=new(qry,cn);
cmd.cmd.ExecuteNonQuery();


cn.Close();
}
catch(Exception ex)
{
Responce.Write(ex.Message.ToString());
}

What are the data types is possible to store in session? and can we store dataset in session?

4 Answers   eMids,

How does viewstate work?

0 Answers  

What is asp.net and its advantages?

0 Answers  

How do we assign page-specific attributes?

0 Answers  

what is the assembly?

2 Answers  

What is the difference between HTTP-Post and HTTP-Get ?

1 Answers  

Is asp.net free?

0 Answers  

what are the security certificates used in webservices?

0 Answers  

what is the cursor

1 Answers   Wipro,

Why will you usually create an aspnet user account in the database for an asp.net web application?

0 Answers  

After capturing the SelectIndexChanged event for a ListBox Control, you find that the event handler doesn?t execute. What could be the problem be? a) The AutoEventWireup attribute is set to False b) The AutomaticPostBack attribute is set to False c) The codebehind module is not properly compiled d) The ListBox must be defined WithEvents.

2 Answers   Syntax Softtech,

Is there any limit for query string? Means what is the maximum size?

0 Answers