I am not sure what I am doing with this and need some direction. I have attempted to create a stored procedure in SQL Server 2005 called proc_GetPrefixes with the following content
USE [CRM] GO ALTER PROCEDURE [dbo].[proc_GetPrefixes]
[Code].....
The stored procedure is supposed to get all the records and what I want to do with the result set is to add all the items to a combobox. I have started off with the following and not sure where to go with this:
Is there a way to grab information from a textbox outside of my form? I am able to track the cursor's position, x and y, and i want to detect whether there is a textbox at a given position, if so..grab the text.
In one page 10 no. of hyperlink present. If I click one of them then the text which is written in links that will be displayed into textbox dynamically. For example, <a href="hello.html">hello</a> If I click hello. Then hello will be displayed in textbox.
I have a text box where i am entering numbers of double datatype andon the Keytdown event of the textbox some checks take pace and in certain circumstances I want to be able to stop the user from entering other information until they enter the right information in the textbox (where it says right here) . now when I say exit sub the textbox somehow loses focus . but this is not how I want it to be I want the textbox to remain with the focus so the user can change the information . How can i go about this. And the other thing is why is my txtDestPayRate1.Focus() just befor the exit sub not working?
Private Sub txtDestPayRate1_KeyDown1(sender As Object, e As System.Windows.Forms.KeyEventArgs) Handles txtDestPayRate1.KeyDown
I am wondering how I would get the information on what errors get processed by the application.unhandledexception. I already handle the event and gather the information, but I am unsure how or what the best way to get that information to me (the developer).
So far I have vdialog that asks the user if he/she wants to send the error to me, kind of like when an error occurs in Windows XP and a dialog asks the user if they would like to send information about the error to microsoft. I am unsure what to do when the user clicks "Send".
I have thought about emailing to me, but I don't really want to put my email address as the from, because I might change it or its password in the future, thus breaking its usability.
I cannot yet do an anonymous FTP upload, because my website only allows one FTP user, and that is used only to update the website.
I also have thought about using the user's default email program, but that will not work in most cases of people who rely on web mail.
i've done research and it's because it's using a GET method instead of a POST method... how the heck do you fix this if your using a FtpWebRequest class!?
I'm trying to add 3 customers to an array that I can then display in 4 seperate text boxes on my form. First Name, Last Name, Account Number and Balance.
Public Class Customer Private firstName As String Private lastName As String Private accountNo As Integer
[code]....
Error 2 Argument not specified for parameter 'account' of 'Public Sub New(first As String, last As String, account As Integer, balance As Decimal)'.
does anyone know how to make it that when you type something in to a text box the click a button called add to then have what you typed in added to a checked list box and then have it that when you click another button called add that the information in the checked list box which has been checked is then added to a database.would it be better to make th information entered in to the text box be saved to a text document and then have the checked box get its information from the text file if so does any one know how to do that.
In the following code example, I am querying WMI for Memory Modules and adding the information to a TreeView component.
VB.NET Dim Scope As New ManagementScope(" ootCIMV2") Scope.Connect() Dim objectQuery As New ObjectQuery("SELECT * FROM Win32_PhysicalMemory") Dim Searcher As New ManagementObjectSearcher(Scope, objectQuery) [Code] .....
When I run the code, I expect to see a Parent Node named System Memory, and two Child Nodes for each memory module installed. I do get the appropriate Child Nodes, but I also get an extra Parent Node and I can't seem to figure out why:
I debated whether or not to ask in the database section, but decided this was probably more of a VB question, than DB.I'm performing a query on my database and add its value to a DGV. At the moment, I'm just running tests to make sure the base example works so I can expand on it for more advanced tests.[code]It doesn't matter how I add the row, just adding it causes the error. And yes, the AllowUsersToAddRows property of the DGV is set to True, which wouldn't cause this problem anyway, but I decided to be extra careful.
I have a problem that adding a new ROW with duplicate UNIQUE id throws CONSTRAINTException that I cannot always catch.. Randomly general exception halts my VB software, sometimes catching works. here is my code.
Several times av been come across of the need of how to create new variables on my application while is running and the next time i will run again the application to be existed in my source code and still be inside.
what excatly i mean is for example i have a listbox with out assigne it in any databound ,or retreive any items from any textbox i just want to insert some items inside
if i go from the designer then i can succesfully add any item i want and they will be there as i declare them.but if i want to to that programmatically i will be able to add them in the listbox but the next time i will run it again it will be lost.until i will select the command again to fill my listbox which is not what i want
in my case i have a datagridview which is running SQL querys and i want if the user selects to save this query i want from some way to save this query string in my listbox . and i want to be there the next time i will run my application with out using any text file or database,
is there any way to that ? i have search before i ask but obviusly my keywords dosen't much with what i was looking for
Exception is generated while adding owc11.chartspace to panel at runtime.
code is:
Imports Microsoft.Office.Interop.Owc11 Public chartspace1 As ChartSpace chartspace1 = New ChartSpace Me.Panel3.Controls.Add(chartspace1)
Exception :Unable to cast COM object of type 'Microsoft.Office.Interop.Owc11.ChartSpaceClass' to class type 'System.Windows.Forms.Control'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface.
I am trying to send information to an mdb. I have already retrieved data from the database. I have preformed changes to the data, they are all still integers and there is the same number of results as there are samples. How do I get the new results back into a MS Access database?
Output Dim dr As DataRow dr = DS1.Tables(0).NewRow()
[Code]....
Would it be better to create a new row or to access an existing row?
It is possible to catch an exception and throw a new exception which wraps the first exception as an inner exception: [URL] Also, if I call a function and it throws a certain error, but I catch it, will the calling code's catch handler execute? If so, and it is of a higher exception type, is this not wrapping the exception? eg I can throw exception ex of type IndexOutOfRange, log it but rethrow, catch a higher up exception and do something, or I can throw a new exception and wrap an inner exception like:
when i enter information into the overall textbox say like 4.0 the calcuation should pick it up as 10.0 but its just taking the the 4.0 instead of the 10.0 in the select case. How do i get it to take 10.0 instead of 4.0. here is my code,
I have a php script mounted on a server. The purpose of the script is to parse some data. What I need to know is how can i access this data in VisualBasic 2010 without opening a brower window and storing the contents of the script into something like a textbox
Private Sub DataGridView1_Click(sender As Object, e As System.EventArgs) Handles DataGridView1.Click txttID.Text = DataGridView1.CurrentCell.Value ' txttSurname.Text = DataGridView1.Columns(1) txttSurname.Text = DataGridView1.Rows(DataGridView1.).Cells(1).Value
I am trying to have a situation where if a user clicks on a certain row in a datagridview control the value in the datagridview row will be shown for a a certain column. Column 1 in my datagridview control has Names in it so I want if a user clicks row 0 the name in row 0 will be shown and if a user clicks row 1 the name in row 1 will be shown etc. this is the code I have so far. ! tried line 2 2 in my code but it shows whatever cell i click and sometimes its not an id .
I am trying to have a situation where if a user clicks on a certain row in a datagridview control the value in the datagridview row will be shown for a a certain column. Column 1 in my datagridview control has Names in it so I want if a user clicks row 0 the name in row 0 will be shown and if a user clicks row 1 the name in row 1 will be shown etc. this is the code I have so far. tried line 2 2 in my code but it shows whatever cell i click and sometimes its not an id.
So what i have is textbox1 textbox2 and richtextbox1 I want to enter information into textbox1 and textbox 2 and then hit submit so it records the data in the richtextbox as if it is a chart.
My current code for this is RichTextBox1.Text = TextBox1.Text & (" | ") + TextBox2.Text & (" | ") + "Pending"
But every time you hit submit it erases the current data and puts the new one. i want it to record it on 1 line, then when u hit submit again it will go to the next line in the richtextbox and record the textbox information on that line and so on.
I have A name in a Textbox and numbers in a Listbox and I need to get the name and the Numbers to appear in another list box and also I need to get this "|" to appear between the numbers. THis is the code on my main form
Private Sub btnUpdate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpdate.Click Dim UpdateScoreForm As New frmUpdateScore UpdateScoreForm.txtScore.Text = ListBox2.SelectedItem
[code]....
This code will work only if there is 3 items in the listbox but I need it to work no matter how many itmes are in the list box
A user can select a few chec box options, then clicks OK.A new tabpage with a textbox and two buttons is created and added to my form, the textbox can be seen as a sort of 'receipt', and one button is a close button, which deletes that tab, the other button is an edit button.When the user selects edit, I would like the selection page to open up, checking, (through a couple of If conditions, whether a text is contained in the text box), then if a certain text is found in the box, a corresponding checkbox on my form is checked.
So basically, my problem is trying to check the text from a textbox which doesnt exist until after my form is loaded... I need someway to reference this new text box, not forgetting there may be many tabs at one stage.I tried a method in which each new texbox was added to a list, then when the edit button was clicked, it checked the tab index and checked the corresponding textbox, but this would only work for the first tab/textbox and caused issues with the close button, perhaps when the edit button is pressed, VB checks my selected tab, and somehow finds the textbox which is on that tab.
How i can insert information from the Row in datagridview into textboxes?now i made an access db then i made 7 textboxes to add information in my db no how i can reverse this action :
that i select any row to show the information every thing in his text box ?