I have a datagridview in a form that is dynamically bound to a datatable. When the user clicks a button I update certian columns of the current row with code like this:
Dim i As Integer = myDataGridView.CurrentRow.Index
Me.myDataGridView.Item("closed", i).Value = DBNull.Value
I'm working with Visual Basic 2008 Express. My application opens with the Terms screen, a form that asks the user to declare his acceptance of certain terms and conditions or to decline. If he accepts, the app opens the main screen, giving him access to all the app's facilities. If he declines, the app gives him a message and then closes. Whether he chooses to accept or decline, the app puts his decision in My.Settings so that it can be used next time the app is opened. In this way he is presented with the Terms screen on the next opening if he declined on the last run. But if he accepted on the last run, he is presented with the main screen on his next opening.
All works fine when I do a debug run. But when I build and publish the app onto my desktop it opens with the Main screen instead of the Terms screen.
why it works on F5 but not after publishing?
Public
Class frmTerms
Dim Accept As Boolean
[Code].....
I need to very quickly write an exe system on a laptop where when the laptops are connected to the network they read a database table and store the data locally, so staff can use the laptop while they roam.The laptops have quite small capacity and the company would prefer not to use SQL Express or Access.
My question is, can the data initially be downloaded into the exe application via a dataadapter and dataset, and will that dataset the retain the downloaded data, or will I need to ensure the dataset is written to an XML file and then loaded/unloaded each time the laptop application is started while the staff are travelling ?
I am a web developer who now has to change a Windows service. I never worked on a Windows service before. I have a several programs that can run within this service. I want to persist a value of a variable from program to program.
View 1 RepliesI'm having some problems in persisting the viewstate on postback for a Control (vb.net)
here's some code i've put in my control[code]...
I'm setting EnableViewState = "true" everywhere i can, but still no result. Do i really need to set those properties here. (ViewStateMode and EnableViewState) If not, where should i handle this and what is the difference between those properties?
I have been searching for quite a while now but i am unable to find the answer to the following. I am storing a key pair in Windows Store, and recently started receiving the "Keyset does not exist" error. Investigating a bit further i found out it could be two things, 1 - The private key is not stored with the persist key set attribute (X509KeyStorageFlags.PersistKeySet) and 2 - access rights to the key. I have tried both 1 and 2 with no success on one machine (in my machine it works apparently). The strange thing is that when i look into MicrosoftCryptoRSAMachineKeys (and S-1-5-18) the key remains there but only for a period of time then it is deleted which means that it is not persisting.
//If decoded then save as RSACryptoServiceProvider
newCert.PrivateKey = DecodePrivateKey(privateKeyFile, pkPassword)
if (newCert.PrivateKey == null)
[Code]....
I have just found out today that since i am doing this through a WCF service, the application pool is deleting the private key when it reaches its idle time limit so i am completely sure that it is the application pool the one disposing of the private key which causes the key to be deleted from the MicrosoftCryptoRSAMachineKeys and S-1-5-18 folders. Today i left a test running where i disabled Idle time shut down from the application pool bu i am still not sure if the private key will stop persisting with a restart or something like that?
Would anybody know how to make the application pool stop deleting my private keys?
I need some general advice about using ListView. The program was originally written in VB2002, but now it's running in VB2008.The results of my program would typically be a ListView of 30 lines by 8 columns. I need to be able to save this data so that it persists after I close the program. There will never be a need to manipulate the data, so I'm looking for something simple. (There will be a need to print it.) I'm presuming that I need to link to a database to save the data. Correct? If so, can I use the one in Microsoft Works (which I already have), or do I need to get Microsoft Access, or is there some other better (simpler?) alternative?
View 7 RepliesI'm looking for a simple, efficient way to get the position of the browser vertical scrollbar and save it into a session variable in an ASP page. What I'm trying to do is when the user changes a page I've the scroll position stored in a session variable so that when the user returns to the page the page will scroll to their last position.Is there a way to do this? I've seen examples of persisting the scroll position on postback but nothing yet doing exactly what I'm trying to do [code]
View 1 RepliesI need to save the controls location and size on the parent form to file. My aim is to be able to simply copy that file to the path where an instance of my program is running and then it automatically applies the previously saved layout of controls. How can I use My.Settings to do that or is there another better option?
View 12 RepliesSorry for the extra long title, Here's what I want to do.I want to give the user the option of using or not using specific features of the program.If I can set a simple yes or no value that wil persist each time the program run and then depending on the variable turn off or on the feature at start
View 14 Repliesdoes anyone knwos what is the point of persist security info? i have always leave it at default (i'm not sure what value it is) but when i pass the application to my friend he seem not to be able to connect to the db. (btw the application calls
View 2 RepliesInstinctively, I would say that this is impossible, as NHibernate needs to know some mapping information on how to persist a given type. Thus, I encountered some situations in which I could use such a feature. For instance, through a named query or something like so. On the other hand, using a named query would require me to make an addition to the configuration file.
Let's suppose we have an application interacting with some underlying datastore. This datastore is configured through the NHibernate configuration file. Then, I wish to have NHibernate load only a subset of an entity properties, from another subsystem to which my application shouldn't need to interact much, so it is not worthy to define classes for this system, as I only need a fraction of this alien system's information, let's say three out of thirty-two data columns. For that matter, if I chose to load only those three columns let's say for performance concerns, I would then use an anonymous type, perform the required action onto this information, then persist it back to the datastore. Now, it wouldn't be of much interest to do so if I only had one entity to get loaded from the datastore, so let's say I have about 75,000 rows to load into my process. I then shall consider this subset option very seriously!
What strategy should you choose in such situation, if you needed to persist these changes to a subset only of this entity's properties?FYI: I am asking because I must write specific rules of usage with NHibernate, such rules that even a beginner developer would even be able to use it without knowing too much about NHibernate, but only following the rules and guidance of the technical documents I have to produce.
Let's say an application needs to persist mostly immutable data. Let's say the application's data files can grow fairly large. How would you implement a simple transaction processing so that changes are either successfully committed or rolled back?
The only requirement is to use built-in .Net libraries. (no databases, no third party libraries)
Here's my current solution. The data file will have three main sections: (1) header, (2) data, (3) index. For now, the header section simply contains an offset to the start of the index section. The data section will store mostly immutable data. The index section will contain serialized objects with enough information to access the data section.
When the application starts, it only needs to deserialize objects from index section. Anything from the data section can be fetched as needed. As the application gets ready to write changes, it makes a temporary copy of the original header and index sections. These would be small relative to the data section. New data would then be appended to the original data section. Once all data has been written, in memory objects would be serialized to the end of the file to become the new index section.
If all this goes without a hitch, the temporary file can be deleted. If something goes wrong, the temporary file can be used to restore the data file to its original state.
Will this work or is there a more elegant approach?
I am making some changes to a fairly old project.It has a DataGrid with an Inherited Class
Public Class CustomDataGridTextBox
Inherits DataGridTextBoxColumn
and a Override Sub Protected Overloads Overrides Sub Paint (.......What it was doing was alternating the Data Grid Line colours New Requirement is to break up some items in the DataGrid By categories So I have added new lines to the data and sorted so they show up ad category headers (Production Stations) And they would like the Category Header to be a different colour and then the alternating line colours to restart.This did not sound too difficult but that has proven a trap Setting the category header is no problem but restarting the alternating colours is Previously the row was determined to be odd or even to set the colour.Now I am intending to use an Integer to define what colour is used but it persists only for that text box.
How can I get it to extend its life so each call can refer to it and update it and set the desired colour?All I need to do is have an integer variable that will hold its value for the next call?
I have an app where I need to dynamically choose an SQLDataSource for a GridView so I can use 1 of 2 stored procedures, depending on who is logged into the system. My problem is that I am using logic like this, in the button click...
If Session("SiteType") = "Type1" Then
GridView1.DataSourceID = "SqlDataSource2"
Else
[code]....
This happens when you click the button that reveals the panel with the gridview in it. The user then makes changes (basically adjusting a text box on one or more liens of the grid) and then clicks "save". However, the gridview no longer knows its DataSourceID once this happens, so when I try to go through the gridview's rows - there are none.
If, in the save button's click, I put the same code, it (of course) blanks out any of the data changes I made in the form. So, simply put - how do I dynamically choose the SqlDataSource, but only one time, so that the program then keeps that SqlDataSourceID associated with the gridview until the end of the cycle? Is this a ViewState thing? I don't totally understand ViewState...
I'm using an Entity Framework context, and sometimes would like to create a transaction so that the client can do multiple changes and then commit/rollback them all together.However, if many changes were made, and SaveChanges() was called multiple times, after which a rollback is called, entities that were commited already, will remain the way they were commited, and would not roll back.Here's how my transaction-relative functions look like:
Public Sub BeginTransaction()
Dim context = HttpContext.Current.GetObjectContext()
If Not context.Connection.State = ConnectionState.Open Then
context.Connection.Open()
End If
[Code]...
Not only does the test fail, but it also leave the ObjectContext in an unstable mode, because it still has invalid changes in it.
I have default.aspx used masterpage, in master page i have a control called DefaultMenuContent, this control have a dropdownlist with autopostback, the problem is loosing the selection even if i use Is Not PostBack in control's load event, how to persist the dropdownlist selection?
In Master:
<asp:ContentPlaceHolder ID="MenuContentPlaceHolder" runat="server">
<art:DefaultArabicMenu ID="DefaultMenuContent" runat="server" />
</asp:ContentPlaceHolder>
[code]....
I want to hear some discussion regarding what is the best way to persist program parameter and variable settings from one run of the program to the next. I used to often use the ubiquitous INI type file in VB6 programs but I am aware that these are not formally supported in .Net programs. I also have a major aversion to adding to the already overwhelming bloat of the Windows registry by using that to store values.
[Code]...
Some 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 have a DataGridView (dgv) on a Windows form (VB.NET) which is bound to a datatable. One of the bound columns is a an ID (Foreign Key) to another datatable. All I want to do is Hide the ID column and populate an unbound column with the Name (ParmName) for the user. I searched the foreign value in the datatable and retrieved the information. I set the Value of the cell in the Datarow. All works well, but does not display. The cell accepts the value...I can even Debug.Print the values to the console. They are there just nothing displaying in DataGridView. Nothing odd about DataGridView. Should be straight forward...
My Code
,
Dim dtParm As DataTable = MyDataSet.tblParameter
Dim dgv As DataGridView = Me.dgvResultNum_DataGrid
[code]....
A datagridview is sorting numerical values (when clicking the datagridview column header text) in the wrong order based on the initial digit:
[Code]....
I have a few classes, one is a form, the other is the source of the datagridview. I want to be able to sort the columns of the datagridview by clicking on the header. Here are the classes that I am dealing with:
Imports DiscoveryByte.AddTools.Misc_Tools
Public Class ViewDiscoveryFlashCards
Private DBBindingSource As New BindingSource
[code].....
I want to see if anyone has used one table that has a primary key (not displayed) in the DataGridView. Then use a text box on the same form to call and group what if viewed in the DataGridView table. I want to group the displayed data of the DataGridView by the primary key of both tables.
View 1 RepliesI have several problems with rows in a DataGridView. Background information: The DataGridView (DataGridViewCalib) is in one TabPage of a TabControl, some columns of the DataGridView are automatically DataGridViewCheckBoxColumn as the DataSource have some colums which are Boolean. This is a Windows Form written in VB.Net with Visual Studio 2008. The user loads an input data file.
The problems:
1) At first arrival in the TabPage, ShowDataGridViewCalib (code below) is called. All rows are then shown in the DataGridView, despite the code saying that some rows should not be visible. Breakpoints in the code show that the code do arrive at the Rows.Visible = False events. Despite all rows beeing shown a Watch in the debugger shows that:
[code]...
There are two alternative ways of handling the rows in the code. The first attempt (commented away here) is probably the "nicest".
Using VB.NET 2008. Am using Datagridview in my application, Datagridview should display according to the windows screen size, Before I used vb6
code.
Private Sub Form_Resize()
On Error Resume Next
[CODE]............
Am new to vb.net, How to set a datagridview size according to windows screen size, In Datagridview property itself any option is available or i have to make a code as like vb. If i have to make a code, how to give form_resize in vb.net.
I 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?
I have a DataGridView where Cell_Validating is being done. I have a Cancel button on my form that allows the user to exit out of the DataGridView changes. The problem is that if a cell was currently flagged as in error, I cannot exit and remove columns from the DataGridView. I get the following error: Operation did not succeed because the program cannot commit or quit a cell value change. Is there a way to cancel the validation once the focus has been removed from the DataGridView? Here is my Cell_Validating
[Code]...
In VB.NET 2008 I've two forms 1 & 2 containing two datagridviews connected to two data source 'ACCESS 2007 tables' Now I want to select multiple rows from one datagridview (form1) & transferring these to another empty datagridview (form2) with a button_click.
View 3 RepliesI have 2 forms, each one with a datagridview.I want to transfer all the DataGridView Rows from From2 to another DataGridView of Form1. but it's not possible.
[Code]...
If using a datagridview to update a database and the datagridview is bound to a bindingsource which has its datasource as the table to be updated: where dshould you place the tableadapter.update(mydatarow)
View 5 Replies