Have you considered using something like DTS or SSIS instead. They are set up to bulk load data.

Just a quick guess, but have you tried just printing a ^G (Control-G) to the printer port the drawer is connected to? The last set of cash drawers I worked with were triggered by a simple bell character (Control-G) being sent to the LP port. Paul Watson wrote: "At the end of the day it is what you produce that counts, not how many doctorates you have on the wall." George Carlin wrote: "Don't sweat the petty things, and don't pet the sweaty things." Jörgen Sigvardsson wrote: If the physicists find a universal theory describing the laws of universe, I'm sure the asshole constant will be an integral part of that theory.

hi, You can't delete a row from datagrid( datagrid row). What you can do is, when user hit the delete key then can delete one record from the data source ( Datatable or view) which use to show the data in datagrid and then you need to re define the datagrid's datasource. Write your logic in datagrids keydown event. if(e.KeyValue== Keys.Delete) { } Better if you go through Datagrid HitInfo or HitTestInfo methods.;) ************************** S r e e j i t h N a i r **************************

hi, I wrote an article which contain solution for this queary. Please refer that first. If it is not serving your purpose then please let me know. http://www.codeproject.com/csharp/Apply\_DataGridTableStyle.asp ************************** S r e e j i t h N a i r **************************

I think he was talking about this[^] As far as I know, VB.Net does not support indexers, though you could always used parameterized properties as a poor man's choice. "if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.

i dont think u can seek to a specific spot in the file to replace just that line, however, someone else should reaffirm this, or otherwise disprove it. here, i took a little time just now and wrote a sub which will replace any line # in a file, with the string you desire: Private Sub TextLineWriter(ByVal fileName As String, ByVal lineNumberToReplace As Integer, ByVal textToWrite As String) Dim inFile As IO.StreamReader = IO.File.OpenText(fileName) Dim tempString(-1) As String Dim i As Byte 'read the file given and save each line into a new array element string Do Until inFile.Peek = -1 ReDim Preserve tempString(tempString.Length) tempString(tempString.Length - 1) = inFile.ReadLine Loop inFile.Close() 'determine if supplied 'numberToReplace' is valid with the current file, 'and correct the problem if so If lineNumberToReplace - 1 > tempString.Length - 1 Then lineNumberToReplace = tempString.Length ElseIf lineNumberToReplace - 1 < 1 Then lineNumberToReplace = 1 End If 'write the 'textToWrite' at the line number given tempString(lineNumberToReplace - 1) = textToWrite 'create same file as given (overwriting it) and rewrite the entire file Dim outFile As IO.StreamWriter = IO.File.CreateText(fileName) For i = 0 To tempString.Length - 1 outFile.WriteLine(tempString(i)) Next outFile.Close() End Sub use it like this: TextLineWriter("C:\myFile.txt", 3, "Here is my newly put text.") no need to use Imports system.io for it, it is already specified in the sub. just copy and paste this exact, as is sub and test it out. please lemme know if this helps. ------------------------ Jordan. III

Details! Lots more details! Which webcam? What are you using to communication with the webcam? Are you using API calls and which ones? Are you using WIA? The manufacturer's SDK?... Code snippets of what your doing also help GREATLY! RageInTheMachine9532

Why are you using DAO? First of all, it was superceeded long ago by ADO. And since this is the C# forum, I can only assume you're using C#. So why aren't you using ADO.NET? It's a hell of a lot easier in .NET applications and has many benefits over plain ADO (like easy parameterized queries, data adapters, and more). You can find more information about ADO.NET in the .NET Framework SDK: Accessing Data using ADO.NET[^]. There's also several technical articles in MSDN with examples: ADO.NET[^]. Microsoft MVP, Visual C# My Articles

Daminda wrote: Any kind of suggestion is highly appreciated! You won't get the answer by reposting and reposting each day. Daminda wrote: I need to know how can we grant permission to access the Msysobjects through C# coding. I don't know if it helps but maybe you have to login with windows adminstrator account to do that. Mazy "Improvisation is the touchstone of wit." - Molière

This has to be granted in the MDB using Access. You might be able to use DDL to do this, but you'll have to see the Access help. If you need the Microsoft Primary Interop Assemblies to access the Access object model, you can obtain them from here: http://msdn.microsoft.com/library/en-us/dv_wrcore/html/wrrefofficeprimaryinteropassemblies.asp[^] (Office 2003). The Office XP PIAs are available from here: http://msdn.microsoft.com/library/default.asp?url=/downloads/list/office.asp[^]. Microsoft MVP, Visual C# My Articles

try: Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User Id=Admin;Password= or maybe with double quotes on the password, but i dont think you need them, just let it end at the = Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User Id=Admin;Password="" or with all default options: Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User Id=Admin;Password="";Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

To get a list of table names: code:-------------------------------------------------------------------------------- SELECT Name FROM MSysObjects WHERE Type = 1; -------------------------------------------------------------------------------- To get list of query names: code:-------------------------------------------------------------------------------- SELECT Name FROM MSysObjects WHERE Type = 5; -------------------------------------------------------------------------------- additional information: code:-------------------------------------------------------------------------------- To get list of Forms: SELECT Name FROM MsysObjects WHERE Type =-32768; To get list of Reports: SELECT Name FROM MsysObjects WHERE Type = -32764; To get list of Modules: SELECT Name FROM MsysObjects WHERE Type = -32761; To get list of Macros: SELECT Name FROM MsysObjects WHERE Type = -32766;

Hi, Try this: dbCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myDB;User ID=xxx;Password=xxx;"; dbCon.Open(); DataTable dt = dbCon.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, null); foreach(DataRow myRow in dt.Rows) { if (myRow["TABLE_NAME"].ToString() == tabSel) { ColList.Items.Add(myRow["COLUMN_NAME"].ToString()); } } This is also from the link that I posted above, here it is again: http://www.sadeveloper.net/Forum/ShowPost.aspx?PostID=5153 HTH, -Thea-