Add data from SQL database to Datatable Using Querry

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

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

Posted 22-Aug-13 18:56pm

Priyanka Bhagwat

Add a Solution

Comments

Om Prakash Pant 23-Aug-13 1:11am

Try running the query and see if you are getting records.

kishore sharma 23-Aug-13 1:15am

Did you executed this query directly in database?

Priyanka Bhagwat 23-Aug-13 2:31am

yes when i execute Query in data base it does show me records

2 solutions

Solution 1

Please try this and check data in database table.

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();
            using(IDataReader dr = cmd1.ExecuteReader())
            {           
                t1.Load(dr);
            }

Posted 22-Aug-13 19:37pm

Sandeep Singh Shekhawat

Comments

Priyanka Bhagwat 23-Aug-13 4:45am

hello Sandeep,
i tried this code bit still its giving me NULL datatable

Sandeep Singh Shekhawat 23-Aug-13 5:01am

Have you run this query in Sql Query Editor in SSMS and it is returning data from database table? If it does not return any result set then we get empty table.

Priyanka Bhagwat 23-Aug-13 5:20am

yes,i get answer for my query,i am also confused for the same reason if the Query is working f9 why is not able to add to the datatable

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Priyanka Bhagwat · Accepted Answer · 2013-08-23T00:54:00

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);