Database

Re: How would you store the ID of a product? (a little bit long question)

30-Jan-09 8:31

Okay, when writing the answer I figured it isn't necessarily what you asked. Yes I think it's quite possible to have duplicate product codes it's necessary to identify the seller somehow.

I think that the solution leckey described would be a good one. No duplicates and optionally additional information how the record came into the system.

The need to optimize rises from a bad design.My articles[^]

leckey29-Jan-09 9:31

leckey

29-Jan-09 9:31

We work with multiple parties and interface with a 3rd party software. Our system is a kind of mirror to the 3rd party system.

For products, it uses a composite key of three fields, the SKU, owner, and another field that we're not actually using right now. You could use the 3rd as your own user defined field. That way if you do have two customers who both use 'ABCD' as a SKU, you look at the composite key. No duplicates that way.

For our system we first differentiate if it's a web item or through an EDI transaction. Start our ID with W or E. Next, if it's inbound or outbound, IB/OB, then the order's true auto-incrmented number padded to 8 digits. So we might have something like EIB00000425. This helps us keep track of what kind of transactions are happening even though they might be stored in the same place.

Hope that helps!

Back in the blog beatch!
http://CraptasticNation.blogspot.com/[^]

Accessing SQL 2005 table through C#

Deepali Khalkar29-Jan-09 2:32

Deepali Khalkar

29-Jan-09 2:32

I am developing an application for Win mobile 6.0 in visual studio 2008 under smart device.This application involves reading and writing the data from a table in SQL server 2005 to a C# smart device form.I cannot read and write the data to the table made in SQL server 2005 to c# form. Plz someone help me with the steps to be followed to achieve this. Also help me with the steps for database connectivity.

Thanks.

Re: Accessing SQL 2005 table through C#

Wendelius29-Jan-09 3:41

how can I get maximum values from set of alphanemeric field [modified]

29-Jan-09 3:41

Deepali Khalkar wrote:
I cannot read and write the data to the table made in SQL server 2005 to c# form

You could start here: Connecting to a Data Source (ADO.NET)[^]

Deepali Khalkar wrote:
help me with the steps for database connectivity

Have a look at this: SqlConnection Class[^]

The need to optimize rises from a bad design.My articles[^]

snehasish29-Jan-09 1:34

snehasish

29-Jan-09 1:34

Hi;
I create a field(namely Id) which have two types(09a.. or 09b..) of alphanumeric value like;

Id
09a1001
09a1002
09b1001
09b1002
09b1003

from these numbers at time a i need maximum value of 09a (it will be 09a1002) series or maximim value of 09b series(it will be 09b1004).

Help me.

modified on Thursday, January 29, 2009 7:57 AM

Re: how can I get maximum values from set of alphanemeric field

Wendelius29-Jan-09 3:34

Table which will become blank after a certain period.

29-Jan-09 3:34

You could have something like:

select max(convert(int, substring(id, 4, 9999)))
from tablename
where id like '09a%'

The need to optimize rises from a bad design.My articles[^]

RajpootRohan29-Jan-09 0:02

RajpootRohan

29-Jan-09 0:02

Hi ,

I have a application in which I have to store the user's data.So that he can retrieve it between its visits to the website.But I want that after 30 days that table should become blank.

Is there any way out.
Please give some guidance....

Thanx in advance.

cheers,
sneha

Re: Table which will become blank after a certain period.

J4amieC29-Jan-09 0:10

J4amieC

29-Jan-09 0:10

On SQL Server, this is generally achieved by using a SQL Agent that periodically scans the table for records older than "x" and removes them.

Re: Table which will become blank after a certain period.

RajpootRohan29-Jan-09 0:28

RajpootRohan

29-Jan-09 0:28

Thanks a lot...
It really worked...

cheers,
sneha

Re: Table which will become blank after a certain period.

Senthil_M29-Jan-09 19:14

Senthil_M

29-Jan-09 19:14

Sneha,

Pls give a brief about how did you do it?

Senthil

Re: Table which will become blank after a certain period.

ashok_rgm30-Jan-09 19:18

ashok_rgm

30-Jan-09 19:18

Hello mate,
Is it not going to effect your applications which are using the data from those tables, here I have similar problem like how to identify the unaccessed tables over a period of time.

Can u pls help me out,

Regards,
Ashok

ashok

MS Access Database

solomondevapaul12328-Jan-09 23:51

solomondevapaul123

28-Jan-09 23:51

I have a doubt regarding MS Access Database. I have two MS database with password protected. Now I want to join one inner join (example table a from first database, table b from second database) with the table how can i do it. When I was trying it's telling that not a valid password.

Problem both database are password protected. How I over come from the issue. Kindly do the favor.

Re: MS Access Database

Wendelius29-Jan-09 4:00

29-Jan-09 4:00

On one of the databases could you try something like:

SELECT a.*, b.* 
FROM sometable as a 
     INNER JOIN 
     [;DATABASE=C:\...\database.mdb;PWD=yourpwd].othertable b 
     ON a.column = b.column
WHERE ...

The need to optimize rises from a bad design.My articles[^]

Re: MS Access Database

solomondevapaul12329-Jan-09 19:43

solomondevapaul123

29-Jan-09 19:43

Hi Mika Wendelius,
It is a great solution. Thanks a lot for the help.

Thanks
Solomon.S

Re: MS Access Database

Wendelius30-Jan-09 6:39

30-Jan-09 6:39

You're welcome.

P.s. I noticed that this was a cross-post. Next time, post only on one forum.

The need to optimize rises from a bad design.My articles[^]

Cross-Post

David Mujica29-Jan-09 4:40

David Mujica

29-Jan-09 4:40

This same question was posted in the Visual Basic Forum. Frown | :(

Try not to cross-post.

How to create DFD

Member 467943628-Jan-09 23:10

28-Jan-09 23:10

Hello Friends,

How to create DFD for my project documents.

My project definition is Inventory System.

Please help me.

Thanks in advance.

Pin

Wendelius29-Jan-09 4:03

29-Jan-09 4:03

I'm curious, what's DFD? Data Flow Diagram?

The need to optimize rises from a bad design.My articles[^]

Member 467943629-Jan-09 20:23

29-Jan-09 20:23

DFD Stands for Data Flow Diagram.

It is one kind of Graphical Representation of the flow of Data in Project.

For example my project is about Inventory Management System.

In My project there is :
Stock - inward
Stock - Outward
Customer
Suppliers
Bank
Order process
etc...

how to represent this using Data Flow Diagram. (dfd 1.0, 2.0...)

Please help me,

Thanks in advance.
Pin

Wendelius30-Jan-09 7:46

30-Jan-09 7:46

So could you use this: Creating Package Data Flow[^] or do you need to model database tables for describing a data flow.

The need to optimize rises from a bad design.My articles[^]

RC_Sebastien_C29-Jan-09 14:53

RC_Sebastien_C

29-Jan-09 14:53

Please clarify your question

"It reads like a B3 page (and for those who don't know what B3 is, it means bullsh*t Baffles Brains)" - Pete O'Hanlon

Member 467943629-Jan-09 20:25

29-Jan-09 20:25

DFD Stands for Data Flow Diagram.

It is one kind of Graphical Representation of the flow of Data in Project.

my project is about Inventory Management System.

In My project module is :
Stock - inward
Stock - Outward
Customer
Suppliers
Bank
etc...

how to represent this using Data Flow Diagram. (dfd 1.0, 2.0...)

Please help me,

Thanks in advance.
Pin

Ashfield29-Jan-09 21:06

Ashfield

29-Jan-09 21:06

And it sounds like a homework question. Ask your tutor or read a book. you never learn if someone else does it for you.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Member 467943629-Jan-09 22:35