C# - Adding A Way To Preserve A Comma In A CSV To DataTable Function

May 17, 2010

I have a function that converts a .csv file to a datatable. One of the columns I am converting is is a field of names that have a comma in them i.e. "Doe, John" when converting the function treats this as 2 seperate fields because of the comma. I need the datatable to hold this as one field Doe, John in the datatable.

Function CSV2DataTable(ByVal filename As String, ByVal sepChar As String) As DataTable
Dim reader As System.IO.StreamReader
Dim table As New DataTable
Dim colAdded As Boolean = False
Try
''# open a reader for the input file, and read line by line
reader = New System.IO.StreamReader(filename)
Do While reader.Peek() >= 0
''# read a line and split it into tokens, divided by the specified
''# separators
Dim tokens As String() = System.Text.RegularExpressions.Regex.Split _
(reader.ReadLine(), sepChar)
''# add the columns if this is the first line
If Not colAdded Then
For Each token As String In tokens
table.Columns.Add(token)
Next
colAdded = True
Else
''# create a new empty row
Dim row As DataRow = table.NewRow()
''# fill the new row with the token extracted from the current
''# line
For i As Integer = 0 To table.Columns.Count - 1
row(i) = tokens(i)
Next
''# add the row to the DataTable
table.Rows.Add(row)
End If
Loop
Return table
Finally
If Not reader Is Nothing Then reader.Close()
End Try
End Function

View 6 Replies


Similar Messages:

Web Forms :: Preserve DataTable Across PostBack In Application

Feb 18, 2013

In asp.net(C#) using a popwidnow i am to hold  some values in dummy table after that dummy table's value and rest form values needed to be added in database. How to proceed with that?

View 1 Replies

C# - Putting Datatable Comma Separated Values In A String?

Feb 4, 2011

My datatable consists of a column named "ID". The no. of values in this column varies.Sometimes this Datatable fetches 3 IDs in that ID column, sometimes 2. Now if for example, my datatable has three values as 1,2,3. What I want is to put these three values in a string and separate them by commas as folows:-

string test= "1,2,3";

If Datatable has 2 values, then string should be as follows:-

string test= "1,2";

I did try but in vain.

edit:-

DataTable dt=new DataTable;
dt = obj.GetIDs();
for (int i = 0; i < dt.Rows.Count; i++)
{
string test= "What should be here????";
}
edit 2
foreach(DataRow dr in dt.Rows)
{
string str = str + "," + Convert.ToString(dr("ID"));
}


@Rajeev ::Tried this..it says dr is a variable but used as a method. What's wrong?

View 4 Replies

C# - Order Datatable By Relevance Using Linq By Column Values Which Are Comma Sperated?

Aug 31, 2010

I have a Datatable that contains a column called Tags, Tags can have values such as

row[0] = Tag1
row[1] = Tag1, Tag2
row[2] = Tag2, Tag3
row[3] = Tag1, Tag2, Tag3
row[4] = Tag4, Tag6

and are seperated by comma's etc..

I have the value of Tags for the current document and have run a query to select all other documents that have either of the Tags in there row. for example lets say the current document Tags are (Tag1, Tag2, Tag3)

so from the example rows above all the rows above are returned apart from row[4] Here is the bit i'm lost with, i now want to sort the datatable by how many tags are matched with the current document. so for the example i've talked about so far they should be ordered

row[3] = Tag1, Tag2, Tag3
row[1] = Tag1, Tag2
row[2] = Tag2, Tag3
row[0] = Tag1


Not used linq before but was told it could do this. so far i have

var query = from c in dt.AsEnumerable()
orderby c.Field<string>("Tags").CompareTo(dr["Tags"]) ascending
select c;

View 3 Replies

Adding Comma Separators To Numbers?

Nov 30, 2010

I'm trying to add comma separators to a number. I've tried the advice here: add commas using String.Format for number and and here: .NET String.Format() to add commas in thousands place for a number but I can't get it to work - they just return the number without commas. The code I'm using is here:

public static string addCommas(string cash) {
return string.Format("{0:n0}", cash).ToString();
}

Where am I going wrong?Update: Hi all, thanks for your help, but all of those methods are returning the same error: "error CS1502: The best overloaded method match for 'BishopFlemingFunctions.addCommas(int)' has some invalid arguments" (or variations therof depending on what number type I'm using.)

View 3 Replies

Forms Data Controls :: Eval Function Of Datalist - Error. Comma, ')', Or A Valid Expression Continuation Expected?

Feb 1, 2010

<asp:Button ID="btnDetail" OnClick=<%#"javascript:return Detail(DataBinder.Eval(Container.DataItem,"Description"));"%> runat="server" Text="View Detail" />

it is giving me error.

Comma, ')', or a valid expression continuation expected.

View 7 Replies

Passing Comma Separated Value From .net To Stored Procedure And Using The Value In "IN" Function In Sql?

Nov 18, 2010

I have a sql query something like below.

create procedure test
(
@param1 nvarchar(max)
)
as
begin
select * from table where column1 in (@param1)
end

Now i need to pass the value of @param1 from my .net application in such a way that the above query works.

how from my vb.net code i can pass a value which is similiar to below

'1','2','3'

Main question is how do i structure value of parameter like above example from my .net application

View 3 Replies

SQL Server :: How To Combine Multiple Rows Into A Comma-delimited List In Sql Server In Build Function

Jan 10, 2011

How can I combine multiple rows into a comma-delimited list in sql server in build function?? in HCL

examples :

X
---
12
15
18
20

Output : 12, 15, 18, 20

with in build function of sql server.

View 6 Replies

Adding A DataColumn To A DataTable?

Nov 22, 2010

How do I go about adding a ButtonColumn to a DataTable.

I am basically using a DataTable as the DataSource of a DataGrid and need to add a ButtonColumn to the DataTable so that when I DataBind it to the DataGrid it all works.

Although when I try

dt.Columns.Add(buttonColumn)

This is not allowed. It has to be a basic DataColumn.

View 1 Replies

Adding An Extra Column In A Datatable

Jun 21, 2010

How do you add an extra column in a datatable which will be used for another query

View 3 Replies

Adding Values For Datatable Column?

Dec 27, 2010

i have a sum column in my datatable and want to add the values?

is compute a good method to use?

View 1 Replies

Web Forms :: Adding Rows To Datatable

Dec 6, 2011

I have added a row to a datatable and displayed this datatable by binding it to gridview.. Later if i add another row to the same table, the data table displays only the recently added row.. I need to display the previously added row along with the newly added row.. How to do this?

View 1 Replies

Web Forms :: Overload Function To Take Datatable Or Dataview?

Mar 28, 2011

I need to handle a datatable or dataview in the code below

private
void SetListDataSource(ListControl
lc, DataView d,
string valueField,
string
textField)

[Code]....

View 1 Replies

Adding Duplicate Type Of Column To A Datatable?

Jan 9, 2011

How can i add same fields for columns in a datatable. I wan to make a datatable which repeate column name of same type multiple times, but dot net dont allow me to add that, but i want to do that hw can i do that?

table.Columns.Add("S.NO", typeof(int));
table.Columns.Add("DC", typeof(string));
table.Columns.Add("DC", typeof(string));
table.Columns.Add("DC", typeof(string));
table.Columns.Add("ST", typeof(string));
table.Columns.Add("ST", typeof(string));
table.Columns.Add("AD", typeof(string));
table.Columns.Add("AD", typeof(string));

View 1 Replies

Data Controls :: Get Index Of Row When Using DataTable Select Function

Jul 17, 2015

I want all Index value from data table using condition. I have tried like below but not getting expected results

foreach (DataRow rows in dtResult.Select("IsOut = 'True'"))
{
int index = rows.Index;
}

View 1 Replies

Web Forms :: Adding Datarows To Existing Datatable In Dataset?

Feb 5, 2010

I need to add rows to an existing (maybe) datatable in a dataset that combines the IIS6 index search with my own sql table. I keep getting object reference errors.

[Code]....

View 4 Replies

DataSource Controls :: Adding A DateTime Field To A DataTable?

May 20, 2010

I'm looping through an ArrayList and creating a column in a DataTable from each field. One of my fields is a DateTime field, and I've noticed that when I create the columns, it's being changed to a String, but I need it to still be a DateTime field for sorting. I'm trying to do this, but it's not quite working.

[Code]....

View 3 Replies

Forms Data Controls :: Adding Dt.select To New Datatable?

Apr 14, 2010

i am using dt.select to filter rows

now i want to add those filter rows to a datatable

View 1 Replies

Web Forms :: Adding Rows To Datatable And Binding It In GridView

Dec 9, 2011

I have a gridview with empty data template. In this empty data template i have a table(HTML) with 4 columns. When user enters data i want to save this in a datatable temporarily at a button click event.. Again if user wants to add one more rows data that also should be added to the same table where i added previous row data. So now the datatable has 2 rows. Like this he may add any no of rows. What i want is all the rows should be displayed when i bind datatable to gridview..At the click event i am adding 1 row at a time to the datatable

View 1 Replies

Data Controls :: Filter DataTable Rows Using Select Function In C#

Aug 18, 2015

I have a ListView with Checkbox. My requirement is - When I click on any checkbox then it should return all the columns values of that row on behalf of that CheckBox. After much study I came to know that using DataTable and DataRow I can get all data of particular ID of a Row. But I am unable to work with this. My code is something like below:
 
DataTable dt=new DataTable();
dt=objBAL.Get_ShoppingCartData();
ListView1.DataSource=dt.Tables[0];

[Code].....

View 1 Replies

DataSource Controls :: Adding Rows And Updating Tables From Datatable

Mar 7, 2010

Maybe this could be a simple questino, but for me it's difficult to do this action: I have a table in sql server 2005 with some records stored, for example 10 records. The primary key of this table, let's call it "Employee", it's a number field with an autoincrement constraint. I want to store more data into the table by using a OdbcDataTable object and OdbcDataAdapter and adding new rows to the datatable and afeter that use the "Update" method from the OdbcDataAdapter object.

The big deal is this: let's suppose that I want a add a new record to the datatable object, using any method or code sequence that you want. if I have 10 records stored on the data base table, when I retrieve this table schema by using the OdbcDataAdapter "Fill" method, I have a copy of the data base table schema in the DataTable object, right?. if I add a new row on the datatable object, it's suppose that the primary key column of that table must AUTO-INCREMENT the value of the key, I mean if the last value that I store on the table was the number 10 on the PK field, when I add a new row on the datatable object, the PK value on the datatable object must be the number 11 if the autoincrement constraint is present into the DataTable object, but in my case, it doesn't work

So, How can I define the conditions or set the c# data objects properties to wor in that way???. In this moment the PK column on the odbcDataTable doesn't auto-increment its value when I add a new row on it.

Please helpe with this.

PD: I have another question about the DataTable object, how many records can store this object?? I have some problems with this because sometimes when I use the Fill() method to get data into the DataTable or a DataSet object there's no problem if the Fill() method retrieves about 142000 records, but when I retrieve over the 145000 records, when I inspect the DataSet or DataTable object by using the debuging mode, they have null value. Any of you can tell me why this situation ocurrs??

View 1 Replies

DataSource Controls :: Adding List Item Collection To Datatable?

Jul 7, 2010

I have a list item collection. How to add this list item collection to a datatable.

The list item collection has the following fields:

Student Name, Maths Mark
John 20
Mac 30
John 35

I want to create a html table from the data table, which is grouped on the Student Name field.

View 2 Replies

DataSource Controls :: Limiting String Length When Adding New DataTable Row?

Mar 13, 2011

I need to limit the length of the string that load into a DataTable that is being used to display. The data I am loading is coming from another DataTable. How do I shorten row["CG_GalleryName"] contents to 24 characters.

Convert.ToString(row["CG_GalleryName"]) -- how do I set this length to 24 characters? Using it in the below code.

if (Convert.ToInt16(row["rnum"]) == 1)
{
dr = GLinks.NewRow();
dr["rnum"] = row["rnum"];
dr["L_URL"] = row["L_URL"];
dr["CG_GalleryName"] = row["CG_GalleryName"];
dr["L_Picture"] = row["L_Picture"];
GLinks.Rows.Add(dr);

View 8 Replies

DataSource Controls :: Create Interface For Adding Users - Datatable Or Dataset

May 3, 2010

I need to create an interface for adding users to .Net Membership DB through an existing database. My Idea is to read each row from database from existing users table in a datatable and then iterate through each row and add it to new database. I cannot directly copy the rows from existing users table because the password stored in .Net Membership provider is in ir-reversible hash code and hashing is done through encryption algorithm present in front end code. My User count is huge (in millions).So what should i use to read the records, Dataset or datatable. Also tell what is the max number of rows it can hold.

View 3 Replies

Web Forms :: Invoke C# Function From Another Project Without Adding Reference?

Sep 24, 2010

There is a C#.net libraray project whose dll name is customer.dll. It has a class name customer with a function name show(). I want to call this function from another project but dont want to add reference to the caller project. Can this be done? Is there any C#.net class that can acheive this?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved