直接贴代码比较好说...
前台:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
ForeColor="#333333" GridLines="None">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="身份证号码" HeaderText="用户ID" ReadOnly="True" />
<asp:BoundField DataField="姓名" HeaderText="用户姓名" />
<asp:BoundField DataField="员工性别" HeaderText="性别" />
<asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />
<asp:CommandField HeaderText="选择" ShowSelectButton="True" />
<asp:CommandField HeaderText="编辑" ShowEditButton="True" />
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
</Columns>
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
</asp:GridView>后台:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
} }
protected SqlConnection createLoginConnect()
{
SqlConnection cnt = new SqlConnection("Data Source=WWW-2381342E102\\SOSO; Initial Catalog=WebSite; Integrated Security=True");
return cnt;
} public void bind()
{
SqlConnection con = this.createLoginConnect();
con.Open();
SqlDataAdapter myda = new SqlDataAdapter();
string sqlstr = "select * from 123";
SqlCommand com = new SqlCommand(sqlstr, con);
myda.SelectCommand = com;
DataSet myds = new DataSet();
myda.Fill(myds, "strtable"); // 这句出错???????
GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "id" };
GridView1.DataBind();
con.Close();
}各位大哥,帮忙看下,myda.Fill(myds, "strtable"); // 这句出错???????
前台:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
ForeColor="#333333" GridLines="None">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="身份证号码" HeaderText="用户ID" ReadOnly="True" />
<asp:BoundField DataField="姓名" HeaderText="用户姓名" />
<asp:BoundField DataField="员工性别" HeaderText="性别" />
<asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />
<asp:CommandField HeaderText="选择" ShowSelectButton="True" />
<asp:CommandField HeaderText="编辑" ShowEditButton="True" />
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
</Columns>
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
</asp:GridView>后台:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
} }
protected SqlConnection createLoginConnect()
{
SqlConnection cnt = new SqlConnection("Data Source=WWW-2381342E102\\SOSO; Initial Catalog=WebSite; Integrated Security=True");
return cnt;
} public void bind()
{
SqlConnection con = this.createLoginConnect();
con.Open();
SqlDataAdapter myda = new SqlDataAdapter();
string sqlstr = "select * from 123";
SqlCommand com = new SqlCommand(sqlstr, con);
myda.SelectCommand = com;
DataSet myds = new DataSet();
myda.Fill(myds, "strtable"); // 这句出错???????
GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "id" };
GridView1.DataBind();
con.Close();
}各位大哥,帮忙看下,myda.Fill(myds, "strtable"); // 这句出错???????
string sqlstr = "select * from [123]";
SqlDataAdapter myda = new SqlDataAdapter(sqlstr ,con);
con.Open();
DataSet myds = new DataSet();
myda.Fill(myds, "strtable");
con.Close();这样会出错吗?
string sqlstr = "select * from 123";
SqlCommand com = new SqlCommand(sqlstr, con);
myda.SelectCommand = com;
干嘛这么写呢,直接写
string sqlstr = "select * from 123";
SqlDataAdapter myda = new SqlDataAdapter(sqlstr,con);
建议用using,或者加try_catch,还是using吧。
con.Open();
try
{
SqlDataAdapter myda = new SqlDataAdapter("select * from 123",con);
DataSet ds=new DataSet();
myda.Fill(ds);
}
catch(Exception ex)
{
con.close();
}