ASP.net(vb)怎么连接SQL数据库

Question

ASP.net(vb)怎么连接SQL数据库

Answer 1

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="au_id"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="au_id" HeaderText="au_id" ReadOnly="True" SortExpression="au_id" />
<asp:BoundField DataField="au_lname" HeaderText="au_lname" SortExpression="au_lname" />
<asp:BoundField DataField="au_fname" HeaderText="au_fname" SortExpression="au_fname" />
<asp:BoundField DataField="phone" HeaderText="phone" SortExpression="phone" />
<asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
<asp:BoundField DataField="city" HeaderText="city" SortExpression="city" />
<asp:BoundField DataField="state" HeaderText="state" SortExpression="state" />
<asp:BoundField DataField="zip" HeaderText="zip" SortExpression="zip" />
<asp:CheckBoxField DataField="contract" HeaderText="contract" SortExpression="contract" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=WJS;Initial Catalog=pubs;User ID=sa"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [authors]"></asp:SqlDataSource>

Answer 2

public class DataInfo
{
SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=;database=pubs;");
SqlDataAdapter da = new SqlDataAdapter();
public SqlDataReader Reader(string str)
{
con.Open();
SqlCommand cmd = new SqlCommand(str,con);
return cmd.ExecuteReader();
}

public void data(string str,DataSet ds)//返回数据集
{
con.Open();
da = new SqlDataAdapter(str,con);
da.Fill(ds);
}
}