Visual Basic

10-Apr-09 3:54

hi, I am Rana
I am using vb.net to accomplish following task:
1) read a csv file from hard disc
2) display it on DataGridView
3) use the datagridview to update an existing access dataset table which has exactly same number of fileds as input csv file displayed in datagridview
4) add query to the updated datset table
5) exporting the result to a text file

So far I cud only hab done until step 2. I desperately need help on rest of 3 steps. Here is my code:

Code Block:
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.OleDb
Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If OpenFileDialog1.ShowDialog(Me) = DialogResult.OK Then
Dim fi As New FileInfo(OpenFileDialog1.FileName)
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Text;Data Source=" & fi.DirectoryName
Dim objConn As New OleDbConnection(sConnectionString)
Dim objDataSet As DataSet = New DataSet()
objConn.Open()
Dim objCmdSelect As New OleDbCommand("SELECT * FROM " & fi.Name, objConn)
Dim objAdapter1 As New OleDbDataAdapter
objAdapter1.SelectCommand = objCmdSelect
objAdapter1.Fill(objDataSet, "test")
DataGridView1.DataSource = objDataSet.Tables(0).DefaultView
objConn.Close()
End If
End Sub
End Class

Please help me on how i can do above three things ASAP.

Dave Kreskowiak10-Apr-09 4:25

10-Apr-09 4:25

Sorry, but this has "homework assignment" written all over it. We're not going to write your code for you. You wouldn't learn anything that way.
Everything you need has already been covered in your class.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

rajulama10-Apr-09 4:48

10-Apr-09 4:48

Hello Dave Kreskowiak,
please believe me its not a homework assignment. actually I am doing it as a part of the development. I have been trying :
objAdapter1.Update(Me.Db1DataSet.Sheet1)
but its not working. I just want your help on updating the database with this datgridview that's all. Rest I can do. Please help me!

MidwestLimey10-Apr-09 5:10

MidwestLimey

10-Apr-09 5:10

rajulama wrote:
I just want your help on updating the database

A word of advice, the verb to Want is too abrasive to use when you are the one making a request from a position of weakness. It's better to use the subjective, i.e. "would like". Same principal I know applies in Spanish and German and I would expect to be fairly universal. Put simply it's the polite way to make a request of somebody you have no authority over.

Not that it'll help you here, mind.
Also, for the love of God, use a decent naming system!

10110011001111101010101000001000001101001010001010100000100000101000001000111100010110001011001011

rajulama10-Apr-09 5:17

10-Apr-09 5:17

sorry,
I would be really grateful to you if you could help me. Please don't mind. Help me out, please!

Jon_Boy10-Apr-09 6:25

10-Apr-09 6:25

MidwestLimey was correct and you're still not quite getting it. It's not polite to ask for help and then in the same request demand it with an exclamation mark. So lets practice as if you were going to ask for help from Dave, you could try kissing his a$$ a little like:

"Dave the almighty who rules next to Xerxes - could you find it in your gracious heart to feel pity upon my disgraced soul and help me with my problem? I am nothing without your assistance and bow before your presence."

Or...........you could simply ask for help without it demanding, caps, or !s. Your problem does kind of look like a homework assignment.

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Dave Kreskowiak10-Apr-09 7:15

10-Apr-09 7:15

Jon_Boy wrote:
"Dave the almighty who rules next to Xerxes - could you find it in your gracious heart to feel pity upon my disgraced soul and help me with my problem? I am nothing without your assistance and bow before your presence."

OK, OK, I don't need to be wiping your lipstick off my ass! Big Grin | :-D

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

EliottA10-Apr-09 13:46

EliottA

10-Apr-09 13:46

+5 for the wit, -5 for not wanting a little lipstick on the ass.

Check out the CodeProject forum Guidelines[^]

rajulama10-Apr-09 18:34

10-Apr-09 18:34

If OpenFileDialog1.ShowDialog(Me) = DialogResult.OK Then
            Dim fi As New FileInfo(OpenFileDialog1.FileName)
            Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Text;Data Source=" & fi.DirectoryName
            Dim objConn As New OleDbConnection(sConnectionString)
            Dim objDataSet As DataSet = New DataSet()
            objConn.Open()
            Dim objCmdSelect As New OleDbCommand("SELECT * FROM " & fi.Name, objConn)
            Dim objAdapter1 As New OleDbDataAdapter
            objAdapter1.SelectCommand = objCmdSelect
            objAdapter1.Fill(objDataSet, "test")
            DataGridView1.DataSource = objDataSet.Tables(0).DefaultView
            objConn.Close()

After this I wrote:

objAdapter1.Update(Me.Db1DataSet.Sheet1("test"))

Because the dataset that I want to update is in by DB1DataSet.Sheet1. I dont want to update the datagridview itself. I want to update an existing database called DB1DataSet.Sheet1 from the datagridview.

when I wrote above line its says following error:

Error	1	Overload resolution failed because no accessible 'Update' can be called with these arguments:
    'Public Function Update(dataTable As System.Data.DataTable) As Integer': Value of type 'WindowsApplication1.db1DataSet.Sheet1Row' cannot be converted to 'System.Data.DataTable'.
    'Public Function Update(dataRows() As System.Data.DataRow) As Integer': Value of type 'WindowsApplication1.db1DataSet.Sheet1Row' cannot be converted to '1-dimensional array of System.Data.DataRow'.
    'Public Overrides Function Update(dataSet As System.Data.DataSet) As Integer': Value of type 'WindowsApplication1.db1DataSet.Sheet1Row' cannot be converted to 'System.Data.DataSet'.

Kschuler10-Apr-09 7:50

Kschuler

10-Apr-09 7:50

rajulama wrote:
but its not working

If you want help, you have to give more information. What isn't working? What error message are you getting? Show us what code you have so far. We're not going to do your work for you, but if you have a specific problem we can try to point you in the right direction to get help.

rajulama10-Apr-09 8:41

10-Apr-09 8:41

If OpenFileDialog1.ShowDialog(Me) = DialogResult.OK Then
Dim fi As New FileInfo(OpenFileDialog1.FileName)
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Text;Data Source=" & fi.DirectoryName
Dim objConn As New OleDbConnection(sConnectionString)
Dim objDataSet As DataSet = New DataSet()
objConn.Open()
Dim objCmdSelect As New OleDbCommand("SELECT * FROM " & fi.Name, objConn)
Dim objAdapter1 As New OleDbDataAdapter
objAdapter1.SelectCommand = objCmdSelect
objAdapter1.Fill(objDataSet, "test")
DataGridView1.DataSource = objDataSet.Tables(0).DefaultView
objConn.Close()
End If

I have this and now to replace the data in existing database with that in datagridview I am using:

objAdapter1.Update(Me.dataset.filename)

But its not making any change in dataset table.rest is ok.

Kschuler10-Apr-09 8:47

Kschuler

10-Apr-09 8:47

Show us the code around your update statement. Is your command still setup when you issue the update? Shouldn't your update statement be something more like this:

odjAdapter1.Update(Me.objDataSet.Tables("test")) ??

Adding my app's link to Desktop Context Menu

Yusuf10-Apr-09 9:23

Yusuf

10-Apr-09 9:23

rajulama wrote:
please believe me its not a homework assignment

Ok, I'll take your word

rajulama wrote:
actually I am doing it as a part of the development.

If I can not get my work done at my job, then I'll have to face the reality. Shouldn't you?

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

Sumit Prakash Sharma10-Apr-09 1:05

Sumit Prakash Sharma

10-Apr-09 1:05

When you right click on the desktop you get a context menu that has something like that:

-----------------------

Arrange Icons By

Refresh

-----------------------

Paste

Paste Shortcut

-----------------------

New

-----------------------

Properties

-----------------------

I need to add a link to my application on Desktop's context menu. How can I accomplish that? What registry key do I need to modify/add to get my app icon listed on the desktop context menu?

E.g.:

---------------------------

Arrange Icons By >

Refresh

---------------------------

My App Link >

Paste

Paste Shortcut

---------------------------

New

---------------------------

Properties

---------------------------

Please help. Thanks.

Jon_Boy10-Apr-09 1:57

10-Apr-09 1:57

Not sure if we got it yet, could you post the question again? (snicker)

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Dave Kreskowiak10-Apr-09 3:00

10-Apr-09 3:00

You posted the exact same question 4 hours ago. Don't. What you're doing is considered very rude and will only get you ignored.

We don't get paid to answer everyones questions. We do this on a volunteer basis, when we can, for as long as we can. Myself, I just woke up 30 minutes ago. Sorry if I wanted to get some breakfast before diving into your question.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

*Developer Day Scotland - Free community conference Delegate Registration Open

Colin Angus Mackay10-Apr-09 3:12

Colin Angus Mackay

10-Apr-09 3:12

Dave Kreskowiak wrote:
I just woke up 30 minutes ago

Good Morning to you. Smile | :)

I don't know why you can't answer questions when you are asleep. I do some of my best work whilst asleep.

Jon_Boy10-Apr-09 3:16

10-Apr-09 3:16

Now if only you could telepathically port your dream code into actual code......

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Steven J Jowett10-Apr-09 4:26

Steven J Jowett

10-Apr-09 4:26

All my coding works like a dream Cool | :cool:

(Well, in my dreams anyway)

Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.

Dave Kreskowiak10-Apr-09 3:28

10-Apr-09 3:28

Ahhh...Breakfast was good! I get today off, so I slept in! Thumbs Up | :thumbsup:

Now, where were we?? Big Grin | :-D

On yeah! Context menus and some guy who cross posts!

Here's an example for you import using RegEdit to add Notepad to the context menu:

Windows Registry Editor Version 5.00
 
[HKEY_CLASSES_ROOT\*\shell]
 
[HKEY_CLASSES_ROOT\*\shell\Notepad]
 
[HKEY_CLASSES_ROOT\*\shell\Notepad\command]
@="\"C:\\Windows\\Notepad.exe\" \"%1\""

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Jon_Boy10-Apr-09 4:01

10-Apr-09 4:01

Glad you got to start the day off right and I'm totally jealous of you getting the day off!

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Sumit Prakash Sharma10-Apr-09 22:46

Sumit Prakash Sharma

10-Apr-09 22:46

Sorry it is not working properly please provide me step by step solution. Thanks

Dave Kreskowiak11-Apr-09 6:52