62,046
社区成员
发帖
与我相关
我的任务
分享gridview 绑定丢数据
请教下绑定一个可以删除修改的gridview的时候，发现数据有的列不显示，不知道绑定的语法有没有什么问题
string strCon = "server=127.0.0.1;user id=report;password=123456;database=HC;allow zero datetime = true";
string sqlstr = "select CID,name,Date,End_Date,Cycle,Start_P,End_P,Refer_NO,Payment,Status from joy where channel ='eny' order by CID";
MySqlConnection sqlcon = new MySqlConnection(strCon);
MySqlDataAdapter myda = new MySqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds, "Payment_Config");
GridView1.DataSource = myds.Tables[0];
GridView1.DataKeyNames = new string[] { "CID" };//主键
GridView1.DataBind();
string strCon = "server=127.0.0.1;user id=report;password=123456;database=HC;allow zero datetime = true";
string sqlstr = "select CID,name,Date,End_Date,Cycle,Start_P,End_P,Refer_NO,Payment,Status from joy where channel ='eny' order by CID";
MySqlConnection sqlcon = new MySqlConnection(strCon);
MySqlDataAdapter myda = new MySqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds, "Payment_Config");
GridView1.DataSource = myds.Tables[0];
GridView1.DataKeyNames = new string[] { "CID" };//主键
GridView1.DataBind();
...全文
请发表友善的回复…
发表回复
Dorislam610 2012-11-20
- 打赏
- 举报
select CID,name,cast（Date as char) as Fate,cast(End_Date as End_Date as char) as End_Date,Cycle,Start_P,End_P,Refer_NO,Payment,Status from joy where channel ='eny' order by CID
laochen61000 2012-11-20
- 打赏
- 举报
解决了 ，cast（）
laochen61000 2012-11-19
- 打赏
- 举报
uuttmnb 是一样的，所以就很奇怪，第一次遇到
uuttmnb 2012-11-19
- 打赏
- 举报
在数据库里面测试和在vs上运行的语句是不是一样，一样的话你这样写没错误的。
laochen61000 2012-11-19
- 打赏
- 举报
模版
<asp:GridView ID="GridView1" runat="server" Width="1256px" OnPageIndexChanging="GridView1_PageIndexChanging1" OnRowCancelingEdit="GridView1_RowCancelingEdit1" OnRowDeleting="GridView1_RowDeleting1" OnRowEditing="GridView1_RowEditing1" OnRowUpdating="GridView1_RowUpdating1" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" style="text-align: left" CellPadding="4" ForeColor="#333333" GridLines="None" HorizontalAlign="Center">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:CommandField ShowEditButton="True" CancelText="Cancle" DeleteText="Deltele" EditText="Edit" InsertText="Insert" NewText="New" SelectText="Select" UpdateText="Update" />
<asp:CommandField ShowDeleteButton="True" CancelText="Cancle" DeleteText="Delete" EditText="Edit" InsertText="Insert" NewText="New" SelectText="Select" UpdateText="Update" />
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
白云任去留 2012-11-19
- 打赏
- 举报
检查你的GridView1模板列的设置是否匹配！
laochen61000 2012-11-19
- 打赏
- 举报
select CID,name,Date,End_Date,Cycle,Start_P,End_P,Refer_NO,Payment,Status from joy where channel ='eny' order by CID
在数据库里直接跑就能出完整的数据列，
奇怪的很
IT_Ya_Tou 2012-11-19
- 打赏
- 举报
...重新查看你的SQL语句...放入拆分器里面查询....laochen61000 2012-11-19
- 打赏
- 举报
string strCon = "server=127.0.0.1;user id=report;password=123456;database=HC;allow zero datetime = true";
string sqlstr = "select CID,name,Date,End_Date,Cycle,Start_P,End_P,Refer_NO,Payment,Status from joy where channel ='eny' order by CID";
MySqlConnection sqlcon = new MySqlConnection(strCon);
MySqlDataAdapter myda = new MySqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds, "joy");
GridView1.DataSource = myds.Tables[0];
GridView1.DataKeyNames = new string[] { "CID" };//主键
GridView1.DataBind();
不知道什么情况 丢失了一些列
bdmh 2012-11-19
- 打赏
- 举报
语法没问题的
