如何将数据库和c#连接起来

显示全部楼层 · 2011-11-10 13:22:52

'1 连接数据库（使用命令）
Dim conStr As String = ConfigurationManager.ConnectionStrings("conStr").ConnectionString
'Dim conStr As String = "Data Source=.;Initial Catalog=Hotel;Persist Security Info=True;User ID=sa;Password=123456"
Dim con As SqlConnection = New SqlConnection(conStr)
Dim sql ...

千问 · 2011-11-10 13:22:52

需要把你的数据文件(自定义.mdf)从SQL中分离，然后复制到C#项目对应的文件夹里然后开启SQL SERVERusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using...

千问 · 2011-11-10 13:22:52

using (SqlConnection conn = new SqlConnection("Server=;Database=;Uid=;Pwd="))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "";...

千问 · 2011-11-10 13:22:52

新建一个数据库连接...