Article View: be.comp.programming
Article #7545Database connectie
From: verkie
Date: Thu, 29 Aug 2002 16:26
Date: Thu, 29 Aug 2002 16:26
29 lines
1925 bytes
1925 bytes
Ben hier bezig in .NET en de bedoeling is een combobox op te vullen door
data te halen uit een SQL server 2000 database. Hierbij krijg ik telkens
een error (http://users.pandora.be/nT-TrusT/sqlerror.jpg). Weet iemand hoe
ik dit oplos?
De code in C#:
private void FillUpCategorie()
{
try
{
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Products", "Data
Source=localhost;Initial Catalog=Products;
User ID=Administrator;Password=*******");
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
adapter.Fill(dataSet, "Categorie");
cboTrack.DataSource = dataSet.Tables["Categorie"].DefaultView;
}
catch(SqlException ex)
{
MessageBox.Show(ex.Message, "SQL error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
--
mvgr,
verkie
Technical Details
Message-ID:
<RWrb9.1542$Y17.190503036@hebe.telenet-ops.be>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!news3.cnt.ru!mtu.ru!image.surnet.ru!surnet.ru!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!demon!newshub1.nl.home.com!news.nl.home.com!skynet.be!skynet.be!ossa.telenet-ops.be!hebe.telenet-ops.be.POSTED!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit X-Google-Thread: fcea4,c50301a16391ffd8,start X-Google-Attributes: gidfcea4,public X-Google-ArrivalTime: 2002-08-29 09:41:39 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!news3.cnt.ru!mtu.ru!image.surnet.ru!surnet.ru!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!demon!newshub1.nl.home.com!news.nl.home.com!skynet.be!skynet.be!ossa.telenet-ops.be!hebe.telenet-ops.be.POSTED!not-for-mail Newsgroups: be.comp.programming Subject: Database connectie From: verkie <verkie_@hotmail.com> User-Agent: Xnews/5.04.25 Lines: 29 Message-ID: <RWrb9.1542$Y17.190503036@hebe.telenet-ops.be> Date: Thu, 29 Aug 2002 16:26:25 GMT NNTP-Posting-Host: 213.224.104.106 X-Complaints-To: abuse@telenet.be X-Trace: hebe.telenet-ops.be 1030638385 213.224.104.106 (Thu, 29 Aug 2002 18:26:25 CEST) NNTP-Posting-Date: Thu, 29 Aug 2002 18:26:25 CEST Organization: Telenet Internet