String s = "Insert into tbl_Bank_Transaction1 ([TransDate],[ValueDate],[Chqno],[Remark],[amount],[Type],[branch],[bank],[Pin_Transno],[refno],[date],[PStatus],[Status]) values( '" + grv.Cells[1].Text + "','" + grv.Cells[2].Text + "','" + grv.Cells[4].Text + "','" + grv.Cells[5].Text + "','" + grv.Cells[7].Text + "','" + grv.Cells[6].Text + "','" + grv.Cells[3].Text + "','" + ddlbank.SelectedItem.Text + "',null,null,'" + DateTime.Now + "','1','1')".ToString();
comman.commanclass.ExecInsertQuery(s);
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "javascript:alert('Inserted');", true);