Read Data from data set

Question

I have data set that is being filled from sql query, like this

cmd_sql.CommandText = " SELECT BrDok " +
                      " FROM ordersstavke " +
                      " WHERE SifParFil = '" + rw_mat["sifskl_kor"] + "'";

MySqlDataAdapter sql_adapter = new MySqlDataAdapter(cmd_sql);
DataSet ds_dok = new DataSet("ordersstavke");
sql_adapter.Fill(ds_dok);

Now I want to extract value from data set for sql update, like this one

myQuery = "UPDATE ordersstavke " +
          "SET BrDok = '" + rw_mat["brdok"] + "', " +
          "SifParFil = '" + rw_mat["sifskl_kor"] + "', " +
          "WHERE BrDok = " + ds_dok.Tables["ordersstavke"].Rows[0]["BrDok"] + "'";

I tried this ds_dok.Tables["ordersstavke"].Rows[0]["BrDok"] but I got an error, I was thinking to do something like this

string BrDok;
BrDok  = ds_dok.["BrDok"].ToString();

But nothing, how to extract that BrDok or just put it into procedure?

Thanks infront!

what is the error you got here? Please, accept the answers of previous questions, if they helped you. — Sai Kalyan Kumar Akshinthala, May 07 '12 at 10:02
Shitti error: Object reference not set to an instance of an object. — CrBruno, May 07 '12 at 10:06
Do you read the answers to your previous questions? Same error here. — Steve, May 07 '12 at 10:08

score 1 · Answer 1 · answered May 07 '12 at 09:56

1

Make it

 DataSet ds_dok = new DataSet("ordersstavke");
 sql_adapter.Fill(ds_dok,"BrDok");

Then use

ds_dok.Tables["BrDok"].Rows[0]["BrDok"].ToString()

answered May 07 '12 at 09:56

PraveenVenu

8,217
4
30
39

Ok, this works, but I got an error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE BrDok = '565'' at line 1 – CrBruno May 07 '12 at 10:05
@CrBruno, see the query modification in the code i have given. – Sai Kalyan Kumar Akshinthala May 07 '12 at 10:10

score 1 · Answer 2 · answered May 07 '12 at 10:10

1

Try this

ds_dok.Tables[0].Rows[0]["BrDok"]

answered May 07 '12 at 10:10

Asif Mushtaq

13,010
3
33
42

score 0 · Accepted Answer · answered May 07 '12 at 10:06

0

If you provide a string argument for the dataset class, then it will be the dataset name and not the datatable name. And there is no table in the database with name you provided for a dataset, so give it while filling the dataset. Write some thing like below.

DataSet ds_dok = new DataSet();
sql_adapter.Fill(ds_dok,"ordersstavke");

and you can write all the remaining code as it is in your code part.

And your second update query has some syntax error, see it like below

myQuery = "UPDATE ordersstavke " +           "SET BrDok = '" + rw_mat["brdok"] + "', "
 +           "SifParFil = '" + rw_mat["sifskl_kor"] + "', " +           "WHERE BrDok 
 = '" + ds_dok.Tables["ordersstavke"].Rows[0]["BrDok"] + "'";

You forgot to put an starting inverted comma at the where clause.

answered May 07 '12 at 10:06

Sai Kalyan Kumar Akshinthala

11,704
8
43
67

I still have an error with syntax, but i added inverted comma at the where clause. – CrBruno May 07 '12 at 10:13
Got it, I had a comma before WHERE, I need to start better looking at the code. THANKS ALL – CrBruno May 07 '12 at 10:17
vot to undelete this question if you have rights to do it : http://stackoverflow.com/questions/10480605/parameters-and-coding/10480638#10480638 – Pranay Rana May 08 '12 at 04:22
@PranayRana, why you are asking to undelete???? You have more reputation than me, you only can do it right? – Sai Kalyan Kumar Akshinthala May 08 '12 at 04:36
@SaiKalyanAkshinthala - because its answered , have 5 votes on it and except formatting question is good too for beginner thats y ..... – Pranay Rana May 08 '12 at 05:29
sorry, but the question is removed from the stack overflow. If its not removed, i can reopen it. – Sai Kalyan Kumar Akshinthala May 08 '12 at 09:16

score 0 · Answer 4 · answered May 07 '12 at 10:33

0

Just a small hint to the sql-command. You should use sql-parameters to prefent sql-injection.

answered May 07 '12 at 10:33

Tomtom

9,087
7
52
95

Read Data from data set

4 Answers4