向数据集dataset添加数据,可以从数据库查询出来放到dataset.
解决方案 »
- 有没有什么办法写一个万能的返回where条件字符串的方法?
- C#编写的手机程序 我想实现手机联网可以访问内网,代码要怎么写?
- ASP.NET去掉IE里的状态栏,菜单栏,标签栏
- 如何理解C#三层架构!
- 关于正则表达式验证的问题...
- 水晶报表分页,和打印问题?
- dropdownlist的item自适应宽度?
- 在一个程序运行时怎么对datagrid的每一列设置列宽?
- 怎么将Byte[]加长,且前面的数据不变? 如: Byte buf = new Byte[10]; 现在想将buf变为 Byte[30]....
- Management|Current Activity ---->Locks/Object无法刷新。(有代码)
- 内码转化的问题高分相送,顶贴有分
- 如何序列化dataset?
{
try
{
_conn.Open ();
_command.CommandText=Select命令 ;
_adapter.SelectCommand =_command;
数据集.Tables [0].Clear ();
}
catch
{
}
try
{
_adapter.Fill( 数据集.Tables [表名 ] );
_conn.Close ();
return 0;
}
catch
{
return (-1);
}
}
{
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();
}
}
}
private System.Data.OleDb.OleDbDataAdapter _adapter;
private System.Data.OleDb.OleDbConnection _conn;
private System.Data.OleDb.OleDbCommand _command;
别忘了定义这些!!
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);
}
OleDbDataAdapter da=new OleDbDataAdapter("select * from ...",cnn);
da.Fill(yourDataSet);