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

Form In A Form - Manipulate The App's Properties Place Inside Child Form?

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

Manipulate Controls From Another Form?

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

Manipulate Web Form In Windows App?

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

DB/Reporting :: SQL Select Query In Form - Form With A Datagridview That Displays All Of The Values

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

Get Value Of Previous Form Textbox In Second Form Sql Query?

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

Sql - When Run The Query In Query Analyzer, It Returns One Row But When Use The Same Query, No Rows Are Returned?

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

.net - How To Manipulate DataSet

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

Have 15 Labels To Manipulate?

Feb 8, 2012

Private sub updatelabels()
If me.invokerequired then 'entire form -- ok ?
me.invoke (new methodinvoker (addressof updatelabels))

[code].....

View 3 Replies

Manipulate A Tab Control?

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

Manipulate Browser From .net?

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

C# - Manipulate A .NET Assembly So That Everything Becomes Public?

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

Can Manipulate Scanner By Code

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

Develop An App That Can Manipulate Video?

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

How To Manipulate Access Database

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

How To Manipulate Treeview Checkbox

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

Manipulate Characters In A String?

Jun 22, 2010

Here's my submission to sort a string of characters in numeric, then lowercase, then uppercase.

[code]...

View 1 Replies

Manipulate Data In Worksheets?

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

Manipulate Sql Server Database

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

Manipulate The 'value' When Setting A Property Value?

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

Opening / Manipulate A Java Web App In .NET

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

Unable To Manipulate String

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

XML : Manipulate A SubObjectList Element?

Jul 12, 2011

<Element_List SubObjectList="Yes">
<Type>2</Type>
<Class>1</Class>
</Element_List>

View 9 Replies

Add A SQL Query In The Form?

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

Access And Manipulate A Mdb File Available Online (on Web) Using VB?

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

Application That Can Manipulate Images For Program?

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

C# - Manipulate A Window Object From Another Class In WPF?

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

Can Combine V & And Number To Manipulate Variable

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

Grab And Manipulate Javascript In A Webpage?

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

Import Data From The Internet And Manipulate It?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved