|
OK. But i have another question-
If i create a windows service to manage the data from the barcode reader (the data will go to clipboard and then set focus to my application),
How can i install this windows service on a user computer (without installutil etc.)?
|
|
|
|
|
You could install the windows service like this, if u are using .Net FrameWork 3.5.
I found that the file named "System.Configuration.Install.dll" in .Net 2.0 is different from the .Net 3.5's.
There are some simple code.
using System.ServiceProcess;
using System.Configuration.Install;
using System.Collections;
private bool isServiceIsExisted(string NameService)
{
ServiceController[] services = ServiceController.GetServices();
foreach (ServiceController s in services)
{
if (s.ServiceName.ToLower() == NameService.ToLower())
{
return true;
}
}
return false;
}
private void InstallmyService(IDictionary stateSaver, string filepath)
{
AssemblyInstaller AssemblyInstaller1 = new AssemblyInstaller();
AssemblyInstaller1.UseNewContext = true;
AssemblyInstaller1.Path = filepath;
AssemblyInstaller1.Install(stateSaver);
AssemblyInstaller1.Commit(stateSaver);
AssemblyInstaller1.Dispose();
}
private void UnInstallmyService(string filepath)
{
AssemblyInstaller AssemblyInstaller1 = new AssemblyInstaller();
AssemblyInstaller1.UseNewContext = true;
AssemblyInstaller1.Path = filepath;
AssemblyInstaller1.Uninstall(null);
AssemblyInstaller1.Dispose();
}
Good Luck!
|
|
|
|
|
Will this code start the service too?
|
|
|
|
|
If set the windows service autorun, when you restart computer, the service will start.
Of course, you can start the service in manual like this.
private bool StarmyService(string name)
{
ServiceController sc = new ServiceController(name);
if (sc.Status == ServiceControllerStatus.Stopped || sc.Status == ServiceControllerStatus.StopPending
)
{
sc.Start();
sc.WaitForStatus(ServiceControllerStatus.Running, new TimeSpan(0, 0, 10));
}
else
{
}
sc.Close();
return true;
}
And stop the service like this
private bool StopmyService(string name)
{
ServiceController sc = new ServiceController(name);
if (sc.Status == ServiceControllerStatus.Running ||
sc.Status == ServiceControllerStatus.StartPending)
{
sc.Stop();
sc.WaitForStatus(ServiceControllerStatus.Stopped, new TimeSpan(0, 0, 10));
}
else
{
}
sc.Close();
return true;
}
|
|
|
|
|
OK and how can i set the service to start automatically ? i mean in the service code.
Also how can i check if the service is already running?
|
|
|
|
|
OK, the simple code to check if the service is running like this.
private bool IsRunning(string name)
{
bool IsRun = false;
if (!isServiceIsExisted(name))
{
return false;
}
ServiceController sc = new ServiceController(name);
if (sc.Status == ServiceControllerStatus.StartPending ||
sc.Status == ServiceControllerStatus.Running)
{
IsRun = true;
}
sc.Close();
return IsRun;
}
Set the service to start automatically:
Change the value of property named "StartType" of the windows service to "Automatic".
BTW, owing to the limitation of my knowledge, the code are not very strong.I suggest that you can research them by yourself. I think that after you reserach them, you will learn more.
|
|
|
|
|
OK , and how can i set the service to start automaticallu ? i mean programatically?
also how do i check if the service is already running? or it's not matter?
|
|
|
|
|
The function "IsRunning" will check if the windows service is running.
I think that when creating a windows service just like creating a application, so I do not know how to create it programatically. We must set the windows service before we release it.
|
|
|
|
|
I feel that using a socet connection between service and application is not a good idea because this connection can be terminated by firewall etc
ps use logging instead
|
|
|
|
|
I.C.
But, just remind once.
I know little about the Logging, I will have some research about that.
|
|
|
|
|
A Windows service almost never has access to the desktop. See this[^] article.
/ravi
|
|
|
|
|
Yes, it can not instantiation a win form and show it.
But I think that the socket could connect the win service and win app.
|
|
|
|
|
To capture Keyboard stream use hooks
Read this http://msdn.microsoft.com/en-us/library/ms632589(VS.85).aspx[^]
Simple example
<br />
using System;<br />
using System.Collections.Generic;<br />
using System.Text;<br />
using System.Diagnostics;<br />
using System.Runtime.InteropServices;<br />
<br />
namespace hook<br />
{<br />
class Program<br />
{<br />
private const int WH_KEYBOARD_LL = 13;<br />
private const int WM_KEYDOWN = 0x0100;<br />
private static LowLevelKeyboardProc _proc = HookCallback;<br />
private static IntPtr _hookID = IntPtr.Zero;<br />
<br />
static void Main()<br />
{<br />
_hookID = SetHook(_proc);<br />
Application.Run();<br />
UnhookWindowsHookEx(_hookID);<br />
<br />
}<br />
<br />
private static IntPtr SetHook(LowLevelKeyboardProc proc)<br />
{<br />
using (Process curProcess = Process.GetCurrentProcess())<br />
using (ProcessModule curModule = curProcess.MainModule)<br />
{<br />
return SetWindowsHookEx(WH_KEYBOARD_LL, proc, GetModuleHandle(curModule.ModuleName), 0);<br />
}<br />
}<br />
<br />
private delegate IntPtr LowLevelKeyboardProc(int nCode, IntPtr wParam, IntPtr lParam);<br />
<br />
private static IntPtr HookCallback(int nCode, IntPtr wParam, IntPtr lParam)<br />
{<br />
if ((nCode >= 0) && (wParam == (IntPtr)WM_KEYDOWN))<br />
{<br />
int vkCode = Marshal.ReadInt32(lParam);<br />
if (((Keys)vkCode == Keys.LWin) || ((Keys)vkCode == Keys.RWin))<br />
{<br />
Console.WriteLine("{0} blocked!", (Keys)vkCode);<br />
return (IntPtr)1;<br />
}<br />
}<br />
return CallNextHookEx(_hookID, nCode, wParam, lParam);<br />
}<br />
<br />
[DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = true)]<br />
private static extern IntPtr SetWindowsHookEx(int idHook, LowLevelKeyboardProc lpfn, IntPtr hMod, uint dwThreadId);<br />
<br />
[DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = true)]<br />
private static extern bool UnhookWindowsHookEx(IntPtr hhk);<br />
<br />
[DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = true)]<br />
private static extern IntPtr CallNextHookEx(IntPtr hhk, int nCode, IntPtr wParam, IntPtr lParam);<br />
<br />
[DllImport("kernel32.dll", CharSet = CharSet.Auto, SetLastError = true)]<br />
private static extern IntPtr GetModuleHandle(string lpModuleName);<br />
<br />
<br />
<br />
}<br />
}<br />
<br />
|
|
|
|
|
how do i use this code? where do i put in? in the program.cs ?
and is it a windows service?
|
|
|
|
|
Dear All,
I have two DataTables. The first (FirstDataTable) is filled by a query and the second is filled by:
SecondDataTable= FirstDataTable;
after this equal operation, the two DataTables are connected and any change is reflected between the both.
I mean when you change the data in the FirstDataTable by a different query, this change will be reflected to the SecondDataTable automatically.
The question here: How can I stop or reject the connection between the two DataTables.
I mean I do not want to reflect the changes after the equal operation. this is to make a copy of the first data returned by the first run of the query.
Regards.
Kind Regards
OBarahmeh
|
|
|
|
|
obarahmeh wrote: SecondDataTable= FirstDataTable;
This means both tables are referring to the same object in memory. What you can do is, create a deep copy of the FirstDataTable. You can find a lot of examples on web for doing this.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Hello,
I have a barcode reader attached to my computer using USB (specific port).
I want my program to run in the background and once the barcode reader read something (8 chars code), this code will be inserted into clipboard.
I know to insert string into the clipboard but how can i check the interupt from the barcode reader (and only it) and only then the program will insert the code to the clipboard, otherwise it won't do nothing.
How can i do it?
|
|
|
|
|
You need to use SerialPort component and the USB specifications (baud rate, stop bit and parity).
A good start would be here.
Cheer's,
Alex Manolescu
|
|
|
|
|
Hi,
I'm gonna get a SQL backup with below method :
void BackupDatabase(string sConnect, string dbName, string backUpPath)
{
using (SqlConnection cnn = new SqlConnection(sConnect))
{
cnn.Open();
dbName = cnn.Database.ToString();
ServerConnection sc = new ServerConnection(cnn);
Server sv = new Server(sc);
BackupDeviceItem bdi = new BackupDeviceItem(backUpPath, DeviceType.File);
Microsoft.SqlServer.Management.Smo.Backup bk = new Backup();
bk.PercentComplete += new PercentCompleteEventHandler(percentComplete);
bk.Devices.Add(bdi);
bk.Action = BackupActionType.Database;
bk.PercentCompleteNotification = 1;
bk.BackupSetDescription = dbName;
bk.BackupSetName = dbName;
bk.Database = dbName;
bk.LogTruncation = BackupTruncateLogType.Truncate;
bk.FormatMedia = false;
bk.Initialize = true;
bk.Checksum = true;
bk.ContinueAfterError = true;
bk.Incremental = false;
bk.SqlBackup(sv);
}
}
But an exception has occurred :
Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server '\\.\pipe\3F103E6E-3FD4-47\tsql\query'
additional info about the Exception:
{Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server '\\.\pipe\3F103E6E-3FD4-47\tsql\query'. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
=== Pre-bind state information ===
LOG: User = MDS-PC\MDS
LOG: DisplayName = Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
(Fully-specified)
LOG: Appbase = file:LOG: Initial PrivatePath = NULL
Calling assembly : Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91.
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: D:\My Works\C#\Win Form\Reza Restaurant\RezaRestaurant\bin\Release\RezaRestaurant.vshost.exe.Config
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework64\v2.0.50727\config\machine.config.
LOG: Post-policy reference: Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
LOG: Attempting download of new URL file:LOG: Attempting download of new URL file:LOG: Attempting download of new URL file:LOG: Attempting download of new URL file:
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
at RezaRestaurant.Form_تنظیمات_نرم_افزار.BackupDatabase(String sConnect, String dbName, String backUpPath) in D:\My Works\C#\Win Form\Reza Restaurant\RezaRestaurant\Forms\تنظیمات_نرم_افزار.cs:line 260
at RezaRestaurant.Form_تنظیمات_نرم_افزار.button_تهیه_نسخه_پشتیبان_Click(Object sender, EventArgs e) in D:\My Works\C#\Win Form\Reza Restaurant\RezaRestaurant\Forms\تنظیمات_نرم_افزار.cs:line 177}
Would you please guide me ?
Thanks.
|
|
|
|
|
Check if you have the package installed in the computer. In case it is not, you will need to install it. You can get the package from MSDN.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Do you mean here[^] ? if so, I installed
Microsoft SQL Server 2008 Management Objects
X64 Package (SharedManagementObjects.msi) - 3895 KB
But I receive the exception again.
|
|
|
|
|
SQLServer2005_XMO.msi does that for SQL Server 2005 32-bit. I am not sure about SQL 2008. Probably you can search for similar file for SQL 2008. Also, once you install the package, check for the dll at the following path:
c:\Program Files\Microsoft SQL Server\100\SDK\Assemblies
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
|
Check the SQL version. In the previous post of yours, you gave link to file for SQL 2008 and now for SQL 2005. Just make sure you have correct files.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Actually I have been installed VS2008 and as I know it installed SQLExpress2008,
d@nish wrote: Just make sure you have correct files.
I installed it and the exception haven't occurred anymore, now the method works well.
|
|
|
|
|