sql dataGrid连接数据库
————————————————————————————
using System.Data.SqlClient;namespace sqlconnect3
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private System.Data.SqlClient.SqlCommand s qlSelectCommand1;
private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null; public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent(); //
// TODO: Add any constructor code after InitializeComponent call
//
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;
}
————————————————————————————
using System.Data.SqlClient;namespace sqlconnect3
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private System.Data.SqlClient.SqlCommand s qlSelectCommand1;
private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null; public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent(); //
// TODO: Add any constructor code after InitializeComponent call
//
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;
}
解决方案 »
- App.Config文件中的add
- button事件
- 怎样用C#编译exe文件,在未装.NET架构的机器上也能运行?
- 水晶报表问题
- 一个跟反射有关的问题,初学.NET,还不是很熟练,希望高手赐教,来者有分!(急)
- WAVECOM 发短信 急急急!(在线等...)
- 能不能用c#程序实现向手机发送短信息?有源码发到我邮箱谢了
- DBNull的替换函数
- 请问用用drawstring函数绘制文本时,如果在指定区域内做到文本两端对齐啊?
- winform调用java接口。使用安全证书 ssl
- 请问学习C#,是不是先学习JAVA会学起来简单点? (高手告诉我的~) 请问高高手是不是啊?
- 如何让treeview中的节点双击以后变得可编辑?
——————————————————————————————
using System;
using System.Data;
using System.Data.OleDb;
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);
} }
}
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();
2:SqlServer连服务器绑定DataGrid连接
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 ();
3:Access连接
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();
MyConnString =
"DRIVER={SQL Server};SERVER=MyServer;"+
"UID=sa;PWD=MyPassWord;DATABASE=pubs;";
两个类的例程分别如下:(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();
}
注:
SqlConnection针对于Sql server 7.0及以后版本。
OleDbConnection用于其他数据库。
至于myConnectinString里的provider参数,针对不同的数据源有:
(1)driver da microsoft para arquivos textto(*.txt,*.csv)--50分
(2)driver do microsoft access(*.mdb)--50分
(3)driver do microsoft dbase(*.dbf)--50分
(4)driver do microsoft execl(*.xls)--50分
(5)driver do microsoft paradox(*.db)--50分
(6)Microsoft Access Driver(*.mdb)--50分
(7)Microsoft Access -treiber(*.mdb)-50分
(8)Microsoft Excel driver(*.xls)--50分
............
分是不是不够了???
just a joke.参阅ODBC数据源配置的drivers,OLEDB可不是光
能连接数据库的数据呀,呵呵。不过都没用过,惭愧,目前
使用的是SqlConnection mySqlConnection=new SqlConnection("database=mydatabasename;server=myservername;user id=sa;pwd=";)
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);
//--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();