Data Controls :: Split Time Based On Comma As IN And OUT Time And Bind It To GridView

May 15, 2013

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

[Code] ....

I have the above query and that gives me result

Emp_code EmplName Punched_date Punched_Time
4 XXX 3/27/2013 14:22:00, 09:44:00, 10:38:00, 11:01:00, 16:12:00, 18:25:00, 
4 XXX 3/28/2013 13:14:00, 09:49:00, 18:02:00, 

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?

View 1 Replies


Similar Messages:

Data Controls :: Split And Bind Comma Separated String Data To GridView

May 7, 2015

Suppose i got a string from select statement:

and string is eshant, amit, ajay, varun, akbar

now i want to show or bind as hyper link in below format.

#eshant #amit #ajay #varun #akbar

with each as hyper link .

How Can i achieve this.

View 1 Replies

Forms Data Controls :: Format Date Time In Gridview Using Bind?

May 7, 2010

I would like to format the date time to

Monday 7th May 2010 9:00 am

What is the format string using <%# Eval("StartSession", "{0:?????}") %>?

View 4 Replies

How To Send Reminder Emails Based On Users Input Time And Day (based On Their Time Zone)

Mar 24, 2010

I need to send emails based on users input time and day (based on their time zone)? Kind of a reminder.

For Example: User input 2:00pm Eastern Time on my server I have different time zone, how to calculate the time and send the email at users time-zone. Its a web application. What is the best way to accomplish it using asp.net c#? If somebody already done it in the past I will be glad to take a look at source code.

View 1 Replies

Forms Data Controls :: How To Read A .txt File And Bind Data To ASP.NET Gridview At Run Time

Dec 10, 2010

Mr requirement is i am uploading a .txt file and read that .txt file and bind that data to ASP.NET Gridview control. My .txt file is look like below:

% Compressor type: GT12 C224(38) 55 Trim 0.38 A/R
% Turbine type: GT12 T202(35.5) 72 Trim 0.39 A/R
% Initial data file name:20050669-02.cdt
% Polar inertia: [kg.m2]
% Comment:DATA REDUCTION CODE REV 2.04 RELEASE 03-OCT-2004 (REFERENCE: REPORT 99-0145. REPORT 03-0901. TI-056)
% P reference: 100000Pa - T reference: 298 K
% NC WC PRC ETAC
% RPM KG/S T-T ----
115030.5714 0.0170 1.3398 0.5698
115030.5714 0.0239 1.3209 0.6155
115030.5714 0.0291 1.3020 0.6282
115030.5714 0.0339 1.2822 0.6377
115030.5714 0.0380 1.2576 0.6209
115030.5714 0.0416 1.2311 0.5955
134956.4286 0.0405 1.4045 0.6852

How to read this file and bind data to gridview control.

Right now i am using the following code but it stores whole data in a single column and a single row but i need it in four columns named NC, WC, PRC,ETAC and it's values in respected columns.

Code:

protected void Button1_Click(object sender, EventArgs e)

{
String ext = System.IO.Path.GetExtension(FileUpload1.FileName).ToUpper();
if (ext == ".TXT")
{
String content = System.Text.Encoding.ASCII.GetString(FileUpload1.FileBytes);
String[] ar = content.Split(';');
GridView1.DataSource = ar;
GridView1.DataBind();
}
}

how to get data in four columns in Gridview as a tabular format. I am using technologies Visual Studio 2005, ASP.NET 2.0,C#.NET 2.0 and Windows Xp Operating system.

View 7 Replies

Forms Data Controls :: Gridview With Checkbox Update One Time In A Button Click Not Every Time?

Mar 11, 2010

I have a gridview on my page. I have a checkbox in each row of this gridview. For each checkbox in the gridview, I'd like to update my table accordingly, but I don't want them to have to hit a submit button every time they check the checkbox. I want them to check all the boxes they need to and at the end, they should hit one submit button.

View 12 Replies

Forms Data Controls :: Displaying Data On Gridview Based On Time Form 15 Minutes

Nov 9, 2010

I have a Transport Detaisl in DB , i want to dispay data on gridview with marquee scrolling up. Cabs are scheduled for drop every hour. So if drop is at 7pm i hav to dispaly on data of that hour from 6:30 to 7:15 later after 7:15 i have to display next hour data ie 8:00 pm drop data. I am able to get scrollin g data on gridview but how to schedlue it to scroll for such timings

View 1 Replies

Data Controls :: Split String And Bind It To GridView

Jan 4, 2014

I have a string of CustomerId and Cusotmername like "1233Adsf 48872Hjyu 1289Rtop. how to show this record in Data Gridview??

View 1 Replies

Web Forms :: Display Start And End Time Based On If Current Time Falls In Range

Dec 23, 2013

I need to do to the following:

Find if the current time falls within hourly ranges  and display the start hour and end hour of that range in labels.

Examples:

 If the current time is 8:46am, label startTime would return "8am" and label endTime would return "9am"
If the current time is 10:01pm, label startTime returns "10pm" and label endTime returns "11pm"
If the current time is 12:59am, label startTime returns "12am" and label endTime returns "1am"

I have been working with the C# TimeRange class but not getting what I need.

View 1 Replies

Web Forms :: Implementing A Time Based Event Time Zones?

Apr 18, 2010

I'm having an issue working out how to implement this time based event. Basically, my program needs to send out an email at 12AM monday morning. But the email needs to go based on the user's local time not 12AM server time.

the problem i have discovered is Daylight savings. I used current server time as 12:00AM (my local time) and my actual offset is -7:00 UTC but after the calculation i get -6:00 utc because of daylight savings. If a user was in -7:00UTC then he/she will not get the email at 12am localtime but an hour late.

View 2 Replies

Data Controls :: Bind Comma Separated String From Database To GridView

May 7, 2015

I have a string in datbase like 10,11,12,13,14,15.

I want to bind in GridView as 

10

11

12

13

14

15

View 1 Replies

Forms Data Controls :: Time Used As "amount Of Time Available", Not Time On A Clock?

Jul 6, 2010

how to suppress the "AM" in the gridview (template Bind("RideTimeMin", "{0:t}")? Don't tell me to use military time because the function is not "time on a clock"; it's how much time is allowed for a task (in this case the min/max hours & minutes that horses have to complete a 20 mile trail; e.g. 05:00, 05:27, etc). I'm currently accomplishing this in the "ondatabound" function by "..RTmin.Replace("AM","")". I have looked and looked at all the websites that talk about datetime formatting but have yet to find a way to do it upfront in the gridview bind statement.

View 6 Replies

How To Split Comma Seperate DataItem Field In GridView Eval

Mar 11, 2011

here my code-

<asp:TemplateField HeaderText="HIGH RISK (10-12)" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:Label ID="lblHighrisk" runat="server" Text='<%# Eval("URANGE").ToString().Split('-')[0] %>' />
</ItemTemplate>
</asp:TemplateField>

but that is giving compile time error 'Server tag is not well formed'

View 2 Replies

Forms Data Controls :: Comparing Time In Field Vs Current Time?

Mar 18, 2010

I have a date/time stored in a smalldatetime field (ms sql 2005) that i want to compare with the current time and receive a difference. If the difference is less than 30 minutes, do this....if more do that....

View 1 Replies

Forms Data Controls :: Show Time In Grid View / Time To Send A Scrap?

May 26, 2010

My problem is that I have a grid view that show the data from database.In my gridview i add a column name date .like eg You knw that when we send a scrap to anyone then show time how much time to send a scrap.

View 6 Replies

Forms Data Controls :: Asp 3.5 Time Field In FormView / Update/insert Time Fields?

Oct 20, 2010

This is the sqlDateTime overflow problem again. Background. As I'm sure you know dates must be between 1/1/1753 and 12/31/2999. If you have an empty date field, it throws and exception. So I created a function (below) that solve the problem when attempting to update or insert a record with a date field. Works great.

Public Shared Function MakeDateField(ByVal pasDate As String) As Nullable(Of DateTime)

If IsDate(pasDate) Then
Try
If pasDate <= System.DateTime.MinValue Then
Return Nothing
Else
Return CType(pasDate, DateTime)
End If
Catch ex As NullReferenceException
Return Nothing
End Try
Else
Return Nothing
End If
End Function

So I thought about using a time field. I have the field, have the validator in place and then attempted to test the page. It resulted in my least favorite error message "sqlDateTime overflow".

I can think of several workarounds like adding a date or a fixed date to the time field, or converting it to a string. Each of these is problematic.

IS THERE A BETTER WAY TO UPDATE/INSERT TIME FIELDS.

View 2 Replies

Forms Data Controls :: C# - Create A 'Time" Column Which Shows The Elapsed Time In HH:MM Format?

Mar 18, 2010

I have 2 fields being displayed in a Gridview, StartTime, EndTime. I want to create a 'Time" column which shows the elapsed time in HH:MM format. (StartTime - EndTime) This was all generated with VS2008, table is pulled from an SQL Query.

View 1 Replies

Global Time Settings / Displaying The Canadian Time Instead Of India Time?

Oct 1, 2010

My web application has hosted on the canada server but my all clients are indians.So, as I am using System.datetime.Now to store all the dates in application.Obviously, it is displaying the canadian time instead of india time.How can i do it?Is there not any gloabl settings that we can do in our web.config file so that it indicates to the server at run time which time zone to execute..?Or any other suitable alternate?

View 3 Replies

Web Forms :: Split Date And Time From DateTime And Display In TextBox

Dec 4, 2013

There is a "singleline" Textbox in my page in which both date and time are fetch from database table column "DateTime".

I want Time to be come below Date in that "singleline" Textbox.

I can't take that Textbox as "multiline". How to split date and time in singleline Textbox?

How to achieve this?

View 1 Replies

DataSource Controls :: Split Recods If Column Contains Comma Else Display As It Is?

May 31, 2010

I have table that's contains 2 columns Name and IDs (VarChar(10)) values are stored as

Name IDs

Test1 Test2 1

Test2, Test3 2
Test3 Test4 3
Mohd Farooq 1,2,5

My requirement is to display as below
Name IDs
Test1 Test2 1
Test2, Test3 2
Test3 Test4 3
Mohd Farooq 1
Mohd Farooq 2
Mohd Farooq 5

View 7 Replies

To Get The Time Difference Between The Replied Time With Arrived Time Of The Mail?

Aug 2, 2010

i have to listen my mail server for every 30 min. i have a distribution list and i want to count number of email comes for that distribution list and no of replies goes from the outlook for every 30 minutes. also i need to get the time difference between the replied time with arrived time of the mail. so show me some sample code

View 3 Replies

ADO.NET :: How To Format A TIME COLUMN In SQL 08 To Regular Time And Not Military Time

Mar 5, 2011

Anyone know how to format a TIME COLUMN in SQL 08 to regular time and not military time? VB.net

View 2 Replies

Data Controls :: How To Hide Show Panel Based On Date Time And Current Date

Oct 8, 2013

Here what i am trying to accomplish. I want to have a div or panel on the page and have some text on it. The div or panel must hava a specfied time limit and then disaaper from the page. Say i want this text to apper on 10Cotober 10.00  and disapper from the page on 11October 18.00. 

View 1 Replies

Data Controls :: Condition Based Data Bind In GridView From XML

Jul 29, 2013

From my code I got all of my data from my xml database .. but I need to display only the data with match of my date. For example if i I give date as 7/25/2013 the data within the date oly want to display in grid view my c# code is

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;

[Code] ....

My xml database is 

<?xml version="1.0" encoding="utf-8"?>
<registration>
<Date> </Date>
<Name> </Name>
<Qualification>
</Qualification>
<areaofinterest>
</areaofinterest>

[Code] ..... 

My design view code is 

<%@ Page Language="C#" MasterPageFile="~/phoenix.master" AutoEventWireup="true" CodeFile="grid1.aspx.cs" Inherits="grid1" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content> <asp:Content ID="Content2" runat="server"
contentplaceholderid="ContentPlaceHolder4">

[Code] ....

View 1 Replies

How To Get The Time Slot Of Telerik's Scheduler From Client Side By The Time Or Date Of That Time Slot

Nov 19, 2010

I'm using Telerik's RadScheduler Control with WebService Binding.

I've used RadScheduler with Server Side Binding which has an event called "OnTimeSlotCreated" which fires every time when a particular time slot creates so that i can access the time slot and get the control (HtmlTableCell Control) to modify it according to the requirement.

But now i'm binding it from client side through WebService which has no such "onClientTimeSlotCreated" event, also these time slots are not having any identity at client side to access.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved