How to fix the errors

Question

How to fix the errors

BenTam-3003 686

Dear All,

In the following screen capture, the error is "Too many characters in charater literal". I have the following questions.

Why in dataadapter.Fill(ds1, "Student_table") uses double quote, and in the statement M_Name = ds1.Tables['Student_table'].Rows[0][Name]; uses single quotes.
How to fix the errors?

Castorix31 91,886 Reputation points

2022-02-06T15:02:10.857+00:00
I don't see the definition of M_Name and M_Remark
If they are defined as string, just add .ToString() at end, like :

M_Name = ds1.Tables["Student_table"].Rows[0]["Name"].ToString();
Castorix31 91,886 Reputation points

2022-02-06T15:05:28.373+00:00

I just saw Paul-5034 answered the same thing in the other thread while I was testing (I answered there because I remembered this thread)

You can mark his answer as right answer...

(I converted my answer into comment as it is useless now)
Jack J Jun 25,306 Reputation points

2022-03-01T02:44:12.31+00:00

@BenTam-3003 , is any update？ I want to know if your current problem has been solved.
BenTam-3003 686 Reputation points

2022-03-01T03:40:01.903+00:00

Hi @Jack J Jun

The problem has been solved by adding '.ToString()' to the end.

Answer accepted by question author

0 additional answers

Your answer

Castorix31 91,886 Reputation points

2022-02-06T15:02:10.857+00:00

I don't see the definition of M_Name and M_Remark
If they are defined as string, just add .ToString() at end, like :

M_Name = ds1.Tables["Student_table"].Rows[0]["Name"].ToString();
Castorix31 91,886 Reputation points

2022-02-06T15:05:28.373+00:00

I just saw Paul-5034 answered the same thing in the other thread while I was testing (I answered there because I remembered this thread)

You can mark his answer as right answer...

(I converted my answer into comment as it is useless now)
Jack J Jun 25,306 Reputation points

2022-03-01T02:44:12.31+00:00

@BenTam-3003 , is any update？ I want to know if your current problem has been solved.
BenTam-3003 686 Reputation points

2022-03-01T03:40:01.903+00:00

Hi @Jack J Jun

The problem has been solved by adding '.ToString()' to the end.

Answer 1

P a u l 10,766

Single quotes are for single characters which are of type char, whereas double quotes represent a string of characters of type string. The way to fix this is to change those single quotes to double quotes.

BenTam-3003 686 Reputation points

2022-02-05T04:42:50.29+00:00

Hi @P a u l

Thanks for your reply. I follow your instructions and make changes. Errors still exist.