1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
SqlConnection con;
SqlDataAdapter dr;
DataSet ds = new DataSet();
string pat, req;
public Form2()
{
try{
pat = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and Settings\\Administrateur\\Bureau\\Copie de WindowsFormsApplication1\\WindowsFormsApplication1\\AppData\\Main.mdf;Integrated Security=True;User Instance=True";
req = "SELECT * FROM fichier";
con = new SqlConnection(pat);
con.Open();
dr = new SqlDataAdapter(req, con);
dr.Fill(ds, "fichier");
}
catch (Exception e) { MessageBox.Show("database not find", e.Message); }
InitializeComponent();
panel2.Hide();
affich();
}
private void affich()
{
// MessageBox.Show(""+sTable.Rows.Count); //the result is 5
// MessageBox.Show(""+sTable.Rows[0][0].ToString()); //the result is 11
dataGridView1.DataSource = ds.Tables["fichier"];
} |
Partager