python 数据库

c1 = conn.cursor()
c1.execute('SELECT * FROM TV')

c2 = conn.cursor()
c2.execute('SELECT * FROM TV WHERE salesrep =%s', Arr[i])

with pymssql.connect(server, user, password, database) as conn:
    with conn.cursor(as_dict=True) as cursor:
        # 创建存储过程
        cursor.execute("""
        CREATE PROCEDURE FindPerson
            @name VARCHAR(100)
        AS BEGIN
            SELECT * FROM TV WHERE name = @name
        END
        """)

        # 调用存储过程
        cursor.callproc('FindPerson', (Arr[i],))
        for row in cursor:
            print("ID=%d, Name=%s" % (row['id'], row['name']))

print( "all right" )print(c1.fetchall() ) # 显示出的是c2游标查询出来的结果print(c2.fetchall() )

private void button1_Click(object sender, EventArgs e)
{
    String connsql = "server=.;database=MyDBName;integrated security=SSPI"; // 数据库连接字符串,database设置为自己的数据库名，以Windows身份验证
            
    try
    {
        using (SqlConnection conn = new SqlConnection())
        {
            conn.ConnectionString = connsql;
            conn.Open(); // 打开数据库连接

            String sql = "select * from TV"; // 查询语句

            SqlDataAdapter myda = new SqlDataAdapter(sql, conn); // 实例化适配器

            DataTable dt = new DataTable(); // 实例化数据表
            myda.Fill(dt); // 保存数据 

            dataGridView1.DataSource = dt; // 设置到DataGridView中

            conn.Close(); // 关闭数据库连接
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show("错误信息：" + ex.Message, "出现错误");
    }
}