String strConnection = "server=ws-sps; database=Northwind; user id=sa;password=waxf";
SqlConnection objConnection = new SqlConnection(strConnection); String strSQL = "SELECT FirstName, LastName, Country " + "FROM Employees";
SqlCommand objCommand = new SqlCommand(strSQL, objConnection); objConnection.Open();
dgNameList.DataSource = objCommand.ExecuteReader();
dgNameList.DataBind();
objConnection.Close();
SqlConnection objConnection = new SqlConnection(strConnection); String strSQL = "SELECT FirstName, LastName, Country " + "FROM Employees";
SqlCommand objCommand = new SqlCommand(strSQL, objConnection); objConnection.Open();
dgNameList.DataSource = objCommand.ExecuteReader();
dgNameList.DataBind();
objConnection.Close();
解决方案 »
- c#如何调用浏览器自动登录,或者如何把cookie传给浏览器访问网页?
- C#程序關閉 異常錯誤
- 如何读取Config文件的问题。
- 请问怎样新建一个方法,作用为清除控件的内容的呢? 急
- 请教一个获取窗体变量集合的问题?
- 急急急 链接问题,object 属性是哪个?
- 请问那位大侠知道“自定义控件”设置好属性然后保存到文件然后打开文件相应的属性还在是如何实现的?
- .NET Framework 中的 Generic 还真是这么回事,
- 一个KTV点歌系统, 怎么让查看歌曲列表一直无限地添加到播放列表呢
- log4net的问题,帮帮忙。
- 为什么这样写就不对呢?
- 如何单击在DataGrid中绑定的CheckBox时触发一个事件?
会弹出向导,不用你写一行代码的。如果你想看ide替你写了什么,去cs文件里找,正好学习如何连接
using System.Data;
using System.Data.SqlClient;
using System.Data.OracleClient ;
using System.Data.Odbc ;
using System.Windows.Forms;
using System.Collections;
using MSCommLib;
namespace DBCls
{
/// <summary>
/// MainClass 的摘要说明。
/// </summary>
public class DBCls
{
#if USINGPROJECTSYSTEM
//Sql server 2000
const string ConnectionString = "integrated security=SSPI;data source=zry;" +
"persist security info=False;initial catalog=lcfs";
//
#else
//Oracle 9i
const string strConn = "Data Source=Oracle9i;user id=lcfs;data source=lcfs;password=lcfs";
public static OracleConnection myCn;
public static OracleDataAdapter DataAdapter;
public static OracleCommand myCommand;
public static OracleTransaction myTrans;
public static OracleCommandBuilder CommandBuilder;
public static string UserName;
public static string UserCity;
public static string password;
public static string strgroup;
public static string[] Userzone;
#endif
public DBCls()
{
//
// TODO: 在此处添加构造函数逻辑
#if USINGPROJECTSYSTEM
//Sql server 2000
//
//////
#else
//Oracle 9i
myCn=new OracleConnection(strConn);
myCn.Open();
#endif
//
}
public static OracleDataAdapter SqlConn(string strSql)
{
DataAdapter=new OracleDataAdapter();
DataAdapter.SelectCommand =new OracleCommand (strSql,myCn);
myCommand=new OracleCommand (strSql,myCn);
CommandBuilder=new OracleCommandBuilder (DataAdapter);
return DataAdapter;
}
public void comtrans()
{
myCommand=myCn.CreateCommand();
myTrans = myCn.BeginTransaction();
myCommand.Transaction = myTrans;
}
// public DBCls(string strSql,OracleConnection connmyCn)
// {
// DataAdapter=new OracleDataAdapter();
// DataAdapter.SelectCommand =new OracleCommand (strSql,connmyCn);
// myCommand=new OracleCommand(strSql,connmyCn);
// CommandBuilder=new OracleCommandBuilder (DataAdapter);
//
// }
public static DataSet dbbind(string strSql,string strTab)
{
DataSet objDataSet= new DataSet() ;
SqlConn(strSql).Fill(objDataSet,strTab);
return objDataSet;
}
}
}
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.OracleClient ;
using System.Data.Odbc ;
using System.Windows.Forms;
using MSCommLib;
namespace lcrepeaterApp
{
/// <summary>
/// MainClass 的摘要说明。
/// </summary>
public class MainCls
{
public MainCls()
{
}
[STAThread]
public static void Main()
{
DBCls.DBCls db=new DBCls.DBCls();
BaseCls.CommonCls cc=new BaseCls.CommonCls();
frmLogin LoginWin=new frmLogin ();
Application.Run(LoginWin);
}
}
}