Torna al Thread

private void Form1_Load(object sender, EventArgs e) { OleDbConnection cn= new OleDbConnection(report.Properties.Settings.Default.fotoConnectionString); cn.Open(); OleDbCommand cmd = new OleDbCommand(); OleDbDataReader dr ; cmd.CommandText = "Select * From qFoto where Costruzione = ?"; cmd.Connection = cn; cmd.Parameters.Add("@Costruzione", OleDbType.LongVarChar); cmd.Parameters["@Costruzione"].Value = textBox1.Text; dr=cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(dr); MessageBox.Show(dt.Rows.Count.ToString()); DataSet ds = new DataSet(); ds.Tables.Add(dt); OleDbDataAdapter da = new OleDbDataAdapter(); da.SelectCommand = cmd; da.Fill(ds.Tables[0]); dataGridView1.DataSource = ds.Tables[0]; }
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5