You searched for the word(s): userid:560223

More Search Options

RSS Available

• 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