datagridview

ok, guys, I have a SQL database with a column called "Date" but with a format of "nchar(8)" so examples of field data are... 12112012 01012013 02022013 etc... In VB i have a DGV that is databound to this sql table. So, my second column in the DGV is the same as what i have explained above...

i have a bound datagridview populated with data and 1 button(named - preview), now my goal is , whenever the user click the preview button, all the data in the datagridview will be displayed in the crystal report,(with the same format)., thanks in advance

i have 2 datagridviews, what i want to achieve is whenever the user clicks a row(selectionmode = fullrowselect) in dgv1 the same row will also be selected in dgv2(selectionmode = fullrowselect) , the same goes when the user clicks on dgv2., thanks in advance :D

i have 2 datagridview, now i want to perform a input validation in each cell to know if the dgv2 value is greater than the dgv1 value i used the ff code., and ofcourse it didnt work XD Private Sub DataGridViewMC1_RIS_ISSUANCE_CellLeave(ByVal sender As System.Object, ByVal e As...

Hey guys, I'm new to the forum, so thanks in advance for your time and help!! I will do my best to explain my situation... I have two SQL Tables and am using VB to represent a user interface for adding/editing this data... Below are screenshots of my two tables tblCollection =========== and...

Hi, I am trying to update a database table via a datagridview. I can successfully populate the grid with data from the table, but when I try to call the update function I get a Syntax error. Based on the error I think I am somehow not linking the datagridview columns to the SQL Update...

This is the 3rd chapter of my new vb.net2010 working with database book, but i wanted to post it here as it covers most wanted points of working with DataGridView control beside working with database. In this chapter i shall discuss these points ...

I've written some code which attempts to hide all rows in to a bound datagridview (dvg1) which share values in a column called sch_id with rows in an unbound datagridview (dvg2). It works for drag operations, the dragged rows are hidden once they are dropped to dvg2. When a sort action is...

Hi, I want to add a ComboBox at Cell Level in DataGrid. i. e. There is one Static ComboBox(Suppose A) in a Cell of DataGrid, upon Selecting a value of that Combo Box, there on Next cell a ComboBox(Suppose B) will generate dynamically. My Problem is that, on first Row of Grid B ComboBox Value...

Hi all I have a vb.net project that connects to a sql database. I have a form that contains a datagridview for the database. The database itself contains many different columns (e.g. customer name, serial number, cust phone number, current status) I am concerned about the current status column...

I apologize to the forum if parts of this were posted earlier but I cannot get the problem resolved so I have put a very detailed post here. Any help would be most appreciated. To summarize, I have a datagridview that is fed its initial data via a text file that is read in to populate the...

I have a winforms app that I wrote on a Windows 7 box. It uses a double buffering for speed, gradient that it paints on the back of a tabpage, lots of DataGridView, and some rectangles (solid filed) for display. When the app runs on a Windows Vista or Windows 7 box it runs fine, but running on...

I have a form which the datagridview will be built manually by reading in certain data from a text file (this is because the data in the text file will change periodically) The code is correctly adding the proper amount of rows but it is NOT putting the required values in the cells. Any...

Hi all! I am a beginner in vb.net. I create a window form with a dataGridview in it. There are two columns , say X-value and Y-Value columns. I want to input values in each cell and then find the sum or average of each column. I don't know how to do this. Please help me with a simple and...

before posting i searched in google and youtube. but still i cant figure it out. maybe someone can simplify it to me.. i watched a video from youtube http://www.youtube.com/watch?v=h6PYx2MgOCQ but i cant figure out why.. some properties arent showing in my vb just like the one needed in the...

I need some help here. I have a form that populates two tables (countries and states). Country Primary key is Identity. State PK is Country PK + state PK (not identity and entered by the user) I want one form to allow the user to add or modify countries and states. My form has a textbox, a...

Hi all, Hope you can help me with this silly question: In my application I have bound a datagridview to a SQL2005 bindingsource. I really had to change a database field (more length allowed) and now de DGV displays red exclamation marks and states: 'Colomn 'password' exceeds the MaxLength...

hello I'm new here and I hope to be helped on this problem I have a windows form with 8 textboxes, 3 datagridview (dgw1, dgw2, dgw3) and a picturebox When entering the data, I have to click out of the current DataGridview3 (lose focus) to select a picturebox. After two clicks I need to go...

Hi! I am new to .NET and been reading these forums in order to learn about it. So far, I must admit that I learned a lot. Hope to be able to share some knowledge in the future! I have a question now, that I am unable to answer to myself. I have a datagridview bound to my access DB (once I'm...

Hi, I have a dictionary (created using DictionaryBase) where the values are 'PostItems'. I want to display the 'PostItems' stored in the dictionary to a datagridview. Each 'PostItem' object contains various simple properties (strings, integers and dates), a 'Contact' object and a dictionary...