E ) Auto Incriment (ID and Cusno) assigment
* Auto Incriment *
* Auto Generate Id
code :- string k = "select count(id)+1 from paradb"; //id incrimiment by +1 auto
cm = new SqlCommand(k, cn);
txtid.Text = cm.ExecuteScalar().ToString();
* Auto generate Cusno
code :- txtcusno.Text = "NR-" + DateTime.Now.ToString("yyyy") + "00-" + txtid.Text;
* Auto genrate id and cusno concept video*
Comments
Post a Comment