|
Hi!
I have a DB table that references it self to create a hierarky. If the ParentRoleId column is null then the Role represents a top level role:
Database columns:<br />
RoleId PK (Identity)<br />
ParentRoleId FK (Allow null)<br />
RoleValue
Now to the question: I'm using typed datasets as database access, but the generated code for the ParentRoleId column is of the type int and thus doesn't support null.
How should I create a workaround for this?
|
|
|
|
|
Aloha,
We have a datagrid with some templatecolumns that show datetime data in an European format (day/month-year).
Everything looks great, but they don't sort correctly. It looks like they are sorted like normal text strings, so day is considered before month and year:
11-05-2006 - should appear last, since it's later than all the other dates
12-04-2006
13-04-2006
14-04-2003 - should appear first
Any idea how to fix this?
Thank you,
|
|
|
|
|
You can set the datatype of the column you are sorting on to be datetime rather than string.
|
|
|
|
|
How? I thought the same, so I have looked high and low for such a property. I can't find any 
|
|
|
|
|
myDataSet.Tables(0).Columns(0).DataType = GetType(System.DateTime)
|
|
|
|
|
Yes, it would be easy with a dataset. Unfortunately we have a dictionary<int, object=""> where the object contains the data for a row in the datagrid.
The object contains datetime properties for the data we want to display in the datetime columns.
|
|
|
|
|
How are you then performing the sorting?
|
|
|
|
|
Implemented the OnSort event on the datagrid. The data is in an ArrayList format and I sort it using the ArrayList.Sort() method.
Maybe this can be changed to handle datetime values?
|
|
|
|
|
You'll need to alter that code to handle sorting on the particular data type - if you're using .net 2.0, i'd consider using a List<T> to allow you to use explicitely set types - by default the arraylist contains only items of Object type - it doesn't know how to sort them.
|
|
|
|
|
hi dear
i am using a typed dataset to load data from database have some modification in it and then updating it back to database...
while inserting row into one of typed dataset's table it is clearly indicating count=1.. and i am again reusing that inserted row in to typed dataset's table ... but while at time of updating that table back to database it is throwing an exception that "null value cannot be inserted into 'MyColumnNameInDataTable' because it cannot contain null values"..
i am unable to sort it out...
please help me...
regards
vishal sharma
vishalsharma808@hotmail.com
Thanks & Regards
Vishal Sharma
vishalsharma556@yahoo.co.in
|
|
|
|
|
hi Vishal
Do one thing debug the code and find that before updating the database
datatable should contain the data. Might be you are trying to update emty dataset into database
Can you post the code so that after seeing it we can come to any result
|
|
|
|
|
I have some large text bound to the asp:label control.I want to add a note to the lines i want.So when i click the mouse at the starting point of the line,an image button should be placed at that point.
when i click the mouse at another starting point of the line,the above image instance should be placed here.
I have tried several ways of doing these.....but couldn't get.
PLz help me out of this problem........
|
|
|
|
|
Hi Friends ,
I have 2 dropdown on my webpage . I am taking the index value from one dropdown using javascript , so i have make the AutoPostback Event property off for that dropdown control . Now , i want to fill the another dropdown , by filtering on the basis of value selected from first dropdown.
Can you please guide me , for above problem?
Thanking You,
Param
param
|
|
|
|
|
You can write following code on SelectedIndexChanged event of first dropdown list. and then load the data based on first dropdown's detail. and in second drop down keep AutoPostback off.
/***************************** Code *************************************
Protected Sub Dropdown1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles SelectCmpCmb.SelectedIndexChanged
Dim str As String
str = "Select CompanyName from Company where
CompanyName = '" & dropdown1.Text & "'" (Name of your first dropdown list)
dropdown2.DataSource = dbaccess.ExecuteDataReader(str)
dropdown2.DataTextField = "GroupName"
dropdown2.DataBind()
End Sub
Note : Here dropdown1 is name of first dropdown list.
and dropdown2 is name of second dropdown list.
I hope this will help you.
|
|
|
|
|
hi All
I have datagrid.Which contains Three fields.
my second column is button column.when i click on that button my jaavscript is fired.
My problem is : i want grid cell in javascript.I have total value in hidden.I want to store in different cells of third column of datagrid.
How can i use of datagrid property in javascript?
Thanks
monika
|
|
|
|
|
i think you don't have datagrid property in javascript as it is server control specifically for asp.net
My suggestion for you is that create a custom control and write the html tags in the render method which is good solution I think
|
|
|
|
|
In the item databound event, you should be able to get a reference to the hidden field for that row. When you have that, you should then be able to pass the ClientId of that control to your javascript function in the button click event.
|
|
|
|
|
Hi
Thanks for yr reply.
My grid name is Datagrid1
id = DataGrid1.UniqueID() this code is written in itemdatabound event.
I have one hidden field.Store value in that.ok
Now my question is I have to assign this hidden value in datagrid cell using javascript.It's my requirement.So I can't changed.
If u have code for refence,pls give me.
I hope u getting my question.
Thanks
monika
|
|
|
|
|
Something like this (in the OnItemDataBound event of your grid):
Dim myHiddenField As HtmlInputHidden
Dim myButton As Button
myButton = DirectCast(e.Item.FindControl("buttonId"), Button)
myHiddenField = DirectCast(e.Item.FindControl("hiddenId"), HtmlInputHidden)
myButton.Attributes.Add("onclick", "JavascriptFunctionName('" & myHiddenField.ClientID & "');")
Then in your javascript function you can use that id to populate your hidden field with whatever data it is that you need.
|
|
|
|
|
hi this is ajay..
can any body suggest me a solution for a link to calendar control
actually i have to use a calendar control in my asp.net page.
where i want to open a pop up window to use a calendar control and on click of the date populate it in my text box on parent form.
any link...
|
|
|
|
|
|
Hello,
I'm working with active directory and I've used:
directorysearcher search =new...;
search.propertiesToLoad.Add("cn");
That give me the user name. now if I'm also getting the "memberof" property I'm getting alot of groups for the user.
Is there a built in function that tell me if the user is in a specific group instead of writing my own function that will run on all the groups that the user is a member of them and compere?
some thing like:
bool x=isCurrentUserMemberof("myGroupName");
Hope i was clear enough.
Thanks.
|
|
|
|
|
I have Placeholder in which runtime table is generated.
Now on button click i want to transfer all the data displayed by placeholder into ms-Word...
Plz give any links if possible...Note it is placeholder in which runtime table is generated not datagrid...
-- modified at 3:39 Monday 4th December, 2006
|
|
|
|
|
How to work with sqlserver 2000 on internet(its working fine in local with IIS).
i need to deploy my asp.net 2.0 with sql server 2000 web application over internet.. please give some suggestion for this issue
Regards
RPL
r_palanivel83 10:01 4 Jan '06
|
|
|
|
|
Your web hotel should have some instructions on how you set up your database on their specific database server. Provided of course that you have an account that includes database support...
---
b { font-weight: normal; }
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
