Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
[C#2003] type dataset
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
philo neo
18y
2.1k
1
Reply
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");
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Change Password,Forget password
sql performance