C#中如何连接数据库,知道的朋友请解决下! ?????????????????????????????C#中如何连接数据库,知道的朋友请解决下! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <connectionStrings > <add name="connectionSql" connectionString="Data Source=(loca);Initial Catalog=Test;User ID=sa;password=" /> </connectionStrings> ConfigurationManager.AppSettings["connectionSql"];http://topic.csdn.net/u/20091116/09/cb08d357-45a2-4324-8163-3b1fa3ba473f.html <appSettings> <add key="dqw" value="Data Source=.;Initial Catalog=dqw;uid=sa;pwd=123"/> </appSettings>dqw是数据库名, http://topic.csdn.net/u/20091116/09/cb08d357-45a2-4324-8163-3b1fa3ba473f.html如梦收藏的帖就是多啊 配置文件:<connectionStrings > <add name="connectionSql" connectionString="Data Source=(loca);Initial Catalog=Test;User ID=sa;password=" /> </connectionStrings> DBHelper:private string connString = ConfigurationManager.connectionStrings["connectionSql"].ToString(); private static string connString = "Data Source=.;Initial Catalog="";User ID=sa;Pwd=sa"; public static SqlConnection connection = new SqlConnection(connString); <connectionStrings > <add name="connectionSql" connectionString="Data Source=(loca);Initial Catalog=Test;User ID=sa;password=" /> </connectionStrings> ConfigurationManager.AppSettings["connectionSql"]; connectionSql 就是你的数据库名字,就可以啦 使用ADO.NET的连接数据库对象如果是SQL数据库使用System.Data.SqlClinet.SqlConnection con=new System.Data.SqlClinet.SqlConnection("server=.;database=Mydata;uid=sa;pwd=sa");con.open(); 首先添加引用using System.Data.OleDb;然后就可以写代码了 如下OleDbConnection conn = new OleDbConnection();conn.ConnectionString = @"provider=microsoft.jet.oledb.4.0;data source=G:\大二课程\Win.Form\第八周\mydb.mdb";conn.Open(); SqlConnection conn = new SqlConnection(@"Server = (local)\sqlexpress; User = sa; PWD = sa;" +Database = "northwind");conn.open();其中:(local)\sqlexpress是你的服务器信息,,User和PWD就不说了或者改成 Integrated Security = True; 表示使用登陆集成。 先在你的窗体里拉一个dataGridView1 直接复制一下我的代码就行了 string connecttionString="Data Source=.;Initial Catalog=abc;Persist Security Info=True;User ID=sa;Password=123456"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from abc where ID="+在这里写要查询的ID; DataSet ds = new DataSet(); using (SqlConnection conn = new SqlConnection(connecttionString)) { cmd.Connection = conn; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds); } DataTable table = ds.Tables; dataGridView1.DataSource=table ; 如果是Bs就是Web里加上这个dataGridView1.DataBind(); 否则不用的 sa登入:data source=服务器名;initial catalog=数据库名;user id=用户名(sa);pwd=密码windows登入:data source=服务器名;initial catalog=数据库名;Integrated Security=True SqlConnection myConnection=new SqlConnection();myConnection.ConnectionString="server=localhost;uid=sa;pwd=**;database="**";//输入你的密码和数据库名myConnection.Open();或者SqlConnection myConnection=new SqlConnection();myConnection.ConnectionString="Integrated Security=SSPI;Initial Catalog="**";//输入你的数据库 也可以用webservice 技术来连服务器数据库 C#编程问题 C# 中comboBox选中的问题 关于datatime类型数据的问题 C#基本問題 请问我的问题到底出在哪里?(将一个文件写入数据库) 在C#中调用C++ 动态库传入回调函数指针的问题,请大家帮忙! 菜单项 Visual 2003的.net framework1.1装不上了 能不能提供一些下载自由软件的网站。 C#和.NET中的原型克隆[zt] RichTextBox的排列问题,高手帮忙! C # return
<add name="connectionSql" connectionString="Data Source=(loca);Initial Catalog=Test;User ID=sa;password=" />
</connectionStrings>
ConfigurationManager.AppSettings["connectionSql"];http://topic.csdn.net/u/20091116/09/cb08d357-45a2-4324-8163-3b1fa3ba473f.html
<add key="dqw" value="Data Source=.;Initial Catalog=dqw;uid=sa;pwd=123"/>
</appSettings>dqw是数据库名,
如梦收藏的帖就是多啊
<connectionStrings >
<add name="connectionSql" connectionString="Data Source=(loca);Initial Catalog=Test;User ID=sa;password=" />
</connectionStrings>
DBHelper:private string connString = ConfigurationManager.connectionStrings["connectionSql"].ToString();
public static SqlConnection connection = new SqlConnection(connString);
<add name="connectionSql" connectionString="Data Source=(loca);Initial Catalog=Test;User ID=sa;password=" />
</connectionStrings>
ConfigurationManager.AppSettings["connectionSql"]; connectionSql 就是你的数据库名字,就可以啦
如果是SQL数据库使用
System.Data.SqlClinet.SqlConnection con=new System.Data.SqlClinet.SqlConnection("server=.;database=Mydata;uid=sa;pwd=sa");
con.open();
然后就可以写代码了 如下
OleDbConnection conn = new OleDbConnection();conn.ConnectionString = @"provider=microsoft.jet.oledb.4.0;data source=G:\大二课程\Win.Form\第八周\mydb.mdb";conn.Open();
string connecttionString="Data Source=.;Initial Catalog=abc;Persist Security Info=True;User ID=sa;Password=123456";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from abc where ID="+在这里写要查询的ID; DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(connecttionString))
{
cmd.Connection = conn; SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd; adapter.Fill(ds);
}
DataTable table = ds.Tables;
dataGridView1.DataSource=table ; 如果是Bs就是Web里加上这个dataGridView1.DataBind();
否则不用的
windows登入:data source=服务器名;initial catalog=数据库名;Integrated Security=True
myConnection.ConnectionString="server=localhost;uid=sa;pwd=**;database="**";//输入你的密码和数据库名
myConnection.Open();
或者
SqlConnection myConnection=new SqlConnection();
myConnection.ConnectionString="Integrated Security=SSPI;Initial Catalog="**";//输入你的数据库