前台用到了ObjectDataSource控件,然后后台是连接数据库然后查询记录。希望在前台显示出来。始终报一个错,是'ObjectDataSource1' could not be found.到底是哪里出了问题。<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1" Width="100%">
<Columns>
<asp:BoundField DataField="username" />
<asp:BoundField DataField="password" />
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" TypeName="Default" SelectMethod="GetAllData">
</asp:ObjectDataSource>
public class UserDB
{
public UserDB()
{
}
//下面这个方法是从用户表中得到所有的数据
public static DataSet GetAllData()
{
string connectionString = ConfigurationManager.ConnectionStrings["DbmsConnectionString"].ConnectionString;
SqlConnection dbConnection = new SqlConnection(connectionString);
string queryString = "select * from user";
/*
SqlCommand dbCommand = new SqlCommand();
dbCommand.Connection = dbConnection;
dbCommand.CommandType = CommandType.Text;
dbCommand.CommandText = queryString;
*/
SqlDataAdapter dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand=new SqlCommand(queryString,dbConnection); DataSet ds = new DataSet(); dataAdapter.Fill(ds); return ds;
}
}
<Columns>
<asp:BoundField DataField="username" />
<asp:BoundField DataField="password" />
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" TypeName="Default" SelectMethod="GetAllData">
</asp:ObjectDataSource>
public class UserDB
{
public UserDB()
{
}
//下面这个方法是从用户表中得到所有的数据
public static DataSet GetAllData()
{
string connectionString = ConfigurationManager.ConnectionStrings["DbmsConnectionString"].ConnectionString;
SqlConnection dbConnection = new SqlConnection(connectionString);
string queryString = "select * from user";
/*
SqlCommand dbCommand = new SqlCommand();
dbCommand.Connection = dbConnection;
dbCommand.CommandType = CommandType.Text;
dbCommand.CommandText = queryString;
*/
SqlDataAdapter dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand=new SqlCommand(queryString,dbConnection); DataSet ds = new DataSet(); dataAdapter.Fill(ds); return ds;
}
}
解决方案 »
- 求修改优化
- sql 语句问题……
- SqlCommand.ExecuteNonQuery()返回值的问题
- if语句中的局部变量如何用出来
- 为什么在页面刷新的时候,css样式,也就消失了!
- 急啊`!!!!!!!
- [VB]小问题:如何从绑定的Repeater中获得某个字段的内容?
- 在线等救命,都两天了!保存到数据库出错!!
- 模态子窗口关闭时怎么触发父窗口中的一个按钮的点击事件?
- 在asp.net中,我用window.open()的开一个登陆页login.aspx,宽为340,高为340的窗口;???急!高分相送!
- 收集.NET面试题目中,来者有分,送完为止!
- Request.InputStream 有没有长度限制?
到底是什么问题。
...这段代码放在哪里的?