Click here to Skip to main content
15,901,122 members
Home / Discussions / C#
   

C#

 
Questionself destructible message Pin
abhisince941-Jul-14 3:32
abhisince941-Jul-14 3:32 
AnswerRe: self destructible message Pin
joost.versteegen1-Jul-14 3:41
joost.versteegen1-Jul-14 3:41 
GeneralRe: self destructible message Pin
Rob Philpott1-Jul-14 4:31
Rob Philpott1-Jul-14 4:31 
AnswerRe: self destructible message Pin
ZurdoDev1-Jul-14 3:58
professionalZurdoDev1-Jul-14 3:58 
AnswerRe: self destructible message Pin
Dan Neely3-Jul-14 9:18
Dan Neely3-Jul-14 9:18 
QuestionJoin data table with sql table Pin
Mohammad Soleimani1-Jul-14 1:40
Mohammad Soleimani1-Jul-14 1:40 
AnswerRe: Join data table with sql table Pin
Eddy Vluggen1-Jul-14 7:25
professionalEddy Vluggen1-Jul-14 7:25 
GeneralRe: Join data table with sql table Pin
Mohammad Soleimani2-Jul-14 1:31
Mohammad Soleimani2-Jul-14 1:31 
Yes you right , how can join Data Table [Memory Table] with Sql Table on C#. Return Datatable.

see this cod

<pre lang="c#">
public DataTable Report_WarehouseStore()
{

dtWarehouse.iD = WarehouseStore.WarehouseiD
SqlDataAdapter da=new SqlDataAdapter(@"SELECT WarehouseStore.ProductID, WarehouseStore.ProductCode, WarehouseStore.ProductName, UnitPart.UnitPart, Warehouse.WarehouseName,WarehouseStore.ProductValue FROM WarehouseStore INNER JOIN UnitPart ON WarehouseStore.UnitPartID = UnitPart.UnitPartid INNER JOIN Warehouse ON Warehouse.WarehouseiD = WarehouseStore.WarehouseiD", new _Connections().Cnn);
DataTable dt = new DataTable();
da.TableMappings.Add("dtObject","dtObject");
da.TableMappings.Add("dtWarehouse","dtWarehouse");

da.Fill(dt);
return dt;

}
</pre>

Wants Run this Code
<pre lang="SQL">
SELECT WarehouseStore.ProductID, WarehouseStore.ProductCode, WarehouseStore.ProductName, UnitPart.UnitPart, Warehouse.WarehouseName,WarehouseStore.ProductValue FROM WarehouseStore INNER JOIN UnitPart ON WarehouseStore.UnitPartID = UnitPart.UnitPartid INNER JOIN Warehouse ON Warehouse.WarehouseiD = WarehouseStore.WarehouseiD INNER JOIN dtObject ON dtObject.iD = WarehouseStore.ProductCode INNER JOIN dtWarehouse ON dtWarehouse.iD = WarehouseStore.WarehouseiD
</pre>

-- modified 2-Jul-14 7:47am.
GeneralRe: Join data table with sql table Pin
Eddy Vluggen2-Jul-14 3:06
professionalEddy Vluggen2-Jul-14 3:06 
GeneralRe: Join data table with sql table Pin
Mohammad Soleimani2-Jul-14 6:22
Mohammad Soleimani2-Jul-14 6:22 
QuestionSystem.AccessViolationException When Using Win32 DLL Pin
Django_Untaken1-Jul-14 0:36
Django_Untaken1-Jul-14 0:36 
AnswerRe: System.AccessViolationException When Using Win32 DLL Pin
OriginalGriff1-Jul-14 2:40
mveOriginalGriff1-Jul-14 2:40 
GeneralRe: System.AccessViolationException When Using Win32 DLL Pin
Django_Untaken1-Jul-14 8:49
Django_Untaken1-Jul-14 8:49 
AnswerRe: System.AccessViolationException When Using Win32 DLL Pin
Bernhard Hiller1-Jul-14 20:38
Bernhard Hiller1-Jul-14 20:38 
GeneralRe: System.AccessViolationException When Using Win32 DLL Pin
Django_Untaken1-Jul-14 21:36
Django_Untaken1-Jul-14 21:36 
Questionhow to solve this Error...in insert query Pin
Nishant.Chauhan8030-Jun-14 21:50
Nishant.Chauhan8030-Jun-14 21:50 
AnswerRe: how to solve this Error...in insert query Pin
Rob Philpott30-Jun-14 22:40
Rob Philpott30-Jun-14 22:40 
AnswerRe: how to solve this Error...in insert query Pin
AjayJamwal2-Jul-14 3:20
professionalAjayJamwal2-Jul-14 3:20 
QuestionExecuting few lines of code on Windows Store app installation Pin
Sharath C V30-Jun-14 21:14
professionalSharath C V30-Jun-14 21:14 
AnswerRe: Executing few lines of code on Windows Store app installation Pin
Pete O'Hanlon30-Jun-14 23:19
mvePete O'Hanlon30-Jun-14 23:19 
GeneralRe: Executing few lines of code on Windows Store app installation Pin
Sharath C V1-Jul-14 0:34
professionalSharath C V1-Jul-14 0:34 
GeneralRe: Executing few lines of code on Windows Store app installation Pin
Pete O'Hanlon1-Jul-14 1:31
mvePete O'Hanlon1-Jul-14 1:31 
QuestionMSI installer, deployment Pin
ankum1630-Jun-14 18:17
ankum1630-Jun-14 18:17 
AnswerRe: MSI installer, deployment Pin
Bernhard Hiller30-Jun-14 20:24
Bernhard Hiller30-Jun-14 20:24 
QuestionHow to add ScrollViewer to usercontrol in MVVM by josh smith. Pin
vijendra malik30-Jun-14 16:45
vijendra malik30-Jun-14 16:45 

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.