Gridview fired event rowupdating which wasn t handled
Text & "%' AND Haulier LIKE '%" & Drop Down Haulier. good luck Paul Hernández My Page Index Changed event does not contain argument Grid View Page Event Args, instead it has Page Event Args ... I'm using The asp Net 2.0 gridview control, if you're using the visual studio 2005 select the control in the design view, go to the properties windows and select the event buton to display the events available for the control and the double click the pageindexchanging event to auto generate the prototype of the funtion in the or code behind page, and now you can write your code for the event Good luck This is the complete code in the Page Index Changing of the Grid View: Protected Sub Grid View1_Page Index Changing(By Val sender As Object, By Val e As System.
Data Bind() Thanks I'm learning that attention to detail helps in development. Clicking on page 2,3 etc sometimes displays the same results as page 1 and sometimes clicking on page 1 displays different details each time I click on it. Cheers Zuma Hi, sorry for the delay in my answer, I've been very busy in my new job.
:) Hi Vinz, I have tried to verify the query in SQL and it works correctly.
Also I suggest you to use the debugger to figure things out.
The Row Updating event is raised when a row's Update button is clicked, but before the Grid View control updates the row.
This enables you to provide an event-handling method that performs a custom routine, such as canceling the update operation, whenever this event occurs.
To cancel the update operation, set the Cancel property of the Grid View Update Event Args object to .
--------------------------------------- The SQL code would be - "select Columns from My Table where Col1 = Combobox 1 and Col2 = Combobox 2" but I dont know how and what Visual C# code I need to enter in this. Thanks, Data Table dt = new Data Table(); Sql Connection connection = new Sql Connection("YOUR CONNECTION STRING HERE"); connection.
Open(); Sql Command sql Cmd = new Sql Command("SELECT Column Name1, Column Name2 FROM TABLE1 WHERE Col1 = @Value1 AND Col2 [email protected]", connection); Sql Data Adapter sql Da = new Sql Data Adapter(sql Cmd); sql Cmd.
It only refreshes when there is data available in the table for the matching values.
Please note that a data representation control like gridview can only handle one datasource at a time. The problem now is the gridview does not refresh when the matching values are not selected from the 2 dropdown boxes.
Dim mysqlad As New Sql Data Adapter("SELECT Commodity, In_Out AS [IN/Out], Date, Contract_No AS [Contrat No], Supplier, Haulier, Ticket_No AS [Ticket No], Nett_Weight AS Weight, Moist FROM TBLSTORE WHERE store = '" & Lbl Login. Regarding your problem, I don't know what the problem is, try to debug the program step by step since you make the query until you bind your gridview.