Retreiving fields from DataSet causes errors

Question

Dear All,

Four errors are found in the following screen capture. Could anybody tell me how to fix it?

Answer 1

If you change those single quotes for double quotes then it should fix the syntax error. You'll also need to .ToString() the columns to get the values though:

M_Name = ds1.Tables["Student_table"].Rows[0]["Name"].ToString();
M_Remark = ds1.Tables["Student_table"].Rows[0]["Remark"].ToString();

Sorry - I missed your reply to the topic yesterday but it's best to bump the old topic rather than creating a duplicate to avoid spam.