| Error after calling System.Diagnostics.Process.GetCurrentProcess().StartTime |
|
 |
Index ‹ DotNet ‹ Visual C#.Net
|
- Previous
- 1
- ADO >> how do I set a SQLdataAdapter's insert parameter to NULLIn my application I use a field of SQL type bit as a kind of tri-state
indicater; 0, 1, and null. When I insert the record into the database using
a stored procedure I set all the parameters and preform an executeNonQuery.
My problem is that I want to be able to set this one parameter under a given
condition to null initially but I can not find a way to add the parameter
and have the insert work under ADO.NET
here's what I'm trying (although I know it's not working):
Dim spcmd As SqlClient.SqlCommand
spcmd = New SqlClient.SqlCommand("spInsertUserActivity2", Me.SqlConnection2)
spcmd.CommandType = CommandType.StoredProcedure
Dim param As SqlClient.SqlParameter
' set up the parameter values.....
If Me.ddAddAssign2.SelectedItem.Text = owner Then
param = spcmd.Parameters.Add("@accepted", 1)
Else
param = spcmd.Parameters.Add("@accepted", Nothing) ' <<< this is where I
wanted to set the value to DBNULL
End If
' try to do the insert .....
Me.SqlConnection2.Open()
spcmd.ExecuteNonQuery()
Me.SqlConnection2.Close()
This should be an easy answer I would think. but I haven't found a reference
as to what this constant is called.
Is there one, and if so what is it called?
-Larry
- 2
- Winforms >> Install that package that came from the Microsoft Corp.--zqoexfseu
Content-Type: multipart/related; boundary="qunrhfwgqyhqbwg";
type="multipart/alternative"
--qunrhfwgqyhqbwg
Content-Type: multipart/alternative; boundary="fxthzqolykd"
--fxthzqolykd
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
MS Customer
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to continue keeping your computer secure
from these vulnerabilities, the most serious of which could
allow an attacker to run code on your computer.
This update includes the functionality =
of all previously released patches.
System requirements: Windows 95/98/Me/2000/NT/XP
This update applies to:
- MS Internet Explorer, version 4.01 and later
- MS Outlook, version 8.00 and later
- MS Outlook Express, version 4.01 and later
Recommendation: Customers should install the patch =
at the earliest opportunity.
How to install: Run attached file. Choose Yes on displayed dialog box.
How to use: You don't need to do anything after installing this item.
--fxthzqolykd
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<HTML>
<HEAD>
<style type=3D'text/css'>.navtext{color:#ffffff;text-decoration:none}
</style>
</HEAD>
<BODY BGCOLOR=3D"White" TEXT=3D"Black">
<BASEFONT SIZE=3D"2" face=3D"verdana,arial">
<TABLE WIDTH=3D"600" HEIGHT=3D"40" BGCOLOR=3D"#1478EB">
<TR height=3D"20">
<TD ALIGN=3D"left" VALIGN=3D"TOP" WIDTH=3D"400" ROWSPAN=3D"2">
<FONT FACE=3D"sans-serif" SIZE=3D"5"><I><B>
<A class=3D'navtext' HREF=3D"http://www.microsoft.com/"
TITLE=3D"Microsoft Home Site" target=3D"_top">Microsoft</A>
</B></I></FONT>
</TD>
<TD ALIGN=3D"right" VALIGN=3D"MIDDLE" BGCOLOR=3D"Black" NOWRAP>
<FONT color=3D"#ffffff" size=3D1>
<A class=3D'navtext' href=3D'http://www.microsoft.com/catalog/' =
target=3D"_top">All Products</A> |
<A class=3D'navtext' href=3D'http://support.microsoft.com/' =
target=3D"_top">Support</A> |
<A class=3D'navtext' href=3D'http://search.microsoft.com/' =
target=3D"_top">Search</A> |
<A class=3D'navtext' href=3D'http://www.microsoft.com/' target=3D_top>
Microsoft.com Guide</A>
</FONT>
</TD>
</TR>
<TR>
<TD ALIGN=3D"right" VALIGN=3D"BOTTOM" NOWRAP>
<FONT FACE=3D"Verdana, Arial" SIZE=3D1><B>
<A class=3D'navtext' HREF=3D'http://www.microsoft.com/' TARGET=3D" top">
Microsoft Home</A> </B>
</FONT>
</TD>
</TR>
</TABLE>
<IMG SRC=3D"cid:xilobuq" BORDER=3D"0"><BR><BR>
<TABLE WIDTH=3D"600"><TR><TD><FONT SIZE=3D"2">
MS Customer<BR><BR>
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to continue keeping your computer secure
from these vulnerabilities, the most serious of which could
allow an attacker to run code on your computer.
This update includes the functionality =
of all previously released patches.
</FONT></TD></TR>
</TABLE>
<BR><BR>
<TABLE BORDER=3D"1" CELLSPACING=3D"1" CELLPADDING=3D"3" WIDTH=3D"600">
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:kfvepnq" =
ALIGN=3D"absmiddle" BORDER=3D"0"> System requirements</B>
</FONT></TD>
<TD NOWRAP><FONT SIZE=3D"1">Windows 95/98/Me/2000/NT/XP</FONT></TD>
</TR>
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:kfvepnq" =
ALIGN=3D"absmiddle" BORDER=3D"0"> This update applies to</B>
</FONT></TD><TD NOWRAP>
<FONT SIZE=3D"1">
MS Internet Explorer, version 4.01 and later<BR>
MS Outlook, version 8.00 and later<BR>
MS Outlook Express, version 4.01 and later
</FONT>
</TD>
</TR>
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:kfvepnq" =
ALIGN=3D"absmiddle" BORDER=3D"0"> Recommendation</B></FONT></TD>
<TD NOWRAP><FONT SIZE=3D"1">Customers should install the patch =
at the earliest opportunity.</FONT></TD>
</TR>
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:kfvepnq" =
ALIGN=3D"absmiddle" BORDER=3D"0"> How to install</B></FONT></TD>
<TD NOWRAP><FONT SIZE=3D"1">Run attached file. =
Choose Yes on displayed dialog box.</FONT></TD>
</TR>
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:kfvepnq" =
ALIGN=3D"absmiddle" BORDER=3D"0"> How to use</B></FONT></TD>
<TD NOWRAP><FONT SIZE=3D"1">You don't need to do =
anything after installing this item.</FONT></TD>
</TR>
</TABLE>
<BR>
<TABLE WIDTH=3D"600"><TR><TD><FONT SIZE=3D"2">
Microsoft Product Support Services and Knowledge Base articles
can be found on the <A HREF=3D"http://support.microsoft.com/" =
TARGET=3D"_top">Microsoft Technical Support</A> web site. =
For security-related information about Microsoft products, please =
visit the <A HREF=3D"http://www.microsoft.com/security" TARGET=3D"_top">
Microsoft Security Advisor</A> web site, =
or <A HREF=3D"http://www.microsoft.com/contactus/contactus.asp" =
TARGET=3D"_top">Contact Us.</A>
<BR><BR>
Thank you for using Microsoft products.<BR><BR></FONT>
<FONT SIZE=3D"1">Please do not reply to this message. =
It was sent from an unmonitored e-mail address and we are unable =
to respond to any replies.<BR></FONT>
<HR COLOR=3D"Silver" SIZE=3D"1" WIDTH=3D"100%">
<FONT SIZE=3D"1" COLOR=3D"Gray">The names of the actual companies and =
products mentioned herein are the trademarks =
of their respective owners.</FONT>
</TD></TR></TABLE>
<BR>
<TABLE WIDTH=3D"600" HEIGHT=3D"45" BGCOLOR=3D"#1478EB">
<TR VALIGN=3D"TOP">
<TD WIDTH=3D"5"></TD>
<TD>
<FONT COLOR=3D"#FFFFFF" SIZE=3D"1"><B>
<A class=3D'navtext' HREF=3D"http://www.microsoft.com/=
contactus/contactus.asp" TARGET=3D"_top">Contact Us</A>
|
<A class=3D'navtext' HREF=3D"http://www.microsoft.com/legal/" =
TARGET=3D"_top">Legal</A>
|
<A class=3D'navtext' HREF=3D"https://www.truste.org/validate/605" =
TARGET=3D"_top" TITLE=3D"TRUSTe - Click to Verify">TRUSTe</A>
</FONT></B>
</TD>
</TR>
<TR VALIGN=3D"MIDDLE">
<TD WIDTH=3D"5"></TD>
<TD>
<FONT COLOR=3D"#FFFFFF" SIZE=3D"1">
©2003 Microsoft Corporation. All rights reserved.
<A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/=
info/cpyright.htm" TARGET=3D"_top">Terms of Use</A>
|
<A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/=
info/privacy.htm" TARGET=3D"_top">
Privacy Statement</A> |
<A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/=
enable/" TARGET=3D"_top">Accessibility</A>
</FONT>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>
--fxthzqolykd--
--qunrhfwgqyhqbwg
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-ID: <xilobuq>
R0lGODlhaAA7APcAAP///+rp6puSp6GZrDUjUUc6Zn53mFJMdbGvvVtXh2xre8bF1x8cU4yLprOy
zIGArlZWu25ux319xWpqnnNzppaWy46OvKKizZqavLa2176+283N5sfH34uLmpKSoNvb7c7O3L29
yqOjrtTU4crK1Nvb5erq9O/v+O7u99PT2sbGzePj6vLy99jY3Pv7/vb2+fn5++/v8Kqr0oWHuNbX
55SVoszN28vM2pGUr7S1vqqtv52frOPl8CQvaquz2Ojp7pmn3Ozu83OPzmmT6F1/xo6Voh9p2C5z
3EWC31mS40Zxr4uw6LXN8iZkuXmn55q97PH2/Yir1rbL5iVTh3Oj2cvX5Pv9/+/w8QF8606h62Wk
3n+dubnY9abB2c7n/83h9Nji6weK+CGJ4Vim6WyKpKWssgFyyAaV/0Km8Gyx6HW57FJxicDP2+Tt
9Pj8/wOa/wmL5wqd/w6V8heb91e5+mS9+VmLr4vD6qvc/b/j/Mbn/sTi9rvX6szq/tPt/9ju/dzx
/+n2/+74//P6/+3w8hOh/xOW6yCm/iuu/zWv/0m4/XTH/IXK95TP9qPV9bfi/tDn9tfp9OP0/93r
9L3Izy6Vzj22/lrC/mfG/JvJ5JGntAyd6IbX/3zD6GzP/3jV/2uoxHqbqujv8g6MvJTj/2HF5pXV
606zz6Hp/63v/7j1/8Ps88b8/rbj5RKOkE2wr3OGhoKGhv7///Dx8V2alqvm4Zni1YPRvx5uVwyO
X0q2hLTvw8X10gx2H4PXkkuoV5zkoQeADZu7mmzIVEO7HIXbaGfLMPz8+97d2/Px7v///+bl5eHg
4P7+/v39/fT09PLy8u7u7gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAaAA7AAAI/gCVCRxI
sKDBgwgTKlzIsKHDhxAjKgwiqs2kSJEgQfqyp2PHLxoxTmojSpTEkyglBrGYcU+el3n09PEDSFKg
mzclAfLTRw/MPV4gjTSZsmhRURchuXwUs88fSYIGubEiqyqAq1gBNLPiRlCgPz197tE4MojRswuD
JHX5UiagQILcNMtKl26zu3etuBgUaKcePXv0QIo0iSjaw8raROKYh6nbuFbmVpVlpbKby4Mya858
eWrlrV0l/fECWDBhw4hPimoJUw9NQVa0Yg6kk6dPmD9xt/Xi52kgKG4GCRLtpTjZNmZTQ5yktLXT
QFNDA+qJe2wkkgkrrmWrx4tv0X6M/gvFrnzh6uaO+wCKOhzs7TzWyUesyDom7z9//EAKOh51eYKK
sdWWH1D15cd78J12GFJKufRXcfwNNtR/ANYXE006UfdSfBQq1lxM3fFHWFlojRBCCA5goMMK5y3V
1B879VGdUMlRqIxaG7kUmHEikVTjQyuAcGIGDmSQwQUYzPBAA1UIKJMfUCI4Vhs2EjTJKrWYwogp
mXSxY0iTTLhQAC2ocKIDHGywgAwYWPDAm3AeIIVztr3E1FiFVSnQJLXc4ksxuujyiy6npNGFYBKK
WRAzKZipAgkp8ACCAyLg0MClDcD5ppIUVNCFFDL1oSF8Qvn3nyi8+KIqMH8aQwwx/66EMQcoVQxG
mI/KBEBCCCSo0MIPLJSJwA6YFvsmBlFkYgopUTxwgQ8XXGBBBRUA0QUXeJp6qi2r2rKLLcAU42qs
WIRhR623YpdDNM4wQ0IOInggrwfFNoCDDl20wooqqaSCCil3SHCBBgQXnAGbFmCAgQMkBKDnLsMU
4wswvPCySy3DuLpJGFiY4YodX6RrUhnOIFDDvPNeqkkXfKzCyssv8+svwM5uYPPNONusAZszEEEE
GoooQsfQdRRdxyJII83I0ow04nQjjkTtCB5cVN3KMBEXA8wuFbMC6Cu5jIJFLsG4oonIQeQQQw4o
a5KsI6moogrMMMvt77+kCPzB3v589+03BxdQ0IFyotyCdTFap7I1K7Z4YskmcIwSTC+9KMHGSD6S
0AIJHkRxByekkIJKv3LPXbfMeOddgQmst+466xoAIUEEEUzAQNBD02H00UkvwnTTT0s9ddV4ZPEK
1hH/qTUnlyDyRi659BJMMLiEgrkoQSwTAjMefPIJ6KKPHnfppfeLCt6cCDFDmjT8AMP7MJywwQW0
1187Aco5osUYyGNtjC+ccFwhzuCK6U0OF2uoQht8FAMEoMADnfge+M7Xrwpa8HyhI0X6JGCwDGhg
fvYLoe1wRzSj9c53THsa1KRGNS6oYQxZ0AXyjKGLUlzCEoeIQxjIRjnKTYESC/7EnjJyYAIRRMF7
4Auf+Cp4vtRxghNOiEAHjxTC+k3gfsp5ghPSAIqMBeoUlkjEIeYgBzjwEBdonEIOgmgWSDlgC0h8
YgabSEcncuITUZQBwYxERftRYAIToEDtbie0EhbthL9TofBa6IT9jeEVgQpUJcZoCDEUcHqUw8UU
ysBGZZQgBAvAgSfimMQMmjJ0T/SeGiKgRw3w8QKz+2Mgp/UALKamC1FYwha1AElJzkEMYiDb5HqB
wE2SRIjR0MEIGoCJUUqwlKd84h0/4QlMRKACezQSLAM5A2pR6wF/JGTudofIFAaPhVW7AxWooIX9
ZSELv4hnJYA5CjQScw1rUP/jMQeCgA/gQA2ecOYzpUnQaVKzmtfM5pEkMIFpebMCtZwA/lJTBR88
YQlRcIITQBHPeNrhCEcwQhPQmM8EALEkAwnBDTBAhWYG1HukTCVMD4oJTBDBAgrNAEOnZYE/vomh
4jQk75KWyHNGrYWO0KUT1tlOWnRUCUdQQhOaoIQ12GEKsVCgEAVSAge88RIufelMxxrQal7iEkLg
oCv5uFOffvOPE0XMMvjggy74IAoZ3UI8aYEEJUh1CkoggxIOUIbCbFUZyczADM4K1rI69rHVxARj
kyDFtRppp9OawR8pAFQS6s6EvSuq0xZZNS444gkZ1SgVQkELWvjMr1QlQgT+pgALG+yTIDrgwAPo
wFiwhtWxNZUsYxVBWYX6YAYT0CwgHwDRB0i0PNGoghTsCoQoaEIYQhCCz7ZLhCYoIAdD+ZEyQqAB
C4xBEb09a3Brmt5LBE0RWYiAB/mo2EBSoJvfdG5QP3vI0JpztOgsLR8y8QTU4jUK2U2wEIagBAWU
AQy3JcgIUqSF97b3wu9VhCXQwErLKpYCDvXmmygQV+UEQLpScKUPfACEFjuBCGuAhQ4gXBLxIjZa
QrBEhtGL3rPyOMOWCHIiOkxfCzT0oc2lwH7J6d+lKTLAVfPIdAu8hCUAwQlCIIMBikAJCEeYIMm4
gAxmkIggB3nHOzazJcb+QIXZ6bHIIPZmT0FMYj2RyUw50EEZRIAASnzheoctSJEekIgyq/nQalaE
E2QXAYHlFANx1iyILYDcJYOWqP9d4VFLi62PgEQkGAl1mI5p44HcYMxoQISqC21oIYcxDUuowOwk
IAMOTDEDGAAnBR5gARyAE5Al1pMytIM5UiuEBxWwQBIOoepmO1sRd/BBBWgnMGo9a758xECmcOBr
QE5Av55lMqadbNThldYjX/h0qEVyvVIDiFpEOIS85b3qOjBBBrODgL4foCZoWVsG2cZAt5fL7ToL
WyAVWeAxA42QScjgAkQoRCHmrYhGgDAC+s54AjbAAQ4s4GDeFHOuvf3/ABwMQBgiUHK4L620TJP2
3J7WSEhG1MmJRKILsJzDxBfxhfLWL+MZn4AGOm5rgj2cWrJ8wAB2sAMRFEMYBtcTRUpCdXcbZDV8
sIAExoAHHuA7At2sYv3Q5PEOQmvXTE/7DlCu8kLyd6gtJzeANw3zPaRb5uwOIkoV0gY2SNsCgG+0
DFJwJFhWMbkDK7qHRcD4xjMeBxMoQAGEHYSpWz0hPlhANHxggWtyYBnMQAYIKvBwCZj+9GCHqAUc
kFMdOF4EOzBAAXoA2JX3d9zAm7u5oxxzW4164doaiAM0rwwU0IAHz4hGAEDfAjH74PTQn4G0EpAA
Z9HX9Y03wAEKcIAB/oDAYQc/CQkcEIBoPAMGzoDBM2KwfGa0QAMXOBLg5y8B6V/gAVNowhQogIEV
61kEDXAAPdADTVAJaKBjtgd3KCR3mrZ7nWZ36kZzx0QIV5AQGNAC5Xd+x6B+7Md8KYBN0oZkziIt
E4AAKTAACtBQ8ZIA3NcBKrAMMRB+RfEAzLAM0aAMz/ACLwANyrcMyNACKXABCwA40VKEFPBwRtYE
cjAHhmAEU5AAAzgFYjAHrHZmCVhODPhyvAeBtkJzNUYIs5AQNLgM5VeBV9CDoQeEIZABICADbviG
FBAtRqYAzCAQAVACOSAACFACMngYFqACNRgAgiiIy+CDLQCEJCAD/yWgAV7ViHF4ATOQAFMABxI3
cWM0B6tWhQjoduIWd7nXgC20hXfHbkOBPRSYECFgAchQg4VYiMyQhikAAjdwAStgAydyIm1yARVA
AQXQASvQhzYSAA2AAav4iq/4g0AYiyRwATRQAiqgAggwAxYgA7t4AAcQAjcIjBTSAgYwAySADOB4
iMkoi7uCAQuQJBYgZj3FfQOwDNpYJSnQAROAAZozjuS4AAsAfzLgAGzyACzYfXX4jlVSAmVAfQ+w
MCRgAyRAAvhIMCmCXNtXAAYQAu4okHryAzaAARNgjQYJJxNAfRF5AAaQAy2QjRYpdWBQBV2QawrA
gpLHfQpgAA1ggiMrYJInKWxIsRhfUAU82ZMj0Iwr8AM3qY3E9ntVV3lDWSUBAQA7
--qunrhfwgqyhqbwg
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-ID: <kfvepnq>
R0lGODlhDAAMANUAAP////f3//f39+/v9+/v797m987W787W5sXW5rXF76295qW975y175St75St
3pSlzoyl1oSl5oylzoycxXOU3nOMxWOM5mOM3mOE1lqE3mOEvVKE1lp7xVJ71lJ7zlJ7xVJ7vUp7
zkpzzkpzxVJzrUprvUJrxUJrvUJjtTpjtTpjrTparTpapQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAADAAMAAAIjAABAAhwwMGFCxAQ
CACwkICDDBYSLGjQwQEBhg8zDBAIYIEIBwIQdLjAoOOFgSFMIICwIUMEAxQwCBxhAgKHDh5C6DQA
IIGJEyA4fPAwYoQCAAVKoEgBQsKJEidQ8CyRYumDA1VTqNBQQYXXFQofsPB6AIAKFiweNBTLoiza
BxcFCjgwgQSJCQcWCggIADs=
--qunrhfwgqyhqbwg--
--zqoexfseu
Content-Type: application/x-compressed; name="QTT.zip"
Content-Transfer-Encoding: base64
Content-Disposition: attachment
--zqoexfseu--
- 3
- Visual C#.Net >> SQL syntax highlighting optimizationSorry I posted this post earlier but got the name and subject the wrong way round (new to this!) so it perhaps didn't look right
Sorry for that. But please please answer if you know anything about it..
Thanks
I've got a procedure that is responsible for performing the following operations on a richtextbox
1) determining what parts of the text to forma
2) formatting specific ranges of text a specific color
I need to do this whenever the contents of the richtextbox change. The algorithm is quite fast as I have built in some speed saving optimizations, but i need to do some more, I was wondering if anybody could give me any suggestions? So far, I've coded it to
* - retrieve information about all ranges 'as of now' but only setting the format of ones that are new / only unsetting the format of ones that were there but aren't no
* - only set the format of ranges that are visible. For this, I use the message EM_GETFIRSTVISIBLELINE to get the first visible line, and the line count by dividing the height by the height of a line (got by GetTextMetrics). But then I need to do a rescan of ranges to format on vscroll aswell as on textchange, which is a bit bad as it's slow when you scroll
I was thinking of having some sort of 'lazy updater' type thing that either runs for, say, 100 milliseconds each second, or in a different thread, to update the RTB for the ranges that are off the visible range once all the others have been done, but I can't get my head round how to handle the synchronicity with the fact that when the richtextbox's contents change, the ranges will change too. Should I consider this a thing that takes 'a long time' to happen? Or can anyone else lend a hand with the obviously huge amount of sideways thinking I'm having to do!!
It's for a syntax highlighting control, right now I'm just trying to get it to be able to parse c-style block comments, line comments and quotes (red.
Any ideas on performance in this area
Have posted to C++ groups as although I am writing the app in c# I am non too averse to turn my hand to c++
Thank
- 4
- 5
- 6
- 7
- Dotnet >> How do you set the value member of a combo boxI have recently migrated to VS.Net 2005, and I am struggling to do something
very basic with the combo box. I want to manually loop through a data table
and add both the display text and the value manually. The reason I cannot
bind the combo box to my data table is that there are more than one field
that I want to combine to be the display member. So what I had to do was
create yet another data table at run time (or an array list) and combine the
columns in my new data table so it would display the way I want it to. This
is much more code than simply lookping through my original data table and
adding the item and setting the value manually. I don't want to have to do
this for every combo box in the application. is it possible to set the value
member of a combo box item without binding it to a data source?
I also noticed that when I set the display member to a field that has a
space in it (i.e. [last name]) the value member displays.
- 8
- Visual C#.Net >> InvalidOperationOperationException problemI've posted a related question in this newsgroup before, see google
groups link:
http://groups.google.nl/group/microsoft.public.dotnet.languages.csharp/browse_thread/thread/e9c40ec186b2cb93/8d8051941dd4e2c4?lnk=gst&q=jeroen+invalidoperationexception&rnum=1#8d8051941dd4e2c4
We still experience the problem ever since we migrated from .NET 1.1
to 2.0. Some of the causes (amongst others bad code in destructors)
have been removed, drastically reducing the number of appearances of
of the dreaded 'InvalidOperationException' right after closing the
application.
However, our testers sometimes get an InvalidOperationException
without clear trace (it occurred in 'System.Windows.Forms', pffff)
when they have just closed the application.
My question then is, can you guys help me compile a list of possible
sources for the above kind of problem? To start of with the ones we
already caught:
- Starting new screens/dialogs/forms in destructors;
- Incorrectly disposing a WebBrowser control
- Meddling with the parent of a form
- ....?
Any suggestions would be appreciated
- 9
- Net Framework >> Dynamic properties in Custom ControlHow do I set up my Control to read properties from Web.config at
design time?
Like the OleDbDataConnection Control where the ConnectionString can be
specified through the Web.config file in an tag like this:
<appSettings>
<add key="oleDbConnection1.ConnectionString"
value="Provider=MSDAORA.1;Password=manager;User ID=system" />
</appSettings>
I know I can access the appSettings through
System.Configuration.ConfigurationSettings.AppSettings, but how do I
do it at design time?
- 10
- Net Framework >> "There was an error opening this document"Hi,
I was calling ADOBE acrobat 5.0 's AcroExch.app from Visual basic 6.0.
It was working fine for 1 year.
Last month I installed .net 2003 anf Framwork 1.1 on same pc.
Noe whenever I call Acrobat's AcroExch.app it give me an error...
"There was an error opening this document.the File does not exist"
I uninstalled and reinstalled ADOBE Acrobat again and agin.
But I am still facing same problem.
Any Idea to solve this.
Thanks
- 11
- Net Framework >> Framework Install ErrorHi Folks,
I've hit the dreaded Error 25015 installing Framework 2.0 on WinXP :
---------------------------
Microsoft .NET Framework 2.0 Setup
---------------------------
Error 25015.Failed to install assembly
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.VisualBasic.Vsa.dll'
because of system error: The process cannot access the file because it
is being used by another process.
I've tried the tips online - virus checker, permissions, cleanup tool
etc. No luck. Only process accessing the file is the installer itself.
Any suggestions?
Thanks,
Davy Mitchell
- 12
- Microsoft Project >> time changewhen i change my time under tools/change working time i hit ok when im done
but nothing happens, then when i click on it again it is back to the original
time setting. how do i get it change and stay that way?
- 13
- 14
- Net Framework >> FileSystemWatcher IssueHi,
I have to create a custom app used (FileSystemWatcher) for monitoring
Server1 say \\Stephen-1\Test and if any change happens to this directory, I
take that info and update Server1 say \\Stephen-2\test it works fine. now I
want to make it vice versa too... so I created another app that does the
opposite
Problem: I think there is a lock/access issue and I have no idea how to
solve it.
Please advice,
Stephen
- 15
- Microsoft Project >> Deadline indicators in HTML outputMS Project adds a reverse font red exclamation point in a red diamond to the
Indicator column when a set deadline is missed. However, when I save that
file as an HTML and include the Indicator column in the map, the column is
present but empty of any information (which are all icons in MSP). Having
also included the Deadline as a separate column in the HTML map, those
Deadline dates are present.
Is there a way to indicate a missed deadline in HTML format without the
reader having to compare the Finish and Deadline dates?
Thanks,
Dan
|
| Author |
Message |
Pietro

|
Posted: Wed Feb 21 04:29:58 CST 2007 |
Top |
Visual C#.Net >> Error after calling System.Diagnostics.Process.GetCurrentProcess().StartTime
Hello,
I get some strange behaviour after calling a method on a third party
library when I call:
System.Diagnostics.Process.GetCurrentProcess().StartTime
If I run the following code it works as expected:
try
{
MapInfo.Engine.Session.Current.Catalog.OpenTable(@"C:
\MapApplication\Data\ecw.tab");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
But if I call:
System.Diagnostics.Process
p=System.Diagnostics.Process.GetCurrentProcess();
string time= p.StartTime.ToShortTimeString();
before the above code I get 2 errors:
Form1: MXWinForm.exe - Unable To Locate Component
This application has failed to start because ncsecwex.dll was not
found. Re-installing the application may fix this problem.
Why would making a call to
System.Diagnostics.Process.GetCurrentProcess().StartTime cause
internal errors to be thrown in my third party library?
Regards,
Matthew Lock
DotNet186
|
| |
|
| |
 |
CiaranODonnell

|
Posted: Wed Feb 21 04:29:58 CST 2007 |
Top |
Visual C#.Net >> Error after calling System.Diagnostics.Process.GetCurrentProcess().StartTime
You should probably take this up with the vendor of the 3rd party control.
--
Ciaran O''Donnell
http://wannabedeveloper.spaces.live.com
"Matthew Lock" wrote:
> Hello,
> I get some strange behaviour after calling a method on a third party
> library when I call:
> System.Diagnostics.Process.GetCurrentProcess().StartTime
>
> If I run the following code it works as expected:
>
> try
> {
> MapInfo.Engine.Session.Current.Catalog.OpenTable(@"C:
> \MapApplication\Data\ecw.tab");
> }
> catch(Exception ex)
> {
> MessageBox.Show(ex.Message);
> }
>
> But if I call:
>
> System.Diagnostics.Process
> p=System.Diagnostics.Process.GetCurrentProcess();
> string time= p.StartTime.ToShortTimeString();
>
> before the above code I get 2 errors:
>
> Form1: MXWinForm.exe - Unable To Locate Component
>
> This application has failed to start because ncsecwex.dll was not
> found. Re-installing the application may fix this problem.
>
>
> Why would making a call to
> System.Diagnostics.Process.GetCurrentProcess().StartTime cause
> internal errors to be thrown in my third party library?
>
> Regards,
> Matthew Lock
>
>
|
| |
|
| |
 |
| |
 |
Index ‹ DotNet ‹ Visual C#.Net |
- Next
- 1
- Winforms >> Windows Forms Drawing ProblemThe problem I am having is that under certain circumstances,
text fails to draw in some controls and dialogs. The problem
occurs primarily in the drawing of ListControls and any Dialogs
generated via MessageBox.Show. In the ComboBox, the items are
in the dropdown, and can be moused-over, highlighted and selected.
When an item is selected, the text is visible in the textbox portion
of the ComboBox control. I am not doing any sort of custom or owner
drawing and have not interfered with the firing of events at all.
The problem appears to be localized to a few machines. The text fails
to draw on two of the =seven machines I've tested this application on.
Suspecting an environment issue, I have uninstalled vstudio & .net
and re-installed, to no avail. (I am using .Net 1.1 SP1 & VS2003)
I am able to work around this, using a hack involving
calls to Invoke on a worker thread (The full source is at the end of the
post):
/// <code>
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
#region HACK
// Ensure the handle has been created so the thread can safely call Invoke.
this.CreateHandle();
System.Threading.Thread thread = new System.Threading.Thread( new
System.Threading.ThreadStart( ThreadProc ) );
thread.Start();
#endregion
}
#region HACK
private delegate void voidfunc();
private void ThreadProc()
{
this.Invoke( new voidfunc( EmptyFunc ) );
}
private void EmptyFunc()
{
// Do nothing
}
#endregion
/// </code>
For clarity, this is how I refer to my threads:
"control thread": The thread on which the control/form's constructor was
called.
"worker thread": Any thread that is not the control thread.
Calling Invoke (or BeginInvoke) from the control thread has no effect
on the drawing issue. Making the call from a worker thread is the key to
the hack.
I first suspected that the fix had to do with calling CreateHandle, but it
doesn't.
CreateHandle alone also does not work. It does, however, allow me to safely
call
Invoke from the worker thread without having to worry about timing issues.
(In this
sample code, I first just used Thread.Sleep(1) to pause just long enough for
the
handle to be created elsewhere).
I am quite perplexed by this, and am at a loss to explain the effect of
Invoke.
Any help/suggestions as to a fix or explanation are appreciated.
Thanks,
Nathan Ernst
ernsnat{at)iit(dot}edu
/// <code>
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace DropDownTest
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.ComboBox comboBox1;
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null;
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
#region HACK
// Ensure the handle has been created so the thread can safely call Invoke.
this.CreateHandle();
this.Invoke( new voidfunc( EmptyFunc ) );
#endregion
}
#region HACK
private delegate void voidfunc();
private void ThreadProc()
{
this.Invoke( new voidfunc( EmptyFunc ) );
}
private void EmptyFunc()
{
// Do nothing
}
#endregion
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.comboBox1 = new System.Windows.Forms.ComboBox();
this.SuspendLayout();
//
// comboBox1
//
// this.comboBox1.Font = new System.Drawing.Font("Tahoma", 9.75F,
System.Drawing.FontStyle.Underline, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));
this.comboBox1.ForeColor = System.Drawing.Color.Black;
this.comboBox1.Items.AddRange(new object[] {
"Test1",
"Test2",
"Test3"});
this.comboBox1.Location = new System.Drawing.Point(40, 40);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(121, 24);
this.comboBox1.TabIndex = 0;
this.comboBox1.Text = "comboBox1";
this.comboBox1.SelectedIndexChanged += new
System.EventHandler(this.comboBox1_SelectedIndexChanged);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
this.ClientSize = new System.Drawing.Size(292, 273);
this.Controls.Add(this.comboBox1);
// this.Font = new System.Drawing.Font("Tahoma", 8.25F,
System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));
this.Name = "Form1";
this.Text = "Form1";
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void comboBox1_SelectedIndexChanged(object sender,
System.EventArgs e)
{
}
private void comboBox1_DropDown(object sender, EventArgs e)
{
}
}
}
/// </code>
- 2
- ADO >> Patterns And Practices[Copied from microsoft.public.dotnet.languages.csharp, no answer up to now
and probably was wrong group anyways]
I downloaded the patterns and practices enterprise library and found that it
is much different for the Data library that I am used to (SqlHelper)..It's
not just an update but a total rewrite. Anywho, figured out how to get it
to work which wasn't too hard. What I haven't found and am having trouble
with is updating and inserting into a database. In the SqlHelper library,
there were methods such as ExecuteScalarTypedParams and such which allowed
all parameters to be inside a dataset and you just passed the dataset. This
was great because all of our data access routines returned a dataset. We
would just modify the data and pass this same dataset/table/row back to the
SqlHelper method and it would get updated using our stored procedures in Sql
Server.
Now, afaik, there are no methods which take a dataset for parameters. I
have to manually created the parameters, one by one and then add them to the
collection. Is there a better way, maybe they do exist but I haven't seen
them? Anywho, I could always write a method in my applications that would
take a dataset and build the parameters based on column name, column data
type, and compare vs the stored procedures, but if it already exists, I
don't want to reinvent the wheel.
Thanks in advance,
Mythran
- 3
- Visual C#.Net >> Wishes for enum in future buildsWhen the enum inherients a type it would be nice not to have to do a cast to
that type.
enum MyEnum: int{one=1,two=2}
MyEnum Mine = 1; // no error!
It would be nice to constrain an enum to a function call (makes code easier
to read, and prevents bad calls)
public int MyRouting(enum inEnum{one=1, two=2} ){ return (int)inEnum;}
int i = MyRoutine(one); // enum would only have scope in routine and calls
to routine
- 4
- Visual C#.Net >> Movado Concerto Diamond Ladies Watch 0604416Movado Concerto Diamond Ladies Watch 0604416
Movado Concerto Diamond Ladies Watch 0604416 Link :
http://www.aaa-replica-watch.com/Movado_0604416.html
Buy the cheapest Movado Concerto Diamond Ladies Watch 0604416 in
toppest Replica . www.aaa-replica-watch.com helps you to save money!
Movado-0604416 , Movado Concerto Diamond Ladies Watch 0604416 ,
Replia , Cheap , Fake , imitation , Movado Watches
Movado Concerto Diamond Ladies Watch 0604416 Information :
Brand : Movado Watches (http://www.aaa-replica-watch.com/
Replica_Movado.html )
Gender : Ladies
Model : Movado-0604416
Case Material : Stainless Steel
Case Diameter : 604416, 0604416, Movado-604416, Movado-0604416
604416, 0604416, Movado-604416, M
Dial Color : Black
Bezel : 20 Diamonds
Movement : Quartz
Clasp : Stainless Steel
Water Resistant : 30m/100ft
Crystal : Scratch Resistant Sapphire
Our Price : $ 158.00
Stainless steel case and bracelet. Black dial. Diamond bezel. Scratch
resistant sapphire crystal. Invisible double locking clasp. Quartz
movement. Water resistant at 30 meters (100 feet). Movado Concerto
Diamond Ladies Watch 0604416 / 604416
Movado Concerto Diamond Ladies Watch 0604416 Replica, With the mix of
finest craftsmanship and contemporary styling, not only does it
reflect the time but also care you put into looking good. choose one
to promote your quality and make yourself impressive among
people .Lowest Price Movado Concerto Diamond Ladies Watch 0604416
Thank you for choosing www.aaa-replica-watch.com as your reliable
dealer of quality waches including Movado Concerto Diamond Ladies
Watch 0604416 . we guarantee every watch you receive will be exact
watch you ordered. Each watch sold enjoy one year Warranty for free
repair. Every order from aaa-replica-watches is shipped via EMS, the
customer is responsible for the shipping fee on the first order, but
since the second watch you buy from our site, the shipping cost is
free. Please note that If the total amount of payment is over
$600(USD), the customer is required to contact our customer service
before sending the money in case failed payment. If you have any other
questions please check our other pages or feel free to email us by
service@aaa-replica-watch.com. Cheapest Movado Concerto Diamond Ladies
Watch 0604416
The Same Movado Watches Series :
Movado Dolca Diamond Steel Ladies Watch 0605657 :
http://www.aaa-replica.com/Movado_Dolca_Diamond_Watch_0605657.html
Movado Dolca Mirror Ladies Watch 0605563 :
http://www.aaa-replica.com/Movado_0605563.html
Movado Dolca Mirror Dial Ladies Watch 0605581 :
http://www.aaa-replica.com/Movado_0605581.html
Movado Dolca Gold-Plated Ladies Watch 0605588 :
http://www.aaa-replica.com/Movado_0605588.html
Movado Dolca Large Ladies Watch 0605564 :
http://www.aaa-replica.com/Movado_0605564.html
Movado Dolca Ladies Watch 0605562 :
http://www.aaa-replica.com/Movado_0605562.html
Movado Eliro Mens Watch 0604883 :
http://www.aaa-replica.com/Movado_Eliro_Mens_Watch_0604883.html
Movado Eliro Chronograph Steel Black Mens Watch 0604681 :
http://www.aaa-replica.com/Movado_0604681.html
Movado Eliro Steel Black Ladies Watch 0604133 :
http://www.aaa-replica.com/Movado_0604133.html
Movado 0604424 Eliro Manchette Ladies Watch :
http://www.aaa-replica.com/movado_watch_0604424.html
Movado Eliro Steel and Black Rubber Chronograph Mens Watch 0605773 :
http://www.aaa-replica.com/Movado_0605773.html
Movado Eliro Diamond Ladies Watch 0605470 :
http://www.aaa-replica.com/Movado_0605470.html
- 5
- Dotnet >> about crystal reportsHi,
I have Page Header and Report Footer in my report, the
Page Header display its content on every page. But for
the Report Footer, I don't want to display the Page
Header, or any method to add a page at the end of report
without displaying the Page Header? Thank you.
- 6
- Visual C#.Net >> Catching events from external COM serverHello,
I have a C++ COM server running that fires events (connection points) that
are then caught and processed in C#. So far, I have managed to get some
things to work, but others fail and I do not understand why.
I can pass as parameters: a single unsigned long, a single double, a single
BSTR from one application (unmanaged C++) to my C# app to get processed. I
can also send a VARIANT containing a SAFEARRAY of unsigned longs across and
extract the data. However, when I build a SAFEARRAY of doubles (VT_R8 or
VT_R4) or BSTRs the event does not get caught.
Has anyone else seen this, or have any ideas where I am going wrong? The
only discernable difference in the VARIANTS is the VT field... Unfortunately,
calling the cerver directly from C#, get the loopback to work just fine.
Any help, or ideas would be appreciated.
Andrew S. Giles
- 7
- Net Framework >> .dll, other install programsI'm trying to use 3 .net C++ built dlls in a National Instruments LabWindows
application and include them in the LabWindows (5.5) install. I've installed
the .net 1.1 framework on the target computer, but when I run my application
after the install, I get a "application did not initialize properly
(0xc0000005)" error. This is occuring on a Windows XP machine, sp2. My
application runs fine on the Windows 2000 machines I've installed it on and
the older versions of my app that use a Visual C++ 6.0 built dll run fine on
the XP machine. What is going on? Do I need to do something special in the
registry or something for the .net built dlls under Windows XP? Thanks!
I've also posted this under .net-general discussion since I didn't know
really which was more appropriate...sorry about the double-posting
- 8
- Net Framework >> Where to dispose whatCan you please give simple examples of objects that would be disposed in both
of the below commented sections. E.g where should SqlConnection, SqlCommand,
DataSet, File, Label, collection objects go?
private override void Dispose(bool disposing)
{
if (disposing)
{
// Release managed resources (examples?)
}
// Release unmanaged resources (examples?)
base.Dispose(disposing);
}
Thanks,
Pete
- 9
- Winforms >> Please help!Hi,
I'm having some strange problem in a windows application
in vb.net. On my form I have two ListBox, and when I try
to add or remove items from the: myListBox.Items, I have
the following error message:
"The list that this enumerator is bound to has been
modified. An enumerator can only be used if the list
doesn't change."
Any idea what happens?
I have not bound the Listbox to anything.
thanks,
Tina
- 10
- 11
- Visual C#.Net >> another question about menu bitmapsI've experimented around with the menu bitmaps but none of
the sample code and app's I've tested with can show me how
to add a bitmap to a context menu. I've created an app
with no main form that resides in the system tray with
around 15 menu items. I've been asked to put icons next
to the menu's and i'll be dammed if i can figure out how
this is done.
The c# example code I've found on the web has been amazing
along with xp xml theme control and xp-style balloon tool-
tips but, adding an icon/bitmap to a context menu has
eluded me.
Anyone have any tutorials or code samples so I can see how
its done?
Thanks again.
- 12
- ADO >> Enterprise Library DeriveParams with Multiple Owner Schemas SQL 2kHi
I am having some issues with the above. Apologies if this is the wrong
forum, perhaps someone will point me to the correct one.
Basically the issue is this:
(using SQL Server 2k sp4, EnterpriseLibrary).
Create procedure dbo.TestProc @param1 int, @param2 int
as select 'hi'
go
Create procedure bob.TestProc @param1 int
as select 'hi'
go
When we get derive params for bob.TestProc it returns the wrong number
of params, apparently the total number for all TestProc procedures.
If anyone knows what I am talking about, I would love to have some
feedback!
- 13
- Visual C#.Net >> re:Binary "Database" for a game - please helpNo one knows? Or did I just confuse everyone with my rambling?
If you are unclear on what I am asking, or have any other questions
before forming a suggestion, please let me know. I am avidly
searching the web for my answer, and checking back here. Would
really appreciate the help, thanks!
Daedric
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com
- 14
- Microsoft Project >> Is it possible to import data from ONE txt file?I need to set up a project scheduling problem importing
data from *.txt file. Can I finish this with only ONE txt
file or do I need several txt files with each imported to
one table of the project? (For example, one txt file
imported to task information table, on imported to
resource table and one to the precedence relation table)
Thanks a lot!
- 15
- ADO >> Oracle input parameter of type string problemI created a new Web app and added a label and a button to the page.
I added the following code which compiles and executes correctly and returns
records:
-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim OracleSelectCommand1 As System.Data.OracleClient.OracleCommand
Dim OracleConnection1 As System.Data.OracleClient.OracleConnection
Dim OracleDataAdapter1 As System.Data.OracleClient.OracleDataAdapter
Dim dt As New Data.DataTable("DenseReport")
OracleSelectCommand1 = New System.Data.OracleClient.OracleCommand
OracleConnection1 = New System.Data.OracleClient.OracleConnection
OracleDataAdapter1 = New System.Data.OracleClient.OracleDataAdapter
OracleSelectCommand1.CommandText = "SELECT DRE_YEAR FROM DENSEREPORT
WHERE DRE_YEAR = '2001'"
OracleConnection1.ConnectionString = "user id=blah;data
source=blah;password=blah"
OracleSelectCommand1.Connection = OracleConnection1
OracleDataAdapter1.SelectCommand = OracleSelectCommand1
OracleDataAdapter1.Fill(dt)
Label1.Text = dt.Rows.Count.ToString
End Sub
-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/
The query above returns records. The following code does not, but it doesn't
cause an error.
-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim OracleSelectCommand1 As System.Data.OracleClient.OracleCommand
Dim OracleConnection1 As System.Data.OracleClient.OracleConnection
Dim OracleDataAdapter1 As System.Data.OracleClient.OracleDataAdapter
Dim dt As New Data.DataTable("DenseReport")
OracleSelectCommand1 = New System.Data.OracleClient.OracleCommand
OracleConnection1 = New System.Data.OracleClient.OracleConnection
OracleDataAdapter1 = New System.Data.OracleClient.OracleDataAdapter
OracleSelectCommand1.CommandText = "SELECT DRE_YEAR FROM DENSEREPORT
WHERE DRE_YEAR = :pYear"
OracleSelectCommand1.Parameters.Add(New
System.Data.OracleClient.OracleParameter("pYear", "2001"))
OracleConnection1.ConnectionString = "user id=blah;data
source=blah;password=blah"
OracleSelectCommand1.Connection = OracleConnection1
OracleDataAdapter1.SelectCommand = OracleSelectCommand1
OracleDataAdapter1.Fill(dt)
Label1.Text = dt.Rows.Count.ToString
End Sub
-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/
Adding a : character before pYear in the OracleSelectCommand1.Parameters.Add
call makes no difference. I still get no records.
Can anyone tell me what's wrong? The database server is running Oracle 9i. I
have installed Oracle client 8.1.5 on my development machine.
Any help would be much appreciated.
Brian
|
|
|