由于工作需要,要用到VS2005中的GridView控件。用的是sybase数据库。
于是用了asp1.1的数据绑定方法和GridView来做。结果能正常运行但无法显示读出的表。不知道怎么回事。请教大家 谢谢~。另请教用asp2.0的sqldatasouce和GridView 怎么实现。
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Sybase.Data.AseClient;
using Sybase.Data;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
AseConnection ac = new AseConnection("Server=192.168.10.188;Port=5500;User=doctor;Password=sybase;Database=doctor");
ac.Open();
AseDataAdapter ada = new AseDataAdapter();
AseCommand cmd = new AseCommand("select * from std_sex_code", ac);
ada.SelectCommand = cmd;
ada.Fill(ds);
this.GridView1.DataSource = ds.Tables[0];
ac.Close();
}
catch
{
Response.Write("错");
}
于是用了asp1.1的数据绑定方法和GridView来做。结果能正常运行但无法显示读出的表。不知道怎么回事。请教大家 谢谢~。另请教用asp2.0的sqldatasouce和GridView 怎么实现。
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Sybase.Data.AseClient;
using Sybase.Data;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
AseConnection ac = new AseConnection("Server=192.168.10.188;Port=5500;User=doctor;Password=sybase;Database=doctor");
ac.Open();
AseDataAdapter ada = new AseDataAdapter();
AseCommand cmd = new AseCommand("select * from std_sex_code", ac);
ada.SelectCommand = cmd;
ada.Fill(ds);
this.GridView1.DataSource = ds.Tables[0];
ac.Close();
}
catch
{
Response.Write("错");
}
this.GridView1.DataBind();//增加这一句看看
加一句this.GridView1.DataBind();
在VS2005中asp2.0的sqldatasouce链接表的时候会自动绑定每个字段。