I cannot seem to figure out how to search through a created/filled dataset for a certain value which exists in column(1), returning Column(0)'s value into a textbox.My code looks like this:
[Code]...
I have written the following stored procedure: ALTER PROCEDURE ProcGet Add the parameters for the stored procedure here @id as int output, @name as varchar(50) output ASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;
[Code]...
i have a dataset that filled by this query :
SELECT Invoices.ID, Invoices.invoicenu, Invoices.pdate, InvoiceList.icaption, Invoices.icaptioncode, Invoices.ccode, Invoices.postedbill, Invoices.billnumber, SUM(InvoicesDetaile.price)
AS Tprice
FROM InvoiceList INNER JOIN
[code]....
a datagridview is showing dataset data and user check checkedcolumn of datagridview (postedbill filed) and after user mark a few rows , i want update (invoice table) in database .
How do I save my dataset ,that is being filled in runtime, to a Microsoft Access database file (.mdb)?
View 3 RepliesI have a combo box that is "linked" to dataset.
I have a Label that I want to return the value from 'Description' Column from 'Base' Table.
This is determine when user has chose a value from the combo box which is linked to the 'Base' Table from 'Material' Column.
Public Sub checkemail()
sqlcheckemail = "select Email from WEBUSER where Email='" + TBEmail.Text + "'"
Dim dscheckemail As New DataSet
[Code]....
if u see the one that i've commented is the one i already googled at tested...so now if the email address exist in the db..everything works wonderful..but if it doesn't exist the code should process the one that does not satisfy the first if statement...but now i'm getting the result as "There is something" eventhough the email does not exist in the db...
I have a strongly typed dataset that has rows with duplicate [sopnumbe] I am looping through them and displaying row data I want to only display the Distinct sopnumbe rows in my initial loop1.. but the sub loop uses the data out of all rows.. So I cant filter the actual dataset.
[Code]....
I have two functions in a class. One function returns a datatable, the other one returns a dataset. Both functions are identical except of the return type (Datatable or dataset). I would like to have only one function which returns either dataset or datatable depending on what the user of the class wants. How can I do this.
Following code shows my function returning a datatable:
Public Shared Function ExecuteSPDatatable(ByVal storedProcedure As String, ByVal ParamArray parameters() As SqlParameter) As DataTable
Dim tbl As DataTable
[Code].....
I want to define a function similar to:[code]My current definition is having an issue with the following statement:GetList = (From x In oDS.Tables(0) Select New T(x)).ToList.I can't figure out how to get to create a New object of type T, any suggestions?
View 2 RepliesI'm trying to get VB6 to access an Oracle (9i) procedure and return a dataset without much success.Not used VB6 that much but I need to do it for this application as we are not able to install the .Net framework on this particular server.Oracle procedure has an input param and an OUT param which is defined as a sys_refcursur
CREATE OR REPLACE PROCEDURE "LOGMNR"."LM" (p_filename in
varchar2, p_recordset OUT SYS_REFCURSOR)[code].....
I get the same error message regardless of wetheror or not the second output parameter is enabled.3709 The connection cannot be used to perform this operation. It is either closed or invalid in this context.how to return a recordset from Oracle to VB6?
I am trying to populate a combo list box with the results of a web service. The web service returns a dataset with two columns. I want to display column one to the user and capture column two with the user selection of an item from the combox.right now I can display the first column and capture the selection.Not sure how to add the connection of column two, to the combo box and capture the selection
Code so far....
myDataSet1 = proxy3.listSuppLang()
Dim x As Integer
[code].....
I have an ASP.NET web application (VB.NET) using an Oracle database. On an insert, I need to get the identity of the inserted row back. I am trying to use RETURNING, but I keep getting a value of 1 returned.
Dim strInsert As String = "INSERT INTO L.TRANSACTIONS (LOCATION_KEY, TRANS_CREATOR, TRANS_EMAIL, TRANS_PHONE) VALUES (:location_key, :trans_creator, :trans_email, :trans_phone) RETURNING TRANS_ID INTO :ukey"
[Code].....
My brain may just be fried since it's the end of the semester, but my teacher kicked this back to fix and resubmit...she said that I am "returning the name of your function rather than your variable name".
Here is my code for all 3 forms.
code:
These are forms to calculate the cost of getting a cell phone package.
I've been looking all over for code to check that all the textboxes on the form have been filled in.... I've found this code in slight variations which people said worked fine
Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl is TextBox Then
If ctl.Text = "" Then
[code]....
I've attached this code to the click of a button and even with all fields empty nothing will happen!
I have 4 textboxes - txtResFDB, txtResPBV, txtResRSLP and txtResTCD..
i need to check that any of the two textboxes should be filled up out of 4.
We are filling a combobox with information of a table. (we read a field for filling the combobox and the id)
It's necessary that if we choose an item in the combobox we also get the id of the table.How do we put the id into the combobox so can read this id after selecting an item.
If Page.IsPostBack = False Then[code]...
View 3 RepliesThe program consists of making 2 text boxes, one labeled Age, and one labeled Name.The Name text box must return the name in all uppercase.If the Age text box isn't filled with a numerical value, you should receive a message saying "need a number" and return your cursor to the age box.2 command buttons "Process" and "Exit"
I tried getting started, but I usually always work better when i have a beginning!
I have 2 textboxes where the values are filled with this code(the data is collected from 2 different
[Code]...
When I now tries to update the data in the box743 i get an error. Who says that I can not convert the strng to double.I use the tableadapter to update the database and both box498 and box518 updates without problems.But when I try to upgrade the 743 box I get the error.
This is the situation when there is a shift change and one record is started by one person and finished by another. What one has written another can't change but must finished a record. So u must lock only the combo boxes and text boxes that are filled. This code lockes all the combo boxes and text boxes and 2 check boxes (NEZAVRSENE_INTERVENCIJE and IZMENA_RASKRSNICE) by clicking on a NEZAVRSENE_INTERVENCIJE check box. Lets say I have combo boxes 1 2 and 3 and text boxes 1 2 and 3 and I have to lock only the ones that are filled. How do I code that another check box lockes just the filled controls?
[Code]...
I have a form and it is databound to a Access table with the standard TABLEADAPTER wizard. All works well HOWEVER, new records are not displayed in sorted order.When I add a new RECORD, it can go anywhere within the table. When I move around the table using the TABLEADAPTER Manager, the newly added record does not appear in sorted order.Furthermore, when I restart the application and show the form (which issued a FILL command), the records are not sorted.The SELECT I am using is fairly simple:
SELECT [list of fields] FROM TableXYZ ORDER By [sort field]
This HOWEVER, does not appear to work.get the table to be sorted when filled?Other information - the table in question has the field that is specified in the ORDER BY clause which is the same as the Primary Key.As an example, in the table there are records with the following KEY:
4313, 4314, 4315
When I insert a new record, it might fall between 4313 and 4314. Lets assume I add 9999. I expect it to be at the end of the list however, it appears between 4313 and 4314.FYI Also tried this in the code as well:
TableBindingSouce.Sort = "field1 ASC"
I have 3 textboxes. I want Button3 to remain disabled until ALL three are filled out. This seems to work, but for only ONE textbox:
If Textbox1.Text.Trim <> String.Empty then
Button1.Enabled = True
Else
Button1.Enabled = False
End If
I have a checkboxlist that is filled with items from an array. I want the user to be able to select the items they want to remove then press a button and have the items be removed from the array. I have never worked with a checkboxlist before so I'm not really sure how to go about this. Here is what I have tried so far:
[Code]...
When I re-display the array into the checkboxlist it shows that nothing was removed from the array.
I have a CheckListBoxthat is filled with items from an array. I want the user to be able to select the items they want to remove then press a button and have the items be removed from the array. I have never worked with a CheckListBoxthat before so I'm not really sure how to go about this. Here is what I have tried so far:
Private Sub btnRemove_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRemove.Click
Dim TempNameList As New ArrayList
If cmbRemove.SelectedIndex = 0 Then
TempNameList.AddRange(NameList)
Array.Clear(NameList, 0, NameList.Length)
When I re-display the array into the CheckListBoxthat it shows that nothing was removed from the array.
How can I control what is filled into the table adapter at runtime? Basically, I have a table full of thousands of rows, and I want to limit this to just 1 row. I want to specify an ID number and be able to pull up that row in the table, and I need to do this at run time. What are my options, and what is the easiest way? I want to make sure the data is still linked to the original row in my database, that way the changes are saved properly.
View 5 RepliesThe strings did not filled the items on my datagridview using with system.data.table. When I click the button, nothing are going to fill on my datagridview table.[code]...
View 1 RepliesI'm fairly new to visual basic and have a problem that is probably quite easy to solve yet I have been unable to do it so far and am about at wits end.I have an access database with a table that contains a list of cities and states. what i would like to do is to populate a combo box on a vb form with a list of the states in the states column. the query that i have is as follows:
SELECT DISTINCT State from Cities I have previewed the data in the dataset designer and it works, i just can't figure out how to make it fill the combo box. i initially created a table with just all of the states and then used a binding source and table adapter to bind it to the combo box, but if I'm able to figure this out this would help with my application going forward
I used this code:
Code:
Friend Sub PopulateCB(ByRef mycontrol As ComboBox, _
ByVal expressionSQL As String)
' DMBD is my data-handling class:
[code]...
Nevertheless, mycontrol remains empty after this.
I have an array Newstr(20) When I fill it, I need to know how many of its indexes has been filled ? and find out the values.
View 3 RepliesI used this
[Code]...
Nevertheless, mycontrol remains empty after this.