社区
C#
帖子详情
关于SqlDataAdapter,SqlConnection,SqlCommand的用法,最好举例说明一个,再线等,急!!!!!!!!!!!!!!!!!
rain1983
2004-03-14 10:32:21
关于SqlDataAdapter,SqlConnection,SqlCommand的用法,最好举例说明一个,再线等,急!!!!!!!!!!!!!!!!!
...全文
578
12
打赏
收藏
关于SqlDataAdapter,SqlConnection,SqlCommand的用法,最好举例说明一个,再线等,急!!!!!!!!!!!!!!!!!
关于SqlDataAdapter,SqlConnection,SqlCommand的用法,最好举例说明一个,再线等,急!!!!!!!!!!!!!!!!!
复制链接
扫一扫
分享
转发到动态
举报
AI
作业
写回复
配置赞助广告
用AI写文章
12 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
calmhawkaaa
2004-03-14
打赏
举报
回复
可以直接将数据表 “拉”到工程里
系统自动生成 SqlConnnection1 SqlDataAdaper1
然后右键 SqlDataAdapter1 生成 dataSet1
在dataSet1 中配置 SqlCommand (insert delete update)
如果SqlServer 有密码 在“窗体设计器生成的代码”中将this.sqlConnection1.ConnectionString = "workstation id=CALMHAWK;packet size=4096;user id=sa;password=****;data source=ca" +
"lmhawk;persist security info=False;initial catalog=student";
加 password=****
popohei
2004-03-14
打赏
举报
回复
可以全部用控件完成
但SqlConnection可能会出错 要自己写Connecttion string
CommanSource
2004-03-14
打赏
举报
回复
QUICK START!
<script language="C#" runat="server">
void Page_Load(Object Src, EventArgs E ) {
String selectCmd;
String state = Request["state"];
if( state == null || !InputValidator.IsValidAnsiTwoCharacterState(state)) {
selectCmd = "select * from Authors";
}
else {
selectCmd = "select * from Authors where state = '" + state + "'";
}
SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated Security=SSPI");
SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd, myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");
MyDataGrid.DataSource=new DataView(ds.Tables[0]);
MyDataGrid.DataBind();
// capture the time of the current request
// subsequent requests that are cached will show the
// original time
TimeMsg.Text = DateTime.Now.ToString("G");
}
</script>
Firestone2003
2004-03-14
打赏
举报
回复
CSDN上有例子阿!
极限999
2004-03-14
打赏
举报
回复
http://www.csdn.net/develop/read_article.asp?id=23258
hertcloud
2004-03-14
打赏
举报
回复
油箱 给你 个列子!
zhpsam109
2004-03-14
打赏
举报
回复
向各位学习!
draclosta
2004-03-14
打赏
举报
回复
好好看看Data Access Application Block 概述吧
http://www.microsoft.com/china/msdn/library/dnbda/html/daab-rm.asp
caojingui
2004-03-14
打赏
举报
回复
用zhzuo(秋枫)老弟的例子吧
huangsuipeng
2004-03-14
打赏
举报
回复
UP
marvelstack
2004-03-14
打赏
举报
回复
using System;
using System.Data;
using System.Data.OleDb;
namespace ZZ.DAL
{
/// <summary>
/// AccessDbHelper 的摘要说明。
/// </summary>
public class AccessDbHelper
{
private static string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=GMS.mdb;Persist Security Info=False;";
/// <summary>
/// 获取单个值
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static object ExecuteScalar(string strSql)
{
object o = null;
OleDbConnection myConn = new OleDbConnection(strConn);
OleDbCommand myComm = new OleDbCommand(strSql,myConn);
try
{
myConn.Open();
o = myComm.ExecuteScalar();
}
catch(Exception e)
{
e.ToString();
}
finally
{
myConn.Close();
}
return o;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="strSql"></param>
public static int ExecuteNonQuery(string strSql)
{
int count = -1;
OleDbConnection myConn = new OleDbConnection(strConn);
OleDbCommand myComm = new OleDbCommand(strSql,myConn);
try
{
myConn.Open();
count = myComm.ExecuteNonQuery();
}
catch(Exception e)
{
e.ToString();
}
finally
{
myConn.Close();
}
return count;
}
/// <summary>
/// 获取数据读取器
/// </summary>
/// <param name="strSql"></param>
public static OleDbDataReader ExecuteReader(string strSql)
{
OleDbConnection myConn = new OleDbConnection(strConn);
OleDbCommand myComm = new OleDbCommand(strSql,myConn);
myConn.Open();
return myComm.ExecuteReader(CommandBehavior.CloseConnection);
}
/// <summary>
/// 获取数据集
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static DataSet ExecuteDataSet(string strSql)
{
DataSet ds = new DataSet();
OleDbConnection myConn = new OleDbConnection(strConn);
try
{
OleDbCommand myComm = new OleDbCommand(strSql,myConn);
OleDbDataAdapter myAda = new OleDbDataAdapter(myComm);
myAda.Fill(ds,"TableName");
}
catch(Exception e)
{
e.ToString();
ds = null;
}
finally
{
myConn.Dispose();
}
return ds;
}
}
}
zljblue
2004-03-14
打赏
举报
回复
SqlConnection mycon=new SqlConnection("server=服务器名;uid=用户名;pwd=密码;database=数据库名");
mycon.Open();
\\如果SQL语句是Select ...
SqlDataAdapter myda=new SqlDataAdapter(SQL语句,mycon);
myda.Fill(myset);
this.DataGrid1.DataSource=myset.Tables[0].DefaultView;
\\如果SQL语句是Delete、Update、Insert
SqlComman cmd=new SqlCommand();
cmd.CommandText=SQL语句;
cmd.CommandType=System.Data.CommandType.Text;
cmd.Connection=mycon;
cmd.ExcuteNoQuery();
mycon.Close();
C#数据库操作的三种经典
用法
.txt
C#数据库操作的三种经典
用法
.txtC#数据库操作的三种经典
用法
.txt
c#数据库操作的3种典型
用法
using System;using System.Collections.Generic;using System.Text;using System.
Data
;using System.
Data
.
Sql
Client; namespace
Data
baseOperate{ class
Sql
OperateInfo { //Suppose your ServerName is "aa",
Data
baseName is "bb",UserName is "cc", Password is "dd" private string
sql
Connection
Command = "
Data
Source=aa;Initial Catalog=bb;User ID=cc;Pwd=dd"; //This table contains two columns:KeywordID int not null,KeywordName varchar(100) not null private string
data
TableName = "Basic_Keyword_Test"; private string storedProcedureName = "Sp_InertToBasic_Keyword_Test"; private string
sql
SelectCommand = "Select KeywordID, KeywordName From Basic_Keyword_Test"; //
sql
UpdateCommand could contain "insert" , "delete" , "update" operate private string
sql
UpdateCommand = "Delete From Basic_Keyword_Test Where KeywordID = 1"; public void Use
Sql
Reader() {
Sql
Connection
sql
Connection
= new
Sql
Connection
(
sql
Connection
Command);
Sql
Command
sql
Command
= new
Sql
Command
();
sql
Command
.CommandType = System.
Data
.CommandType.Text;
sql
Command
.Connection =
sql
Connection
;
sql
Command
.CommandText =
sql
SelectCommand;
sql
Connection
.Open();
Sql
Data
Reader
sql
Data
Reader =
sql
Command
.ExecuteReader(); while(
sql
Data
Reader.Read()) { //Get KeywordID and KeywordName , You can do anything you like. Here I just output them. int keywordid = (int)
sql
Data
Reader[0]; //the same as: int keywordid = (int)
sql
Data
Reader["KeywordID"] string keywordName = (string)
sql
Data
Reader[1]; //the same as: string keywordName = (int)
sql
Data
Reader["KeywordName"] Console.WriteLine("KeywordID = " + keywordid + " , KeywordName = " + keywordName); }
sql
Data
Reader.Close();
sql
Command
.Dispose();
sql
Connection
.Close(); } public void Use
Sql
StoredProcedure() {
Sql
Connection
sql
Connection
= new
Sql
Connection
(
sql
Connection
Command);
Sql
Command
sql
Command
= new
Sql
Command
();
sql
Command
.CommandType = CommandType.StoredProcedure;
sql
Command
.Connection =
sql
Connection
;
sql
Command
.CommandText = storedProcedureName;
sql
Connection
.Open();
sql
Command
.ExecuteNonQuery(); //you can use reader here,too.as long as you modify the sp and let it like select * from ....
sql
Command
.Dispose();
sql
Connection
.Close(); } public void Use
Sql
Data
Set() {
Sql
Connection
sql
Connection
= new
Sql
Connection
(
sql
Connection
Command);
Sql
Command
sql
Command
= new
Sql
Command
();
sql
Command
.CommandType = System.
Data
.CommandType.Text;
sql
Command
.Connection =
sql
Connection
;
sql
Command
.CommandText =
sql
SelectCommand;
sql
Connection
.Open();
Sql
Data
Adapter
sql
Data
Adapter
= new
Sql
Data
Adapter
();
sql
Data
Adapter
.SelectCommand =
sql
Command
;
Data
Set
data
Set = new
Data
Set(); //
sql
Command
Builder is for update the
data
set to
data
base
Sql
Command
Builder
sql
Command
Builder = new
Sql
Command
Builder(
sql
Data
Adapter
);
sql
Data
Adapter
.Fill(
data
Set,
data
TableName); //Do something to
data
set then you can update it to
Data
base.Here I just add a row
Data
Row row =
data
Set.Tables[0].NewRow(); row[0] = 10000; row[1] = "new row";
data
Set.Tables[0].Rows.Add(row);
sql
Data
Adapter
.Update(
data
Set,
data
TableName);
sql
Command
.Dispose();
sql
Data
Adapter
.Dispose();
sql
Connection
.Close(); } }}
VB连接
SQL
实列(3) !!!!
本 实列 内 有多个文件夹 每个文件夹里面都有
一个
实列 你下载 了实列1,2,3就完整的 下载了 这些 实列~ 祝你们好运~~
sql
.zip_C#连接
sql
C# .net,连接
sql
server数据库,执行
sql
语句,存入
Data
Set
asp.net
Sql
Data
Adapter
对象使用札记
Sql
Data
Adapter
Sql
Connection
nwindConn = new
Sql
Connection
(“
Data
Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind”);
Sql
Command
selectCMD = new
Sql
Command
(“SELECT CustomerID, CompanyName FROM Customers”, nwindConn); selectCMD.CommandTimeout = 30;
Sql
Data
Adapter
custDA = new
Sql
Dat
C#
111,094
社区成员
642,554
社区内容
发帖
与我相关
我的任务
C#
.NET技术 C#
复制链接
扫一扫
分享
社区描述
.NET技术 C#
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
让您成为最强悍的C#开发者
试试用AI创作助手写篇文章吧
+ 用AI写文章