ksni56z - 2008-6-1 17:41:00
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace xsw99
{
/// <summary>
/// showcourse 的摘要说明。
/// </summary>
public class showcourse : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
public string getrs;
public int bh;
public string km;
private void Page_Load(object sender, System.EventArgs e)
{
bind();
}
void bind()
{
SqlConnection conn=new SqlConnection("server=(local);uid=sa;pwd=0;database=新思维");
string sql="select top 10 * from kcb order by posttime desc";
SqlCommand cmd=new SqlCommand(sql,conn);
conn.Open();
DataGrid1.DataSource=cmd.ExecuteReader();
DataGrid1.DataBind();
conn.Close();
}
小弟刚学.net没多久 还请大家多多直教!
aspx1 - 2008-6-1 17:51:00
可能是你的数据库连接字符串有问题,conn对象为null
ksni56z - 2008-6-2 12:02:00
应该没有问题啊 因为之前我运行的没错误 怀疑是环境本身哪里的问题
gengyong1202 - 2008-6-6 8:56:00
SqlConnection conn=new SqlConnection("server=(local);uid=sa;pwd=0;database=新思维;");
加个分号
fsy123456 - 2008-6-13 17:30:00
SqlCommand cmd=new SqlCommand(sql,conn);
conn.Open();
这两句调换位置
conn.Open();
SqlCommand cmd=new SqlCommand(sql,conn);