|
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...
|
|
|
|
|
Please Don't Cross Post 
|
|
|
|
|
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;
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 
|
|
|
|
|
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";
modified on Thursday, January 22, 2009 12:15 PM
|
|
|
|
|
nice gentle man u got my problem...
when i include those lines i get this error....
"File does Not exist in the current context"
|
|
|
|
|
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.
|
|
|
|
|
i got this error
Could not find file 'D:\king.txt'.
but i have word file in my d:
|
|
|
|
|
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 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'.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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..
|
|
|
|
|
VERY VERY THANKS GENTLE MAN...
I GOT THE RESULT...
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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...
|
|
|
|
|
Few observations:
jetgrageda wrote: mycmd.ExecuteNonQuery()
That should be unnecessary.
Before fill, you could call dtable.Clear()
|
|
|
|
|
thanx.. datatable.clear before fill works..
i owe you..thanx so much..
|
|
|
|
|
You're welcome 
|
|
|
|
|
this is my connection string...
SqlConnection objCon = new SqlConnection("Data Source=VEESERV4;Initial Catalog=DemoInven;User ID=sa;Password=sa");
i give data source = veeserv4...
instead of this i have to give one word file their...
and the corresponding text in that word file is taken as data source name...
how can i do this...
|
|
|
|
|
kulandaivel_mca2007 wrote: instead of this i have to give one word file their...
and the corresponding text in that word file is taken as data source name...
Why ??
|
|
|
|
|
projects are submitted in exe file format...
so he(client) not able to change datasource name...
if the datasource name taken from word file...
he can change easily..
|
|
|
|
|
|
Try this
SqlConnection objCon = New SqlConnection(ConfigurationManager.ConnectionStrings["VEESERV4"].ConnectionString)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
