DBF connection string

[David C]

I have an asp.net application that I need to connect to and read dBase IV
file format files. I have a connection string below in the web.config but I
don't think it will work because the folder where the files exist is on
another server. Can I substitute the \\server\folder in the connection
string where the c:\folder is now? Thanks.

David (web config line below)

<add name="EMSConnectionString" connectionString="Data
Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=;"
providerName="Microsoft.Jet.OLEDB.4.0;"/>

 

[David C]

I can't seem to use the DataSource wizard as my connection string I added in
the web.config does not show up as a selection. How do I assign a
DataSource for an ELEDB dBase connection? Thanks.

David

 

[David C]

dbase IV/Fox Pro dbf datasource. I want to display it in a gridview.

David

[please don't top-post]

I can't seem to use the DataSource wizard as my connection string I added
in the web.config does not show up as a selection. How do I assign a
DataSource for an ELEDB dBase connection? Thanks.

Forget about the DataSource wizard.

What type of DataSource are you trying to create...?

 

[Olaf Rabbachin]

Hi,

I have an asp.net application that I need to connect to and read dBase IV
file format files. I have a connection string below in the web.config but I
don't think it will work because the folder where the files exist is on
another server. Can I substitute the \\server\folder in the connection
string where the c:\folder is now? Thanks.

as for ConnectionStrings - check out www.connectionstrings.com.
Regarding the partwise assembly of ConnectionStrings I suggest you check
the ConnectionStringBuilder-classes; these are provider-specific, i.e.
SqlConnectionStringBuilder for SQL Server.

Cheers,
Olaf

 

[David C]

DataSet/DataTable.

p.s. What do you mean by [please don't top-post]? Thanks.

David

[please don't top-post]

Yes, but are you trying to use a DataSet / DataTable or a DataReader as
the DataSource of your GridView...?

 

[David Jackson]

p.s. What do you mean by [please don't top-post]? Thanks.

A newsgroup thread is a conversation between two or more contributors.

Typically, someone starts the thread by making a statement or asking a
question.

In your case, you started this thread by asking a question. Yours was,
therefore, post number one.

The first reply to your initial post answered your question, and gave you a
link to look at where someone else had asked a similar question. That was,
therefore, post number two.

Which is why it was posted UNDERNEATH your post, not above it. When people
have a conversation, generally speaking, they don't answer questions before
they've been asked.

Next, you replied to post number two in the thread. This post was,
therefore, number three.

However, you placed the text of your reply ABOVE the rest of the text i.e.
you top-posted it. Therefore, the text in this post was now out of order
i.e. it went post three, post one, post two.

When you top-post, you force people who have not participated in the thread
before to scroll down to the bottom of the post and read it backwards e.g.

"OK, see you then."
"About eight thirty."
"What time?"
"Under the clock at the station?"
"Sounds great! Where shall we meet?"
"How about that little Italian on the High Street?"
"I'd love to! Where shall we go?
"Shall we go out for dinner tomorrow?"

 

[David C]

Thank you. That will work.

David

DataSet/DataTable.

using System;
using System.Data;
using System.Data.OleDb;

DataSet objDS;
string strConnectionString =
System.Configuration.ConfigurationManager.ConnectionStrings["EMSConnectionString"].ConnectionString;

using (OleDbConnection objOleDbConnection = new
OleDbConnection(strConnectionString))
{
objOleDbConnection.Open();
using (OleDbCommand objOleDbCommand = new OleDbCommand(pstrSQL,
objOleDbConnection))
{
using (OleDbDataAdapter objDA = new
OleDbDataAdapter(objOleDbCommand))
{
using (DataSet objDataSet = new DataSet())
{
objDA.Fill(objDataSet);
objOleDbConnection.Close();
return (objDataSet);
}
}
}
}

MyGridView.DataSource = objDS;

p.s. What do you mean by [please don't top-post]? Thanks.

http://www.river.com/users/share/etiquette/

 

[David Jackson]

Thank you. That will work.

Do you see how you posted that line ABOVE the rest of the text instead of
UNDERNEATH it?

By doing that, you are forcing everyone to scroll right down to the bottom
of your post and then all the way back up again to make sense of what you're
saying!

 

[David C]

Is this better? How will someone know what I am responding to? Thanks.
p.s. I just click on "Reply Group" in Outlook Express and it puts me at the
top of the message I am replying to.

David

 

[David Jackson]

Is this better?

Better because you didn't top-post, but still not right.

How will someone know what I am responding to?

Exactly! You have not included *any* of the post to which you're replying in
order to provide context.

Do you see how I've included just enough of your post to provide meaning to
anyone else reading this thread? This is called snipping, and is just as
important in terms of netiquette as bottom-posting. This is especially
important as earlier posts of a thread disappear over time.

Do you also see how I've replied to your various points UNDERNEATH them
(i.e. in normal conversation order), thereby not forcing people to read this
post backwards? You are able to read this post from top to bottom without
having to keep jumping up and down in order to understand the chronology.

p.s. I just click on "Reply Group" in Outlook Express and it puts me at
the top of the message I am replying to.

There's a wonderful key combination available in Windows - Ctrl-End.

Next time you reply to a post in Outlook Express, click "Reply Group" and
then click Ctrl-End or scroll to the bottom of the post that you're replying
to.

Windows Mail in Vista now thankfully allows bottom-posting to be enabled by
default.