public partial class Ex09_03 : System.Web.UI.Page
{
protected SqlConnection myConnection = new SqlConnection();
private void BindData()
{
string selCmd = "select * from Ex09_GuestBook where(ParentID=0) order by PostTime DESC";
SqlDataAdapter da = new SqlDataAdapter(selCmd, myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "word");
DataGrid1.DataSource = ds.Tables["word"].DefaultView;
DataGrid1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session.Count == 0)
{
Response.Redirect("Ex09_01.aspx");
}
else if (!IsPostBack)
{
Label1.Text = "欢迎" + Session["username"].ToString();
string strConn = "server=Localhost;uid=sa;pwd=sa;database=Aspnet";
myConnection.ConnectionString = strConn;
BindData();
} } protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
BindData();
}
}
在 da.Fill(ds, "word")这行报错ConnectionString 属性尚未初始化。
{
protected SqlConnection myConnection = new SqlConnection();
private void BindData()
{
string selCmd = "select * from Ex09_GuestBook where(ParentID=0) order by PostTime DESC";
SqlDataAdapter da = new SqlDataAdapter(selCmd, myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "word");
DataGrid1.DataSource = ds.Tables["word"].DefaultView;
DataGrid1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session.Count == 0)
{
Response.Redirect("Ex09_01.aspx");
}
else if (!IsPostBack)
{
Label1.Text = "欢迎" + Session["username"].ToString();
string strConn = "server=Localhost;uid=sa;pwd=sa;database=Aspnet";
myConnection.ConnectionString = strConn;
BindData();
} } protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
BindData();
}
}
在 da.Fill(ds, "word")这行报错ConnectionString 属性尚未初始化。
解决方案 »
- 求教:有一个Student类,从SQLSERVER数据库中读取多个值包括名字班级等等
- 格式化时间
- GridView如何实现多选
- FontStyle.Bold和checkBox1.Checked这样的如果定义变量该怎么定义呢?
- 如何合并datagridview的单元格?
- 这个简单程序调试怎么通不过呢
- c# 可以获取鼠标在屏幕上的文本吗??就像金山取词,能识别当前鼠标所指的文本
- 客户端程序报错:“Oracle.DataAccess.Client.OracleConnection”的类型初始值设定项引发异常!
- 用c#编写dll时,如何调试?
- 我是新手。想了解一下。c# vb.net asp.net
- 一个数字类型转换为char类型的疑问
- 如何自己写程序实现类似.net中的“.”的功能
{
if (Session.Count == 0)
{
Response.Redirect("Ex09_01.aspx");
}
else if (!IsPostBack)
{
Label1.Text = "欢迎" + Session["username"].ToString();
string strConn = "server=Localhost;uid=sa;pwd=sa;database=Aspnet";
myConnection.ConnectionString = strConn;
BindData();
}如果我是第一次访问这个页面 连接字符串没赋值给连接对象
我建议你实例化对象的时候把连接字符串给连接对象
protected SqlConnection myConnection = new SqlConnection("server=Localhost;uid=sa;pwd=sa;database=Aspnet");