Here is my problem: I have a DataGridView and I am adding a new row. In a particular cell, I have to check that the user does not enter existing values in the related table. That is, the value of that cell must be unique. If the user enters an existing value, the application must:
- Show error message
- Clean the cell
- Put the focus again into the cell, to allow the user to enter another value.
Would you know someone do this?
I've been asked by a local window cleaner to design a small utility that can display a grid of customer data, sort them, and then export it out as a formatted .txt or rtf file.
View 1 RepliesI've been asked by a local window cleaner to design a small utility that can display a grid of customer data, sort them, and then export it out as a formatted .txt or rtf file.
View 14 RepliesI am trying to find the proper way to code a datagridview so that I transfer the cell contents to a two dimensional array.
View 3 RepliesI am sorry to keep bothering you about this damn DataGridView control ... As you might have noticed I am having a hard time with the DataGridView control ... My latest problem has to do with updating the data base file (Access) through a DataGridView control .
Up to now I have managed to successfully edit an entry in the DataGridView control and moreover to successfully update the data base file itself .
The above form and its code work fine . The problem starts when I am trying to run the code of the Update button from another form .
You see , I have another form , through which I change the contents of some of the cells in the DataGridView control (back in Form1) . What I want next is to simply update the data base file itself , just like I was doing with the button in the first form , after I manually changed the cell in the DataGridView control .Thus , on the second form I have a button with this code :
Form1.Button1_Click(Nothing, Nothing) (of course the Click event is declared public)I have also tried :
Form1.Button1.PerformClick()
but still nothing ...Although Form2 successfully changes the cells back in Form1 , the data base file itself does not get updated ...If I manually press the Update button in Form1 I once again successfully update the data base file , but I want to do the whole thing by calling the Update button from Form2 .
I have a DataGridView in which I register customer orders.
The DGV has a column "PRICE", Price must be > than 100, and I control that in this way:
Private Sub DataGridView1_CellValidating(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles DataGridView1.CellValidating
Dim newInteger As Integer
[Code].....
I have never had issues trying to input data via a webbrowser control but I am banging my head against the wall here.
Here is the html from the website I am working with:
[Code].....
I'm using visual basic 2010 and i am able to import the raw data from excel and into my datagirdview but i am unable to get the code to add the values of raw data in column 2 and 3 and show the answer in column 5. Do i need to loop it?
The entire project is in the attachment take a look at it.
This is the entire code i have now:
Imports System.Data.SqlClient
Imports System.IO
Imports System
[Code]....
I have a program for school project that has input fields for Name, Address, City, State and Zip. I need to error check so that the fields are not empty.I have used If statements that check to see if the fields are empty and shows a message box if they are but if I leave the whole form empty and click the button that activates it, all the if statements go- one by one instead of pausing for the user to input the required data.How do I check for data and make the program stay there until the data is input? I have tried TRY/CATCH but it won't catch this type of error.
this is the
'This program computes customer's bills at the pizza shop for all combinations of
'crusts, toppings, sizes and discounts
Option Strict On
Public Class PizzaForm
[code].....
I am looking for a nice menu control to add some styling to my application. I search the forums and codeplex and codeproject. I found one that is nice..[URL] but I need to be able to embed a textbox for some input.
View 2 RepliesI created Dataentry forms. In the form there are so many controls like DropDowns and textboxes. I am using Access database. Now I enterd the few records into the controls, and these records are saved into the Database. But now if i enter the any data which i recently saved in the database to the textbox or any other control then the remaining controls should be display the related data.
For example i have 4 controls in my form one is dropdown and 3 are textboxes. If i select the data in the dropdown then the remaining 3 textboxes shows the related data. How can i dispaly the corresponding data to the other controls?
I have two datagridview's both are databound. First one shows items for sale and the second stores all the items that were sold. I am trying too transfer selected rows from one to the other but no matter what I keep getting told "Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound."
View 2 Repliesim creating a simple program where the user inputs there own numbers in a textbox and the program works out the total and average and produces a bar chart.I have done the hard part of creating the bar chart, but i am stuck on using the numbers in the text box from the array.[code]
View 5 RepliesI am trying to make a GUI that can input data into an exe that is already made.
View 1 RepliesI want to have multiple threads input data into the same arraylist, so they would need to share it. If this is possible how can I do this task?
View 1 RepliesI'm using VB.Net 2005 appln with MS-Access 2007 as database.In my appln i'm using a datagridview1 control, without datagridview control, i'm able to insert records to my DB directly from my TextBoxes..
But after after using datagridview control i cant insert or can't open my connection.. providing a solution to it? I dont know what to include or change?
[Code]...
On geting input into DataGridViewTextBoxColumn but the column should not accept input of data that is not integer like; 10003, 2.00, 1500.00
View 3 RepliesSome codes here on how could I validate my datagridview? I mean, a certain column on my datagridview should accept integers only, otherwise, it will return a messagebox. Kindly include on which event it should be posted.
View 17 RepliesI created a table in mySql named 'user' where fields are:
UserID,UserFirstName,UserMidName,UserLastName,Username,UserType,AcctPassword,DateCreated, DatLastModified and IsDeleted.
[code].....
I am having problem with datagridview. Actually I have created datagridview control used to display the data using sqldatareader. My problem is that How can I fill the data in textbox control when user selects the row in datagridview using coding. For e.g. my form is having a) Datagridview and displaying values of columns: Name, Address, City, State etc and textboxes: txt1, txt2, txt3, txt4. Now if the user selects any row from datagridview the selected value of Name is filled with txt1, address is with txt2, city with txt3, state with txt4. I am directly dealing with database with using DataAdapter.
View 1 RepliesI am having trouble in allowing the user to select the row in the datagridview.
I managed to include the checkbox column in the datagridview but i do not know how to wrte the code such that when the user wants to update or edit the data in the checked row, he just have to check the affected rows checkbox, can be one or many, and then click on ok button, which will then lead him to the data updater form, allowing him to update the data.
Currently i have the below code which can populate the checkboxclumn only.
dbProvider = "PROVIDER=MICROSOFT.Jet.OLEDB.4.0;"
dbSource = "Data Source = '" & Form1.TextBox8.Text & "'"
con.ConnectionString = dbProvider & dbSource
[Code]....
with more control over changing values in a data bound DataGridView.On form load, all the data is pulled down from the attached database and fills the gridIf I want to change one of the values in the grid, I can put my mouse cursor in the cell, change the entry and save it back to the database.
View 10 RepliesOption Strict On Public Class Form1 Private Sub btnDistance_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDistance.Click 'The btnEnterSpeed click event accepts and displays up to ten speeds from the user'and then calculates and displays average speed
[Code]...
I cannot figure out how to incorporate the number of days into the input box then get it to loop and count the number of times the User inputs in the number of days. Then I have to incorporate it into the equation to get the total distance D = MPH * Hours. What I have right now wil not count up the number of days and locks up after I input one number and will not add anything to the listbox. Because I also have to make sure that they cant add nonnumaric values and the number of hours per day cannot exceed 20. I have put things in and taken them out but it has been 2 days and I am lost now
how to input a data/value to excel through vb input form and get the data/value from excel back to the input form?? (For example: put a number into exel A1 from input form and get another number from ecel B1 bact to the input form)
View 1 RepliesI have a DataTable that's constantly being updated with new data from my database via a timer. That data is eventually reformatted and displayed in a DataGridView control.In an effort to prevent the DataGridView from completely refreshing from re-databinding (thus, clearing out selections, resetting scrollbars, defaulting sorting settings, and making the gridview flash as it reupdates), I'm simply removing old rows from the datagrid that no longer exist in the DataTable, and adding new rows to the datagrid that appear in the DataTable since the last update.
For the sake of simplicity, we'll call DataGridView the LEFT table, and DataTable the RIGHT table I'm looking for a way to go through both tables (LEFT and RIGHT), and remove old rows that are no longer in RIGHT and delete them from LEFT. And look for new items in RIGHT and add them to LEFT. Each table has a column called "RecID" containing a unique id for each entry that can be used for comparison. is there a way to do this all in one loop? What I'm looking for, in pseudo code:
<loop through everything>
if RecID does not exist in LEFT but exists in RIGHT
add new item to LEFT
if RecID does exist in LEFT but does not exist in RIGHT
[code]....
1. I have a DataGridView box, that is connected to a MySQL database via the 'Data Source'. I am trying to do the datagridview1.rows.add("info here"), however i receive an error i cannot do this programmatically. I DO know the code to post to MySQL via the "insert into" la la la.However, I was curious if I can do this via the datagridview a bit..easier/simpler, such as a "datagridview1.rows.add(stuff)" sorta thing.
2. I am attempting to make a custom control, and as with ANY control, they have their.. settings. Example, a textbox, or label, has so you can set the Text. and color, etc.Others, have it (such as datagridview) have the little icon on the control itself, where you click it, and it opens a small window with settings.
Once I read the property for DataGridView Column which allows Grid Column to adjust as per the data width. I can not recall it or find it.
View 1 RepliesI am creating a reporting app that pulls information off of a Sql database and populates the data in a datagridview control (DVG). I am using tab pages (Tabcontrol), and I have about 10 tabs with within the control. What I have done is created a dynamic control that will populate in each tab page once the tab is selected. I am using a split container and in my split container.panel 1 is where all my buttons and search functionality will be. In my split container.panel2 to is where the main DGV control will be. I have got this to function properly, however now I am unable to add anything to my split container.panel1. I would like to add diffrent labels and buttons in the panel1 one without putting another panel on top of the split container.panel1, and also if i do this when I resize my container the panel will just sit there. I am using the selected index changed event to get my split container to show in each of the diffrent tabs
Private Sub searchTab_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles searchTab.SelectedIndexChanged
searchTab.TabPages(searchTab.TabPages.IndexOf(searchTab.SelectedTab)).Controls.Add(splitContainer1)
[code]...
i'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)
I've been working on some code to add together input from an input box to make a string and display it in a message box. I've put the code in a loop so that it will add all input into the string until nothing is entered in the input box.
Dim stringInput As String
Dim message As String
Do Until stringInput = String.Empty
[Code].....
All I get is just the last input entered to show up in the message box and none of the previous entries. How do I get all the input to be added together and show up in the message box?