penseur11
Last Activity: Sep 25 '10, 06:06 PM
Joined: Feb 10 '10
Location:
-
In this circumstance, in the xml file, it denotes an anonymous user. Just trying to deny access to anonymous users...but not working when I try to write it into the file. -
Writing a web.config file.. question mark problem
Hi,
I'm trying to write a new web.config file using VB in ASP.net. I am trying to set access permissions, but it won't let me use the question mark to denote: <deny users="?" /> in the authorization tag. Is there an alternative to this or a different encoding I should be using for this character?
My specific error: The '?' character cannot be used here.
Thanks for any replies
... -
got it!!!!
Figured it out! Here's the working code in case anyone needs:
...Code:Imports System.IO Imports System.Data.OleDb Public Class Update2 Sub LoadData() Dim objStreamReader As StreamReader = File.OpenText("/CMgmt/import.csv") While objStreamReader.Peek() <> -1 Dim Str1() As String = Split(objStreamReader.ReadLine(), ",")Leave a comment:
-
importing csv to mdb file - multiple fields
Hi,
I had this code working to import one column in a table as a starter point, but now that i'm trying to import all the columns in the table, i'm running into problems.
When I run the app, I get this Microsoft . NET Framework error:
Syntax error in INSERT INTO statement
I've tried just about every combination I can think of for the sql statement and still the same error message.
... -
Sort of working
Thank you Cocrew, got it working!! This is the final code I used, if anyone needs it for future.
I'm running into one problem though, in the db table the that I'm importing the data to is a primary key field and there will always be duplicates when I run the app. I keep getting this message each time I run the app. Is there any way to prevent this from popping up?
It says "The changes...Leave a comment:
-
Thanks tlhintoq, so my error is using an oledb connection and command instead of sql?Leave a comment:
-
importing a csv to access table
Hi,
I'm trying to write a small application that imports data in a column from a csv file into a table in access. I'm very new to programming, but this is what i've come up with so far. It runs, but it's not actually bringing the data over to my database.
Can anyone help?
Here is the code:
...Code:Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Last edited by tlhintoq; Feb 10 '10, 10:05 PM. Reason: remove the 5x line spacing to see all the code at once
No activity results to display
Leave a comment: