how to make the datagridview read only as i noticed that when i display a datagridview with the data, it can be edited. How can I just display the data from the database. I use datagridview is to show the data that get from the database, am I right?Hope that anyone could help me on is there any way to display the data that frm the database beside datagridview?
View 10 RepliesIs there a way to make a DataGridView's column a combo ONLY in the "new row", and a read only textbox in all other rows? I want the user to be able to make a selection from the combo box, and when the row is finished and the "new row" moves down one, I want the column to become a textbox containing the what the user selected. My grid will be bound to a table witch contains a "category" column, that is drawn from a seccond table that i want the combo box bound to.
View 1 RepliesI am using VS2008 and I have a form which has a datagridview. This is for an invoice where I already have the user select the customer from a details view and want to have the items in the datagridview change based on what the customer selected. Then when the item is selected I want to have the price change accordingly.
So far I have the customer selction as well as the item combobox(not limited to cust items yet) appear, but I cannot figure out how to get the join of the 2 items (cust+item as the price varies from cust to cust) to change the price. Question is, is it possible to do this in the same datagridview, or should i try to just break this down some other way?
Is there any way to retrieve data from certain cells of a Datagridview?
View 3 Repliesi need to read a CSV (txt) file that has no header and has 4 fields (all numeric), the number of lines will vary. [Code] I want to read this file into a DataGridView for proofing and later insert all these lines into an Access db with 2 additional fields added. I've been able to access, read/populate the CSV file into the Grid (code below) but I have the following problem(s): If I set the 4 column headers and other parms of the Grid at design; my sub inserts 4 more columns when it reads/populates the Grid. OR If I don't set the Headers and Parms, it reads the first line of the CSV into the Grid as Header info. [Code]
View 9 RepliesIf suppose i am using the vb.How can i export the data from text file to datagridview.
View 1 RepliesI read a few relevant post about the procedure to create the Read function, but in my case, i would want to read the database with selected item only. Belows are the information of my form.
I have 2 DGVs and 2 buttons is my form.My 1st DGV is filled by 3 fields from my Excel Sheet: No, ProductID, and Quantity.there are 5 fields in my MsAccess Database: ProductID, Selling Price, Product Name, Selling Cost, and Supplier.My first Button is clicked to fill the 1st DGV with 3 fields.
Now my question is:
How can i compared and displayed the Selling Price and Product Name fields of the ProductID in the 2nd DGV? i.e: if only 2 ProductID is loaded, then only display the selling price and product name of that 2 ProductId only.
My application is in VS2008 coded in Vb.net.I have a datagridview which is populated from Database.I have a save button on the same form that has DatagridView.My requirement is i want that all the records that are populated in DatagridView should be saved in a certain table of the database when the user clicks save.Im done with my save and Update code.What im not able to do is,im not able to increment the counter and move to the next row of datagridView when my For loop is executing after the click of Save button.Below is my Code.
For i As Integer = 0 To DGVStudRecord.RowCount - 1
My Code for Update and Save.
Next
I need to write the xml files into datagrid view but what i need also is to write to the datagridview and next to every row , the file name from where im reading the values from xml , example if have an xml file named : AIO , i want to read the values of the xml and add a column to the datagrid view that displays the name : AIO and so on the code that reads all the xml files and display there values in the datagrid view is below :
Dim FilePath As String = FileName.Substring(0, FileName.LastIndexOf(""))
Dim meter As New Stopwatch
Try
[code]....
I have a form that loads a gridview at runtime based on users logon names which is pretty easy the data I load lives in an excel document, I want to be able to read the data from the datagrid view I loaded at runtime, like a sort of ini file my question what is the syntax to read data from a a datagridview in vb.net, the datagrid is pretty simple it has only one columm and at most it has 6 rows of different information that I need to read from it.
View 3 RepliesI am having trouble when I am running the below code. I a datagridview (DG) and it has one column that is a DataGridViewComboBoxColumn and this gets populated from a list in a database.I want to go through all the lines in the DG and add them to a SQL insert statement
Dim RN As String = "Show Cell Address"
Try
Dim tempsql As String = ""
Dim sqli As SqlCommand = sqlconn.CreateCommand
Dim Counter As Integer = 0
[Code]...
I have a class which contains the object and a collection for that object. I want to make a property readonly to external calls, but allow access to that property from the collection class. I know I can use:[code]But, I want to the PreviousRow property to actually show as "ReadOnly" in the intelisense of the calling code of client app. The above does not. The only way that I see to make it show as "ReadOnly" in the called code is to mark the whole property as ReadOnly, but the problem with this is that my collection class code can no longer access this property:[code]I tried using the "Friend" declaration, but that seems to still allow Write access to the calling code.I only want write access from within the RowCollection class.
View 9 RepliesI have a datagridview that is bound to a dataset by dragging it onto a windows form. I want one of the columns on the datagridview to be read only for existing records (rows), but I don't want it read only when the add new icon is pressed on the navigator. How can I tell when a row is being edited as opposed to being added?
View 2 RepliesI'm loopiing through a datagridview and I want to get the selected value in a combobox, not the bound column's value. (I'm putting the contents of the dgv on a Word document.)
For icounter = 0 To Me.ConversationTblDataGridView.RowCount - 1
range.Text = range.Text & Me.ConversationTblDataGridView.Rows(icounter).Cells("PersonID").Value <-- I want to change "Value" so I get the displayed value, not the person's id
range.Text = range.Text & CHR(13)
Next icounter
It will not take .DisplayMember or .SelectedItem and .Selected returns True of False. Can anyone tell me how to get the name that shows in the combo box instead of the id number?
Anyone have any have some code to make everything (or even all TextBoxes in a form) read-only all at once without having to set every control to read only individually?
View 6 RepliesI made a launcher to launch a bunch of programs, and i wanted to know if its possible to make the .exe read the /ini file to get the path.[code...]
View 4 RepliesI am working on some USB (flash drive) software which i want to make portable and always accessible on USB i know .net is not good for this because much users don't have framework installed but users who use this software have it installed and i just love VB.net :)
So what i want to do is to create a hidden partition on this USB device where software will store some info and itself. The software and data it stores is 6MB so i would also like to know the suggestions from you what size of this hidden partition can and i should make.
But:
how do i read from hidden partition through .net?
(i did never confront with this till now...) how i make hidden partition through .net?
I want this because users i working this for usually format their drives and that way they delete the software too, so hidden folder and encrypting doesn't help me in this.
I have a text file to read. The text file contain two parts. I need to find matching line in this two parts and place the matching lines in new file. In that new file i need to change the value in () from firs part and value in[] in second part. So far i can do all this things. This is a code.
Imports System.IO
Imports System.Text.RegularExpressions
Public Class Form1
[Code].....
So second line onwards the value will be X=X+2.4. Same also for second part . how should i point the green and red value and change the values. I attach mu text files here for your referance
I was hoping to find out how to make a list box only, so you can choose whats currently in the selection but you cant type / modify it but, only read and select.
View 3 RepliesI'm retrieving some norwegian letters for my application. I know that the norwegian letters has something to do with:iso-8859-1 But I have no idea how to implement it in my application.
View 5 RepliesI have several controls in a winform application that I added databindings to using code.
Dim tblWrapper As ObliqueQCAndSpliceTool.TableWrapper = New ObliqueQCAndSpliceTool.TableWrapper(tbl, idField.Name)
tblWrapper.UseCVDomains = True
[code].....
I am reading a record from a database into a datagridview.I have changed the column "ComputerAwareness" from a textbox column to a combobox column.This column is at the 21st position in the database but after changing it to a combobox in datagridview it is diplayed as the first column in the datagridview.How can I keep the position of this column same as in the database?I have googled a lot for the solution and tried all the possible ways but none seem to work.One of the ways I tried is in the code below.
Private Sub DisplayButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DisplayButton.Click
Dim cs As String = "Provider=Microsoft.ACE.OLEDB.12.0 ;Data Source=C:\Users
[Code].....
I am trying to edit (in Visual Basic Express 2008) the source code of MapWindow's CSV to Shapefile plugin url... to read directly from a datagrid view. My datagridview is successfully created with the following code in frmMain:[code]With the help of BackWoodsCoder I was able to add the datagridview column names to the X and Y combo boxes but that's where I get stuck again. The original source code appears to re-read the delimited text file instead of using existing object code.I did try the MapWindow Forum first but have had no response thus far.
View 1 RepliesWith my datagridview I have column for datetime. I used the following for format.
Mydatagrid1.Columns(3).DefaultCellStyle.Format = "dd/MM/yyyy"
But the problem is it's getting input like MM/dd/yyyy and after pressing enter it's changing to dd/mm/yyyy style. So is it possible to read input like "dd/MM/yyyy".
I've never had to work with them before, and I think I've got everything down except one big thing: I'm setting it up so that different settings have different values depending on what file is being read. I need to know how to tell vb to take a specific item in an array and make the setting equal to it. I know how to make it read the file and add each new line into the array, just need to make sure I'll have to correct method to get the item in the array to match up the setting.
View 3 RepliesI have a combo box and a datetime picker on a form that I do not want a user to be able to type in or select. I need both controls to look as if they are enabled with the default backcolor and black font color. How can I do this?
View 4 RepliesI am looking to after the user selects from a drop down to give read only access to the form( textboxes, buttons, etc).Upon the second selection the user would have read-write access and upon the third selection full access.Does anyoen have an example of how this might go ? I have the code in place which places the information in the drop down from the configuration table itself.
View 1 RepliesI also need to know how to make the same button create a folder to save a txt file in. I havnt yet figured out how to save changes made into my program, that way next time i open it, i can continue where i left off.
View 4 Repliesim trying to make a program that can read a sms received through gsm modem.im using serial port to connect to the modem and use this code...
[code]...
in the first IF statement im trying to get the index of the msg then send an AT command to read the smg in the second IF, im trying to get all the data of the msg. in the index of 1 of the array i can get the number of the sender..my problem is that i cant get the entire msg of the sms.
How can i make a VB app read a .DAT file as if i opened it in notepad.
View 13 Replies