I am trying to load some data from a database table into a data grid. However the way it is accomplished is that the user will be able to select the database (i.e. the database can be located anywhere in the hard drive) and once he or she selects the database, a second interface would allow him or her to select the number of tables within that database (can be any number of tables). Once the table is selected the contents of the table will be loaded into the datagrid. It is just like opening an Access (.mdb) file and then click and open a table within the file except that it is done programatically
I'm probably doing something wrong but, SQL statement on an access database works fine until I add in the second table. As soon as I do it just hangs....??
sql = "SELECT Candidate.Candidate_Number, Candidate_Name FROM Candidate, Candidate_Counties WHERE Technical_Skills LIKE '%" & Q1 & "%'" ' AND Anywhere_UK = 1" Technical_Skills is on Table Candidate Anywhere_UK is on Table Candidate_Counties
I have about 4 different tables with the exact same column names. What I would like to do is select the top 4 records out of all of these tables combined ordered by date (as date is one of the columns that they all share).
I want to insert existing tables in new table stock by selecting from date and to date ..I tried this
cmd = New SqlCommand("INSERT INTO Stock (OpeningStockdate,Productcode,Openingstock,Despatch,Receipt,ClosingStock) (SELECT A.OpeningStockdate as OpeningStockdate, A.PC as Productcode,MAX(A.Openstock) AS Openingstock ,SUM(C.Qty) AS Despatch,SUM(B.Qty) AS Receipt,MAX(Openstock) + ISNULL(SUM(B.Qty),0) -ISNULL(SUM(C.Qty),0) AS ClosingStock FROM Product A LEFT JOIN Receipt B ON
[code]....
i got this error" Incorrect syntax near the keyword 'Where' "
what i am trying to do is :when i type in the user the system will look in my table cg_security_user and recognise that the current role is "guest". Then in the Upgrade to when i type in "admin" it will update the current role(guest) to admin here is a picture is attached of what i am trying to do as it might paint a better picture the code which i have made so far is
Private Sub cmdupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdupdate.Click Dim myAdapter As New OleDbDataAdapter strsql = "update table1 set studname = @field2, studaddress=@field3, studage=@field4 where studid=@field1"
Using Access 2003 and VB code, I have created a form with a number of labels. The labels will display an employee's names. I have named the labels name1, name2, name3...etc. Using an ADO data set and DCount I have determined the number of names in an Access table (the number of names can vary). What I want to do is for each record in succession to pick the first name and surname from the data set , combine them into a full name (this part has been successful), and then set the full name into the label caption in succession. Example: full name 1 into name1, full name 2 into name2, full name 3 into name3... until all names appear as labels on the form.
I created a counter to and a variable to increment the label number but when I address the caption property of the variable containing the new label (e.g. name1, name2..etc.) it throws an errer at runtime. Here is the code:
I have a WCF service installed on my system. I can browse and see the .svc file just fine. Should I be able to use a browser to view the endpoint addresses such as https://svc.example.com/BaseService/Login
I'm working on a web browser, (it uses the IE engine, im fairly certain)with visual studio, anyway, whenever I click on a link, it opens in a new IE tab, not in my own brrowser, as do popups.
I have created a simple database table in SQL Express.Now, I would like the data in the table to appear in a VB datagrid.But, I cannot brows the connections in VB2008 express(data on local PC why ??
Im brand new to programming. Apart from doing a few digital dashboards in excel i have zero experience with vb or creating code. You may need to be patient.What i am trying to do is from my form, browse to a pic in a folder and insert it into a picture box in the program. the pic should insert itself into the program after it has been selected, and the picture should resize itself to fit the pic box (or viceversa if need be)
I have looked at some similar threads on this issue but none of the code in those solutions is working for me.
There is a website and it has excel file. Daily I login to it and open excel file update, save and close it and then logout. This I want automate using code.
I have been tasked with trying to build a small program to delete internet browsing history and cookies, My form consist's of just 3 buttons one to delete browsing history one to delete cookies and another button to do both. I have looked all over the internet and come across a few ways but none work any other ways to do this task?
i have a little company, where my employes work, wanted to know if they are not wasting time in my office, so i decided to make a little application to get history by all browsers, i tried and only could get from IE, but i need cross-browsers history at least minimum from Firefox + IE ?
Ashfaq Ahmed Web Programmer + Software Engineer of the world where nothing is impossible :)
How would I go about having my program monitor all open (or at least the current active) Internet Explorer windows and their current URLs? Basically, I want my program (running in system tray) to monitor the web page that is being viewed in an Internet Explorer window (NOT an integrated web browser control), and if it detects the loading of a specific URL address, execute whatever code.
Dim OrgValue As String '%USERPROFILE%AppDataLocalMicrosoftWindowsTemporary Internet Files Private Sub Form1_Load(sender As Object, e As System.EventArgs) Handles Me.Load 'read the key of temp internet folder
I'm creating an open-source web browser in VB.NET and I'm trying to load the browsing history from My.Settings.History (StringCollection) and list the items in a listbox, but only the first item appears.
Here is the code I am using:
Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
I am currently working on a Web browser and I want to make a button to delete the browsing history. I found the file URLHIST.TLB but I cant Register it.
I've tried multiple times to create a web browser with tabbed browsing. I know that I have to use "tab control".
I have succeeded in creating a semi-tabbed browsing. People are able to add new tabs, but the webbrowser component only appears in one tab page.[code]...
i need something simplei tried using webbrowsers to view files, had 5 different browsers in a tabcontrol and it seemed to slow down the pc.. hmmm.. so, maybe the basic vb coding will do..although it was easy w/webbrowsers, just WebBrowser5.Navigate("C:Documents and SettingsOwnerDesktop ru filesemulators") and it was done... anyways,
I am trying to make it so if a button is pushed then it will take you to a file browser where you can select a image. after you select an image and click ok then it will upload the image to a picture box. Is there any way to do this with the folderbrowser dialog?
how do I disable browsing to a http link from a Html editor. I have a vb.net web form with a html editor, when I add a hyperlink to the html editor, for example my application website for instance[URL]...When I run and click the link I can browse my application from inside the Html Editor which is so weird.It should open the link in a new window. How do I stop this from happening.This is an Intranet application. And the component for Html Editor is of TMS.
Or is there any Javascript code available where I can deactivate the link from an HtmlEditor, i mean when i add any hyperlink it should be not be activated , or no should be able to browse it from inside the HtmlEditor ?
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped) da.Update(dt) << This line 'da = dataadapter
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
I am trying to create an application where you can browse to a folder, press install button and it will copy some files to the directory of your choosing? I found some example code but how do i go on with my code from here? Cant figure out how to copy the files. You can see at last in the code i tried to copy files but its not really working, how do i use the function? I want the files to come from the application directory. And copy to the browsed folder.
Public Class Installer Private Sub Installer_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load End Sub
I have a program that autologs itself into facebook and monitors posts to my main page and tells me if anything new comes up. Every minute my program refreshes the page and searches for a new post, if my session is expired it logs itselft back in automatically. If I'm in explorer trying to play farmville and my facebook monitor program is running then I'm forced to log in about every minute because my login at the browser kills my vb.net program session.
Then my vb.net program logs itself back in and I'm out! This behavior doesn't happen If I have two browsers running I can log into both and it doesn't seem to effect the other. I can even have my wife log in from another machine while I'm logged in and It's ok. So The question is why is useing the webbrowser controls in the Vb program any different then just having 2 open and logged in browsers and jumping between the two.
We are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
Friend WithEvents dtpReportDate As System.Windows.Forms.DateTimePicker
The default date picker has left arrow and right arrow which allow you to browser previous month and following month. I add a handler to date picker valuechanged event:
Private Sub dtpReportDateChanged(ByVal sender As Object, ByVal e As System.EventArgs)
'do something here
End Sub
The problem is that whenever I click left arrow or right arrow to change month, the dptReportDateChanged is triggered. I do not want this happens. All I want is that after I find a month, I double click date to trigger the event.
