将数据从SQL数据库添加到Datatable Using Querry [英] Add data from SQL database to Datatable Using Querry

问题描述

您好，

我正在尝试使用我的数据库记录来填充我的数据表

 strQuery =SELECT Enquiry_Header.UserId，Product_master.ProductShortName_EN，Enquiry_Details.Price，Enquiry_Details.Quantity， + 
Enquiry_Header.EnquiryTotalAmount，Enquiry_Header.USD_Price+ 
FROM Enquiry_Details+ 
INNER JOIN Enquiry_Header ON Enquiry_Details.EnquiryID = Enquiry_Header.EnquiryID+ 
INNER JOIN Product_master ON Enquiry_Details.ProductID = Product_master.ProductId+ 
WHERE（Enquiry_Header.UserId ='U001 +'）; 
 reader.Close（）; 
 OleDbCommand cmd1 = new OleDbCommand（strQuery，con）; 
 DataTable t1 = new DataTable（）; 
使用（OleDbDataAdapter a = new OleDbDataAdapter（cmd1））
 {
 a.Fill（t1）; 
} 
 

但是我的数据表空白了。我不知道知道为什么。请帮助

解决方案

请尝试这个并检查数据库表中的数据。



< pre lang =c＃> strQuery = SELECT Enquiry_Header.UserId，Product_master.ProductShortName_EN，Enquiry_Details.Price，Enquiry_Details.Quantity ， +
Enquiry_Header.EnquiryTotalAmount，Enquiry_Header.USD_Price +
FROM Enquiry_Details +
INNER JOIN Enquiry_Header ON Enquiry_Details.EnquiryID = Enquiry_Header.EnquiryID +
INNER JOIN Product_master ON Enquiry_Details.ProductID = Product_master.ProductId +
WHERE（Enquiry_Header.UserId =' U001 + '）;

// reader.Close（）;
OleDbCommand cmd1 = new OleDbCommand（strQuery，con）;
con.Open（）;
DataTable t1 = new DataTable（）;
使用（IDataReader dr = cmd1.ExecuteReader（））
{
t1.Load（dr）;
}

我不知道如何，但这个解决方案对我有用!!!!! :) :)

 strQuery =SELECT Enquiry_Details.ProductId，Product_master.ProductCode，Enquiry_Header.UserId，Product_master.ProductShortName_EN，Enquiry_Details.Price， Enquiry_Details.Quantity，+ 
Enquiry_Header.EnquiryTotalAmount as [Total]，Enquiry_Header.USD_Price+ 
FROM Enquiry_Details+ 
INNER JOIN Enquiry_Header ON Enquiry_Details.EnquiryID = Enquiry_Header.EnquiryID + 
INNER JOIN Product_master ON Enquiry_Details.ProductID = Product_master.ProductId+ 
WHERE（Enquiry_Header.UserId ='+ fuid +'）; 
 
 OleDbDataAdapter adp = new OleDbDataAdapter（strQuery，con）; 
 DataTable dt = new DataTable（）; 
 adp.Fill（dt）; 

Hello,
I am trying to fill my Datatable using my database records

strQuery = "SELECT  Enquiry_Header.UserId, Product_master.ProductShortName_EN, Enquiry_Details.Price, Enquiry_Details.Quantity, " +
           " Enquiry_Header.EnquiryTotalAmount, Enquiry_Header.USD_Price" +
           " FROM  Enquiry_Details" +
           " INNER JOIN Enquiry_Header ON Enquiry_Details.EnquiryID = Enquiry_Header.EnquiryID" +
           " INNER JOIN Product_master ON Enquiry_Details.ProductID = Product_master.ProductId" +
           " WHERE (Enquiry_Header.UserId = '" U001+ "')";
           reader.Close();
           OleDbCommand cmd1 = new OleDbCommand(strQuery, con);
           DataTable t1 = new DataTable();
           using (OleDbDataAdapter a = new OleDbDataAdapter(cmd1))
           {
               a.Fill(t1);
           }

But i get my datatable blank.i don't know why.please help

解决方案

Please try this and check data in database table.

strQuery = "SELECT  Enquiry_Header.UserId, Product_master.ProductShortName_EN,   Enquiry_Details.Price, Enquiry_Details.Quantity, " +
            " Enquiry_Header.EnquiryTotalAmount, Enquiry_Header.USD_Price" +
            " FROM  Enquiry_Details" +
            " INNER JOIN Enquiry_Header ON Enquiry_Details.EnquiryID = Enquiry_Header.EnquiryID" +
            " INNER JOIN Product_master ON Enquiry_Details.ProductID = Product_master.ProductId" +
            " WHERE (Enquiry_Header.UserId = '" U001+ "')";     
           
            //reader.Close();
            OleDbCommand cmd1 = new OleDbCommand(strQuery, con);
            con.Open();
            DataTable t1 = new DataTable();
            using(IDataReader dr = cmd1.ExecuteReader())
            {           
                t1.Load(dr);
            }

I don't knw how but this solution worked for me!!!!! :) :)

strQuery = "SELECT  Enquiry_Details.ProductId, Product_master.ProductCode, Enquiry_Header.UserId, Product_master.ProductShortName_EN, Enquiry_Details.Price, Enquiry_Details.Quantity, " +
            " Enquiry_Header.EnquiryTotalAmount as [Total], Enquiry_Header.USD_Price" +
            " FROM  Enquiry_Details" +
           " INNER JOIN Enquiry_Header ON Enquiry_Details.EnquiryID = Enquiry_Header.EnquiryID" +
            " INNER JOIN Product_master ON Enquiry_Details.ProductID = Product_master.ProductId" +
           " WHERE (Enquiry_Header.UserId = '"+ fuid+ "')";           
          
           OleDbDataAdapter adp = new OleDbDataAdapter(strQuery, con);
           DataTable dt = new DataTable();
           adp.Fill(dt);

这篇关于将数据从SQL数据库添加到Datatable Using Querry的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！