问个简单数据库问题

Question

select * from RptItemRela where intRow=1 and intCol=1
这个取出来的一行数据，怎么传值给程序里的变量。

Answer 1

datareader 来接受数据，

Answer 2

public List<string> GetDataCollection(string sql,SqlParameter []para)
        {
            List<string> lst = new List<string>();
            using (SqlConnection con = new SqlConnection(connectString))
            {
                SqlCommand cmd = new SqlCommand(sql, con);
                if (para != null)
                {
                    foreach (SqlParameter p in para)
                        cmd.Parameters.Add(p);
                }
                con.Open();
                SqlDataReader read = cmd.ExecuteReader();
                while (read.Read())
                    lst.Add(read.GetString(0));
            }
            return lst;
        }

Answer 3

public SqlDataReader getDataReaderBySQL(string sql)
        {
            string strConn = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;//数据库连接字符串
            SqlConnection Conn = new SqlConnection(strConn);//创建数据库连接
            Conn.Open();//打开数据库连接            SqlDataReader dr = null;
            string strSelect = sql;
            try
            {                SqlCommand cmd = new SqlCommand(strSelect, Conn);
                Adapter.Fill(ds, "T_Function");
                dr = cmd.ExecuteReader();
                dr.Read();
                return dr;
            }
            catch 
            {
               
                return null;
            }
            finally
            {
                
                Conn.Close();
            }
        }调用这个函数，SqlDataReader dr =getDataReaderBySQL("select * from RptItemRela where intRow=1 and intCol=1
");
dr.Read();string str1=dr["数据表字段"].ToString();
.....

Answer 4

        private void Form1_Load(object sender, EventArgs e)
        {
            String sConnString = "Data Source=WWW-28E16B9FC9D;Initial Catalog=ceshi;  Integrated Security=true";
            String sSQL = "SELECT * FROM Store";
                        //创建一个数据库连接对象
            sqlConnection1 = new System.Data.SqlClient.SqlConnection(sConnString );
            sqlCommand1 = new System.Data.SqlClient.SqlCommand(sSQL ,sqlConnection1 );
            sqlCommand1.CommandText = "SELECT PlayerID FROM Store ORDER BY PlayerID";            //创建sqldataadapter对象
            sqlDataAdapter1 = new SqlDataAdapter(sSQL, sqlConnection1);
            //创建一个dataset对象
            DataSet dataSet1 = new DataSet();            sqlDataAdapter1.Fill(dataSet1, "Store");
            dataGridView1.DataSource = dataSet1.Tables["Store"];
            GetPlayerID();
            dataGridView1.DataBindings.Add("Text", dataSet1, "Store.PlayerID");
        }举个例子。

Answer 5

        private void button1_Click_1(object sender, EventArgs e)
        {
            String ConnString = "Data Source=WWW-28E16B9FC9D;Initial Catalog=ceshi;Integrated Security=true";
            String SQLString = "SELECT * FROM Store";
            SqlDataAdapter SqlDataAdapter1 = new SqlDataAdapter(SQLString, ConnString);
            DataSet DataSet1 = new DataSet();
            SqlDataAdapter1.Fill(DataSet1, "Store");
            dataGridView1.DataSource = DataSet1.Tables["Store"];
            DataTable dt = DataSet1.Tables["Store"];//例如
        }