C#

FirstPrevNext

Re: Two Access database questions Luis Alonso Ramos22-Aug-02 12:37 Luis Alonso Ramos 22-Aug-02 12:37  And creating the database? I did it through Access... well, maybe create an empty Access database with all the structure and call the upsizing wizard on that machine. -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Two Access database questions David Stone22-Aug-02 12:47 David Stone 22-Aug-02 12:47  You would need the SQL Client tools in order to do that. You can connect with VS.NET or you could connect via a local installation of SQL Server. I'm not sure if you have either, but it can be done that way. The Upsizing Wizard is fine. It does an OK job, but as the motto goes: "Never upgrade. Do a clean install." David Stone It seemed similar to someone saying, "Would you like to meet my knife collection?" Ryan Johnston on Elaine's sig Re: Two Access database questions Luis Alonso Ramos22-Aug-02 16:31 Luis Alonso Ramos 22-Aug-02 16:31  I think I'll use the upsizing wizard. I can use Access to export current tables to a database (just the design) and then use the upsizing wizard to put them back on another SQL server. -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Two Access database questions James T. Johnson22-Aug-02 12:50 James T. Johnson 22-Aug-02 12:50  You can create it via a T-SQL script. CREATE DATABASE MyDatabase USE MyDatabase CREATE TABLE yadda.... You can execute the T-SQL script by putting it into a string object and executing it via a SqlCommand object. Or put it in a file and run the osql command. Either can be done from within a setup program. James "And we are all men; apart from the females." - Colin Davies Re: Two Access database questions David Stone22-Aug-02 12:59 David Stone 22-Aug-02 12:59  Yes, but it's so much nicer to do it visually isn't it? David Stone It seemed similar to someone saying, "Would you like to meet my knife collection?" Ryan Johnston on Elaine's sig Re: Two Access database questions James T. Johnson22-Aug-02 13:12 James T. Johnson 22-Aug-02 13:12  I can go either way I prefer having the scripts so that if I need to recreate the database I can do it without a problem; plus it makes installation a breeze no matter what version of SQL Server I'm using (so long as I don't use any features not found in earlier versions). But getting the initial design is generally done quicker by using the visual tools. James "And we are all men; apart from the females." - Colin Davies Re: Two Access database questions leppie22-Aug-02 6:32 leppie 22-Aug-02 6:32  I havent worked with this for a while, but you dont state what version of Access you are try to downgrade to. If you are using Access2002 I would recommend setting the to ANSI-92 instead of ANSI-89. It solved alot of headaches for me. Hope this helps MYrc : A .NET IRC client with C# Plugin Capabilities. See http://sourceforge.net/projects/myrc for more info. Re: Two Access database questions Luis Alonso Ramos22-Aug-02 7:06 Luis Alonso Ramos 22-Aug-02 7:06  I'm using Access XP (2002) but my customer can also use Access 2000. But AFAIK, they both use the same format. My Access XP database says in the title bar (Access 2000 Format), and I just created it on XP. How do I set the ANSI-92 standard? -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Two Access database questions David Stone22-Aug-02 7:16 David Stone 22-Aug-02 7:16  They don't use the same standard. Open an Access database. Go to Tools->Options->Advanced(Tab)->Default File Format(Group Box) There you can change the format from 2002 to 2000 or back. As for the ANSI 92 standard, I believe he means to go to the Tables\Queries Tab and then to the SQL Server Compatible Syntax group box. David Stone It seemed similar to someone saying, "Would you like to meet my knife collection?" Ryan Johnston on Elaine's sig Re: Two Access database questions Luis Alonso Ramos22-Aug-02 8:00 Luis Alonso Ramos 22-Aug-02 8:00  I changed the standard (not the format) and nothing seemed to change. The problem was I was using reserved words (Date, Time, Password, Year, etc.) in several tables. Thanks for the tip! -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Two Access database questions David Stone22-Aug-02 8:05 David Stone 22-Aug-02 8:05  No problem. I used to have a nice pretty chart of Access' reserved keywords up on my wall. I know most of them. David Stone It seemed similar to someone saying, "Would you like to meet my knife collection?" Ryan Johnston on Elaine's sig Re: Two Access database questions Carlos Antollini22-Aug-02 8:10 Carlos Antollini 22-Aug-02 8:10  Because Password is a Reserved Word... When you make a query with reserverd words, you need to use those words into brakets... Regards Carlos Antollini. Sonork ID 100.10529 cantollini Casting Problem Nnamdi Onyeyiri22-Aug-02 6:06 Nnamdi Onyeyiri 22-Aug-02 6:06  The ListBox class' Item collection stores items of type object. I have stored a struct in there, at a certain point, i need to change the information in the struct, but when i do this [shown below] the compiler gives the error The Left hand side of an assignment must be a variable, property or indexer. ((EBulletListItem)this.Items[index]).Checked = true; Email: theeclypse@hotmail.com   URL: http://www.onyeyiri.co.uk "All programmers are playwrights and all computers are lousy actors." Re: Casting Problem leppie22-Aug-02 6:23 leppie 22-Aug-02 6:23  Dont use a struct, use a class! struct by Value, class by Ref. use structs to pass groups of values and use a class to store them Also, something looks fishy, what are u trying to do? I think I see. Try doing a cast first, then set the property... MYrc : A .NET IRC client with C# Plugin Capabilities. See http://sourceforge.net/projects/myrc for more info. Need for a Grid in C# Luis Alonso Ramos22-Aug-02 4:49 Luis Alonso Ramos 22-Aug-02 4:49  Hello, I need a control where I can edit the first two columns, so a grid control like Chris Maunder's or MS FlexGrid would be great. I don't have that much time as to write one of my own, so I'd like to see if someone already has one that would like to share. I need it because I'm writing a POS application and need the user to specify the product code in one column and quantity in the second. The third will display the description and the fourth the price (non-editables). Any other ideas? I think the grid is the easiest for the user, isn't it? -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Need for a Grid in C# Nnamdi Onyeyiri22-Aug-02 6:02 Nnamdi Onyeyiri 22-Aug-02 6:02  can you use the ListView control? Email: theeclypse@hotmail.com   URL: http://www.onyeyiri.co.uk "All programmers are playwrights and all computers are lousy actors." Re: Need for a Grid in C# Luis Alonso Ramos22-Aug-02 6:22 Luis Alonso Ramos 22-Aug-02 6:22  No, because I need to edit the first two columns (product code and quantity). I also thought about it, and I could create an edit control on top of the item, but off the top of my mind, I can't think about a property to get the rectangle of a column and row. But it could work... any ideas? -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Need for a Grid in C# Nnamdi Onyeyiri22-Aug-02 6:51 Nnamdi Onyeyiri 22-Aug-02 6:51  GetItemRect() maybe ? Email: theeclypse@hotmail.com   URL: http://www.onyeyiri.co.uk "All programmers are playwrights and all computers are lousy actors." Re: Need for a Grid in C# Luis Alonso Ramos22-Aug-02 7:16 Luis Alonso Ramos 22-Aug-02 7:16  No, that won't make it. It does not return the rectangle of one of the columns... but wait, I have the column widht... maybe I can calculate it on my own. Let me think about it, it could be a possible solution. But looking at the Xceed Grid control, it looks awesome! -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Need for a Grid in C# James T. Johnson22-Aug-02 6:31 James T. Johnson 22-Aug-02 6:31  I've been beta testing Xceed's new grid control; so far I haven't had any major problems with it. Here is the site for the grid[^] and Xceed has a good deal on their Ultimate Suite[^], $350 nets you all of Xceed's products plus anything that comes out for a year. James "And we are all men; apart from the females." - Colin Davies Re: Need for a Grid in C# Luis Alonso Ramos22-Aug-02 7:25 Luis Alonso Ramos 22-Aug-02 7:25  James T. Johnson wrote: I've been beta testing Xceed's new grid control; I just downloaded it... from the web page, it looks cool! -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Need for a Grid in C# Stephane Rodriguez.22-Aug-02 7:15 Stephane Rodriguez. 22-Aug-02 7:15  Ever thought about the .Net datagrid component? In .Net samples, the datagrid is always attached to an IDataSet, but heck you have a method allowing you to do : cell(x,y) = value. And even turn a given cell in edit mode. So what else do you need ? Here is the link to the MSDN doc, And I swallow a small raisin. Re: Need for a Grid in C# Luis Alonso Ramos22-Aug-02 7:24 Luis Alonso Ramos 22-Aug-02 7:24  Yeah, I once took a look into it but it seemed to complicated for me, mainly because it has to be attached to an IDataSet as you said. But I will look into it again. Maybe I can build an in-memory dataset and get its data when the sale is about to be registered. I'll take a look... -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein Re: Need for a Grid in C# Stephane Rodriguez.22-Aug-02 8:14 Stephane Rodriguez. 22-Aug-02 8:14  Read my post again Luis. I have never said a datagrid must be attached to a IDataSet, And I swallow a small raisin. Re: Need for a Grid in C# Luis Alonso Ramos22-Aug-02 8:30 Luis Alonso Ramos 22-Aug-02 8:30  I had that idea from the docs... I briefly tried using it the other day and it caused exceptions when I modified the data (I think, I don't quite well remember) -- LuisR ──────────────   Luis Alonso Ramos   Chihuahua, Mexico   www.luisalonsoramos.com "Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein

Last Visit: 31-Dec-99 18:00     Last Update: 7-Jun-24 5:15 Refresh ᐊ Prev1...15087150881508915090150911509215093150941509515096 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.