I'm allowing users to change data in a DGV. Is there some kind of built in method for DGVs that updates the table with the new values in my Access database? I have a save button that performs the following:
[Code]....
In my form load event I am setting the defaultcellstyle formats. They are not taking hold anyone know why? None of the formatting that is expected in the code after I bind the datatable to the grid is getting done even though the code steps through it
Private Sub frmADRORD_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'wire the delegate function for incoming updates
AddHandler m_helper.DataUpdate, AddressOf UpdateGridInvoker
'bind the visual grid with the binding source
[code]....
I have a DataGridView that loads info from an Access DB. The user can change the data accordingly, but how can I make it so the form will save the data that was changed? I know I'll have a SAVE button... but not sure what methods to be calling on the DataGrid
View 6 RepliesI'm adding a textbox to my grid as follows and formating it as a date.But reagrdless it doesn't seem to want to format it as a date.Further how would I prevent, for just a single column, the user from entering anything but numbers and "/"'s?[code]
View 5 RepliesI've got 1 form, with a TextBox1, where I want the news to pop-up.Now, I've made a kind of admin menu, where there's another TextBox in another form, and I want it in such a way, that when I press the "Accept" button, the text saves itself and shows up in TextBox1.[code]Can I control form 1, with form 2?
View 3 RepliesI'm trying to get the first row in each worksheet to be shaded and have the font bold. Right now, I am able to get the first worksheet changes made, but none of the other worksheets within the same workbook are being changed. Here is what I have written so far for creating the spreadsheet and applying a format.Public Function WRITE_TO_EXCEL(ByVal dt As System.Data.DataTable, ByVal includeheader As Boolean, ByVal worksheet_index As Integer) As Integer
[code]...
I have the following [cod]e...
But the label still shows the [b]! It doesn't want to delete itself..
I have add,update,delete buttons on my form.A message box should appear on the screen "should have values to Add/delete/update/" if user clicks on Add/delete/update buttons without having any values in the textfiled,i have around 20 text fields on my form.
View 7 RepliesThe general purpose of my application simply reads a line of text for example:
1. I have a printer issue
2. I have a software issue
I have a rule set as follows:
'Define the class 'Printer' with 14 values as a string...
Dim Printer(13) As String
'The string 'Printer' gets assigned a value, this is repeated another 13 times...
Printer(0) = "Printing"
[code]....
The code simply uses a number of keywords to detect if the issue is a 'printer', 'software', 'telephone',. or 'password' problem.I want to apply this rule set to 10 issues within the same rich text box, with the results sent to a text file. The exporting to a text file I can do, however the main issue is, i cannot read the lines individually.
I tried applying an animation to an object in powerpoint through VB.NET. I'm only a beginner and have tried my best to figure it out with something like the following code which is two objects using one as the trigger. I managed to get it working in pptVBA but just can't get it to work in .NET. I keep getting an error COMException was unhandled.
Imports PowerPoint = Microsoft.Office.Interop.PowerPoint
Dim intereffect as powerpoint.effect
Dim oShape/sPic as powerpoint.shape
With oApp.ActivePresentation.Slides(1).TimeLine.InteractiveSequences.Add(1)
[Code] .....
I have a dialog with an OK, Apply and Cancel button. I want the apply button to have the same effect as the OK button, but the dialog should not close. Can you stop the dialog from closing when you set a dialog result value (as I want to when clicking the Apply button)? Basically I have some settings that are passed into the constructor of the dialog. The dialog then updates its controls with these settings. At the moment any settings that are changed in the dialog are applied when the dialog closes via the OK dialog result (i.e. the code that calls the dialog also applies the changes). This is the way I would prefer it to happen, but the only way I can think of to get what I want to work is to apply the settings changes before I set the dialog result value (i.e. in the dialog code). This essentially makes dialogresult useless in my case as I cant use it to get the effect I am after.
View 6 RepliesI have an application that is writing a comma separated values file. How would I go about altering the permissions of that file from .NET - for example to give read-only permissions to a particular active directory group?
View 4 RepliesI'm trying to set ACL's on a folder using Directory.SetAccessControl. More specifically, I want to grant "Users" full control on a folder. AddFileSecurity works perfectly. AddFolderSecurity does not. It's result is that "Users" will get added to the folder's ACL but "Full Control" is not checked off (nor are any other permissions).
Imports
System.IO
Imports
System.Security.AccessControl
[code]....
i got the following equations and want to apply it in VB.net, how do I construct it in VB.net.
[code..]
I'm creating a windows application form in vs 2005 for a client.. It's a data-tracking application. I have a few questions.The client wants a logon screen to be added into the application (at least any way or method that'll ensure that security was applied). My question in regards to this topic would be; Is it necessary to create a logon screen (or even a user authorization) for a windows form? I realize that in a webform project, security should always be considered and should be applied in all areas. Although with a windows form, I thought you can authorize who can gain access to the application by defining which workstations to install the final production release of the application (when its time to deploy the file). Is this correct?
My next question is, what is the best method to exporting data from EXCEL to SQL tables? I have many Excel files that I'd like to take portions of data from each file and insert them to there proper table.
The last question is about deploying a windows form application. As you can tell, I don't have much experience when it comes to developing Windows Form projects. Anyways back to the topic, When deploying a project, does it provide a .EXE file (installation package) to install the application on the workstation? Or is it a .EXE file of the application, where you can run it and no need to install anything?
I am working on applying date validation to excel cell(range) from VB.NET.
Private Sub DateValidExcelRule(ByVal worksheet As SpreadsheetGear.IWorksheet, ByVal DateRange As String)
Dim dt As Date = CDate("1/1/1900")
[Code].....
When I enter 4 digits whole number 7777 it is validating correctly showing message Enter Valid Date, but when I enter 5 digits 77777 it is accepting the value and converting it to 12/10/2112 value and not showing any error message.
Here all I want to do is I want to validate the cell value to any date format mm/dd/yyyy.
I created a form with a datagrid to show data stored in an Access database. It shows the data correctly, using the code:
[code]...
("compras" is the table name and "Comprasver" is the dataset name).The form also has 3 textboxes and 1 DateTimePicker.Then I created a sql query to allow the user to search within 4 fields of the table (field1, field2 and field4 get the data in the textboxes and field3 gets it in the DateTimePicker). The query looks like this: SELECT field1, field2, field3, field4, field5 FROM compras where field1 like "%"+?+"%" and field2 like "%"+?+"%" and field3 like "%"+?+"%" and field5 like "%"+?+"%" field4 is not an important search criteria, so I didn't include it in the query. Field1 and field2 are both string type. Field3 is a Date type and field4 is integer.Once I made the query, it automatically added a toolstrip with a code, which I cut and pasted in my "Search" button "click" event. The code looks like this:
[code]...
But every time I try to search, no matter which criterias I fill in (even if I fill in none of them), I get an error message saying something like the conversion of the "" string into Integer is not valid (my Visual Studio version is in Spanish, so I don't know how to exactly translate the error message).It's supposed to let the user fill in one, more or all search criterias (all 4 search fields).I found out that if I delete from the query the two fields that don't have String type data, it works correctly. What should I do in order to be able to use the Date and Integer type fields as search criterias too?
Okay in my program I have users select options and then it writes text to a file. When the user restarts the program, I want it to read from the file and search for specific text like "User is a senior,False." At this point if the file has this text, I would like the program to read from a line in the program.
View 3 RepliesHow do I apply 2 font styles to the text selected in a richtextbox? Used this method to change fontstyle:
RichTextBox1.SelectionFont = New Font(RichTextBox1.SelectionFont, FontStyle.Bold)
But with this method I can only apply 1 font-style (for example bold OR italic OR underlined, etc.) right? But I want to apply for example 2 front-styles, or just add the font style ( so I can add several front-styles to the selected text, for example the text is bold, and then ALSO make it underlined (with this method I can only change the font-style, only one font-style)), how do I do this?
Just do so:
RichTextBox1.SelectionFont = New Font(RichTextBox1.SelectionFont, FontStyle.Bold + FontStyle.Italic)
In my program I have a picturebox. using the .onEnter and .onLeave events for the mouse I have the cursor change to a cross (one of the default cursors) and it does like a transparent grayscale thing and changes color a bit depending on what is behind it. The issue with that is that all the images I look at are grayscale images so it gets a bit lost. I am wondering if there is a way to use this default cursor and apply a different color to it?
View 1 RepliesI'm very new to VB and am struggling with a problem! I have a form with mutiple (100) textboxes and buttons. I have set the properties of some of the buttons so that the text is draggable, but I want to be able to drag it to every textbox. I have posted a snippet of code below that allows me to drag ot to box 1 and 2, but is there any way that I can set it to drag to all boxes without having to individually specifying them? The same goes for dragging text between boxes...i'm sure there must be some way of specifying multiple drag and drop locations without the laborious task of specifying each as an individual sub? Code below
[Code]...
Can I calculate sumproduct by applying LINQ to List collection?[code]...
How to return the weighted Percentage for each category with LINQ? Weight is the Value.
I have a datagridview (windows forms) that is inside an mdiChild form. The custom format is given by a "for" instance, something like this:
For row As Integer = 0 To .Rows.Count - 1
If .Rows(row).Cells("someNumber").Value = 0 Then
.Rows(row).DefaultCellStyle.BackColor = Color.DarkSeaGreen
End If
Next
So, for every row in the grid that you find, if ther value in the "somenumber" =0 paint the whole row green. Problem is, if I put the form OUTSIDE of the MDIParent - just put frmMyform.show() in my btn that calls the form-, the grid WILL apply the format; If I call it like frmMyform.mdiparent = frmMdi, then frmMyform.show, the grid WILL NOT apply the format.
Our MRP database stores time as a four character string.
0116
0845
1420
[code].....
I'm currently working on this .Net/WPF project. I'm trying to get the method to check to see if a skin file exists before applying. I have feeling that my address formatting my be wrong....
Dim lobjSPEConfigService As SPEConfigurationService = New SPEConfigurationService
Dim lobjSkinFilePath As String = CStr(lobjSPEConfigService.GetApplicationSetting("SkinFileLocation", GetType(String)))
If String.IsNullOrEmpty(lobjSkinFilePath) Then
lobjSkinFilePath = "/SPE.Infrastructure.UI/Application/Resources/Skins/LightSkin"
[Code] .....
The file is being referenced thourgh the project...
I'm working on a project with FTPwebrequest methods, the problem is that every time the program executes a FTP command such as download/upload/connect, It completely freezes the form. However I need a progressbar to keep the user updated of the download status. The only way I can see this working is applying the progressbar to a notifyicon(taskbar).
View 2 RepliesI am using API calls to transform a Bitmap object. I have various physical transformations (rotation, flipping, scaling, displacement) as well as some colour adjustments (inversion, brightness and contrast)Everything works fine except for when I use the rotation or shear transformations in combination with the colour adjustment. In that case the colours revert to the original image.The interesting thing about this problem is that it seems to be dependent on the off-diagonal factors (eM12 and eM21 below) in the XForm matrix. For example, here is the rotation matrix:
Public Sub RotateClockwise(Radians As Single)
With XFormMatrix
.eM11 = Cos(Radians)[code]....
is there some way I can use both SetWorldTransform and SetColorAdjustment when using non-zero values for the off-diagonal factors in my XForm transformation?
I was just wondering if it is possible to apply an attribute to a property within a business object (MyBusinessObject) such that after the DataSource of a grid is set to a List(Of MyBusinessObject), the visible property of the column will automatically be false. For example:
myGrid.DataSource = New List(Of MyBusinessObject)
Public Class MyBusinessObject
[code]....
Ok, so I have created an Access database, and everything is working fine (much to my amazement) except for one thing. I want the database "update" button to validate the input before applying it to the dataset, and if there is an error (empty field) I want it to pop a message and highlight the text box in question where the error occured (there are 7 textboxes).
How precisely do I go about doing that?
CODE:
This is what I have so far for the update button. I attempted the "textbox1.isnullorempty"
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 Replies
