Databases :: Play Around With Column's Names Filled By OleDbDataAdapter?

May 3, 2010

I tried to query an excel file which contains a lot of customers' information but my problem is most of those don't have a specific column names. E.g. it's in the following format. (Excel File)

Info1 blur blur
Info2 blur blur
Info3 blur blur

So, when I query using SqlDbDataAdapter, in my DataTable, info1 blur blur becomes column header. e.g. it's in the following format. (DataTable)

Info1 blur blur
Info2 blur blur
Info3 blur blur

I been working on it so that it actually goes down one row and Change the column name in the DataTable into some appropiate name. Something like the following format.

Name1 Name2 Name 3
Info1 blur blur
Info2 blur blur
Info3 blur blur

Is there any way that I could work around it rather than actually going back to change the excel files ? Because I have like 1,000 excel files in that kinda format and seriously giving me headache now.

View 5 Replies

Similar Messages:

ADO.NET :: Can Add New Column In Already Filled DataTable In Vb.NET

Mar 3, 2011

I have a dataTable filled with data.

And I want to insert new column into same datatable without affecting original data.

View 1 Replies

SQL Server :: Select Only Filled Column?

Jan 25, 2011

I have a suitation where i want to select only those columns only which contain any data blank, null or "0" values data couldn't retrive from query.

for eg.
SL NO Name Contact Address email remarks
01 Atul 0 Ranchi
02 Atul 34753 fdsgsdfgdfs

what query i write which display only slno, name, address and email automaitcally for slno 1, or slno,name,contact and remarks for slno2.

View 8 Replies

Forms Data Controls :: Create A Column While The Datatable Is Being Filled?

Jun 17, 2010

What I have is a datatable being constructed from Sharepoint API. We dont need to worry about the sharepoint api.The code where it fills the data is as follows

Datatable dt = new datatable();

Write what I want is as the dt is being filled is to create another column called full path which has a formula col1+col2I dont want to do a for next loop after the dt is filled . very slow !

View 1 Replies

Forms Data Controls :: Gridview BoundField Or DataField Has To Be Filled With The Value That Comes From Column1 Or Column?

Feb 4, 2010

I'm using a DataSet to fill my gridview. The dataset contains several columns, like: direction - fromNumber - toNumberThe column direction can contain the values "incoming" or "outgoing". In my gridview, I would like to show only 2 columns, direction and from/to. If direction = "incoming", the values from fromNumber has to be inserted in "from/to". If direction = "outgoing", the values from toNumber has to be inserted in "from/to".I know I can use a TemplateField to show different text values in a column...But I have no idea how to do this when I want to show the values from a column...

<asp:BoundField DataField="direction" HeaderText="direction" HtmlEncode="false" />


View 2 Replies

Databases :: Getting Excel Sheet Names When File Is Uploaded?

Mar 3, 2011

I have the following code i found online and it works fine as long as the sheet names are simple names it seems..

If i have a excel file with a sheet name of (sheet1) the code works.. but if i have a file with a sheet name like (FileName2011_03_03_15_01_43) it fails and causes the rest of my code not work..


View 3 Replies

Getting The Column Names When Using E.oldvalues

May 28, 2010

How do I get the column names when using e.oldvalues?


View 9 Replies

ADO.NET :: How To Get Column Names From Linq Datasource

Jan 14, 2011

how to get column names from linq datasource?


View 7 Replies

SelectCommand Dynamic Column Names?

Feb 8, 2011

I have a database with two columns: Retailers or Traders. A row can have only one of them with values while the other must be 'Null'. Both are nvarchars kinds. What I am trying to do is to show data if a radio button is selected for either Retailer or Trader. So I constructed a SelectCommand statement which is getting column names of either 'Retailers' or 'Traders' as a parameter but the SelectCommand statement still returns all records. What can I do?

<asp:SqlDataSource ID="dsSearchResults" runat="server" ConnectionString="<%$ ConnectionStrings:AdoFabricsConnection %>"
SelectCommand="SELECT Name,Address1,City,State,Zip, Telephone, Email_Address, TO_THE_Trade, Retailer,


View 1 Replies

ADO.NET :: DataTable Column Names Not Matching Case

Nov 4, 2010

I am getting a datatable from the SQL Server. In SQL Server the column headers are fine (mix of Capital and Small Letters). But when i am getting it in the front end, all the column names are in lower case. How can i get the column names in original Case.

View 3 Replies

C# - How To Change Column Names Randomly In Gridview

Jun 11, 2010

I am struggling to show different views of gridview with database values. Here is my requirement.

Database Table:

I need to show one drop downlist with three values 1,2,3. If user selects 3 i Need to show a grid like below

Age,AnnualSales and Assortment are names which are coming dynamically from database.

High,Medium and Core all are values

Here my question is I need to show same attribute names.

Like If the name changes from "Assortment" to "Location" I need to show it in different page index .

In page index 2 i need to show like below.

View 2 Replies

.net - Add Table Column Names Automatically In An ASP ListView?

Feb 17, 2010

I have an ASP ListView which I am using to display some pivoted information (across years) in a table. Currently I have the ListView templates defined as:

<table id="listViewTable" class="tableData">
<tr class="rowHeader">


View 2 Replies

Read Column Names Of An Excel Sheet?

Apr 26, 2010

im trying to read column names from excel .

View 3 Replies

SQL Server :: Cannot Reference Column Names To Calculate Percentage

Feb 15, 2011

I have the following SQL:

(SELECT COUNT(Incidentx) AS Expr3
WHERE (LBWF_1.KPIFailx = '1') OR
(LBWF_1.Chargex > '0.00') OR
(LBWF_1.LChargex > '0.00')

What I'm trying to do is divide TotalCalls by SlaFailed and * by 100 into a new variable such as Percentage. However, everytime I try to select SLAFailed or TotalCalls I receive a 'Column Names do not exist' message.

Is there any way I can reference said values?

View 5 Replies

.net - Dynamic Data - Make Friendly Column Names?

Jun 17, 2010

I've created a Dynamic Data project with an Entity Framework model. It works nicely. But, right now it shows all my database tables with the db column names - which aren't always the most friendly (e.g. address_line_1). How can I got about giving these more friendly column titles that will display to the end user?

View 2 Replies

C# - Get Column Names From Table Returned From Stored Procedure?

Feb 10, 2011

I have a stored procedure which returns a table. The stored proc is called via a linq datacontext.

It works fine and I get the table back however I really want to also get the title relating to each particular cell returned.

The stored procedure call is like:

var table = DataContext.GetTable().ToList();

So I get a List<GetTable>. The data is fine I just want the column names as well.

View 2 Replies

SQL Server :: Converting Dates To Strings For Column Names?

Jan 13, 2011

I am working on a query to pull the revenue for the last 7 days, as individual days, to be used in a bar graph. My query does what I want it to:


My question is: How do I change the Date1, Date2, Date3, etc to display the actual date it is pulling from? So instead of Date1, it will say "Jan. 3 2011" and so on...

View 2 Replies

Web Forms :: Display Alphabets Above Each Datagrid Column Names?

Feb 14, 2011

I have a requirement to display alphabets above each datagrid column names (like shown in excel). The datagrid columns (and header text) are dynamically created at run time and the alphabets on top could grow like excel A, B, C,....Z, AA, AB, AC,.....AZ etc. Any suggestions on how to get the alphabets showing for each columns?

View 1 Replies

Forms Data Controls :: How To Write The Column Names In Gridview

Jun 22, 2010

I want to write the default column names in gridview when the data is not coming from the dataset or you can say that datset is blank.

I tried to use this [Code]....

But this does not help me and i am not able to see the column with name as 'ID'

View 12 Replies

SQL Server :: Using String Variables As Column Names In A Select Statement?

Dec 20, 2010

I'm trying to use a function in my code behind to let me select a different column each time by calling the function with a different parameter.

However, I keep being told 'invalid column name', even though in the error page the column name appears perfectly valid.

Private Function getData(ByVal s As String) As String

View 4 Replies

DataSource Controls :: How To Find Column Names Without Selecting Data

Jun 14, 2010

I am writting a custom class with which I manipulate the data for my website. I was wondering if there is a way to connect to a database and retreive the column names for a given table with out sellecting any data in the table.

Currently I am using an sql select and connection string to create an SqlComman object. Then I use the command object to create a SqlDataAdapter object which I use to fill a DataSet. At the end of all that I am able to retrieve the column names but I have select data and retreived data.

View 2 Replies

VS 2008 Gridview - Hide Certain Columns And Change Column Names

Jun 15, 2012

I have a gridview that I am loading from a stored procedure. I need to be able to hide certain columns and change the column names. Since it is loading with stored procedure the columns aren't listed in the gridview->edit columns properties.

View 1 Replies

Web Forms :: Show Data In GridView Returned By Sp Different Column Names

Jul 6, 2012

my sp return resultset with different column names based on different parameters passed to sp and now i want to show that data in gridview so how can i achieve this

View 1 Replies

Web Forms :: How To Change Gridview Header Column Names Dynamically

Apr 5, 2012

I want to change Gridview Header column names dynamically with if condition.

for example

IF condition 1 

UserID |   Full name | Transaction Amt |  Tancaction Date 

IF condition 2 

UserID | Full Name | DOB | Balnace | Date 

How to change Header column name for single Gridview dynamically ?  

View 1 Replies

Export 4 Tables Data Into One Excel File In Different Sheets With Column Names?

Jan 11, 2010

anybody working on data exporting? I've 4 tables in my sql server database. I want to export these 4 tables data into one excel file in different sheets with column names.

View 7 Replies

Copyrights 2005-15, All rights reserved