Need to know row number straight from SQLServer table

Question

Hello all In my code I have a DataGridView object. I use it to know the row number when I browse 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. How can I do that? Here is part of the code that utilize the DATAGridView (RaceDGView) and I want to change it accordingly private void CellEditMethod() { int a = RaceDGView.Rows.Count; DataGridViewRow rowToSelect = RaceDGView.Rows[a - 1]; rowToSelect.Selected = true ; rowToSelect.Cells[RaceDGView.SelectedCells[0].RowIndex].Selected = true ; RaceDGView.CurrentCell = rowToSelect.Cells[RaceDGView.SelectedCells[0].RowIndex]; AddRowPositionLbl.Text = Added row number is:  + Convert.ToString(RaceDGView.SelectedCells[0].RowIndex+1); RaceDGView.BeginEdit( true ); } PLZ HLP.

Lior · Answer

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 (:

theLizard · Answer

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.

Suthish Nair · Answer

Lior The best i can help you refer this article about using DataGraidView The rest is upon you how to learn implement and achieve.

Sam Hobbs · Answer

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.

Lior · Answer

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

Sam Hobbs · Answer

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.

Suthish Nair · Answer

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

Lior · Answer

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?

theLizard · Answer

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.

Lior · Answer

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!!!!

Sam Hobbs · Answer

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.

Lior · Answer

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

Sam Hobbs · Answer

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

Lior · Answer

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

Sam Hobbs · Answer

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.

Suthish Nair · Answer

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.

Sam Hobbs · Answer

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.

Suthish Nair · Answer

yes.. its sql server function. google it for more details

Lior · Answer

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?

Suthish Nair · Answer

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

Lior · Answer

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.

Sam Hobbs · Answer

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.

Manikavelu Velayutham · Answer

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

Lior · Answer

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.

Sam Hobbs · Answer

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.