DataView dv;
SqlConnection con;
DataSet ds;
SqlDataAdapter da;
SqlCommand cmd;
public void DataBind()
{
con = new SqlConnection(@"Data Source=abbas-PC\SQLEXPRESS;Initial Catalog=EREGISTRY;Integrated Security=True");
ds = new DataSet();
da = new SqlDataAdapter("select * from REGISTRY", con);
con.Open();
da.Fill(ds, "reg");
con.Close();
dv = new DataView(ds.Tables["reg"]);
textBox1.DataBindings.Clear();
textBox1.DataBindings.Add("Text", dv, "CUSTUMER");
dateTimePicker1.DataBindings.Clear();
dateTimePicker1.DataBindings.Add("Text", dv, "DATE");
textBox3.DataBindings.Clear();
textBox3.DataBindings.Add("Text", dv, "IMAGES NO");
textBox4.DataBindings.Clear();
textBox4.DataBindings.Add("Text", dv, "QUANTITY");
textBox5.DataBindings.Clear();
textBox5.DataBindings.Add("Text", dv, "RATE");
textBox2.DataBindings.Clear();
textBox2.DataBindings.Add("Text", dv, "AMOUNT GIVEN ");
textBox8.DataBindings.Clear();
textBox8.DataBindings.Add("Text", dv, "AMOUNT LEFT");
}
{
cmd = new SqlCommand("insert into REGISTRY values(@CUSTUMER,@DATE,@TOTAL.@IMAGES NO,@QUANTITY,@RATE,@AMOUNT GIVEN,@AMOUNT LEFT)", con);
cmd.Parameters.Add("CUSTUMER ", SqlDbType.Char, 5);
cmd.Parameters.Add("@IMAGES NO", SqlDbType.VarChar, 40);
cmd.Parameters.Add("QUANTITY", SqlDbType.VarChar, 30);
cmd.Parameters.Add("@RATE", SqlDbType.VarChar, 30);
cmd.Parameters.Add("@TOTAL", SqlDbType.VarChar, 60);
cmd.Parameters.Add("@AMOUNT", SqlDbType.VarChar, 15);
cmd.Parameters.Add("@AMOUNT GIVEN ", SqlDbType.Char, 15);
cmd.Parameters.Add("@AMOUNT LEFT ", SqlDbType.Char, 10);
cmd.Parameters["@CUSTOMER "].Value = textBox1.Text;
cmd.Parameters["@DATE "].Value = dateTimePicker1.Value;
cmd.Parameters["@IMAGE NO"].Value = textBox3.Text;
cmd.Parameters["@QUANTITY"].Value = textBox4.Text;
cmd.Parameters["@RATE"].Value = textBox5.Text;
cmd.Parameters["@T0TAL"].Value = textBox7.Text;
cmd.Parameters["AMOUNT GIVEN"].Value = textBox2.Text;
cmd.Parameters["@AMOUNT LEFT"].Value = textBox8.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
string ID = textBox1.Text;
MessageBox.Show("record added successfully");
DataBind();
dv.Sort = "CUSTUMER";
]
[Added from "solution"]
{
cmd = new SqlCommand("insert into REGISTRY values(@CUSTUMER,@DATE,@TOTAL,@IMAGES NO,@QUANTITY,@RATE,@TOTAL,@AMOUNT GIVEN,@AMOUNT LEFT)", con);
cmd.Parameters.Add("@CUSTUMER", SqlDbType.NVarChar, 5);
cmd.Parameters.Add("@DATE", SqlDbType.NVarChar, 15);
cmd.Parameters.Add("@IMAGES NO", SqlDbType.NVarChar, 40);
cmd.Parameters.Add("@QUANTITY", SqlDbType.NVarChar, 30);
cmd.Parameters.Add("@RATE", SqlDbType.NVarChar, 30);
cmd.Parameters.Add("@TOTAL", SqlDbType.NVarChar, 10);
cmd.Parameters.Add("@AMOUNT", SqlDbType.NVarChar, 15);
cmd.Parameters.Add("@AMOUNT GIVEN", SqlDbType.NVarChar, 15);
cmd.Parameters.Add("@AMOUNT LEFT", SqlDbType.NVarChar, 10);
cmd.Parameters["@CUSTUMER"].Value = textBox1.Text;
cmd.Parameters["@DATE"].Value = dateTimePicker1.Value;
cmd.Parameters["@IMAGES NO"].Value = textBox3.Text;
cmd.Parameters["@QUANTITY"].Value = textBox4.Text;
cmd.Parameters["@RATE"].Value = textBox5.Text;
cmd.Parameters["@TOTAL"].Value = textBox7.Text;
cmd.Parameters["@AMOUNT GIVEN"].Value = textBox2.Text;
cmd.Parameters["@AMOUNT LEFT"].Value = textBox8.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
string name = textBox1.Text;
MessageBox.Show("record added successfully");
DataBind();
dv.Sort = "CUSTUMER";