本文介绍了网格多次显示相同的值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用componentart.grid在asp中开发项目。网格多次显示相同的值。这是我的数据库值
I developing a project in asp with componentart.grid. Grid displays same values multiple times.Here my database values
Id CarModel Email Phone query 2 Audi lali.mahesh@gmail 123456 Test这里我的网格输出: CarModel 电子邮件 电话 查询 http:// localhost:21172 / mkkia。 co.uk/common/images/Grid/asc.gif 删除 奥迪 lali.mahesh @ gmail 123456 测试 删除 奥迪 lali。 mahesh@gmail 123456 测试 删除 我用以下代码:
Here my output in Grid: CarModel Email Phone Query localhost:21172/mkkia.co.uk/common/images/Grid/asc.gif Delete Audi lali.mahesh@gmail 123456 Test Delete Audi lali.mahesh@gmail 123456 Test Delete I use the following code:
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;请任何人帮我解决这个问题
Please any one help me to resolve this
推荐答案嗨朋友们, 我找到了答案。 现在工作正常。 全部谢谢。 Hi Friends, I found the answer for it. Now its working fine. Thanks all.
更多推荐
网格多次显示相同的值
发布评论