Click here to Skip to main content
15,884,836 members
Home / Discussions / C#
   

C#

 
GeneralRe: Pop up error message when I call AS400 Stored Procedures via c# application Pin
Pete O'Hanlon7-Jul-14 2:17
mvePete O'Hanlon7-Jul-14 2:17 
GeneralRe: Pop up error message when I call AS400 Stored Procedures via c# application Pin
Bernhard Hiller7-Jul-14 2:52
Bernhard Hiller7-Jul-14 2:52 
GeneralRe: Pop up error message when I call AS400 Stored Procedures via c# application Pin
JanakaND7-Jul-14 16:59
JanakaND7-Jul-14 16:59 
QuestionJoin Table with Data table Pin
Mohammad Soleimani6-Jul-14 23:10
Mohammad Soleimani6-Jul-14 23:10 
AnswerRe: Join Table with Data table Pin
Eddy Vluggen7-Jul-14 0:19
professionalEddy Vluggen7-Jul-14 0:19 
GeneralRe: Join Table with Data table Pin
Mohammad Soleimani7-Jul-14 1:27
Mohammad Soleimani7-Jul-14 1:27 
QuestionRe: Join Table with Data table Pin
Eddy Vluggen7-Jul-14 7:13
professionalEddy Vluggen7-Jul-14 7:13 
AnswerRe: Join Table with Data table Pin
Mohammad Soleimani7-Jul-14 7:59
Mohammad Soleimani7-Jul-14 7:59 
hi,when i add datatable on Query Error show "invalid Object name 'dtProduct'.
i execute my Query on Sql Management studio its run perfect without datatable,

this is All Code

<pre lang="c#">
public DataTable Report_WarehouseStore()
{
DataTable dtProduct = new DataTable("dtProduct");
DataTable dtWarehouse = new DataTable("dtWarehouse");
DataTable dtResult = new DataTable("dtResult");
DataSet ds = new DataSet("Report");

DataColumn[] columns_p = new DataColumn[0];
dtProduct.Columns.Add("identity", typeof(int));
dtProduct.Columns.Add("iD", typeof(int));
dtProduct.Columns.Add("Title", typeof(string));
dtProduct.PrimaryKey = columns_p;
ds.Tables.Add(dtProduct);
dtProduct.Rows.Add(new object[] {1,1,"Iphone 6"});

DataColumn[] columns_w = new DataColumn[0];
dtWarehouse.Columns.Add("identity", typeof(int));
dtWarehouse.Columns.Add("iD", typeof(int));
dtWarehouse.Columns.Add("Title", typeof(string));
dtWarehouse.PrimaryKey = columns_w;
ds.Tables.Add(dtWarehouse);
dtWarehouse.Rows.Add(new object[] {1,1,"Central Warehouse"});

ds = ExecuteDataset(System.Data.CommandType.Text,@"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 dtProduct ON dtProduct.iD = WarehouseStore.ProductCode INNER JOIN dtWarehouse
ON dtWarehouse.iD = WarehouseStore.WarehouseiD", null);
return ds.Tables[0];
}
</pre>
GeneralRe: Join Table with Data table Pin
Eddy Vluggen7-Jul-14 8:49
professionalEddy Vluggen7-Jul-14 8:49 
GeneralRe: Join Table with Data table Pin
Mohammad Soleimani7-Jul-14 16:46
Mohammad Soleimani7-Jul-14 16:46 
QuestionChainedFilter.cs is not available in Lucene.Net 3.0.3? Pin
Shubhanshu Pathak6-Jul-14 18:16
Shubhanshu Pathak6-Jul-14 18:16 
AnswerRe: ChainedFilter.cs is not available in Lucene.Net 3.0.3? Pin
Dave Kreskowiak6-Jul-14 18:21
mveDave Kreskowiak6-Jul-14 18:21 
GeneralRe: ChainedFilter.cs is not available in Lucene.Net 3.0.3? Pin
Shubhanshu Pathak6-Jul-14 19:17
Shubhanshu Pathak6-Jul-14 19:17 
QuestionOpening Sub menu and minimaize main form Pin
KaKoten6-Jul-14 2:43
KaKoten6-Jul-14 2:43 
AnswerRe: Opening Sub menu and minimaize main form Pin
OriginalGriff6-Jul-14 4:04
mveOriginalGriff6-Jul-14 4:04 
GeneralRe: Opening Sub menu and minimaize main form Pin
KaKoten6-Jul-14 12:08
KaKoten6-Jul-14 12:08 
AnswerRe: Opening Sub menu and minimaize main form Pin
Eddy Vluggen6-Jul-14 8:16
professionalEddy Vluggen6-Jul-14 8:16 
GeneralRe: Opening Sub menu and minimaize main form Pin
KaKoten6-Jul-14 12:09
KaKoten6-Jul-14 12:09 
QuestionCS0246: The type or namespace name 'UserInfoaa' could not be found (are you missing a using directive or an assembly reference?) Pin
Member 109016446-Jul-14 0:18
Member 109016446-Jul-14 0:18 
AnswerRe: CS0246: The type or namespace name 'UserInfoaa' could not be found (are you missing a using directive or an assembly reference?) Pin
Bernhard Hiller6-Jul-14 20:42
Bernhard Hiller6-Jul-14 20:42 
QuestionAdd coding to showing message box successful message sent in gmail smtp in c# 2008 Pin
KaKoten5-Jul-14 23:43
KaKoten5-Jul-14 23:43 
AnswerRe: Add coding to showing message box successful message sent in gmail smtp in c# 2008 Pin
OriginalGriff6-Jul-14 0:18
mveOriginalGriff6-Jul-14 0:18 
GeneralRe: Add coding to showing message box successful message sent in gmail smtp in c# 2008 Pin
KaKoten6-Jul-14 0:53
KaKoten6-Jul-14 0:53 
GeneralRe: Add coding to showing message box successful message sent in gmail smtp in c# 2008 Pin
OriginalGriff6-Jul-14 0:54
mveOriginalGriff6-Jul-14 0:54 
GeneralRe: Add coding to showing message box successful message sent in gmail smtp in c# 2008 Pin
KaKoten6-Jul-14 1:01
KaKoten6-Jul-14 1:01 

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.