removing null valued columns from dataset in asp .net

Posted by N.Sai Harish on Stack Overflow See other posts from Stack Overflow or by N.Sai Harish
Published on 2010-01-19T05:19:39Z Indexed on 2010/04/03 8:03 UTC
Read the original article Hit count: 270

Filed under:

dataset

I have a table which stores data with null valued columns for some entries .I want to retrieve only Not null data to the detail view. I tried the following

foreach(string strTableField in (objDataSet.Tables[0].Columns[i])) 
{
    if(objDataSet.Tables[0].Columns[i].Equals(null))
    {
        objDataSet.Tables[0].Columns.Remove(strTableField);
       objDataSet.Tables[0].AcceptChanges();
    }

    i++;
}

but it is giving error .. Pls help me reg this ...

Related posts about dataset

Dataset -> XML Document - Load DataSet into an XML Document - C#.Net

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I'm trying to read a dataset as xml and load it into an XML Document. XmlDocument contractHistoryXMLSchemaDoc = new XmlDocument(); using (MemoryStream ms = new MemoryStream()) { //XmlWriterSettings xmlWSettings = new XmlWriterSettings(); //xmlWSettings.ConformanceLevel = ConformanceLevel… >>> More
Combine multiple dataset columns to one dataset

as seen on Stack Overflow - Search for 'Stack Overflow'
I have multiple datasets that I would like to combine into one. There is a common ID field that can be associated to each row. Calling Merge on the dataset will add additional rows to the dataset, but I would like to combine the additional columns. There are too many fields to do this in one query… >>> More
Making a DataSet from another DataSet

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi folks I have a client-server project (small project for companies in C#) and the server has a DataSet with some tables (there is no Database for some reasons so we save the DataSet as an XML file). when the clients connect to the server, the server should send some informations to the client depends… >>> More
Declaring variables with New DataSet vs DataSet

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the impact of creating variables using: Dim ds as New DataSet ds = GetActualData() where GetActualData() also creates a New DataSet and returns it? Does the original empty DataSet that was 'New'ed just get left in the Heap? What if this kind of code was in many places? Would… >>> More
DataSet.Copy vs Dataset.Clone

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone explain me DataSet.Copy vs Dataset.Clone Also let me know some scenario's where we can use these >>> More

Developer IT

removing null valued columns from dataset in asp .net - Developer IT

removing null valued columns from dataset in asp .net

dataset

Related posts about dataset

Dataset -> XML Document - Load DataSet into an XML Document - C#.Net

Combine multiple dataset columns to one dataset

Making a DataSet from another DataSet

Declaring variables with New DataSet vs DataSet

DataSet.Copy vs Dataset.Clone

Categories cloud