I have the data grid above that displays rows of data. Problem I am having is when I clear the grid from one file to the next. The last cell selected is staying on the screen - and I dont know why.
I have tried many thing like DataTable.EndEdit, DataGrid.EndEdit, DataTable.Refresh, DataGrid.Refresh, etc. I can't seem to make this behavior stop.
What I have is on my form there are several text boxes. These text boxes are for user input and attached to each text box is a Private Sub txtBox1_KeyPress function. In that function I have some validation code to check that the user is inputing only what I want them to. And if it doesnt it will pop up a message box telling them so, then it is supposed to clear the text box so the user can try again. But no matter what I try, the text box does not clear it still keeps the last character typed (the invalid one).
Here is the code for one of the text boxes.
Private Sub txtLanIp_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtLanIp.KeyPress
Dim strEmpty As String = ""
If Char.IsDigit(e.KeyChar) = True Or Char.IsPunctuation(e.KeyChar) = True Or Char.IsControl(e.KeyChar) = True Then
'do nothing
[code]....
The commented methods at the bottom are some of the other things ive tried to make this work. The txtLanIp.text.clear() is what ive tried from the beginning. I have also tried setting the text to "", I even created an empty string and set the .Text value to it but no matter what it wont remove that character. I have also tried various trim(), len(), Select() functions, most either give me an 'index out of range error', a 'length cannot be less than zero' error or a general ExceptionOutOfBounds error. I am just tearing my hair out as to why the simple way doesnt work, there is no logical reason why and it gives no error it just doesn't clear the box.
I have also tried moving the validation to a _LostFocus but e.KeyChar isnt a valid method or property for that declaration, which doesn't surprise me but I wanted to try everything.I dont see how it would matter in this case but I am running Windows XP Pro SP3, though I also see the same behavior in Windows 7 64 bit ultimate sp1 and windows 7 64 bit pro.
I am stuck at this part where I am unable to allow paging in the datagrid. I have tried this.
<asp:datagrid id="dgReport" runat="server" AllowCustomPaging = "True" PageSize = 5 OnPageIndexChanged="dgReport_Paging"....
and in the code-behind,
Sub dgReport_Paging(ByVal sender As Object, ByVal e As DataGridPageChangedEventArgs)
dgReport.CurrentPageIndex = e.NewPageIndex
bind()
End Sub
IM making a password and username and website recorder and how would i save it all to a file? (and load)
View 2 RepliesI'm currently attempting to save data inputed into a data grid clicking the "save" button. My problem is, I also have another DB opened in the same window that also needs to be saved. The second database is pulled up by the contents of a text box, so there for it has no real Dataset to call on. It looks something like this.
[Code]...
I try to run the update command it always throws the exception "Cannot find table 0" or "Update unable to find TableMapping['Table'] or DataTable 'Table'." I tried declaring the connection the same way as the code above and then simply calling the da.update(ds) but it wouldn't do anything.
I haves textboxes and a ddatagrid and a report. This is how I put the the data of the textboxes in my dataset and show the report, but I was unable to show my data in the datagrid in the report, how can I do? It�s not possible two datasource
[Code]...
I have a datagrid and set of collection of columns for the datagrid. I have added cloumnname and headertext using column collections in design time. I have made false of autogenerated column. I was unable to load the data in datagrid from datatable. If i remove the collection and add bind data in datagrid means working fine but not for the column collections.VB.net windows application.
View 2 RepliesI want to be able to type text in a search box (textbox1) and have the datagrid adjust at the same time. My datagridview is called DGEstudent and the data source is dataset2 and is pulling from the student table. As soon as I start typing in the textbox my datagrid just goes blank. Private Sub TextBox1_KeyUp(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.KeyUp
Dim dv As DataView = New DataView()
dv.Table = DataSet2.Student
dv.RowFilter = "First_Name like '" & TextBox1.Text & "%'"
DGEstudent.DataSource = dv
this is currently my code to clear my 5 textboxes
Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click
TextBox1.Clear()
TextBox2.Clear()
TextBox3.Clear()
TextBox4.Clear()
TextBox5.Clear()
End Sub
I have a timer that runs every time by itself, and for the code the runs in it I would like to have it clear the dataset before it does anything, the timer runs every 10 seconds, so I tried to do dataset.clear but it would crash if the dataset had no values
View 4 Repliesin hyper teriminal when i press "ctrl+L" is to clear terminal screen how to write the code in vb.net? Hyperterminal is connecting to serial comport.when i try this it work and return line on debug
serialport.writeline ("at+cmgl=1")
i try this but not work and it still show some lines on debug
serialport.writeline (vbcrtl +"L")
serialport.WriteLine("vbCrLf + l")
way to clear textboxes in VB.Net and what is the difference between the two methods? I have also seen people be critical of folk using clear objects on their forms and i can see why but in this case, i am only learning.
txtbox1.Clear()
or
txtbox1.Text = ""
wan to ask about anyone know the code about how to clear all the data inside the data grid view without clear the binding source...
View 1 RepliesIn my winform program (in vb.net) I wrote:
Dim dt As New DataTable
'Get data from DB into dt
'...
[Code].....
But when I run the program, Clear() cleared both dt and dttemp! Why? Aren't dt and dttemp supposed to be two distinct instances of DataTable?
(I finally found a solution - dttemp = dt.Copy() instead of dttemp = dt. But I still can't see why Copy() was necessary in this case.
I am using the StreamWriter to create a log file for my application. However I do not see a method on how to clear the file (make the file blank again). Also before I clear the file I want to rename it so that I can have multiple log files, a new one produced everytime the application runs.
[Code]...
I have a datagridview with transaction bindingsource I want the datagrid to show the sorted rows only not all the records when i enter a value into a textbox and click button sort.
View 1 RepliesWhat I am trying to do basically is open an access query in a datagrid view and then be able to make changes to the datagrid and then save it back to the database.When I try to save:
Me.BindingSource.EndEdit()
Me.TableAdapter.Update(DataSet)
It says that update is not a member of the tableadapter... Why is that?
now i use acces as datasource to view the agenda in a datagrid and a combo box to select a year or month so i can find the selected month or year in the datagrid .how do i program it so that it searches the selected year or month in a datagrid
View 2 RepliesI have a datagrid who's ItemsSource is a strongly typed IEnumerable object In this datagrid, I have a checkbox column, a price column, a part name column, and a 'total selling for' column. On checking the checkbox I need to update the total selling for column with the value in the price column. This part I have working, however, how can I get the checkbox to remain checked when this happens?
Private Sub UpdateSellFor(sender As System.Object, e As System.Windows.RoutedEventArgs)
Dim _CB As CheckBox = DirectCast(sender, CheckBox)
Dim _ID As Integer = _CB.Tag
Dim _PP = DirectCast(DG_PartsToSelect.CurrentItem, PartTyping).PartPrice
[code]....
I placed a datagrid in my form which l retrive data from my sql. i am using oledb connection. if i run the form i can retrive the data but i am not getting the data in the grid at first ,there is a "+" sign, i have to clik that then it shows the table name and after clicking the table name i can view the data displays in the grid..
View 1 RepliesI have a datagrid which I am using LINQ to fill, I then add some custom columns and fill them in programmatically - if the users clicks on the column header to re-sort, all the data in the added columns disappears. I am obviously missing something very basic here but can't seem to see the forest for the trees. I also have a couple of other questions about how I am doing things:
[Code]...
I am trying to create an xml editor that read and write xml. my code reads the xml with no problem and allows me to create new rows but when I try to "write" it over I get the following error: "Token StartElement in state Epilog would result in an invalid XML document"
here is my xml:
<?xml version="1.0" standalone="yes"?>
<MacroList identifier="test">
[code].....
I decided to rewrite my project. Hit another snag. How do I write the contents from a datagrid to a file and back into the datagrid again later? (Actually, I've done the writing ok - but for the life of me can't get the data back into a blank datagrid.
Here's what I done so far:
Imports System
Imports System.IO
Imports System.Text
[Code]....
how to do cursor moving from one grid it effect to another grid.example Grid A and Grid B have the same number of rows. when I click current row on data grid A, the selected row on data Grid B also follow data grid A..
View 1 RepliesI am printing a files that are shown in datagrid.. But I want to choose a file that I don't want to print by checking the checkbox that I added in datagrid..
I have here the code for printing.. Anyone can edit my code that will print those file that is not checked.
Code:
Try
openMySQL()
Dim sql = "DROP TABLE IF EXISTS dummydisconnectionorder"
[Code].....
I have on my form two datagridviews that correspond to the same table. They are both databound. They have been created automatically through dragging them from the datasources windows.One is datagridview and the other datagridview1. When ever I navigate through a datagrid the corresponding row on the other grid changes as well. I do not want this. Also I want to be able to fill and use each datagrid indepentent from each other. To fill a datagridview on load I use this code
Me.AllServicesTableAdapter.workstation(Me.Database2DataSet.AllServices)This code does not let me choose which datagrid to fill.
I have a search form on that will be pulling search template queries from a table in the underlying (an Access db on a share). The search form has a calendar control for filtering by date range, a listbox containing the names of the search templates, a second listbox which lists the fields in the selected template, and then some controls which show/hide themselves depending on which field is selected so that the user can pick a field and enter it's unique criteria in the appropriate control for filtering. Below these controls is a DataGrid, which will obviously display the results.
The problem is how to dynamically "transform" this DataGrid to display the selected search template. These templates do not represent tables in the underlying; rather they represent preconstructed SQL queries (stored in a table) which are essentially SELECT queries with joins and no WHERE clause (so they are the results of multiple tables joined together by their keys).
To be honest, I'm having trouble even generating the LINQ queries to represent these template dynamically, but that's not as important, since I can manually translate the SQL queries into LINQ. This is definitely not the preferred method, as the whole point of putting these templates in a table, rather than code, was to allow for future additions without rebuilding/redistributing the application interface.
what are the differences between the WPF Datagrid included in the .NET Framework 4.0 versus the Datagrid included in the out-of-band WPF Toolkit? I understand that the toolkit version was released first, and targets the .NET Framework 3.5 SP1.
I needed a WPF datagrid quick and have utilized the toolkit version in my applications. I'm considering moving the application to .NET 4.0 and am wondering what the pros/cons will be in changing out my existing datagrids for the new ones.
I have one data grid which contains a column which contains long string values. When I edit it, the text box which appears is very small. I want to increase the length of text box.
View 2 RepliesI am using the following code to clear all the values of all my controls everytime I click save button....Is there a way to not to clear the value of a certain control inside one groupbox? I would like the radiobutton in one group box will not be cleared...or if it can't be done, how do i put back the selected radiobutton after i click save?[code]....
View 15 Replies