|
I am not getting your idea !!
Doesn't this going to create redundancy in offer table, if for a single offer i create same rows with only change in AgentID?
At present this way i had design DB tables!!
Table - Offer(ID, PartyName, offerDate, etc....., AssignPerson,...)
Table - Users(Name , pass)
table offfer is main table holding all discription about OFFER.
Now at offer creating i simply insert Assign person name in Offer table,
and at login time checks login name and fetch only records
...from offer where AssignPerson = loginName
regards
|
|
|
|
|
Hum Dum wrote: create redundancy in offer table
No, no two records should be the same there.
Hum Dum wrote: only change in AgentID?
Maybe, but perhaps also in any other fields you may have there, e.g. when assigned and by whom.
Hum Dum wrote: Table - Users(Name , pass)
Your users should have IDs, then you use the ID, not the name. And are you storing plain text passwords?
|
|
|
|
|
PIEBALDconsult wrote: No, no two records should be the same there.
But all fields are same also data, except AgentID ?
PIEBALDconsult wrote: And are you storing plain text passwords?
Quote Selected Text
yes. is this incorrect?
|
|
|
|
|
Hum Dum wrote: And are you storing plain text passwords?
Quote Selected Text
yes. is this incorrect?
Yes. Anybody who can gain access to the database can see a users password - remember that this could be somebody who's managed to hack into your system.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hum Dum wrote: But all fields are same also data, except AgentID ?
No, and so what if it is? I suspect you're too new to database work to balk at such concepts.
User ( ID , Name , ... [ password , etc. ] )
1 , Alice , ...
2 , Bob , ...
3 , Carol , ...
4 , Ted , ...
Let's say Alice creates issue 1 and assigns it to Bob, you get:
(I'll use {} to indicate a datetime.)
Issue ( ID , CreatedByID , CreatedWhen , Description , ... )
1 , 1 , {} , "Normalize the database" , ...
2 , 1 , {} , "Document the code" , ...
3 , 1 , {} , "Peer review Ted's code" , ...
Then she assigns them to Bob:
Assignment ( IssueID , AssignedToID , AssignedByID , AssignedWhen , ... )
1 , 2 , 1 , {} , ...
2 , 2 , 1 , {} , ...
3 , 2 , 1 , {} , ...
Later, Carol may assign issues 1 and 2 to Ted:
Assignment ( IssueID , AssignedToID , AssignedByID , AssignedWhen , ... )
1 , 2 , 1 , {} , ...
2 , 2 , 1 , {} , ...
3 , 2 , 1 , {} , ...
1 , 4 , 3 , {} , ...
2 , 4 , 3 , {} , ...
So, you can see that no two rows are the same and can be quite different, especially as time goes on.
You'll need to learn about table JOINs.
Hum Dum wrote: yes. is this incorrect?
Yes, at least store a hash of the password instead of the actual password:
0) When someone sets a password, store the hash. (I use SHA-1[^])
1) When someone logs in; take the provided password, hash it, and compare the new hash to the stored hash.
|
|
|
|
|
thanks for your needful reply.
cheers
|
|
|
|
|
|
hi;
i wonder if there's a designer support for inserting ComboBoxes into a DataGrid in windows applications, rather than writing codes for it since the samples are too complicated. can anyone help?
--- Thanks
|
|
|
|
|
0) Why are you using a DataGrid(View) ?
1) Are you trying to allow editing in one?
See this[^] recent thread.
|
|
|
|
|
yes, i need to present an sql table in a grid and allow the user to change its values if needed. one column of the grid should have restricted values, so i thought it might be a good idea to insert a combo for it and i found several samples which were too complicated and time-consuming. if there's other ways of restricting values for a DataGridColumn, i'll be glad to learn.
--- Thanks
|
|
|
|
|
AmbitiousBeginner wrote: i need to present an sql table in a grid
Who says? That's a very poor way of presenting information to a user.
|
|
|
|
|
???
Just add a column using designer and set the type to ComboBox.
|
|
|
|
|
there's no such thing! you can either add a boolColumnStyle or textBoxColumnStyle when creating a table style for your grid. where can we change a column style to ComboBox???
--- Thanks
|
|
|
|
|
Which version if VS do you use ?
I think, you are able to set column style to DataGridViewComboBox since VS2005.
|
|
|
|
|
Hi,
I have a setup program that installs my application with an MS Access database. Now, when I have to provide an update to a client, I again build a setup program and give them this setup.
The client unistalls his existing program and installs new setup. This process also wipes out his existing database. To overcome this, I set permanent property of database in the setup TRUE. This has resolved the above problem.
But now... I have updated few tables in my database. The clients must be provided with the update such that his existing data must be retained intact...
HOW to achieve this? Any suggesstion will be greatly helpful?
Regards,
-SIFAR.
|
|
|
|
|
My standard practice is to write migration scripts for new versions of the database. Then you can use the migration scripts to update the old database. This can be a lot of code to maintain so what you do is an iterative update process. IE, convert DB V1 to DB V2 then convert the newly created DB V2 to DB V3, etc. This is much easier than writing infinite migration scripts. Be cautious because you will come across database that just cannot be upgraded with 100% accuracy if you do not have a solid change control policy in place.
|
|
|
|
|
I am learning how to read text files at the moment, and it seems regular expressions is the way to go for what I need. I understand the concept but not quite sure how to implement it.
I have the line...
$2 USD NL Texas Hold'em - Sunday, August 09, 19:05:42 EDT 2009
...stored in a string. I would like to take certain parts of this and store them in seperate strings.
The data I need is...
NL Texas Hold'em
August 09
19:05:42
2009
Should I use something like "USD\s.*\s-" this would give me "USD NL Texas Hold'Em -"? After this I can then trim "USD " and " -" off the start and the end of the string and I will the information I need.
Regex rExp = new Regex("USD\\s.*\\s-");
Match match = rExp.Match(sLine1);
string gameType = match.Value;
gameType.TrimStart("USD ".ToCharArray());
gameType.TrimEnd(" -".ToCharArray());
switch (gameType)
{
case "NL Texas Hold'em":
break;
default:
break;
}
Is this a good way to approach the task? Are there better ways to do this?
Any help would be appreciated.
Thank you.
modified on Monday, August 10, 2009 1:18 AM
|
|
|
|
|
Ah, thanks, I was just working on a Regex tester; you gave me something to test!
With that input, this Regex:
\$\d* \w* (?'Game'.*?) -.*?, (?'Date'.*?), (?'Time'\d\d:\d\d:\d\d) \w* (?'Year'\d*)
Produces:
Match: $2 USD NL Texas Hold'em - Sunday, August 09, 19:05:42 EDT 2009
Group 0: $2 USD NL Texas Hold'em - Sunday, August 09, 19:05:42 EDT 2009
Group Game: NL Texas Hold'em
Group Date: August 09
Group Time: 19:05:42
Group Year: 2009
(You should also look into Expresso.)
|
|
|
|
|
Thanks Piebald, thats the sort of expression I was looking for. Far more simpl than what I had originally.
Regex regExp = new Regex("$\\d* USD (?'GameType'.*?) -.*?, (?'DateMonth'\\w*?) (?'DateDay'\\d*?), (?'DateTime'\\d{2}:\\d{2}:\\d{2}?) \\w* (?'DateYear' \\d*?)");
Match line2Match = regExp.Match(sLine2);
switch (line2Match.Groups["GameType"].Value)
{
case "NL Texas Hold'em":
break;
default:
break;
}
|
|
|
|
|
|
Hi All,
I am trying to develop a client/server application in which client will send images to the server.
Case 1:
Server is running on one machine that is behind a router and client is running on another machine that is behind some different router. As this communication will be on WAN (public IPs), a port is forwarded on server side router so that server can easily receive incoming UDP datagrams on that port.
UDP's maximum transmission unit (MTU) size is 64KB. It means a UDP socket should be able to transmit anything thing of size less than or equal to 65,536 bytes. When in case of the application i am developing the client is only able to send an image(UDP datagram) of 10-13k. If i try to transfer an image of the size greater than 10Kb, server is unable to receive it and server side UDP socket will be always in (receive) blocking mode.
Case 2:
Server is running on a machine that is behind a router and client is running on a machine that is behind the same router. It means client & server are on the same local area network. Even client and server are sharing the same local area network client is sending the images (UDP datagrams) on server's public IP. In this case server is able to receive any size of UDP datagram upto 64K, which is what i am expecting from my application.
I tried to run my client on different remote PCs but the result is same. Server is not able to receive a UDP datagram of bigger than 10-13Kb. If anyone can help me to deal with this situation, he would be much appreciated.
Link to the code: http://pastebin.com/f644fee71
Thanks and goodluck with your projects. Regards,
Atif
|
|
|
|
|
You only have two choices, TCP/IP if you want to seen standard images or if you insist on using UDP you will have to use an image compression algorithm that supports lost packets. Otherwise, any logic you do in an effort to support UDP will be an uphill battle trying to replicate TCP/IP but doing a poorer job.
|
|
|
|
|
Can't you just use Socket.Send and forget about MTUs and such.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Ok here is a quick screenshot, from which you can see my top of my character has been rendered over
[IMG]http://i714.photobucket.com/albums/ww146/jneul/RPG_INVENTOR8-1.png[/IMG]
I hace a RPG game which works on a 3-layered map which is split into a grid (of rows and columns)
I can get my character making to work properly on simple objects such as a tree stump (just one cell),
and it works when you are moving down, but i get this problem when i move up, here is the code below:
public ArrayList detectTilesToRedraw(Rectangle srcArea, bool bUp)
{
ArrayList pTileRedrawList = new ArrayList();
int nTop = srcArea.Y / Map_Definitions.m_nCellHeight ;
for (int i = 0; i < m_pObjectList.Count; ++i)
{
Object pObj = m_pObjectList[i];
if (pObj is ArrayList)
{
ArrayList pList = (ArrayList)pObj;
for (int j = 0; j < pList.Count; ++j)
{
Tile_Object pTile = (Tile_Object)pList[j];
Object pSubObj = pTile.getObject();
if (pSubObj is Graphic_Object)
{
Graphic_Object pGraphicObject = (Graphic_Object)pSubObj;
int nTileTop = pGraphicObject.getPosition().Y / Map_Definitions.m_nCellHeight;
if (!bUp)
{
if (nTileTop >= nTop)
{
pTileRedrawList.Add(pGraphicObject);
}
}
else
{
if (nTileTop <= nTop)
{
pTileRedrawList.Add(pGraphicObject);
}
}
}
}
}
}
Obviously i need some smarter code for when i move up as sometimes different objects are required to be drawn when the character is in different positions
modified on Sunday, August 9, 2009 7:29 PM
|
|
|
|
|
Hi,
Please use PRE tags to show readable code. No one is going to read it as is.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|