各位朋友,小弟刚刚从VB过度到C#,面对新的开发环境,觉得一切都变的好陌生,所以这里有个问题希望朋友们能给点主意,小第就是想知道,VB里面用ADO连接数据库,我已经掌握,可是在C#里,怎么想在VB中用ADO,连接数据库呢?
例如,在VB中要连接数据裤时,我通常会用以下代码:
dim SystemConnas new adodb.Connection Set SystemConn = New ADODB.Connection
strConn = "Provider=SQLOLEDB.1;Password=fang;Persist Security Info=True;User ID=sa;Initial Catalog=Test;Data Source=prrj021"
SystemConn.CursorLocation = adUseClient
SystemConn.ConnectionTimeout = 5
SystemConn.ConnectionString = strConn
SystemConn.Open
用来打开数据库连接,那么在C#中该怎么打开数据库连接呢?各位C#的朋友能推荐我个群吗?
例如,在VB中要连接数据裤时,我通常会用以下代码:
dim SystemConnas new adodb.Connection Set SystemConn = New ADODB.Connection
strConn = "Provider=SQLOLEDB.1;Password=fang;Persist Security Info=True;User ID=sa;Initial Catalog=Test;Data Source=prrj021"
SystemConn.CursorLocation = adUseClient
SystemConn.ConnectionTimeout = 5
SystemConn.ConnectionString = strConn
SystemConn.Open
用来打开数据库连接,那么在C#中该怎么打开数据库连接呢?各位C#的朋友能推荐我个群吗?
{
string mySelectQuery = "SELECT * FROM Categories ORDER BY CategoryID";
string myConnectString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer";
SqlConnection myConnection = new SqlConnection(myConnectString);
SqlCommand myCommand = new SqlCommand(mySelectQuery,myConnection);
myCommand.CommandTimeout = 15;
myCommand.CommandType = CommandType.Text;
}
简单数据访问步骤:
1、创建Connection,Command以及DataReader对象。
2、利用DataRader从数据库检索信息并利用Web表单上的某个控件显示这些信息。
3.关闭连接。
4.把页面发送给用户。
读取示例:
SqlConnection objConn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnStr"]);
SqlCommand objCommand = new SqlCommand("select * from table1 where id="+idNum,objConn);
objConn.Open();
SqlDataReader dr = objCommand.ExecuteReader(); //可绑定读取的数据相应控件
//this.listbox1.DataSource=objCommand.ExecuteReader(); dr.Read(); //读取第1行
string addName1=dr["addName"].ToString();
dr.Read(); //读取第2行
string addName2=dr["addName"].ToString(); //可通过如下方法循环获得:
while (dr.Read())
{
addName=dr["addName"].ToString();
} dr.Close();
objConn.Close();
http://shop34017187.taobao.com/