void add()
{
var docnum = SR_Yr.Text + '-' + SR_No.Text;
string constring = "Data Source=D-HOS-MIS2;Initial Catalog=Consignment_db;Persist Security Info=True;User ID=sa;Password=t.july.01";
string query = "insert into StockRequesitionTable (SR_DocNo,SR_ItemID) values('"+docnum+"',SRT_ID)";
SqlConnection con_db = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand(query, con_db);
try
{
con_db.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}