数据适配器的问题 [英] problem with dataadapter

问题描述

我正在使用oledbdataadapter ..如何在适配器中存储多个表...帮助我吗?

i am using oledbdataadapter..how to store multiple table in adapter...help me?

推荐答案

您可以尝试使用以下方法编写的内容. ..

使用System.Configuration;
使用System.Data.OleDb;

公共数据集getYourData(int paramid)
{
DataSet _ds = new DataSet();
OleDbConnection _conn = null;
OleDbCommand _cmd = null;
OleDbDataAdapter _da = null;

试试
{
字符串constr = ConfigurationManager.ConnectionStrings ["SqlConnectionString"].ConnectionString;
_conn =新的OleDbConnection(constr);
_cmd =新的OleDbCommand("sp_get_YourData/您的查询文本"，_conn);
_cmd.CommandTimeout = 0;
_cmd.CommandType = CommandType.StoredProcedure;//或使用CommandType.Text;

_da =新的OleDbDataAdapter(_cmd);
//将参数添加到commandojbect
_cmd.Parameters.Add(新SqlParameter("@ paramid"，SqlDbType.Int));
_cmd.Parameters ["@ paramid"].Value = paramid;

_da.TableMappings.Add("SourceTable"，"DatasetTableName");
_da.TableMappings.Add("SourceTable1"，"DatasetTableName1");
_da.TableMappings.Add("SourceTable2"，"DatasetTableName2");
_da.TableMappings.Add("SourceTable3"，"DatasetTableName3");
_da.TableMappings.Add("SourceTable4"，"DatasetTableName4");

_ds.EnforceConstraints = false;

_da.Fill(_ds);
}
抓住(OleDbException ex)
{
扔前;
}
catch(ex ex例外)
{
扔前;
}
终于
{
如果(_cmd！= null)
{
_cmd.Dispose();
_cmd = null;
}
如果(_da！= null)
{
_da.Dispose();
_da = null;
}
}

返回_ds;
}

You can try this as it written in following method...

using System.Configuration;
using System.Data.OleDb;

public DataSet getYourData(int paramid)
{
DataSet _ds = new DataSet();
OleDbConnection _conn = null;
OleDbCommand _cmd = null;
OleDbDataAdapter _da = null;

try
{
string constr=ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString;
_conn = new OleDbConnection(constr);
_cmd = new OleDbCommand("sp_get_YourData/Your query text", _conn);
_cmd.CommandTimeout = 0;
_cmd.CommandType = CommandType.StoredProcedure;// or use CommandType.Text;

_da = new OleDbDataAdapter(_cmd);
//adding parameters to the commandojbect
_cmd.Parameters.Add(new SqlParameter("@paramid", SqlDbType.Int));
_cmd.Parameters["@paramid"].Value = paramid;

_da.TableMappings.Add("SourceTable", "DatasetTableName");
_da.TableMappings.Add("SourceTable1", "DatasetTableName1");
_da.TableMappings.Add("SourceTable2", "DatasetTableName2");
_da.TableMappings.Add("SourceTable3", "DatasetTableName3");
_da.TableMappings.Add("SourceTable4", "DatasetTableName4");

_ds.EnforceConstraints = false;

_da.Fill(_ds);
}
catch (OleDbException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (_cmd != null)
{
_cmd.Dispose();
_cmd = null;
}
if (_da != null)
{
_da.Dispose();
_da = null;
}
}

return _ds;
}

这篇关于数据适配器的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！