private void Button1_Click(object sender, System.EventArgs e)
{
SqlConnection myconnect=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["myconnectionstring"]);
SqlCommand cmd=new SqlCommand("select top 10 * from test10K",myconnect);
//SqlDataAdapter adapter=new SqlDataAdapter(cmd.CommandText,myconnect);
SqlDataAdapter adapter=new SqlDataAdapter();
adapter.SelectCommand=cmd;
DataSet data1=new DataSet();
DataGrid datagrid1=new DataGrid();
try
{
myconnect.Open(); //Response.Write(myconnect.State.ToString());
adapter.Fill(data1);
//Response.Write("2");
datagrid1.DataSource=data1;
datagrid1.DataBind();
//Response.Write("3");
}
catch(Exception ex)
{
Response.Write(ex.Message);
} finally
{myconnect.Close();
data1.Clear();
} }
}
以上都能通過,就是顯示不了datagrid1和相應的數據
{
SqlConnection myconnect=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["myconnectionstring"]);
SqlCommand cmd=new SqlCommand("select top 10 * from test10K",myconnect);
//SqlDataAdapter adapter=new SqlDataAdapter(cmd.CommandText,myconnect);
SqlDataAdapter adapter=new SqlDataAdapter();
adapter.SelectCommand=cmd;
DataSet data1=new DataSet();
DataGrid datagrid1=new DataGrid();
try
{
myconnect.Open(); //Response.Write(myconnect.State.ToString());
adapter.Fill(data1);
//Response.Write("2");
datagrid1.DataSource=data1;
datagrid1.DataBind();
//Response.Write("3");
}
catch(Exception ex)
{
Response.Write(ex.Message);
} finally
{myconnect.Close();
data1.Clear();
} }
}
以上都能通過,就是顯示不了datagrid1和相應的數據
好像要绑定到表的吧
data1.Tables[0]
??????
public ICollection CreateSource(string sqlstr,string dTable)
{
SqlConnection myConn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["myconnectionstring"]);
DataSet ds=new DataSet ();
myAdapter=new SqlDataAdapter (sqlstr,myConn);
myAdapter.Fill (ds,dTable);
return ds.Tables [dTable].DefaultView ;
}
#endregion
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!Page.IsPostBack)
{
DG.DataSource= db.CreateSource ("select top 10 * from test10K","test10K");
DG.DataBind ();
}
}DATAGRID里面的各个列等等样式就自己定义一下啦
終於明白了,原因是我沒定義好DataGrid的位置(也就是說我隻分配了空間,去沒把它顯示出來