I'm building a tool for our techs and I cannot get the search function working.Basically, they will be looking up hotel sites information by their unique identifier "HotelCode" (ie: "DOTH") which they need to put in a text box.My dataset is setup to filter by HotelCode = '@HotelCode'How do i pass the user input from the text box (id: searchTextBox) to the param in the dataset?
View 1 RepliesI have all my data in a dataset but i'm wanting to show only some of this in a datagrid. I know I can open up "Search Criteria Builder" as shown in my image but how can I add a program virisable into this for example
SELECT ID, ShortName, LongName, Manufacturer FROM Aircraft WHERE FirstFlight > CurrentGameYear
And CurrentGameYear is a Public variable in my application.
I have a list in detail view that (obviously) lists information. I want to edit an Item if it is double-clicked on. I'm not sure what the best way to do this is. Currently I have this:
Private Sub SoundList_DoubleClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SoundList.DoubleClick
index = SoundList.Items.Item(SoundList.FocusedItem.Index).Index
[code].....
Once I have filled a dataset is there a set of properties or in-line functions that will allow me to pull the data out of said dataset without having to populate a datagrid?
Code example:
Connection.Open()
accCommand.CommandText = "SELECT CustID FROM Rental WHERE DvdID = " & DvdID
accCommand.Connection = Connection
dvdDataAdapter.SelectCommand = accCommand
accCommand.ExecuteNonQuery()
dvdDataAdapter.Fill(dvdDataSet, "CustID")
Connection.Close()
I know the information returned from the query is a single value located at (0, 0) I just can't get to it so I can assign the value to the variable.
Using Visual Basic 2008 Express. I need to pass a variable to another form. Or else make the variable visible to both forms.
View 4 RepliesI have one form, which the user enters upto 5 websites then clicks go - I have on the second form, the one with the webbrowser. timer which checks if the web browser is busy then either a green light or black image will be shown along side the assocaited input box on the first form. I am finding it impossible to feed variables into the clock through ByVal, like I would a subroutine or function.
[Code]...
I have a certain subrotine where I excute a sql query and save data into a certain dataset, in another subrotine i need to make use of the data in the dataset i've just made by filtering on certain data in order to fasten my program rather than re-execute the sql query again that would take much time.
View 6 RepliesI have two charts one of residents and another of payments, I want to unite them by a parameter that the user enters to show the result. I have written this
SELECT CasaNum, FirstName, LastName
FROM residents
WHERE (LastName LIKE @LastName)
but when writing this code in the button me the error Me.ResidentesTableAdapter.Fill(Me.Por_apellido_DataSet.residentes, LastNameTextBox.Text)
I have two subroutines that consists of two datasets. I am not sure how to pass some data in first dataset named dsGoodStudent to second dataset named dsBestClass.
Private Sub Classification()
Dim SqlSelect As String
SqlSelect = "Select Name, Age, grade from tblStudent where grade = 'A'"
[Code]......
Is it possible to pass a variable set in one form to another?
View 12 RepliesWe can easily pass a DataSet with a single table from one form to another,
View 2 Replieshow to pass a parameter to a predefined parameter in a dataset. I've found everywhere a solution if you build the sqldata adapter and the dataset in the code. Then you can pass the parameter like: da.SelectCommand.Parameters.Add("@param1", SqlDbType.Char).Value = param1_variable (as example)
But if you have builded a dataset (with table adapters), and then in the form app you want just to pass the param1 to a DataGridView1 (as example) which is using the table adapter, I did not find how to do this.
I'm currently working on this search page. I'm using access database, InventorySystem.mdb, tablename is ALL. On this webpage I have 5 radiobuttons: All, Status, Requestor, Group and Applications. A textbox: to input search text A button: A search button to generate gridview So for example I will select status, then I will input "live" and click the button. All the data which status = live should appear in the datagrid. How can I do so?
View 2 RepliesI'm looking for a way to search a string variable for two words and copy the text in between them into another variable. This needs to be done as many times as the match occurs.
View 3 Repliesok to start i know very little about VB6 but i am very good in true basic lol (stupid school teaching the wrong language -_-) anyway im just asking you to make the answer as clear as possible because i don't know very much. heres the problem . ok in the above example i have a button that (for my example) can be used to build a house (lol) i then have a variable in the button sub called money which will have 150 subtracted from it when the button is clicked my problem is it say variable not defined when using this button ... i have declared the variable in a module and in form load along with my other 50 or so variables. my question is how do i pass the variable into this sub and then send the new value back into form load so it can be sent into another sub for more calculations.
View 14 RepliesI currently have the following funcion:
Public Sub GetUserAmount(ByVal ConnectionString As String)
Dim command1Text As String = "SELECT Wager FROM Donations1 WHERE DonationId = (SELECTCOUNT (BidCountHistory) FROM BidCountHistory)"
[Code]......
I need to pass a variable by name like this
Dim html_news = "...the news ..."
Dim var = "news"
Dim a = "html_" & var
' content of that variable
How can I do that in VB.NET ?
I am currently trying to teach myself how to program VB.Net in Visual Basic 2010 Express.I've been working on a little project for a while and have hit a wall. Normally I can find what I need online but I am now at a complete loss. Essentially I am trying to pass a pair of variables from Visual Basic (file names actually) to VBA so that I can copy/paste data from them using VBA. What I need is to find out how I can pass variables (in string form) back and forth between VB and VBA
View 13 RepliesI have a Public Sub where I declared
Dim Elev As Double
later under that Sub I have the program go to anothrer SubRoutine that uses the same Elev variable. Within that subroutine I get a Variable not declared error. My book talks about using "Static" but in the context i guess I am using it, it hasn't worked.
What is the best method of tranfering the information from one sub to another.
I am using VS 2008.I have an application that has a variable defined as an Application Setting. I use this variable to define the connection string so I can change the location of the database withour having to recompile the application.My application references a class library. The Class Library is the one that manages the database. The DLL is referenced by my application.How can I make the class library use the Connection String defined as an Application Setting of the consuming application? If I say in the class library:sdRadhaAllied.Schema.Connections(0).ConnectionString[code]...
View 4 RepliesVS 2008, .NET 2, Win XP I need help with passing a String variable from App to DLL?Why: I have App that on UnhandledException needs to call ErrorReport dll, send to that dll some strings like: App name, stack, error... Dll will send through internet this gathered data to me.
I can open Dll, close it, code it, but I can not figure it how to send data to it like VB App name, VB App version, VB App error.message For example I can in my form make a global variable like Public TestGlobal As String and that I can call from anywhere in my app, but how to do it with dll?
[Code]...
I have created an application in which I have to make a report with ReportViewver from Microsoft.Everything ok until now. I have created the report and for this report I have created a dataset. This dataset contains data for every month in every year from 2010 to 2015. With this dataset I am populating a graphic but my problem is that I want to select the year and create graphic for one year.I do not know how to insert a parameter in the dataset. In sql is very easy by in Access is different and if I try to put something like ...' where year_column=@year_parameter' I receive an error.
View 3 RepliesI am writing an application that is doing a file conversion.I created a new process in order to run an exe and pass it some arguments in order to do the file conversion. I ran this in the Submit button click event.I added an event handler for when the Process had exited and then continued my code, since I had to wait for the file conversion to complete before continuing.
Everything is running fine now up until the point where I am trying to call a FillBy for one of my datasets. My fill by is accepting a parameter UserID and filling it based on the user id, which is selected in a combo box in the program itself.I keep getting exceptions and it immediately exits the program whenever I try and use this fillby method, if I take it out it completes successfully; however, the new row I just inserted was not added.
I tried adding a tryparse for the value selected from the UserID combobox but I get this cross-thread exception, so I have a feeling the 2 are related.
[Code]...
I'd like to know, if I have a variable,for example, a string, how to pass its value to my new app domain:
static string _str;
static void Main(string[] args) {
_str = "abc";
[Code].....
i have a dialogbox (dialog1) i will assign the input from textbox a variable to the from1 but i cant do that.the variable in form1 is Dim get_from_dbox As Long i try to assign to it from dialog1 like below it fails form1.get_from_dbox = Textbox1.Text but i can assign to textbox??like that which works well
form1.RichTextBox1.Text=Textbox1.Text I am new programing i know i am wrong .don't know where?
How can i pass a global variable from dll project to a exe file, after this i want to run the exe also from the dll.
View 9 RepliesI would like to create this url blah.com/preview?h=yes
so i can do this
<% if request.querystring("h") = "yes" then %>
jquery stuff
<% else %>
don't do jquery stuff
<% end if %>
I have a grid of NumericUPDown fields. When a value is changed, I want the page to update a label at the bottom of a column - its a total line. Everything works, when the page is updated(a button click), but I want it to update real time. as they are changing the updown value... My question, and I have searched and couldn't find it, how do I pass a variable to an eventclick subroutine? Or make the variable a global variable, so it will work in the eventclick subroutine...
View 2 RepliesI have 2 public variables that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. [code]...
View 2 RepliesThis code was working consistently, but now...This code works on the first pass.Then second pass it just hangs on Code:Dim tcpClient As TcpClient = tcpListener.AcceptTcpClient() for about 2 minutesThen the code will fork for another pass, then fail.....
Code:Imports SystemImports System.TextImports System.Collections.GenericImports System.XmlImports System.Xml.LinqImports System.Net.Sockets
[CODE]....