如何在C#中连接数据库SQL 本人编程经验不足,对编程方面有很多疑问,我不知道如何在C#和C++中连接SQL数据库以及使用数据库,不知道用到那些函数。希望高手可以赐教一二!!1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看下工具栏里的“数据”里的几个控件,sqlConnection就是了 string source="user id=sa;password=;initial catalog=bank;data source=2-116"; SqlConnection conn=new SqlConnection(source);conn.Open();initial catalog 数据库名;data source 服务器名 连接字符串,以在配置文件中写法为例,string onnectionString="Data Source=127.0.0.1;Initial Catalog=NingboEmsErp;Integrated Security=True";举例如下string str ="server=workflow;uid=sa;pwd=workflow123;database=Northwind";data source=192.192.132.41;initial catalog=h2000_pre;uid=h2000;pwd=h2000;<?xml version="1.0" encoding="utf-8" ?><configuration> <configSections> </configSections> <connectionStrings> <add name="H2KEntry.Data.Properties.Settings.H2000AssistConnectionString" connectionString="Data Source=192.192.132.53;Initial Catalog=H2000Assist;Persist Security Info=True;User ID=sa;Password=jinguan?53" providerName="System.Data.SqlClient" /> <add name="H2KEntry.Data.Properties.Settings.H2000_PREConnectionString" connectionString="Data Source=192.192.132.53;Initial Catalog=H2000_PRE;Persist Security Info=True;User ID=sa;Password=jinguan?53" providerName="System.Data.SqlClient" /> </connectionStrings></configuration>connectionString="Data Source=NBEPORT-ZZ;Initial Catalog=NingboEmsErp;Integrated Security=True"Web.config for an ASP.NET Web application: <configuration> <appSettings> <add key="DBConnStr" value="server=(local);Integrated Security=SSPI;database=northwind"/> </appSettings></configuration>string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Jet OLEDB:Database Password=forever04;Data Source="+Environment.CurrentDirectory+"\\data\\data.mdb"; 在C#中的实现例子看,http://blog.csdn.net/zhzuo/archive/2004/07/03/33273.aspxhttp://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspxhttp://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx透过vs.net数据窗体向导看Ado.nethttp://blog.csdn.net/zhzuo/archive/2005/01/03/238273.aspx 直接调用SQL命令using System.Data;using System.Data.SqlClient;string source="user id=sa;password=;initial catalog=bank;data source=2-116"; SqlConnection conn=new SqlConnection(source);//打开连接conn.Open();//关闭连接conn.close();//释放资源conn.dispose(); 回调事件,请求方法与概念的理解. 引用Excel库的版本问题 如何实现流输出图片文件时,实现动态的GIF效果 文字排版 研究过示例duwamish(C#)的请进来 程序退出后,托盘上的图标仍在,但当鼠标移到托盘上时,图标才消失? 为什么我的水晶报表不能动态显示 请问哪位晓得在自定义控件中实现像CompareValidator控件中的ControlToCompare属性一样的属性. 如何把RichTextBox的内容保存到数据库?? c#中form窗体第二次打开时保持第一次打开时的位置和数据信息 关于C#接口编程的一个疑问 按记录数量多少为记录排序,然后再从大到小取出记录的算法
SqlConnection conn=new SqlConnection(source);
conn.Open();
initial catalog 数据库名;data source 服务器名
举例如下
string str ="server=workflow;uid=sa;pwd=workflow123;database=Northwind";
data source=192.192.132.41;initial catalog=h2000_pre;uid=h2000;pwd=h2000;<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="H2KEntry.Data.Properties.Settings.H2000AssistConnectionString"
connectionString="Data Source=192.192.132.53;Initial Catalog=H2000Assist;Persist Security Info=True;User ID=sa;Password=jinguan?53"
providerName="System.Data.SqlClient" />
<add name="H2KEntry.Data.Properties.Settings.H2000_PREConnectionString"
connectionString="Data Source=192.192.132.53;Initial Catalog=H2000_PRE;Persist Security Info=True;User ID=sa;Password=jinguan?53"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>connectionString="Data Source=NBEPORT-ZZ;Initial Catalog=NingboEmsErp;Integrated Security=True"
Web.config for an ASP.NET Web application: <configuration>
<appSettings>
<add key="DBConnStr" value="server=(local);Integrated Security=SSPI;database=northwind"/>
</appSettings>
</configuration>string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Jet OLEDB:Database Password=forever04;Data Source="+Environment.CurrentDirectory+"\\data\\data.mdb";
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx
透过vs.net数据窗体向导看Ado.net
http://blog.csdn.net/zhzuo/archive/2005/01/03/238273.aspx
using System.Data;
using System.Data.SqlClient;string source="user id=sa;password=;initial catalog=bank;data source=2-116";
SqlConnection conn=new SqlConnection(source);
//打开连接
conn.Open();//关闭连接
conn.close();
//释放资源
conn.dispose();