|
Hi All,
I need to sort GirdView with up and down image.Please help me in doing this.
Thanks in advance..
|
|
|
|
|
You can have a look at this[^]. This tells pretty much about the same.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi thank for the reply but i have tried this its not working.
Please tell me some other code.Actually I have done this in C# but the same code is not working in VB.If u want I will post C# Code.
Please help...
|
|
|
|
|
I don't see any reason that why VB.Net code will not work provided it has been converted correctly.
BTW you can try some convert tool one I know is this[^]. But verify the code after it is converted don't trust them blindly.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I use the same code but the problem with the code here is that I get the header text as UserCode"<img src=../Images/bar_up.gif height=13 width=13 border=0>"
but I want the UserCode with the image not the html tag(<img src=../Images/bar_up.gif height=13 width=13 border=0>).
Please tell me how do I go about the same...
|
|
|
|
|
Sorry but could not understand the problen exactly. Can you give the corresponding code for that.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I use the following code:
Public Sub GetSort(ByVal dgGrid As
System.Web.UI.WebControls.GridView, ByVal ds As System.Data.DataTable,
ByVal sortExpr As String)
'Sorts the DataGrid
Dim dv As Data.DataView = New Data.DataView(ds)
Dim i As Integer = 0
Do While (i < dgGrid.Columns.Count)
If ((dgGrid.Columns(i).HeaderText.Trim.Length > 0) _
AndAlso (dgGrid.Columns(i).Visible = true)) Then
Dim index As Integer =
dgGrid.Columns(i).HeaderText.IndexOf("<img")
If ((dgGrid.Columns(i).SortExpression = sortExpr) _
AndAlso
(dgGrid.Columns(i).SortExpression.Length > 0)) Then
If (index >= 0) Then
Dim index1 As Integer =
dgGrid.Columns(i).HeaderText.IndexOf("bar_down.gif")
If (index1 >= 0) Then
' sort Asc
dgGrid.Columns(i).HeaderText =
dgGrid.Columns(i).HeaderText.Substring(0, index)
dgGrid.Columns(i).HeaderText =
(dgGrid.Columns(i).HeaderText + "<img src=../Images/bar_up.gif height=13
width=13 border=0>")
dv.Sort = (sortExpr + " ASC ")
Else
' sort Desc
dgGrid.Columns(i).HeaderText =
dgGrid.Columns(i).HeaderText.Substring(0, index)
dgGrid.Columns(i).HeaderText =
(dgGrid.Columns(i).HeaderText + "<img src=../Images/bar_down.gif
height=13 width=13 border=0>")
dv.Sort = (sortExpr + " DESC")
End If
Else
dgGrid.Columns(i).HeaderText =
(dgGrid.Columns(i).HeaderText + "<img src=../Images/bar_up.gif height=13
width=13 border=0>")
dv.Sort = (sortExpr + " ASC")
End If
ElseIf (index >= 0) Then
dgGrid.Columns(i).HeaderText =
dgGrid.Columns(i).HeaderText.Substring(0, index)
End If
End If
i = (i + 1)
Loop
dgGrid.DataSource = dv
dgGrid.DataBind
End Sub
But when I click on the Header Column of the Gridview I get UserCode with the image tag where as I want UserCode and image only not the image tag.
Please tell me where I am going wrong.I think the problem is with
dgGrid.Columns(i).HeaderText =
(dgGrid.Columns(i).HeaderText + "<img src=../Images/bar_up.gif height=13
width=13 border=0>")
Statment??
I really dont know how to go about this.
|
|
|
|
|
I think directly you can't set the headertext as html contect it is not been rendered as html. What you can do is make is headertemplate and then put label in that and then try to assign html in it.
BTW are you sure the same is working with c# because I think it should not work there also.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Thanks for replying.Can you provide some code for the same.
Also it works in C#,I have done this in my prevoius project.Since I am working on ASP.NET(VB) I wanted to do the same so thought of using the same code but its not working.
Please me in writing code for the suggestion which you gave me.
Thanks again.
|
|
|
|
|
Can you tell me whether you are using datagrid or gridview. Because the parameter of the method used suggest that you are using datagrid and the subject of the thread says the other?
Best Regards,
Apurva Kaushal
|
|
|
|
|
Actually my previous project was in ASP.NET 2003 and now I am using ASP.NET 2005,but do u think it is going to make any problem if I use the same code???
|
|
|
|
|
Actually previously you were using datagrid where it is working fine but here it seems that you are using gridview and here it doesnot work. BTW in 2005 also you can use datagrid unless you have some specific reason to use the gridview. 
Best Regards,
Apurva Kaushal
|
|
|
|
|
No we have been told to use GridView.Please tell me any other way you know.
|
|
|
|
|
Here in gridview what you can do is to create a headertemplate and then put the control you want and then use it.
Also you can have a look at this link[^]. The same thing is being implemented here in Gridview.
Best Regards,
Apurva Kaushal
|
|
|
|
|
No its not working.I need the image also....
|
|
|
|
|
What is not working? Have you followed the content in the article or you tried it with just applying headertemplate control.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I cant see headertemplate Control??how do I start???
|
|
|
|
|
It would be something like this inside the gridview:
<code><asp:TemplateField>
<HeaderTemplate>
<asp:Label ID="ii" runat="server">kaushalk</asp:Label>
</HeaderTemplate>
</asp:TemplateField></code>
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi to all,
I need to know.... how to create One click installer for web project for VS 2003.
Thanks in advance
Sajjad
|
|
|
|
|
|
thanx man
|
|
|
|
|
Hello & Smiles,
I had to add a new field to one of my old projects which was designed using Datagrid, it is a checkbox field with datatype as 'Bit'(SQL 2005)same as boolean. I added the checkbox in datagrid as below:
<asp:templatecolumn headertext="Current Driver?">
<itemTemplate>
<asp:checkbox id="cbcurrentdriver" runat="server" autopostback="true" checked='<%# DataBinder.Eval(Container.DataItem,"currentdriver") %>' />
</itemTemplate>
</asp:templatecolumn>
In the Insert and Update Sub's I added the code as below:
Dim chkbox As CheckBox = CType(e.Item.Cells(9).FindControl("cbcurrentdriver"), CheckBox)
If chkbox.Checked = True Then
Command.Parameters.Add("@currentdriver", SqlDbType.Bit, 2).Value = "True"
Else
Command.Parameters.Add("@currentdriver", SqlDbType.Bit, 2).Value = "False"
End If
Also, included the field in Databind for Datagrid with select * from etc...
This works fine when I open the page in update mode and shows the status of checkbox as checked or unchecked depending upon it's value in database.
My datagrid has a feature 'Add New row' which blank row and this part fails giving me the error -
Conversion from type 'DBNull' to type 'Boolean' is not valid.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Conversion from type 'DBNull' to type 'Boolean' is not valid.
Source Error:
Line 1175:<asp:templatecolumn headertext="Current Driver?">
Line 1176:<itemTemplate>
Line 1177:<asp:checkbox id="cbcurrentdriver" runat="server" autopostback="true" checked='<%# DataBinder.Eval(Container.DataItem,"currentdriver") %>' /></itemTemplate>
Line 1178:
I have been struggling with Null checks for checkboxes etc... for last two days. Any help is Gratifying.
Thankyou.
Aartee.
...HE is watching Us All!
|
|
|
|
|
hi , try to use default value in database as 'F'.it may help u
thanks and regards,
Kinnu
|
|
|
|
|
Hello Kinnu,
Thankyou for your reply.
I did try giving it a default value 'F' with 7 without quotes, I even tried default value false and NULL but it didn't work and SQL database is giving me an error when I type the default value as: Error validating the default value for column 'currentdriver'. It does not give me this error when I enter default value as NULL or 0 but my program is still not working and giving me the same conversion (DBNULL to Boolean) error.
Thanks once again. Please let me know if you have any other tips or suggestions.
Aartee.
...HE is watching Us All!
|
|
|
|
|
Since this is a bit column you need the default value to be 0 which is false and then you would avoid this. Also if you dont want a default value, create a Protected Function in the code behind and pass the value from the Datagrid DB value and accept it as an Object, check for DBNull and if it is return a 0/False whatever works.
Cleako
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
