|
How do I connect to the database called test on Localhost using C#? I can figure out the select statement code I think, but I am having no luck with me connection statements.
Thanks for the help!
|
|
|
|
|
private void SetupDataBase()<br />
{<br />
SqlConnection cnSQL = new SqlConnection("server=localhost;database=tibia;uid=root;pwd=password");<br />
<br />
try<br />
{<br />
cnSQL.Open();<br />
SqlCommand cmd = new SqlCommand("SELECT name FROM characters", cnSQL);<br />
SqlDataReader reader = cmd.ExecuteReader();<br />
while(reader.Read())<br />
{<br />
txtPlayer.Text = txtPlayer.Text + "\n" + reader["name"];<br />
}<br />
}<br />
catch(SqlException ex)<br />
{<br />
txtPlayer.Text = ex.Message;<br />
}<br />
finally<br />
{<br />
cnSQL.Close();<br />
}<br />
}
Says it caa not find the SQL Server or access is denied.
|
|
|
|
|
|
I get the following error when trying to install sql server 2005 standard:
-----------------------------------------------
SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.
-----------------------------------------------
I'm running Windows XP pro.
I'm attempting to install all the sql components simmultaneously.
I've read on http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=60606 that I need to change a setting in the Service tab of the websites properties dialog in the Internet Information Services manager, but that dialog doesn't have a "Service" tab!
Any thoughts?
Thanks!
Ian
|
|
|
|
|
hello
plz help me!
i have only one column in my database file named rnd which contain random numbers i want to read these random numbers and store in a arraylist which method i use to read a specific rang of numbers likee 500 random numbers or whatever and i also want to insert some new random numbers in this access database file. i have used oledbreader object in while loop but how i will get each row value plz tell me soon
|
|
|
|
|
Ok, I have a question for you... What?
What do you mean? what are you talking about? what database? SQL Server?
|
|
|
|
|
First of all get a good .NET book and read it. Now, looks like you were able to read one value from your table, so it should be simple to read all records. Look at the following sample code, supply right values for connection and query variables.
<br />
<br />
DataSet dataset = new DataSet();<br />
string connection = "Put connection string here";<br />
string query = "Write your SQL SELECT clause here";<br />
<br />
OleDbConnection conn = new OleDbConnection(connection);<br />
OleDbDataAdapter adapter = new OleDbDataAdapter();<br />
adapter.SelectCommand = new OleDbCommand(query, conn);<br />
adapter.Fill(dataset);<br />
<br />
Now at this point you have a "filled" DataSet. To store value in an ArrayList object
<br />
<br />
ArrayList arrList = new ArrayList();<br />
<br />
foreach (DataRow dr in dataset.Tables[0].Rows)<br />
{<br />
arrList.Add(dr[0]);<br />
}<br />
Farhan Noor Qureshi
if (this == this) thow this;
|
|
|
|
|
hi all !
I want to put "2" line Message instead of 1 line message , in this :
MessageBox.Show("this is 2 line message","Message",MessageBoxButtons.OK,MessageBoxIcon.Information);
how can it possible ?
thanks !
s_mostafa_h
-- modified at 14:47 Thursday 23rd February, 2006
|
|
|
|
|
OK I think this is a VB/C# question but I think I know what you are talking about..
You want to display a messsage in 2 lines like;
Hello
World!
If so, you message box goes like this
*------
VB
*------
MessageBox.Show("Hello" & vbLf & "World!","Message" ,MessageBoxButtons.OK,MessageBoxIcon.Information)
*------
C#;P
*------
MessageBox.Show("Hellow \n World!","Message" ,MessageBoxButtons.OK,MessageBoxIcon.Information)
Greetings
|
|
|
|
|
This morning my VS.NET 2005 crashed on me while at the same time SQLEXPRESS had thrown up (on its own) a command prompt, it was doing something to my file. So I had to kill the entire process because it was not responding.
From then on I have not been able to connect to an MDF file. I am able to create new databases on my instance of SQLEXPRESS, my TCPIP and Named Pipes are working, but whenever I try to add an MDF file it times out. In the event viewer I am getting periodic messages about my TCPIP for SQL not being valid, but I don't see how considering I am able to create new databases and the client and the service are configured on the same port.
For what its worth, the LOG file does not show SQLSERVER express listening on any ports.
|
|
|
|
|
I have a column in SQL Server with ‘nvarchar’ data type; I entered some string in Sanskrit language from enterprise manager of SQL Server. But when ever I search for that string through C# SQL command, it’s not finding. Record set containing null data.
My C# SQL Command is like this...
"SELECT SlNo FROM Noun where Word = '"+textBox1.Text+"'";
Same command is able to search English string from the same column.
I hope U understood my problem.
Can anybody please help me?
Thanks in Advance
Cheers
Shiva
|
|
|
|
|
|
when some unicode characters (like sanskrit , chinese) are entered into DB , they are encoded in sense that a character in sanskrti is converted to say "&55;" & then it is stored in db .
Divya Rathi
|
|
|
|
|
Does enyone know how to get all byte[] from records in database.
When user click on the button to give him all records in some arhive??
Some code???(C#)
Thanx
Oga
-- modified at 6:53 Thursday 23rd February, 2006
|
|
|
|
|
Perhaps if you explain more clearly what you are looking for we could help.
oga_ns wrote: Does enyone know how to get all byte[] from records in database.
What do you mean by this? Are you talking about an image or varbinary column?
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
In datatable I have field with type: "binary data", and I put into it some jpeg, doc, xls, .... files. Then I have a web form with download button, when user click it i wont to give him all files from that datatable.
I hope this explanation is better
oga
|
|
|
|
|
I need to sort numeric data in an access database table. The following command is used in my current program which sorts string values (Names of employees) but i do not know what command can I use to sort numeric data. Please help me.
I am using this currently:
SELECT * INTO TargTable FROM SourceTable ORDER BY EmpName
Regards,
padma gahlot
|
|
|
|
|
Hi there. Just use ORDER BY with your numeric field -
SELECT * INTO TargTable FROM SourceTable ORDER BY MyNumericField
|
|
|
|
|
All i want to know is, is SQL a interface like Access or is it just a server manager for databases... i downloaded SQl express and MySQL and nither had any GUI i could find unless i did something wrong. i just want a program to make databases as easily as access with more functionalty, as access can only hold 500-1000 records per file, efficently...
"Love, Life and Option Explicit"
|
|
|
|
|
SQL Express and MySQL are database servers. You have to use tools like SQL Server Management Studio Express to have any kind of gui similar to Access. MySQL has tools like MySQL Tools which help build databases, queries, etc. If you are looking for something like Access Forms, then you have to program a front-end in VB or C#.
ThePmanLives wrote: access can only hold 500-1000 records per file
Are you sure? Because I have a client who has 130,000+ records per table and about 50+ tables and he insists on Access.
|
|
|
|
|
I guessed as much, by the interface, just wanted to be sure i wasnt being stupid or anything. I'll look into SQL Server Management Studio Express, if not i will just use access. i have no problem with that. i use VB .net 2003. It should work fine with that.
the 500-1000 figure was given to me by a friend of mine. he may have ben referring to '97 office. I inteend to use 2000.
"Love, Life and Option Explicit"
|
|
|
|
|
My client uses Access 2000/2003 so that could be the reason. I don't know about older versions of Access.
Good luck with SQL Server Management Studio.
Paul
|
|
|
|
|
SQL is a standardized declarative language for interacting with relational database systems. It literally stands for "Structured Query Language" and was originally developed by IBM in the 70's. As of 1987, it was standardized by ANSI and ISO, and has gone through a number of revisions since.
Typically a RDBMs will have a command-line interface of some sort (if not a full blown GUI) that accepts SQL commands. You can download one for Sql Express from Microsoft here[^]. I've heard MySQL's command-line interpreter is much better than its graphical tools, but I don't know that from my own experience.
|
|
|
|
|
If you like the GUI of Access but want the power of SQL use both.
You can link Access to SQL tables and have the best of both worlds...
http://www.sqlservercentral.com/columnists/kKellenberger/accesstosqlserverlinkingtables.asp[^]
You will need a GUI to create the original SQL table, search the web there are others apart from the standard offering or you can generate tables in code.
Have fun...
When people make you see red, be thankful your not colour blind.
|
|
|
|
|
Access is an aplication.
SQL server (express) is an OLE database server. That means it is made to handle calls from other programs.
OLE = Object Linking and Embedding. A Microsoft technology which allows you to link elements from different applications within each other.
|
|
|
|