|
Good luck, I hope it works out for you.
People usually use these forums to ask questions, ideally about code they have written, not about tasks they have accepted and have no idea how to even start.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Hi I am new for .Net....
I work with Microsoft Visual Basic 2008
I want to import the csv(comma delimited values) file into my database(Access). I read the file using StreamReader(File IO) instead of database (OLEDB) connection.I read the line and splited each values by 'comma' and stored into an array of strings. The csv file may contain field names or not...
Now my problem is i want to read the records from csv file and store into database in appropriate field names in table(access)(I dont know how many records in csv and whether it contains field name or not, and also only selected fields are stored into database.)
Can someone explain?
Thanks in Advance...
|
|
|
|
|
You can open the mdb with any .net connection and use the INSERT SQL to import the csv data.
Ensure the target table is blank and make a Schema.ini file for define the schema of the csv file.
eg.
string sql = string.Format("insert into {0} select * from [Text;FMT=Delimited(|);HDR=No;DATABASE={1};].[{2}#csv];",
info.TableName, info.FilePath, info.FileName);
System.Data.Odbc.OdbcCommand command = new System.Data.Odbc.OdbcCommand(sql, connection);
command.ExecuteNonQuery();
for schema.ini
http://msdn.microsoft.com/en-us/library/ms709353.aspx
Emimmortal
|
|
|
|
|
Thanks for your reply....
My target table contains values(master table).I want to add the selected columns( appropriate values) from the csv file to related fields in the master table..(Mapping via field names, if csv doesn't contain field names we can assign...)
How is this possible...
Please explain...
|
|
|
|
|
When you create this post it suggested you first search the site and ot Google. This is one of the most asked questions ANYWHERE, do the searches!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi
Im sorry. I know that this subject does not belong to this forum but I asked this question also in suggestions and saw no response.
I sent an article to codeproject about 2 weaks ago. I dont know why this article is still unedited.If this article[^]"> has fatal bugs or doesnt meet the CodeProject expected quality why people there dont inform me via e-mail? they seem too busy!
A.E.Kubanani
|
|
|
|
|
|
A.E.K wrote: why people there dont inform me via e-mail?
The article looks good to me. Don't worry, unedited means unedited. If they had looked at it to bother to email you, they would have edited it, I would presume.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Background: I have a datagridview that I am adding rows to manually. In design mode, I have specified the column header text on all columns to sans sherif, 14, bold (I have done this specifically to each column and also specified the font settings as the default header cell style). Various other formatting changes were made like making the highlighted rows yellow etc.
1. When I start the app, the column header text reverts back to the default header text sytle (Arial 8). What causes this to occur?
*EDIT* - in regards to #1, I found that if I reset the AutoSizeMode, the column header text switches back to one line. But what is the root cause of the grid losing the formatting at runtime?
I also found some posts on other sites that forcing a sort on the grid may at times clear the formatting. In this case, I'm not doing any sorts that would cause this condition. Any ideas on why this occurs?
Any suggestions, ideas, or 'constructive criticism' are always welcome.
modified on Thursday, August 21, 2008 8:47 AM
|
|
|
|
|
I need to create a routine that queries a database whenever an event is fired. the thing is that I have to wait a specific amount of time before I execute that query. I am already able to run the sql query but I am not sure how to go about waiting the specified amount of time. Also each time the event is fired, it could require a different wait time, which could be up to 24 hours.
Right now I use a background worker to process the database query but can I (should I) use a wait inside the background worker?
Thanks in advance
|
|
|
|
|
Yes (and yes). There are two ways that come to mind if you need this kind of a wait. If you will not ever need to cancel the wait, you can just use Thread.Sleep, but if you may need to cancel (eg: to shut the thread down immediately), you can use an AutoResetEvent (or one of the other similar System.Threading classes).
As far as the variable wait time, just encapsulate the DoWork event handler in a class with the wait time as a field or property.
Here's a simple console app sample to demonstrate the two ways. Uncomment the lines and comment the Thread.Sleep line to use the AutoResetEvent instead.
Dim waitTime As Integer
Dim handle As New System.Threading.AutoResetEvent(False)
Sub Main()
Dim rand As New System.Random
waitTime = rand.Next(10, 20)
Dim bw As New System.ComponentModel.BackgroundWorker
AddHandler bw.DoWork, AddressOf WorkerRoutine
Console.WriteLine("Wait time will be {0} seconds", waitTime)
bw.RunWorkerAsync()
'Console.WriteLine("Press any key to interrupt the worker.")
'Console.ReadKey()
'handle.Set()
Console.WriteLine("Program complete...")
Console.ReadKey()
End Sub
Private Sub WorkerRoutine(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs)
Console.WriteLine("Beginning work")
System.Threading.Thread.Sleep(waitTime * 1000) 'gives a non-interruptable sleep
'handle.WaitOne(waitTime * 1000, False) 'gives an interruptable "sleep" period
Console.WriteLine("Ending work")
End Sub
|
|
|
|
|
Is there a good way to connect to a password protected Access databse usig VB.Net?
I tried some of those but it is still giving me errors!!
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;"
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="
|
|
|
|
|
I use an OLEDB connection with this connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
If you are looking for more connection string options this [^]is a great site.
Hope this helps.
|
|
|
|
|
may be work with
Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=PWD;Data Source=C:\mydatabase.mdb;Persist Security Info=False
Emimmortal
|
|
|
|
|
Thank you all for replying. It was a great help to try diffrent methods.
John,
|
|
|
|
|
i need help on something i have this
Dim SQLIinsert As String = "UPDATE httpuser SET credits= " + -1 + "' WHERE username='" + My.Settings.Username + "'"
what i need is to decrease the column credits by 1 but it this i get -1 in the database.
can someone explain whats wrong? ive searched but im almost ready to quit.
thanks in advance
|
|
|
|
|
You are telling the database 'SET credits=-1', so that is what it's doing. I believe you can say 'SET credits=credits-1' to get the effect you want.
|
|
|
|
|
thanks that does the job very well.
|
|
|
|
|
Hi,
I work with vb6
i need to write a function which will get
an array of bytes, count how many bytes are
there and run a loop in that size...
i managed to get the length of an array with "x = LenB(y)"
but that function somtimes recieve a single byte (not an array)
and then the size i get for it is 4 instead of 1
how can i determin if what i get in is a byte or an array of bytes
also i dont know what to write in the declaration of the function
("Function myfunc(???)")
thanks in advance.
|
|
|
|
|
It would be easier to help if you post your code and show us where the problem is.
|
|
|
|
|
O.k its quite simple , im not at home so ill write what i remember.
Function CS(a) 'is the decleration ok ?
dim n as int 'Define counter
dim temp as byte 'temp for storing CS
temp = 0
dim b(LenB(a)) as byte '(if a is 7 bytes long i get a new aray of 8 bytes here)
for n = 0 To LenB(a)-1
b(n) = a(n)
temp = temp Xor a(n)
next
.
.
.
b(n+1) = temp '(i dont remeber if its n or n+1 depends if it got increased by the for)
a = b
End Function
if i send an array to this function all goes well
lets say i have an array of bytes named try1(7)
the LenB(a) will return the currect size of it
but when i send it a single byte (not an array) it returns 4.
i need to find a way to get the size of "a"
so if its 1 ill skip the "for n=0..." and do somthing else.
Thanxs again.
|
|
|
|
|
Hi All,
Can you please correct if I am wrong I have declared a function that returns array of object as below, pls. rectify me if I am wrong
Public Function convertInToObject(ByVal dsParameterValues As DataSet) As Object()
Thanks a Lot,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
|
I think it should be this when you return an array.
Public Function convertInToObject(ByVal dsParameterValues As DataSet) As Array
|
|
|
|
|
Just out out of curiousity would any of 2 of you who gave me a 1 vote explain your reason since the answer I gave is correct. As Object will work because of late binding but As Array is preferable.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
