|
If you're using Windows Forms, you don't need this structure, or the P/Invoke method; the SystemInformation.PowerStatus property[^] will give you the same information.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hello,
it was an sample.
Thanks.
|
|
|
|
|
How many forms include in Emplyee's attendace system?
|
|
|
|
|
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.
|
|
|
|