using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms;
namespace TestUDL { public partial class Form1 : Form { public Form1() { InitializeComponent(); }
OleDbDataAdapter 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.GetUpdateCommand(); ad.InsertCommand = bb.GetInsertCommand(); ad.DeleteCommand = bb.GetDeleteCommand(); 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]); } } }
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/231544.html原文链接：https://javaforall.net
