这个太简单了,写个方法就ok了 public void Bind() { SqlConnection con = new SqlConnection("连接字符串"); con.open(); SqlDataAdapter da = new SqlDataAdapter("select * from table",con); DataSet ds = new DataSet(); da.fill(ds,"table"); DataGrid1.DataSource = ds.Tables["table"]; DataGrid1.DataBind(); } 然后再Page_Load()或者其他的事件中去调用就OK了 然后就结贴了
OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); OleDbCommand comm = new OleDbCommand(strSQL,conn); dg.DataSource = comm.ExecuteReader(); conn.Close(); }
.........//连接数据库 string strSql = "SELECT * FROM [tablename]"; OleDbDataAdapter da = new OleDbDataAdapter(strSql, mc ); DataSet ds = new DataSet( ); dg.DataSource = ds.Tables["tablename"];
public void Bind()
{
SqlConnection con = new SqlConnection("连接字符串");
con.open();
SqlDataAdapter da = new SqlDataAdapter("select * from table",con);
DataSet ds = new DataSet();
da.fill(ds,"table");
DataGrid1.DataSource = ds.Tables["table"];
DataGrid1.DataBind();
}
然后再Page_Load()或者其他的事件中去调用就OK了
然后就结贴了
{
string strConn = "Provider=Microsoft.Jet.OleDb.4.0;data source=" + System.Configuration.ConfigurationSettings.AppSettings["Path"];
string strSQL = "select * from user";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open(); OleDbCommand comm = new OleDbCommand(strSQL,conn);
dg.DataSource = comm.ExecuteReader();
conn.Close();
}
string strSql = "SELECT * FROM [tablename]";
OleDbDataAdapter da = new OleDbDataAdapter(strSql, mc );
DataSet ds = new DataSet( );
dg.DataSource = ds.Tables["tablename"];
DataSet ds=new DataSet();
SqlDataAdapter adapter =new SqlDataAdapter(“sql语句”, myConnection);
adapter.Fill(ds, "数据库表名");
MyDataGrid.DataSource = ds.Tables["数据库表名"].DefaultView;
MyDataGrid.DataBind();如果是WINFORM的话:
MyDataGrid.DataSource = ds.Tables["数据库表名"];(一句就够了)
private DataSet ExecuteDataSet(
string commandText)
{
return ExecuteDataSet(commandText, CommandType.Text, (SqlParameter[])null);
}
DataTable idDt =ExecuteDataSet(idSql).Tables[0];
dg.DataSoure = idDt;
嘿嘿,我就爱回答你的问题,分少点也没关系.