ctrl12
版主
  
UID 478
精华
0
积分 1033
帖子 1033
阅读权限 100
注册 2002-9-28
状态 离线
|
private string strConnection="server=(localhost);database=xxx;uid=sa;pwd=sa";
public DataSet DataSelectDst(string strSelect)
{
SqlConnection sqlConn=new SqlConnection(strConnection);
try
{
sqlConn.Open();
SqlDataAdapter sqlDA=new SqlDataAdapter(strSelect,sqlConn);
DataSet dst=new DataSet();
sqlDA.Fill(dst);
sqlConn.Close();
return dst;
}
catch(Exception e)
{
ex=e.ToString();
sqlConn.Close();
return null;
}
}
datagrid.dataScrure=DataSelectDst("select * from table where age=23").table[0];
datagrid.databind();
|
|
