能否给个简单的asp.net连接mssql 的例子,不要用控件
我烦控件,像asp一样,比如select后记录放到mystr里,我随时应用.
[解决办法]
string mystr = " "; //使用StringBuilder会更好
string sqlConnectionString = "Data Source=; Initial Catalog=; Integrated Security=SSPI "; //windows安全认证
SqlConnection conn = new SqlConnection(sqlConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand( "Select * from [table] ", conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
mystr += (string)dr[filed];
}
dr.Close();
conn.Close();
Response.Write(myStr);
[解决办法]
寫成一個class，傳參數進來，就可以隨意調用了！~~~
[解决办法]
先顶.
[解决办法]
//建立连接
SqlConnection con=new SqlConnection( "server=.;database=vote;uid=sa;pwd=; ");
con.open();
string sqr=( "select * from vote ");
SqlCommand cmd=new SqlCommand(sqr,con);
SqlDataReader sdr=cmd.ExecuteReader;
while(sdr.Reader())
{
Response.Write( "+sdr.GetString(0)+ "- "+sdr.GetInt32(1).ToString()+ ");//接受数据库中列的值
}
sdr.close();
con.close();
[解决办法]
转自：http://www.cnblogs.com/yelsea/archive/2007/06/21/792314.html
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
// 创建数据库文件
File.Delete( "test1.db3 ");
SQLiteConnection.CreateFile( "test1.db3 ");
DbProviderFactory factory = SQLiteFactory.Instance;
using (DbConnection conn = factory.CreateConnection())
{
// 连接数据库
conn.ConnectionString = "Data Source=test1.db3 ";
conn.Open();
// 创建数据表
string sql = "create table [test1] ([id] INTEGER PRIMARY KEY, [s] TEXT COLLATE NOCASE) ";
DbCommand cmd = conn.CreateCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
// 添加参数
cmd.Parameters.Add(cmd.CreateParameter());
// 开始计时
Stopwatch watch = new Stopwatch();
watch.Start();
// 连续插入1000条记录
for (int i = 0; i < 1000; i++)
{
cmd.CommandText = "insert into [test1] ([s]) values (?) ";
cmd.Parameters[0].Value = i.ToString();
cmd.ExecuteNonQuery();
}
// 停止计时
watch.Stop();
Console.WriteLine(watch.Elapsed);
}
哎~~~~ 一个常识性的错误，我加几行代码 (新增代码标记 "// <------------------- ")。
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
// 创建数据库文件
File.Delete( "test1.db3 ");
SQLiteConnection.CreateFile( "test1.db3 ");
DbProviderFactory factory = SQLiteFactory.Instance;
using (DbConnection conn = factory.CreateConnection())
{
// 连接数据库
conn.ConnectionString = "Data Source=test1.db3 ";
conn.Open();
// 创建数据表
string sql = "create table [test1] ([id] INTEGER PRIMARY KEY, [s] TEXT COLLATE NOCASE) ";
DbCommand cmd = conn.CreateCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
// 添加参数
cmd.Parameters.Add(cmd.CreateParameter());
// 开始计时
Stopwatch watch = new Stopwatch();
watch.Start();
DbTransaction trans = conn.BeginTransaction(); // <-------------------
try
{
// 连续插入1000条记录
for (int i = 0; i < 1000; i++)
{
cmd.CommandText = "insert into [test1] ([s]) values (?) ";
cmd.Parameters[0].Value = i.ToString();
cmd.ExecuteNonQuery();
}
trans.Commit(); // <-------------------
}
catch
{
trans.Rollback(); // <-------------------
throw; // <-------------------
}
// 停止计时
watch.Stop();
Console.WriteLine(watch.Elapsed);
}
[解决办法]
string connectionString = "Data Source=.; Initial Catalog=Northwind; Integrated Security=SSPI "; // Windows 认证
//string connectionString = "Data Source=.; Initial Catalog=Northwind; User ID=sa; Password=911119 "; // SQL 混合验证
string sql = "SELECT * FROM Products ";
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(sql, connectionString()); // 由 DataAdapter 自己管理连接
da.Fill(dt); // 读取数据
[解决办法]
写在类里面的
public class LinkDataBase
{
private string strSQL;
//与SQL Server的连接字符串设置
private string connectionString = "server=(local);uid=sa;pwd=;database=JwglSql ";
//与数据库的连接
private SqlConnection myConnection;
//private SqlCommandBuilder sqlCmdBld;
private DataSet ds = new DataSet();
private SqlDataAdapter da;
public LinkDataBase()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
///////////////////////////////// 操作脱机数据库(创建了该类的实例时直接用) /////////////////////////////////////////////////////
public DataSet SelectDataBase(string tempStrSQL,string tempTableName)
{
this.strSQL = tempStrSQL;
this.myConnection = new SqlConnection(connectionString);
this.da = new SqlDataAdapter(this.strSQL,this.myConnection);
this.ds.Clear();
this.da.Fill(ds,tempTableName);
return ds;//返回填充了数据的DataSet，其中数据表以tempTableName给出的字符串命名
}
//
}
在窗体里面调用 连接数据库函数
//*************************************************实例化连接数据库类************************************************
public void str_DataBase()
{
LinkDataBase link = new LinkDataBase();
this.ds = link.SelectDataBase(SqlStr,sendTableName);
}
定义变量并给变量赋值 调用实例化连接数据库方法 str_DataBase()就可以要你要的数据了，要的数据根据你的SQL语句来控制
sendTableName= "教师表 ";
SqlStr= "SELECT * from 教师表 ";
selectTeacherName();
