Need to know row number straight from SQLServer table

Hi all,
I got the solution myself.
to know on what row I am at the table in the SQL server all I need to type is:
BindingSource.Position;
And thats all!!!!
Thanks all whom tried to help (:

What you want is very easy if you are handling all the sql work yourself. how I do these things is most likely not the same as anyone else but time after time my methods have proven themselves.  just as an example of what I do

Say you have a combo box with data from an sql table, if you load the combo box manually you can create a dynamic array and add the associated row id to the array so that when you want to access the record of the combo box item it is as easy as "SELECT * FROM table WHERE rowid = " + rowids[combobox->selectedindex]; 

In my case I have written components and component agents that do this by design and as the controls are being loaded from the database their row id is added to vector and properties of the control access the vector to return the record id like this int rowid = combobox->RecordId();  in this case it returns the id of the selected record.

Lior,

The best i can help you, refer this article about using DataGraidView

The rest is upon you, how to learn, implement and achieve.

All three participants in this thread have asked you for additional information that requires time for us to ask for. It does often happen that we must get clarification; I am just pointing out that there was a lot of material missing from the original post. The code that should have been posted originally is the code from the SqlIdNumLbl_Click method. I don't understand why it is so important that you insist that all the code was provided; it was not, and although that sometimes happens in discussions such as that, it is also true that the problem was not adequately described initially.

SAM - it's cleer that you have read this tree from the start otherwise you must have noticed the codes that I posted
 
Nair - I can use the primary key but don't know how

In How To Ask Questions The Smart Way it says that before you ask, try to find the answer, including reading the manual. It also says:

• "display the fact that you have done these things first"
• "making it clear that you are able and willing to help in the process of developing the solution is a very good start"
• "it is necessary to demonstrate the kind of attitude that leads to competence" .... if you can't "we suggest you pay somebody"

And it says much, much more that you need to read. Note that that page has been developed with the assistance of many people.

A shorter version of the above is in How To Ask Good Questions, which says:

• "Before asking a question, try to find an answer yourself"
• "when you ask your question, make it clear that you have done this research"

Microsoft has written their version; see How to ask a question. You need to read that too. It also says to search the documentation, the internet, FAQs and previous answers in forums before asking a question.

If that the case why dont you use primary keys in table?

In my code I have a DataGridView object. I use it to know the row number when I update the table.
I actually don't need this DataGridView object! I need to know the row number operation straight from the table located inside my SQL so I could INSERT, UPDATE and DELETE rows.
How can I do that?

I don't know if i can help but to be able to I need to know what the row number will be used for, what is the significance of row number, does it relate to the record id.

The forum is a place of free choice and open knowledge.
No one does the work of the other!
If you think that you are being exploited so do not help-no one is forcing you!
I need help in coding and I do help others that need help in areas that I'm strong at. Not feeling exploited but helpfull that is why FORUMS exists - to help others helping themselves.
I'm a newbe at C# and SQL I don't know to program but I'm learning, by myself, and this and other forums are the best place to learn!
There are good people on the way that have the skill and patience to help and they do help!
So thanks to you but no thanks if you think that I'm an exploiter - I'M NOT!!!!

You will quickly be ignored if you try to get other people to do your work. It is your work to do. We all have other work to do. We try to help others when we can but we don't want to do work that instead you should be doing yourself.

That is exactly what I'm doing.
But if someone knows the solution for my problem why not simply ask?

You misunderstand. MSDN is the documentation! You need to use the documentation before using any forum to request assistance.

Hey guys,
I do use the MSDN forum. but I've come to conclusion that C# Corner forum is a very PRO forum so why not be a member too!?
About the search engine, well, here you can see the work of a good code plus a greate PR!!! and the outcome is obvious!
Like microsoft a nice code plus proffesional PR and marketing and you have an empire :)
And for my problem- I need a complete code sample if you please.
I do search a solution in all my available sources but for now got non!!! ):
Thanks

It's not a big thing and please don't take it personally. If it was just you then none of my comments about Google would even occur to me. Yes, I totally understand that you said Google because everyone else does. I am reacting to all the many times that people say Google as if it is the only search engine; especially people in television shows and such.

I think I distracted the discussion away from the most important point; that developers need to use MSDN more.

waw.. Sam dont be emotional. am too here not for any promotional of websites. :-)
I just typed the name becoz most people nowdays directly use this to find answers.

For Microsoft software, instead of using Google or any search engine that searches the entire internet, it is usually faster to go directly to the MSDN, as in:

http://social.msdn.microsoft.com/Search/en-US?query=SqlCommand&ac=3

If answers are not found in the MSDN then it is useful to search this web site; then if an answer is still not found, search the entire internet using a search engine such as Google. Note that Google was not the first search engine and it is not the only one.

I think Google has paid the most money to get people to talk about them, but I sure have never gotten any of that.

I'm talking about row number.
Nair - is the SQL code you wrote needs to be in the Sqlcommand? and the rest of my code will stay the same????
What "ROW_NUMBER()" relates to?

are you talking about each row_numbers or row count?
please be specify about your post..

select ROW_NUMBER() OVER(ORDER BY race_id DESC) AS 'Row Number', race_NAME from dbo.RaceTbl

Here is a code that I'm trying to "play" with.
The end resault is that this code counts all the rows of my table and doesn't show the specific row that I'm standing on.
Lets say that I'm on row 5 and when I click my lable I want to see the number 5 and not the number of all the rows
private void SqlIdNumLbl_Click(object sender, EventArgs e)
{
//SqlIdNumLbl.Text = Convert.ToString(RaceDS.Tables[0].Rows.Count);
SqlCommand RowIdCmd = new SqlCommand("select count('ID') from RaceTbl", WorldConn);
WorldConn.Open();
{
SqlDataReader RowIdDrd = RowIdCmd.ExecuteReader();
while (RowIdDrd.Read())
{
SqlIdNumLbl.Text = Convert.ToString(RowIdDrd.GetInt32(0));
}

}
WorldConn.Close();
}
 
Hope that this make my problem more clear.

There are many ways to get data from SQL. If someone were to choose one of the many ways and they were to show you sample code using it and the sample code does not help you because you are using something different then don't criticize them for guessing wrong.

How are you reading the data into the DataGridView? If it were me, I would create a TableAdapter; that can be done in the Database Designer. If you do that then the only code you need to write is the code to create an instance of the TableAdapter and maybe one line to open it and then one line to get the count of the rows. You will need to spend some time learning but the time is well spent since you can re-use the knowledge many more times.

Below query is used to generate the row number in sql server 2005
SELECT ROW_NUMBER() OVER (ORDER BY EMPID ASC) AS ROWID, * FROM EMPLOYEE

As I said before at present I use the DataGridView object and I want to elimnate it.
I need to know on what row I am so I could edit or update it.
How can I do that? need a simple code sample.

The code you show does not show the DataGridView's data source, but the data source is likely a DataTable, or at least a binding source that binds a DataTable to the DataGridView. A DataTable has a Rows property.