C# [SQL Data Read]

[​Exo]

/solved

[Mostey]

The sql reader does not contain the result, it reads from the stream that contains the result. Therefore, converting the reader to a string will probably result in the class name.

[​Exo]

Originally Posted by Mostey

The sql reader does not contain the result, it reads from the stream that contains the result. Therefore, converting the reader to a string will probably result in the class name.

So any idea how to get the result to a string?

[Assault IX]

<command>.CommandText = "SELECT Row FROM Table";
string txtNews = Convert.ToString(command.ExecuteScalar());
<richTextBox1>.Text = txtNews;

[Black Tiger ツ]

Originally Posted by xExorcist

So any idea how to get the result to a string?

Don't forget to select a table from your DB.

            private string _readStringDB1;
            private string _readStringDB2;
            private string _readStringDB3;
            
            SqlDataReader reader = Command.ExecuteReader();
            while (reader.Read())
            {
                _readStringDB1 = reader.GetString(0); //First column
                _readStringDB2 = reader.GetString(1); //Second column
                _readStringDB3 = reader.GetString(2); //Third column
            }

[Black Tiger ツ]

Originally Posted by xExorcist

I am gett ofng "0" as a string
cmd.CommandText = ("Select * FROM _Char");
cmd.Connection = sqlconn.cnn;

string txtNews = Convert.ToString(cmd.ExecuteScalar());
richTextBox1.Text = txtNews;
The result should be like this


There's only 1 row in the table

ExecuteScalar can only handle one column / cell. If there is multiple value it will take the first column of the first row.
Use ExecuteReader instead.

Best approach would be LinQ to SQL:

[​Exo]

Originally Posted by Black Tiger ツ

ExecuteScalar can only handle one column / cell. If there is multiple value it will take the first column of the first row.
Use ExecuteReader instead.

Best approach would be LinQ to SQL:

Reader just returns the "System.Data.SqlClient.SqlDataReader" as text...

[Mostey]

Why'd you need that? Just model your data properly and store the inserted objects.

If you want to get the last inserted ID (due to the AI modifier), you may query this as follows:

SELECT LAST_INSERT_ID()

But I'm sure that your library can even handle that, might be stored as property in the result class?