散分!散分!有请高手请教!!

Question

向数据集dataset添加数据,可以从数据库查询出来放到dataset.

Answer 1

public int FillTable(DataSet 数据集,string 表名,string Select命令)
{
try
{

_conn.Open ();
_command.CommandText=Select命令 ;
_adapter.SelectCommand =_command;
数据集.Tables [0].Clear ();
}
catch
{
}
try
{
_adapter.Fill( 数据集.Tables [表名 ] );
_conn.Close ();
return 0;
}
catch
{
return (-1);
}
}

Answer 2

private void gongBindGrid()
{
string sql="select * from gonggl order by gongId desc";
SqlDataAdapter myDataAdapter=new SqlDataAdapter(sql,myDataConnClass.dataConn);
DataSet myDataSet=new DataSet();
myDataAdapter.Fill(myDataSet,"gonggl");
gongglDataGrid.DataSource=myDataSet.Tables["gonggl"].DefaultView;
try
{
gongglDataGrid.DataBind();
}
catch
{
gongglDataGrid.CurrentPageIndex=gongglDataGrid.CurrentPageIndex-1;
gongglDataGrid.DataBind();
}
}
}

Answer 3

public DataSet ds; 
private System.Data.OleDb.OleDbDataAdapter _adapter;
private System.Data.OleDb.OleDbConnection _conn;
private System.Data.OleDb.OleDbCommand _command;
别忘了定义这些！！

Answer 4

Con_st1为连接字符串
public DataTable LoadData(string tcb,string bm,string pxsx,string xzzd,string xztj)
{
if(ds==null)ds=new DataSet();
if(ds.Tables[tcb]!=null)ds.Tables[tcb].Clear();
if(SQL==null||SQL=="")
{
SQL="SELECT ";
if(xzzd!="")SQL+=xzzd;
else SQL+="*";
SQL+=" FROM "+bm;
if(xztj!="")SQL+=" WHERE "+xztj;
if(pxsx!="")SQL+=" ORDER BY "+pxsx;
}
switch(dsNX)
{
case 1:
{
SqlDataAdapter da=new SqlDataAdapter();
SqlConnection thisConnection=new SqlConnection();
thisConnection.ConnectionString=Con_st1;
da.SelectCommand=new SqlCommand(SQL,thisConnection);
try 
{
da.MissingSchemaAction=MissingSchemaAction.Add;
da.MissingSchemaAction=MissingSchemaAction.AddWithKey;
da.Fill(ds,tcb);
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
try
{
if(ds.Tables[bm].Columns["序号"].AutoIncrement==false)
{
int i=0;i++;
}
}
catch{}
thisConnection.Close();
break;
}
case 2:
{
OleDbDataAdapter da=new OleDbDataAdapter();
OleDbConnection thisConnection=new OleDbConnection();
thisConnection.ConnectionString=Con_st1;
da.SelectCommand=new OleDbCommand(SQL,thisConnection);
try 
{
da.MissingSchemaAction=MissingSchemaAction.Add;
da.MissingSchemaAction=MissingSchemaAction.AddWithKey;
da.Fill(ds,tcb);
}
catch(OleDbException ex)
{
MessageBox.Show(ex.ToString());
}
thisConnection.Close();
break;
}
default:
break;
}
SQL=null;
DataTable thisTable=ds.Tables[tcb].Copy();
return thisTable;
// dataGrid1.SetDataBinding(ds.Tables[tcb],null);
}

Answer 5

OleDbConnecton cnn=...
OleDbDataAdapter da=new OleDbDataAdapter("select * from ...",cnn);
da.Fill(yourDataSet);

Answer 6

你是用Crystal做报表吗？？如果是可以加我的QQ：26654261