.NET (Core and Framework)

21-Jan-09 22:57

public string connection = "Provider=SQLOLEDB; Data Source=D:king.txt;Catalog=STU_ATTENDANCE;User ID=sa;Password=sa; Network Library=dbmssocn";

SqlConnection con1 = new SqlConnection(connection);

in my text file king i gave this text "veeserv3" <--(this is my data source name)

is it right...

ConnectionStrings (original topic wasn't descriptive enough.. Not that this one is, but perhaps it shows some more detail)

Abhijit Jana21-Jan-09 23:41

Abhijit Jana

21-Jan-09 23:41

Please Don't Cross Post Dead | X|

cheers,
Abhijit
CodeProject MVP
My Recent Article : Exploring Session in ASP.Net

Eddy Vluggen22-Jan-09 0:53

Eddy Vluggen

22-Jan-09 0:53

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 Smile | :)

Re: check this [modified]

Wendelius22-Jan-09 1:34

22-Jan-09 1:34

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_mca200722-Jan-09 2:01

22-Jan-09 2:01

nice gentle man u got my problem...

when i include those lines i get this error....

"File does Not exist in the current context"

Wendelius22-Jan-09 2:06

22-Jan-09 2:06

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_mca200722-Jan-09 2:28

22-Jan-09 2:28

i got this error

Could not find file 'D:\king.txt'.

but i have word file in my d:

Wendelius22-Jan-09 2:36

22-Jan-09 2:36

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_mca200722-Jan-09 2:47

22-Jan-09 2:47

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'.

Wendelius22-Jan-09 2:54

22-Jan-09 2:54

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_mca200722-Jan-09 3:17

22-Jan-09 3:17

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

Wendelius22-Jan-09 3:20

22-Jan-09 3:20

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_mca200722-Jan-09 3:24

22-Jan-09 3:24

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_mca200722-Jan-09 3:31

refresh command on datagridview

22-Jan-09 3:31

VERY VERY THANKS GENTLE MAN...

I GOT THE RESULT...

jetgrageda21-Jan-09 21:45

jetgrageda

21-Jan-09 21:45

hi. im working on a project that requires inserting, deleting values in the database.
i used the datagridview and edit on the values directly on the grid. it worked but when i try to refresh it, the new values are just appended. example, there are only 2rows in the table. when i click the refresh button, 2rows are appended making it 4 rows of the same value. please help.. need it badly..
another thing is that when i change the name for the data table, directly updating on the datagrid is impossible.

Re: refresh command on datagridview

Wendelius22-Jan-09 1:37

Re: refresh command on datagridview

22-Jan-09 1:37

Sounds like there are some problems in your bindings from the datatable to the datagridview. But without seeing your code, it's hard to say more.

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

jetgrageda22-Jan-09 5:36

jetgrageda

22-Jan-09 5:36

thanx for the reply..
Dim listquery1 As String
If conn.State = ConnectionState.Open Then conn.Close()

Try
conn.Open()
If cboSubj.SelectedItem.ToString = "ICSM310" And cboSec.SelectedItem.ToString = "Z14" Then

listquery1 = "Select *from sampleList;"
Dim mycmd As New MySqlCommand(listquery1, conn)
mycmd.ExecuteNonQuery()

adptr.SelectCommand = mycmd
adptr.Fill(dtable)

DataGridView1.DataSource = dtable
DataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells
Else
MsgBox("No list ")

End If

Catch ex As Exception
MsgBox(ex.Message)
End Try
conn.Close()
this is the first instance for loading the values in the datagrid...
for the "refresh" command
Dim listquery As String
If conn.State = ConnectionState.Open Then conn.Close()

Try
conn.Open()

Try
listquery = "Select *from sampleList;"
Dim mycmd As New MySqlCommand(listquery, conn)
mycmd.ExecuteNonQuery()

adptr.SelectCommand = mycmd
adptr.Fill(dtable)

statusView.DataSource = dtable
statusView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells

Catch myerror As MySqlException
MsgBox("There was an error reading from the database: " & myerror.Message)
End Try
Catch myerror As MySqlException
MessageBox.Show("Error connecting to the database: " & myerror.Message)
Finally
If conn.State <> ConnectionState.Closed Then conn.Close()
End Try
End Sub
note that statusView is datagridview

for the mysql adapter and datatable, i declare it at the very beginning of the code..
for me to use the command builder command...

Re: refresh command on datagridview

Wendelius22-Jan-09 5:47