|
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.
|
|
|
|
|
Hello,
I'm new to database programming. I'm currently reading Pro ADO.NET 2.0 from Apress. The book has been great so far, but when he get's to his first example, he supplies a script file to set up a simple data source. So, i have this .sql file that i don't know what to do with. when I double click it, it just opens in notepad. Yes, i'm a doofus. please help me! 
I'm running a local instance of sql server 2005 standard.
thanks!
Ian
|
|
|
|
|
Hi Ian. If you're running Sql Server 2005, you should have access to the Query Analyzer program, yes? Open the .sql file in Query Analyzer, then execute it (F5 will do it)
|
|
|
|
|
i can't find the query analyzer. I'm going to reinstall and give that a shot. Thanks!
Ian
|
|
|
|
|
SQL Server 2005 does not come with Query Analyser. That was a feature of SQL Server 2000.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
 My mistake. 
Thanks Colin.
|
|
|
|
|
Open Microsoft SQL Server Management Studio
Connect to the SQL Server
In the tree on the left open the databases folder
Right click on the database you want to query and select New Query...
In the main pane you can now type SQL. You can execute the SQL by pressing F5 or using the Execute button.
Does this help?
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
