I have created a query off a dataset with a where = @param. This poulates a dgv.
I then have created the parameter by using the Parameter collection editor.
Then on my form I have Textbox1.Text that has the value I want to pass to the parameter @param.
How do I get that value in to the @param?
I have an access database that I would like to add a row to. Contents of the row are entered through text boxes. The problem I am running into is the data is not being saved to the the dataset. It only saves to the TableAdapter and is visible in DataGridView.[code]
View 1 Replies[code]its show me that it have written the command but when i stop the program and see my db its is not there. i've searched the net and alot of books but i cant seem to make it work.
View 1 RepliesI am working in vb2008.TableAdapterManagers are a new feature in vs 2008 and I would like to understand how to use them properly.I have about 30 tables in my database that are unique to themselves and donot link to other tables.I have created a dataset.xsd in my solution and dragged in my database tables of interest.A unique datatableadapter has been identified in the dataset1.xsd for each datatable.Rather than using the identified datatableadapter for each datatable operation, should I be using the dataadaptermanager for each unique table?
View 1 RepliesI am writing an application that does a number of different things with data downloaded from hardware which is monitoring the power used in my home and produced by my PV Solar array. I have run into a roadblock early on, because I cannot seem to get new data into an Access database that I have linked to my application by means of a DataSet. I have checked the DataAdapter's InsertCommand, DeleteCommand, and UpdateCommand definitions (created by the DataSet Wizard), and they seem to make sense, and nothing is throwing exceptions or otherwise making VB complain, but new rows added to the dataset are not being added to the database.
[Code]...
If I have a variable, X, of type SqlDecimal, that was instantiated without providing a decimal value parameter to the constructor, then the .IsNull property is True: Dim X As New SqlDecimal '.Value = Null..If I have a Stored Procedure that acepts a single parameter, @SqlDecimalParameter, of type Decimal, the value of this this parameter could be NULL or a decimal value. This is how I would normally call the stored procedure:[code]It seems like the 1st example should work. Am I missing something? after all, the Sql datatypes are designed to work with SQL Server, I thought.[code]I get the following error:Failed to convert parameter value from a SqlDecimal to a Decimal.It works when X.IsNull is True.How do you set the value of the PARAM object when it can be NULL?
View 1 Repliesi've got a Class like this public Class Cart(Of Item) Public Sub New(ByVal a As Integer, ByVal ParamArray items As Item())but i do not see how to create an instance of it: Dim block_names As New Cart(Of String, 5I)i get something like "type expected" o.O
View 2 RepliesI've a HTML page and i need to pass some value to my aspx page.
Since the url got a maximum length 256, i need to use <param /> tag to help me pass values and also get values from aspx.
(the numbers of param is not fix)
I've been searching days for the example how to get this done.
I have the following VB.NET function, for example:Public Function MyFunction (Of TData) (ByVal InParam As Integer) As TDataEnd Sub
View 5 RepliesI'm converting some RDO code to ODBC Provider code in .NET.The problem is parameter names were not specified in the orignal code, but param values were retrieved by parameter name after the command was executed.Is there anyway to have parameter names populated by the provider once the command is executed so calling code can access params by name.Let me show you an example of the declaration of param and accessing of it.
[Code]...
You can now see how this "used to work in RDO/VB". For some reason it would accept this and know what the param names were after execution. I imagine it had to do another round trip to the db to get this info.
Is there anyway to mimic this behaviour in .NET for ODBC Provider (using Oracle)? Or am I stuck manually specifying the param names in the code (I understand this is the better option, but wondering what the alternative is to match the original code as closely as possible).
We're in a strange situation with a legacy winforms VB.NET 1.1 application using ASMX web services. Trying to send a user Token from a WindowsIdentity object as a parameter to a WebMethod. I will be adding a 'HACK: comment. System.Security.Principal.WindowsIdentity.GetCurrent().Token
The token is of type IntPtr, the first problem is the WSDL being generated doesn't support IntPtr with the error of 'unsupported type'I'm aware this is a big WTF question and sounds insecure, so any simple helpful alternatives are welcome but there are a lot of constraints on how we can change this system, including complications with the hosting environment. So I would just like to get our piece of data over to the web service to save a lot of other headaches.
[Code]...
Imports System
Imports System.Threading
Imports System.ComponentModel[code]....
how to declare "smsport" on class smscomms as public so that it can be access in class form1 or button1_click event.
I cannot figure out how to convert this code from C# to VB.net. It says - Argument not specified for parameter 'y' in the calling code below.
[Code]...
I am developing a web mapping application intranet from our company. And I am creating add polygon function on the map. I use AspMap, Vb.net and sql server. So when user click a button for add new record therefor out the web form input data attribute. When i run the application I get trouble like this Incorrect syntax near '?' My code is:
Private Sub AddNewShape(ByVal checklist_id As String, ByVal type As String, ByVal shape As AspMap.Shape, ByVal address_area As String, ByVal dmz As String, ByVal customerid As String, ByVal source As String, ByVal area As String, ByVal instalatur As String, ByVal developer As String, ByVal data_received As DateTime, ByVal doc_data As DateTime, ByVal datereport As DateTime, ByVal remark As String)
[Code]...
I need to pull from an access database to populate a combobox. Then from there I need to have a second combo box populated depending on the selection in the first box. My thought of an example would be a website that is setup for selecting car make, modle,year...can that be done in VB?
View 1 RepliesI have asked this question before but didn't get any help. I am going to try to rephrase it a bit.
I have 5 input boxes; let's call them chck1, chck2, chck3, chck4, and chck5.Each input box has an associated checkbox, let's call them chckbox1, chckbox2, chckbox3, chckbox4, chckbox5. These are in a section called '*Step 3****
THe spec is that if you enter a number into one of the input boxes and check the associated checkbox in Step 3, the number gets populated into the corresponding box in step 4.
For instance, if i check a checkbox called chckbox1 and enter a number into chck1 in step3, that number gets populated into chck_amt in step 4 as long as the checkbox next to the inputbox in step3 is checked.
If a number is entered in any of the boxes in step 3 but the associated checkbox is not checked, the number doesn't get populated into the corresponding box in step4.The issue that I have so far is that if I check a box FIRST before entering a number, the corresponding box in step4 gets populated.
If, however, I enter a number into a box in step3 BEFORE checking the associated checkbox, that number does NOT get populated into the corresponding box in step4.Does anyone know how to ensure that whether a number is entered first in step3 or a box is checked first, as long a box is checked, that number needs to get populated into the corresponding box in step4.
[Code]...
I have tested the code for the DataSet and DataAdaptor and both work fine, and as test was able to place the MaxRows variable into one of the text boxes on my form so I know thats all ok. But I am now trying to use the function below to copy the 1st cell of each row into a combo box to populate the options and comes up with a null exception error but cant get my head around it.
[Code]...
i know how to do this in vb.net? to populate datagrid in vb.net?like in the vb6
View 1 RepliesI'm working on a project for personal use to make my life as an IT administrator a little bit easier. (Yea right)So basically, i'm creating a windows application with a form. On this form, it has a button, and a listview.When they click this button, it will load all "Windows XP run commands" into the list view. I also, have a on-click event to capture a click on certain lines in which it will automatically open said run command, or shortcut.
Here is an example of what I am working with so far. (It populates correctly, and the clicking event works like a charm. However, i'm just looking for a better way to clean this code up, or maybe, a better way to go about everything).Once done, I will populate this to the codebank if there isn't another similar thing out there.
On to the code:This is what I have for the form_load event
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
With ListView1
.View = View.Details 'Changes the view to "detailed" view
.LabelEdit = True 'Allow user to edit text
[code]....
I want to populate my asp:table with the contents from my SQL query. The page loads but with nothing in the table.
<%@ Page Title="stuff"Language="vb" AutoEventWireup="false" MasterPageFile="~/Site1.Master" CodeBehind="stuff.aspx.vb" Inherits="WebApplication1.WebForm1" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Net.Mail" %>
[Code] .....
I'm trying to populate a list box with XML so that when the user clicks on a list item it them populates with the next set of elements.
View 1 RepliesI'm trying to populate a combo box with some data from a xml document, but so far all i'm getting is this error message in the combo box[code]...
View 2 RepliesI have my mysql query selected fields (item_code, item_name, item quantity, item_selltype, item_selldetail) but some of these fields are variants.
Dim sqlConn As String = ("SELECT item_code, item_name, item_quantity, item_selltype, item_selldetail FROM qa_items")
Dim objDataAdapter As New MySqlDataAdapter(sqlConn, objConn)
[Code]....
I have created a sub that I am using over and over again. However, I am not able to get the values from the database. Screen shots and code attached. I need a second pair of eyes, can't seem to figure out what is wrong.
Form Load
vb
'Populate the drop down lists
PopulateDropDownListFromDB(cboReferrerType, "ReferrerType", "ReferrerName")
[Code]....
I select first value from a combobox1 but combobox2 was not populated corresponding to value selected from first one. Again I select same value now combobox was populated
View 2 Repliesthe information displays in the datarepeater correctly when loading the form, but i can not get new data to be displayed, (when saved to the database) no matter what i try. I think it is just beyond me.here is the code for which i import the initial data into the datarepeater:
Function test()
Dim bsStaff As New BindingSource
Dim dtStaff As New DataTable()
[code].....
In vb 6 I have on my form two listboxes I also have a dao data control called Data1 My database is in access and is called SampleDB.mdb
My code in VB 6 is as follows
Private Sub Form_Load()
Dim RI As String
Dim CurrentDB As String
[code].....
This simple code populates both List1 and List2?
I have a Report I created with Visual Studio's VB.Net ( I guess this makes my report embedded), which I can select a date range like starting and ending date but the drop-down listbox for the Name is empty and I have to type a name into it to work. I need to be able to choose the name because I won't know who is on the list.
View 1 RepliesI have a parent table called users which stores all the user info with a prime key field called ID. Now in the child table which has a seperate foreign key associated with the ID field in the parent table.
What I would like to do is be able to populate the foreign key once once the user uploads data into the child table with the user ID it has.
So far I have created the associated foreign key with ID field in the user table and also programmly through data-relation related the table but now sure on how to get the value from the relation.
The foreign key in the child table is called 'U_ID' as shown in the snipet velow.
[code]...
I don't have access to VB.NET right now so I can't test this value:Dim lst As New List(Of String)(cookieValue.Split("$"c))i got this from another question , but was wondering if A. The list will populate correctly and B. What does the c represent?
View 2 Replies