Id CarModel Email Phone query 2 Audi lali.mahesh@gmail.com 123456 Test
SqlConnection conn; DataSet ds; SqlDataAdapter da; string strSQL = ""; try { ds = new DataSet(); conn = new SqlConnection(sConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand(); da = new SqlDataAdapter(cmd); cmd.Connection = conn; cmd.CommandText = "SP_GETPAGERESULT"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Tables", tableName); cmd.Parameters.AddWithValue("@PK", pk); cmd.Parameters.AddWithValue("@Sort", sSortColumn); cmd.Parameters.AddWithValue("@PageNumber", pageNumber); cmd.Parameters.AddWithValue("@PageSize", pageSize); cmd.Parameters.AddWithValue("@Fields", fields); cmd.Parameters.AddWithValue("@Filter", filter); cmd.Parameters.AddWithValue("@Group", ""); da.Fill(ds); if (filter != "") { strSQL = "SELECT COUNT(*) AS TOTALRECORDS FROM " + tableName + " WHERE " + filter; } else { strSQL = "SELECT COUNT(*) AS TOTALRECORDS FROM " + tableName; } DataSet dsCnt; dsCnt = SqlHelper.ExecuteDataset(sConnectionString, CommandType.Text, strSQL); RecordCount = (int)(dsCnt.Tables[0].Rows[0].ItemArray[0]); //RecordCount = (int)(LoadData(strSQL).Tables[0].Rows[0].ItemArray[0]); control.Items.Clear(); control.DataSource = ds; control.DataBind(); control.RecordCount = RecordCount; conn.Close(); conn.Dispose(); conn = null;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)