wijdene
-
15 nov. 2013 à 22:11
jordane45
Messages postés38144Date d'inscriptionmercredi 22 octobre 2003StatutModérateurDernière intervention21 avril 2024
-
16 nov. 2013 à 01:21
Bonjour,
sur la ligne , var red = cmd.ExecuteReader();
voici mon code :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Collections;
namespace Soutenance
{
class Connction
// Data Source=Wejden;Initial Catalog="PROJET PFE";Integrated Security=True
{
private String connction = "Data Source=Wejden;Initial Catalog=PROJET PFE;Integrated Security=True";
/* SqlConnection cn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\GI1.mdf;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;*/
public ArrayList Getalladmin(int id)
{
using (var con = new SqlConnection(connction))
{
con.Open();
var list = new ArrayList();
string Query = "select*form admin where id=" + id;
using (SqlCommand cmd = new SqlCommand(Query, con))
{
cmd.CommandTimeout =100;
var red = cmd.ExecuteReader();