|
Depends how many you want, and what you want to record and show in your system.
|
|
|
|
|
This will depend on the number of features you want to provide in your attendance system.
It will also depend on your UI design - you could show everything in one form or have different forms for each piece of functionality.
|
|
|
|
|
hi
How to print a page of stickers in C# WinForm
i try with crystal-report without success.
thanks
|
|
|
|
|
The simplest way is to use a PrintDocument[^] - create a method to print a label, and call it repeatedly.
The class gives you complete control over the printing on your page, and exactly where everything goes.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
hi
i have dataGridView that show my table.
how to update dataGridView cell by fill it ?
for example i have table MEN that contain field Age
when i stand on my age cell on dataGridView and change the value - i need that it will
change in the database too.
how to do it ?
work on C# Winform
|
|
|
|
|
|
How To Get The Values Which is In Grid View To Another Form??????
|
|
|
|
|
|
apologized for asking a help for linq query. i hardly use LINQ rather i use MSDAAB as DAL which i use to execute my inline sql query or my db store procedure etc. now i am in situation where i need to use LINQ to extract data from datatable.
here i am attaching one screenshot like how my data look like enter image description here
http://i.stack.imgur.com/NMrvR.png[^]
the is data is coming from sql server and for which i am using the below query for sql server. please see my query first.
select
(select count(*) as incoming from tridip_Interval where direction='I'
and CONVERT(datetime,right([Call Start],8)) >='08:30:00'
and CONVERT(datetime,right([Call Start],8)) <='09:00:00'
and Is_Internal=0 and continuation=0 and
RIGHT(convert(varchar,[call duration]),8)<> '00:00:00'
and party1name='Train5') as incoming,
(select count(*) as OutGoing from tridip_Interval where direction='O'
and CONVERT(datetime,right([Call Start],8)) >='08:30:00'
and CONVERT(datetime,right([Call Start],8)) <='09:00:00'
and Is_Internal=0 and continuation=0
and party1name not in ('Voice Mail')
and party1name='Train5') as OutGoing,
(select count(*) as CallTransfer from tridip_Interval where continuation=1
and CONVERT(datetime,right([Call Start],8)) >='08:30:00'
and CONVERT(datetime,right([Call Start],8)) <='09:00:00'
and RIGHT(convert(varchar,[call duration]),8)<> '00:00:00' and
party1name not in ('Voice Mail')
and party1name='Train5') as CallTransfer,
(SELECT count(*) as UnansweredCalls_DuringBusinessHours
from tridip_Interval where direction='I' and
CONVERT(datetime,right([Call Start],8)) >='08:30:00'
and CONVERT(datetime,right([Call Start],8)) <='09:00:00'
and RIGHT(convert(varchar,[call duration]),8)= '00:00:00'
and [Ring duration]>0 and party1name='Train5') as misscall
now i want to use LINQ to query data table but hence i am not good in linq so not being able to compose the above sql like query with linq. so just wonder if any guy help me to compose the above query with linq.
apologized could not highlight my linq query because very honestly i know linq little and that is the reason things is not coming to my mind how to compose the same above sql query with LINQ. looking for hep and support.
tbhattacharjee
|
|
|
|
|
|
basically i would have a main select and there will be some nested select like below
SELECT EmployeeName,
(Select count(*) from table1 where condition) as data1,
(Select count(*) from table1 where condition) as data2,
(Select count(*) from table1 where condition) as data3
i like to know how to write nested select ?
anyone can construct a sample one for me. thanks
tbhattacharjee
|
|
|
|
|
I know how to create a stored procedure.
In C#, how do you create a stored query so that is is displayed in the table of contents with related tables and queries?
|
|
|
|
|
Member 10953820 wrote: create a stored procedure.
Access doesn't support stored procedures.
Member 10953820 wrote: how do you create a stored query so that is is displayed in the table of contents with related tables and queries?
The closest concept that Access supports that fits your description is a View. Creating a View using SQL in Access is no different than any other database engine. You build a SQL query string and execute it on the database just like any other SELECT query, only the query you're executing is going to start with CREATE VIEW, not SELECT. CREATE VIEW documentation[^]
|
|
|
|
|
|
And the comment there says:
Note
The Microsoft Access database engine does not support the use of CREATE PROCEDURE, or any of the DDL statements, with non-Microsoft Jet database engine databases.
"Fairy tales do not tell children the dragons exist. Children already know that dragons exist. Fairy tales tell children the dragons can be killed."
- G.K. Chesterton
|
|
|
|
|
Matt T Heffron wrote: And the comment there says:
Yep "with non-Microsoft Jet database engine databases."
Why do you think that the MS Access guide to SQL, from where that link originates, documents how to create a stored procedure?
|
|
|
|
|
I can only verify that stored procedures have never been supported by Access up to and including Office 2007. I never use Access for anything so I can't really comment on 2010 and above. Though, I highly doubt Access got real stored procedure support.
|
|
|
|
|
|
When I copy a project to a new folder my bookmarks still point at the old location. HOw can I update the bookmarks to look at the new location?
|
|
|
|
|
|
So, I have something which writes data to a stream (in binary if you must know), and something else that can read this data from a stream and do something with it (display it), all via the gift of BinaryReader/Writer etc. All good.
So, I could get the producer to write everything to a FileStream, or a MemoryStream, and then get the consumer to read from these streams without issue, but what if I want to do both these things concurrently?
I've done this a lot with network streams, where for instance you are returning the data from a big SQL query. At the same time SQL Server is running the query and returning the results, they are being squirted over a NetworkStream and into the client in a beautiful concurrent manner that avoids latency and large memory footprints.
Now, I think I should be able to do this in-proc. But I'd need a stream which was based on a circular buffer and had different read and write cursors, and supports multithreading. This seems pretty standard stuff to me, even the standard I/O streams give you this, but I'm unaware of simple way to do it.
The likely contender MemoryStream has always left me feeling dissatisfied as it appears nothing more than a glorified growable byte array, where repeated reads yield the same data over and over again.
Please share your thoughts, or ideally enlighten me.
Regards,
Rob Philpott.
|
|
|
|
|
That's because there isn't one. With respect to the MemoryStream, I have used them a time or two, and you surmise correctly that they are really just glorified byte arrays. Since your question omits some significant details, my suggestion is mostly an educated guess, which is that you may want to look into something along the lines of a named pipe, where the process that is writing sits at one end of the pipe, and the process that is reading the data sits at the other end.
|
|
|
|
|
Hi,
I am using .net 4.0 and my requirements are,
- Return a file stream from web - api and the deserialize the stream in GetResponse() method in MVC.
- Upload a file from MVC - Here i have FileStream of the file.
I have searched for the above operations to be done in 4.0 framework but i can't get. HttpResponseMessage is the only solution for my requirements which is available only from 4.5 framework. Is there any solution to achieve this in 4.0 framework?
|
|
|
|
|
Member 11387877 wrote: HttpResponseMessage is the only solution for my requirements
GetResponse has multiple ways to access the data. If you know which class you are getting the response from, then you can look on MSDN for alternative ways to retrieve data.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I have datas in words something like this:-
As there is two different Model No. and respective two different Serial No. for a single Machine on Serial No. 6 and 7.
S.
No Machine Id # Machine Name Model no. Serial no. Made in Location
01 AC01 Air Compressor (CECCATO) CSB 25/10 CAI 136509 Italy Old Factory
02 AC02 Air Compressor (CECCATO) CSB 25/10 CAI 136510 Italy Old Factory
03 AC03 Piston Air Compressor 462 TV 02 H1029PKZ Italy Old Factory
04 AC04 Rotary Screw Head Compressor (Ingersoll Rand) SSR-EP 100 CK 8225U08163 Italy New Factory
05 BM05 Multi Boring Machine (SCM) MULTITECH PLUS Not Available Italy New Factory
06 CC01 Chip Collector (FIDA) SILO SCF 165/04 Italy Old Factory
IMPIANTO F 1013/04
07 CC02 Chip Collector(FIDA) TRC 1001 Not Available Italy New Factory
TRC 711 Not Available
08 CM02 Rip Saw (SCM) SI 450 N AB/167284 Italy Old Factory
09 CM04 Automatic Panel Sizing Center (MACMAZZA) TS100 589 Italy Old Factory
10 CM06 Rip Saw (SAC) CS 4 Not Available Italy Old Factory
11 CM07 Rip Saw (SCM) SI-350 N AB/153028 Italy Old Factory
12 CM08 Band Saw (CENTAURO) R-800 6080 Italy Old Factory
13 CM09 Band Saw (CENTAURO) CENTAURO-C Not Available Italy Old Factory
14 CM10 Multi Rip Saw (SCM) M-3 AB/167282 Italy Old Factory
15 CM11 Multi Rip Saw (SCM) M-2 AB.42150 Italy Old Factory
16 CM12 Chain Cutter (MASTERWOOD) OMR 350 35109102 Italy Old Factory
17 CM13 Under Side Cross Cut Saw (STROMAB) RS-110 91002 Italy Outside
18 CM14 Double side Cutter (GABBIANI) Not Available Not Available Italy Old Factory
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
