mainForm fmmain = (mainForm)this.MdiParent;
sqlda_in.UpdateCommand.Connection = fmmain.grandconnect;
sqlda_in.UpdateCommand.Parameters.Clear();
sqlda_in.UpdateCommand.Parameters.Add("@j_price",SqlDbType.Money);
sqlda_in.UpdateCommand.Parameters.Add("@a_npp",SqlDbType.Int);
sqlda_in.UpdateCommand.Parameters.Add("@otp_cena",SqlDbType.Money);
sqlda_in.UpdateCommand.CommandText=@"update template_in_nakl set j_price = @j_price where a_npp=@a_npp and otp_cena = @otp_cena and username = user_name()";
sqlda_in.UpdateCommand.Parameters["@j_price"].Value = ds_in.Tables[0].Columns[5];
sqlda_in.UpdateCommand.Parameters["@a_npp"].Value = ds_in.Tables[0].Columns[0];
sqlda_in.UpdateCommand.Parameters["@otp_cena"].Value = ds_in.Tables[0].Columns[6];
int rows = sqlda_in.Update(ds_in);
MessageBox.Show(rows.ToString());

private void button1_Click(object sender, System.EventArgs e)
{

for (int i=0;i< ds_in.Tables[0].Rows.Count;i++)
{
ds_in.Tables[0].Rows["j_price"]=Math.Round((decimal)ds_in.Tables[0].Rows["j_price"]*Convert.ToDecimal((Int32.Parse(tb1.Text)/100.0+1)),2);

}
button1.Enabled = false;
}