using System;
using System.Data;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Test07
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection conn;
private void button1_Click(object sender, EventArgs e)
{
conn = new SqlConnection("server=192.168.1.145;database=lydb;uid=sa;pwd=123@abc");
SqlCommand cmd = new SqlCommand("select * from student", conn);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds, "cs");
dataGridView1.DataSource = ds.Tables[0];
}
}
}
using System.Data;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Test07
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection conn;
private void button1_Click(object sender, EventArgs e)
{
conn = new SqlConnection("server=192.168.1.145;database=lydb;uid=sa;pwd=123@abc");
SqlCommand cmd = new SqlCommand("select * from student", conn);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds, "cs");
dataGridView1.DataSource = ds.Tables[0];
}
}
}