Database

FirstPrevNext

MessageBox mostafa_h23-Feb-06 8:43 mostafa_h 23-Feb-06 8:43  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 Re: MessageBox Felipe Dalorzo23-Feb-06 11:09 Felipe Dalorzo 23-Feb-06 11:09  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 Unable to connect to SQL DB file using SQLEXPRESS dxben23-Feb-06 6:05 dxben 23-Feb-06 6:05  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. Retrieving UNICODE data cshivaprasad23-Feb-06 5:34 cshivaprasad 23-Feb-06 5:34  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 Re: Retrieving UNICODE data Colin Angus Mackay23-Feb-06 12:35 Colin Angus Mackay 23-Feb-06 12:35  I don't know if this will help your current problem, but it is something you should do as a matter of habit. That is to use parameterised queries. SQL Injection Attacks and Tips on how to Prevent them[^]. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more? Re: Retrieving UNICODE data Divya Rathi24-Feb-06 9:36 Divya Rathi 24-Feb-06 9:36  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 download multiple files from database oga_ns23-Feb-06 0:53 oga_ns 23-Feb-06 0:53  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 Re: download multiple files from database Colin Angus Mackay23-Feb-06 12:29 Colin Angus Mackay 23-Feb-06 12:29  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? Re: download multiple files from database oga_ns23-Feb-06 22:33 oga_ns 23-Feb-06 22:33  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 How to sort Numeric Data? padma_0122-Feb-06 18:56 padma_01 22-Feb-06 18:56  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 Re: How to sort Numeric Data? Mike Ellison22-Feb-06 19:10 Mike Ellison 22-Feb-06 19:10  Hi there. Just use ORDER BY with your numeric field - SELECT * INTO TargTable FROM SourceTable ORDER BY MyNumericField How Does SQL work? (easy question, i assume) ThePmanLives22-Feb-06 18:23 ThePmanLives 22-Feb-06 18:23  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" Re: How Does SQL work? (easy question, i assume) Paul Conrad22-Feb-06 18:34 Paul Conrad 22-Feb-06 18:34  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. Re: How Does SQL work? (easy question, i assume) ThePmanLives22-Feb-06 18:44 ThePmanLives 22-Feb-06 18:44  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" Re: How Does SQL work? (easy question, i assume) Paul Conrad22-Feb-06 18:48 Paul Conrad 22-Feb-06 18:48  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 Re: How Does SQL work? (easy question, i assume) Mike Ellison22-Feb-06 19:18 Mike Ellison 22-Feb-06 19:18  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. Re: How Does SQL work? (easy question, i assume) japel22-Feb-06 22:28 japel 22-Feb-06 22:28  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. Re: How Does SQL work? (easy question, i assume) Boris van de Laarschot25-Feb-06 6:19 Boris van de Laarschot 25-Feb-06 6:19  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. How do I execute a sql script? Mundo Cani22-Feb-06 13:50 Mundo Cani 22-Feb-06 13:50  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 Re: How do I execute a sql script? Mike Ellison22-Feb-06 19:12 Mike Ellison 22-Feb-06 19:12  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) Re: How do I execute a sql script? Mundo Cani23-Feb-06 8:34 Mundo Cani 23-Feb-06 8:34  i can't find the query analyzer. I'm going to reinstall and give that a shot. Thanks! Ian Re: How do I execute a sql script? Colin Angus Mackay23-Feb-06 12:22 Colin Angus Mackay 23-Feb-06 12:22  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? Re: How do I execute a sql script? Mike Ellison23-Feb-06 13:49 Mike Ellison 23-Feb-06 13:49  My mistake. Thanks Colin. Re: How do I execute a sql script? Colin Angus Mackay23-Feb-06 12:26 Colin Angus Mackay 23-Feb-06 12:26  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? Install SQL 2K default instance over MSDE 2k default instance nnurani22-Feb-06 4:38 nnurani 22-Feb-06 4:38  The system already has a default instance of MSDE2000 installed. I would liket to upgrade this to a default instance of SQL server 2000. Is this possible without uninstalling the MSDE? The SQL installation asks me for an instance name and disables the default instance (since it already exists in MSDE)??

Last Visit: 31-Dec-99 18:00     Last Update: 22-Sep-24 10:40 Refresh ᐊ Prev1...1956195719581959196019611962196319641965 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.