Is there a relatively simple way that my VB.NET application can be notified of the fact that a new value has been written to a table in SQL Server Express 2008? Polling is not an option since I'd need to do that every 10 seconds nonstop.
View 1 RepliesThis is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
View 5 RepliesA notifyIcon is down in task bar, a user left clicks on it, how to show the contextmenu after left click?
View 1 RepliesPublic Sub cleanTables(ByVal prOKDel As Short)
Dim sqlParams(1) As SqlParameter
Dim sqlProcName As String
[code]....
and finally datatable dt = dbConn.Execute(CommandType.StoredProcedure, sqlProcName, sqlParams)
I have been working with the Notify Icon to make it easier for some who prefer minimizing an application into the notification bar rather than the task bar. I have a drop down item that allows the user to Show in Notification area if checked. If it's not checked, then the form reverts back to default with the task bar. However, when this is checked and I minimize the form, I can not open the form from the notification tray. The problem is when the notify icon is visible and clicked, I need it to run code. If the form is minimized, I want it to show the app when I click the icon.
Here is my code:
Private Sub ShowInTaskbarToolStripMenuItem_Click(sender As System.Object, e As System.EventArgs) Handles ShowInTaskbarToolStripMenuItem.Click
If ShowInTaskbarToolStripMenuItem.Checked = True Then
NotifyIcon1.Visible = True
[Code] .....
I am working in a project where i have to add employees in a company. I have a form with text fields(for example name,surname,age,...). What i want is to insert this txt values into a database. My project is connected with an sql database. How can i add the values into a data table on button click("submit")?
View 9 RepliesI have been developing a VB 2008 application which has been using Access as its database. The app is very far a long with about 30 forms and 45 DataSets I now must change the application to use SQLServer. Unfortunately all of the Table & Attributes names have changed in the new DB. Almost all of the data model has stay the same.
I have a few questions on the conversion.
The ConnectionString is currently pointing to the Access DB. I have entered the new ConnectionString into the Setting tab. What is the best approach to make the change?
I have done some testing to change the Table & Attributes names by using Quick Replace. It seams that sometime when I would do the rename I would lose the TableAdepter on some screens.
What is the best approach to performing the renaming task?
how can I restore sqlserver database from VB.net or C# Application?
View 2 Repliesi am doing school software projects in windows application. now i want to install. this project to my client place. i can able to convert my application in to EXE using setup project. The problem for me is the database. i am using sqlserver 2005. i don't how to install my database and table into the client computer. is there any way to copy the database. if anyone have any idea about how to install my database i have create for that application into client computer.
View 1 RepliesWhen I try to install an application to another user's computer I receive a message box that says "Unable to run or install application. The application requires that assembly Microsoft.SqlServer.Pipelinehost version 9.0.242.0 be installed in the global assembly cache (GAC) first.A key feature of the app is to export data from sql server to an excel spread sheet so I have the following import statements
View 3 RepliesI'm trying to complete this airline reservation application, but having a problem in this part of the question:Creat an event handler for the FlightBindingSource's PositionChanged event: select FlightBindingSource in the class Name combobox then select position changed in method name combobox to creat the FlightBindingSource's PositionChanged event handler. Write a code to access the currently displayed flight object and pass its flightNumber to method DisplayPassengers as a decimal.This Is my code so far:
HTML
Public Class AirlineReservationForm
Private database As New ReservationsDataClassesDataContext()
Private Sub FillAll()[code].....
Ultimately, what I want to accomplish is an AJAX-based messaging system. I already have a database table for messages, and an ASPX to add new messages (and declare old messages no longer relevant).
The current messaging system simply polls the server every 15 seconds, and re-pulls the current message set.
What I am looking to do is: On $(document).ready(), register an ajax callback function that listens for a server-side event (e.g., MessagesUpdated) On table insert/update, fire MessagesUpdated server-side.
This way, whenever the table is updated (or new records added), any clients listening know that new data is available and can re-poll the server then.
Ideally, I'd also like to make the new data available as an event argument (to minimize re-polling the db).
I can find references to something like this in other languages, but I cannot find any actual code examples to get me started.
Assuming this is possible to do via .Net, can anyone help get me started on this?
I'm using the 2.0 Framework. Also while I added a VB.Net tag, I can read C# reasonably well, so please feel free to post in either language.
I have an application I have developed which works great on individual PC's. However I've had some interest from a few customers that asked if I have a network version for site licencing.If my app did not save any data or write any reg entries, this might have been ok. But it does to the local computer. I also built in my own copy protection and trial function that stores data in the registry on the local computer.What would I need to do to enable my application to run on a server/network share, so that the only a serial number needed is for the server?
View 3 Repliesi'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?
View 9 RepliesCase : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
I need to read the email from the mail server that is in my intranet from my application server.
View 9 RepliesI planing to develop an application which can connect any remote server and pick the configuration information from server and show it in my desktop.
View 4 RepliesAn application loaded on a citrix server executes with no problem. When we try to run the same program files on a virtual server, we get silent errors and we do not even see the application window appear. The program runs for a moment in task manager, but then closes down. BTW other .net apps run on the virtual server. Here is the error we see in the event viewer application logs[code]...
View 2 RepliesHow to make clients on sql server i mean when i will install my application on clients how i will connect it with sql server?
View 6 RepliesI m getting the following error when i upload my site to Production Server using Database in App_Data ASPNETDB.MDF
Server Error in '/' Application.
Runtime Error
[code]..... ...
i'm newbie in this programming..i need some references or a starting guide to build an sql server and vb.net application.
View 3 RepliesI am creating small application (desktop search engine) which uses sql server as back end. Sql server is used to store huge data using indexing (for quick search). Is it necessary that client should have sql server on his machine to run the application? I don't want to install sql server on client's machine, because my application is just a small utility.Is there any other way so that I can store huge data using indexing?
View 2 RepliesIm planning to create a Remote Desktop Application and I'm having problem with viewing other computers monitor or screen.
Im not asking for the code on how to do it. and one more thing is it safe to use winsock in creating a client/server application?
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 am trying to run simple application (e.g. generated from template by VS.NET 2010) on IIS6. I changed it to run with .NET 4.0 (its application pool) and checked with regiis (this pool has 4.0). I also changed all possible httpHandlers (svc etc), to run with NET4.0. All possible rights are checked (i think so). Almost every request results in "Server Application Unavailable" (sometimes it is empty page with -2146232576 (0x80131700) value) and "...Please review this log entry to discover what caused this error to occur." but EventViewer and IIS Log are empty.
View 2 RepliesI have wrote an Application for a organisation and they had let the app run in their lan using Samba, it worked perfect. Now they want to work over the internet.The Problem is that I have written this app with Sqlite, that means its currently working so:They have a exe and the sqlite dll and the sqlite database on their samba server and they connected a network drive on their windows pc to run it. So that means every pc is writing over samba to the sqlite database.
I tried it over the internet, but like i thought sqlite is a local database and its very slow, even if the ping is under 50ms. I could create a tcp server, that handles all and writes all to the sqlite database, but I have already written around 20.000 code lines for the project, so that would be not the best option for the lazy me. I have used only one sqlite class in my client for querieng, so I thought that it could work without much work, if i would replace the sqlite database adapter with the mysql database adapter, since sqlite has nearly the same syntax then mysql.
Question: I created an ASP.NET web application. Now it originally was meant for deployment on a webserver.That is working, so, so far so good.My question now is: Is it possible to deploy it as a desktop-application, too? That is to say the installer installs some kind of server, plus the web application, configures the server to run this application on a localhost URL, and then creates a link in the start menu/desktop, where it opens that url (website, the application) on localhost in a web browser?
I think it should be possible, though the server wouldn't be IIS, because this is a windows component which can't be separately installed. Is there anything like this already out there The nonplusultra would be that it only starts the server when you click on the shortcut.
I created this simple textpad program in WPF/VB.NET 200 that automatically saves the content of the forms to an XML file on every keystroke.Now, I'm trying to make the program see the changes on the XML file in realtime.. example, If I open two of my textpads, when I write on the first one, it will automatically reflect on the other textpad.
View 4 RepliesUsing VB 2008 .NET 3.5..I am working on an N-Layer desktop application.Suppose a method in the BLL runs into an situation where the user needs to be notified and the method needs to wait for the user input (OK, Cancel, etc.) before continuing.Assume that this situation happens fairly often but not all the time, and is expected. It doesn't seem correct to throw an exception. The only solution I have so far is to raise an event with a custom EventArgs, and allow the UI to set some property in the custom EventArgs to reflect the user input.
View 1 RepliesI have a program here which im trying to intergrate a alarm.I would basically just like a alarm to go off at a specified time and a message box come up notifying me.[code]
View 1 Replies