public string SlNo(string tblName, string colName, string srchCodn, Page form)
{
string functionReturnValue = null;
try
{
string sqlQuery = "select max(" + colName + ") + 1 from " + tblName;
if (srchCodn != "")
sqlQuery += " " + srchCodn;
adp = new SqlDataAdapter(sqlQuery, conn);
tbl = new DataTable();
adp.Fill(tbl);
if (tbl.Rows.Count == 0 | tbl.Rows[0][0].ToString() == "")
functionReturnValue = Convert.ToString(1);
else
functionReturnValue = tbl.Rows[0][0].ToString();
tbl.Dispose();
adp.Dispose();
}
catch (Exception ex)
{
MsgBox("Serial No Error: " + ex.Message, form);
return "";
}
return functionReturnValue;
}