C# 访问 sql Delphi oledb 数据库

最新推荐文章于 2024-09-05 13:41:49 发布

林尧彬

最新推荐文章于 2024-09-05 13:41:49 发布

阅读量114

点赞数

文章标签：数据库 c#

原文链接：http://www.cnblogs.com/weioxwei/archive/2013/02/26/2933230.html

版权

this.constr1.Text = "Provider=SQLOLEDB;Data Source=10.0.8.6;Initial Catalog=toolrepair;User ID=sa;Pass" +
"word=2R00T@KF*TE;Auto Translate=false";

private void button1_Click(object sender, EventArgs e) { DataTable delphiTable = GetOleDbDataTable(search1.Text, "delphiTable", constr1.Text);

SqlCommand l_com = new SqlCommand("select * from " + tablename2.Text, new SqlConnection(constr2.Text)); SqlDataAdapter l_da = new SqlDataAdapter(l_com); SqlCommandBuilder l_sb = new SqlCommandBuilder(l_da); DataTable l_dtbl_struct = new DataTable(); l_da.Fill(l_dtbl_struct); DataRow newRow; foreach (DataRow dr in delphiTable.Rows) { newRow = l_dtbl_struct.NewRow(); foreach (DataColumn l_dc in l_dtbl_struct.Columns) { if (delphiTable.Columns.Contains(l_dc.ColumnName)) newRow[l_dc.ColumnName] = dr[l_dc.ColumnName]; } l_dtbl_struct.Rows.Add(newRow); } l_da.Update(l_dtbl_struct);//搜索Rowsate的狀態并執行 }

public DataTable GetOleDbDataTable(string pi_strSql, string pi_strTableName, string pi_strCnn) { DataTable l_dtbl_return = new DataTable("return"); OleDbConnection l_conn = new OleDbConnection(pi_strCnn); try { if (l_conn.State == ConnectionState.Closed) l_conn.Open(); OleDbDataAdapter l_da = new OleDbDataAdapter(pi_strSql, l_conn); l_da.Fill(l_dtbl_return); } finally { l_conn.Close(); } return l_dtbl_return; }

转载于:https://www.cnblogs.com/weioxwei/archive/2013/02/26/2933230.html