private void conn()
{
if (objconn == null)
objconn = new SqlConnection(sql);
if (objconn.State == ConnectionState.Closed)
objconn.Open();
}我的代码:
objconn = new SqlConnection(sql);
报这一行出错;
{
if (objconn == null)
objconn = new SqlConnection(sql);
if (objconn.State == ConnectionState.Closed)
objconn.Open();
}我的代码:
objconn = new SqlConnection(sql);
报这一行出错;
解决方案 »
- img显示图片的问题
- asp.net里的Flash问题
- 毕业设计
- 执行最后一句com.ExecuteNonQuery();报错,急《《《
- asp.net 如何读取pdf文件,并将其转换成二进制,存到数据库中。(vs2005 asp.net !)
- 关于DataGrid控件更新数据库
- LinkButton控件:如何不产生或替换掉服务器端事件
- 我现在做一个新闻系统,到网上载了一个网页在线编辑器(HtmlEditor3.1_Dem)现想把他插入我的新闻系统里面需要哪些步骤?
- reportview 读取服务器报表时报错
- datalist中的在同一个组中的radiobutton能够实现单选点击,但是后代取不到值,求解决。。
- odbcdatareader 读出来的数据无法转换!
- 谁有C#的UBB转换函数,有的话发给我一下
不过我改了,还是这个错误 啊,这是怎么回事?String strconn=ConfigurationSettings.AppSettings["conn"];private void Conn()
{
if (objconn == null)
objconn = new SqlConnection(strconn);
if (objconn.State == ConnectionState.Closed)
objconn.Open();
}
连接数据库字符串我写在webconfig里了。conn就是
{
if (objconn == null)
{
objconn = new SqlConnection(strconn);
objconn.Open();}
if (objconn.State == ConnectionState.Closed)
objconn.Open();
}
//定义全局变量
String strconn=ConfigurationSettings.AppSettings["conn"];
String sql = "select * from class order by id desc";
SqlConnection objconn;
String Table="table"; protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.RadioButtonList sex;
protected System.Web.UI.HtmlControls.HtmlTable Table1;
protected System.Web.UI.WebControls.DataGrid showclass;
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
LoadGrid();
}
}
//绑定DataGrid的函数
private void LoadGrid()
{
Conn();
SqlDataAdapter adapter = new SqlDataAdapter(sql,objconn);
DataSet ds = new DataSet();
adapter.Fill(ds,Table);
disconn(); showclass.DataSource=ds.Tables[Table];
showclass.DataBind();
}
//连接数据库函数
private void Conn()
{
if (objconn == null)
objconn = new SqlConnection(strconn);
objconn.Open();
if (objconn.State == ConnectionState.Closed)
objconn.Open();
} //conn对像关闭函数
private void disconn()
{
objconn.Close();
}还是那行错误,