打球归来,写一段写代然后吃饭。
填充和更新数据集,都要作的,现在还没有理解CS的意思。
1 using System; 2 using System.Collections.Generic; 3 using System.ComponentModel; 4 using System.Data; 5 using System.Drawing; 6 using System.Linq; 7 using System.Text; 8 using System.Threading.Tasks; 9 using System.Windows.Forms;10 using System.Data.SqlClient;11 12 namespace WindowsFormsApplication613 {14 public partial class Form1 : Form15 {16 SqlConnection conn;17 public Form1()18 {19 InitializeComponent();20 }21 22 private void button1_Click(object sender, EventArgs e)23 {24 conn = new SqlConnection("server = .; database = msdb; uid = A; pwd = B");25 SqlCommand cmd = new SqlCommand("select * from MSdbms", conn);26 SqlDataAdapter sda = new SqlDataAdapter();27 sda.SelectCommand = cmd;28 DataSet ds = new DataSet();29 sda.Fill(ds, "cs");30 dataGridView1.DataSource = ds.Tables[0];31 }32 }33 }