34,590
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
orcale 2004-01-02
- 打赏
- 举报
SqlConnection Conn=new SqlConnection("data source=jack;password=;persist security info=True;user id=sa;connect timeout=9600;initial catalog=manr");
zsh168 2004-01-02
- 打赏
- 举报
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
protected void Page_Load(Object Src, EventArgs E )
{
SqlConnection myConn = new SqlConnection("server=(local);uid=sa;pwd=;database=wellDB1");
//创建对象SqlConnection
string strSQL="SELECT * FROM wzlb_tbl";
SqlDataAdapter myCmd = new SqlDataAdapter(strSQL, myConn);
//创建对象SqlDataAdapter
DataSet ds = new DataSet();
//创建对象DataSet
myCmd.Fill(ds);
//填充数据到Dataset
DataView source = new DataView(ds.Tables[0]);
MyDataGrid.DataSource = source ;
MyDataGrid.DataBind();
//将数据绑定到DataGrid
}
</script>
<body>
<h3><font face="Verdana">Simple SELECT to a DataGrid Control
</font></h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="600"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
MaintainState="false"
/>
</body>
</html>
给你这里例子看看就明白了
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
protected void Page_Load(Object Src, EventArgs E )
{
SqlConnection myConn = new SqlConnection("server=(local);uid=sa;pwd=;database=wellDB1");
//创建对象SqlConnection
string strSQL="SELECT * FROM wzlb_tbl";
SqlDataAdapter myCmd = new SqlDataAdapter(strSQL, myConn);
//创建对象SqlDataAdapter
DataSet ds = new DataSet();
//创建对象DataSet
myCmd.Fill(ds);
//填充数据到Dataset
DataView source = new DataView(ds.Tables[0]);
MyDataGrid.DataSource = source ;
MyDataGrid.DataBind();
//将数据绑定到DataGrid
}
</script>
<body>
<h3><font face="Verdana">Simple SELECT to a DataGrid Control
</font></h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="600"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
MaintainState="false"
/>
</body>
</html>
给你这里例子看看就明白了
活靶子哥哥 2004-01-02
- 打赏
- 举报
http://www.csdn.net/Develop/read_article.asp?id=16437
jingxijun 2004-01-01
- 打赏
- 举报
比较简单的用visual studio 7中提供的SQL组件：SqlConnection，
拖放到窗口中，依照提示进行得了。
示例语句：
this.sqlConnection1.ConnectionString = "data source=localhost;initial catalog=eForum;persist security info=False;user id=sa;password='111111';workstation id=WT;packet size=4096";
