سؤال مستعجل
هذا الكود الزي كتبته اريده ان يعمل انسيرت لبعض الكولوم من gridview الى new table عندما اضغط select بيعطيني Incorrect syntax near 'CourseID'.
protected void GridView3_SelectedIndexChanged(object sender, EventArgs e)
{
String StudentNumber = Session["LoggedUsername"].ToString();
int SelectIndex;
SelectIndex = GridView3.SelectedIndex;
GridViewRow Row = GridView3.Rows[SelectIndex];
String CourseIDB = Row.Cells[0].Text;
String InstID = Row.Cells[6].Text;
SqlConnection Inconn = new SqlConnection(SqlDataSource5.ConnectionString);
SqlCommand cmd = Inconn.CreateCommand();
cmd.CommandText = "insert into Enrollment (CourseID,StudentID,InstractorID) Values CourseID = @CourseIDB ,StudentID = @StudentNumber,InstractorID = @InstID";
cmd.Parameters.Add("@CourseIDB", SqlDbType.VarChar,3);
cmd.Parameters.Add("@StudentNumber", SqlDbType.VarChar, 12);
cmd.Parameters.Add("@InstID", SqlDbType.VarChar, 12);
cmd.Parameters["@CourseIDB"].Value = CourseIDB;
cmd.Parameters["@StudentNumber"].Value = StudentNumber;
cmd.Parameters["@InstID"].Value = InstID;
try
{
Inconn.Open();
cmd.ExecuteReader();
}
finally
{
Inconn.Close();
}
GridView3.DataBind();
}ارجو المساعده ضرووووري
