TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
philo neo
NA
4
0
[C#2003] type dataset
Mar 8 2006 7:30 AM
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");
Reply
Answers (
2
)
Change Password,Forget password
sql performance