<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web" %>
<script language="VB" runat="server">
Dim ObjConnection As SQLConnection
Sub Page_load(sender As Object, e As EventArgs)
Dim D as string ="user id=pp;password=pp;Initial Catalog=OA;Data Source="+ server MapPath("fdsf.mdf") +";Integrated Security=SSPI;"
Dim ObjConnection1 as SQLConnection = New SQLConnection(D)
End Sub这应该行了!你试试!
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web" %>
<script language="VB" runat="server">
Dim ObjConnection As SQLConnection
Sub Page_load(sender As Object, e As EventArgs)
Dim D as string ="user id=pp;password=pp;Initial Catalog=OA;Data Source="+ server MapPath("fdsf.mdf") +";Integrated Security=SSPI;"
Dim ObjConnection1 as SQLConnection = New SQLConnection(D)
End Sub这应该行了!你试试!
解决方案 »
- ASP.Net Web Service在win7 iis部署,出错
- 使用URLRewriter后,Cookie不能正常显示的问题
- 如何设置Datagrid的数据行高度?
- 大家好,问大家个问题
- 如何让多个checkbox的checked 状态置为为true,并选择checkbox的text内容
- 如何绑定两个字段到DataTextField
- 一个批量转表的问题~~~请大侠们赐教~~~~
- ASP.NET 的 Profile 没有类似 Membership.GetUser 方法,管理员在后台无法管理别人的 Profile?
- 高分求购难题!
- 如何在Label中输出%号呢?
- 紧急求助:"添加项目"里没有"Crystal Reprot"项
- 求教关于SESSION失效的问题
using System.Data;
using System.Data.SqlClient;string dsn = "server=localhost;uid=sa;pwd=;database=northwind";
SqlConnection database = new SqlConnection(dsn);
string sqlstring="select *.....";
SqlDataAdapter sda = new SqlDataAdapter(sqlstring,database);
DataSet mydata = new DataSet();
sda.Fill(mydata);DataGrid1.DataSource = mydata;
DataGrid1.DataBind();
Dim MyCommand as SqlDataAdaPter= new SqlDataAdapter(strSql,ObjConnection)
MyDataSet= new DataSet()
MyCommand.Fill(MyDataSet, "myTable")
public DataSet GetDataSet(string sConn,string strSql)
{
/** 参数说明
string sConn,连接字符串(如 "data source=test;initial catalog=db;user id=asd;password=asd";)
string strSql //SQL 语句 (如 "SELECT * FROM t_User where cUserName='UserName'")
*/
SqlConnection myConnection = new SqlConnection(sConn);
SqlDataAdapter myAdapter = new SqlDataAdapter(); myConnection.Open();
SqlCommand myCommand = new SqlCommand(strSql,myConnection);
myCommand.CommandType = CommandType.Text;
myAdapter.SelectCommand = myCommand;
DataSet ds = new DataSet();
myAdapter.Fill(ds);
myConnection.Close();
return ds;
}