Read Data from data set
<p>I have data set that is being filled from sql query, like this</p>

<pre><code>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);
</code></pre>

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

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

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

<pre><code>string BrDok;
BrDok  = ds_dok.["BrDok"].ToString();
</code></pre>

<p>But nothing, how to extract that BrDok or just put it into procedure?</p>

<p>Thanks infront!</p>
