|
|
You're welcome; perhaps you would be so kind as to vote my answer (the one with the solution)?
I must get a clever new signature for 2011.
|
|
|
|
|
I have an application in C# to process scanned invoices. A customer wants to buy a scanner for the application but has these simple requirements:
- Some 50 invoices are received each day, 40 of them single page, 10 multi page
- The 40 single page invoices are put in a stack on the ADF and the "single" button on the scanner is pushed. The scanner then creates 40 files from the 40 invoices, ready for further processing.
- The first multi page invoice is put on the adf and the "multi" button on the scanner is pushed. The scanner then creates 1 (PDF) file from all pages in the adf
- the second multi page invoice etc...
What I want is to program the buttons on the scanner to do exactly that (with resolution and color depth etc). It may be on a network scanner, it may also be an USB scanner (with software running on a dedicated PC).
It must exist, I think it's a reasonable request, but extensive googling gives millions of results but nothing usefull.
Can anybody give me a pointer ?
Rob
|
|
|
|
|
PosiRob wrote: but extensive googling gives millions of results but nothing usefull.
A single Google search revealed this article[^], which should get you started.
I must get a clever new signature for 2011.
|
|
|
|
|
I'm sorry but scanning from my applications is allmost daily work. I need to scan from the hardware for this solution.
Thanks for your effort.
Rob
|
|
|
|
|
PosiRob wrote: I need to scan from the hardware for this solution.
Well, you forgot to mention that in your initial question. Maybe you should check with the manufacturers to see if there is a published API for their device.
I must get a clever new signature for 2011.
|
|
|
|
|
Thank you for trying to be helpfull, just for the record: in my initial post I mentioned:
"and the "single" button on the scanner is pushed"
I can easily create the thing from software, but I want to do it from the hardware. There has been no purchase of a scanner yet, I first want to establish the possibility before I advise to buy something..
Rob
|
|
|
|
|
PosiRob wrote: in my initial post I mentioned:
"and the "single" button on the scanner is pushed"
OK, that's what a human does, how is that relevant to driving the scanner with software?
PosiRob wrote: I can easily create the thing from software, but I want to do it from the hardware.
Sorry, I'm more confused; you can do it from software but you want to do it from hardware. So how exactly do you hope to drive the hardware if not from some software?
I must get a clever new signature for 2011.
|
|
|
|
|
I am create some project by C#. I need to use COM-object axWindowsMediaPlayer. I want to play some AVI resource file. How can I do it? As a rule, I wrote next code for play any file from hard disk:
axWindowsMediaPlayer.URL = @"D:\MyFile.avi"
But this code can play only file located to disk, i.e. I cann't write next code^
axWindowsMediaPlayer.URL = Resource.MyFile
Can you tell me, how can I play some AVI-file from resource file ?
|
|
|
|
|
your second code can able to play only .wav file when you will use System.Media.SoundPlayer but in case of axWindowsMediaPlayer you need to do conversion of byte[] to stream because .wav file returns System.IO.UnmanagedMemoryStream [Provie access to unmanaged block of memory from managed code] but in case of other audio file it return byte array so conversion is required here.
|
|
|
|
|
I am unable to connect to the sql2005express on my laptop
The error I get is:
login failed for user 'UserA'. the user is not associated with a trusted sql server connection
Note that sql server is set for both windows and sql authentication modes.
UserA is created in the login to have access to the database "DBName"
Data Source=.\SQLEXPRESS;Initial Catalog=DBname;User Id=UserA;Password=password
If I use the following connectionstring then it works fine
Data Source=LAPTOPName;Initial Catalog=DBname;IntegratedSecurity=True
Note that I get the Same error when connecting to the sqlexpress instance using sql server management studio and the username password combination
Question:
How can I connect successfully to sqlExpress in my laptop please?
Thanks
|
|
|
|
|
Have you restarted SSMS after setting authentication to both windows and Sql server authentication. If that's not the case then THIS[^] ongoing thread may help you to troubleshoot the problem.
Regards,
Hiren.
be good(Help people in CP),do good(Vote if one finds helpful) all will happen good, In case happens bad(You are getting downvote for your best try to help OP) it will be good for later after(Countered with more points by humble member). - Gita sar in context of CP.
-So Guys don't care about downvote believe in you.
|
|
|
|
|
|
That's just closing it and reopening it again.
Regards,
Hiren.
be good(Help people in CP),do good(Vote if one finds helpful) all will happen good, In case happens bad(You are getting downvote for your best try to help OP) it will be good for later after(Countered with more points by humble member). - Gita sar in context of CP.
-So Guys don't care about downvote believe in you.
|
|
|
|
|
In that case, yes, I have done that. and still no difference.
|
|
|
|
|
There can be many things that blocks the connection. Even a firewall blocked port(I think the default port is 1433)
Make sure that UserA has granted the permission to connect to the SQL Server.(RightClick on the server in managemet=>SelectedUser has granted(checked) the Permission => Connect SQL)
Obviously the same for the DB itself.
All the best,
Dan
|
|
|
|
|
MDL=>Moshu wrote: Even a firewall blocked port(I think the default port is 1433)
Would this apply to an sqlserverexpress instance on the laptop he is trying to connect from?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
|
|
|
|
|
My bad 
All the best,
Dan
|
|
|
|
|
|
arkiboys wrote: Note that I get the Same error when connecting to the sqlexpress instance using sql server management studio
That would suggest that it has nothing to do with C#. Instead it has to do with how you set up the user in SQL Server and/or the permissions.
At least in the past, far as I remember, one had to create a user in the server and then associate it with the database. Creating it in the database itself did not work. A forum specific to MS SQL Server might provide more specifics.
|
|
|
|
|
Hi all, I'm experiencing something odd (well, to me at least but I'm sure there is a good explanation for it). I have a ComboBox on my form which I populate as follows:
using (SqlCommand myCommand = new SqlCommand("SELECT Value, Description FROM ...", myConnection))
{
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
DataSet myDataSet = new DataSet();
DataTable myDataTable = new DataTable();
myDataSet.Tables.Add(myDataTable);
myDataSet.Load(myReader, LoadOption.PreserveChanges, myDataSource.Tables[0]);
myComboBox.DataSource = myDataSource.Tables[0];
myComboBox.DisplayMember = "Description";
myComboBox.ValueMember = "Value";
}
}
This is the way I've always used to populate ComboBoxes from a DB. If it's wrong, please let me know so I can start doing it differently, although it has worked for me so far.
The problem I'm getting is that I'm trying to set the SelectedValue of the ComboBox immediately after the above block of code with something like
myComboBox.SelectedValue = myDefaultValue;
but it does nothing. When I step through the code I notice that by the time the above line executes the value of myComboBox.Items.Count is still 0 so it appears as if the binding has not finished yet, but the ComboBox does not have a DataBindingComplete() event.
Can anyone tell me of a way to make sure that the ComboBox is bound to the DB before I try to change the SelectedValue explicitly?
|
|
|
|
|
I've never done it like this.
I'm not saying it's wrong just that I haven't done it like this.
Usually I create a array[] or list of something(string, int, custom class), load the datas from the db in the list or array through a datareader,
then I use the Items.AddRange() method of the combobox and specify theArray or the theList.ToArray()
All the best,
Dan
|
|
|
|
|
Yes, that definitely is a solution although I've always just considered it more elegant to bind the combobox's datasource directly to the queried datasource.
|
|
|
|
|
Dewald wrote: please let me know so I can start doing it differently
I used any one way based on condition to bind database with Combobox. The two different way are given below
SqlCommand cmd = new SqlCommand("Query",connetion);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr[index].ToString());
}
and
SqlCommand cmd = new SqlCommand("Query",connetion);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds,tablename);
DataTable dt = ds.Tables[tablename];
DataRow dr;
int x = 0;
while (x != dt.Rows.Count)
{
dr = dt.Rows[x];
comboBox1.Items.Add(dr[index].ToString());
x++;
}
let us know in case of any query
modified on Wednesday, January 19, 2011 8:14 AM
|
|
|
|
|
Dewald wrote: Can anyone tell me of a way to make sure that the ComboBox is bound to the DB before I try to change the SelectedValue explicitly?
I'm not sure if this a winform, but isn't there a databound event. Just create a method for you cb.databound += YourMethod() and put your code there. Also, you can check the items count before setting a value.
Good luck.
I didn't get any requirements for the signature
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
