Hi Petar,

Thanks for the quick reply and the code you provided me helped alot.

I really appreciate the quick response of you..

Regards

Swetha

Hi Petar,

I have the following requirements with the Web Data Grid.Can you please help me in giving the solutinons for them.

1)How can I highlight a one of the columns of the web data grid?I need to highlight the one of the columns of the web data grid with the color say suppose yellow.

2)I have a button in my page called reload grid which will refresh the grid by calling a function in cs file which uses

this

.WDGTP.RequestFullAsyncRender();to refresh the grid.

when i do this it is not setting the cursor of the scroll bar to the first row of the grid.

I want the cursor to point to the first row of the grid after refresh it should not retain its previous position.

3)I want value in the cell to be shown in one line. I dont want it to come to the second/3rd/4th line if the length of the value is bigger than the width of the cell.If it is bigger than the width of the cell I want to show only the value that can fit in the column width and remaining value can be seen once the user resize the cell width with the mouse cursor made available to him.

Thanks in advance

Swetha

Hi Petar,

To clarify the first question I asked in this forum:

say my grid is having student data with columns student first name,lastname,marks in subject1,marks in subject2,marks in subject3,roll number etc. This data I am getting from storeprocedure using below code

<

asp:SqlDataSource ID="SQLDSTP" runat="server" OnSelected="SQLDSTP_Selected" ConnectionString="<%$ ConnectionStrings:xxxxConnectionString %>"

SelectCommand="SP_SCREEN_xxxx"

SelectCommandType="StoredProcedure">

<SelectParameters>

<asp:ControlParameter ControlID="txtFilterExpression" DefaultValue="1=1" Name

="ParamFilterExpression" PropertyName="Value" Type="String" />

</SelectParameters>

</asp:SqlDataSource>

txtFilterExpression is my filterexpression which is a text box.

in the application I will be providing the option for the user to filter the grid.

I will give few check boxes and drop downs for the users to select the filters.

say suppose user want to see the students of roll numbers from 1 to 10.so user will check the roll number check box and select the value min=1 max=10 then click on the button add filter.

now the text box txtFilterExpression will have value 1<=roll number<=10 which is a parameter to the sqldatasource.

I want the grid to refresh once the user selects like this kind of filters and clicks on apply filter button.

I have done this with the ultra web grid I have prepared the filter expression and kept the value in the text box and supplied this value to the sql data source and then did a refresh of the gird.everything i did it on client side I dont want a post back to happen here.

I want the same to achieve this with the web data grid.

Thanks

Thank you so much for your support Petar,

It is working well now...I am happy..

Hi Petar,

Thank you so much for your response.They are working well except the

You can set white-space:nowrap in the .tbody.igg_Item>tr>td class in order to ensure that only the text which can be fitted would be visible:

.tbody.igg_Item>tr>td {
    white-space:nowrap;
}

I have created the aboce CSS class and used as below:

<
 
 
ig:BoundDataField DataFieldName="Local Product Description" Key="Local Product Description"
 
 
Width="80" CssClass="tbody.igg_Item>tr>td">
This didnot helped me.
I tried as below as well.
<
 
 
ig:WebDataGrid ID="WDGTP" runat="server" AutoGenerateColumns="False" DataSourceID="SQLDSTP"
 
 
Height="350px" Width="980px" CellSpacing="1" StyleSetName="Default" OnInitializeRow="WDGTP_InitializeRow" CssClass="tbody.igg_Item>tr>td">
This also didnot helped me.
 
Can you please let me know if I am using it correctly or not.If not can you please suggest me its usage.
Thanks in advance
Swetha