How to insert data from one table

Sanjay Kumar

13y1.6k.NET

How table structure in sql query Problem CousersName = Hindi Subject ID=number series Ex 1, 2, 3,4

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

13y ago
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 Kumar13y ago
how to this code converter to linq query DropDownList_SelectedIndexChanged event any help..
Sanjay Kumar13y ago
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 Kumar13y ago
How to insert CousersName by = (Hindi) Subject ID=Number series for db (Ex 1, 2, 3, 4 )
selva kumar13y ago
Can you explain briefly..