c# 读取数据库得到dateset

public DataSet GetCraftInformation(string connectionString, string opName, string productType)
        {
            string sqlCmd = "select 对应零件序号 as 工步序号,装配工步 as 工步 from Gongbu where 产品型号='" + productType + "' and 工位号='" + opName + "'";
            SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();
            //MessageBox.Show("连接成功");
            SqlCommand command = new SqlCommand(sqlCmd, conn);
            DataSet dataset = new DataSet();
            SqlDataAdapter myDataAdapter = new SqlDataAdapter(sqlCmd, conn);
            myDataAdapter.Fill(dataset);
            return dataset;
        }

前台代码如下；

dataGrid_Craft.DataSource=GetCraftInformation(connectionString,opName,productType).Tables[0]; //得到工步列表

转载于:https://www.cnblogs.com/hanjiaxu/p/3200442.html