使用DataGrid即可。string strSQL = 查询语句SQL;
myConn=new SqlConnection(ConnString);
myConn.Open();
SqlDataAdapter myDataAdapter = new SqlDataAdapter(strSQL , myConn);
DataSet ds = new DataSet();
myDataAdapter.Fill(ds);
DataView Source =ds.Tables[0].DefaultView;
myDataGrid.DataSource=Source;
myDataGrid.DataBind();
myConn=new SqlConnection(ConnString);
myConn.Open();
SqlDataAdapter myDataAdapter = new SqlDataAdapter(strSQL , myConn);
DataSet ds = new DataSet();
myDataAdapter.Fill(ds);
DataView Source =ds.Tables[0].DefaultView;
myDataGrid.DataSource=Source;
myDataGrid.DataBind();
解决方案 »
- Dataset中 如何实现模糊查询 着急ing
- 文件下载中,所有会话被挂起,直到文件下载完成
- 如何让网页显示在指定的Frame中?
- vs2005有一个调试模式的问题
- MappingException:Unknown entity class:Provider.User
- ASP.NET中,C#代码嵌套在html代码中的问题...
- 大家发现了吗,blog出问题了?
- 有谁做过datagrid的层次结构?
- 请问如何用ASP.NET打印出SQL数据库的学生信息?
- 我的Visual Studio.NET创建ASP.NET应用程序
- 老问题不能解决
- 求助:公司要做网站想申请个固定IP和域名,请问向谁去申请啊?
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="VB" runat="server"> Sub GetAuthors_Click(Sender As Object, E As EventArgs) Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter Dim SelectCommand As String = "select * from Authors where state = @State" MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter(SelectCommand, MyConnection) MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@State", SqlDbType.NVarChar, 2))
MyCommand.SelectCommand.Parameters("@State").Value = MySelect.Value DS = new DataSet()
MyCommand.Fill(DS, "作者") MyDataGrid.DataSource=DS.Tables("作者").DefaultView
MyDataGrid.DataBind()
End Sub</script><body style="font: 10.5pt 宋体"> <form runat="server"> <h3><font face="宋体">对 DataGrid 控件的参数化选择</font></h3> 选择州: <select id="MySelect" runat="server">
<option>CA</option>
<option>IN</option>
<option>KS</option>
<option>MD</option>
<option>MI</option>
<option>OR</option>
<option>TN</option>
<option>UT</option>
</select> <input type="submit" OnServerClick="GetAuthors_Click" Value="获取作者" runat="server"/><p> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/> </form></body>
</html>
public SqlDataReader ExecuteReader(string varsql)
{
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand cmd = new SqlCommand(varsql,conn);
SqlDataReader myrd=cmd.ExecuteReader();
return myrd;
}
public int ExecuteNonQuery(string varsql)
{
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand cmd = new SqlCommand(varsql,conn);
int rows=cmd.ExecuteNonQuery();
return rows;
}
public DataSet DataAdapter(string varsql,string vartable)
{
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter(varsql,conn);
DataSet ds = new DataSet();
cmd.Fill(ds,vartable);
return ds;
}
'Put user code to initialize the page here Dim MyConnection As SqlConnection = New SqlConnection(Application("ConnectionString"))
MyConnection.Open()
Dim MyCommand As SqlDataAdapter = New SqlDataAdapter("select * from operator", MyConnection)
Dim ds As DataSet
ds = New DataSet
MyCommand.Fill(ds, "operator")
DataGrid1.DataSource = ds.Tables("operator").DefaultView
DataGrid1.DataBind()
MyConnection.Close()
End Sub
End Classhi,朋友们上面的代码哪里有错?怎么运行的时候提示:END SUB这句有错小菜虫