我使用以下代码让 GridView控件连接数据库,数据应该是连接上了,就是显示不出结果,求高人指导!!
string Constr = @"Data Source=.\SQLEXPRESS;" + @"AttachDbFilename=C:\Users\Administrator\sql\zml.mdf;"+ "Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection conn = new SqlConnection(Constr);
string Sqlstr = "select * from account";
SqlDataAdapter ada = new SqlDataAdapter(Sqlstr, conn);
conn.Open();
DataSet ds = new DataSet();
ada.Fill(ds, "tableshow");
GridView1.DataSource = ds.Tables["tableshow"].DefaultView;
GridView1.DataBind();
conn.Close();
string Constr = @"Data Source=.\SQLEXPRESS;" + @"AttachDbFilename=C:\Users\Administrator\sql\zml.mdf;"+ "Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection conn = new SqlConnection(Constr);
string Sqlstr = "select * from account";
SqlDataAdapter ada = new SqlDataAdapter(Sqlstr, conn);
conn.Open();
DataSet ds = new DataSet();
ada.Fill(ds, "tableshow");
GridView1.DataSource = ds.Tables["tableshow"].DefaultView;
GridView1.DataBind();
conn.Close();
GridView1.DataSource = ds.Tables["tableshow"].DefaultView;
你的"tableshow"是什么意思
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
EnableModelValidation="True" Height="174px"
Width="300px">
</asp:GridView>
改为True