c#连接到sql

[liuxianhao]

如何用数据库图书管理系统连接到C#语句？
create table Reader
(Sno char(11) primary key,
Sname char(20),
Ssex char(5),
Sdept char(10),
Sold char(10),
Sjs char(10),
Swz char(10),
)

[风骑士之怒]

DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(ConnString))
{
SqlCommand cmd = new SqlCommand();
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.Connection = conn;
cmd.CommandText = "select * from Reader";
cmd.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
adapter.Fill(dt);
}

[子夜__]

 public static DataTable ReturnDataTable(string cmdtext)
    {
        SqlConnection cn = new SqlConnection();
        cn.ConnectionString = "数据库连接字符串";
        DataTable dt = new DataTable();
        SqlCommand cmd = new SqlCommand();
        cmd = new SqlCommand(cmdtext, cn);
        cmd.CommandType = CommandType.Text; ;
        SqlDataReader dr = null;
        using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
        {
            dt.Load(dr);
        }
        return dt;
    }

//调用
ReturnDataTable("select * from Reader");

[renyiqiu]

[Quote=引用 2 楼 wxr0323 的回复:]
C# code
public static DataTable ReturnDataTable(string cmdtext)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "数据库连接字符串";
DataTable dt = new DataTab……
[/Quote]
LS的正解，LZ解决问题了吧

[ycproc]

http://apps.hi.baidu.com/share/detail/14973865

自己做一个 DBHelp类

或者 网上随便下一下

[zhaowentao_bc]

网上通用类很多，但是楼主不要只管用，一定要看看他的实现过程，这样会有所进步

[lindiadia]

顶, 哈哈 我也是菜鸟 学习中

[.云哲.]

链接的数据，用vs，添加数据源里面测试连接。

[flyerwing]

[Quote=引用 2 楼 wxr0323 的回复:]
C# code
public static DataTable ReturnDataTable(string cmdtext)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "数据库连接字符串";
DataTable dt = new DataTab……
[/Quote]
连接其实也分很多种的

[Jdragon]

string connStr = GetConnStr();

using (SqlConnection conn = new SqlConnection(connStr))
{
SqlCommand comm = conn.CreateCommand();
comm.CommandText = comText;

if (param != null)
{
foreach (SqlParameter p in param)
{
comm.Parameters.Add(p);
}
}

try
{
conn.Open();
return comm.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}

finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}

[asfdsfdsadwae]

DBHelper找一下，到去都是

[郗晓勇]

怀疑是伪帖子

[only_lonely]

ado.net 如果LZ对此方面不甚熟悉的话，可以google一下。

[wangyan9110]

DataTable dt = new DataTable();
using(SqlConnection conn=new SqlConnection(connString))//connString是数据库连接字符串
{
   using(SqlCommand comm=conn.CreateCommand())
   {
         comm.CommandText="SQL语句";
          SqlDataAdapter adapter = new SqlDataAdapter();
          adapter.SelectCommand = comm;
           adapter.Fill(dt);
    }
}
return dt

[lihaiboit]

ado.net...

[wjhgzx]

要熟悉几个基本的对象，
connection，command，ConnectionString ，还有command的执行方法。熟悉他们之间的相互关系。
学着去调试。