string connection = ConfigurationManager.ConnectionStrings["mysql"].ConnectionString;
DataSet ds = new DataSet(); MySqlDataAdapter sa = new MySqlDataAdapter("SELECT * FROM oc_order where aktarma = 0 ", connection); sa.Fill(ds); DataGridView2.DataSource = ds.Tables[0]; DataGridView2.Refresh(); DataGridView3.Refresh();
for (int i = 0; i <= ds.Tables[0].Rows.Count -1; i++) {string order_id = ds.Tables[0].Rows[i]["order_id"].ToString().Replace(" ", ""); string gelen = order_id;
order.DataFields.FieldByName("orderid").Value = GELEN;
}