How to insert data from one table

Question

ID COUSERSNAME SUBJECT NAME SUBJECT CODE Subject ID 101 ONE HINDI H1 1 102 ONE HINDI H2 2 103 ONE HINDI H3 3 104 ONE HINDI H4 4 105 TWO ENGLISH E1 1 106 TWO ENGLISH E1 2 107 TWO ENGLISH E1 3 108 TWO ENGLISH E1 4 How table structure in sql query Problem CousersName = Hindi Subject ID=number series Ex 1 2 34

Kailash Chandra Behera · Answer

hi Sanjay try this code // Query for a specific customer. var cust = (from c in db. tablename where c.SubjectID== 1 select c).First(); // Change the name of the contact. cust. CourseName=DropDownList.SelectedValue.ToString() ; // Ask the DataContext to save all the changes. db .SaveChanges(); db .AcceptAllChanges(); db.SubmitChanges();

Sanjay Kumar · Answer

how to this code converter to linq query DropDownList_SelectedIndexChanged event any help..

Sanjay Kumar · Answer

DropDownList_SelectedIndexChanged SqlCommand cmd = new SqlCommand(Select max(SubjectID) from tablename where CourseName=' +DropDownList.SelectedValue.ToString() + ' con); string str = Convert.ToString(cmd.ExecuteScalar()); if (str == ) { lblSubjectID.Text = 1; lblSubjectID.Visible = true; } else { int inc = Convert.ToInt32(str); inc = inc + 1; lblSubjectID.Text = inc.ToString(); lblSubjectID.Visible = true; } problem solving

Sanjay Kumar · Answer

How to insert CousersName by = (Hindi) Subject ID=Number series for db (Ex 1 2 3 4 )

selva kumar · Answer

Can you explain briefly..

ID	COUSERSNAME	SUBJECT NAME	SUBJECT CODE	Subject ID
101	ONE	HINDI	H1	1
102	ONE	HINDI	H2	2
103	ONE	HINDI	H3	3
104	ONE	HINDI	H4	4
105	TWO	ENGLISH	E1	1
106	TWO	ENGLISH	E1	2
107	TWO	ENGLISH	E1	3
108	TWO	ENGLISH	E1	4