Click here to Skip to main content
15,888,242 members
Home / Discussions / C#
   

C#

 
AnswerRe: XML Writer and the ampersand Pin
PIEBALDconsult9-Jun-08 5:46
mvePIEBALDconsult9-Jun-08 5:46 
QuestionHow to execute an SQL statement from a DataSet? Pin
bouli9-Jun-08 3:29
bouli9-Jun-08 3:29 
AnswerRe: How to execute an SQL statement from a DataSet? Pin
leppie9-Jun-08 3:32
leppie9-Jun-08 3:32 
AnswerRe: How to execute an SQL statement from a DataSet? Pin
Vimalsoft(Pty) Ltd9-Jun-08 4:02
professionalVimalsoft(Pty) Ltd9-Jun-08 4:02 
GeneralRe: How to execute an SQL statement from a DataSet? Pin
bouli9-Jun-08 4:40
bouli9-Jun-08 4:40 
GeneralRe: How to execute an SQL statement from a DataSet? Pin
Vimalsoft(Pty) Ltd9-Jun-08 5:02
professionalVimalsoft(Pty) Ltd9-Jun-08 5:02 
GeneralRe: How to execute an SQL statement from a DataSet? Pin
bouli9-Jun-08 5:17
bouli9-Jun-08 5:17 
GeneralRe: How to execute an SQL statement from a DataSet? Pin
Vimalsoft(Pty) Ltd9-Jun-08 20:50
professionalVimalsoft(Pty) Ltd9-Jun-08 20:50 
ok,

I was showing you, if the data is already in the dataset. then your Dataset will have a name and a datatable, then from the above code.
see , you will end up with a dataset object.
Dim strFileName As String = "MyFile.csv"
Dim strPath As String = "C:\"
Dim strCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + strPath + ";Extended
Properties='text;HDR=Yes;FMT=Delimited'"
Dim con As New OleDbConnection(strCon)
Dim cmdGetCsv As New OleDbCommand("SELECT * from " +
strFileName, con)
Dim csvAdapter As New OleDbDataAdapter(cmdGetCsv)
'Dim csvReader As OleDbDataReader
con.Open()

Dim dsCsv As DataSet = New DataSet

csvAdapter.Fill(dsCsv)


you can change your Select statement to your liking.

Hopr this Helps

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za


QuestionConnecting to DB from a Web Service Pin
zaboboa9-Jun-08 2:21
zaboboa9-Jun-08 2:21 
AnswerRe: Connecting to DB from a Web Service Pin
Colin Angus Mackay9-Jun-08 2:28
Colin Angus Mackay9-Jun-08 2:28 
GeneralRe: Connecting to DB from a Web Service [modified] Pin
zaboboa9-Jun-08 2:35
zaboboa9-Jun-08 2:35 
AnswerRe: Connecting to DB from a Web Service Pin
Vimalsoft(Pty) Ltd9-Jun-08 4:07
professionalVimalsoft(Pty) Ltd9-Jun-08 4:07 
GeneralRe: Connecting to DB from a Web Service Pin
zaboboa9-Jun-08 4:21
zaboboa9-Jun-08 4:21 
GeneralRe: Connecting to DB from a Web Service Pin
Vimalsoft(Pty) Ltd9-Jun-08 4:36
professionalVimalsoft(Pty) Ltd9-Jun-08 4:36 
GeneralRe: Connecting to DB from a Web Service Pin
zaboboa9-Jun-08 5:43
zaboboa9-Jun-08 5:43 
GeneralRe: Connecting to DB from a Web Service Pin
Vimalsoft(Pty) Ltd9-Jun-08 20:30
professionalVimalsoft(Pty) Ltd9-Jun-08 20:30 
Questionhow to use TextEffectFormat from Microsoft.Office.Interop.Word ? Pin
combo_ci9-Jun-08 1:51
combo_ci9-Jun-08 1:51 
QuestionNeed to call a function in C# just before ComboBox SelectedIndexChanged event Pin
Madandu9-Jun-08 1:31
Madandu9-Jun-08 1:31 
AnswerRe: Need to call a function in C# just before ComboBox SelectedIndexChanged event Pin
Colin Angus Mackay9-Jun-08 2:30
Colin Angus Mackay9-Jun-08 2:30 
AnswerRe: Need to call a function in C# just before ComboBox SelectedIndexChanged event Pin
Eslam Afifi9-Jun-08 3:40
Eslam Afifi9-Jun-08 3:40 
Questionhow i can show meesagebox LIke msn on Notification Icon Pin
wasimsharp9-Jun-08 1:19
wasimsharp9-Jun-08 1:19 
AnswerRe: how i can show meesagebox LIke msn on Notification Icon Pin
Syed Ali Raza9-Jun-08 2:47
Syed Ali Raza9-Jun-08 2:47 
GeneralRe: how i can show meesagebox LIke msn on Notification Icon Pin
Syed Ali Raza9-Jun-08 2:50
Syed Ali Raza9-Jun-08 2:50 
Answerfor Win Application Pin
Syed Ali Raza9-Jun-08 3:23
Syed Ali Raza9-Jun-08 3:23 
QuestionDeployment C# 2008 Express Edition windows project Pin
vishnukamath9-Jun-08 0:46
vishnukamath9-Jun-08 0:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.