Solved

SQLDataAdapter fill DataSet; include columns with null values

Posted on 2004-09-22
7
2,340 Views
Last Modified: 2008-02-20
I'm using SQLDataAdapter to fill a DataSet. The problem that I have is when I fill the DataSet from the SQLDataAdapter. The DataSet doesn't include the columns with null values. Is there any property of SQLDataAdapter that can solve the problem?

Thanks,
Vangelis
Cosine Consultants Ltd.
0
Comment
Question by:Cosine_Consultants
  • 3
  • 3
7 Comments
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 12120920
Never heard that one before, Do you by any change use a typed dataset
0
 
LVL 2

Expert Comment

by:ahmadfuwad
ID: 12121057
'fill your datagrid by using following code i will solve your problem
   
 Public cn As New SqlConnection
    Public cmd1 As New SqlCommand
    Public oda1 As New SqlDataAdapter
    Public ods As New DataSet

 cn.ConnectionString = "Server=eteam04;Database=Test;user id=sa;password=password"
        cn.Open()

        ods.Clear()
        cmd1.Connection = cn
        cmd1.CommandType = CommandType.Text
        cmd1.CommandText = "select * from Customer"
        oda1.SelectCommand = cmd1
        oda1.Fill(ods, "Customer")
        Me.DataGrid1.DataSource = ods.Tables("Customer")
0
 

Author Comment

by:Cosine_Consultants
ID: 12121087
I don't want to use a typed dataset since I have a lot of columns to add (app. 40) manually. My application has many tables with lots of columns, therefore I will definitely use the SQLDataAdapter which fills automatically the dataset. I'm looking for a property or something else that will allow the dataset to have columns with null values.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 12121266
Hi Cosine_Consultants,

I didn't imply that you should use a typed dataset, I just asked if you used one , because a typed dataset sometimes has problems with columns containing Nulls.

As far as properties to set to allow columns that contain nulls there is no such property, the dataadapter doesn't care if they contain nulls it should load them just as any other, If it doesn't then there is something else wrong.
I've just tested it with a table that contained  10 empty columns and it loads them just fine.

could you post some code so we might see what's wrong
0
 

Author Comment

by:Cosine_Consultants
ID: 12121641
Here is my code. The SqlDataAdapterCompanyDetails is an object that created using the sqldataadapter wizard. The SqlDataAdapterCompanyDetails use SQL Server stored procedures for SELECT,INSERT,UPDATE functionality. The createCommand is a custom function that returns SqlCommand. If you need any other info please let me know. Thanks.


<WebMethod()> Public Function GetCompanyDetails(ByVal intCompanyId As Integer) As String

        ' Build the parameter to send to the createCommand function
        Dim pars As New ArrayList
        pars.Add(createParameter("@CompanyId", SqlDbType.Int, intCompanyId))

        ' Assign the SQL command to the data adapter
        SqlDataAdapterCompanyDetails.SelectCommand = createCommand("CompanySelect", pars)

        ' Create a new dataset
        Dim ds As DataSet
        ds = New DataSet

        SqlDataAdapterCompanyDetails.Fill(ds)
       
      ' Create a string writer to write the dataset into in XML format
        Dim sw As System.IO.StringWriter = New System.IO.StringWriter
        ' Write the dataset into the string writer as XML
        ds.WriteXml(sw)

        ' Return the XML string
        Return sw.ToString()

    End Function
0
 
LVL 25

Accepted Solution

by:
RonaldBiemans earned 500 total points
ID: 12121701
so after this

SqlDataAdapterCompanyDetails.Fill(ds)

when you do

msgbox (ds.tables(0).columns.count)

you don't get the amount of columns you expect ?

0
 

Author Comment

by:Cosine_Consultants
ID: 12130617
I have solved the problem, thanks for the help. I was passing the xml format of the Dataset instead of the Dataset object itself. Now I can see the xml schema info of the table so I have everything I need.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now