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

Popular posts from this blog

DATA CONTROL ( Gridview , Repeater , Formview , DataList , Detailsview , Listview )

Z 5 ) MVC (Model view Controller)

Z 8 ) MVC HTMLHELPER METHOD AND ACTIONLINK (how to use css ,atrributes,style in css)