select distinct tbl.emp_code, b.EmplName, convert(varchar, tbl.punched_date,101) as Punched_date, (select convert(varchar(8),itbl.PUNCHED_TIME, 114)+', ' from Trn_Capture_Data_New itbl where itbl.EMP_CODE=tbl.emp_code and itbl.PUNCHED_DATE=tbl.punched_date and itbl.EMP_CODE='4' and tbl.punched_date >= '03/27/2013' and tbl.punched_date <= '03/28/2013' for xml path('')) Punched_Time
Now i need to Bind it to gridview, the gridview columns should be
Date,IN,OUT,IN,OUT
In punched time the first one should be IN and second OUT. A employee would have punched several time a day. Based on that I should take maximum punches and bring that of columns as IN and OUT in gridvew dynamically. How to achieve this?
I have the following string, is it possible to split seperate & make as comma seperator string by 'and', 'or' and 'not' operators. "Application AND for Payment OR John OR Smith OR Ralph Doe NOT Bob NOT Ad Hock" and assign to the following variables:
Here is what i would like to be able to do with the urls/routes:
1) www.domain.com/customer/home/index
2) www.domain.com/home/index
Where both the home controllers should be seperate controllers with seperate views and the company part should be an param for all the actions in the controllers.Now why i want to be able to do this is because of the following scenario: Each customer will have there own pages (which actually will all be the same for each customer but with different information per customer). The one without the customer is the general website where non customers can go to to become an customer or get information about the services we provide for them, they can sign up etc.
I retrieve the date & time from datetime field in sql using a reader:
[Code]....
This value returns e.g. 15/04/2010 8:00:00 but I would like to split the day value (15), month value (4) etc from the overall datetime value, so I can assign dropdowns with corresponding (preselected) day, hour selection ..I know the dropdown assignment process, but I can't get the datetime field/value split ..
How can I return a comma delimited list of codes for each client, to a temp field in the results of a select statement in a stored procedure?
Is it posible to get a comma delimited list into a temp field of a temp table?
I have a table tblCodes that has the following fields ClientID, CodeID
I have a table tblCodeLookup that has the following fields CodeID, CodeDecription
I need to get a temp table with two fields ClientID and a field that holds a comma delimited list of CodeDescriptions for each clientID. Maybe the tmp fiel would be named ClientsCodes Select clientID, ClientsCodes
I got the difference between Bind and EVal from here. Bind will do both way reading and writing. And Eval do only reading. So any function only for writing?
i have one hidden field and i want to bind it with two values of my data base separated by an coma. some thing like ->asp:HiddenField ID="hfRstidDate" runat="server" Value=<%# DataBinder.Eval(Container.DataItem, "tsk_ID"),DataBinder.Eval(Container.DataItem, "Date_Worked").ToString())%>
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.
From Google i figured out these can be used to bind the columns in GridView to ArrayList. But what is "some property" ?For example i have a ArrayList in .aspx.cs as
static ArrayList componentSelectionArray = new ArrayList();
so can i just write in grid view to bind a arraylist to grid view columns as:
I have a button inside my <ItemTemplate> in GridView and I want to call a javascript function on the OnClientClick of that button passing the DataItem value as a parameter of the javascript function
[code]....
If I will not put a parameter in CreateEditAddess() this works well but I need the parameter.
I know I can put the OnClientClick event value in OnRowDataBound event of the gridview but I don't want to put it in CodeBehind. It seems like the server tag is not parsed correctly.
I have a listview control on an .aspx page. Inside this list view i want to check "Type" property which comes from database. here is the example code :
[code]...
As a last resort i tried to user DataBinder.Eval() but i get the exception "Expected class, delegate, enum, interface, or struct". What can i be doing wrong? Writing a function in code-behind isn't an option for me.
The following seems reasonable, but it returns an error:
<asp:Repeater ID="RepeaterF" runat="server" DataSourceID="DSF" > <ItemTemplate> <% If Eval("Item_Batch") = 0 Then %><tr><td></td><td colspan="2"></td><td></td></tr><% Else %>........
Error: "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."
I am finding it difficult to accept that the whole Repeater approach has any benefits over just creating a loop in code, iterating through a recordset, and building a html table into a variable, then dumping it to the page. This repeater is spawning pages of code and objects, and surely this is all using up server resources.