protected void btnSearch_Click(object sender, EventArgs e)
{
sqlConn = new SqlConnection(sqlConnStr);
sqlConn.Open();
try
{
SqlCommand sqlcmd = new SqlCommand(" 0005_Empolyee_tbl_Search1", sqlConn);
sqlcmd.CommandType = CommandType.StoredProcedure;
if (String.IsNullOrEmpty(txtEmployeeId.Text.Trim()))
sqlcmd.Parameters.Add("@Emp_ID", SqlDbType.Int).Value = 0;
else
sqlcmd.Parameters.Add("@Emp_ID", SqlDbType.Int).Value = int.Parse(txtEmployeeId.Text);
if (String.IsNullOrEmpty(txtEmployeeArName.Text.Trim()))
sqlcmd.Parameters.Add("@Emp_Arabic_Name", SqlDbType.VarChar).Value = DBNull.Value;
else
sqlcmd.Parameters.Add("@Emp_Arabic_Name", SqlDbType.VarChar).Value = txtEmployeeArName.Text.ToString();
if (String.IsNullOrEmpty(txtEmployeeEnName.Text.Trim()))
sqlcmd.Parameters.Add("@Emp_English_Name", SqlDbType.VarChar).Value = DB ...
Go to the complete details ...