Visual Basic

FirstPrevNext

Re: Read MS Access Table to Text file _mubashir22-Apr-07 9:16 _mubashir 22-Apr-07 9:16  You have to write your own parser for this. Fetch records from your access DB and insert them line by line in a Text file. See THIS for how to read/write data into a text file Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it. Re: Read MS Access Table to Text file IvanIT23-Apr-07 6:35 IvanIT 23-Apr-07 6:35  Thanks Mubashir. I though that would be it, but I wondered if anyone already had some code scenarios that i could modify. Re: Read MS Access Table to Text file Dave Kreskowiak23-Apr-07 6:55 Dave Kreskowiak 23-Apr-07 6:55  That's not how this site works. We'll help you write your own code, we won't write it for you. Why?? Because you wouldn't learn anything if we did the work. Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Read MS Access Table to Text file IvanIT23-Apr-07 14:56 IvanIT 23-Apr-07 14:56  Thanks for the input and patience. Through trial and error, I am now in an advances stage of writing a custom parser (using the WriteLine method). Appreciate the help. Minimize form eagertolearn22-Apr-07 7:17 eagertolearn 22-Apr-07 7:17  Hello all, I was just wondering if there is any way to make a form to minimize to the windows toolbar (the one with clock). So, when minimized there will be an icon of the application next to the clock (bottom right) that is when i right click on it, there will be a menu showing. Thanks Re: Minimize form kubben22-Apr-07 9:06 kubben 22-Apr-07 9:06  I have written an article on this: http://www.codeproject.com/dotnet/notifyiconcontrol20.asp[^] Hope that helps. Ben Re: Minimize form eagertolearn23-Apr-07 6:03 eagertolearn 23-Apr-07 6:03  Thanks Kubben How To compare data in array A and array B somchoto22-Apr-07 2:43 somchoto 22-Apr-07 2:43  How To compare data in array A and array B Re: How To compare data in array A and array B Arun.Immanuel22-Apr-07 4:29 Arun.Immanuel 22-Apr-07 4:29  Do U need this? Using simple for loop we can achieve this. flag=true for i=0 to n if a(i) not equal to b(i) then flag=false next if flag = false then the arrays are not equal. If U want something else other than this, U will have to elaborate so that everyone can understand what U really need. Regards, Arun Kumar.A Re: How To compare data in array A and array B somchoto22-Apr-07 5:05 somchoto 22-Apr-07 5:05  Thank You Please help me in Crystal report pnrad22-Apr-07 0:59 pnrad 22-Apr-07 0:59  How to use crystal report Engine 10 in vb.net and open my *.rpt so i don't like using crviewer in .net for opening my report help me ahmadi Re: Please help me in Crystal report klaydze22-Apr-07 19:42 klaydze 22-Apr-07 19:42  hi, so where do you want you to view your report if you don't like to use crviewer? Don't block the drive way of all the newbies in programming. Text Color Anybloodyid22-Apr-07 0:04 Anybloodyid 22-Apr-07 0:04  I want the user to be able to choose the colours of the title, score, lives etc I thought if I have a text file in the folder with the colours, Red Yellow Blue How do I then transfer it to the project? Title.color = text line one Score.color = text line two Lives.color = text line three Re: Text Color Christian Graus22-Apr-07 0:22 Christian Graus 22-Apr-07 0:22  If you accept words, you may be able to use reflection if they are colors in the enum the framework provides. Otherwise, you need a lookup table to establish what "Red" means, if it's Colors.Red, or if it's 0XFF0000, or whatevr. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) How to use a variable value in a SELECT statement keninfo21-Apr-07 23:46 keninfo 21-Apr-07 23:46  Hello all, Does anyone know how to use variable values in SELECT statements? Thanks Re: How to use a variable value in a SELECT statement Christian Graus21-Apr-07 23:57 Christian Graus 21-Apr-07 23:57  The obvious way is to concatenate strings. The better way is to write a stored procedure. Either way, you need to be careful of SQL injection attacks. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) datagrid nilam1121-Apr-07 22:41 nilam11 21-Apr-07 22:41  hello i have generated one datagrid using dataset having columns user_id,initial,passwd,access etc. From these i am displaying only 3 columns my query is - select user_id as user,user_init as inital,user_nm as name from user_mast but i am facing one problem i.e. after adding new record in dataset my datagrid is displaying all columns including passwd also which is not to be shown. Pliz. guide me how i solve this problem? thanks reply immediate thanks Re: datagrid mghiassi22-Apr-07 0:25 mghiassi 22-Apr-07 0:25  Hi, You should set AutoGenerateColumn to False Re: datagrid klaydze22-Apr-07 16:23 klaydze 22-Apr-07 16:23  hi, try to insert a query again using select statement after you add your record. to show specific column you want to show. Don't block the drive way of all the newbies in programming. Adding a column to an existing SQL database table furjaw21-Apr-07 20:28 furjaw 21-Apr-07 20:28  Visual Basic 2005 I used DataSet Designer to add a column called "Case#" to an existing SQL table. The table is used by a DataGridView in a VB 2005 program. I got it working on my development computer in debug mode. Then, when I installed it, I got an exception "Case# is an invalid column" and none of my data records appeared. Adding the following statement did not help: PatientDataSet.Patient.Columns.Add("Case#") Re: Adding a column to an existing SQL database table Christian Graus22-Apr-07 0:00 Christian Graus 22-Apr-07 0:00  You asked this three times.... If you have a grid, you can add columns to it, this will not change your database, but just the data you have in memory. I'm not sure if you can run SQL to add a column within your code. I'd certainly be asking why you'd do such a thing, instead of fixing your SQL and making your schema established and solid. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) Re: Adding a column to an existing SQL database table furjaw22-Apr-07 5:20 furjaw 22-Apr-07 5:20  I have a commercial application with a number of customers running it. I need to add a column to one of the SQL tables. So, I have to do it within my code. Re: Adding a column to an existing SQL database table Christian Graus22-Apr-07 12:08 Christian Graus 22-Apr-07 12:08  OK, try writing the SQL to alter the table and running it from code. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) Re: Adding a column to an existing SQL database table furjaw22-Apr-07 17:28 furjaw 22-Apr-07 17:28  I have a number of users running this application in remote locations. Of course, they cannot lose their existing data. It was requested that I include a column called "CaseNbr" in the table. The file that I need to add the column to is an SQL table that is being updated via a DataGridView. I think that it was a mistake to add the column via DataSet Designer, so, I restored my project from a backup eliminating that step. So, now the column does not exist in the database and I am back to square one. I would like to add the column to the SQL tables via my app so that my various users can have it added to their databases. Every user has his own database. There is only one program that accesses the table and it is very simple. The user selects (or adds) a row (Patient record) then the program simply passes that Patient's info to the main form of the application. I know nothing about SQL. There are no SQL statements in my app. Everything is done by TableAdapter and BindingSource statements like: Me.PatientTableAdapter.Fill(Me.PatientDataSet.Patient) PatientBindingSource.Position = Form1.DefaultPatient That's why I don't know how to add a column to the SQL table. Re: Adding a column to an existing SQL database table furjaw22-Apr-07 17:30 furjaw 22-Apr-07 17:30  I have a number of users running this application in remote locations. Of course, they cannot lose their existing data. It was requested that I include a column called "CaseNbr" in the table. The file that I need to add the column to is an SQL table that is being updated via a DataGridView. I think that it was a mistake to add the column via DataSet Designer, so, I restored my project from a backup eliminating that step. So, now the column does not exist in the database and I am back to square one. I would like to add the column to the SQL tables via my app so that my various users can have it added to their databases. Every user has his own database. There is only one program that accesses the table and it is very simple. The user selects (or adds) a row (Patient record) then the program simply passes that Patient's info to the main form of the application. I know nothing about SQL. There are no SQL statements in my app. Everything is done by TableAdapter and BindingSource statements like: Me.PatientTableAdapter.Fill(Me.PatientDataSet.Patient) PatientBindingSource.Position = Form1.DefaultPatient That's why I don't know how to add a column to the SQL table.

Last Visit: 31-Dec-99 18:00     Last Update: 21-May-24 16:46 Refresh ᐊ Prev1...2606260726082609261026112612261326142615 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.