用DATASET吧!例子:
myConnection = new System.Data.SqlClient.SqlConnection
(System.Configuration.ConfigurationSettings.AppSettings["connectionstring"]);
myConnection.Open(); myDataSet = new System.Data.DataSet();
myDataSet.CaseSensitive = true; myCommand = new System.Data.SqlClient.SqlCommand();
myCommand.Connection = myConnection; myCommand.CommandText = "Select ptf_ptfinfo.cptf_no as PTF编号," +
"ptf_system.csys_cname as 系统名称," +
"ptf_ptfinfo.cptf_manager as 负责人," +
"convert(char(10),ptf_ptfinfo.dptf_testsend,120) as 发送测试日期," +
"convert(char(10),ptf_ptfinfo.dptf_testend,120) as 要求测毕日期," +
"ptf_level.cptf_levelname as 紧急程度," +
"ptf_state.cptf_statename as 状态" +
" from ptf_ptfinfo,ptf_level,ptf_state,ptf_system" +
" where ptf_ptfinfo.cptf_level = ptf_level.cptf_level" +
" and ptf_ptfinfo.csys_no = ptf_system.csys_no" +
" and ptf_ptfinfo.cptf_state = ptf_state.cptf_state" +
" and ptf_ptfinfo.cptf_state <> '0'" +
" and ptf_ptfinfo.cptf_state <> '4'" +
" order by ptf_ptfinfo.cptf_no"; dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.SelectCommand = myCommand;
dataAdapter.TableMappings.Add("Table","ptf_ptfinfo");
dataAdapter.Fill(myDataSet); DataGrid_undispose.DataSource = myDataSet.Tables["ptf_ptfinfo"].DefaultView;
DataGrid_undispose.DataBind();
myConnection = new System.Data.SqlClient.SqlConnection
(System.Configuration.ConfigurationSettings.AppSettings["connectionstring"]);
myConnection.Open(); myDataSet = new System.Data.DataSet();
myDataSet.CaseSensitive = true; myCommand = new System.Data.SqlClient.SqlCommand();
myCommand.Connection = myConnection; myCommand.CommandText = "Select ptf_ptfinfo.cptf_no as PTF编号," +
"ptf_system.csys_cname as 系统名称," +
"ptf_ptfinfo.cptf_manager as 负责人," +
"convert(char(10),ptf_ptfinfo.dptf_testsend,120) as 发送测试日期," +
"convert(char(10),ptf_ptfinfo.dptf_testend,120) as 要求测毕日期," +
"ptf_level.cptf_levelname as 紧急程度," +
"ptf_state.cptf_statename as 状态" +
" from ptf_ptfinfo,ptf_level,ptf_state,ptf_system" +
" where ptf_ptfinfo.cptf_level = ptf_level.cptf_level" +
" and ptf_ptfinfo.csys_no = ptf_system.csys_no" +
" and ptf_ptfinfo.cptf_state = ptf_state.cptf_state" +
" and ptf_ptfinfo.cptf_state <> '0'" +
" and ptf_ptfinfo.cptf_state <> '4'" +
" order by ptf_ptfinfo.cptf_no"; dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.SelectCommand = myCommand;
dataAdapter.TableMappings.Add("Table","ptf_ptfinfo");
dataAdapter.Fill(myDataSet); DataGrid_undispose.DataSource = myDataSet.Tables["ptf_ptfinfo"].DefaultView;
DataGrid_undispose.DataBind();
解决方案 »
- 如何判断某路径下是否存在文件(非文件夹)
- 如何将字符串放入WHERE 列名 IN (这里面) 在线等,标题要长。。。。。。。。。。。。。。。。。。。。。。
- 今天去面试突然问我问题很令我郁闷
- 求remoting在access数据库中的远程查询
- C#socket编程时,多ip的客户端.如何通过其中指定的某个ip访问服务器?
- C# 获取 EXECL安装版本信息?
- 使用FileUpload控件的问题
- float类型的数据怎么保存到文件,保存成什么格式,然后用到的时候再读出来?
- NetworkStream 为什么这个流不支持查找操作?急求解,跪求!!
- 一个刚开的好论坛,希望大家去灌水呀!
- 怎么样截取小数后两位,并能四舍五入。。。。。
- media player SDK里面的例子在.net2003下面编译出错 求解~~
string sproc = "fetch_subjects_of_asset";
//过程名fetch_subjects_of_asset
SqlCommand oCommand = new SqlCommand(sproc);
oCommand.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = new SqlParameter("@asset_id", SqlDbType.Int, 4);
//输入参数asset_id
p1.Value = assetID;
oCommand.Parameters.Add(p1);SqlConnection oConnection = new SqlConnection(connectionString);
oCommand.Connection = oConnection;
SqlDataAdapter oData = new SqlDataAdapter(oCommand);
DataSet oDataSet = new DataSet();
oData.Fill(oDataSet);
//数据就取出来了,放在oDataSet
string sproc = "fetch_subjects_of_asset";
//过程名fetch_subjects_of_asset
SqlCommand oCommand = new SqlCommand(sproc);
oCommand.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = new SqlParameter("@asset_id", SqlDbType.Int, 4);
//输入参数asset_id
p1.Value = assetID;
oCommand.Parameters.Add(p1);SqlConnection oConnection = new SqlConnection(connectionString);
oCommand.Connection = oConnection;
SqlDataAdapter oData = new SqlDataAdapter(oCommand);
DataSet oDataSet = new DataSet();
oData.Fill(oDataSet);
//数据就取出来了,放在oDataSet