感谢您使用微软产品。关于在C#中使用ADO的方法和示例,您可以参考以下文章和例子:
HOW TO: Open ADO Connection and RecordSet Objects in Visual C# .NET (Q308611)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308611
- 微软全球技术中心 VB技术支持本贴子以“现状”提供且没有任何担保,同时也没有授予任何权利。具体事项可参见使用条款(http://support.microsoft.com/directory/worldwide/zh-cn/community/terms_chs.asp)。为了为您创建更好的讨论环境,请参加我们的用户满意度调查(http://support.microsoft.com/directory/worldwide/zh-cn/community/survey.asp?key=(S,49854782))。
HOW TO: Open ADO Connection and RecordSet Objects in Visual C# .NET (Q308611)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308611
- 微软全球技术中心 VB技术支持本贴子以“现状”提供且没有任何担保,同时也没有授予任何权利。具体事项可参见使用条款(http://support.microsoft.com/directory/worldwide/zh-cn/community/terms_chs.asp)。为了为您创建更好的讨论环境,请参加我们的用户满意度调查(http://support.microsoft.com/directory/worldwide/zh-cn/community/survey.asp?key=(S,49854782))。
______ __________ ______________ _______
1.sql
(1)利用控件(amoo提供)
SqlConnection con=new SqlConnection(this.sqlConnection1.ConnectionString); SqlDataAdapter Dgb=new SqlDataAdapter("Select * From Address",con);
DataSet ds=new DataSet();
Dgb.Fill(ds,"Address");
dataGrid1.DataSource=ds.Tables["Address"].DefaultView; (2)SqlServer连本地数据库(Tcat提供)
SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Trusted_Connection=yes");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "Titles");
MyRepeater.DataSource = ds.Tables["Titles"].DefaultView;
MyRepeater.DataBind();
(3)SqlServer连服务器绑定DataGrid连接(Tcat提供)
SqlConnection myConnection;
myConnection = new SqlConnection (" user id=mmas;password=mmas;initial catalog=MMAS;data source=MMASS;Connect Timeout=30");
myConnection.Open ();
string strSel="select * from bas_item ";
SqlDataAdapter myAdapter= new SqlDataAdapter (strSel,myConnection);
DataSet ds=new DataSet ();
myAdapter.Fill (ds,"bas_item");
DataGrid1.DataSource =ds.Tables ["bas_item"].DefaultView;
DataGrid1.DataBind ();
________________________________________________________________________
2。oracle
(1)连接(amoo提供)
class OracleTest
{
static void Main()
{
const string strConn = "PROVIDER=OraOLEDB.Oracle;DATA SOURCE=YourDataSrcName;USER ID=YourUID;PASSWORD=YourPassword;PLSQLRSet=1";
const string strSQL = "Select * From YourTable";
try
{ OleDbConnection dbConn = new OleDbConnection(strConn);
DataSet ds = new DataSet("EmployeesSet");
OleDbDataAdapter da = new OleDbDataAdapter(strSQL,dbConn);
da.Fill(ds,"Buyer");
Console.WriteLine(ds.GetXml());
}
catch(OleDbException e)
{
Console.WriteLine("Exception Occured :{0}",e.Errors[0].Message);
} }
}
______________________________________________________________________
3 Access连接(Tcat提供)
string MyConnString="provider=Microsoft.Jet.OLEDB.4.0;Data Source=d://demo//db1.mdb";// "+Server.MapPath("db1.mdb")+"";
MyConn= new OleDbConnection(MyConnString);
MyConn.Open();
string strSel = "select * from u";
DataSet ds = new DataSet();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"u");
DataGrid2.DataSource = ds.Tables ["u"].DefaultView
DataGrid2.DataBind();
______________________________________________________
4(bkss提供)
ODBC:
MyConnString =
"DRIVER={SQL Server};SERVER=MyServer;"+
"UID=sa;PWD=MyPassWord;DATABASE=pubs;";
________________________________________________________
5 (iyiduhsoad提供)
目前在c#里两个连接类:SqlConnection与OleDbConnection.
两个类的例程分别如下:(from msdn)
1.OleDbConnection:
public void InsertRow(string myConnectionString)
{
// If the connection string is null, use a default.
if(myConnectionString == "")
{
myConnectionString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Northwind;" +
"Integrated Security=SSPI;";
}
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
string myInsertQuery = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')";
OleDbCommand myCommand = new OleDbCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
}
2.SqlConnection:
public void InsertRow(string myConnectionString)
{
// If the connection string is null, use a default.
if(myConnectionString == "")
{
myConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
}
SqlConnection myConnection = new SqlConnection(myConnectionString);
string myInsertQuery = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')";
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
}
(eken提供)
//C#
//--insert data
DataRow anyRow = DatasetName.Tablename.NewRow();
anyRow.FirstName = "Jay";
anyRow.LastName = "Stevens";
Tablename.Rows.Add(anyRow);// ---delete
Dataset.tablename.Rows[0].Delete();//--edit
workRow.BeginEdit();
workRow[0] = "sdfsdf";
workRow.EndEdit();
//connect
SqlConnection con=new SqlConnection(this.sqlConnection1.ConnectionString); SqlDataAdapter Dgb=new SqlDataAdapter("Select * From Address",con);
DataSet ds=new DataSet();
Dgb.Fill(ds,"Address"); dataGrid1.DataSource=ds.Tables["Address"].DefaultView;
DataTable dt=ds.Tables[0];
// set zhujian
dt.Columns["ID"].AutoIncrement=true; //edit
dt.Rows[0]["name"]="aaa";
//del
dt.Rows[dt.Rows.Count-2].Delete();
//add
DataRow add=dt.NewRow();
add["name"]="nining";
add["tel"]="123";
dt.Rows.Add(add);SQL: /// <summary>
/// 增、删、改记录
/// </summary>
/// <param name="strSQL">SQL语句(增、删或改记录)</param>
/// <returns>是否成功bool</returns> public bool AddDelAlterRecord(string strSQL)
{
SqlConnection CN;
CN = new SqlConnection(Config.ConnectionString);
CN.Open();
bool Victory = false;
string sSQL = strSQL;
SqlCommand Cmd = new SqlCommand(sSQL,CN);
try
{
Cmd.ExecuteNonQuery();
Victory = true;
}
catch (Exception e)
{
Victory = false;
throw e;
}
finally
{
if (CN.State == ConnectionState.Open)
CN.Close(); return Victory;
}
}