I've got MONEY datatypes in a SQL database.I bind these to TEXTBOXES in code.These fields show up like 104.0000 or 0.1300.Is there a standard way to format these so that only two decimal places appear?
View 3 RepliesI have a DGV that is bound to an Access DB DataTable. I have added a column in the DB that is either a 0 or a 1. When the program loads, I want to change the backcolor and forecolor of each row based on the value of this column's cell. ie: a 1 makes the row red, a 0 makes the row green. this column would be hidden in the DGV.
Is this possible to do at runtime even though it is bound?
I'm not sure when I would actually do the color swap, formLoad?
Second question, as I iterate through each row of the DataGridView and need to change the value of this column, will this update my DB automatically, or do I need to call an update() after each row?
I'm trying to format a datetime field to just show the date. The datetime is bound to an asp:label and for the Text attribute I have tried the following....
Text= String.Format("{0:D}", '<%# Bind("CReviewDate") %>')
and
Text= String.Format("{0:D}", <%# Bind("CReviewDate") %>)
[code]....
In all cases I get a green wavy line under the equation and the tip help says "Validation (ASP.Net): If this attribute value is enclosed in quotation marks, the quotation marks must match.
String.Format("{0:D}", DateTime.Now)
is the syntax that I have been told should work.
I am an experienced programmer but am new to VB. To start, I am trying to create a simple database program. (My ultimate goal is writing a comprehensive database program in 6-8 months)I have created the database and bound the fields to a form.
But what I want to be able to do is add a field to the database and then also bind that new field to a textbox on the form.The new field appears on the list in the Server Explorer window (on my left) but not in the data sources window (on my right.) The data sources windows has a "refresh" option but that does not help.When I manually add a textbox and try going to DataBindings in the property window the new database field is not listed.
I have a custom collection class that is bound to a data grid view object.I'd like to try to do the following from the custom element class if possible.
1) I'd like the name of the column header to be a different text than the name of the public property in the custom class. i.e. Trade_Name should read "Trade Name"
2) I'd like to try to be able to manipulate the text formatting/color of the individual collection class element's items. i.e. for a profit/loss field I'd like to have the numbers be red if they are loss and black of they are profit. I know I could do this from the datagridview object in the form, but that can be cumbersome to raise events etc.
I am having issues understanding why it is that a text box that has been bound to a dataset correctly updates that dataset when the text in the box is manually changed i.e. by changing it using the keyboard but the dataset does not recognise the change when I change it in code.Am I missing something obvious? The text is changed in code when the user clicks on a command button that copies the text from another textbox on the form to this textbox.
[Code]...
As i mentioned, manually it works fine but when I use the comman button to change the text it does not recognise that any changes have occured.
I have a window form with a label. On the form I have a dataset, bindingsoure, and tableadaptor (all created by the IDE in response to binding the text property of the label) To fill the datatable, the IDE created this: Me.ClientsTableAdapter.Fill(Me.MyDataSet.Clients) Works fine. The bound field is a phone number, stored in the db as a 10 digit numeric string I need to format this with the standard ()-, and I have a function that will do just that. How can I apply the formatting so the phone number appears in the label properly?
[Code]...
I'm trying to resize any image fields in my data-bound DataGridView to 200x300; the column resizing code looks like this:
[Code]...
I want to allow blanks in BOUND textboxes that are bound to int and money columns.
It's not letting me - apparently it knows to force digits...
Is there anyone who can tell me the code for the below? Receive a lower bound and an upper bound of a range. Also receive a number of random numbers to generate. You must validate
1) the numbers are integers
2) the lower bound is less than or equal to the upper bound
3) the number to generate is positive (i.e., > 0).
Generate this many numbers in the specified range and keep track of how many of each are generated in an array of counters. Once all the numbers have been generated, display in a List Box the number, the raw count data, and the percentage of how many times the number was generated displayed with two decimal places of precision.
I have a DataGridView that is bound to a DataSet I created from a database table named Contacts. The Contacts table contains a field called StatusId. StatusId is a foreign key to a table called Status. The Status table contains StatusId and StatusName.
[Code]...
I have some VB .NET software that interfaces to a load of old (but sound) COM objects. The VB provides a GUI for the COM objects, part of which consists of setting various options on the COM objects - several of which relate to string formatting.I have a simple pair of VB .NET functions that convert basic %f, %d, %g formats to/from .NET equivalents using a large select case covering specific common strings, but they don't cover all formats.[code]Before I start diving in and making it more versatile with some parsing, does anyone know of a class (eg VB or C# .NET) that provides a decent ready-made implementation? Or perhaps some regexp wizadry could be used?
View 2 RepliesI'm currently refactoring an old Visual Basic DLL (VB.Net), which stores all of its data in one module called Globaldefinitions as public fields. There are about 200 fields, referenced thousands of times all around the code:
Public Module Globaldefinitons
Public a As Short
...
Public zz10 As Double
[Code]...
I need to change the module into a class with non-shared fields. This means, each and every of these thousands of references needs to reference the instance of that class:
globalDefinitionsInstance.a = 5
How do I go about this efficiently?
Regular expressions operating on the source fall flat. Refactoring tools like Re-Sharper or CodeRush don't seem to offer this functionality. Visual Studio 2010 cannot do it automatically either.
Class Foo
ReadOnly name As String
Public Sub New(name As String, dependentUpon As Foo)
Me.name = name
[code]....
The output of New Bar() is:
Dependent created. Dependent upon nothing.
Independent created. Dependent upon nothing.
It seems fields are initialized in the same order as they appear in the source code, which (a) leads to an unexpected result, and (b) seems a little puzzling, given that one is normally not permitted to read from uninitialized variables in .NET, yet that seems to be working fine above.I would've expected VB.NET to be smart enough to initialize referenced fields first, and only then those that reference it; i.e. I'd have liked to see this output instead:
Independent created. Dependent upon nothing.
Dependent created. Dependent upon Independent.
how to get VB.NET to behave like that instead, without simply having to swap the declaration order of dependent and independent inside class Bar?
I'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
View 1 RepliesMy intent is to have the code - on a button.click event - check the Username and Password fields and return an error depending on which is wrong. Or if both are wrong, return a different error message. I've set the username as parts and the password as parts (still learning how to use external authentication). [Code]
View 2 RepliesI have several sqldatasources for my gridview. All of the columns are autogenerated. However they all have some consistent fields and I'd like to make those fields template fields so I can modify the edit template for them such as adding a drop down menu. Is this possible?
View 1 Repliesexperience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
View 2 RepliesI have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
There is something strange going on with my datagridview.
I've a data adapter that fills the underlying data table from a database. Then I assign this datatable as datasource to the datagridview Then I add a row to the datagridview and immediately I need to update the table in my database (as soon as user leaves the newly created row).
At this moment I have more rows (+2, not +1) in my datagridview than in the underlying datatable (the new row doesn't exists yet in it so the data adapter .Update method doesn't write anything to the database).
When DataGridView's .RowLeave event fires the undelying datatable is not yet updated. I've a question - is this behavior normal?
how to execute this SQL Statement
Scenario:
Given Tables T_Data, T_AllDesc, T_System1, T_System2
Given Fields:
T_Data= f_id, f_Desc, f_CreationDate, f_CreationTime, f_System1, f_System2
[Code].....
We are binding most of our text boxes and dropdown boxes to a BINDING NAVIGATOR (with a DATA SOURCE of a DATA TABLE).When the BN is clicked through the text boxes all change immediately.We need to use some non-bound controls as well.First one is 4 radio buttons that when clicked will change a single value in a DATA TABLE.What would be the best method to do this? Should I track when the CURRENTCHANGED event occurs on the BINDING NAVIGATOR.I'm thinking that I could trick this by BINDING the SINGLE FIELD to a HIDDEN TEXTBOX and when that textbox CHANGED event occurs mess with the radio buttons and visa-versa.
View 5 RepliesWhile I understand there are properties of MailItem that would allow one to programmatically create a formatted email, I would prefer the ability to copy the body of an email that is already formatted to my liking (bolding, italicizing, embedded pictures/tables, set margins, etc.) copy and paste it to a newly composed email such that this formatting is preserved.
View 4 RepliesI've got a piece of code in a project (MyProject) that contains early bound object from a referenced assembly (We'll call it CommonAssembly):
Dim myObject As CommonAssembly.MyEarlyBoundType
now I have another assembly that is dynamically loaded because it is not present in all projects:
Dim myLateBoundObject As Object = AppDomain.CurrentDomain.CreateInstanceAndUnwrap("Utils", "Utils.MyLateBoundType")
MyLateBoundType derives from CommonAssembly.MyEarlyBoundType, and I want to cast myObject to myLateBoundObject and then programmatically invoke the additional
[Code].....
how to bound datetimepicker to dgv
View 3 Repliesi have 3 textbox and 1 listbox bound to the same datatable. when i insert new row to the datatable, there are 2 rows affacted in datatable, one row in datatable is replaced by the newly added row, and this new row is also insert into the end of datatable, while this modified datatable is updated into the database, only the inserted row is updated, the other modified row did not affacted in database.
here is my code:
Private Sub Form1_Load(ByVal
sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim DA As MySqlDataAdapter
[code]....
I try to add now value to DataGridViewComboBoxColumn is already bound is there any way to do this at
its like add "AddNewItem" at the bottom of my dropdown list
My overall goal is to add fake/unbound items to a listview control (for final HTML Table output reasons). This is a code behind solution. Users will not be adding items as it will be outputted in a rigid table.
I have looked at several examples and while this is easy for a dropdown it is not for listview.
The code below works without error, but my item is not shown on runtime. I think the class is not setting the item fieldname correctly, but I can't figure out the right syntax to fix it.
ColumnNameAList.DataSource = PeriodDataView
ColumnNameAList.DataBind()
Dim test As New Example1("ColumnNameA")
[Code]...
I just want to know the right practice for database application. as of now i am creating a simple database application where the database is all bound to the control for minimal coding purpose. is it a good practice?
View 3 RepliesI have bound an array of a class with 3 public strings.
When I run the form app and in the form load call I bind the array to the DGV all works fine and the DGV is fully populated. However, if I change an item in the array I had expected it to change in the DGV.. it doesn't. Or rather, it only updates if I click on the cell that should have changed.