Seach

inserting data into table by the help of parameters

 SqlConnection c = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\aspprojects\insertion\WebSite1\App_Data\Database.mdf;Integrated Security=True;User Instance=True");
        try
        {
            c.Open();

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = c;
            cmd.CommandText = "insert into student values(@name,@age,@add)";
            cmd.Parameters.AddWithValue("@name", TextBox1.Text);
            cmd.Parameters.AddWithValue("@age",Convert.ToInt32(TextBox2.Text));
            cmd.Parameters.AddWithValue("@add", TextBox3.Text);
            cmd.ExecuteNonQuery();
            clear_();
        }
        catch (Exception e)
        {
            Response.Write(e.Message);
        }
        finally
        {
            c.Close();
        }

No comments: