Write A Windows Service Used As SMS Gateway To Push And Pull Sms To Database
Aug 21, 2010Who can write a windows service used as SMS gateway to push and pull sms to database..
View 3 Replies
ADVERTISEMENT
IDE :: Pull Data From Source Database, Manipulate It And Push It Into The Destination Database?
Jan 22, 2009I have VS 2005 installed in my sytem fyi.We have two databases, say source database and destination database. The databases is in Oracle. Now we need to pull data from Source database, manipulate it and push it into the destination database on daily basis.We are planning to use VB .Net for this and would like to know if this is feasible. Using windows forms through VB .NET, is it possible to create a exe and schedule the exe on nightly basis to pull the data from source to destination.how to do this as for manipulation of data, there is no intermediate database for us?
View 1 RepliesMulti-user Application - Updating All Clients When A User Updates Data (push Vs Pull)?
Aug 26, 2009I am designing a fairly small application to manage a waiting area for a clinical department. There will be a receptionist who books appointments and updates exisiting appointments to say that a patient has "Arrived". In seperate rooms will be nurses who call patients who have "Arrived" and update the appointment as "In Session" and finally as "Discharged". The appointments are viewed in a flexgrid with nurses across the top and time down the left, patient names are displayed at the relevant times and the cells are shaded a colour to represent the current appointment status ("Booked", "Arrived", "In Session" and "Discharged").
I am using SQL Server as the back-end and Visual Basic 6 (I know) as my front-end.I have been told that there will be 2 or 3 nurses plus the receptionist logged in to the system but I would like to cater for growth.My question is what is the best mechanism to use in order to reflect the status change made by one user on the screens of the other users currently logged in?
I have been thinking about using a timer to refresh the data at a set interval but I do not want to keep hitting the server excessively (although what is considered excessive? we would be talking about a call for data every 60 secs per user). Plus the server could be serving data for many other applications so this is another consideration.Alternatively I have been thinking about sending some kind of message via Winsock to the other users notifying them of data changes as they happen. I don't have a lot of experience with this and am concerned about clients not receiving messages and users seeing old data. It also seems strange to me that once the days appointments have been retrieved from the database that "in theory" a client could go the whole day without having to query the database again to pick up changes - kind of scary.Some information on the data:We would probably be looking at around 100 appointments per day We capture patient name, date of birth, date and time of appointment and appointment status.What is the standard approach / best practice for this kind of scenario?
Windows Service: Write To Log File
Aug 22, 2010Trying to develop a windows service which will write to a log file at prefix interval, but surprisingly the code "writelog" routine which previously work in a normal windows system but doesn't work under service.
[Code]...
DB/Reporting :: SQL Database With Windows Service?
May 14, 20081. I have a windows service type of application that first creates a database on the local SQL server (and a table). It then starts putting data into the table.
2. This works fine when running as a normal application but due to permissions, when it is run as a service, it can create a database but then fails to connect to it to create the Table. I understand that because its a LOCAL SYSTEM service, SQL might have problems but why does it let it create a database but not a table?? .
3. Is there anyway I could hard code a USER NAME for this database my application creates and then use it to get in? As it uses an exclusive database, I don't want to prompt the user for an SA account (and their sql may not be mixed mode).
Monitor A Database With A Windows Service?
May 26, 2008I'm using VB.NET 2008 (framework 3.5). I would like to check permanently if a new entry (row) is added to a table in particular, (is there some equivalent of the FileWatcher for DB ?...)
View 4 Replies.net - WCF Service Hosted In A Managed Windows Service Connect Using A WCF Service Application
Jul 14, 2011i have a Windows service that is hosting a WCF service through net.tcp and this is working great. I have also created a WCF service application. I am trying to add the net.tcp service reference to the service application. Then I add it to the GAC that goes ok but if I try to RegAsm the WCF service application to allow it to be called from Server.CreateObject I get the error:
Warning: Type library exporter encountered a type that derives from a
generic class and is not marked as
[ClassInterface(ClassInterfaceType.None)]. Class interfaces cannot be
exposed for such types. Consider marking the type with
[ClassInterface(ClassInterfaceType.None)] and exposing an explicit
interface as the default interface to COM using the
ComDefaultInterface attribute.
It does not work. I have tried to call it through a class library but this does not work either as the end point is not set correctly.
Windows Service Interacting With SQL Server Database?
Dec 24, 2010I have a windows service application that is meant to interact with SQL server database (INSERT, UPDATE, ETC). The windows service application is also multi-threaded.I created an "App_Data " folder to keep my database and used app.config file for connection information, etc.
After installing and starting the service, nothing happens, the database doesnt get updated, etc.
Has anyone ever written a windows service application that interacts with a database? Kindly advice me on how to overcome this problem..
Windows Form With Push Button And Label
Jul 12, 2011So I need to make a windows form where it has a button to push and a label. There needs to be a list of 10 words/phrases. And when the button is pushed a random word/phrase is put into the text of the label. I have a section of code/psudo code but it keeps saying I am missing declarations when I try to run the program in debug...
Public Class Form1
'to make the list of different hello world languages
Dim strHello(0 To 6) As String
Dim blDimensioned As Boolean
Dim strText As String
[Code] .....
The errors all seem to be declarations for the lines of the array (strHello(x) = "xxxxx xxxxx")... What declaration am I missing? and how do I make the list give a random response to change the label text?
Read/ Write From/ To Web MyMysql Database Into A .net Windows Ap?
Sep 13, 2010I'm trying to write a ClickOnce ap that will connect to a web database and download the data into a collection that will be written into a local database. This will allow the user to update the data while online but use the program while offline. I see it as a hybrid ap using both Windows forms and asp sql calls.
View 7 RepliesUsing TransactionScope - Windows Service That Reads From An Excel Spreadsheet And Imports Records Into A SQL Server 2000 Database Table
Oct 30, 2007I have a simple Windows Service that reads from an Excel spreadsheet and imports the records into a SQL Server 2000 database table. Before it loads it checks if the file has been successfully imported before (using filename) and whether any of the records in the file have been imported before (using primary key). If these checks are ok I load the records into a datatable and then update the datatable to the database.
However, I need to do this in a transaction as I want to ignore the whole file if there is an error. The file goes to a discarded folder and the user gets an email with why the import failed. (This is likely to be because the store the record is for is not yet added to the database and the referential intergrity of the db fails). If there is no transaction the records before the failure record are imported. When the file is imported again (the store has been added to store table) the file is then rejected because duplicate records are already in the db.
Heres my code:
[CODE]...
[VS 2005] Service Control Manager Privileges - Communicate With A Windows Service On A Remote Machine On The Network
Jul 23, 2009I am trying to communicate with a Windows service on a remote machine on the network but i keep getting an exception saying the following: "System.InvalidOperationException: Cannot open Service Control Manager on computer 'machine001'. This operation might require other priviledges. ---> System.ComponentModel.Win32Exception: Access is denied.
[Code]...
Have A Dotnet Windows Service Which Monitor Other Services And Upon Stop Of Any Service?
Sep 18, 2009Is it possible to have a dotnet windows service which monitor other services and upon stop of any service, the monitoring service would be able to start the stopped service.
View 4 RepliesUse Windows Search Service Instead Of The Old Indexing Service To Index Files?
Jul 7, 2009In the past I had the indexing service installed on a Windows Server 2003 and used it to index files for my website. I did this by executing an OleDbCommand with a query and a connection string.How do I accomplish the same thing with the new "Windows Search Service" (Windows Server 2008) by using VB.NET? Does this work the same way so that I only need to change the Provider name which has been "MSIDXS.1" up to now? Case true, what is the new Provider name?
View 1 RepliesWindows Service: Multiple Instances Of The Same Service Class?
May 3, 2011When you create a Windows Service, you create a list of the services you want to start. The default is this:
ServicesToRun = New System.ServiceProcess.ServiceBase() {New Service}
Can you have multiple instances of the same Service class (that bind to different addresses or ports), like this?
ServicesToRun = New System.ServiceProcess.ServiceBase() {New Service("Option1"), New Service("Option2")}
Or will that cause problems? Should we use two different classes instead?
Pull Data Form Other Database To Other Database?
Mar 11, 2010I need your guide regarding to pull data form other database to other database. I'm already pull the data into Dataset using this command oracmd = New odbccommand ("Select id,name,dept from staff order by id",oracn) da = ds.fill then i need to insert to other database but it have different name of column that is Staff_Id,Staff_name,Department.
View 2 RepliesStopping A Windows Service, A Different Service Stops As Well?
Mar 3, 2009We have a server with multiple services written in .Net 1.1 and 3.5 running on a Win 2003 server. Everything runs fine, but when we stop a certain service, an unrelated service stops. I have checked and neither has any dependencies. The service we stop is in 3.5, and the unrelated service that incorrectly stops is in 1.1. We get no error messages, nor event log errors, so we are baffled.Does anyone have an idea as to what may be causing this?
View 7 RepliesWindows Service - Get The Account Name After Whenever The Service Is Started ?
Nov 17, 2011I am using this method to install windows service
processInstaller = New ServiceProcessInstaller()
serviceInstaller1 = New ServiceInstaller()
serviceInstaller2 = New ServiceInstaller()[code].....
How can I get the account name after whenever the service is started ?
Pull Data From A Websites HTML Soruce Code And Use It In A VB Windows Form?
Nov 13, 2009the "text", such as that you would find in a forum, and use it in a Visual Basic Windows Form.Everything in bold is finishedGrab theHTML source of a web page and store it into a string variable.Next I need to search that string variable for two HTML syntax, and place the text between them into another string variable
View 4 RepliesMS Access: Pull Data But Can't Pull Field Name?
Mar 3, 2010I am trying to work with an access database. If this line pulls data from a dataset and puts it into a textbox: TextBox1.Text = Me.A_DataSet.a_Table.Rows(0).Item(0).ToString How would I pull the field name? For Example, in this database I have 3 fields:
[Code]...
Pull Data From Database To Combobox?
Jun 10, 2011I'm having a problem to pull data from MS Access to my combobox. I know how to search one data using another data (e.g: using IC num to search name) but this time I just want to pull the data (e.g: name) that has several rows to my combobox. I think the method is the same but don't know where to change it.
Then when I added new names to the combobox, want to save it to my database, can each name be saved in different rows? I added the names to the combobox 1st, after that then I saved it. [code]...
Pull Text From A Textbox That Is The Key Row In A Database
Sep 3, 2011I open a form from the datagridview on a selected record in the database. When saving I have my code saving to (0) I need to somehow pull the text form the account textbox in order to save to that row in the database. here is a copy of my save button...
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
'save updates to database
[Code]......
Pull Data From Database And Populate An Array?
May 14, 2010I want to pull data from database and populate an array. Field one: A short name to call the second. Field tow: A connection string to a database.
EG: Cstr=Connstr("OrDB")
The known name of OrDB would result in a string assigned to the variable Cstr that could be a connection string to an oracle database.
Pull One Record From Database And Bind To An HTML Tag?
Jul 23, 2009In ASP.NET, what is the definitive way to pull one record from the database and bind it and HTML tag?
View 2 RepliesVB 2008 & Access Database - How To Pull Data Into VB
Dec 30, 2008I have a form as shown below:
And a database as shown below:
It is an inventory program I am doing on the side just to keep track of a small number of supplies, I want to be able to enter a barcode and have the program see if it already is in the inventory database, if not, it will allow me to enter information and add it to the database (That part works - Thanks to member on D.I.C.) If the barcode exists, I want it to fill the form with all the data from the database and allow me to update fields such as date used and used definition
Here is what I have so far:
Imports System
Imports System.IO
'Added For Database
[CODE]...
2010 - Cannot Save/Pull Data To Access Database
Mar 21, 2011I have a VB 2010 program with a single-table Access Database.I have selected the option to copy the Access Database to the output directory.When doing so, the program copies the original database to the inDebug folder.I want the original (NOT the copy) to be modified when the program is being tested.Also, when I attempted to publish the program and run it to test, I got an error which was sourced to be a temporary file (which was the database) that was missing.I think this is a reaction from the "Copy Always" option.
View 1 RepliesPull A GUID From Database In Order To Update A Username?
Jul 13, 2010I have a SQL database that is different than the one in ASP.net so I had to create a custom membership Provider. The provider to get the user looks like this:My SQL class name is CustomSqlProvider:
Public Overrides Function GetUser(ByVal username As String, _
ByVal userIsOnline As Boolean) As MembershipUser
'Dim connectionString As String = "Server=***;Database=***;User Id=***password=****"'
[code]....
After adding those gets and sets and assigning parameter variables to my Sproc parameters I get the following error: "Reference not set to an instance of an object." at this line of code:
Dim currentUser As MembershipUser = Membership.GetUser()
Dim UserId As Guid = CType(currentUser.ProviderUserKey, Guid)
And this is what I have on the UserInfo.aspx.vb Page under the Button click:
Dim sql As New SqlClient.SqlCommand("Update_User", con)
sql.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = UserId
sql.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = txtUserName.Text
VS 2010 Pull And Display The Data From The Database Into The List Box?
Jan 27, 2011I'm currently working on a Capstone Point of Sales project. We're using a multi-column list box to pull up the item #, Item Name, Quantity(may be deleted) and Price. However, I haven't had much experience with a connect database in Visual Basic. how to pull and display the data from the database into the list box?
View 5 RepliesWhich Account Using For My Service Windows Service
Jun 25, 2009I am using a windows service and tried to copy some file as below,System.IO.File.Copy("Z:abc.txt", "C:helloworld.txt")Note: Z: is a map drive from another host in 1 LAN (same LAN)I got error, "Could not find a part of the path 'Z:abc.txt'."But when I tried it at a simple application using windows application, it works with the same code as above.
View 8 RepliesWindows Service - Set Service Login?
Jul 14, 2005Tried to write my first Windoes Service yesterday with a certain degree of success but I couldnt install it.Upon running teh Install programme in the command line I was presented with a 'Set Service Login' window with a User ID, Password and Confirm Password text box.I attempted to use my windows login credentials but the install failed and was rolled back.Im using a computer on a company network with Win2k?
View 6 Replies