VB Form To Manipulate SQL Query?
Jun 19, 2011
I am fairly certain that the error is on my calling the SQL database, but just checking if there is something obvious that I am missing.
Class Form2
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
If (My.User.Name).Replace("server", "") = "u
[code].....
View 4 Replies
ADVERTISEMENT
Dec 23, 2008
The following code does create a form within a form and does place NotePad inside the child form. You have to manually start NotePad prior to execution (I work on that later) but the code does workŠ My problem is now I want to manipulate the properties of notepad i.e. focus, size, location, etc. but I cannot figure out how to reference notepad and its properties.
[Code]...
View 8 Replies
Feb 6, 2011
Lets say I have a List Box called listBox1 on Form1 and on Form2 I have a button called Delete. Whenever the user presses the Delete button on Form2 it should delete an entry from listBox1 in Form1. How can I manipulate listBox1 from Form2's Delete button?
View 5 Replies
Aug 23, 2009
I want to create a program which inserts the person's data from a textbox into a form on the webpage named "name" (for example). I want to be able to make them select from a dropdown list named "cat" and what they select is selected on the dropdown form too.
I also want them to be able for the person to select a file on their machine which is entered in a form named "thumb"I'm completely stumped on how to do the above in VB 08. Also, how to use a submit button? On the page, the submit button's code is<input type='submit' value='Submit' />How to manipulate that in VB 08?
Excuse me if this was asked, Google wasn't in my favours today.
View 5 Replies
Mar 26, 2008
I am using VB2008 Express and a MSSQL Server 2005 db by the way! I have a comprehensive SQL statement, which should fill my Grid:
DECLARE @Sum NUMERIC(9,2)
SELECT @Sum = SUM(I_LS.lmenge)
FROM dbo.lfs AS I_L
[CODE]...
Now here is my problem! I want to have a form with a datagridview that displays all of the values I am querying. This shouldn't be a problem I guess. However, I have no idea how I can integrate two textboxes that can be used to enter the selection criteria (WHERE I_L.lfsnr LIKE '%1253') AND (l.sped_journal = '11-08')[/SIZE]. I have googled and read many threads so far but didn't stumble upon anything that would suit my needs and answer my question. Maybe it's just too elementary!? By the way, it is very important that the input of textbox1 ((WHERE I_L.lfsnr LIKE '%1253')) is linked to 3 positions in my SQL query to define the search criteria!
The worst thing is that I don't want to have a bindingnav displayed! I do not need any delete, update or add functions just the select option, however!
View 1 Replies
Mar 7, 2011
str = "Select testlib.code, testlib.name, testlib.RATE, testlib.GRP, testlib.lbound, testlib.ubound, testlib.lcode, testlibHEAD.name AS TNAME from testlib, testlibHEAD where testlib.GRP >= '" & frmPrntRate.txtGroup.Text & "' and testlib.GRP <= '" & frmPrntRate.txtGroupTo.Text & "' and testlibHEAD.code=testlib.lcode and testlib.ISMAIN='Y'and testlib.DCODE = '" & frmPrntRate.txtDept.Text & "' order by testlibHEAD.name, testlib.code"
i'm using this query but the value of group n dept are not coming from first form....
View 3 Replies
Aug 19, 2010
Here is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
View 1 Replies
Jan 31, 2012
i have problem in manipulating DataSet, how can i filter rows without getting the whole records in tables.
[Code]...
View 1 Replies
Feb 8, 2012
Private sub updatelabels()
If me.invokerequired then 'entire form -- ok ?
me.invoke (new methodinvoker (addressof updatelabels))
[code].....
View 3 Replies
Oct 1, 2010
I have a form with a bunch of tabs on it, but I don't want them to all be visible all the time.[code]...
View 4 Replies
Jul 9, 2009
I am developing an intranet app (so security isn't such a problem). The client wants to drag eml files from Outlook to a folder. I would like put a file watcher control that monitors the folder. When the new file is added I want to run some javascript in the open intranet window. How can the file watcher app communicate with the intranet app (also there may be more than one intranet app open). I am experienced at asp.net but a total novice to Winforms so bear with me.
View 4 Replies
Aug 8, 2010
I don't know much about the CIL, except that there is metadata in assemblies that record the type information.Would it be possible to create some reflecting tool that is able to read a C# or VB.NET assembly and change its metadata so that all class members become public?
View 4 Replies
Apr 11, 2012
I need to create a code, that allows me manipulate a scanner for to do the functions of scanning and save the image.
View 1 Replies
Jul 3, 2010
I want to create and application (I'm a rather Jr. programmer, with just a few apps in production), but I'm not sure where to start.
The app needs to be able to join videos of the same types, for instance, divx1.avi and divx2.avi into divx_joined.avi.
I've already google...err I mean, searched bing for some how to's and what not, but I don't think I'm looking for the right terms.
Where do I start to learn to deal with video streams? Is there a book, SDK, etc?
View 4 Replies
Dec 28, 2009
I'm currently using system.data.oledb but I can't seem to make the update , search, & delete work fine. Are there any other ways on how to manipulate an ms access database in vb.net easier than my method? Here is my code for searching:
[Code]...
View 2 Replies
Feb 16, 2009
I had a treeview that had checkbox and its content is like file explorer. the checkbox is check when users want to delete that files or directory, after the selection, press the command button then all selection will be process (on this case deletion) how that to be code?
View 2 Replies
Jun 22, 2010
Here's my submission to sort a string of characters in numeric, then lowercase, then uppercase.
[code]...
View 1 Replies
Aug 24, 2009
Is it possible to manipulate data in worksheets?[code]...
what i want to do is round off the time in if the time is greater than 6:00 example please look at the data date 8/2 and 8/3. i would like to modify it and make the 6:01 to 6:15, and 6:16 to 6:30 , every 1-15min late the time would round off to the nearest 15mins.. my question is how can i make loop in the column "time in" and every time the program sees a "late IN" it will round it up to the nearest 15mins.
View 2 Replies
Mar 10, 2010
Do you know of any beginner tutorial on how to manipulate(Add, Edit, Delete, Search, List) sql Server database in vb.net?
View 2 Replies
May 31, 2011
I have the following property in a class:
[Code]....
The problem is that when I try to set the property like this: myClass.Language = "English" The property is set to "English" and not to "<![CDATA[English]]>" which is what I want. What is the reason for that and how can I fix it? When placing a break point on End Set and use the Watch window to inspect the value of _Language after setting the property to "English" it remains "English" and doesn't change.
View 3 Replies
Jan 16, 2011
I use a Java web app (app/screenshot, you'd need to sign up, but it's just a java web app), however I'd like to automate its functionality inside of a .NET application (C# or VB, doesn't matter, I'd prefer C#).
I've tried searching but unfortunately "Java web" and ".NET" and "C#" etc, don't return me anything even remotely useful. Is it possible to load the page within a control (or through some other way) within a .NET application, and thus act upon the display itself (the data flow will be encrypted, since it's https - so I don't know if I'd be able to read the data coming to and from the java application, I assume not, but being able to read the application would be nice), to be able to select areas, click, read/input numbers and text, etc. I realize this is a pretty broad question, but, it'd be very helpful if someone could offer some advice/insight into this problem.
edit to add: I guess a better question would have been either "Ways to interact with a java web-start app with windows apis?" or "Possible to contain a java web-start app within a .NET app, and interact directly with components of the web app". I'm also wondering if it will be possible to load it into a browser in a form in .NET, although I assume that it would just launch web-start taking it out of the forms control.
View 2 Replies
Oct 23, 2010
In my website i have a script that return the current song that playing from my shoutcast server in a format of: "artist-track", what i want to do is to take that string and split it to 2 strings: artist and track, in order to do that i wrapped the script in server tag like this[code]...
View 3 Replies
Jul 12, 2011
<Element_List SubObjectList="Yes">
<Type>2</Type>
<Class>1</Class>
</Element_List>
View 9 Replies
Jun 2, 2011
I add connections in server explorors. Then, I use AdventureWorks Person.Contact to set up a query by searching peter and mary ,but how to add it on form 1 ? and I type part of their names and by the way how to link a "VB label of text" or two "variables" to the two query parameter? when the competer need me to put the parameter from "Me.form 1.label 1", I type "mar" and "pete". I need the tools for up-date, re-edit and save.
[Code]...
View 5 Replies
Nov 6, 2009
I have a mdb file hosted on my site [URL]. I am developing an application which will be running on multiple machines and will contact the mdb file via internet. I am not sure how do i go about it as building the connection string for an online connection.
View 2 Replies
Jul 21, 2010
Basically functionality i need is:
easy integration with ASP.NET application.user ability to crop image with handle prior to save image optimization from any image type to jpg (compression levels) during the save saving images with proper h/w ratios during the save user ability to rotate the image prior to save ability to translate application to foreign language as it won't be used on international site
View 4 Replies
Aug 28, 2011
I'm new in WPF and C#. I know a lot of VB.NET and I'm used to the way when I call a form object like textboxes, etc. I'm calling it from another form. Now, I'm using WPF, I'm confused. Because I have a Main Window. And I want to add and item to a listbox in the Main Window from a Class. In VB.Net , its just like this.
[Code]...
View 2 Replies
Jun 9, 2011
I have 10 variables that have numbers at the end in sequential order (e.g. V1, V2, V3, ect.). I would like to perform a function to find what the position is in an array and then add then add the value to the correct variable. Can I combine V & and the number to manipulate the variable?
View 2 Replies
Apr 9, 2009
was messing around with web controls and making auto login programs and I have been running across many websites that use java script to code their login boxes for some reason. I was wondering how might I edit the values and click on the sign in button if it is inside of javascript?
View 5 Replies
Feb 4, 2010
i want to import data about cigarettes from the internet. i don't know terminology so i'm having a hard time starting.
View 1 Replies