C Sharp :: Time Table Of School?
Mar 22, 2013
I have project "Time Table of school". How it possible logically as well as visually in .NET. it contain all teachers name and their periods. when any one absent then we enter the name of teacher or course name, highlight the absent teacher periods and then generate arrange period list and print it. when it highlight timetable we click on them and show all other teacher names who are free at this time.......
what controls are need in .NET with c#. it will be desktop application,
View 10 Replies
ADVERTISEMENT
Dec 30, 2014
I am doing a school project. The project basically is that it records the in and out time of an employee(of an particular company).The employee while checking in or out should enter a unique key generated specially for him so that no one else can check in and out for him.Then referring to the employees position( A worker or a manager or something like that) his total working time each day , for a week and a month is calculated. The company starts at 8 am and ends at 5 pm for 1st shift and for second shift from 3.30 pm to 2.30 am. Plus Saturday and Sunday off. Then after a month the program refers to the working time date stored in a file and calculates his pay(For workers its per hour salary and for managers it aint).
If an employee is consistently late the details are forwarded to the HR account( so that necessary steps are taken).This will support the company log the details of their employees duty time plus give enough detail to take action if someones always late. I'm doing this as a school project and it needn't be of enterprise class and all.. But i want the coding to perform as it should. Also i'm forced to use the old Turbo C++. Now i'm struck in the place where the time of the employees in and out time is logged. This coding does the work
Code:
void main( ) {
clrscr();
char dateStr [9],timeStr [9];
_strdate( dateStr);
cout<<" The current date is "<<dateStr<<'
[Code] ....
I think the second one is better as it not only gives me date but also gives me the day so i can check easily for the weekends. So, how these time functions work.
View 1 Replies
View Related
Mar 25, 2013
I have a C# .NET Application which get data from QuickBooks via the ODBC Driver and save the result to C# data table. So, I want to transfer this data table to a mysql table on my own server. That's the code I use:
using System.IO;
using MySql.Data.MySqlClient;
//Add mysql dll on the .NET Tab in Project's references
string connStr = "DSN=QBTest;";
string myServerAddress = "192.168.0.243";
string myDataBase = "CostTest";
[Code] ....
View 2 Replies
View Related
Nov 14, 2014
My table:
Code:
Database name: test & Table name : Profilemaster
+-----+--------+
| PID | PNAME |
+-----+--------+
| 1 | APPLE1 |
| 2 | APPLE2 |
| 3 | APPLE3 |
| 4 | APPLE4 |
| 5 | APPLE5 |
| 6 | APPLE6 |
| 7 | APPLE7 |
| 8 | APPLE8 |
| 9 | APPLE9 |
| 10| APPLE10 |
+-----+--------+
I like to read the table and get the all PNAME into the combo box.
Using the below code i can read the table, but while loop takes 2 seconds to read 10 records in the Profilemaster table.
How can i reduce the reading time?
My Code is
void MainScreen::OnreadProfileName() {
CDatabase database;
CString SqlString;
CString sDsn;
CString pname;
sDsn.Format("Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;Database=test;User=root;Password=client;Option=4;");
[Code] ....
Is any other way to reduce the query execution time?
View 6 Replies
View Related
Jul 9, 2012
I am beginner in developing C # and I will like to develop an application that a converte. csv file (table) in an xml file
View 1 Replies
View Related
Nov 22, 2012
private void button1_Click(object sender, EventArgs e) {
if (openFileDialog1.ShowDialog() == DialogResult.OK) {
TxtPath.Text = openFileDialog1.FileName;
} string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+TxtPath.Text+"";
DataSet ds = new DataSet();
[Code] .....
View 1 Replies
View Related
Nov 14, 2013
I am trying to work with C# and i am stuck here. My problem is i want to retrieve the count of all the users in a specific side. Let me Explain. Here is my table snapshot with sample data.
Now what i want exactly is that i get the count of users in a specific side as i give a user id as a parameter.The data is stored in MS Sql Database and i have to implement this on a website so efficiency of code is also a issue.
Suppose i give 1001 as input
The output should be : Left:1 , Right: 8
if 1002 is input
The output should be : Left:5, Right:0
if 1003 is input
The output should be : Left:3, Right:0
if 1004 is input
The output should be : Left:0, Right:0
if 1005 is input
The output should be : Left:1, Right:1
and so on. how to implement this thing. I also want to get a code which would return an array of all child users of a particular ID in a hierarchical manner so that i could process that data with RadOrgChart Control.
Attached Images scr.png (14.9 KB, 36 views)
View 1 Replies
View Related
Mar 26, 2013
how I update sql table using datagridview cell..... I want to edit cell and then press enter it update the sql table ... ??? It possible or not ... ?
View 3 Replies
View Related
Jun 6, 2014
I'm trying to build an interactive loan calculator for a school project. These are the requirements:
Your program should do the following:
•Display a Welcome title for the Loan Calculator
•Prompt the user to enter the price of the car
•Prompt the user to enter the length of the term in months
•Prompt the user to enter the APR in percentage (e.g. 4.79%) - without the percent sign of course
Your program should then report with the monthly payment will be.
Use setw() and setfill() to display the content like a receipt. All the data should be neatly displayed.
Example
For a Friend Loan Calculator
Price of Vehicle: $25,000
Term of Loan (in months): 60
APR in percentage (e.g. 4.79% - without the percent sign): 3.8
--------------------------------------------------------------
Total Monthly Payments: $433.50 //NOT ACCURATE
Display all money totals (output values) to two decimal places. You should output an accurate result as well.
For extra credit you may factor in a state auto sales tax of 6.5% of the purchase price of the vehicle and how much of a down payment the user would like to put down. Of course, if you are factor down payment, you must prompt the user to enter that amount.
I attempted to build one but I'm getting a lot of errors using Microsoft visual studio. Here it is below:
Interactive Loan Calculator
#include <iostream>
#include <cmath>
#include <ctime>
#include <cstdlib>
using namespace std;
int num1,
num2,
response,
[Code] .....
View 3 Replies
View Related
Apr 5, 2013
I need to save excel file data directely into oracle database by using XML string but getting error as
ORA-01704: string literal too long
01704. 00000 - "string literal too long"
*Cause: The string literal is longer than 4000 characters.
*Action: Use a string literal of at most 4000 characters.
Longer values may only be entered using bind variables.
Error at Line: 50 Column: 31
View 9 Replies
View Related
Jan 1, 2014
I have an application in C sharp that searches for a record in a sql database using a datetimepicker,the output is displayed in a datagridview.When I execute it I got a blank datagridview with empty columns.I can not view the content and I don't get any error message.
Here is my code:
DataTable dt=new dataTable();
SqlDataAdapter sda=new sqldataadapter("select * from Delivery where convert
(char(20),Delivery_Date,112)='"+ dateTimePicker1.value.Date,con);
//con is sqlconnection
Sda.Fill(dt);
Datagridview1.DataSource=dt;
View 1 Replies
View Related
Sep 24, 2014
How to validate the data if the data already exist in the table record in c#?
For example I wanted to add the student roll no. if roll no. is 134 and if we are adding rollno. 134 student then we get the warning like roll no. 134 is already exist ....
View 1 Replies
View Related
Apr 17, 2012
I would like to fill a combobox with particular field for example if i have atable with fields such as CustID, CustName, CustAge.
I would like to only fill the combobox with the Name filed such that only the CustNames will be field in the combobox and am able to write an event handler for the selected index.
View 1 Replies
View Related
Aug 18, 2012
I was looking at this code:
private void button1_Click(object sender, EventArgs e)
{
string input = textBox3.Text;
[Code].....
And how to rewrite the code so that it display the MySQL table data for a specific user I already have a string called username and that stores the username entered on the login form. I want the code to use the username string to search for the name and display that users info.
My table contents are: username
First name
Last name
Position
Employee Id
Airline
View 7 Replies
View Related
Sep 11, 2012
I am completely new to SQL server i know a few of the basics. I have a VS2010 asp.net c# application with two dropdown listboxes and a textbox. I need to calculate the numbers e.g 3 + 3 = Medium, using the table below to calculate the answer so i can insert the output value into a textbox.
Table
12345
1ColdColdColdColdHOT
2ColdColdColdMediumHOT
3ColdMediumMediumHOTHOT
4MediumMediumMediumHOTHOT
5MediumMediumMediumHOTHOT
Drop down Listbox3Drop down Listbox3
TextBoxMedium
View 3 Replies
View Related
Nov 29, 2010
I have a tcp client - server implementation running in the same program, on different background worker threads. There will be instances of this program on multiple computers so they can send and receive files between each other. I can send files sequentially between computers using network stream, but how would I send multiple files at the same time from computer A to B.
Sending multiple files over one connection ( socket ) is fine, but having multiple network streams sending data to a client, the client doesn't know which chunk of data is apart of which file ?
View 3 Replies
View Related
Nov 9, 2013
I am checking out this simple piece of code:
private void button1_Click(object sender, EventArgs e) {
Stopwatch sw = Stopwatch.StartNew();
Task Task1 = Task.Factory.StartNew(() => {
Console.WriteLine("Task1 started in : "+ " "+sw.ElapsedMilliseconds);
Thread.Sleep(4000);
Console.WriteLine("Task1 finished in : " + " " + sw.ElapsedMilliseconds);
}
);
}
and the results are :
Task1 started in : 2 in milliseconds
Task1 finished in : 4015 in milliseconds.
The problem is, that if i count the time with an external device, just like the timer of my watch or my cellphone s,the total time is 4,8 or 4,9 seconds, which i wouldn t expect that to happen.
The first thing i ve thought, is that it takes the ThreadPool about 800msec or 1 sec to create the thread so as to execute this task, but even if it is so, shouldn t the stopwatch count the time precisely?So , why is there a deviation between an external timer and the stopwatch ?
View 1 Replies
View Related
Dec 22, 2014
When server send data then client receive that data, in C# windows services where data receive continuously (Using IP Address and port number) . This below code writing in console application . i want implement same logic in windows service side. but i want data receive continuously.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
[Code]....
Above code write in console application, same logic implementing in windows service, but i want data receiving continuously
View 3 Replies
View Related
Aug 6, 2012
In my class I'm trying to display the elapsed time as my label on a windows form. I've been reading up on all the different articles online and have tried these three methods all with the same result:
1. Using the System.Timers class
2. Built in Timer sub-class
3. Defining directly inside of my class the StartTime, etc. variables.
All of these still result in the following error:
Cross-thread operation not valid: Control 'User_Interface' accessed from a thread other than the thread it was created on.
Currently, my windows form is being called by another class, but I'm not sure if this is the cause of the problem.
This is a sample of the code that I'm currently using to show the elapsed time:
private void OnTimedEvent (object source, ElapsedEventArgs c)
{
TimeSpan time;
currentTime = DateTime.Now;
[Code].....
View 5 Replies
View Related
Feb 1, 2013
How to show only current date not time in webforms in visual studio as for date and time code is
Label1.Text = DateTime.Now.ToString();
What for only date not time
View 3 Replies
View Related
Feb 2, 2013
The first time my application opens up, it should get the local date out of the System and store this in a registry key. But the second time it should get the date stored in that registryKey and compare it to the date right now.And there is where I am stuck, I just don't know how to get the date out of that key and compare it to the date right now.
This is my code:
RegistryKey key1;
private void btnTrial_Click(object sender, EventArgs e) {
DateTime current = DateTime.Now;
key1 = Registry.CurrentUser.OpenSubKey("myKey");
if (key1 == null)
[code]....
at the last "if" statement it should compare the date stored in the key with the DateTime.Now.
View 9 Replies
View Related
Nov 20, 2012
i want to create an application which generates popup alerts at the day of event occurs as well as a day before the event will occur in a specific time interval as well.. events are stored in database and they are all date time fields .. so i want to link those fields to create popups ..
View 2 Replies
View Related
Aug 18, 2014
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.IO;
using System.IO.Ports;
[Code] ....
How to pick date / time when serial port starts reading , and also when reading stops ?
View 2 Replies
View Related
Nov 19, 2013
I am having an issue with my sort function. This is one part of the Hash table program. The main issue is that I am trying to sort the pointer table after all of the values have been entered. The ptr_sort function is not a class function and so I am therefore unable to use the class variables psize and pTable. Is there another way I should be trying this? it is a Vector should I use the sort() function from the vector class in STL?
#include "/home/onyuksel/courses/340/progs/13f/p9/util9.h"
#include "/home/onyuksel/courses/340/progs/13f/p9/hTable.h"
#ifndef H_TABLE1
#define H_TABLE1
void ptr_sort ( );
[Code] ....
View 1 Replies
View Related
Jan 25, 2013
If a user enters a string of boolean algebra it will ouput the table.
I have input parsing, cycling through the combinations, and outputing working. However once i parse the input I am not sure what to do with it. I have thought of having it write the parsed input to a new file as a function and then use that function, but that seems bad.
How to dynamically create the function, how to implement it.
BTW This is a console function, if that changes anything.
View 2 Replies
View Related
Dec 15, 2014
I have written an SQL statement that would:
1) Count the number of rows in the table booking that are open and where the booking.postcode is "MK",
2) Take a note of the plot (in booking.plot_id), and then update the table plot.jobs with the value count.
For example running the SQL query when booking table has the following rows:
Would see the following highlighted values in plot.jobs being updated to 1:
I managed to resolve it with this code so far (note I am using Connector/Net):
public void RefreshPlot(){
string query =
"SELECT Count(*) AS count, plot_id FROM booking WHERE postcode='MK' AND status='open' GROUP BY plot_id";
var cmd = new MySqlCommand(query, _connection);
var da = new MySqlDataAdapter(cmd);
var dtCounts = new DataTable();
da.Fill(dtCounts);
[code]....
Currently, my code only checks for existing rows in the booking table and updates the plot table. However if the row gets deleted in the booking, then the changes are not reflected in the plot table.
Example: If we delete the row with plot.id=1 and plot.plot_id=4, then booking.plot_id should go back to being 0, if it was initially 1. At the moment, it doesn't. How would I update my SQL statement to better reflect this? In a sense, it should check for "non-existent" rows, i.e. the impact that the row plot.plot_id=4 & plot.id=1 has on booking.plot_id when deleted?
View 6 Replies
View Related
