S
Sat Oct 29 10:41:59 CDT 2005
This is a multi-part message in MIME format.
------=_NextPart_000_00C4_01C5DCA7.AEBD2E10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Show us the code that you tried to use for your SQLParameters. =20
-Altaf
-------------------------------------------------------------------------=
-------
All that glitters has a high refractive index.=20
www.mendhak.com=20
"depova" <awolff@cityofbryan.net> wrote in message =
news:1130527684.419272.306580@g43g2000cwa.googlegroups.com...
I've been trying to figure this out but can't seem to grasp it. I'm
very new to web services and am trying to create a simple one that can
receive and submit to a sql table to be used by Infopath. I have been
able to do this thanks to this microsoft article.
=
http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/odc_ip=
2003_tr/html/odc_INF_Lab_09.asp
Now I want to be able to use parameters to create query fields in
infopath so that these results can be easily filtered. This is where
I'm lost. I've tried using the SqlParameters but when I add them into
the select statement it makes the web service not work. (says it's
missing an expected parameter which was not supplied) I'm assuming =
I'm
missing code to be put into the webmethod but I don't know what goes
in. Any help would be greately appreciated. thanks.
------=_NextPart_000_00C4_01C5DCA7.AEBD2E10
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=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial size=3D2>Show =
us the code=20
that you tried to use for your SQLParameters. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>-Altaf</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><BR></DIV>
<DIV>
<HR align=3Dleft width=3D"50%">
</DIV>
<DIV><FONT face=3DTahoma size=3D2>All that glitters has a high =
refractive index.=20
<BR><B><A href=3D"
http://www.mendhak.com">www.mendhak.com</A></B> =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"depova" <<A=20
href=3D"mailto:awolff@cityofbryan.net">awolff@cityofbryan.net</A>> =
wrote in=20
message <A=20
=
href=3D"news:1130527684.419272.306580@g43g2000cwa.googlegroups.com">news:=
1130527684.419272.306580@g43g2000cwa.googlegroups.com</A>...</DIV>I've=20
been trying to figure this out but can't seem to grasp it. =
I'm<BR>very=20
new to web services and am trying to create a simple one that =
can<BR>receive=20
and submit to a sql table to be used by Infopath. I have =
been<BR>able to=20
do this thanks to this microsoft article.<BR><BR><A=20
=
href=3D"
http://msdn.microsoft.com/library/default.asp?url=3D/library/en-u=
s/odc_ip2003_tr/html/odc_INF_Lab_09.asp">
http://msdn.microsoft.com/librar=
y/default.asp?url=3D/library/en-us/odc_ip2003_tr/html/odc_INF_Lab_09.asp<=
/A><BR><BR>Now=20
I want to be able to use parameters to create query fields =
in<BR>infopath so=20
that these results can be easily filtered. This is where<BR>I'm=20
lost. I've tried using the SqlParameters but when I add them =
into<BR>the=20
select statement it makes the web service not work. (says=20
it's<BR>missing an expected parameter which was not supplied) =
I'm=20
assuming I'm<BR>missing code to be put into the webmethod but I don't =
know=20
what goes<BR>in. Any help would be greately appreciated. =20
thanks.<BR></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_00C4_01C5DCA7.AEBD2E10--