How to mathc all the items...in a collection? - C# Discussion Boards

Re: How to Implement Scanner with windows applications

11-Nov-07 20:14

Hi,

If you are going to use the actual hardware, then you will have to connect it and get data from it. Otherwise, you'll have to detect and extract the exact place in the image, where the barcode is, and then read it as its specifications.

Regards,

Adeel

Vicky2Galaxy11-Nov-07 20:26

Vicky2Galaxy

11-Nov-07 20:26

thanks for your support....i am going to use actual hardware for it...do i have to use any supporting dll for that...if yes, what is it and how to use it?

Re: How to Implement Scanner with windows applications

Adeel Chaudhry11-Nov-07 20:51

Re: How to Implement Scanner with windows applications

11-Nov-07 20:51

For that you will have to check what interface the barcode reader has i.e. will you connect it using serial port, USB port or parallel port. After that you need to look-in the specifics of the barcode reader, like in what format it sends/receives data, what commands it supports, that mainly depends on the make and the chip design of the barcode reader.

Hope that helps!

Adeel

Vicky2Galaxy11-Nov-07 20:56

Vicky2Galaxy

11-Nov-07 20:56

Thanks..

Re: How to Implement Scanner with windows applications

m@u11-Nov-07 23:00

m@u

11-Nov-07 23:00

most barcodescanners act like a keyboard so you won't need anything special.

greets
m@u

How to mathc all the items...in a collection?

Pankaj - Joshi11-Nov-07 19:54

11-Nov-07 19:54

Hello experts,

I have a combo in that I fill some values from Db say A,B,C,D,e,f,G,h,i,j etc.

My combo is a simple combo so end user can also type in that. for data consistency I check wheather or not the user select proper value or not...? That is user have to enter or select the pre-filed value. For that I am using the Contains method
like
comboBox1.Items.Contains(comboBox1.Text.ToString()

and its working fine.

But this will interperete A and a different ....What to do...? Confused | :confused:

I want a and A are the same

Regards
Pankaj Joshi

Andrei Ungureanu11-Nov-07 20:07

Andrei Ungureanu

11-Nov-07 20:07

One idea might be to do a string comparison between the objects in the combobox and the the value inserted by the user

for (int i = 0 ; i < cmb.Items.Count ; i++)
{
 if (String.Compare(cmb.Items[i].ToString,cmb.Text,true)
 {
  //values are the same
 }
 else
 {
  //different values
 }
}

Hope it helps.

I will use Google before asking dumb questions

Pankaj - Joshi11-Nov-07 20:34

11-Nov-07 20:34

Thanks for reply Rose | [Rose]

But this is Ok...? If I having 15,000 records in combo then for loop will run 15,000 times and check the item. This will make code slower, And .Contains method automatically do that only case-sensitivity is the matter...I am right?

Regards
Pankaj Joshi

Andrei Ungureanu11-Nov-07 21:02

Andrei Ungureanu

11-Nov-07 21:02

pankaj.indore wrote:
If I having 15,000 records in combo then for loop will run 15,000 times and check the item.

Yes, when you have 15000 records in a combobox it's not right...but then again...why don't you do some filtering to have fewer values...or even...you should try to use autocomplete Wink | ;)

would work better

Hope it helps.

I will use Google before asking dumb questions

Adeel Chaudhry11-Nov-07 20:11

11-Nov-07 20:11

Hi,

If you have already fill-in all the possible values in that combo, why not you make it un-editable? That way, still, the user will be able to select the value by pressing the 1st character key of the value. Correct me if i am wrong. Smile | :)

Regards,

Adeel

Pankaj - Joshi11-Nov-07 20:34

11-Nov-07 20:34

Hi Adeel,

You are right, But in this case only one letter searching is allowed and
My combo having more than 15,000 records and that will create a problem.

SO user can type first few starting letters of the name and then select the name.

In your case [DropDownList I suppose] you only have one letter search and that will take much time to search particular record.

Regards
Pankaj Joshi

Xmen Real 11-Nov-07 20:48

Xmen Real

11-Nov-07 20:48

use like this

bool chkitem_small = comboBox1.Items.Contains(comboBox1.Text.ToLower());
<pre>bool chkitem_cap = comboBox1.Items.Contains(comboBox1.Text.ToUpper());
if(chkitem_small == true | chkitem_cap == true)
{
// found
}
else
{
//not found
}

Becoming Programmer...

Pankaj - Joshi11-Nov-07 21:15

11-Nov-07 21:15

That is working fine Big Grin | :-D

Thanks for reply Rose | [Rose]

Regards
Pankaj Joshi

SqlTransaction object

Vipin.d11-Nov-07 19:54

11-Nov-07 19:54

hi,
Is it posible to use two diferent connection string in a SqlTransaction object??

Be very grateful for any advice.

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Adeel Chaudhry11-Nov-07 20:07

11-Nov-07 20:07

Hi,

I dont think it is possible to use two connection strings(CSs) at the same time!! But you should be able to use two different CSs 1 after the other. Like use CS-1 perform something in transaction close CS-1, then open CS-2 and use it with the same transaction object! That may be possible.

Regards,

Adeel

Vipin.d11-Nov-07 20:17

11-Nov-07 20:17

Thank you very much for your reply.. Smile | :)

 <br />
using (SqlConnection connection = DbConnection("SerConstr"))<br />
                     {<br />
                         using (SqlCommand command =<br />
                                 connection.CreateCommand())<br />
                         {<br />
                             SqlTransaction transaction = null;<br />
<br />
                             try<br />
                             {<br />
                                  connection.Open();<br />
<br />
                                 transaction = connection.BeginTransaction();<br />
<br />
<br />
<br />
<br />
                                 command.Transaction = transaction;<br />
<br />
<br />
<br />
            // i need to perform this in con1                                <br />
  command.CommandText = "Insert ...";<br />
                                 command.ExecuteNonQuery();<br />
<br />
               // Execute i need to perform this in con2<br />
                                 command.CommandText = "Update...";<br />
                                 command.ExecuteNonQuery();<br />
<br />
                                 transaction.Commit();<br />
                             }<br />
                             catch<br />
                             {<br />
                                 transaction.Rollback();<br />
                                 throw;<br />
                             }<br />
                             finally<br />
                             {<br />
                                 connection.Close();<br />
                             }<br />
<br />

how I ll do this??

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Andrei Ungureanu11-Nov-07 20:19

Andrei Ungureanu

11-Nov-07 20:19

Vipin.d wrote:
// i need to perform this in con1
command.CommandText = "Insert ...";
command.ExecuteNonQuery();

// Execute i need to perform this in con2
command.CommandText = "Update...";
command.ExecuteNonQuery();

The insert and update queries refer to the same database, within the same server?

I will use Google before asking dumb questions

Vipin.d11-Nov-07 20:25

11-Nov-07 20:25

yes i know that ,
my requirement is I need to change the connection string before doing UPDATE process.is it have any solution??

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Adeel Chaudhry11-Nov-07 20:25

11-Nov-07 20:25

Can you please elaborate "Insert..." & "Update..." bit more? Smile | :)

Like for what purpose you need to have two CSs? Do you want to change the database? If yes, why not do it as an intermediate SQL statement between insert & update?

Vipin.d11-Nov-07 20:26

11-Nov-07 20:26

Dear friend,
my rquiremnt is like

1. SELECT some data from servr1.db1.Tbl1
2. INSERT that to server2.db2.Tbl1.
3. UPDATE the status filed of selected data in servr1.db1.Tbl1

If either step 2 or 3 fail I need to Roll back that transaction.
any advice please..

Let me check intermediate SQL statement in my Google Uncle Smile | :)

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Adeel Chaudhry11-Nov-07 20:38

11-Nov-07 20:38

First, allow me to clear this, I used "intermediate" as an english word, not as technical word. Smile | :)

Theoretically, it should be like that

connect with server1
select
if it was a success
connect with server2
insert
if it was a success
disconnect with server2
update
if not success rollback
disconnect with server1

Surely, you will need to have 2 connection objects, given this is not a live server with few hundereds transactions goin on.

Hope that helps!

Adeel

Vipin.d11-Nov-07 20:42