C# Discussion Boards - CodeProject

Re: Get Current Identity value of the table using LINQ.

Dave Kreskowiak29-Jun-11 9:35

29-Jun-11 9:35

You've still got a problem. Unless you return the ID number in the same sceop as the SQL INSERT you can get back the wrong ID number. Your SQL INSERT statement has to be followed by a SELECT SCOPE_IDENTITY(), like this in order to return the correct ID number:

INSERT INTO tablename (fields) VALUES (values);
SELECT SCOPE_IDENTITY() AS [LastIdentity];

It's better to do this as a stored procedure than to assemble it and use it with ExecuteQuery directly with this batch.

When your INSERT code runs, it'll automatically return the identity value that was assigned to back to you, without having to worry about another user screwing things up by inserting another record in the table between the first users trips to the database.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Get Current Identity value of the table using LINQ.

AspDotNetDev29-Jun-11 8:55

AspDotNetDev

29-Jun-11 8:55

Dave Kreskowiak wrote:
Next, the bigger question is why are you getting the next IDENTITY value or a table?

FYI, the OP wants the last identity value, not the next identity value.

Driven to the ARMs by x86.

Re: Get Current Identity value of the table using LINQ.

Dave Kreskowiak29-Jun-11 9:25

Dave Kreskowiak

29-Jun-11 9:25

Yeah, I messed up. The result is the same though. If he doesn't get the ID number back from the same scope the INSERT is in, he could get back the wrong ID number.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Get Current Identity value of the table using LINQ.

madhubabu29-Jun-11 9:47

madhubabu

29-Jun-11 9:47

I am new to .net so my request may look silly.but here is my question...........
can i know what would be the return type and even how to extract the first value out of the collection for
var num = db.ExecuteQuery<"ReturnType">("Select Ident_current('[mers_testing].[dbo].[Repositories] as value')");
The Identity column in the database is of datatype smallint

Thanks in advance

Re: Get Current Identity value of the table using LINQ.

Dave Kreskowiak29-Jun-11 10:38

Dave Kreskowiak

29-Jun-11 10:38

You still cannot do this in a multi-user environment. You've been warned...

Buit, a smallint in SQL is a 16-bit signed integer having a range of -32768 to +32767.

In .NET, the equivilent type is a short. So, in place of the "ReturnType", you put short.

...dbExecute<short>("SELECT ...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Get Current Identity value of the table using LINQ.

madhubabu29-Jun-11 10:55

madhubabu

29-Jun-11 10:55

thanks for the reply............it works.

Re: Get Current Identity value of the table using LINQ.

AspDotNetDev29-Jun-11 7:36

AspDotNetDev

29-Jun-11 7:36

Don't cross-post. For future reference, there is a LINQ forum.

Driven to the ARMs by x86.

Re: Get Current Identity value of the table using LINQ.

PIEBALDconsult29-Jun-11 15:02

PIEBALDconsult

29-Jun-11 15:02

Identities are evil, they cause nothing but trouble like you're experiencing now, don't use them.

Re: Get Current Identity value of the table using LINQ.

#realJSOP30-Jun-11 1:32

#realJSOP

30-Jun-11 1:32

Check my edited reply to your duplicate version of this question in Questions and Answers.

Short version - You can't do what you're trying to do the way you're trying to do it.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"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

Datagridview Arabic Localization? C# 2010 Application

Paramu197329-Jun-11 5:11

Paramu1973

29-Jun-11 5:11

I have small Windows Forms project.

And My DataGridView Query like the following manner:

string MyQuery1="select field1,field2,field3 from myTable"; Con.Open(); MySqlAdapter=New sqlAdapter(MyQuery1,con); MySqlAdapter.fill(MyTable); Con.Close(); DataGridview1.DataSource=MyTable; Now, my DataGridView's columns displaying like

Field1, Feidl2, Field3... good in English Mode...[Left to right]

But when My user changes his keyboard language this datagridview should display like the below manner...Is it possible?

Field3, Fiedl2, Field1 [Right to left]
Thanks && Regards Thumbs Up | :thumbsup:

PARAMU

Re: Datagridview Arabic Localization? C# 2010 Application [modified]

Not Active29-Jun-11 5:37

Not Active

29-Jun-11 5:37

1) Format your code snippets using the "code block" toolbar item

A simple way would be to have another query with the field order reversed.

I know the language. I've read a book. - _Madmatt

modified on Wednesday, June 29, 2011 11:59 AM

Re: Datagridview Arabic Localization? C# 2010 Application

DoctorMick29-Jun-11 5:45

DoctorMick

29-Jun-11 5:45

This should work. I've just tried it and it seemed to do exactly what you wanted.

dataGridView1.RightToLeft = System.Windows.Forms.RightToLeft.Yes;

Re: Datagridview Arabic Localization? C# 2010 Application

Paramu197329-Jun-11 19:30

Paramu1973

29-Jun-11 19:30

My 1/2 tension get released.

Nice & Wonderful !!!

Thanks For The Helps...! Rose | [Rose]

Thanks & Regards
PARAMU

WCF Service Browsable through any Web Browser

logicon29-Jun-11 4:36

logicon

29-Jun-11 4:36

Hello Everyone,

Sorry for putting this question in this board. I didn't find any broad for WCF.

I am trying to develop couple of Web Services (which I have done already in ASMX version)

Now as a reference and for development ease, I want to do this like:

domain.com/store.svc/Products?APIKEY={KEY}&ProductId={Id}

I searched a lot on WEB but unfortunately not able to find any resource which can help me with this.

I will be thankful to you all for any suggestions and pointers.

Thanks
Amit

Re: WCF Service Browsable through any Web Browser

Richard MacCutchan29-Jun-11 5:46

Richard MacCutchan

29-Jun-11 5:46

logicon wrote:
I didn't find any broad for WCF.

What about the one in the list to the left marked "WCF".

The best things in life are not things.

Re: WCF Service Browsable through any Web Browser

DoctorMick29-Jun-11 5:48

DoctorMick

29-Jun-11 5:48

You maybe want to look in to RESTful services. See here[]as a starting point.

Re: WCF Service Browsable through any Web Browser

Mirko198029-Jun-11 5:51

Mirko1980

29-Jun-11 5:51

Here for a complete tutorial.

convert a DataTable to a multi-line graph in c#

Jordao8529-Jun-11 4:13

Jordao85

29-Jun-11 4:13

How can i convert a Datatable to a Multi line in C#??????Ihave a DataTable with Values,and i want now to convert all of them in a multi line Graph in C# my first Row have information with Date and time,and will be my X Axis, and the other Rows,will be my Y axis with Value of censor.
may be some one can help me

Thx in advance

Re: convert a DataTable to a multi-line graph in c#

Blue_Boy29-Jun-11 4:29

Blue_Boy

29-Jun-11 4:29

Did you try to search on google?[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.cacttus.com

Why Control.FromHandle(IntPtr) returns null in one hooked process and returns valid object of “Form”? in another hooked process?

glitteringsound29-Jun-11 3:13

glitteringsound

29-Jun-11 3:13

I am facing a problem related to get out all the controls from some hooked process. My SpyDll launched into hooked process sucessfully, But when I check the statement

Control control = Control.FromHandle(MainWindowHandle), it returns null into control object where "MainWindowhandle"is just a native main window handle of that hooked process, which you always take from .NET "Process" class after launching that process.

But STRANGLY it happens that in some other hooked process which is the same C# .NET application, it returns valid object of Main "WinForm".

So why it will not work in above case? Are there any exceptions to use "MainWindowHandle" properly. In my case both are seperate .NET managed processes programmed in C#. Any process configuration needs to maintain specially while creating that process?

Regards Usman

Dot Net Remoting [modified]

Aneesh M29-Jun-11 1:14

Aneesh M

29-Jun-11 1:14

hi,
i am using dotnet remoting sometimes i getting error ( A non-blocking socket operation could not be completed immediately )
how can i slove this problem

modified on Friday, July 1, 2011 6:29 AM

Re: Dot Net Remoting

Mario Majčica29-Jun-11 1:49

Mario Majčica

29-Jun-11 1:49

So, what is the question?

Re: Dot Net Remoting

Aneesh M1-Jul-11 0:29

Aneesh M

1-Jul-11 0:29

when calling remote function iam getting an exception A non-blocking socket operation could not be completed immediately. how can i slove this problem

Re: Dot Net Remoting

Corinna John29-Jun-11 5:04

Corinna John

29-Jun-11 5:04

This could be a timeout, because the server application needs too long for its answer. It could also be a sporadic network problem which your client application doesn't handle. But your question is too incomplete to give a better answer.

This statement is false.

Activator.CreateInstance

scotlandc28-Jun-11 4:12

scotlandc

28-Jun-11 4:12

Hello.

Am not sure about this, hope someone can provide a little help.

I've got a folder with a variety of pre-defined Crystal Reports which will need to be instantiated depending on some user input. This folder is not part of the solution, it's just sitting on a server drive.

So assuming the input is rptTest, I need to instantiate the report called rptTest. If the app can't find a match, it alerts the user.

Is it Activator.CreateInstance I need to accomplish this or is it simply not possible? If it is, can anyone provide a code sample. I know I need an assemblyname and a typename for one but which would be the user input and what would the other be?

Hope I'm being clear and that someone can help.

Thanks in advance

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.