Re: How to generate base64 random number - C# Discussion Boards

mrkeivan22-Feb-08 22:05

22-Feb-08 22:05

Hey guys, I'm using stored procedure to insert data to my database, I works perfectly. after clickin the button it inserts the information. but when I again want to enter new information and press the button I get this error >> Procedure or function ExpenseEntery has too many arguments specified.

<br />
                //Insert the Info<br />
                InsertCmd.Connection = MyCon;<br />
                InsertCmd.CommandType = CommandType.StoredProcedure;<br />
                InsertCmd.CommandText = "ExpenseEntery";<br />
<br />
                InsertCmd.Parameters.Add("@ID", SqlDbType.Int).Value = GetID;<br />
                InsertCmd.Parameters.Add("@ClientID", SqlDbType.Int).Value = UserID;<br />
                InsertCmd.Parameters.Add("@ExpenseID", SqlDbType.TinyInt).Value = SelectedExpense;<br />
                InsertCmd.Parameters.Add("@DateOfPurchase", SqlDbType.VarChar, 8).Value = SelectedDate;<br />
                InsertCmd.Parameters.Add("@Cost", SqlDbType.Money).Value = Convert.ToInt64(Cost_tb.Text);<br />
                InsertCmd.Parameters.Add("@Number", SqlDbType.Int).Value = Convert.ToInt32(Number_tb.Text);<br />
                InsertCmd.Parameters.Add("@TotalCost", SqlDbType.Money).Value = Total;<br />
                InsertCmd.Parameters.Add("@Comment", SqlDbType.NVarChar, 300).Value = Comment_tb.Text;<br />
                InsertCmd.Parameters.Add("@DeleteFlag", SqlDbType.Bit).Value = "false";<br />
<br />
                MyCon.Open();<br />
                InsertCmd.ExecuteNonQuery();<br />
                MyCon.Close();

Re: Stored procedure in C#

Hesham Amin22-Feb-08 22:38

Hesham Amin

22-Feb-08 22:38

seems that you use InsertCmd again without clearing its parameters.
Clear the command parameters or create a new instance.

Hesham A. Amin
My blog

Re: Stored procedure in C#

mrkeivan23-Feb-08 9:25

mrkeivan

23-Feb-08 9:25

thanx buddy ! it solved the problem !!!

Mr.K

Re: Stored procedure in C#

PIEBALDconsult23-Feb-08 14:56

PIEBALDconsult

23-Feb-08 14:56

Or only add them the first time.

Re: Stored procedure in C#

ali_reza_zareian22-Feb-08 22:40

ali_reza_zareian

22-Feb-08 22:40

Yes.thats right
Because every time that you execute your methode, InsertCmd object define some parameter with same name.
Define InsertCmd in local manner.

How to generate random number [modified]

D i x y22-Feb-08 20:50

D i x y

22-Feb-08 20:50

Hello Everybody,
I need help for generating Random Numbers......
and need to add current system date with that generated number....

Please help

Thanks

modified on Saturday, February 23, 2008 4:45 AM

Re: How to generate base64 random number

Hesham Amin22-Feb-08 22:36

Hesham Amin

22-Feb-08 22:36

base64 is an encoding not a number system, what do you need to do exactly? generate a number then encode it ?

Hesham A. Amin
My blog

Re: How to generate base64 random number

D i x y22-Feb-08 22:45

D i x y

22-Feb-08 22:45

Hi,
its a mistake in writting question.
i want to generate random numbers that unique with a combination of current date...

means if my random number is 757454584 then its will never generate again so i want some extra digits at the end for unique number that i think the current date 757454584 + 230208
so it will give me the perfect random number...

But i am unable to achive this..
can u help me...

Re: How to generate base64 random number

Gareth H23-Feb-08 0:08

Gareth H

23-Feb-08 0:08

Dikshant,

Random random = new Random();
string randomString = (DateTime.Now.ToString() + "_" + random.Next().ToString());
random.Dispose();

Above gives you "23/02/2008 11:08:23_3243243242"

Re: How to generate base64 random number

Christoph Menge23-Feb-08 0:17

Christoph Menge

23-Feb-08 0:17

Hi,

what exactly are you trying to accomplish? Do you need a specific distribution, or a constant length, for example?

If you just need some keys that do not collide, i.e. keys which are (almost) unique, you might want to take a look at UUIDs or GUIDs. They are time-based, but in a more subtle manner. Their length is constant. However, they are usually written in hexadecimal strings, e.g.: {2AED1BB2-7314-43e9-9DE7-8AAB3BBC20C1}.

Or do you just need something like

Random a = new Random();<br />
string x = String.Format("{0}{1}", a.Next(), DateTime.UtcNow.Ticks);

?

yielding, for example, this:

"2143552667633393651580403445"

Note that this has a variable length, because

a.Next()

returns some number which can be shorter or longer.

Also note that a, if initialized without a seed will use the system time as seed, thus creating completely different numbers on each run (these alone, however, have a rather large chance of colliding).

In general, there are no keys which can *never* collide (unless they have infinite legth...), but you can make it extremely unlikely to happen.

Hope that helps,

Chris

"Obstacles are those frightening things you see when you take your Eyes off your aim"
- Henry Ford

Articles
Blog

Re: How to generate base64 random number

Guffa23-Feb-08 0:25

Guffa

23-Feb-08 0:25

Please avoid removing a question that someone already has replied to. It's a bit confusing to read replies to a question that has changed completely. You can ~~strike out~~ text when you edit the question.

You can use the Ticks property to get a DateTime value as a number.

You should use DateTime.UtcNow rather than DateTime.Now to get the time. The local time is affected by daylight savings time, so it's not unique, i.e. once a year it overlaps for an hour.

string id = myRandomNumber + "_" + DateTime.UtcNow.Ticks.ToString();

But if you want a unique random number, why are you not using a GUID?

Despite everything, the person most likely to be fooling you next is yourself.

Re: How to generate base64 random number

D i x y23-Feb-08 0:53

D i x y

23-Feb-08 0:53

Thank you all for solution....

And Sorry that i have to edit it.....

Again thanks

Dikshant

Re: How to generate base64 random number

Hesham Amin23-Feb-08 5:24

Hesham Amin

23-Feb-08 5:24

You can use GUIDs. or use Cryptography classes (as RNGCryptoServiceProvider) to generate the random value.
The advantage of using RNGCryptoServiceProvider is that you can select the length of the generated value.

Here is an example (I choosed the length = 50):

using System.Security.Cryptography;
.
.
.
byte[] data = new byte[50];
RNGCryptoServiceProvider rand = new RNGCryptoServiceProvider();

for (int i = 0; i < 50; i++)
{
    rand.GetBytes(data);

    string s = Convert.ToBase64String(data);

    Console.WriteLine(s);
}

Hesham A. Amin
My blog

C# windows service is not showing in Control panel services

Satish - Developer22-Feb-08 20:12

Satish - Developer

22-Feb-08 20:12

Hi, i have written one windows sevice and i have been build that service.
An exe file is generated for that service. using installutil.exe that file has been installed. but the service is not showing under Administrtaivetools->services.

Is the service not created? or any other reason.
I am getting succesful message in command prompt after using istallutil.
please help me regarding this.

G. Satish

Re: C# windows service is not showing in Control panel services

Mohammed Shahab23-Feb-08 1:36

Mohammed Shahab

23-Feb-08 1:36

Dear try (RegSvcs.exe) utility provided in .net framework to register services.

Regards Big Grin | :-D

How to get clear figure in windows application?

Aravinthan22-Feb-08 19:25

Aravinthan

22-Feb-08 19:25

Hi friends..
I am working in windows application(MDI).I am using graphicspath method to draw the figure..some time i got output as bezier figure instead of normal figure...for example to draw straight line(both vertical and horizontal) i got output as normal figure... other than straight line i got bezier figure as output... how to avoid this.....

Re: How to get clear figure in windows application?

Christian Graus22-Feb-08 19:41

Christian Graus

22-Feb-08 19:41

I"m not sure I follow. Sometimes your path draws a bezier ? I guess the question is, where does the path come from, and why can't you just not create it as a bezier path ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: How to get clear figure in windows application?

Aravinthan22-Feb-08 21:59

Aravinthan

22-Feb-08 21:59

hi friend..
path draws normal figure but the figure(visual ) is like bezier figure...

VTD-XML 2.3

Jimmy Zhang22-Feb-08 19:00

Jimmy Zhang

22-Feb-08 19:00

VTD-XML 2.3 is now released. To download the latest version please visit http://sourceforge.net/project/showfiles.php?group_id=110612&package_id=120172.[^]

Below is a list of new features and enhancements in this version.

* VTDException is now introduced as the root class for all other VTD-XML's exception classes (per suggestion of Max Rahder).
*Transcoding capability is now added for inter-document cut and paste. You can cut a chuck of bytes in a UTF-8 encoded document and paste it into a UTF-16 encoded document and the output document is still well-formed.
*ISO-8859-10, ISO-8859-11, ISO-8859-12, ISO-8859-13, ISO-8859-14 and ISO-8859-15 support has now been added
*Zero length Text node is now possible.
*Ability to dump in-memory copy of text is added.
*Various code cleanup, enhancement and bug fixes.

Below are some new articles related to VTD-XML

*Index XML documents with VTD-XML http://xml.sys-con.com/read/453082.htm[^]
*Manipulate XML content the Ximple Way http://www.devx.com/xml/Article/36379[^]
*VTD-XML: A new vision of XML http://www.developer.com/xml/article.php/3714051[^]
*VTD-XML: XML Processing for the future http://www.codeproject.com/KB/cs/vtd-xml_examples.aspx[^]

If you (or someone you know) like the concept of VTD-XML, think that it can help solve enterprises' XML processing related issues (particularly those related to SOA), and would like to directly influence and contribute to the development of the future of Internet, please email me (crackeur@comcast.net). We are looking for open source software developers and project management people to take VTD-XML to the next level.

Re: VTD-XML 2.3

Christian Graus22-Feb-08 19:05

Christian Graus

22-Feb-08 19:05

So, write an article here on CP, instead of making an off topic post that will be lost for all time within a half day.

Re: VTD-XML 2.3

Jimmy Zhang22-Feb-08 19:16

Jimmy Zhang

22-Feb-08 19:16

Thanks for the suggestion. STill new to CP..

Failed to load provider type

paulb22-Feb-08 18:27

paulb

22-Feb-08 18:27

I'm getting an exception thrown when trying to use a 3rd party library from my DLL, it works fine if I use this library from an Exe but not the DLL. I suspect its to do with it trying to access a config file. This is (part of) the stack trace:

Inner Exception: Failed to load provider type: ERSP.Utilities.Configuration.LocalFileModuleSettingsProvider, xFx, Version=2.1.2868.1848, Culture=neutral, PublicKeyToken=null. (ConfigurationErrorsException)<br />
Stack:<br />
  at System.Configuration.ApplicationSettingsBase.get_Initializer()<br />
  at System.Configuration.ApplicationSettingsBase.CreateSetting(PropertyInfo propInfo)<br />
  at System.Configuration.ApplicationSettingsBase.EnsureInitialized()<br />
  at System.Configuration.ApplicationSettingsBase.get_Context()<br />
  at System.Configuration.ApplicationSettingsBase.set_SettingsKey(String value)<br />
  at xFx.Properties.Settings..ctor()<br />
  at xFx.Properties.Settings..cctor()

It looks like its using a custom configuration provider, maybe its just buggy? and maybe it will work if the config file is avialble so... Is it possible to have an app.config file with a DLL? I tried adding one to the project, didn't seem to help.

Re: Failed to load provider type

Hesham Amin22-Feb-08 22:40

Hesham Amin

22-Feb-08 22:40

You have to put the config file with the exe that references the dll, you can't have a separate app.config for the dll.

Hesham A. Amin
My blog

Re: Failed to load provider type

paulb23-Feb-08 0:36

paulb

23-Feb-08 0:36

ah well, I thought I could find a way around the problem but you pretty much confirmed what I was thinking. thanks,

OpenVPN bandwidth controlling

vikramspce198322-Feb-08 17:38

vikramspce1983

22-Feb-08 17:38

Hi every one
I am developing one application. In that application I am developing one software tool or wondows. With help of that window I wantto control protocoles of the internet. For that I need to identify protocol or packet and test it and then after decide to accept or drop that packet.

For this purpose I am using "OpenVPN" and creating two ports and programming in between those two terminal.

But I an cofused is tehre any sources available for that or is that a right base or any simple method is possible ?

Thanks

Confused | :confused:

vikram d patel

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.