[C#2003] type dataset

Hi,
I do a application with C# and SQL server 2000, I have a question about type dataset,
i have 4 tables that a modélise with type dataset, the name is "Dataset_command".
I think that i do a mistake betwen sqladapter and sqlcommad, can you help me?
This is my code :

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.SqlClient;
//using System.Data.SqlClient.SqlDataAdapter;
using System.Data;
......

protected const string SQL_CONNECTION_STRING = "Server=localhost;DataBase=philo_es;Integrated Security=SSPI";
protected const string MSDE_CONNECTION_STRING = "Server=(local)\\NetSDK;DataBase=philo_es;Integrated Security=SSPI";
protected const string CONNECTION_ERROR_MSG = "To run this sample, you must have SQL or MSDE with the Northwind database installed. For instructions on installing MSDE, view the ReadMe file.";
protected bool bolDidPreviouslyConnect = false;
protected bool bolDidCreateTable = false;
protected string connectionString = SQL_CONNECTION_STRING;
.....

// affichage du select

SqlConnection connexion = new SqlConnection(connectionString);
SqlDataAdapter macomclient = new SqlDataAdapter("SELECT num_client ,nom_client , prenom_client, adr_client , tel_client FROM table_client ",connexion);
//SqlCommand macomclient = new SqlCommand("SELECT num_client ,nom_client , prenom_client, adr_client , tel_client FROM table_client ",connexion);
macomclient.Connection=connexion;
SqlDataAdapter m_sqladapter = new SqlDataAdapter();
//Création du Premier DataAdpater pour la Table commande
//SqlDataAdapter daCommande = new SqlDataAdapter("SELECT num_commande,num_c_client,num_c_ligne_commande, desi_commande FROM table_commande",connexion);
try
{
m_sqladapter.SelectCommand = macomclient;
connexion.Open();
//connexion.ExecuteNonQuery();
Dataset_command dsGestion = new Dataset_command();
//dsSeafood.Clear();
daClient.Fill(dsGestion, "table_client");
//daClient.Fill(dsGestion, "table_client");
//daClient.DataSource = dsGestion;
//daClient.DataMember = "table_client";
//daCommande.Fill(dsGestion, "table_commande");

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

philo neo20y ago
Hi ravi,
I do an modifications at code like you tell me, but the workspace find a error at :

daClient.Fill(dsGestion, "table_client");

I verify that i have a name of datagrid, it's true.

pease Can you explain me with a stored procedures...
Ravi Puri20y ago
Hi, you should be able to get away with the following:

protected const string SQL_CONNECTION_STRING = "Server=localhost;DataBase=philo_es;Integrated Security=SSPI";

SqlConnection connexion = new SqlConnection(SQL_CONNECTION_STRING);

SqlDataAdapter macomclient = new SqlDataAdapter("SELECT num_client ,nom_client , prenom_client, adr_client , tel_client FROM table_client ",connexion);
daClient.Fill(dsGestion, "table_client");

I suggest you use stored procedures for your update and delete commands.

Thanks,

Ravi