|
I have a stored procedure which have a return value and a output parameter .I know how to get the value of this parameter but I need to get value of return value too but I don't know how. Thanks
Mazy
No sig. available now.
|
|
|
|
|
On your SqlCommand, add a parameter (whatever name you want, the command builder typically uses @RETURN_VALUE if you want to be consistent). Set the direction parameter in the SqlParameter constructor (or use the Direction property after the SqlParameter is created) and set it to ParameterDirection.ReturnValue. Add this SqlParameter to the command's SqlCommand.Parameters collection. After executing the command, check the SqlParameter.Value.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Thanks for reply. I use the way you said but when I execute my code I got unhandled error which say my stored procedure expects parameter @RETURN_VALUE which was not supplied. If I delete the row that said Parmater.Direction is ReturnValue then this error does not occured but of course I don't get any return value.Should I add anything to my stored procedure defenition like the way I do for Output parameter?
Mazy
No sig. available now.
|
|
|
|
|
First, you have to make sure you're using a stored proc by setting the SqlCommand.CommantText to the stored proc name, and the SqlCommand.CommandType to CommandType.StoredProcedure. The line that the SQL builder outputs looks something like:
cmd.Parameters.Add(
new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4,
ParameterDirection.ReturnValue, false, ((Byte)(10)), ((Byte)(0)), "",
DataRowVersion.Current, null));You use check out the documentatoin for the respective SqlParameter constructor to see what everything means. Basically, a lot of parameters are just fillers so you could create the SqlParameter with the default constructor or a shorter constructor, then assign the properties the way you want.
You should also try playing around with the features that VS.NET provides, like using the Server Explorer to find the Stored Procedure you want and drag it to your form. You can also do this with SqlDataAdapter and many other things like tables (which is especially nice when making strongly-typed DataSet classes). Normally, I don't like "drag-n-drop programming" but in cases like this it sure saves a heck of a lot of time!
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Apparently, PrintOut is not a blocking call, so it's trying to quit immediately after printing. You should check for optional parameters for the Quit method to see if you can override the prompt. I remember seeing one previously.
You should also use synchronous printing, if possible (depends on the COM implementation, so read the Word developer documentation). This should give time for Word to print and then you can quit.
As far as not showing the application, this has been covered before in this forum countless times. It has to do with using a ProcessStartInfo class in Process.Start. Search the comments (always a good idea to do first anyway) for more information.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
one Windos Service is making by C#.NET
when order to Stop service but Service is Some Processing... not Finish
so.. i want to Message Box ("Can not Stop Serveice") ..or
this service can not stop until Service is Some Processing Finish
i want to make
if (someprocessing finish)
{ service.Stop();}
else wait Service.Stop();
How to coding ~~ i do not know~~!!!!!
|
|
|
|
|
I don't know I get your problem correctly but this is I can tell you:
indows service has CanStop property,set it to false and after your proccessing finished set it to true.
CanStop = false;
if(job is done)
CanStop = true;
Mazy
No sig. available now.
|
|
|
|
|
Client --- Unix..
Server --- windows 2000
how does recognize what a data type client send to server?
.................................................................
How to Know server dataType this is Receive Data from Client ???
..................................................................
client send Data
server receive data .. how to konw dataType
if DataType is picture or avi file than save to the other file name and same file type
if DataType is sting than order to SQL Server... "select~~~~from~~~where" + string
if DataType is XML file than save to XML file
Please answer me..
i m Socket Programing at first
|
|
|
|
|
Before sending the data send a datatype maybe as a enumerated type, integer or string.
Maybe create a struct that has a datatype field?
Just some ideas...
HTH
Luke
|
|
|
|
|
You should search CodeProject. There is lots of examples and topics regarding socket programming.
How do you know the data types? You're the one sending and receiving them, so you dictate what those structures are. If you didn't create these structures for either the client or the server, then you need to consult the documentation for the socket client or server that you're trying to talk to. As far as sending files, you just send them using a buffer (a Byte[] array) as is. For strings and XML, just send the character data using the proper encoding (see System.Text.Encoding for more information). You get the Byte[] array for the characters based on an agreed encoding between client and server. You can either assume a single encoding between the two, or send data (much like HTTP, SMTP/MIME, etc.) using an encoding that one dictates.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
hi
i making a program to make dial-up connection and connecting to the net ,i dial with numbers stored in database , i use win API
like(InternetDial() ,InternetHangUp()), but i have two problems
1)InternetDial is dialing with default network connection on pc.
i need to make it taking numbers from database.?????
2) i want to create a new dial-up connection on pc, idont now what function i can use
thank u for advanced help
send me on hz_csharp@hotmail.com
|
|
|
|
|
Assuming you're the same person as before, I already covered this with you: http://www.codeproject.com/script/comments/forums.asp?msg=694424&forumid=1649#xx694424xx[^]. InternetDial can accept a phone number to dial.
Also, creating an actual connection file/config seems to be platform dependent. You should search MSDN Online for ways to do this.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
it try to use internetdial() to take numbers,but i can't because it take name of connection to dial with (existing connecton on pc) as a parameter
plz tell me how to make it take numbers
|
|
|
|
|
I am after a component that will enable users to resize visual objects such as an image at runtime. Just like in a standard art package.
I wrote 1 myself in Delphi and I could port it to C# but I am not sure how I would implement some of the Mouse capture routines...
Besides there must be an open source control that I can use/develop further to achieve what I want.
TIA and Merry Christmas
Luke
|
|
|
|
|
Jinwah wrote:
Besides there must be an open source control that I can use/develop further to achieve what I want.
Well, did you try searching for one? There should be plenty of examples here on CP.
Also, read the documentation for the System.Windows.Forms.Control class. That has all the mouse events and properties you need to do this.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
I am new to C#. I am developing a small windows application to train myself with. I faced an issue and can't figure out a good approach to it.
My application needs a few configuration settings that shall be available for altering from users interface. I can build a form etc. but the problem is that I don't know how to keep custom settings. I tried application configuration file, defining a custom section and using IDictionary class instance for reading them. Well, I can read them but can't save them as they only get saved in System.Collections.IDictionary and don't get saved in the application config file.
Is there any simple way to arrange custom configuration and read-write it?
Can someone share a simple understandable example of it?
I hope I explained it clear enough.
Thank you all.
|
|
|
|
|
Take a look at the "Isolated Storage" in the docs and also have a look at this[^] article.
Regards,
Kannan
|
|
|
|
|
I guess this might help and I am trying to read the article.
However, the code in the article looks bit complicated. Can you (someone) maybe give me a simple example of reading/writing a couple of settings?
like nick : real name?
thanks a lot lot lot!
|
|
|
|
|
The .config file is just an XML file, so use the System.Xml namespace elements to append/insert/delete your settings. Note that this will not update your configuration options while the process is running. For information on how to do that, search the comments for this forum for keywords like AppDomainSetup because I've already covered how to do this a couple times. Of course, you could always update your settings in the running, cached instance if you provide an instance property for your configuration section object (which the IConfigurationSectionHandler implementation creates) and update your UI accordingly.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Look at XML serialization. You can create an xml file that contains your app settings. You would simply 1. open a file stream 2. create xml formatter 3. serialize the settings you choose to the xml file.
Take a look at serialization. You could use the .config file but this is read only, therefore you cannot create a user interface to modify it.
|
|
|
|
|
And if the config file contained other stuff not for his section? This would NOT be a good idea because the other IConfigurationSectionHandler implementations provided in the .NET BCL do not use XML serialization. XML Serialization would wipe out the file and create a new one (based on your stream preferences).
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
For a simple solution take a look at my Profile article[^].
Regards,
Alvaro
He who laughs last, thinks slowest.
|
|
|
|
|
How can i create a new datatable in a database ?
We have a connection and a dataadaptor .
I mean programically.
Regards' Amir Jalaly
life is tow days'
one is paid for love someone '
and one day is paid for hate him'
|
|
|
|
|
|
I want to convert this code from vb.net to c#.net:
Declare Function ExitWindowEx Lib "User32" (Byval l as long ,Byval s as long ) as long or this:
Declare Function FormatMessage Lib "kernel32" Alias _<br />
"FormatMessageA" (ByVal dwFlags As Int32, ByVal lpSource As Int32, _<br />
ByVal dwMessageId As Int32, ByVal dwLanguageId As Int32, _<br />
ByVal lpBuffer As StringBuilder, ByVal nSize As Int32, ByVal Arguments As Int32) _<br />
As Int32
what is equal for Declare and lib in C#?
Regards'Amir Jalaly
life is tow days'
one is paid for love someone '
and one day is paid for hate him'
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
