|
Hi
I have made a scanner program based on imgx www.imgx.net. They also have a Dot net version called dotimage.
Both solution is easy to use.
Good luck
Vilhelm Marstrand
|
|
|
|
|
Yah I had seen that at atalasoft.. I'm going to try that.. I had seen here on the site somebody had made a program to scan using twain.. Been looking at how they did it.
Thanks
Gerry
|
|
|
|
|
Hi,
Does anyone know if it is possible obtain the network usergroup of the currently logged on user? I want to use this as the basis for a security class in vb.net.
Thanks
|
|
|
|
|
Refer the msdn documentation for WindowsPrincipal.IsInRole method so that you can get some idea.
|
|
|
|
|
Hello,
I am new to vb.net and i am writing a billing application for a client. The application takes a bunch of raw numbers and does some filtering and calculations and puts time into different tables. The problem is that there are like 400,000 records of raw data. Now i put all the queries and calculations and filters in the onclick when the user hits the generate clean data button. The for is set up like this the user picks the month he wants to clean up by choosing the start date and enddate and then hits clean data button. My question is how can i make it go faster an I doing it wrong? It workes but it takes for ever like 20 mins and sometimes it freezes up. I will try and illistrate how i have it set up.
button_onclick
'first i get the raw data and up it into a new table
testdap.selectcommand.commandtext= "selece * form table"
for i=0 to dataset.table.row.count-1
cleandap.insertcommand.commandtext ="insert into cleantbl
(field1,field2,etc ) where (dataset.table.row(i).item("field1),etc)
I have like 17 of these actions where i get the data and put it in another table or clean it up and sometimes compare it to another table with thousands of records and if any two records match by account i put that row into another table. Well i hope you get the idea. I have all this being done when the user hits the button. Is there a better and fast way to do this, again i am know to .net and any help will be greatly appriciatied.
Thank you,
Santana
|
|
|
|
|
First, move your SQL statements to the SQL server so it can cache the execution plans for your statements. Second, I take it from your "Select * from table" that your returning all 400,000 rows?! No wonder it's taking forever... See if you can move some of this logic to SQL stored procedure and Trigger procedures so it can preprocess some of the data for you. If you have the server preprocess some of the data for you, you can improve the "apparent" speed of your application. Third, keep the number of records that SQL returns to your client to a minimum.
RageInTheMachine9532
|
|
|
|
|
Hi Santana
I think I can give you a hint in your problem.
Sometime ago I had to solve a problem where the app had to update one table from a file. The file contained approx. 400,000 records, and the app had to decide which are the new records, which need to be removed, and which to be updated.
Running it as a FOR loop would have taken ~11 hours. Running it using SQL cursors and FETCH NEXT SQL command - 7-8 hours. The following SQL stored proc it took 20 minutes:
tbl1 - table being modified
tbl2 - table which has all records from the file
[code]
UPDATE tbl1 set Inactive=1 where pID=@prid
UPDATE tbl1 SET Inactive = 0
FROM tbl2
WHERE tbl2.iID = tbl1.iID AND tbl1.pID = tbl2.pID
DELETE tbl2
FROM tbl1
WHERE tbl2.iID = tbl1.iID AND tbl1.pID = tbl2.pID
INSERT INTO tbl1 SELECT * FROM tbl2
DELETE FROM tbl2
[/code]
Hope this will help you.
Regards,
Serge (Logic Software)
|
|
|
|
|
I'm trying to create a project with an OLE connection to a Microsoft Access database. I don't see a choice for the Jet OLE DB provider as one of my choice in the wizard. Is that the right choice? How do I add it?
Thanks.
|
|
|
|
|
Simple, you don't...
The code you use to open a connection to the database does something like this:
Public Sub ConnectToAccess()
Dim conn As New System.Data.OleDb.OleDbConnection()
' TODO: Modify the connection string and include any
' additional required properties for your database.
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Documents and Settings\username\My Documents\dbFile.mdb"
Try
conn.Open()
' Insert code to process data.
Catch ex As Exception
MessageBox.Show("Failed to connect to data source")
Finally
conn.Close()
End Try
End Sub
Look in the VS.NET help for OleDbConnection, OleDbDataAdapter, and OleDbCommand for much more detailed information.
RageInTheMachine9532
|
|
|
|
|
|
I have created a user control that encapsulates a DataGrid. The DataGrid contains some inherited visual column styles that allow for editing in a custom textbox, combocbox, etc. The DataGrid is bound to a dynamically created DataTable. The trouble is: When I Tab from column to column, it steps through one and into the next. When I set a breakpoint anywhere, it behaves itself.
I suspect this is a threading problem. Any Ideas???
Thanx
Greg
|
|
|
|
|
hiiii
i want that somebody give me code to get the RGB values from an image and show in edit boxes.
its a bit urgent plz
regards
tahir
|
|
|
|
|
What you can do is use the Bitmap class GetPixel method to get the Color of that pixel, then use the Color class R, G, and B properties to get the values you want.
Dim MyImage As New Bitmap("C:\testimage.jpg")
Dim pixelColor As Color = MyImage.GetPixel(0,0)
Dim r As Byte = pixelColor.R
Dim b As Byte = pixelColor.B
Dim g As Byte = pixelColor.G
RageInTheMachine9532
|
|
|
|
|
Hi,
I have an array with emailaddresses that I have extracted from a file in an import function in my program. But the same e-mail adddress may occurre several times in the array if the user did add it several times in the file.
I need a way to delete duplicates and I need help. What I want is to replace an address (it will vary) with an emty string("") or a string I can later use for testing against(lest say the string "duplicate" is the replacement). I am having trouble with my loop or if. The inner if sentence does not work. I have put the e-mail addresses also in a second array called tab, and checks each value in the first array against each value in the second one. Any suggestions? This is what I have:
Dim K as integer=0<br />
Dim L as integer=0<br />
For Each email In emails<br />
For Each em In emails2 <br />
If K <> L 'if it is a duplicate <br />
If emails(L).ToLower().Equals(emails2.ToLower())then <br />
emails(K)="duplicate" End If<br />
End If<br />
L = L + 1<br />
Next<br />
K = K + 1<br />
'MsgBox(emails(K)) 'only shows the value of the last element in the array. Next
IF anyone have a solution for how to do this, or another suggestion for a solution using for example RegEx I would really appreciate it
|
|
|
|
|
Try this logic
private void Email()
{
string[] emails = new string[]{"a@a.c", "a@a.c", "b@a.c", "b@a.c",
"a@a.c", "a@a.c", "b@a.c", "b@a.c"};
int j = 0;
for(int i = 0; i < emails.Length; i++)
{
for (j = i + 1; j < emails.Length; j++)
{
if (! emails[i].Equals("duplicate")
&& emails[i].Equals(emails[j]))
{
emails[j] = "duplicate";
}
}
}
string mbStr = "";
foreach (string str in emails)
{
if (! str.Equals("duplicate"))
{
mbStr = mbStr + str + ", ";
}
}
MessageBox.Show(mbStr);
}
|
|
|
|
|
Hi, and thanks for your help.
However I ended up trying out the StringDictionary like Ian suggested and I he opened a world of 'unknown' collections for me.
The code written by using a StringDictionary collection is shorter, so I'll stick with that for now. But I'll keep your code be cause I will probably need it some other time.
Thanks from Inger
|
|
|
|
|
|
Hi, and thanks for the advise.
I do not know what I am doing wrong in vb when it comes to arrays, but things that easily works with arrays in C++ or Java I can not make to work in VB6 or VB.NET..
However, I am now putting only unique emailaddresses in a StringDictionary thanks to your advise.
If anybody knows how I can add strings directly to the StringDictionary collection without extracting them first to a MatchCollection, I would appr. it. I think it should be possible to use the class Match and a method called findNext or something like that. It may reduce the overhead of having data added first in one collection, and then into an other.
This is the code:
Private Function ExtractEmailAddressesFromString2(ByVal source As String) As StringDictionary<br />
Dim mc As MatchCollection<br />
Dim i As Integer<br />
Dim myCol As New StringDictionary<br />
Dim m As String<br />
' expression from www.regexlib.com extracting email-addresses<br />
mc = Regex.Matches(source, "([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})") <br />
<br />
For i = 0 To mc.Count - 1<br />
'if address is not in collection from before, it is added <br />
If myCol.ContainsKey(mc(i).Value )=False Then <br />
myCol.Add(mc(i).Value, "") 'key + value <br />
End If<br />
Next <br />
Return myCol<br />
End function
|
|
|
|
|
Hey All
Does anyone know how to capture or record the screen into an AVI file through VB? I work in a call centre and for training purpose would like to capture the agents movements while on a call...
Any help would be great!
Later
|
|
|
|
|
Why write the code? Why not just use the Windows Media Encoder (free from here[^]) and record everything you do on the screen into an AVI?
RageInTheMachine9532
|
|
|
|
|
I need to code this because our software is connected to the PBX, so when a call comes in I would like to capture what the agent does on his/her screen. This will enhance our ability to maintain standards.
Any ideas??
|
|
|
|
|
Sounds like a very specialized app. You'll still need the Media 9 SDK and/or the Capture 9 Series tools to accomplish this, both come with code examples. The main problems you are going to have are storage requirements for the AVI's and a performance hit on the capture if the machine is not fast enough to do it AND perform the normal support functions at the same time. Capturing audio and video requires more than a little bit of CPU horsepower and the capture can fall behind and get jumpy if the machine is busy doing other things like loading Word, Excel, ... I would recommend testing the performance of such a setup by using the normal capture tools to see if the performance is acceptable before writing any code.
http://www.microsoft.com/windows/windowsmedia/download/default.asp[^]
RageInTheMachine9532
|
|
|
|
|
Thanks Dave for the quick responses.
I understand the problem I will face with resources but this would only be installed on new agents p.c's. This would help us to see how he/she is performing... I would only have to capture the video side of things because I already have a datavoice which captures all incoming and outgoing calls. Just incase of any problems.
Anyway thanks for you help
Later
|
|
|
|
|
I did timeworked in a call center for a while. The manager asked me to write an app that scanned the task list of the workstation for applications being run that were not part of the regular apps needed to do thier work and then report it back as an alarm to the manager.
Grrrrr.... but it ended up paying me so....
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 a**hole constant will be an integral part of that theory.
|
|
|
|
|
I created a simple database with 3 fields in it. When i tried to access it through VB.NET it says unknown data and will not let me go any further. any information on how to correct this problem would be appreciated. Thank you
|
|
|
|