Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:560223
More Search Options
RSS Available
Matching Posts
Re: Import distinct rows from csv into DataTable
Thanks Siju, that looks great. Only 1 problem, my DataTable has 3 columns, and I'd like the Distinct filter to occur on 1 column only, but still return all columns. I now have: Dim view As DataView = dt.DefaultView Dim dt2 As DataTable = view.ToTable(dt, True, New String() {"Email", "FirstName", "Surname", "Password", "Pass", "CompanyID"}) But it's still returning a full dataset because the combination of rows values is unique. I
Posted to
Data Access and ObjectDataSource Control
(Forum)
by
aspnewbieperson
on 11/5/2009
Import distinct rows from csv into DataTable
I'm trying to import a csv file into a datatable, but I'm having issues getting rid of the duplicate rows (only 1 column/field requires unique data). The crux of it is here. Dim strSql As String = "SELECT * FROM [" & fileinfo.Name & "] WHERE Email IN (SELECT DISTINCT Email FROM [" & fileinfo.Name & "]) ORDER BY Email" I'm thinking DISTINCT etc don't seem to work with OleDb as the query is still returning all results. Any ideas?
Posted to
Data Access and ObjectDataSource Control
(Forum)
by
aspnewbieperson
on 11/4/2009
Re: HtmlEncode BULKCOPY
I've reverted to using AntiXss.HtmlEncode, which does exactly what I require.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
aspnewbieperson
on 11/2/2009
HtmlEncode BULKCOPY
Hi, I'm importing a csv file into SQL Server using BULKCOPY. How can I use Server.HtmlEncode for data that comes from the csv file before it goes into SQL Server? If possible, I only need to run it on 1 column in particular. I have it all working except I can't figure out how to get htmlencode happening. Any help would be appreciated.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
aspnewbieperson
on 10/15/2009
Re: HtmlEncode BULKCOPY
I'll try to explain it a little clearer. I am importing the csv into SQL Server using BULKCOPY. I would like to encode 1 of the columns of data before it goes into the database. So, the csv is imported and a DataTable is created, the columns are mapped using the Schema.ini file and column mapping. As I say, all is working fine on that side of things - I am getting all data into the database fine. The issue is I can't figure out how to encode one of the datacolumns before it gets inserted
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
aspnewbieperson
on 10/15/2009
Re: HtmlEncode BULKCOPY
FirstName,LastName,EmailAddress John,Smith,john@smith.com Jane,Smith,jane@smith.com Gran,Smith,gran@smith.com I've used the encoding in the past on email address and the data is stored as joehn@smith.com
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
aspnewbieperson
on 10/15/2009
Re: HtmlEncode BULKCOPY
Don't worry about why I'm just after the how!
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
aspnewbieperson
on 10/15/2009
Import csv into SQL Server 2005 using VB.Net
Hi, This has me stumped with the exception "Unspecified error". This is the first part of the process of importing a .csv file into SQL Server. Can anyone see why this is throwing that exception? Protected Sub UploadCSV(ByVal Sender As Object, ByVal E As CommandEventArgs) If fup1.HasFile Then Try Dim fileinfo As New FileInfo(fup1.PostedFile.FileName) Dim strCsvFilePath As String = (Server.MapPath("csv") & "\") + fileinfo.Name 'Save the CSV file in the Server
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
aspnewbieperson
on 10/13/2009
Re: Import csv into SQL Server 2005 using VB.Net
I resolved the issue. In the web.config file, I had: <identity impersonate="true" /> Switch it to <identity impersonate="false" /> and it works perfectly. I now need to do some reading.....
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
aspnewbieperson
on 10/13/2009
Email Newsletter System - Where To Start?
Hey, I would like to develop a simple email newsletter system to be used as part of a very basic CMS. Capturing addresses, using templates, archiving newsletters etc is all fine. The side of things I'm not too familiar with is the actual sending of bulk emails in ASP.Net (> 2.0). Can anyone give me a brief rundown on what is required/what to look out for/be aware of? It'd be nice to have the system handle newsletters with up to 10,000 subscribers, handle bounced messages, and things like
Posted to
Architecture
(Forum)
by
aspnewbieperson
on 6/15/2009
Page 1 of 22 (215 items) 1
2
3
4
5
Next >
...
Last »
WindowsClient:
Snoop with 64 bit support
ASP.NET:
jQuery Hide/Close Link
ASP.NET:
Merry Christmas
TechNet Edge:
FPE Customer Story
Silverlight:
Being a writer, and having an editor. A Short Rant.
Channel 9:
Channel 9 Live at PDC09: Dr Brian Brooks (3M)
Channel 9:
C9 Lectures: Dr. Erik Meijer - Functional Programming Fundamentals Chapter 13 of 13
Silverlight:
Information for Silverlight HVP Developers…
WindowsClient:
Custom Content Loaders in Silverlight 4.0
WindowsClient:
MVVM Links\Info
TechNet Edge:
Check out how Dolly Parton uses IE8 and Web slices!!!
Silverlight:
A Silverlight HVP Update
Channel 9:
Channel 9 Live at PDC09: This Week on Channel 9 - PDC09 Daily Show Edition Day 1
Channel 9:
Maria Klawe: Scholar, Scientist and Microsoft Board Member
Channel 10:
Play the Bing Sherlock Holmes Game
Channel 9:
Channel 9 Live at PDC09: Loic Le Meur
Channel 10:
How to Delete Jump List Items
Channel 10:
Roll Back to Classic Network Indicator in Win7
Channel 9:
Jafar Husain: Silverlight Toolkit and Rx, Part 2
Channel 9:
Ping 42: Is Microsoft cool? Photo DNA, Win7 tool, 10k MIX contest
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online