C#

protected void btnSave_Click(object sender, EventArgs e)

{
   string connString = "Data Source=ServerName;Initial Catalog=DbName;Integrated Security=True"; SqlConnection conn = new    SqlConnection(connString);
   conn.Open();
     String sql = "INSERT INTO CustomerInfo(FirstName, LastName, Address, Order, Quantity) values ('Sai', 'Prasad',    'Hyderabad', 1, 100)";
SqlCommand cmd = new SqlCommand(sql,conn);
     cmd.ExecuteNonQuery();

   conn.Close();

}

using System.Data.SqlClient;

shubham salwan wrote:

i am not able o make connection con

private void button1_Click(object sender, EventArgs e)
        {
            string connString = "Data Source=shubhi-PC;Initial Catalog=employee;uid=sa;pass=abc;Integrated Security=True"; SqlConnection conn = new SqlConnection(connString);
            conn.Open();
            String sql = "INSERT INTO emp_detail(empid,empname,empadd,empsal) values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')";
            
            cmd.ExecuteNonQuery();

            conn.Close();
            textBox1.Text="";

shubham salwan wrote:

bt itz not working

Midnight Ahri wrote:

i need a suggestion, what encryption is best for this problem?

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

and not have the client interact with the database directly.

Midnight Ahri wrote:

i give this application to my friend, and he can save the data in his own database,

my application can connect to his database (using his connection string & wifi) and i can access his address book, also save it to my database.

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]