using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Data.SqlClient; using System.Drawing; 便宜美国vps using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms;
namespace TestUDL { ??? public partial class Form1 : Form ??? { ??????? public Form1() ??????? { ??????????? InitializeComponent(); ??????? }
<plmdlq ad; ??????? DataSet ds; ??????? public void fanfa() { ??????????? //string connectString = "Data Source=localhost;Initial Catalog=MytestDB;Integrated Security=SSPI"; ??????????? //SqlConnection sqlConnect = new SqlConnection(connectString); ??????????? string connectString = @"File Name=D:\VS2015Programming\MyTest\TestUDL\TextFile1.udl;"; ??????????? OleDbConnection conn = new OleDbConnection(connectString); ??????????? conn.Open(); ??????????? OleDbCommand sqlCommand = conn.CreateCommand(); ??????????? string sqlCommandText = "SELECT [ID],[Name] FROM[MytestDB].[dbo].[PersonTable]"; ??????????? sqlCommand.CommandText = sqlCommandText; ??????????? //OleDbDataReader sqlDataReader = sqlCommand.ExecuteReader(); ??????????? ad = new OleDbDataAdapter(sqlCommand); ??????????? OleDbCommandBuilder bb = new OleDbCommandBuilder(ad); ??????????? ad.UpdateCommand = bb.大力的咖啡(); ??????????? ad.InsertCommand = bb.爱笑的高山(); ??????????? ad.DeleteCommand = bb.yydkj(); ???????????? ds = new DataSet(); ??????????? ad.Fill(ds); ??????? } ??????? private void button1_Click(object sender, EventArgs e) ??????? { ??????????? string connectString = "Data Source=localhost;Initial Catalog=MytestDB;Integrated Security=SSPI"; ??????????? SqlConnection sqlConnect = new SqlConnection(connectString); ??????????? //string connectString = @"File Name=D:\VS2015Programming\MyTest\TestUDL\TextFile1.udl;"; ??????????? //OleDbConnection conn = new OleDbConnection(connectString); ??????????? //conn.Open(); ??????????? //OleDbCommand sqlCommand = conn.CreateCommand(); ??????????? //string sqlCommandText = "SELECT [ID],[Name] FROM[MytestDB].[dbo].[PersonTable]"; ??????????? //sqlCommand.CommandText = sqlCommandText; ??????????? OleDbDataReader sqlDataReader = sqlCommand.ExecuteReader(); ??????????? //OleDbDataAdapter ad = new OleDbDataAdapter(sqlCommand); ??????????? //DataSet ds = new DataSet(); ??????????? //ad.Fill(ds); ??????????? fanfa(); ??????????? this.dataGridView1.DataSource = ds.Tables[0]; ??????? }
??????? private void button2_Click(object sender, EventArgs e) ??????? { ??????????? DataTableCollection ss = ds.Tables; ??????????? //ds.Tables[0].Rows[5].RowState = DataRowState.Added; ??????????? this.ad.Update(ds.Tables[0]); ??????? } ??? } }
<pzzdqz载于:https://www.cnblogs.com/1175429393wljblog/p/6868309.html
39918294
