[CSharp.net] DataSet in eigener Klasse
Sven Arndt
csharp.net at glengamoi.com
Mon, 19 Jul 2004 12:12:41 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_00FB_01C46D89.B0765A30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Zusatz:
schreibe ich es so:
MySqlDataAdapter myAd = new MySqlDataAdapter(myCmd, myCon);
bekomme ich folgende Meldung beim Compilieren:
The best overloaded method match has some invalid arguments.
Argument '1' : cannot convert to 'string'.
Bei MySqlDataAdapter myAd = new MySqlDataAdapter(myCmd); bekomme ich =
dies:
Invalid expression term 'string'.
Gruß,
Sven
----- Original Message -----
From: Sven Arndt
To: csharp.net@glengamoi.com
Sent: Monday, July 19, 2004 11:46 AM
Subject: Re: [CSharp.net] DataSet in eigener Klasse
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_00FB_01C46D89.B0765A30
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>Zusatz:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>schreibe ich es so:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MySqlDataAdapter myAd = new =
MySqlDataAdapter(myCmd,
myCon);</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>bekomme ich folgende Meldung beim
Compilieren:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The best overloaded method match has =
some invalid
arguments.</FONT></DIV>
<DIV><FONT face=Arial size=2>Argument '1' : cannot convert to
'string'.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Bei MySqlDataAdapter myAd = new
MySqlDataAdapter(myCmd); bekomme ich dies:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Invalid expression term =
'string'.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gruß,</FONT></DIV>
<DIV><FONT face=Arial size=2>Sven</FONT></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=3DArndtinho@gmx.net href="mailto:Arndtinho@gmx.net">Sven =
Arndt</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:46
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [CSharp.net] =
DataSet in
eigener Klasse</DIV>
<DIV><BR></DIV>
<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></BLOCKQUOTE></BODY></=
HTML>
------=_NextPart_000_00FB_01C46D89.B0765A30--