} //End Of Insert Function
public static void InsertData(OTInfoclass stock)
{
string query = "INSERT INTO OrderTakerInfoTable (OrderTakerName,OrderTakerCompany,OrderTakerNumber ) VALUES('" + stock.Name.ToUpper() + "','" + stock.CompanyName.ToUpper() + "','" + stock.CompanyNumber.ToUpper() + "');";
try
{
DataTable _dtable = null;
_dtable = dbAccess.ReadDataFromDb(query);
}
catch (Exception ex)
{ throw ex; }
} //End Of Insert Function
private void button2_Click(object sender, EventArgs e)
{
OTInfoclass s = new OTInfoclass();
try
{
s.Name = txtName.Text.Trim();
s.CompanyName = txtcmpnyName.Text;
// QueryClass.DeleteData(s);
MessageBox.Show("Delete Successfully");
}
catch (Exception ex)
{
MessageBox.Show("Error", ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
OTInfoclass os = new OTInfoclass();
try
{
os.Name = txtName.Text.Trim();
os.CompanyName = txtcmpnyName.Text.Trim();
os.CompanyNumber = txtNumber.Text;
// QueryClass.InsertData(fs);
MessageBox.Show("Add Successfully");
}
catch (Exception ex)
{
MessageBox.Show("Error", ex.Message);
}
}
