[CSharp.net] DataSet in eigener Klasse
Sven Arndt
csharp.net at glengamoi.com
Mon, 19 Jul 2004 11:46:30 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_00E2_01C46D86.07FAF8F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Mach ich ja eigentlich. hier ist der volle Code der Klasse:
public class MySqlCon
{
public string cmdMySQL;
public MySqlConnection myCon;
public MySqlCommand myCmd;
public MySqlCon()
{
string strCon = "Server...";
myCon = new MySqlConnection(strCon);
try
{ myCon.Open(); }
catch(Exception e)
{ ... }
}
public void MySqlCmd(string cmdMySQL)
{
try
{
MySqlCommand myCmd = new MySqlCommand();
myCmd.CommandText = cmdMySQL;
myCmd.Connection = myCon;
}
catch(Exception e)
{ ... }
}
public DataSet GetData()
{
try
{
MySqlDataAdapter myAd = new MySqlDataAdapter(myCmd);
myAd.SelectCommand = myCmd;
DataSet myDs = new DataSet("data");
myAd.Fill(myDs, "data");
myCon.Close();
return myDs;
}
catch(Exception e)
{ ... }
return null;
}
}
Gruß,
Sven
----- Original Message -----
From: A-Schubert
To: csharp.net@glengamoi.com
Sent: Monday, July 19, 2004 11:34 AM
Subject: AW: [CSharp.net] DataSet in eigener Klasse
MySqlDataAdapter myAd = new MySqlDataAdapter();
Du musst diesem Konstruktor die Connection und das Command Objekt =
übergeben, sonst weiss der Adapter nicht was
er machen soll.
André
------=_NextPart_000_00E2_01C46D86.07FAF8F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; =
charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 70.85pt 70.85pt 2.0cm =
70.85pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailFormatvorlage17 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=DE vLink=purple link=blue bgColor=white>
<DIV><FONT face=Arial size=2>Mach ich ja eigentlich. hier ist der =
volle Code der
Klasse:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>public class MySqlCon<BR>{<BR> public string =
cmdMySQL;<BR>
public MySqlConnection myCon;<BR> public MySqlCommand
myCmd;<BR> <BR> public MySqlCon()<BR> =
{<BR>
string strCon = "Server...";<BR> myCon = new
MySqlConnection(strCon);<BR> try<BR> =
{ myCon.Open(); }<BR> catch(Exception
e)<BR> { ... }<BR> }<BR> <BR> public =
void
MySqlCmd(string cmdMySQL)<BR> {<BR>
try<BR> {<BR> =
MySqlCommand myCmd
= new MySqlCommand();<BR> =
myCmd.CommandText =
cmdMySQL;<BR> myCmd.Connection =
myCon;<BR> }<BR> catch(Exception
e)<BR> { ... }<BR> }<BR><BR> public =
DataSet
GetData()<BR> {<BR> try<BR>
{<BR> MySqlDataAdapter myAd = new
MySqlDataAdapter(myCmd);<BR>
myAd.SelectCommand = myCmd;<BR> =
DataSet
myDs = new
DataSet("data");<BR> myAd.Fill(m=
yDs,
"data");<BR>
myCon.Close();<BR> return
myDs;<BR> }<BR> catch(Exception
e)<BR> { ... }<BR> return =
null;<BR>
}<BR>}</DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Gruß,</FONT></DIV>
<DIV><FONT face=Arial size=2>Sven</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>
<A title=3DAndre.Schubert@t-systems.com
href="mailto:Andre.Schubert@t-systems.com">A-Schubert</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A =
title=3Dcsharp.net@glengamoi.com
href="mailto:csharp.net@glengamoi.com">csharp.net@glengamoi.com</A> =
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, July 19, 2004 =
11:34
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> AW: [CSharp.net] =
DataSet in
eigener Klasse</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> MySqlDataAdapter =
myAd = new
MySqlDataAdapter();</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Du musst diesem =
Konstruktor die
Connection und das Command Objekt übergeben, sonst weiss der Adapter =
nicht
was</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">er machen =
soll.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">André</SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_00E2_01C46D86.07FAF8F0--