程序如下:div id="mainbody">
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1" RepeatColumns="4">
</asp:DataList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:mydatabaseConnectionString %>"
SelectCommand="SELECT [name] FROM [ctg2]"></asp:SqlDataSource>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
</div>
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1" RepeatColumns="4">
</asp:DataList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:mydatabaseConnectionString %>"
SelectCommand="SELECT [name] FROM [ctg2]"></asp:SqlDataSource>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
</div>
SqlConnection myconn = new SqlConnection("Server=localhost;Database=mydatabase");
try
{
myconn.Open();
string sql = "select * from ctg2";
SqlCommand mycomm= new SqlCommand (sql);
mycomm.ExecuteNonQuery();
myconn.Close();
}
catch (Exception )
{
}
太郁闷了!
{
myconn.Open();
string sql = "select * from ctg2";
SqlCommand mycomm= new SqlCommand (sql);
mycomm.ExecuteNonQuery();
myconn.Close();
}
只是执行了一下sql语句 并没有返回任何数据集
{
myconn.Open();
string sql = "select * from ctg2";
datatable dt=new datatable();
sqlDataAdapter adapter=new sqldataadapter(sql,myconn);
adapter.fill(dt);
messagebox.show(dt.rows.count.tostring());
this.gridview.datasource=dt;
myconn.Close();
}
catch (Exception )
{
}
{
myconn.Open();
string sql = "select * from ctg2";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, myconn);
da.Fill(ds,"ctg2");
GridView1.DataSource = ds.Tables["ctg2"];
GridView1.DataBind();
myconn.Close();
}
catch (Exception )
{
}这是我根据上面的提示修改的程序
但是,还是显示不了
真奇怪
你说的显示模板是什么呢?
.................
</ItemTemplate>没这个,你怎么显示数据?显示到哪里?