Nested Select queries i main select query LINQ - C# Discussion Boards

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.

Mobile Apps - Sound Meter | Color Analyzer | SMBC | Football Doodles

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

See here: Auto Saving DataGridView Rows to a SQL Server Database[^]

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

How To Get The Values Which is In Grid View To Another Form??????

Depends on how the forms are "organised". If the form that holds the GridView opens the second, then it's one way. If the GridView is on the form that is opened, it's another.
See these:
Transferring information between two forms, Part 1: Parent to Child[^]
Transferring information between two forms, Part 2: Child to Parent[^]
Transferring information between two forms, Part 3: Child to Child[^]
One of them will fit your scenario.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

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

Hi,

Here is the link which shows how to get count from LINQ query.

http://stackoverflow.com/questions/3853010/get-item-count-of-a-list-using-linq[^]
Here is link that shows how to query Datatable using LINQ:

Working with LINQ to Entities & LINQ to DataTable[^]

basically i would have a main select and there will be some nested select like below

SQL

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[^]

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Dave Kreskowiak wrote:
Access doesn't support stored procedures.

Err....what is the following then?

https://msdn.microsoft.com/en-us/library/office/ff845861.aspx[^]

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.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

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?

Google? At least for me one of the results that was returned seemed useful.

http://stackoverflow.com/questions/22706601/how-to-create-stored-queries-in-ms-access-at-runtime-using-c-sharp[^]

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?

What does this have to do with C#?

Try the dedicated forum: http://www.codeproject.com/Forums/3831/Visual-Studio.aspx[^]

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

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 Suspicious | :suss:

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

First column isn't a serial-number, it is an identity-field; one that will act as a primary key probably. The field that is actually used to uniquely identify a record - that is what should have been the primary key.

I'd recommend learning to normalize a structure before creating a schema.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]