I have a form which takes input from the user in a TextBox to display ("contains") record/data on a grid. However, I am unable to achieve the input data thing. I have been trying to solve this for a while now. Dtatbase is MS Access.
Here is my code: I don't get any values in the form grid whatsoever for this query.
Imports
System.Data.OleDb
Public
[code]....
How do I add a wildcard parameter to my query. Im using a mysql database. The following doesn't work:
Dim occCmd As New MySqlCommand("SELECT occupationid,descr FROM occupations WHERE lcase(descr) like '?descr%';", con)
occCmd.Parameters.AddWithValue("?descr", prefixText)
I have created a Web Setup project using VS 2008. I have created a custom action to programatically add a wildcard scriptmap for my virtual directory. The app installs fine, but, during custom action, fails to add scriptmap. I've tried this on Win 2003 server with IIS 6.0 and WinXP with IIS 5.1.[code]....
View 1 RepliesWe have recently updated our SQL Server to 2008 (from 2000). I moved all the data over to the SQL 2008 server by exporting from the 2000 server. All the tables open just fine, and all the data appears to be present. Within the VB.NET app, however, any table reference that uses a parameter generates an error: The data types text and text are incompatible in the equal to operators. The table adapter works just fine with full table previews, but not with either parameters or filter values (i.e., Field1 <> '0'). I should confess that I am new to SQL 2008. What do I need to do to get these parameter queries operational?BTW, I have downloaded and installed the VB2005 plugin that enables working with SQL 2008 (VS80sp1-KB954961-X86-INTL.exe).LDC
View 3 RepliesI am newbee to VB Express and having many problems for displaying different reports from Tables in MsAccess to Listview in Vb Express.
View 4 RepliesWhat I want to do is to replace lets say ##test## with Something(test)..I know that I can find ##test## by: (Though don't know whether there's a smarter way)
System.Text.RegularExpressions.Regex.Replace(str, "##Test.*##", "Output")
So basically the problem is to get what the wildcard (.*) is, since thats really what I need to know..
We have an c# class, say we have a following method with out parameterpublic class TestCsharpClass{ public Int32 GetNumber(out bool pbNull){ pbnull=true; return 1; }}tlb file for C# project is generated with regasm tool. The above method is called in vb6 application using callbyName Dim number as IntegerDim objTest as TestCsharpClassdim blnNull as Booleannumber = CallByName(objTest,"GetNumber",VbMethod,blnNull) return value 'Number' is fine.But 'blnNull' boolean variable is "False" always.We were unable to get the out parameter value from C# code.Function signatures are defined in the IDL file.Without changing the function signature is it possible to get the resolution/workaround solution for this issue
View 4 RepliesI am having a stored procedure in sql 2005 the procedure is to retrieve year code between two days it works correctly in sql query analyzer and it returns value [code]...
View 2 RepliesI am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
I have a login panel with a textbox for the userloginID. When the login button is clicked, the datasource is supposed to pick up the valkue in the textbox and provide filtered data to the chklistbox dependent of the value in the userloginID textbox.I only connect the datasource to the chklistbox when the login button is clicked, but the app still fal;ls over wit the folowing message:
The Type property of parameter 'UserLogin' cannot be set when the DbType property is set. Description: An unhandled exception occurred during the execution of the current web request. review thestack trace for more information about the error and where it originated in the code.
[code]....
I'm trying to populate my textboxs with data from my database when the user name i
table
users (there is a textbox for each of these fields)
password
[code]....
I am using following code to connect to my database.
Dim conStr As String = "Data Source=.SQLEXPRESS; ![enter image description here][1]
AttachDbFilename=|DataDirectory|dbTest.mdf;
Integrated Security=True;
User Instance=True"
Dim sqlQry As String = "SELECT * FROM [tblTest] WHERE ([Name] = @Name)"
Dim dAdt As New SqlDataAdapter(sqlQry, conStr)
Dim dSet As New DataSet()
Then filling adapter with
dAdt.Fill(dSet, "tblTest")
And then I can use the data the way I want.
My question is: How to pass the value of parameter that user will give through a text box on my webform.
Dim sqlQry As String = "SELECT * FROM [tblTest] <b>WHERE ([Name] = @Name)
I mean how to pass the parameter value to my query?
I am now able to add a row to Table1 in my database and and to populate some text boxes with that data. Now...one of those text boxes has a piece of data I wish to use as a variable/parameter in a SQL query to then populate several other text boxes. The piece of data in question is the Primary Key in a Table2. I have tried several methods I've discovered online...but nothing is working so far. So far I'm leaning towards the CommandBuilder but am unable to make it work.
View 4 RepliesI'm currently working on "transferring" my vb6 application to vb.net. I'm doing a complete rebuild from the ground up - which allows me to address issues that have arisen over the life of my vb6 application and I'm also learning .net as I work. My primary concern though, is that on one of my forms I display all the information about a customer (Name, Address, Notes, Phone Number, Assigned Salesman, etc.) in VB6, I put all the textboxes in a frame and disabled the frame so they boxes looked "normal", meaning there were still white with black text. In .net, if I add the textboxes to a
View 12 RepliesI got some textboxes that I can't write in, and no it is not because it is enabled = false. It is strange but I click on a textbox, type something but the textbox stays empty. It is focussed but I can't write in anything I tried this with two textboxes and still having the same problem.I didn't add any new code that could do this, I don't know what's wrong
View 2 RepliesI have a datagridview on a form.
I have a text box and when the text is changed in the text box, i want it to search the datagridview for any matching values.[code]...
My application has to do a lot of work when I press as single button. When he is doing this he got to changes sometimes a few tings in a textbox. Sometimes the calculation can take more then 10 - 15 minutes, is there any way to make it doesn't say not responding? And you are able to work further in the program. I did try backgroundworker but I'm not able to edit the textbox.
View 1 RepliesI am using the following code to filter on a textbox value using the BindingSource.Filter function.I thought this was the right code based on my many searches.
BindingSource1.Filter = "ValueID = '%" & ValueToFilter.Text & "%'"
When do a debug, it shows the correct value which is "432360ac-ac35-4101-8d46-f2cbd5b5dc52.There are spaces in the end of this value and it is exactly the same in the SQL database with the spaces. ValueID is a column in my SQL server. It does not filter the records in my dataset.I tried replacing the ValueToFilter.Text with my actual value as shown above including the space at the end and it filters the records just fine exactly as I want it to. Although I obviously need it to work for multiple values from my SQL server.
I am having some trouble using string.Format + textBox.
Dim formatStr As String = "{0,30}{1,15}{2,15}{3,10}"
Dim i As Integer
txtShowAll.Text = (String.Format(formatStr, "Video Name", _
"Year Produced", "Running Time", "Rating"))
[code]....
I used this code, and nothing works.I am trying to output a header, then the data under it.
i made 3 textbox and 3 button. when button click, button name can put textbox. but when i try to run it, button name can go only 1 textbox,the other 2 textbox does not working. I will put my code, Please chk it what is wrong.
Private Sub b_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btna.Click, btnb.Click, btnc.Click
Dim btn As Button
btn = sender
If TextBox1.Focus() Then
[code].....
I've been having problems extracting the value of a Regex in a String. I have a string with several regex expressions and I need to get the value of each expression's match. The thing is though, it's not returning the last match correctly. For example:
Regex Pattern: I play (S+.*?) and (S+.*?)
String: I play the guitar and the bass The program is returning the value of the first expression as "the guitar" but it's returning the value of the second expression as "the" instead of "the bass".
Dim PrinterIP as String
Dim Str as String
Dim objReg As New IWshRuntimeLibrary.WshShell
[Code]....
I have the following code. I would like to perform a if then check via a button click before the user processes the information.
Private Sub TestBTN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TestBTN.Click
If TBSearch.Text = "" & ".exe" Or TBSearch.Text = "" & "" Or TBSearch.Text =
[Code].....
I would like it to just check to see if the text box info has been entered in one of three formats.
1)blah.blah
2)blah*.blah
3)blah*.*
I have a form with lots of textbox, and a dateTimePicker. All of these controls are binded to a JoinTableDataBindingSource. So when I wanted to insert a new value or update the values, I have to rebind all these controls to the respective tableBindingSource.So after saving all the values to database, I rebind them again to the JoinTableBindingSource to display the values accordingly.
All these works perfectly until I tried to bind the DateTimePicker. I am able to show the Date, insert new values to Date, and updating date.However, after all the binding and rebinding,whenever I tried to call tblJoinTruckTableAdapter.Fill (me.dataset. tblJoinTruck), All the textbox.Text becomes "Nothing". I am unable to show the values in the textbox.
Everything works when I commented off the binding and rebinding of dateTimePicker. I seriously have no idea what had happen.Below is the binding and rebinding of my dateTimePicker.'I have clear the databinding before adding this to point it back to its respective table.
dtpTareDate.DataBindings.Add(
New Binding("Value", TblTruckBindingSource, "dtTareDateTime"))
'After inserting or updating the values, I clear the binding and rebind it back to tblJoinTable.
dtpTareDate.DataBindings.Add(New Binding("Value", TblJoinTruckBindingSource, "dtTareDateTime"))[code].....
I am using VB to make a file editing system that allows the user to edit multiple files on multiple tabs like Notpad++.I hit a slight snag though. Seeing as tabs don't contain text, I add a textbox to each tab upon creation.For loading files I want to check if the current tab's textbox is empty so I don't end up adding the loaded file as a new tab, which would just create clutter (like how when word opens a file, it checks if the current document is an unsaved file with no text before loading.)Problem is, how do I check this with tabs I haven't added yet? (Ie will be added whilst the program is running as opposed to in design mode)
View 2 RepliesI have a small problem with my AutoComplete Textbox in that it doesn't replace what I type with the item from the drop down list. This is hard to explain so I will start off with the AutoComplete of the combobox and how it works.
If I create a combobox with the following listitems (pay attention to case as this is the actual problem)
Item1
Item2
Production1
Production2
Now I can set my AutocompleteSource to ListItems and when I begin typing into a combobox I get a list of matches (Using SuggestAppend)So if I type i (lowercase) I get a list containing Item1 and Item2 with tem1 added and selected for overtyping in my combobox text. Now if I press Tab or Enter, My combobox.text is updated with Item1 with the proper casing from the list even though I typed a lowercase i. This is not how it is working in the textbox. Using the following code:
Dim mySource As New AutoCompleteStringCollection
mySource.AddRange({"Item1", "Item2", "Production1", "ProductionItem2"})
TextBox1.AutoCompleteCustomSource = mySource
TextBox1.AutoCompleteSource = AutoCompleteSource.CustomSource
TextBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend
When I begin typing in the textbox, again, the list drops down. And again, when I type a lowercase i, I get a list containing Item1 and Item2 with tem1 filled in to my textbox. Now if I press enter or tab, my textbox is filled with item1 instead of Item1 as it did with the combobox.
My question is:Is there a way to ensure that the text in the textbox matches the actual case of the item in the customsource? I can click the item in the dropdown and it appears in the textbox just fine. But I don't want to force my users to have to do that.
I'm trying to evade the problem of being unable to have a transparent textbox by using a label. When the label is selected, it selects the info in a textbox elsewhere. Then using Textbox.changed, i stream the text to the label. Maybe the code will make sense:
Private Sub UserLabelClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles UserLabel.Click
UserTB.SelectAll()
End Sub
[code]....
But the text is not selected and therefore cannot be changed.
I'm trying to use the bindingsource.find method to match a datarow column with a user entered text. I know that using BindingSource1.find("columnName", searchString) will work when the user enters the exact string. What I would like to know is how to find a row that is close to the string using a wildcard search... a good example I guess is:dim searchString as string = textbox1.text 'lets say the user enter "se"dim index as integer = myBindingSource.find("columnName", searchString) 'I would like to find the firs record that starts with "se"I can achieve the idea using the bindingsource.filter method but this will interfere with other parts of my application if the bindingsource is changed.
View 6 RepliesHow can I use wildcard/s for the attachment filename. Part of the filename changes but the characters 8 and 9 (counting from the left to right) always present and always either LK or KL. Currently files are PDF type, thus with extension PDF but might be different in the future (this is not important now).
Here it is: Dim oAttch As Net.Mail.Attachment = New Net.Mail.Attachment("C: est102309LKO.pdf")
As you can see in the picture I send my wildcard parameters to my query if the "textbox" does'nt have any content. But when the query require INT, and not STRING, I don't really know what to do.Is there another kind of wildcard when it's INT?
View 19 Replies