use the keyword Like in your select query

kavitha

actually my datatable is in session but i m using FindControl which uses RowIndex to search the record but RowIndex is from 0 to 4 in first page.To retrieve 6th record it has to move to second page and get another 5 records . How to do that?

kavitha

use a regular expression validator to set the maxlength for a multiline taxtbox

kavitha

How to retrieve all records from gridview and assign it to datatable when paging is done?

kavitha

I m very clear i know that only 5 rows are ther in the grid .but i need all the records from the grid

kavitha

That i know But i have to move to next page grid and retrieve the records and assign it to the data table.How should i? my UpdateCustomerDetails method is as below private void UpdateCustomersDetails() { Customers oCustomers = Customers.GetCurrentSingleton(); int iRowCount = oCustomers.CustomersList.Rows.Count; for (int iRowIndex = 0; iRowIndex < iRowCount; iRowIndex++) { TextBox oTextBoxCustomerName = (TextBox)GridViewCustomers.Rows[iRowIndex].FindControl("TextBoxCustomerName"); oCustomers.CustomersList.Rows[iRowIndex]["cCustomerName"] = oTextBoxCustomerName.Text; TextBox oTextBoxEmailID = (TextBox)GridViewCustomers.Rows[iRowIndex].FindControl("TextBoxEmailID"); oCustomers.CustomersList.Rows[iRowIndex]["cEmailID"] = oTextBoxEmailID.Text; RadioButton oRadioButtonActive = (RadioButton)GridViewCustomers.Rows[iRowIndex].FindControl("RadioButtonActive"); RadioButton oRadioButtonInActive = (RadioButton)GridViewCustomers.Rows[iRowIndex].FindControl("RadioButtonInActive"); if (oRadioButtonActive.Checked == true) { oCustomers.CustomersList.Rows[iRowIndex]["bIsActive"] = true; } else if (oRadioButtonInActive.Checked == true) { oCustomers.CustomersList.Rows[iRowIndex]["bIsActive"] = false; } oCustomers.CustomersList.AcceptChanges(); } -- modified at 7:40 Wednesday 31st October, 2007

kavitha

With the Index I m finding control so wen it reaches 5th record it searches for 6th then says out of range error because pagesize is 5 -- modified at 7:22 Wednesday 31st October, 2007

kavitha

I have an Add button which adds each row to the grid then while i click save i takes a bulk record and sends to stored procedure.So i have to take the content of gridview whenever an Add button is clicked.When paging is done I am not able to do that.Otherwise my code is working.

kavitha

I have a gridview ,i have done paging for that grid.In a method i have to retrieve all the records from gridview to datatable.It shows the error IndexOutofRange because page size is 5.Actually 12 records are there.What to do?

kavitha