textbox

Question

i have a student table with adm_no field ,on registration i want student label to be set to 0 after admiting a student it Add by 1 when registering the second student to pick the last adm_no and add by 1 ........No idea on how to do it proud of your answers

Srikanth Reddy · Answer

intitailly retrieve the last record Id. If it is in integer(id): sqlcommand cmd=new sqlcommand(select max(id) from studentcon); int maxid= (int)cmd.ExecuteScalar(); maxid=maxid+1; //this maxid is needs to be inserted as id. Command.CommandText = INSERT INTO students (adm_nofirst_namelast_namesir_nameid_nodobSex date_admision comment branch_idimageclass_id )VALUES (@adm_no@first_name@last_name@sir_name@id_no@dob@Sex@date_admision @comment@branch_id@image@class_id) SET @student_id =(SELECT SCOPE_IDENTITY()); command.parameters.addwithvalue( @ adm_no  maxid ) ; -------------------------- ---------------------------- ---------- cmd.ExecuteNonQuery(); ----------------------------------------------------------------------------------------------------- Please mark as selected if it helps else come with query. Thank you.

Srikanth Reddy · Answer

Thanks for acceptance. Waiting for your next query.

Srikanth Reddy · Answer

Please mark the answer as accepted. Waiting for your next query. Thank you.

Carlos kambui · Answer

After correction this one worked properly thanks for you support int a = 0; a ++; txtadm.Text = a.ToString(); tStudent.adm_no =Convert.ToInt32 (txtadm.Text);

Carlos kambui · Answer

this my query if (tStudent.student_id == 0 ) { Command.CommandText = INSERT INTO students (adm_nofirst_namelast_namesir_nameid_nodobSex date_admision comment branch_idimageclass_id )VALUES (@adm_no@first_name@last_name@sir_name@id_no@dob@Sex@date_admision @comment@branch_id@image@class_id) SET @student_id =(SELECT SCOPE_IDENTITY()); } this my codes int a = 10; a = a + 1; tStudent.adm_no =a;

Srikanth Reddy · Answer

Your's: tStudent.student_id = 0; a = 10; a = a + 1; tStudent.adm_no =Convert.ToInt32 (txtadm.Text = a.ToString()); tStudent.sir_name = txtsirname.Text; Modified one: int a=10; a=a+1; tStudent.adm_no=a.ToString(); tStudent.sir_name = txtsirname.Text; --------------------------------------------------------------------- Please accept if helps else come with query. Thank you.

Carlos kambui · Answer

Below are my codes kindly correct me int a; StudentType tStudent = new StudentType(); tStudent.student_id = 0; a = 10; a = a + 1; tStudent.adm_no =Convert.ToInt32 (txtadm.Text = a.ToString()); tStudent.sir_name = txtsirname.Text;

Srikanth Reddy · Answer

Hai Carlos kambui  use this command: -->select count(*) from student; It provides the total number of records. For Ex: 10 Then in your code add a=10; a=a+1; ablcount.Text=a.ToString(); --------------------------------------------------------------------------------------- If this answer helps Please mark it as accepted. Thank you.

Upendra Pratap Shahi · Answer

get total count and add 1. like int totalcount=0; totalcount=totalcount+1; lblTest.Text=Convert.ToString(totalcount );