看一个SQL语句

[昵称写在沙滩上被海浪带走了]

select *from invoiceserver where ISID in(53,54)

上面这个SQL语句查询到的值怎样用table显示出来？

用GridView没反应啊

[细嗅蔷薇]

你先把你的sql 语句在查询分析器里面运行 看能查出数据不。
然后就是贴代码

[昵称写在沙滩上被海浪带走了]

sql语句没问题，你要看哪里的代码，前台：
<asp:GridView ID="invoiceServerGridView" runat="server" AutoGenerateColumns="False"
onselectedindexchanged="invoiceServerGridView_SelectedIndexChanged">
<Columns>
<asp:TemplateField HeaderText="id">
<ItemTemplate>
<asp:Label ID="lblID" runat="server" Text='<%# Bind("id") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="IServer">
<ItemTemplate>
<asp:Label ID="lblIServer" runat="server" Text='<%# Bind("IServer") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Taxed">
<ItemTemplate>
<asp:Label ID="lblTaxed" runat="server" Text='<%# Bind("Taxed") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="amount">
<ItemTemplate>
<asp:Label ID="lblamount" runat="server" Text='<%# Bind("amount") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

[天下如山]

select * from invoiceserver where ISID in(53,54)

简单的就是 往你的页面拖一个GridView控件
然后在后台写上绑定方法(在这个里面 连接数据库 执行SQL 读取数据 绑定gridview)
运行页面

[昵称写在沙滩上被海浪带走了]

后台：
string isid = tinvoice.Rows[0]["isid"].ToString();
string invoiceServer = BInvoice.GetInvoiceServers("isid in (" + isid, out tinvoiceServer);
if (!string.IsNullOrEmpty(invoiceServer))
{
Response.Write("<script>alert('" + @invoiceServer.Replace("'", "") + "');</script>");
return;
}
else
{
invoiceServerGridView.DataBind();
invoiceServerGridView.DataSource = tinvoiceServer;
}

[昵称写在沙滩上被海浪带走了]

SQL：
public static string GetInvoiceServers(string where, out DataTable dt)
{
dt = null;
string error = "";
string strSql = "select * from invoiceserver ";
if (!string.IsNullOrEmpty(where))
strSql += " where " + where + ")";

try
{
dt = SqlHelperSql.ExecuteDataSet(strSql).Tables[0];
}
catch (Exception e)
{
error = e.Message;
}
return error;
}

[天殇月痕]

SqlConnection con = new SqlConnection(myConnStr);
con.Open();
string sql = select *from invoiceserver where ISID in(53,54)
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);

GridView1.DataSource = ds;
GridView1.DataBind();
类似这样不行吗？？？？？

[昵称写在沙滩上被海浪带走了]

string invoiceServer = BInvoice.GetInvoiceServers("isid in (" + isid, out tinvoiceServer);

这里得到一个table然后
invoiceServerGridView.DataBind();
invoiceServerGridView.DataSource = tinvoiceServer;绑定

[昵称写在沙滩上被海浪带走了]

[Quote=引用 6 楼 的回复:]

SqlConnection con = new SqlConnection(myConnStr);
con.Open();
string sql = select *from invoiceserver where ISID in(53,54)
SqlCommand cmd = new SqlC……
[/Quote]

用的3层

[woainiqh1111]

想知道，你现在是否已经得到有数据的 DataTable,得到以后如果一不会bind给GridView 看看书吧。

[jun471537173]

  invoiceServerGridView.DataBind();
  invoiceServerGridView.DataSource = tinvoiceServer;

换下顺序。。。

[写个昵称都这么麻烦]

我晕了、楼主、真F了你了

先DataSource 再DataBind（） 知道么、擦

[zjh_c_s_d_n]

先为控件指定数据源，再绑定到控件上，像6楼那样

[昵称写在沙滩上被海浪带走了]

哦，原来还有顺序的，呵呵 新手，谢谢啦

[cliu_beijing]

正解，，，

invoiceServerGridView.DataSource = tinvoiceServer;
invoiceServerGridView.DataBind();


[Quote=引用 10 楼 的回复:]
C# code

invoiceServerGridView.DataBind();
invoiceServerGridView.DataSource = tinvoiceServer;

换下顺序。。。
[/Quote]