check this

[Lost User]

I don't know if you can treat an arbitrary text as a database. A CSV-text, no problems. It kinda depends on the format of your textfile. Can you show us a small excerpt (5 lines), including escape-characters? Anyway, if you want to verify that your connection-string works and can connect to the datastore, invoke the function described below;

/// Used to determine whether we can connect to a db-instance as provided
/// By a connectionstring.
internal bool TryConnectToSqlInstance(string connectionString)
{
using (SqlConnection con = new SqlConnection(connectionString))
try
{
con.Open();
}
catch (SqlException ex)
{
MessageBox.Show(String.Format("{0}\n\nConnection string: '{1}'", Message, connectionString}
Application.ProductName,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
while (con.State == ConnectionState.Connecting)
Application.DoEvents();
if (con.State == ConnectionState.Open)
MessageBox.Show("Connection Succeeded!",
Application.ProductName,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}

You might also be interested in this[^] link, where you can find various connectionstrings for almost every database.

I are troll :)

[Wendelius]

No, you cannot refer to the contents of the text file as the data source. Use config file or read the text from the textfile, for example using File.ReadAllLines[^] amd then place the contents to your connection string. Something like:

string[] datasource = File.ReadAllLines("D:\\king.txt");
string connection = "Provider=SQLOLEDB; Data Source="
+ datasource[0]
+ ";Catalog=STU_ATTENDANCE;User ID=sa;Password=sa; Network Library=dbmssocn";

The need to optimize rises from a bad design.My articles[^]

modified on Thursday, January 22, 2009 12:15 PM

[kulandaivel_mca2007]

nice gentle man u got my problem... when i include those lines i get this error.... "File does Not exist in the current context"

[Wendelius]

File class is under System.IO namespace, so you can refer to it like System.IO.File.ReadAllLines(... or add using System.IO directive to your file.

The need to optimize rises from a bad design.My articles[^]

[kulandaivel_mca2007]

i got this error Could not find file 'D:\king.txt'. but i have word file in my d:

[Wendelius]

As the message says, the file cannot be opened. Re-chek the path and the name and if another application is having that file open, close the other application first.

The need to optimize rises from a bad design.My articles[^]

[kulandaivel_mca2007]

the file did not open any where in my project... i gave like this... string[] datasource = File.ReadAllLines("D:\\king.txt"); Could not find file 'D:\king.txt'. if i give like this.... string[] datasource = File.ReadAllLines("D:\king.txt"); Error 1 Unrecognized escape sequence //occurs i gave like this... string[] datasource = File.ReadAllLines("D:king.txt"); Could not find file 'D:\king.txt'.

[Wendelius]

The problem isn't in your code, but the code cannot open the file from the operating system. Check (for example using windows explorer) that: - the file is on drive D and in the root directory - the file is named king.txt - you have privileges to open the file - the file isn't open in any program, for example in Microsoft Word etc.

The need to optimize rises from a bad design.My articles[^]

[kulandaivel_mca2007]

file read successfully but.. reading in this manner ::ࡱ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0>\0\0\t\0\0\0ࡱ\0\0\0\0\0\0\0\0\0\0\0\0\0

[Wendelius]

Are you sure it's a plain text file and not for example in Word format? Open it using notepad. It should answer that question. File-class reads the text as plain text. If the file contains some other format, File class is unable to "translate" it to text.

The need to optimize rises from a bad design.My articles[^]

[kulandaivel_mca2007]

i typed "veeserv3" in that word doc... it is not empty... "Format of the initialization string does not conform to specification starting at index 0." this error also occured..

[kulandaivel_mca2007]

VERY VERY THANKS GENTLE MAN... I GOT THE RESULT...