示例#1
0
文件: Dblink.cs 项目: Alencc2015/Myc-
        /// <summary>
        /// 获取数据集
        /// </summary>
        /// <param name="sql"></param>
        /// <returns>DataSet GetDataset</returns>
        public DataSet GetDataset(string sql, string tablename)
        {
            try
            {
                DataSet ds = new DataSet();

                string         strConn = Dblink.connstr();
                SqlConnection  conn    = new SqlConnection(strConn);
                SqlCommand     command = new SqlCommand(sql, conn);
                SqlDataAdapter adapter = new SqlDataAdapter();
                adapter.SelectCommand = command;
                int i = adapter.Fill(ds, tablename);
                if (i == 0)
                {
                    return(null);
                }
                else
                {
                    return(ds);
                }
            }
            catch
            {
                return(null);
            }
        }
示例#2
0
文件: Dblink.cs 项目: Alencc2015/Myc-
 /// <summary>
 /// 水晶报表的数据集
 /// </summary>
 /// <param name="sql"></param>
 /// <param name="table"></param>
 /// <returns>DataSet GetDatasetReport</returns>
 public DataSet GetDatasetReport(string sql, string table)
 {
     try
     {
         DataSet ds = new DataSet();
         //string strConn = "server=(local);database =Library;integrated security=true";
         string         strConn = Dblink.connstr();
         SqlConnection  conn    = new SqlConnection(strConn);
         SqlCommand     command = new SqlCommand(sql, conn);
         SqlDataAdapter adapter = new SqlDataAdapter();
         adapter.SelectCommand = command;
         int i = adapter.Fill(ds, table);
         if (i == 0)
         {
             return(null);
         }
         else
         {
             return(ds);
         }
     }
     catch
     {
         return(null);
     }
 }
示例#3
0
文件: Dblink.cs 项目: Alencc2015/Myc-
 /// <summary>
 ///  下拉形式显示数据
 /// </summary>
 /// <param name="Sql">Sql 语句</param>
 /// <param name="field">字段名</param>
 /// <param name="name">ComboBox名称</param>
 public void ShowInfoList(string Sql, string field, ComboBox name)
 {
     try
     {
         //SqlConnection conn = new SqlConnection("server=(local);database =Library;integrated security=true");
         string         constr = Dblink.connstr();
         SqlConnection  conn   = new SqlConnection(constr);
         SqlDataAdapter da     = new SqlDataAdapter(Sql, conn);
         //SqlCommandBuilder cb = new SqlCommandBuilder(da);
         DataSet ds = new DataSet();
         da.Fill(ds);
         name.DataSource    = ds.Tables[0];   //以下拉的形式显示所有用户名
         name.DisplayMember = field;
         conn.Close();
     }
     catch (Exception)
     {
         ;
     }
 }