天大怪事!!!!!!!!高手来看看. DataGrid里明明有数据,,,但得不到列???Response.Write(dgselect.Columns.Count);结果是"0"??????????/ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你跟一下它的dataset是否有数据. DataGrid在绑定dataset后还要手动绑定datacolumn才能访问它的Columns集合 string ls_sql;cn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); ls_sql = "SELECT ORDER_NO,QEQUEST_DATE,'' as SELECTED FROM BD_SALES_ORDER_HEAD WHERE COMPLETED = 0";SqlDataAdapter da=new SqlDataAdapter(ls_sql,cn);DataSet ds = new DataSet();da.Fill(ds,"webreturn");dgList.DataSource=ds.Tables["webreturn"];dgList.DataBind();Button2.Attributes.Add("onclick","javascript:returnValue(this);");Response.Write(dgselect.Columns.Count); string ls_sql;cn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); ls_sql = "SELECT ORDER_NO,QEQUEST_DATE,'' as SELECTED FROM BD_SALES_ORDER_HEAD WHERE COMPLETED = 0";SqlDataAdapter da=new SqlDataAdapter(ls_sql,cn);DataSet ds = new DataSet();da.Fill(ds,"webreturn");dgList.DataSource=ds.Tables["webreturn"];dgList.DataBind();Button2.Attributes.Add("onclick","javascript:returnValue(this);");Response.Write(dgList.Columns.Count);上面有个笔误,,,这个就是全的了呀. 加入着个引用uing System.data.SqlClient;namespace hysm{ /// <summary> /// yytd 的摘要说明。 /// </summary> public class yytd : System.Web.UI.Page{ // 然后在着个里面加入 System.data.SqlClient.sqlConnection l;}private void Page_Load(object sender, System.EventArgs e){ li=new SqlConnection("你的数据库连接串 "); SqlDataAdapter sql=new SqlDataAdapter(select * from 表名,li); dataSet x=new dataSet() sql.fill(x,"表名"); DataGrid1.DataSource=x.Tables["表名"] DataGrid1.DataBind();} MsChart控件X轴文字颠倒 关于ASP.NET的验证控件的疑问 IsAllowedExtension 未能找到文件 诚聘项NET目经理 IIS无法打开网页问题,在线等~! .NET FRAMEWORK1.1 能上AJAX吗? datagrid导出excel如何将隐藏列也导出 如何取文件名 我的Web窗体左边是用treeview控件做成的一个目录结构,右边是窗体内容,我想做成CSDN窗体所示的那样,可左右移动中间分界线来改变左右边大小 我要得到FBC_1中的1,请问各位高手怎么载取呀!!在线等,好了马上给分!! asp.net连接oracle的问题? dataset的问题!
还要手动绑定datacolumn才能访问它的Columns集合
cn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
ls_sql = "SELECT ORDER_NO,QEQUEST_DATE,'' as SELECTED FROM BD_SALES_ORDER_HEAD WHERE COMPLETED = 0";
SqlDataAdapter da=new SqlDataAdapter(ls_sql,cn);
DataSet ds = new DataSet();
da.Fill(ds,"webreturn");
dgList.DataSource=ds.Tables["webreturn"];
dgList.DataBind();
Button2.Attributes.Add("onclick","javascript:returnValue(this);");
Response.Write(dgselect.Columns.Count);
cn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
ls_sql = "SELECT ORDER_NO,QEQUEST_DATE,'' as SELECTED FROM BD_SALES_ORDER_HEAD WHERE COMPLETED = 0";
SqlDataAdapter da=new SqlDataAdapter(ls_sql,cn);
DataSet ds = new DataSet();
da.Fill(ds,"webreturn");
dgList.DataSource=ds.Tables["webreturn"];
dgList.DataBind();
Button2.Attributes.Add("onclick","javascript:returnValue(this);");
Response.Write(dgList.Columns.Count);上面有个笔误,,,这个就是全的了呀.
uing System.data.SqlClient;
namespace hysm
{
/// <summary>
/// yytd 的摘要说明。
/// </summary>
public class yytd : System.Web.UI.Page
{
// 然后在着个里面加入
System.data.SqlClient.sqlConnection l;
}
private void Page_Load(object sender, System.EventArgs e)
{
li=new SqlConnection("你的数据库连接串 ");
SqlDataAdapter sql=new SqlDataAdapter(select * from 表名,li);
dataSet x=new dataSet()
sql.fill(x,"表名");
DataGrid1.DataSource=x.Tables["表名"]
DataGrid1.DataBind();
}