try this site
Convert VB.NET to C#[
^]
private void AddStocksInUpdating()
{
if (string.IsNullOrEmpty(txtItemNo.Text)) {
Interaction.MsgBox("Please select item to add stocks.", MsgBoxStyle.Critical, "Select Item");
return;
}
string strStocksIn = null;
strStocksIn = Interaction.InputBox("Enter number of items : ", "Stocks In");
txtQuantity.Text = Conversion.Val(txtQuantity.Text) + Conversion.Val(strStocksIn);
try {
System.Data.sqL = "INSERT INTO StocksIn(ItemNo, ItemQuantity, SIDate, CurrentStocks) VALUES('" + txtItemNo.Text + "', '" + strStocksIn + "', '" + Strings.Format(System.DateTime.Now, "Short Date") + "', " + txtQuantity.Text + ")";
ConnDB();
cmd = new OleDbCommand(System.Data.sqL, conn);
int i = 0;
i = cmd.ExecuteNonQuery();
if (i > 0) {
Interaction.MsgBox("Stocks added successfully", MsgBoxStyle.Information, "Stocks In");
Updateproduct();
}
} catch (Exception ex) {
Interaction.MsgBox(ex.Message);
} finally {
cmd.Dispose();
conn.Close();
}
}