Create An Application Which Will Interact With SQL Server 2008?
Oct 10, 2011
I'm doing a project in VB.NET, in which the application will interact with SQL Server 2008 database. I know how to develop that application. But after created executable version of that application(.exe) i will install it in another machine. How will that application interact with database at that machine??
I want to start building my first large program. I want to create scripts on their own and allow them to interact with my main sub. I guess if I need a "plane" in my application, that could become it's own class? If I wanted to calculate "purchases", "money" I could create a DLL? I don't want to have to change things and have to recompile my entire application every time I want to change how something works for example.
I've recently created my first serious Windows Service. It is a chat Server that can interact with a mobile Platform.Now If a Exception occurs in OnStart Sub you have no way of knowing there was an exception other than the misleading messagebox.I've Pinpointed the Exception to my fairly Simple log Class that Writes to a log file. Please look if you can see any obvious places where exceptions could occur. [code]
How would I send that to a remote server as if I had just filled out a form on a webpage? Specifically... I'm looking to have a program automatically log me in to a web site like Facebook, get important details/updates, then log out.
At user login, launch an app I have created. This app opens a web site in a webbrowser control, logs the user in to the web site, and parses links from the resulting web page. These links are links to launch citrix sessions on another farm.
Create another app that appears on the start menu for the logged in user. User clicks on this app, it communicates with the launch app to basically click the href associated with the citrix app within the webbrowser control. Then this app will go away...
I have already coded the first app and figured out how to click links within the webbrowser control. What I can't figure out is how to go about implementing the second app, that runs as a separate app, but communicates with the first app to do its business. I see a plethora of options such as MFC, AppDomains, RPC, and so on. My question is which is the best practice to have one app interact with another and have the other app take actions based on that interaction? I prefer to stick completely to vb.net.
A good example of how I would like this to work - a web browser (IE, FF, whatever) is open on the desktop, user clicks a link in an email, link opens in running browser. An action in the mail client causes action in the browser.
I've search numerous hours, but I haven't been able to find the appropriate solution. What I want to do: Get the html of a certain webpage (Lets say in this case url...this html within my wpf application, so that you can see the content of the page you requested. Then I want to be able to trigger events on the html that has been loaded from the URL. Like I want you to be able to click on a certain node in the HTML and I want to be able to link this node to a certain value. Basically a crawler application that let's you request a page, see the page in a control and allows you to click in the loaded HTML and link values to predefined values you set. So basically I want to be able to get a webpage displayed within my application and be able to trigger events on the html (For example a click on the html which would need me to know on what node you clicked in the html, or for example be able to edit the html by clicking in it).
As i am trying to create a custom FTP server for an application i've been reading up on this for a while. One part of the problem is obviously the multi threading issue.Now i know that the synclock command will lock an object to the thread that requested it's lock, however in an example on the internet i found the following construction and i am wondering why he would do this.
Code:Private Sub ProcessClient( NewClient As Client )Call SendMessage( "530 Acces Denied", NewClient.ControlSocket) more codeEnd Sub Private Sub SendMessage(ByVal message As String, ByVal ToSocket as Socket)Dim CurrentThread As Thread = Thread.CurrentThread SyncLock CurrentThreadToSocket.Send(Message)End SyncLockEnd Sub Now ProcessClient is a thread that is trying to do some stuff with a newly connected client and SendMessage is just a sub in the same class as where the thread was created. Now normally one would synclock a "syncobject" however here he calls a sub and then from that sub he synclocks to the thread that called it. I wonder what the use of that is and why he does it this way?
I have removed the synclock statement and as I expected it functions exactle the same as it does with it. I tested it with multiple users at the same time trying to connect to it.
I am trying to create a a server and client application. All that I want to do is have a client that has a picture box. The server will send an image to the picture box and the client will display it. I have looked online to find some tutorials but most of them just show how to do a connection and usually only with a console application.
i'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
Im a new in this VS2008. But i have some foundation of programming in VB6.0. So im planning to create this application using VB since im familiar in that language.I downloaded a Visual Studio 2008 and SP1 - now on its 90-day trial, and planning to buy the full version depending if it will meet my needs. I just read afterwards the conditions and how to buy it. I hope its free shipping and credit card is acceptable.^^
I need to make an application something like a reporting system, my plan application is a client-server application. Currently im reading the How to topics and some walkthroughs so far so good. Now here are some sort of details and target need to fulfill.
1. An interface from client that will input the data from the multiple-user , including images and these data will be saved in database/table remote server (center database server) LAN.
I have to create a Client/Server Application...for a project...Its not a programming class so the Professors allowing us to look code up online and just use that...Can anyone help get me started, Ive found some code but most of it uses TCPListener and Visual Studio says this is obsolete. An I can't get the IPaddress to be declared either..
I have never interacted with Varbiles outside of the projject but now in need of it.I am developing a Windows Service Application that is multi-threaded. There is going to be a set of Global Varibles in the application that contain basic status information such as how many threads are currently running, What clients are currently connected etc.
Now I would like to develop another application as a monitor. This one would be a Windows Forms App and its sole purpose is to display to the user this information so that is can be monitored.Is there an easy way of doing this? If not I don't think I will bother as the Monitor is not essential.
We would like to create a client-server architecture application that the server can control all client computers connected to it (e.g shutdown) and we would like to put a security login and a desktop lockeron the clients. The process of the system is that when the clients starts, the desktop is locked and ofcourse the user can't access the desktop unless he/she logged-in. And when the scheduled time (e.g 1 hour) is done, the client computers where automatically shutdown like the Time Logger Softwares
I am new to working with SQL databases (and databases in general) so I do not have a lot of experience with how queries work and how I can practice them. When I was first learning xml and XPath, I found XPath Visualizer incredibly helpful after someone on stack overflow mentioned it to me.Due to this, I am wondering if a similar tool exists for SQL databases?Basically a tool that will allow me to connect to a database,enter queries and see somehow what the results would be like.
I have looked online a bit, however I have found relatively few options in terms of any utility that would do what I want, and that looks reliable.I will ultimately be writing an application to interact with an SQL 2008 server in vb.net, however for now I am just experimenting so I will know what I am doing when I actually want to create my application.So far I have managed to connect to the database using an OLE DB connection, but I am now looking for a way to experiement with queries without just querying and figuring out a way to interpret the results in my program. Basically I want to be able to remove the programming aspect of things so I can experiment with queries without needing to question anything in my code that is unrelated to the specific query.
I'm bulding a program that willl work with a database the database is made with mysql.I would like to know if there is a way to install the DB automatically with the application without requiring the user to create a mysql server...the db have more than 5 million records.
This part of visual basic is new to me. How can i make multiple forms that each operate on different computers but can interact with each other and influence each other over the internet?
I've seen loads of programs that use an icon in the system tray to let you interact with a windows service that is running on your machine but I am curious as to how this works. As I understand it, unless a service marks itself as 'interactive' then it has no way to communicate with the user's desktop and doing so is discouraged by MS (and even causes an alternate desktop to appear temporarily in Server 2008 in some cases). So I want to try and avoid doing this but I cant think how else I would do it, and even if I marked my service as interactive I'm not too sure how I could actually get it to show a notification icon in the system tray.
I assume I would have to use Windows APIs, unless just using the windows forms NotifyIcon class would work. I considered just having the system tray icon in a totally separate application that just communicates with the service via named pipes or TCP etc but I'm pretty sure this isnt how other programs do it because with most of them if you just kill the process that the service is running in then the icon disappears so it must actually be directly running from the service.
I'm using Visual Studio 2008 on an XP machine and am trying to develop a web app that can interact with websites and carry out automatic tasks.One problem I have is trying to recreate the web requests for automatic interaction.
For example:I use a webBrowser control to allow me to surf a page manually. Then, once I am at a specific location, I'd like the automatic interaction to take over.Part of the website requires a log-in and exchanges cookie data.When I try to read the cookie info from the webbrowser control to build the subsequent automatic requests, the cookie content is incomplete.Upon further investigation, it appears that the site sets one of the cookies to "http only". This stops the value being visible to the webbrowser control.Is there another control or method I could use to retrieve this info?
When it comes to threading. I've managed to adapt one of JMcIllhinney's backgroundworker codebank examples to somewhat suit my needs, but not completely. I have a main form, and a second form that appears while I'm running through a for loop. It informs the user what is currently happening. I set up a backgroundworker that allowed me to continue to use the main form during the for loop, but the other "status" form was completely frozen, and any labels or graphics were shown as white boxes. I am struggling to figure out how to be able to move/interact with both forms while the loop is running.
I am developing an IT Asset Tracking application using VB 2005 and SQL Server 2005 Express edition. Will I need to create classes to represent objects such as Computers, Printers, Scanners/Faxes, Contracts, Purchase Orders etc or are there any other approaches.For example, if I am correct, I will have a class called Computer and its properties will include Make,Model,CPU,Hard Disk,Memory etc. Is this the right approach.
Computers can be split up into Desktop PC's, Servers and Notebooks. Would I have to create separate classes for these as well or would they be ok under the Computer class.Once I create an object from the class, how can I use the object to interact with the SQL db.I am a beginner to VB.NET 2005 therefore I am slowly getting to grips with OOP.
I'm using ReportExecutionService to create file on a different server on the network. The application does the required job if I run it locally, but fails to create file when I publish it. The error I get is- Access to the path '\servernameapth..xyz' is denied. The folder has full access to Domain users. Here is my code to create a report file on a different server via an ASP.net app.
My DBA has several SSIS packages that he would like the functionality of providing the end user with a way to input values for variables in the package. What would be the best solution for creating an application that would take the user input and pass the data through to the SSIS package variables?
I can get this work locally using this code
Dim packageName As String Dim myPackage As Package Dim integrationServices As New Application
[code]....
Problem is this requires that the user have SSIS installed locally.