Scan Barcode and Verify Data From Database Using Web Service On Windows CE Portable Terminal Scanner Device

Nikunj Trivedi

10y83.7k24100Article

web service in c#Scan and Verify BarCode DataWindows CE Application

24 Comments

Join the conversation! Your thoughts help the community grow.

Karin Huy6y ago
Hi, Have ufile source or video tutorial?
bapu7y ago
Hi Nikunj, Very nice. What's the best way to check traffic or data between RF scanner and web service? So if I do some transaction on RF scanner which will then make a request to web service and then web service returns some response, so If I want to check those transactions, what would you suggest.
bapu7y ago
Hi Nikunj,
Hadshana Kamalanathan8y ago
Nice one...
Syed10y ago
No overload for method 'getmember' takes '1' arguments showing in smartdevice method on execution, please help me
Syed10y ago
DataTable getdatatable(string str) this method throwing an error, which says incorrect syntax... at service.getdatatable(String str), please help me how to fix this.
Syed10y ago
I am not able to connect remote server, please help me
Syed10y ago
Now i am able to connect to the IIS, but once entering the barcode and click on submit button, i am getting error, namespace, in reference.cs file it showing to line having getdatatable,
Syed10y ago
Hi, i have build this project, after publishing website and configuring into IIS, i am not able to browse service.asmx web page..its throwing error. HTTP error.19, may i know how to resolve this error. I tried by changing virtual directory etc.. still i am getting error, should i have to use different port no.? please help me, i am new to VS.
Syed10y ago
Hi Nikunj, can you tell me which version of visual studio you used for this project.
Subash10y ago
Can you give more windows CE article?
Subash10y ago
Very useful one
Asfend Yar10y ago
nice
Fisseha Awash10y ago
Hello Sir it is very interesting article I build the project based on your example and test the Emulators by ruing it windows embedded handheld 6.5 classic device the but it generate Could not establish connection to network when i go to the detail section it generate the following error message system.web.services.protocols.webclientprotocol.getwebresponse(webrequest request) error on windows embede device, any help, thank you again
Nikunj Trivedi11y ago
Its simple , just focus cursor on Textbox4. when u scan any barcode from scanner then u get barcode data in your textbox4.
Venkat Govind11y ago
How can get scanned Barcode ID in textbox4.text
Venkat Govind11y ago
I want one discus with u about my one task .my client already using one barcode access control.its Siemens access control . here generate employee ID card with Barcode ,i want integrate with my newly developed application . here using 37 bit wiagand reader and controller is verinet E2/E4 (IP x.x.xxx.xx) how to integrate that controller with web application Please i kindly very request to you post some sample code.
Venkat Govind11y ago
i want details with web application i get ideia from your post, if have any code pls post thank u...
Venkat Govind11y ago
Hello Nikunj Your post very usefull for my project... its very amazing
Sibeesh Venu11y ago
Good one :)
- Nikunj Trivedi11y ago
  Thank u sir...
Santhakumar Munuswamy11y ago
Welcome
Santhakumar Munuswamy11y ago
Good start
- Nikunj Trivedi11y ago
  Thank u sir..

Introduction

This article shows how to scan a barcode in a Windows CE Portable Terminal Scanner Device and verify the scanned data from a SQL Server Database using a web service on a Windows CE Portable Terminal Scanner Device.

Modules

Webservice Application
Host Webservice on IIS
Windows CE Application.

Step 1

First of all create a database in SQL Server.

File name : Barcode_Data

Create a table like this.

Now insert data into this table like this.

Ok.

Step 2

Now create an ASP.NET web service in Visual Studio.

Open Visual Studio the select File -> New -> Web Site then select ASP.NET Web Service.

Press OK.

Step 3

In Solution Explorer, open Service.cs.

Create a method depending on your requirements.

Open your Service.cs file in the web service website to write the code to get the user details from the database.

Step 4

Now write code in the Service.cs file.

Before writing the WebMethod in Service.cs first add the following namespaces:

using System;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class Service: System.Web.Services.WebService
{
SqlConnection con;
SqlDataAdapter adp;
DataSet ds;
public Service()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public DataSet getmember()
{
con = new SqlConnection("Data Source=192.168.xx.xx\\SERVERR2;Initial Catalog=Barcode_Data;Connection Timeout=5000;Min Pool Size=100; Max Pool Size=2000;User ID=xxxx;Password=xxxxxxx");
con.Open();
adp = new SqlDataAdapter("select * from codedata", con);
ds = new DataSet();
adp.Fill(ds, "member");
return ds;
}
[WebMethod]
public int addition(int a, int b)
{
int c = a + b;
return c;
}
[WebMethod]
public DataTable getdatatable(string str)
{
con = new SqlConnection("Data Source=192.168.xx.xx\\SERVERR2;Initial Catalog=Barcode_Data;Connection Timeout=5000;Min Pool Size=100; Max Pool Size=2000;User ID=xxxx;Password=xxxxxx");
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
cmd.Connection = con;
cmd.CommandText = str;
da.SelectCommand = cmd;
da.Fill(ds, "Product_tbl");
dt = ds.Tables["Product_tbl"];
return dt;
}
}

Step 5

Now build this web service and publish this web service and then host it in IIS.

To host the website or web service on IIS read the article How to Configure ASP.Net Website in IIS.

Step 6

Host this published Webservice to IIS.

Run this WS in IIS.

Step 7

Now In the last module, create a Windows CE smart device application.

In Visual Studio:

File -> New -> Smart Device App -> Windows CE.

Create a design form like this.

Step 8

Now select Add Web Reference from the Solution Explorer.

Step 9

Copy your running web service path and paste it here in the URL.

Step 10

Replace “Localhost” and type that place “Your System Name” “CONtrivedi” or IP address.

Then press GO then press Add Refrence.

Step 11

Now call this web services function (method) in the WinCE application using Object.

namespace SmartDeviceProject2
{
public partial class Form1: Form
{
public Form1()
{
InitializeComponent();
}
contrivedi.Service obj = new contrivedi.Service();
private void button2_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
sqry = "SELECT id,bcode,bdetail from Sheet1 WITH(INDEX(index_fab))";
dt = obj.getdatatable(sqry);
dataGrid1.DataSource = dt;
}
string sqry = "";
private void textBox4_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue == 13)
{
if (textBox4.Text != "")
{
string bcode = textBox4.Text;
sqry = "select bcode,bdetail from Sheet1 where bcode='" + textBox4.Text + "'";
DataTable dt = new DataTable();
dt = obj.getdatatable(sqry);
if (dt.Rows.Count > 0)
{
MessageBox.Show("Valid Barcode !!");
string codevalue = dt.Rows[0]["bdetail"].ToString();
label3.Text = codevalue;
}
else
{
MessageBox.Show("Invalid Barcode");
}
}
}
}
}
}

Now run this application on a Portable Terminal Scanner device.

It will scan Barcode Data and then validate from the SQL Server database and then display detailed data related to the Barcode.

Thanks.

If you have any query regarding this feel free to post your comment.