public void update(string searchkey) { log = new TMS.db(); log.open(); int key; DataTable read; string query = "select id from partysearch where name = '" + searchkey + "'"; read = log.searchquery(query); key = Convert.ToInt32(read.Rows[0][0].ToString()); query = "update party set pname='" + pname + "',address='" + paddress + "',city='" + pcity + "',contact='" + pcontact + "',balance=" + pbalance + " where id = " + key + ""; log.updatequery(query); log.close(); }