subject_14665.htm

一些关于vc的问答

<p>
序号：14665 发表者：cer 发表日期：2002-09-10 12:03:56
<br>主题：ASP.NET中能在客户端打开SQL库吗?怎样打开?
<br>内容：ASP.NET中能在客户端打开SQL库吗?怎样打开?
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
回复者：雷神 回复日期：2002-09-10 13:52:29
<br>内容：通过ADO或者ADO.NET。
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：cer 回复日期：2002-09-10 14:56:02
<br>内容：通过ado.net的具体程序有吗?<BR> Dim ssql As String<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim constr As String<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim bdate As Date<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim edate As Date<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim i As Integer<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim j As Integer<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim gconn As SqlConnection = New SqlConnection("server=localhost;database=OASYS;uid=sa;password=sa") <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim MyDataset As New DataSet()<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim cmd As New SqlCommand() ' OleDbCommand()<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim dbAdapter As New SqlDataAdapter() '&nbsp;&nbsp;OleDbDataAdapter()<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;' OpenDataFunction("OASYS")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cmd.CommandType = CommandType.Text<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cmd.Connection = gconn<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbAdapter.SelectCommand = cmd<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ssql = "select * from addrossbook"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cmd.CommandText = ssql<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbAdapter.Fill(MyDataset, "newupdate")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i = MyDataset.Tables("newupdate").Rows.Count<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;labrowcont.Text = i<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gconn.Close()<BR>是这样子?<BR>New SqlConnection("server=localhost;database=OASYS;uid=sa;password=sa") <BR>部分,能有其它的写法吗?<BR>如:ConnectionString=ConfigurationSettings.AppSettings("ConnString")<BR>这个"ConnString"是什么意思?
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：雷神 回复日期：2002-09-10 15:25:00
<br>内容：ConnString是连接字符串.他是在web.config中进行设定的.<BR>形式如下:<BR><BR>&nbsp;&nbsp;&lt;appSettings&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;add key="ConnString" value="server=localhost;database=NorthWind;User Id=sa;pwd="/&gt;<BR>&nbsp;&nbsp;&lt;/appSettings&gt;<BR><BR>你可以用这样的方法获得它,<BR>&nbsp;&nbsp;ConnectionString=ConfigurationSettings.AppSettings("ConnString")<BR>这样做的好处是你可以很方便的改变你的数据库连接<BR><BR>2002-9-10 15:26:30