clg

Are Template Columns available for use in the Windows Forms version of the DataGrid. I have seen many references to working with checkboxes and radio buttons in the datagrid but they all seem to refer to WebForms. Can someone please verify this for me or get me started on how to use template columns in WinForms Datagrid??? Thanks!

I am using a windows form DataGrid to display some records. When I initially created the datagrid, the boolean field showed up as a checkbox -- this is what I want. I added a TableStyle and GridColumStyle to make more user friendly column names -- when I did this, the boolean field now shows up as true/false -- not what I want (very hard for user to edit). There is a "format" property on the DataGridColumnStyle for the field but I'm not sure what to put there. I have tried yes/no and checkbox neither make any difference nor do they give me an error. Any suggestions will be greatly appreciated!

The program does requires lots of data updates, but no images. I have noticed that this only seems to be a problem on Windows 98 machines.

I am using an Access Database in my program. I have noticed that the file size increases very quickly after the program has been used for a short while. I can still compact the file by opening it in ACCESS, but I would like to be able to automatically compact the database each time I exit my VB.net program. When I compact using ACCESS the file size goes from 9mg to 700kb this is a substantial difference and I have no idea why it is getting so large. Anyone know why my file size would be increasing so quickly or if I can do a compact from VB.net.

I'm using a DataRow First I create a new datarow, then add values to the row, then add the row to the dataset. Next I use the CommandBuilder Insert command to update the database. Previously, when I didn't deal with that column at all, I got an error that the column can't be null. I just tried to comment out the autoincrement stuff to recreate the error, but I didn't get it this time. Maybe there was something else amiss back then. Are you saying that I don't need to deal with the autoincrement column at all in my code, only set it to autoincrement in my Access Database?

I just came upon a suggestion to set the AutoincrementSeed to -1 and the AutoIncrementStep to -1 This should make the dataset count backwards and therefore never reach my actual table values. This sounds like it might work. Any comments?

I am using an Access database with an autoincrement field. When I am writing the new records to my Dataset, I get an error saying that the field is constrained to be unique and a record with that number already exists. I have played with the autoincrement seed and deleted records enough to realize that the autoincrement number in the dataset is not the same number as the actual database (it increments properly). My problem is -- what do I do with the error? If I say "continue" the record does not get saved. Can I capture this exception somehow and still save the record?:confused:

Thanks for the info. Your solution is cleaner -- I just didn't know where to put that statement until I learned about the KEYDOWN event. Thanks again folks

Found a solution Found a solution. Put this code in the KEYDOWN event If e.KeyCode = Keys.Enter Then TextBox1.Focus() End If Textbox1 is a dummy textbox that will be invisible. The most important thing is that it will now trigger the LEAVE event and process my data whether the user has configured a TAB suffix or an ENTER suffix into his barcode scanner -- or if he just hits ENTER or TAB on the keyboard. Thanks for your interest!

Thanks, but still confused! Thanks for the reply, but I'm afraid I'm still confused! Where should I put this statement? I'll try to be more specific, I have a text box on my form whose purpose is to accept a barcode from a barcode scanner. It will accept the barcode alright but I need to leave the textbox so that I can fire the LEAVE event and process the information. If after scanning the barcode, the user hits the TAB key the event will fire. I would like to make it possible for the user to press the ENTER key to activate the LEAVE event. I can also configure my scanner to have a TAB suffix which also fires the LEAVE event. This is good, but I need to deal with many different users and different barcode scanners -- I think many barcode scanners come preconfigured with a Carriage Return suffix. If I can get the textbox to LEAVE when it encounters an ENTER then I think it will also LEAVE when it encounters the Carriage Return suffix. This would allow the user to continue scanning without stopping to touch the keyboard to hit TAB.

Can someone tell me how to configure my windows form or control so that when I press enter I navigate from control to control (like tab)?

I am new to VB.net. When I was programming in Access, I could create a form with a multicolumn listbox and give my user a sampling from all the records in a table. The user would double-click on a record activating the double-click event which I had programmed to open another form that would allow them to edit or delete the specific record. I can't figure out how to recreate this activity in VB.net. I tried using a listbox but it no longer allows multiple columns of different fields. I tried the datagrid -- I don't want my users editing the data on the grid (there are too many fields and my users are beginners) I just want to present them with a list of records to edit -- once they choose the record they want to edit, I want to offer them a new screen with all the fields available for editing. Any suggestions?

I need to implement barcodes into a database tracking type of program. I need to be able to print the barcodes on reports and labels. I also need to be able to scan the codes back into my database. I want to distribute this application to several people. Can someone recommend some tools to accomplish this? I need something that is royalty free to distribute. Thank you

Gladimir, Thanks for replying. I really don't want them to be able to access the database without my program. Does your user have to have an ACCESS license in order for you to use an ACCESS type database to develop the program??

Thank you for replying! I am creating an attendance database for a school system. In my ACCESS version of this program I had tables such as Student Information, Teacher Information, Attendance Data, etc. Basically a data entry form is presented to the user to choose a student(or scan a barcode), enter a date (or accept default date) and record attendance. The data is very simple. The real value of the program is in the many ways that data can be retrieved by the users(reports for specific purposes). It seems that maybe I should be thinking about creating a class that looks like some of my tables. Like a Student Class that has properties such as Lname, Fname, SSN, Student Number, etc. Do you know of any sample programs that show this type of approach along with accessing the data from a database and returning values to that database? I have several books on VB.Net but the ones that refer to databases don't seem to have references to classes and the ones that teach about classes don't mention databases. I am new to this and feel like I am missing something very important!

Hello, I am experienced in creating applications in ACCESS but I would now like to move on to VB.Net. I want to create a new application that will be used by many people on many different machine setups. It is a stand alone project -- no servers to deal with. I would like to know which database engine I should use -- Access, MSDE, or SQL? Thank you!