I'm having trouble on how to code this. First I need to assign a value for every item in the list (1 for the first item, 2 for the 2nd and so on). Does this control have a separate field for the value aside from text?
Second, I need to insert this into my database(MSSQL 2008) in this format:
insert into table values(ID,selectedvaluegoeshere)
I have a problem with my program, and it's really bad because I need to burn it to disk within 12 hours and I can't get it to work: If I create a record, add information to it and click on Next Record, the ID, Status and Notes boxes content will change but the rest of the controls contents are carried over to the next record and I don't know why or how. It was working perfectly but now it stopped and I never done anything.
View 8 Replieshow do you insert new record in the datagridview coming from what the user insert in the textbox?
I tried to used the INSERT INTO -- sql query, but it didn't work..
i have this code to open a record and this working if there is any, but if no records it will come out with error
[Code]...
I am using Vb.net 3.5, An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in System.Windows.Forms.dll
Additional information: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
This exception is coming when control is trying to added into the page i.e Me.Controls.Add(CntrlName). I have registered.Then also i am getting error.Please help me.Its urgent.
I am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage. i want to check it after entering whole name
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Try
Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
[CODE]...
I am populating a combobox with a list of names that are coming from a database. I would like to get the names to show up in the combo box in alphabetical order. [code] There is also another combobox I'm populating with text from a database. (as below). However, in the database, in the column I'm reading data from, there are a few duplicate rows and then when the combobox is populated, the same text can be seen 2/3 times. What can I do or add to my existing code, that will ensure that there is no duplication shown in the combo box? [code]
View 3 RepliesI know how to cut off characters at the end of a string using vb script, which uses the LEFT(string, #) syntax, however, how do i do this using vb.net?
and my second question, I have a string being sent into a drop down menu that gets the data pulled from an access database using a data source control. How do I format it so say, it only shows the first 100 characters of that string in the dropdown?
I have records in a database. Each record has a Picture path in it eg. "C:\Pics\Image1.jpg". I would like to display a record from my database and also the picture for that record, in a .rdlc report in vb .net 2008. i have succeded in displaying the record but just can't get the picture to show. I am using an Imagebox in the report.
View 2 RepliesI have a access database with these columns. USER_ID,COUNT,TIMES
Let say the current record is this:
USER_ID,COUNT,TIMES
STEVE20,24,1.5
Now I want to updated the current count record and times, but before updating I want the old record to be added to the new record. What should be my query?
how to view the next record and previous record in the database.? just like in the picture below.? what condition should we use.?
View 8 Repliesi have got a checklist box and i have bind it with value like menstioned below
Dim strquery As String = "SELECT Pk_ProcessID,Fk_ClientID,ProcessName,mc.ClientName FROM M_Process mp JOIN M_Clients mc ON mp.Fk_ClientID = mc.Pk_ClientID ORDER BY mp.Pk_ProcessID"
cnn = New SqlClient.SqlConnection(strConnect)
[code]....
I have data in an arraylist and i want to add data to checklist box on runtime and i also want to display a textbox besides it so that i get the comments
example :
checklistbox "text" textbox
checklistbox "text" textbox
checklistbox "text" textbox
checklistbox "text" textbox
checklistbox "text" textbox
i am currently doing a checkboxlist that is retrieved from database. is there any way where i can sort the checklist items in a way like those checked itmes will be displayed at the back then those that are not checked will be moved to the top.
View 4 RepliesFor the assignment that I'm doing, there's certain skills I must demonstrate in my assignment. There are some standard ones, and some optional ones. The more optional ones I have, the better chance I have at achieving an A.Problem is, some of the things on the list are a bit wierd, and after Googling them, I still have no idea what they are. I will list them, if you could perhaps tell me what they are and how they work anInput Mask (Actually, I know what this is - when people input information, it's a method that inserts in the information in the correct frormat (eg. dd/mm/yyyy) but how do you do use this in Visual Basic?Use of procedures or modules
Optional
Validation rule andappropriate validation text message
Validating data input entry (eg data type, appropriate value, required)
[code].....
I am developing a .Net application that populates a checklist by querying the directories inside a "base" directory (this part already accomplished). The purpose is to show these directories and allow the user to "check off" the directories they want to delete, and then click a button to delete just those directories (this is the part I'm stuck at).My checklist populates, but how would I go about deleting just the directories that get checked?There is one more thing. Each of these directories might have a log file (of the same name) inside the "base" directory; this corresponding log file should also be removed.
View 2 Replieshow would i tell if user checked a box in the CheckList Box? Im going to have alot so i need to keep it neet and tidy so it looks clean.
View 3 RepliesMy checklist is doing a autopostback on selectedIndexChange event. I need to know how to get the item that was just selected that invoked the postback. I tried using selectedvalue,selecteditem, selectedindex, but they all give me the lowest item in thecollection and not neccessarily the item just checked
View 2 Repliesi know how to add items to a list box box if all controls are on one form but for space reasons i'm adding items/urls into a text box on form2 then when i click OK the items are supposed to be saved/stored in the checked list box on my main form.
View 5 RepliesI am trying to build an application using vb.net that will serve as a very large checklist of sorts. and i'm not exactly sure of the best way to do this. I considered using a database but i would need it to be self contained without having to rely on a server or internet connection
View 4 RepliesI am planning a three form checklist/status report for a FEED template. Each form will address a different FEL. FEL1 is really a simple checklist and is easily dealt with using the Windows Form. My question is there a better structure to handle the more complex FEL2 and FEL3, like the web page? FEL2 will have approximately 20 questions and FEL3 will have about 50. I am still undecided whether to use radio buttons (radio button list, which I do not understand yet) or text boxes that will take a value between 0 and 10. I may weight the questions to give an overall percent complete that I can show on the progress bar or some such. If there is a better structure than the Windows form, can it and the Windows Form be linked? If not, will abandon efforts to complete current FEL1. Conceptually, you cannot start FEL2 until you have completed FEL1, and FEL3 until FEL2 is complete.
Public Class FrmFEL1
Dim PctCmpt As New ProgressBar()
Private Sub CboxChrtr_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CboxChrtr.CheckedChanged
[CODE]...
This is what I have so far. It is no working at all. No values appear when boxes checked. Would like a value for each checkbox that can be added in in order to get a total. That total to be added to the percent complete (TxFEL1).
I had actually getting LINQ to work but I am past that now but I was wandering if anyone could help me what I basically have is a DropDownChecklist user control I made and the contents of the list are filled by LINQ getting a list of company names see below:
'Population for company filter box
Public Function GetCompNames()
Using DC As New DataClassDataContext
Dim comp = (From C In DC.Companies _
[code]....
Would you suggest using a public array or something to store the companyID's when populating the first list box? This just came to me at the end of writing this post. Will try this but not sure if its the right thing to do.
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
I want to add to my site a simple table/excel-like feauture that will display some values. So, I added a gridview. I don't use Datasets or database biding at all. All I have is a small form with two entries. When the user clicks a button, I want to add some values to the datagridview control as a new row. How do I add a new record to datagridview control in VB.NET?[code]...
View 2 RepliesI'm using Visual Web Developer 2008 Express Edition and I need your assistance since I'm new to it. I want to insert a record into my listview control of my asp.net webpage using c# or vb.net codes. Here's how it works, if I have four textboxes and I'm going to fill each textboxes so I click a command button I want to insert the value of each textboxes into the listview control.
View 1 RepliesI need to record all the sound that is made from a flash swf in vb.net. I don't mind how I do it but I don't want to record all the sound from the whole computer through the sound card I only want the sound from my program. Doing it through a webbrowser control with the swf embedded in a html page is fine or just recording all the sound from my form.
View 3 RepliesI would like to save records in my unbound datagridview to a table in my database. The datagridview was manually created during design and is not bounded to any table. After the user has filled in the rows and columns, I would like all the rows to be inserted into the table. How do I go about this?
View 11 Replies1. I am trying to sum up a record in ListView1 called NumberInStock and have that value added to a text box called txtInventoryTotal. I have been playing with code to do this and have come with something that is placing a result in my text box. The problem is that it is the wrong answer.
On my first attempt, I went through and created a new function called InventoryTotals() that calculates the sum of the NumberInStock but couldn't get it to display in the text box.
2. In ListView2, I want to show a location and then have the NumberInStock show a subtotal for what is available per location. How do I go about doing this? Do I have to create a connection to the database every time I want to accomplish this? Right now, doing that causes errors in Vs 2005. If i have more than one connection trying to access my database, it tells me that it cannot establish a connection to the database.
I have added a screenshot of my application in hopes that it gives you an idea of what it is I am trying to do.
Option Strict On
Imports System.Data.OleDb
Public Class Form1
[Code]......
i want to control the functionality of moving the records thru binding navigator in vb.net
for example, on click of next button in navigator, i want to check some condition, if condition is true then move to next record otherwise don't move.
I am trying to add a new record to a database using VB.net. I have used code for one table in the database which worked and then copied and pasted it and changed the column names to the ones in the other table and then I got an error saying that the insert into statement was wrong even though I am using a comand builder. [code]
View 4 Replies
