.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to create time-sheet ?

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :ASP.Net
I don't know what can I call it in English? 01-Aug 02-Aug 03-Aug ... 31-Aug worker A 8(textbox) 8 ... 8 worker B 4 8 ... 8 worker C 8 8 ... 8 ... ... ... ... ...                                              Submit buttonhow to create a datagrid like above, date columns (days of month): dynamicallyworker column: name of worker in each department: dynamicallywe will enter number of hour worker do everyday in textboxThanks

View Complete Post

More Related Resource Links

How can I create a Table to represent a Job schedule sheet?

I have the following database, consisting of 3 tables: Job, JobPhase, Assigned (as seen in the following image) I'm trying to create a page that will hold a table. The table will represent, for a particular employee (ID = D_ID), his/her corresponding Job Schedule sheet. This table will consists of the following columns: Job ID Description (from table 'Job') Comments (from table 'Assigned') 7 columns representing days of the week, with the first column representing Today's date, the next column representing the next day...-> The 7 columns for the dates will not come from the database itself (as opposed to the other columns). However, for each row, we have to check wether the start date(s) of the job's phase(s) are equal to the date column (the image will make this more clear) An example of a such table would as follows (for the employee whose D_ID is = '555'): Any ideas how I can create such a table?? Should it be done in recursive html? Or gridview maybe?? Thanks for any info

Create zip file of dyanamicaly generated Excel sheet in c#

hi all,   I want to give product details in excel sheet but that excel sheet should be zipped and then pass it to user. I know how to create excel sheet from database but  how to pass that excel sheet into folder and then zip that folder..?   plz giv me any solution 

How to create templete controls inside a gridview at run time


i am creating a grid view at run time.now i want to create controls inside the gridview at run time itself,and how to Bind/Eval it.

plz help me

Create Data List at Run Time


hi friends,

I need ur little help, i have a dataset filled from the DB,

let assume the data in the dataset is: -

Inderjeet          Name          Jagjeet          Father's Name          BE.           Qualification.          and so on at infinite level. set by the user.

now i wana bind my data in the Data list:-

bind like as:-

header template would be bind with the data comming at 1 3 5.... and so on position.

I tem template would be bind with data at 0 2 4..... and so on position, Here a point need to conern is that, i dont know the no of coulmns in the data set, so i cant put the label in the header template and item template, all would be set at the run time according the data into the dataset.

the data list structure should be lke above:-




<th>Father's Name</th>




How to create a new folder with contains of note pad in every time

<!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -->

Hello every one,

How to create a new folder with contains of note pad in every time. I mean if I am clicking on a new folder it’s automatically creates with notepad in that new folder. Please help me any one.


Thanks in advance




how to create date time event in sharepoint workflow



I want to change the status of a list item one month after its approval. which event should i fire and how do i do it in workflow. any idea.



Time, not just date, is part of PK--should I create a time dimension?



Should I create a time dimension if the time is part of the primary key?  I'm trying to create a fact table of successful user connections.  Since each user can connect their device more than once per day, I don't have a complete primary key.  What's the correct way to handle this?

I just thought of something: should I be using storing an aggregate by date key instead, so that each line has a "ConnectionCount" column but not a "ConnectionDate" column?

Thanks for your help,




TABLE MyFact (

Create a table with Time ranges


HI all,

I need to create a table with two columns TimeKey and TimeRange with the following data.But the data has seconds and minutes .

what is the correct format to create table with these two columns and insert the below data .is it correct to insert time in two different formats into the table as seconds and minutes or that should be in single format.

0 <15 seconds

1 15-30 seconds

2 30-60 seconds

3 1-3 minutes

4 3-5 minutes

5 5-10 minutes

6 10-15 minutes

7 15-20 minutes

8 20-30 minutes

9      >30 minutes


How to create and copy files into a subdirectory at run time.


Good Day,


I have a folder on my server say:


in that folder there is 4 folders






in the pics folder is jpg's that are the buttons for a web page, the web page is in the MasterArt folder and is named default.aspx


upon a user creating an account, i have my program create a folder under a subfolder named ARTIST

I got that part but now what I need to learn how to do is to have at run time, when a new user creates an account, that my program creates a subdirectory under the ARTIST subdirectory and then I copy the default.aspx from the MasterArt folder into their folder, then copy the folders and contents of the 4 subfolders (pics, videos, music, other) so that they now have the direcotries and its contents.


Example: I create a user account and my artist name is Kevin

a subdirectory is created called Kevin, the folder Kevin should now have the default.aspx page, and 4 sub folders, pics, videos, music, and other.


How do I do this? I thanks in advance for any help!



Static "forms" used as a background to the XPS fixed pages to cut down the time to create XPS file



with Postscript I can define a resource (a static reusable form in this case) and reference that resource on any page I chose without having to recreate all the drawing instructions stored in that form resource.

How would I be able to do something similar with XPS?  Can I create a grouping of UIElements (drawing / text / image) as a resource stored at the FixedDocument level and then just include a reference to that resource on specific FixedPages?

Would seem illogical in the XPS file format to not be able to merge a single resource on the fixed pages which is a group of static UIElements which appear exactly the same on each of those pages.  Would cut down on repeat elements on every page and should end up with a smaller file size.



create one-time backup files


(using SQL 2008)

Here is my situation.  I have administrative rights to a particular database, but not the entire server.  The server admin makes a new backup every night for all the databases. 

At certain points in time, I would also like to save a backup file of my database, but of course don't want to alter the existing backup schedule.  Is this possible?

Round off time to the nearest minute

How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.

How to create 3 tier application using LINQ

As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)

Create ToolTip for GridView Header

The following allows you to add a tooltip to the header links of your GridView, a feature that is lacking.

display data into GridView from excel sheet

I have to display data from excel sheet into my gridview and also I need to figure out a way to store data into excel files from my web page. I am using C# 3.5, VS 2008.

Create And Run Excel Macro At Runtime in C#

You've been tasked with writing a Windows Form application using the .NET Framework that interacts with Microsoft Excel. If you are new to working with Excel in .NET and are having trouble learning how to format certain cells or cell ranges, then this little tip will come in handy. Rather than scour the internet hoping to find the correct set of constants or method syntax for formatting your spreadsheet, use the built in tools in Excel to write the familiar VBA code for you. Then, you can paste the VBA code generated by Excel into the sample C# code below and run it dynamically at runtime.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend