this is my sql query and its work fine in my code but it only check ParentDeptID IS NULL it not working when ParentDeptID field is empty how can i check it
("select DeptID,DeptName,(select count(*) FROM HrDept " _ & "WHERE ParentDeptID=sc.DeptID) childnodecount FROM HrDept sc where ParentDeptID IS NULL ", _ objConn)
I'm trying to populate the DataPager using Container.DataItem (I'm not allowed to use FindControl) but I get this error
'System.Web.UI.WebControls.DataPager' does not contain a definition for 'DataItem' and no extension method 'DataItem' accepting a first argument of type 'System.Web.UI.WebControls.DataPager' could be found (are you missing a using directive or an assembly reference?)
I have setup my business object to have a create_date and edit_date members both datetime datatypes. My company want to display the create_date and edit_date fields in a gridview for each transaction. The problem i have is that after insterting a record it will have a valid create_date but no edit_date and when displayed in the gridview it defaults to datetime.minvalue (My default). How on earth do i show an empty field in my gridview for a null datetime field in the database?
I am using similar architecture to the Imar Spaanjaars example of a tiered solution. With a few small tweeks it has worked well for me for ages. I am passing a List<Database> to my object datasource which connects to my gridview.
I am collecting user roles into a single dimension string array.
I have a repeater that its source set to that array. The repeater template includes list of checkboxes for the values in the array.The checkbox text is set to: Text='<%# Container.DataItem %>'
All is good till this point.
But I am trying to call a javascript function triggered by clickign a checkbox and pass it the container.dataitem, but the javascript doesn't seem to be reading the value and either complain about string not being in correct format or that treats the container.dataitem as a liter. This is the trial that didn't work (I tried many different things too):
DetermineVal(<%# DataBinder.Eval(Container.DataItem) %>); determineval is my javascript function
I have a ListView in which i have a function that creates images for users. I pass userGender,userImage1name,userIsImage1Aprooved values to the function in which i generate image.ie. if user has approved image i return it back, otherwise i return default image based on gender.y question is, is there any way to avoid passing 3 parameters to that function and to pass whole DataRow so i can get values of columns i need?In reality i pass about 12 parameters just made it easy for you.ie. i want to achieve something like that <%# GetImage(Container.Item) %> while in GetImage() i would be able to access Item("some_column_name") or C# version Item["some_column_name"].
How do I check if my value is empty AND Isnull? I need to check for both, using ISNULL is not enough because the data can change just so that it is empty.
In a nested GridView (GridView inside a template column of parent GridView). I am binding child GridView to a DataTable in parent GridView's RowDataBound event. this works as it should. But the problem i am facing is in Child GridView's RowDataBound Event, when i try to access e.Row.DataItem property it returns null. I am expecting it to return DataRowView Type. which i will then use to set values of TextBox's.
I have set the value of an int parameter to the attribute of a textbox.The textbox can be empty or null, how to check whether the parameter is empty or null?
I'm fetching som data from AD and I notice that I'm getting an exeption and notice that one of the users field that I'm fetching is empty, how can I prevent exeption.
What is the proper way to check for null or empty strings on dynamic objects? This is the only solution I've found so far:
if (admin.PasswordHash.GetType() == typeof(DBNull) || admin.PasswordHash == string.Empty)
If the field is null, the object returned is DBNull.Value, but if the field is empty string, it's return as a System.String object. This makes it impossible to do regular "admin.PasswordHash == DBNull.Value" check, as that will fail whenever the field has been set to empty string. Is my example the right (and only) way to go?
I'm trying to pass a string value to a javascript function from a LinkButton's OnClientClick event, but the function is receiving "<%# Container.DataItem %>" instead of the value. Here's the code:
The container is a collection of strings. Why is it not evaluating?EDIT: This is located in a nested ListView. The datasource for the inner ListView is a property in the datasource of the outer ListView.
I am trying to access the current 'active' top level node from a sitemap repeater from outside of the ASP.NET repeater used to render it, this is for CSS styling purposes as I want to place the child nodes on the subsequent row with different styling horizontally. At present I have the following code which I can't get to display correctly using CSS.
[code]....
I would like to display the child nodes on the next light blue element which I can do perfectly well from a seperate div if this was not rendered using a child repeater. In the image below Blog and Services are top level nodes and their subseqent nodes (2 for each) should be displayed on the light-blue row below. Is this possible?
I use a ItemDataBound for a repeater.But i use 2 kinds of linq querys to bind it.Some of them has a MerkID, and some doesnt have this item.So its easy i need to do this:
if(e.Item.DataItem.Contains("MerkID"))
{ //Code for linq query 1
} [code]...
So of course the if selection doesnt work, but how can i do that? I already tryed this:
DataRowView drv = (DataRowView)e.Item.DataItem; if (drv.Row.Table.Columns.Contains("MerkID"))
But that doenst work because he cant convert it to a datarowview because its a linq class.So what to do? Right now i use a try and catch, but there are better solutions i guess...
i am using a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
When handling the OnUpdateCommand event on a RadGrid the DataItem is null.
I thought that this would also represent the data item being represented by the row.
The Radgrid is populated from an IList and in the handler the code looks like this...
protected void rgAllocatedClients_UpdateCommand(object sender, GridCommandEventArgs e) { if (e.Item is GridDataItem) { var gridDataItem = e.Item as GridDataItem; var client= gridDataItem .DataItem as Client;
This works find when handling the ItemDataBound event but not when handling the UpdateCommand event. I really need this as in my Client class is the Id of the row I want to handle the update for.
I have a gridview with two bound fields. On clicking a button i want to display the values in first row of gridview in two textboxes. But if gridview cell is empty i am getting the text in textbox to which the value of cell is given as -' 'i know my problem will be solved if i use the template fields instead. But i want a solution while maintaining the bound fields ,if any.
i'm trying to check for an empty cell in a gridview.
On the RowDataBound event I tried the following:
- if (String.IsNullOrEmpty(e.Row.Cells[2].Text.Trim()))
- if (String.IsNullOrEmpty(e.Row.Cells[2].Text))
- if (e.Row.Cells[2].Text == "")
None of them worked.
I'm using boundfields. I can't use a TemplateField with a label because I need to check for other stuff for that column in the RowDataBound event by doing e.Row.Cells[2].Text - that only works if I use boundfields.