Create an Insert SQL - Statement for insert a date - C# Discussion Boards

Re: Casting objects to get at the contents? [modified]

17-Dec-09 4:15

Just a guess, but if you cast it (preferably with "as" and a null check) as an object[] first, you can then cast each element as a string in a foreach.

All those who believe in psycho kinesis, raise my hand.

MattFunke17-Dec-09 4:23

MattFunke

17-Dec-09 4:23

I'm having some luck with this one. Thanks! I should have thought of casting the function call as an array of objects myself!

modified on Thursday, December 17, 2009 10:29 AM

Re: Casting objects to get at the contents?

Jim Crafton17-Dec-09 5:34

Jim Crafton

17-Dec-09 5:34

If you hover over the "GetEntityDefNames()" method in your VS editor, you should get a little popup that describes the type that the method returns. Match cqEntities with that type. Alternately the ClearQuest API docs should give you the proper return type. Even the VS class browser should be able to tell you what the type is. You'll want to avoid casting if you can, unless that's being forced on you by the ClearQuest API, in which case that's a heads up that it's not a very good API.

¡El diablo está en mis pantalones! ¡Mire, mire!
SELECT * FROM User WHERE Clue > 0
0 rows returned
Save an Orange - Use the VCF!
Personal 3D projects
Just Say No to Web 2 Point Blow

problem receiving data from

Shivendra Pandey17-Dec-09 2:14

Shivendra Pandey

17-Dec-09 2:14

i got assignment to write a program(Server) for port listner the client program is written in java.
the client will send 69 byte that will be received by server and then processed.
i have written a simple TCP listner progam in c# but it always read upto 52 bytes and next 17 bytes are always 0

Re: problem receiving data from

OriginalGriff17-Dec-09 2:35

Re: problem receiving data from

17-Dec-09 2:35

So, cut out the relevant bits, and post them here (within <pre>...</pre> blocks) - otherwise we can't tell what your problem might be...

All those who believe in psycho kinesis, raise my hand.

Migounette17-Dec-09 3:59

Migounette

17-Dec-09 3:59

Do you have TCP no delay set ?

SetSocketOption(SocketOptionLevel.Tcp ,SocketOptionName.NoDelay, true);

It should not help in your case except if you made a mistake in your read operation.

TCP is a reliable stream delivery service that guarantees delivery of a data stream sent from one host to another without duplication or losing data but you may see your data cut in several packets. So, handling of re-assembly packets is necessary at the application level.

When the system is not loaded it's okay, but you will see when a system is at 99% of CPU usage it's not the same.

Hope it helps....

Just let me know

Re: problem receiving data from

Jim Crafton17-Dec-09 5:37

Jim Crafton

17-Dec-09 5:37

Is your recv or read function giving you back a total of 69 bytes? If so then the TCP part of the socket read is OK, and the "problem" lies on the server end in terms of what it's sending you. It's entirely possible that the server is in fact sending you 69 bytes, 52 of which are printable characters, and the remaining 17 padded out as 0's. A 0 is a perfectly valid byte value to send across a network.

¡El diablo está en mis pantalones! ¡Mire, mire!
SELECT * FROM User WHERE Clue > 0
0 rows returned
Save an Orange - Use the VCF!
Personal 3D projects
Just Say No to Web 2 Point Blow

Create an Insert SQL - Statement for insert a date

neus8317-Dec-09 1:59

neus83

17-Dec-09 1:59

Hi all,

I was trying and trying ...

in Visual c# .net I use a date which should besaved to the database:

DateTime TimeForTheDatabase = DateTime.Now;
... this is only an example ...

Now I will Insert "TimeForTheDatabase" to the Database:

SqlCommand dataCommand = new SqlCommand("Insert INTO table1 (Text,Datum) VALUES ("Info",TimeForTheDatabase)",dataConnection);

But I get an Error Frown | :(

Can somebody give me a sample how to insert my "TimeForTheDatabase" into my DB ?
Thanks

Re: Create an Insert SQL - Statement for insert a date

Arindam Tewary17-Dec-09 2:15

Arindam Tewary

17-Dec-09 2:15

whats the error????? without error description how people can help you ?

Thanks,
Arindam D Tewary

Re: Create an Insert SQL - Statement for insert a date

Shivendra Pandey17-Dec-09 2:17

Shivendra Pandey

17-Dec-09 2:17

the problem is format.
if u simply want to store datatime do in in db side
example
Insert INTO table1 (Text,Datum) VALUES ("Info",getdate())

Re: Create an Insert SQL - Statement for insert a date [modified]

OriginalGriff17-Dec-09 2:33

Re: Create an Insert SQL - Statement for insert a date

17-Dec-09 2:33

OK, there are a few problems here. Do it this way:

SqlCommand dataCommand = new SqlCommand("INSERT INTO table1 (Text,Datum) VALUES (@TX,@DT)");
dataCommand.Parameters.AddWithValue("@TX", "Info");
dataCommand.Parameters.AddWithValue("@DT", TimeForTheDatabase);

That way you won't get the syntax error, and you can start to avoid SQL injection attacks later on.

[edit]I forgot the .Parameters bit. D'Oh! | :doh:

[/edit]

All those who believe in psycho kinesis, raise my hand.

modified on Thursday, December 17, 2009 10:07 AM

loyal ginger17-Dec-09 4:05

loyal ginger

17-Dec-09 4:05

I am not sure SqlCommand has a AddWithValue method. You are supposed to add to the Parameters collection, not to the command object.

Re: Create an Insert SQL - Statement for insert a date

OriginalGriff17-Dec-09 4:09

Re: Create an Insert SQL - Statement for insert a date

17-Dec-09 4:09

Corrected - thanks!

All those who believe in psycho kinesis, raise my hand.

cysccnu17-Dec-09 3:34

cysccnu

17-Dec-09 3:34

That is because the time format isn't converted to string.
Try this:

SqlCommand dataCommand = new SqlCommand(string.Format("Insert INTO table1 (Text,Datum) VALUES ('Info',{0})",TimeForTheDatabase),dataConnection);

Re: Create an Insert SQL - Statement for insert a date

PIEBALDconsult17-Dec-09 5:07

PIEBALDconsult

17-Dec-09 5:07

No, never do that. Use parameters.

Re: Create an Insert SQL - Statement for insert a date

OriginalGriff17-Dec-09 5:18

Re: Create an Insert SQL - Statement for insert a date

17-Dec-09 5:18

Not really recommended - firstly beacause it involves an unnecessary string conversion, and secondly because it is better practise to use parameters at all times. In this case there is no risk of an SQL injection attack, but all it would take is a small change to the logic...
See the XKCD cartoon "Bobby Tables"[^]

All those who believe in psycho kinesis, raise my hand.

PIEBALDconsult17-Dec-09 8:21

PIEBALDconsult

17-Dec-09 8:21

Yes, for those reasons, plus performance in a loop:

If you concatenate SQL strings to insert a million such rows the server has to prepare a million SQL statements, but by using a parameterized statement the server prepares the statement once and uses the cached execution plan a million times (at least in theory).

Injection Games Menu.

evangile17-Dec-09 1:36

17-Dec-09 1:36

Hi all i try make an injection into a Game .
some peaple draw menu in a lot of games mmorpg or fps like counterstrike.

i find this stuff kinda cool also for thing like customise windows application or change games interface let say turn ffxi interface into wow interface etc...
now i don't realy understand how peaple do that.

at first i though they inject an exe into the game process but look like its impossible.

so if peaple only inject a dll how they can draw menu? does the code of the dll draw it self a menu into game?
or maybe the dll load an exe into the games?

if someone can point me in the rigth direction from ground for built a simple menu into a games?

i realise i need c++ over c# not sure also.

Eddy Vluggen17-Dec-09 2:34

Eddy Vluggen

17-Dec-09 2:34

evangile wrote:
at first i though they inject an exe into the game process but look like its impossible.

Even forbidden, and you agreed not to when you first logged into Wow. As I remember, the agreement is shown after every update, usually on Wednesday.

Wow has a *damn cool* plugin system, can be extended over C#, and there's a coding4fun-article on building your own;
TweetCraft[^] Smile | :)

The way that a plugin is formed, varies from application to application though.

I are Troll Suspicious | :suss:

evangile17-Dec-09 3:34

17-Dec-09 3:34

so to eddy you know blizard agreement worth nothing?
they actualy more than happy peaple developping private server so they have a cool demo version.
+ they have mass arangement with rmt.so they not realy care time peaple talk about wow they happy with dollard.
ffxi is way differente about that they have 0 tolerance but just for some helper application.

Eddy Vluggen17-Dec-09 3:40

Eddy Vluggen

17-Dec-09 3:40

evangile wrote:
so to eddy you know blizard agreement worth nothing?

They have the right to block you if you violate the agreement. I know that they will from personal experience Laugh | :laugh:

The coding4fun article using C# wouldn't be a violation though, the interfaces are defined just as the plugin-system expects it. Injecting things in another way could be seen as an attempt to hack the system (e.g., someone who tries to change the amount of money that's stored in memory; such a thing is impossible to do, but they *can* detect attempts)

Creating a mining-bot will get you in the same trouble, after some weeks. And why would you even want to, if there's a ready-to-run example in C# that you can customize to your own needs? They even explain how to make a Wow-like interface-window for your Tweets Smile | :)

I are Troll Suspicious | :suss:

EliottA17-Dec-09 3:01

EliottA

17-Dec-09 3:01

You most definately need C++ for a task like this, and a program like this usually is comprised of two portions. The first is a DLL which your code that effects the game lays in, and the second program is an injector which will inject your dll into the game process.

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

evangile17-Dec-09 3:28

17-Dec-09 3:28

i know wow have premade plugin for developpe quick but i need learn more than i need build a plugin for wow realy.

for the other respons yes i understand the principe of injecting a dll.

i can even prolly do a something where the charactere will clap his hand in game fast lol.

what i don't d=get is how from an injected dll you can draw a menu or bouton in the game itself.

let say i want a button "Clap your hand".

possible to draw menu from dll realy?

EliottA17-Dec-09 3:31

EliottA

17-Dec-09 3:31

You could probably create a macro for that, no need to inject code.

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

evangile17-Dec-09 3:36