C# Discussion Boards - CodeProject

Paul Unsworth6-May-10 23:57

Paul Unsworth

6-May-10 23:57

Thats it??? D'Oh! | :doh:

So simple. I'm kicking myself now. Thank you.

oooo, the Jedi's will feel this one....

OriginalGriff7-May-10 0:12

7-May-10 0:12

You're welcome - technically you don't need the brackets, but I always feel they help to make it more readable (if a regex can be described as readable... Laugh | :laugh:

)

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

OriginalGriff6-May-10 23:57

6-May-10 23:57

Before I forget - have a look at Expresso[^] - it examines, creates and explains regular expressions. It works, it helps you understand how they work, and it's free.

Generate Sequencial Number

Paul Unsworth7-May-10 0:00

Paul Unsworth

7-May-10 0:00

Excellent. Thanks. I'm new to regular expressions, and they appear very alien so far.

Muchas Gracias Big Grin | :-D

oooo, the Jedi's will feel this one....

Zoomlion6-May-10 22:44

Zoomlion

6-May-10 22:44

Guys,
I am using C# with MSS 2005. I need to generate a sequential number for a field (ItemNo) in the format ddmmyyyy000000x where x is a sequencial number eg (020520100000001,020520100000002, 020520100000003 ...) for records generated on May 2, 2010.
Can any one help in this regard.

OriginalGriff6-May-10 22:47

6-May-10 22:47

So do it - what is the problem?

Zoomlion6-May-10 23:03

Zoomlion

6-May-10 23:03

I have something similar in VB6 with MDB but have difficulty using C# and MSS. See my VB6 code below and advice on how to produce something similar in C#.
Public Sub GenerateCode(ByRef Coder As String)
Dim strMar As String, intApr As Integer
Dim strJul As String
Coder = UCase(Coder)

Dim rs As New ADODB.Recordset
Dim cn As New ADODB.Connection
On Error GoTo AddNewErr
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Manager.mdb"
rs.Open "select ItemNo from Items where left(ItemNo,8) like '" + Coder + "' order by ItemNo asc", cn, adOpenKeyset, adLockOptimistic

If rs.RecordCount <> 0 Then
rs.MoveLast
If Left(Trim(rs.Fields!ItemNo), 8) = Coder Then
strMar = Right(Trim(rs.Fields!ItemNo), 6)
strMar = Val(strMar) + 1
strMar = CStr(strMar)
If (6 - Len(strMar)) <> 0 Then
strMar = String$(6 - Len(strMar), "00000") & strMar
End If
Else
strMar = "000001"
End If
Else
strMar = "000001"
End If
Coder = Coder & strMar
Editor = Coder
Set rs = Nothing
Set cn = Nothing
Exit Sub
AddNewErr:
MsgBox Err.Description, vbExclamation, "Error Report"

End Sub

OriginalGriff6-May-10 23:25

6-May-10 23:25

So, what you are doing is:

1) Read the last record (presumably for this month) from your database.
2) If it doesn't exist, use a default of 1.
3) If it does, strip out the last 6 characters, convert to int, add one to it and use that.
4) Reattach that to the code for this month.

Ignoring that you seem to have a fetish over naming your variables after months of the year, and the "str" prefix is a bit of a waste of time, since half way through you hold integers in them.

What is the bit that is giving you problems? Apart from the whole approach, which is frankly rubbish?

If you must have an item number that is a string, with a date and a sequence number, then:

1) Read the last record.
2) Assume none: set integer default to 0 in variable called nextSequenceNumber
3) If record exists, extract last 6 characters, and parse to int. Store in nextSequenceNumber.
4) Return date code + (nextSequenceNumber + 1).ToString("000000")

Assume the database will contain corrupt data - use TryParse rather than parse, and log any failures. Try to deal with them nicely.

Luc Pattyn7-May-10 2:15

Luc Pattyn

7-May-10 2:15

There is a lack of PRE tags, semi-colons and curly braces. These codez don't belong here.

Frown | :(

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

OriginalGriff7-May-10 4:02

7-May-10 4:02

PRE tags, semi-colons and curly braces are the least of the problems! Even by VB standards, that is some clumsy code...

nagendrathecoder6-May-10 23:04

nagendrathecoder

6-May-10 23:04

You just need to concatenate all strings, "your datetime string" + "000000" + your value of x.
Are you facing any problem in this?

Peace ON6-May-10 23:05

Peace ON

6-May-10 23:05

Ya what is the issue?

Where you stuck ??

Jinal Desai - LIVE
Experience is mother of sage....

Peace ON6-May-10 23:22

Peace ON

6-May-10 23:22

Following code will help you to achieve what you want in C#.

string temp="0000000";
int i=10;
string finalstring=DateTime.Today.ToString("ddMMyyyy") + temp.Substring(0, temp.Length - i.ToString().Length) + i.ToString();

Hope this will help!

Jinal Desai - LIVE
Experience is mother of sage....

Generate Error While Build Dll

#realJSOP6-May-10 23:25

#realJSOP

6-May-10 23:25

So create a static int variable (I would do this in a global static class), and increment it from anywhere in the code.

public static Globals
{
    public static int counter = 0;
}

Then, when you create your string, do it this way:

Globals.counter++;
string id = string.Format("{0}{1:0000000}", myDate.ToString("ddMMyy"), Globals.counter);

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Anubhava Dimri6-May-10 21:29

Anubhava Dimri

6-May-10 21:29

Hello Everybody,

I have generate an error while building on Dll

Cannot register assembly "MYDLL.dll" - access denied. Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Thanks

If you can think then I Can.

Bernhard Hiller6-May-10 21:40

Bernhard Hiller

6-May-10 21:40

Can you register it with regsrv32? You need administrative privileges for registering a dll, because it writes some data to HKEY_CLASSES_ROOT in the registry.

Anubhava Dimri6-May-10 21:43

Anubhava Dimri

6-May-10 21:43

How can i register it. Because Error is generate while i am Compiling my dll.

If you can think then I Can.

Vimalsoft(Pty) Ltd6-May-10 21:56

Vimalsoft(Pty) Ltd

6-May-10 21:56

Is this a .NET DLL ?

This Simply means you don't have permissions to create Files in that local drive.

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Anubhava Dimri6-May-10 22:16

Anubhava Dimri

6-May-10 22:16

But I am Running Visual Studio in Administrative mode. and if i am block some code then it will working fine.

If you can think then I Can.

Vimalsoft(Pty) Ltd6-May-10 22:31

Vimalsoft(Pty) Ltd

6-May-10 22:31

Your are running into permissions , look at this

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/81e3d2a8-33f9-458d-a053-4da85af0591c[^]

http://www.sitefinity.com/support/forums/sitefinity-3-x/deployment/access-is-denied-exception-from-hresult-0x80070005-e-accessdenied.aspx[^]

DataSet to List<>

Illegal Operation6-May-10 17:43

Illegal Operation

6-May-10 17:43

Hi!

How can I take data from a dataset and populate a List<>()?

Illegal Operation

Luc Pattyn6-May-10 17:51

Luc Pattyn

6-May-10 17:51

A List of what type?
You could use Add to add an instance of type T to a List<T>
You could use Add to add a DataSet to a List<DateSet>
So what is it you want?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

Illegal Operation6-May-10 17:55

Illegal Operation

6-May-10 17:55

I need to create a list of type Dataset. Here is my code at the moment

List<<DataSet>> dsList = new List<<DataSet>>();

dsList.Add(payClass.GetPayItems());

How would I bind that list to a ListBox?

P.S - I added to << and >> because when posting it removes it.

Illegal Operation

Luc Pattyn6-May-10 18:06

Luc Pattyn

6-May-10 18:06

A ListBox can hold and show all kinds of items; by default, it calls ToString() on each of its items to visualize them.

There is an alternative by turning the ListBox into "OwnerDrawn" mode, which means you set out to provide all the code required to paint one item, see the DrawItem event.

If you were to bind a List<DataSet> to a ListBox, it would turn each DataSet into a single item in its collection; unless your DataSet has overridden its ToString() method, the net result would be something similar to the string "System.Data.DataSet" which I guess is not what you want. And painting a DataSet yourself would be a challenge.

So I think you are tackling this the wrong way. I'm not so sure what it is you really want to achieve.

PS: you can get proper < > & signs by using the little widgets above the editor box.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.