I have an application with a database. I can add, remove and save items but when I want to CHANGE an item and save it, the program gives the following error: Update requires a valid UpdateCommand when passed DataRow collection with modified rows.
I am using "service-based database" from visual basic itself. No acces or something.
whats wrong with my code?if i change the item from the combo box..the textbox not change or has an error?
conn = New MySqlConnection()
conn.ConnectionString = "server=localhost; user id=root; password=12345; database=gigzta; allow zero datetime=no"
strsql = "SELECT accNo FROM accinfo WHERE (completename LIKE '%" & ComboBox2.Text & "%')"[code].....
i want to make program like this:
if DataGridView1.item(SID).value = DataGridView2.item(SID).value then
color=green
else
color=red
i want all item list in DataGridView2.item(SID).value will be checked.
this is my
Private Sub PSCDataGridView_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles PSCDataGridView.CellFormatting
Dim myBL As String
[code]....
Just started on vb.net
I have a combo box with "yes" and "no" with i select Yes i want the label2 to change the text to "yes" likewise with "no"
I've tried to code it in a logical way as possible but it just doesn't works except for the "wtf" so i think that overall my code is correct but the way i want to retrieve the selected item from combo box is wrong.
Public Class Form1
Dim aa As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
[Code].....
I am trying to change an item in a selected item of a listbox.
View 1 RepliesRegarding my college project. i'm working on a sales system . i have a form which consist of all the following information( item code , item name , item price , quantity of item ) which is display using a data grid . data input by user using text box and all this information will be stored in a database(sales database) i'm using ms access 2007. the grand total will be displayed in a text box . and amount paid will be input in a text box too , my major problem now is how to i create a reciept that will have all this information of the purcase. i have a reciept button . what the next step ? i dont have any idea how to get the reciept done.
Imports System.Data.OleDb
Public Class Form5
Dim con As New OleDbConnection
[CODE].......................
Can someone please help me create a very very simplistic sample page as the chat page included is too coomplete. something as simple as detecting a change in the database and displaying the word "change" on screen in realtime for any client connected.and I tried creating a global.asax file into which I added in the line mentioned in the link above, but it does not seem to like the word "Setup" in the line [code]
View 2 RepliesIs there any way to change the colour (background colour or text colour) of just a certain item or item(s)?
View 2 RepliesUsing a plugin architecture, i created a Form Class that holds the Mdi Form. it has menustrip, toolstrip and statusstrip.
child forms are created as class and are loaded into the Mdi Form at runtime.
using interface, i was able to execute subs and functions of a child in the Mdi Form and vice versa.
now i need to change property values.. to be exact, i need to change the enabled property of the toolstrip buttons depending on which child form is activated using the form_activated event of the child form.
the problem i now have is how to change the property of the toolstrip item in the Mdi Form.. should i be using interface on this as well by creating subs in the interface and have the Mdi Form implement this interface?
The code below is from your forum and it gives the error: missingmemberexception?
For x3 = 0 To lstStock.Items.Count - 1
If lstStock.Items(x3) = LastStockCode1 Then
lstStock.Items(x3).attributes.add("style", "color:red")
Exit For
End If
Next x3
I have a list box display on a form. I want to change the forground color of one item using item index. The code "lststock.item(x3).attributes.add("style", "color:red")" does not work. One solution was two pages of code! This s/b simple. I have the INDEX of the list item. I just want to change the words in that item from the color at list build time to red to highlite it!
I'm making a small program in VB.NET. I have a listBox and a button. I'd like to be able to press the button and have the selected listBox item change it's foreColor to green. I've tried many ways of doing this, ranging from overriding the draw method to using a listView (listBox is much better for what I'm doing, please don't recommend that I use a listView, I've already tried it.)At first I thought this would be simple, but it's the exact opposite and I'm very frustrated that such a simple task should be so difficult. I don't want to use any third-party controls, as I'd have to completely re-write my application.
View 1 Repliesis it possible to group similar controls in a form so instead of having to change every control's property I could just change the property for the entire group?
View 1 Repliesi have imported items in a datagridview but i like to know how to change the color of an item?
View 2 RepliesHow to change the system's cursor using VB.NET?
View 1 RepliesOk, i almost finished my music player, but i need one more thing. I have a ListBox as PlayList. It is possible, when i double click a Item to change he`s text color or background color?
View 13 RepliesThis is the xaml of listview
<ListView Grid.Column="1" Height="auto" Name="ListView1" Width="auto" AllowDrop ="True" >
<ListView.View>
<GridView >
[code]....
And How to get the value at second column?
I have tried this code, but it just return the second character of first column, I can't find any ways to access the second column
ListView1.Items(0)(1)
l am trying to do this listbox1.selected item.text =textbox1.text.l am using vb.net 2010 , that syntax doesn't work.l just want to be able to change an item text in a listbox using a textbox.
View 4 RepliesHow would I go about changing the background color or just the last item in a listbox?
View 1 RepliesI have two listboxes. [code]..
I have already achieved above but the main difficult part is I also want numbering in listbox2 to go green or red based on listbox1 item (Corresponding items)
I have two listviews the first one has all my items in it, the second one is for when I click a button and clone an item from listview1 and add it to listview2. Here is the code I am using for cloning.[code]...
View 6 RepliesJust wondering if there is a way to change the style/css of repeateritems from the codebehind. Basically I have a printer friendly version of a page and if the display is printer friendly i want to add a bottom margin to each item in the repeater.Change style of repeater item in codebehind?
View 5 RepliesHow can I change the text of an ContextMenuStrip item which is used by a NotifyIcon? and how can I delete a item form the menustrip?
View 8 RepliesI've turned the web upside down looking for a way to do this.The only thing I found(although I couldn't get it to work) was the example from the documentation, and it's more code than there is in my program to begin with.
There has to be a simply method of changing the BackColor of the selected item in the ListView details view.I know it's selected when you click on it, and you can press the up/down arrow keys and it'll scroll through the items.
I just want to change the backcolor from the default dark blue to something else, with a line or two of code.
I want to change the color of the background of an item in datalist upon some condition while binding the data? How?
View 1 RepliesI am inserting the data through textbox of the selected item of the list box I want the when the user will input the data into textbox and then pressing the insert button the the selected item of list box (selected item only color change) color change white into blue or red.
View 1 RepliesIn the event of SelectedIndexChanged() I need to updated text of an item that is highlighted. If I remove it and .SetSelected again, this event will be entered repeatly. So how to update the text of this item in this event without deselecting and re-selecting it?
View 10 RepliesI am trying to either change the text or preferably the background color of a listview item if it is checked and a button is pressed.
I looked at a few older ways of doing it but it doesn't work anymore
I'm not really sure about how to do this.
[Code]...
How do I change particular item font(or)text color of a Combobox in VB6?
View 4 RepliesI have to hidden buttons on my page that I can trigger using JavaScript (__dopostback...). I also have a list of object on my page and a dropdownlist giving the user the possibility to sort those objects on the page. My code checks the current value of the dropdownlist on Databind of the list and applies the chosen sort method to the list. The first button is triggered when the user has selected another sort method from the list.
The second button is triggered when the user adds a new item to the list. Sortmethod "sort2" should be set automatically in the dropdownlist if this happens. So when the second button has been clicked, I need to set the selected item of the dropdownlist dynamically so I can check the value of the selected value later in the DataBind method of the dropdownlist and know what sort method should be applied.
I don't succeed in changing the selected value dynamically. I'm using to controls: First is the objects.vb and the second is the ObjectContainer.vb. Objects.vb contains the two buttons, the dropdownlist and an instance of the objectcontainer. The objectcontainer contains the list with objects that needs to be sorted based on the value selected in the objects control.
Objects.vb:
Private sortMethod As DropdownList
Private container as ObjectContainer
Protected Overrides Sub OnInit(ByVal e As System.EventArgs)
MyBase.OnInit(e)
EnsureChildControls()
End Sub
[Code] .....
How can I change the backcolor or forecolor of highlighted item in listbox?
View 7 Replies
