I would like to combine the two things in the title to use as a query for an access database. I think i kind of know what to do, but then it doesn't work so i actually dont, the error i am getting in runtime is that the query is incomplete. The line of code in question is this:
Query = New OleDb.OleDbCommand("Select key From '" & frmFrontEnd.cmbModel.SelectedIndex.ToString & "'_Assistant", AccessConn)
'i have written the following code:
Private
Sub Combo_Mth_KeyPress(ByVal
sender As
Object,
[code]....
'even thogh it seems to clear the text and select default text yet user written 'keyword appears in the text area of combobox?
I'm making a program in which there is a form and when opening this form it automatically checks the internet for a csv file and reads the data from it.
the csv file consists of 2 items i need "Provider name , Provider smtp" example:
==
Chello,smtp.chello.nl
Het Net,smtp.hetnet.nl
==
I've got the part working that when the form loads the online file gets read and the data is shown in a combobox. Only it shows the whole line like 'Chello,smtp.chello.nl'.
What I want (and can't seem to get working) In only the combobox the words before the comma and in a invisible textbox the corresponding smtp line. Ergo when I select option number 4 the right smtp is put into the invisible textbox.
My code so far:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim myWebClient As System.Net.WebClient = New System.Net.WebClient()
[Code]....
I have 2 tables: locations and depot:[code]I have 2 forms, frm1 and frm2. Frm1 has a combobox, cboLocations which pulls from the Locations table. Frm2 has textboxes which populate based upon the location selected from cboLocations on frm1. Frm2 also has a combobox, cboDepot, which pulls from the Depot table.So far, I've been able to get cboDepot to populate with the first depot_refnbr. This is not the corresponding depot_refnbr that matches with the selected Location; it is just the first depot_refnbr in the Depot table.I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
View 11 Repliesfollowing issue I'm having:
I have 2 tables: locations and depot:
Locations:
site_refnbr (primary key)
site_name
depot_refnbr(foreign key)
[Code]...
I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
I came to a company that already has a fully grown project... but coders that worked here before me didn't follow conventions and didn't use parametrized SQL queries... as a result there is over 1000 places in a very huge project that can possibly be vulnerable to SQL injection...
I need to find a solution that will automatically detect if there is an SQL injection in the code. So, for example there is a form which allows user to enter comments regarding a product, which will be sent to database on submit... how can we make sure that a user didn't enter a harmfull query instead of a normal text?
Is there any advanced code/regular expression/magic that can detect if this text contains a piece of SQL query instead of normal harmless text? I will accept any links, pieces of code in any language or even commercial software that will do that for me.
At present i have an interface which displays a string of sql code in a rich text box.
I also have my microsoft access database connected to the form.
How would i go about getting the sql code in the rich text box to produce the results for the query??
I have been working on this project for a while and this is just one more add-on. I want to be able to combine text boxes like my code below-
[Code]...
I have some trouble to combine text and numbers from a cell in my excel sheet.C
FilePath = "V:DatasheetPDF-COA & Sheets("Ark3").Cells(4,10).Value & *.*"
I found a very useful source code on how to make a fud cryptor, but the author didn't mention which coding language / software he used, please follow the link below, to see the full source code.
View 5 RepliesIs it possible to populate an AutoComplete text box property in code from an Access query.
View 6 RepliesHow can I Optimize my own code written by VB.net? Is there any tools for it? Does Visual Studio have any one? What's your suggestion? I use VS2008 as my editor.
View 1 RepliesI have never used Visual Basic before.
I have some source code for a project to look at. How can I tell whether the code has been written in VB or VB.Net?
I have some code that was written in C# and am attempting to convert it to VB.Net, for the most part things have gone well but I am running into an issue that I am not sure how to handle. The project has several classes and a few namespaces defined. The issue is [or seems to be] related to the namespace usage.
In the C# code of one class I have
Code:
namespace GdiPlusLib
In another class I have
Code:
using GdiPlusLib;
When translated to VB I have in the first class above
Code:
Namespace GdiPlusLib
and the following in the other class from above.
Code:
Imports GdiPlusLib
I get the following warning message on the imports line
Namespace or type specified in the Imports 'GdiPlusLib' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases. There is another instance with a different namespace that gives the same warning and I get 11 errors all of which would seem to be related to the two warnings.
I'm currently using this method in calling batch files in vb.net:
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
System.Diagnostics.Process.Start("F:ipconfigflushdns.bat")
End Sub
Is it possible to incorporate the code written in the batch file so that I won't have to call it like the one above?
I have written a code to generate random colors and the code is working perfectly fine.I have a requirement in which I should not generate Red or Shades of Red in Random Color function. suggestion on how to not generate Red and its shades
View 7 Repliesi want to make a website builder which has the html code already written so all you have to do is check which boxes you want and click next or back to go through the process of making a website with specific code implemented in it.
P.s. im using VB 2008 express edition?
I have been developing windows and web application using Visual Basic 2005 for a long time. Now i want to change from Visual Basic 2005 to Visual Basic 2008. I would like to know what ever projects i have done in visual basic 2005 will works in Visual Basic 2008. Will the existing code in visual basic 2005 supports Visual Basic 2008 or do i need lot of modification. I haven't used VB 2008 but i hear that most of the code which written in visual basic 2005 supports visual basic 2008. What are the things i need to take care when working the existing projects in visual basic 2008.
View 3 RepliesI have VB 2008 Express installed in my PC. I downloaded a program source code written in VB6 but could not open the files. What do I need to do to get this codes displayed.
View 4 RepliesI am trying to write code for a login to my program. But the code I have written freeze's the screen. Basicaly I want to check if username (TextBox1) has text in it and then check if password (Textbox2) has text in it. if either textbox has no text then a MsgBox show's with an OK Button. and then I dont want the program to run. I want The login form to reload so the user can insert thier username & password. the code I have is below.
[Code]...
i wan to display the text from combobox into the textbox and clear the combobox text when click on the button.But when i select another text from the combobox and click the button, the textbox display and overwrite the previous text.How can i do so that when click, textbox display text from combobox and clear combobox text. Then click again, display the new text at 2nd line of the textbox without deleting the previous text?
View 5 RepliesI am trying to save text in a particula format.
I am using the following code to enter the data from the keyboard and save it in a text file.
Private Sub EnterXMatrixToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles EnterXMatrixToolStripMenuItem.Click
Dim i, j As Integer
[Code].....
I need to write in the text of the button written in it "—10x" but when I copy it from MS word it is copied like that " —10x"
View 3 RepliesCan any1 teach me how to save the stuff written in the text box in the from not in a notepad file so i can retrieve it later in the same form. I just need help learning how to save the stuff written in the text.
View 4 RepliesI want to get the text written in textbox1 And Then After getting it It should type it In The Label
View 7 RepliesHow would i put * in a password box when text is written in it but only when text is written in it and i want the *'s to be as many as how many characters are entered so if the pass was test it would be 4 *'s
View 6 RepliesI am having a hard time with my project. A description of it is here (Question #2) I don't know where to begin with classes. I have a functioning program, but it isn't working as designed. Changes and updates are being written directly to the text files, so the listbox doesn't display current information unless it is refreshed in some way. The instructions say that this program should commit files once a "Save accounts to File" button is clicked. Obviously, my program doesn't make use of the button. I was going through another project where changes were written to a list box, and committed to the files upon exit. However the text files were in LSV format, and the program used an array of structures instead of classes.
[Code]...
Can anyone think how to read how many lines will be written to a txt file via streamwriter?I know i can do a count and increment on each writeline but maybe someone knows how to countlines from streamwriter?
View 2 RepliesLet me preface this by saying that I'm very much a novice coder. I'm currently working on a small project to practice with Visual Basic and have experienced some issues during my save and load process using text files. I think I can solve the issue by changing the way my text file is initially saved. I want to see if I can sort the items and change the order in which they are written to the text file based of the value in one of the lines.[code]....
View 5 RepliesI tried to write a text written in my textbox to file.(a .txt). I scanned it to see if it contained any illegal characters, the program said that it did not. However, when I went to save it it said that the program performed an illegal operation.
System.Runtime.InteropServices.COMException was unhandled Message: Exception from HRESULT: 0x800A0005 (CTL_E_ILLEGALFUNCTIONCALL).
It created the text file but did not write the content of the textbox to the file.I can save the text in Microsoft word without a problem. Is there something wrong with the encoding for the textbox and how do I set the encoding for the characters so I can write it to a text file.