Query value to textbox c#

Goran Bibic

8y936Learn iOS Programming

I have result System.Data.SqlClient.SqlDataReader

Some help?

private void ukupno_bez_pdv_roba()
{
SqlConnection con2 = new SqlConnection(cs);
string sqlquery = ("select * from mp_racun_roba where tip_robe = 'Roba (Generalno)' and id=" + id_fakture);
SqlCommand command = new SqlCommand(sqlquery, con2);
con2.Open();
SqlDataReader sdr = command.ExecuteReader();
roba_bez_pdvTextBox.Text = sdr.ToString();
con2.Close();
}

6 Replies

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

Nanddeep Nachan8y ago
Accepted answer
You can also use positional parameter
roba_bez_pdvTextBox.Text = Convert.ToString(sdr.GetSqlString(1));
Goran Bibic8y ago
Solved
SqlConnection con2 = new SqlConnection(cs);

           string sqlquery = ("SELECT SUM(isnull(cast(REPLACE(TRY_CONVERT(int,TRY_CONVERT(float,iznos_bpdv),1), '#,0.00','')AS decimal(10,2)),0.00)) as UKUPNObpdv," +
                                     " SUM(isnull(cast(REPLACE(TRY_CONVERT(float, TRY_CONVERT(float, pdv), 1), '#,0.00', '')AS decimal(10, 2)), 0.00)) as UKUPNOpdv," +
                                     " SUM(isnull(cast(REPLACE(TRY_CONVERT(float, TRY_CONVERT(float, iznos_sa_pdv), 1), '#,0.00', '')AS decimal(10, 2)), 0.00)) as UKUPNOsapdv" +
                                     " from mp_racun_roba" +
                                     " where tip_robe = 'Roba (Generalno)' and id_fakture =" + id_fakture
                             );


           SqlCommand command = new SqlCommand(sqlquery, con2);
               con2.Open();
               SqlDataReader sdr = command.ExecuteReader();

               if (sdr.Read())
               {

               roba_bez_pdvTextBox.Text = sdr["UKUPNObpdv"].ToString();
               roba_pdvTextBox.Text = sdr["UKUPNOpdv"].ToString();
               roba_sa_pdvTextBox.Text = sdr["UKUPNOsapdv"].ToString();

           }
               con2.Close();
Sumit Chaudhary8y ago
Hi,

You can not set this output in this text box values because of executed query output like in DataTable so get one by one all column and set in text box value.

Thanks
Sumit Chaudhary
Goran Bibic8y ago
Manas Tripathi
Textbox value is empty....sql query is ok
private void ukupno_bez_pdv_roba()
        {
using (SqlConnection con2 = new SqlConnection(cs))
            using (SqlCommand command = new SqlCommand("select SUM (Try_Convert(float,[iznos_bpdv])) from [mp_racun_roba] where [tip_robe] = 'Roba (Generalno)' and [id] = @id", con2))
            {
                command.Parameters.AddWithValue("@id", id_fakture);

                con2.Open();
                using (SqlDataReader sdr = command.ExecuteReader())
                {
                    if (sdr.Read())
                    {
                        roba_bez_pdvTextBox.Text = sdr["iznos_bpdv"].ToString();

                    }
                }
            }


        }
Goran Bibic8y ago
Nanddeep Nachan
Error...Index was outside the bounds of the array
Manas Tripathi8y ago
roba_bez_pdvTextBox.Text = sdr["ColumnName1"].ToString();

Column Names are in your select query.

select ColumnName1,ColumnName2 from mp_racun_roba

Query value to textbox c#

Manas Tripathi

Nanddeep Nachan