Click here to Skip to main content
15,913,939 members
Home / Discussions / C#
   

C#

 
GeneralRe: trying to search a text file for a certain string and display it in a richTextBox Pin
OriginalGriff1-Apr-15 6:59
mveOriginalGriff1-Apr-15 6:59 
GeneralRe: trying to search a text file for a certain string and display it in a richTextBox Pin
Member 115700981-Apr-15 9:24
Member 115700981-Apr-15 9:24 
GeneralRe: trying to search a text file for a certain string and display it in a richTextBox Pin
Member 115700981-Apr-15 11:54
Member 115700981-Apr-15 11:54 
GeneralRe: trying to search a text file for a certain string and display it in a richTextBox Pin
Member 1157009831-Mar-15 6:26
Member 1157009831-Mar-15 6:26 
GeneralRe: trying to search a text file for a certain string and display it in a richTextBox Pin
Member 1157009831-Mar-15 5:01
Member 1157009831-Mar-15 5:01 
QuestionSplit list to two gridview columns in C# winforms Pin
arsale31-Mar-15 3:27
arsale31-Mar-15 3:27 
AnswerRe: Split list to two gridview columns Pin
Eddy Vluggen31-Mar-15 7:31
professionalEddy Vluggen31-Mar-15 7:31 
GeneralRe: Split list to two gridview columns Pin
arsale31-Mar-15 10:46
arsale31-Mar-15 10:46 
GeneralRe: Split list to two gridview columns Pin
Eddy Vluggen31-Mar-15 13:03
professionalEddy Vluggen31-Mar-15 13:03 
GeneralRe: Split list to two gridview columns Pin
arsale31-Mar-15 23:20
arsale31-Mar-15 23:20 
GeneralRe: Split list to two gridview columns Pin
Eddy Vluggen31-Mar-15 23:41
professionalEddy Vluggen31-Mar-15 23:41 
GeneralRe: Split list to two gridview columns Pin
arsale31-Mar-15 23:58
arsale31-Mar-15 23:58 
GeneralRe: Split list to two gridview columns Pin
arsale1-Apr-15 0:09
arsale1-Apr-15 0:09 
GeneralRe: Split list to two gridview columns Pin
Eddy Vluggen1-Apr-15 0:24
professionalEddy Vluggen1-Apr-15 0:24 
GeneralRe: Split list to two gridview columns Pin
arsale1-Apr-15 0:28
arsale1-Apr-15 0:28 
QuestionCould not cal the repaint usercontrol?? Pin
Sarita S31-Mar-15 0:05
Sarita S31-Mar-15 0:05 
AnswerRe: Could not cal the repaint usercontrol?? Pin
OriginalGriff31-Mar-15 0:16
mveOriginalGriff31-Mar-15 0:16 
GeneralRe: Could not cal the repaint usercontrol?? Pin
Sarita S31-Mar-15 0:21
Sarita S31-Mar-15 0:21 
GeneralRe: Could not cal the repaint usercontrol?? Pin
OriginalGriff31-Mar-15 0:22
mveOriginalGriff31-Mar-15 0:22 
GeneralRe: Could not cal the repaint usercontrol?? Pin
Sarita S31-Mar-15 0:49
Sarita S31-Mar-15 0:49 
GeneralRe: Could not cal the repaint usercontrol?? Pin
OriginalGriff31-Mar-15 0:55
mveOriginalGriff31-Mar-15 0:55 
QuestionHow to have a Select Query like Sql Server Cross Apply query in MS-Access? Pin
Paramu197330-Mar-15 16:05
Paramu197330-Mar-15 16:05 
HI,
I have 3 tables. I wish to select the latest Unit Rate from those tables....like SQL Cross Apply.Is it possible from Ms-Access?

The below SQL-Query Select the latest unit_price, price_date from three tables..... Itemmst, Pomst, Grinmst

Actually the query checks those three tables and will select the greatest Price_date and Unit_Rate
C#
Select i.itm_code,i.itm_description,i.unit_measure,t.unit_rate,t.price_date from itemmst i cross apply ( select top 1 unit_rate,price_date from( select im.unit_rate,''as price_date,0 as ord from itemmst im where im.itm_code=i.itm_code and im.unit_rate is not null union all select unit_price as unit_rate,po_date as price_date,1 as ord from pomst where pomst.itm_code =i.itm_code and pomst.unit_price is not null union all select grinmst.unit_rate,grinmst.grn_date,1 from grinmst where grinmst.itm_code =i.itm_code and grinmst.unit_rate is not null )r order by price_date desc,ord desc )t
Output :-
  1. Item1, Pencil, Nos, 25.00, 26/03/2015 => from Grimst
  2. Item2, Pen, Nos, 22.00, 21/03/2015 => from Pomst
  3. Item3, Paper, Nos, 65.00, 01/04/2014 => from Itemst
ThanksThumbs Up | :thumbsup:
AnswerRe: How to have a Select Query like Sql Server Cross Apply query in MS-Access? Pin
Afzaal Ahmad Zeeshan30-Mar-15 16:20
professionalAfzaal Ahmad Zeeshan30-Mar-15 16:20 
Questionhow get array of drawing in inkcanvas in wpf Pin
Member 1111269830-Mar-15 9:24
Member 1111269830-Mar-15 9:24 
QuestionHow to handle SQL Dependency error properly Pin
Tridip Bhattacharjee30-Mar-15 2:35
professionalTridip Bhattacharjee30-Mar-15 2:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.