generate numbers for form data

Question

3.33/5 (2 votes)

See more:

Hi :) I have some form data that is stored in the database and each form has a ref num..So here is the problem

Suppose i have four ref numbers of the forms say 001,002,003,004 I want 001 and 003 grouped together and generate a number say 1,then i want 002 and 004 grouped together and generate a number say 2.

So in the DB it will look like

C#

Name Desig Ref ID
xyz   abc  001  1
abc   asd  003  1
def   sed  002  2
fgh   hjk  004  2

Can someone let me know how to implement this on c# and SQL..I just want the basic logic on how to do this and not the code...should i use datagrid?if so then how do i work on grouping the ref numbers?

Posted 11-Sep-13 6:07am

Member 10066916

Updated 11-Sep-13 6:12am

Thanks7872

v2

Add a Solution

Comments

phil.o 11-Sep-13 12:12pm

What is the logic behind? You gave an example but it is far from describing the logic.
For example, what about if your 'ref numbers' are 002, 005, 010, 027 and 152? What is the logic deciding of the grouping?

Member 10066916 11-Sep-13 12:13pm

that is upto the admin to group whichever ref numbers he/she wants to

Member 10066916 11-Sep-13 12:14pm

the admin can group 002 or 005 or maybe 010 or 152 anything...

i.fakhari 11-Sep-13 13:04pm

hithe user makes groups or there are some groups and user divide data?

Member 10066916 11-Sep-13 23:08pm

there are some groups and the admin will divide the data

Maciej Los 11-Sep-13 13:55pm

Unclear...
Please, be more specific and provide more details (for example: sample data and expected output).

i.fakhari 12-Sep-13 4:30am

why you don't add a combo box with some numbers to get the group of each data from user.
i mean when you get other data from user you get a id number to divide them to some groups?
what's wrong with it?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bernhard Hiller · Answer 1 · 2013-09-11T21:05:00

On the database side, you need a new table for the groups. That table has an automatically generated ID (autoincrement) as the group's ID (which is not shown in your example, only used internally). You may add extra columns for e.g. a description of the group.
Another new table stores the relation of your existing data with the group: it contains the ID of the group and the ID ("ref") of your data.
In the C# application, you could use a Dictionary<Group, YourData>; for handling that.