62,073
社区成员
发帖
与我相关
我的任务
分享
public DataSet GetDateSet(string strSql)
{
OracleConnection myConn = GetOracleConnection();
OracleDataAdapter adap = new OracleDataAdapter(strSql, myConn);
try
{
DataSet myDS = new DataSet();
adap.Fill(myDS);
return myDS;
}
catch (Exception ex)
{
string error = ex.Message;
return null;
}
finally
{
myConn.Close();
adap.Dispose();
}
}
#endregion
SqlDataAdapter da1 = new SqlDataAdapter("select * from Oil", "Data Source=192.168.1.120,11433;Initial Catalog=NERP_VTS;Persist Security Info=True;User ID=sa;PassWord=asiatek;");
DataSet ds1 = new DataSet();
da1.Fill(ds1, "v_hr_ats_employee");
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
conn.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(sql语句或存储过程或试图, conn);
DataSet ds = new DataSet();
dbAdapter.Fill(ds, "表名");
string sql1="select * from 你的视图名字";
SqlDataAdapter da1 = new SqlDataAdapter(sql1, mycon);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "v_hr_ats_employee");
string sql1 = "select a.id,a.name,b.gh from table1 a,table2 b where a.id = b.id";
SqlDataAdapter da1 = new SqlDataAdapter(sql1, mycon);
DataSet ds1 = new DataSet();
da1.Fill(ds1);