RAS connection using GSM - GPRS Modem [modified] - Mobile Discussion Boards

Rather ironically for something called 'SQL Server CE', the SQL language is the worst, slowest way to do anything. If you're using .NET Compact Framework 2.0, the solution for loading data that's the fastest to execute while still being pretty readable and maintainable is to use the SqlCeResultSet class.

To do this, create a SqlCeCommand, passing just the name of the table to modify in the query text parameter. Then set the command type to CommandType.TableDirect. Associate it with an open SqlCeConnection and call ExecuteResultSet, using the ResultSetOptions.Updatable option. Then, on the SqlCeResultSet, call CreateRecord to get a new record, set the record's properties, then call Insert to insert it into the table.

See SQL Server Compact Edition Insert Performance[^] for details on just how big a difference this makes.

Equally, a direct table access operation is far, far faster than SELECTing from that table - not just time to first row being returned, but even the time to access each subsequent row. To access the results in a particular order, you can use the IndexName property to use a named index on the table, and you can use the SetRange method to restrict the set of results that are returned.

DoEvents: Generating unexpected recursion since 1991

dandi18 wrote:
Is there any way or Method to do this any faster ?

Yes. Use SharpZipLib (also known as NZipLib) CF library to compress the files before sending them over. You can get it here:

http://www.icsharpcode.net/OpenSource/SharpZipLib/Download.aspx[^]

Pete Soheil
DigiOz Multimedia
http://www.digioz.com

Hello!
I'm starting to create some PPC aplications, but on a start I have a problem. After creating fresh new PPC project I have no device skin in designer view. Everything in options is set right.

Hello,

I am writing a smartphone application in visual C++ using WTL. And I want to change background color in progress bar. I am using following code to do this functionality.

CProgressBarCtrl m_ProgressBarCtrl;

m_ProgressBarCtrl.SetBkColor(RGB(0,255,0));

When I compile this code, I am getting following error:-

***********************************************************************************************
error C2039: 'SetBkColor' : is not a member of 'WTL::CProgressBarCtrlT<tbase>'
with
[
TBase=ATL::CWindow
]

***********************************************************************************************

I don't know what else to do to change background color of progress bar.

Can anyone help me with this?

I'd really appreciate it.

Thanks,

Muthiah.

Hi Muthiah,

MuthiahR wrote:
error C2039: 'SetBkColor' : is not a member of 'WTL::CProgressBarCtrlT<tbase>'

The WinCE Progress bar control doesn't support the underlying PBM_SETBKCOLOR message, so WTL::CProgressBarCtrlT<TBase>::SetBkColor() is not present on WinCE platforms.

MuthiahR wrote:
I don't know what else to do to change background color of progress bar.

Subclass your progress bar and handle WM_ERASEBKGND at your liking.

cheers,
AR

Thanks for the information. And I will try this.

Thanks again,

Muthiah.

I tried it and works fine. Thanks A.R.

Regards,

Muthiah.

How do I programmatically set the Extra Initialization string on the modem when making a RAS connection through a GSM – GPRS modem device to get TCP/IP connectivity through the ISP provider to the internet??

Here’s the Extra Initialization string needed on the modem for RAS: +CGDCONT=1,"IP,"IPS.CINGULAR"

Here’s my targeted device environment:
OS: Windows CE 5.0 (using .Net Compact Framework 2.0)

Here’s the sample code that I’m calling to connect to a RAS phonebook entry profile.

namespace TestDevices
{
class RasWrapperII
{
[DllImport("coredll.dll")]
public static extern uint RasDial(IntPtr dialExtensions,
IntPtr phoneBookPath,
IntPtr rasDialParam,
uint NotifierType,
IntPtr notifier,
ref IntPtr pRasConn);

[DllImport("coredll.dll")]
public static extern uint RasHangUp(IntPtr pRasConn);

///

/// EntryName ,UserName,Password - same as in RASDIALPARAMS structure (see MSDN)
///

/// <param name="EntryName" />
/// <param name="UserName" />
/// <param name="Password" />
/// <param name="RasConn" />
/// <returns>
unsafe public static uint myRasDial(string EntryName, string UserName, string Password, out IntPtr RasConn)
{
uint r = 0;
RasConn = IntPtr.Zero;
byte[] bRASDIALPARAMS = new byte[1464];
fixed (byte* pAddr = bRASDIALPARAMS)
{
byte* pCurrent = pAddr;
Marshal.WriteInt32((IntPtr)pCurrent, bRASDIALPARAMS.Length);
pCurrent += 4;
foreach (byte b in Encoding.Unicode.GetBytes(EntryName))
{
Marshal.WriteByte((IntPtr)pCurrent, b);
pCurrent++;
}
pCurrent = pAddr + 0x192; //0x192 - offset for RASDIALPARAMS.UserName
foreach (byte b in Encoding.Unicode.GetBytes(UserName))
{
Marshal.WriteByte((IntPtr)pCurrent, b);
pCurrent++;
}
pCurrent = pAddr + 0x394; //0x394 - offset for RASDIALPARAMS.Password
foreach (byte b in Encoding.Unicode.GetBytes(Password))
{
Marshal.WriteByte((IntPtr)pCurrent, b);
pCurrent++;
}
r = RasDial(IntPtr.Zero, IntPtr.Zero, (IntPtr)pAddr, 0, IntPtr.Zero, ref RasConn);
}
return r;
}
}
}

The Call Code:

IntPtr conn; // connection handle
uint rc = RasWrapperII.myRasDial(this.txtPhoneNbr.Text, this.txtUserName.Text, this.txtPassword.Text, out conn);
if (rc == 0)
{
try
{
TcpClient client = new TcpClient();
client.Connect("www.amazon.com", 80);
MessageBox.Show("Successful Connection!", "TCP Client Call", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
}
catch (Exception ex)
{
MessageBox.Show("Connection Failed! Reason=" + ex.Message, "TCP Client Call", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
}
RasWrapperII.RasHangUp(conn);
}
else throw new ApplicationException("Return Code: " + rc.ToString());

Thanks in advance for any help that someone can provide.

-Bill

-- modified at 18:04 Friday 21st September, 2007

It's not officially supported, I'm afraid. The 'Extra Dialling Commands' field is a field of the opaque structure pointed to by the lpbDeviceInfo parameter passed to RasSetEntryProperties which isn't officially documented. Strictly it can be whatever the TAPI (Telephony API) provider for this phonebook entry wants it to be.

For standard dial-up connections, though, the TAPI provider is the Universal Modem (Unimodem) provider. If you have access to the Windows CE shared source code, you discover that it's a DEVMINICFG structure. You'll have to see that source for the definition of the structure and how to use it.

The only supported way of editing this information programmatically is on Windows Mobile 2003 and later, using configuration XML with the CM_PPPEntries configuration service provider. However, normally WM2003 and later devices with a GSM/GPRS radio will ship with Phone Edition and offer a direct Cellular Radio TAPI Provider, which can be used with the CM_GPRSEntries configuration service provider.

DoEvents: Generating unexpected recursion since 1991

Thanks Mike for the information about the DEVMINICFG structure under the TAPI, at least now I have a starting point to check into!

Could you please provide the code to set the unimodem dial up connection properties on Win ce 5 using c#... I need to set programatically baud rate, stop bit, flow control, extra dial up string etc.,
Thanks in advance...

my mail id is prajwal_ap@yahoo.co.uk

hi sir,

I am developing a windows application in C# where i have a small part to send sms to the number specified. i went through the article
http://support.microsoft.com/kb/555578.
(SMS services in ASP.NET Mobile Web Application)
and i used the webservice which you have mentioned here. i am not developing a mobile asp.net application but a normal windows application in C# 2005.

i added the webreference to the webservice and used the code. when i run the application,

however i get a error saying that a firewall is not allowing to estabilish remote connections and that a exception is set. i removed all exceptions and run the program again.

i still get the same problem.

Can you please suggest me any ideas on how to proceed?

Thanks in advance

Regards

Anuradha

Thanks in advance. Smile | :)

Regards

Anuradha

Hi,

I am trying to get a sampleclient application for wince working. When running the app on the pocket pc the message is that it can not find a certain certificate file; however, even after putting the the certificate file in the same directory as the sampleclient app it still produces the same message.

How about changing the source (sampleclient.c file) to have a preprocessor command which outputs the current directory for running the app? Maybe the app runs from some other directory not so obvious. Also, what is the method of getting the current directory?

Thanks,

Pooyan

Hi Pooyan,
There is no current directory in WinCE. All file names must be specified from root: \<path>\<filename>.
cheers,
AR

Hello,
Which are the faster functions in order to write a file in PPC 2003 & WM5?
I must write string in a file in a cycle and must be fastest possible!
I use C# ...
Thanks a lot.

Alex

Hey all,

I'm porting a small smartphone application to Windows Mobile 5/6. I am a bit stumped by the following:

The app consists of a small graphical rectangle which is always on top - basically a status bar. It should be painted on top of whatever else the win mobile os does. Ie. the win mobile OS works as usual with paint, input handling etc in everything it does, only with this custom graphical element overlay always painted on top of part of the screen.

Is there an elegant way of doing this?
(bonus points if it's possible to implement in managed / C# code)

Best regards,
Thomas Kjeldahl Nilsson, Oslo

Hello to all seniours, i am an university student frm kolkata, i am developing a project....wherein i encountered a severe problem...the idea is i will be having a pda and a couple of servers....now i m to download something from the server in the pda...however the connection can be via bluetooth or wifi or gprs i.e when it is within the range of bluetooth it uses bluetooth, after that wifi and finally through gprs.....now i am stuck in the wifi thing.....is there anyway to implement wifi connection through a j2me/java program? i am totally a newbie, so plz correct me if i m asking the wrong question! plz help
thnx in advance

Hallo. I am having the following problem;
i want to move into a .txt file, e.g move by 3 characters from line 1,position 1 to line 1,position 10.
I am using StreamWriter but it does not support something like move or seek method to move into the file.
What i am trying to do exactly is writing a name into first line and then go into position 25 of the same line and writing the surname.Same for the following lines. Any ideas how to move the cursor?
Thank you in advance for any help given.

Hi Is it possible to send SMS from a PC that is connected to a Windows Mobile Phone?
For example using VC++ 2005 and Windows CE 5
Thanks

Is it possible to develop mobile applications using VS express?

I think you have to have VS2005.

_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!

Hi to All,

 I want to develop a application for Black Barry device. Can someone guide me which Technology is suitable for it, and which kind of tool i have required on my development Machine.

?) <code>Can i developed application in (.Net 2005 Compact Framework 2.0 )C#.Net ?</code>

Please Help Me.... Frown | :(

Thanks

Pavan Pareta

Hi All,
how are you doing there? Must be fine. I am getting a terrible stack over flow exception error in my PDA application. And I simply can't under stand why this is happening? Currently I am working on a project where the user has to inspect a vehicle for different failures.
The flow is like this. There is a form named Select Inspection where the user selects the vehicle id and clicks on Inspection. Then It will go to the next screen where the user presses start inspection. After clicking on that the next form will display a list of categories such as cab test, brake test, emission test etc and all these values comes from the database and buttons are created according to the category. When the user clicks on a particular category different question will come on the screen under that category. It will also come from the database and the buttons are created at runtime. Then when the user clicks on a particular question in the next screen he has to pass or fail the question. Whatever button the user clicks, it then again comes back to the questions form and a tick or cross mark is displayed according to pass or fail. After answering all the question the user has to click on pass button at the bottom of the question screen. Then it will go back to the category screen and an associated image will be displayed on the right side of the category. All these buttons and pictures are created at run time. All these are working well for 7 question ...But when I click on the 8th question it is showing the stack over flow exception. I am here also giving mu code snippet.

Start Inspection Form...

private void button1_Click(object sender, EventArgs e)
{
CatgoryQuestion cc = new CatgoryQuestion();
cc.ShowDialog();
this.Close();
}

Category Form
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
namespace AIS_Start
{
public partial class CatgoryQuestion : Form
{
public CatgoryQuestion()
{
InitializeComponent();
}
private const string LOCALDATABASE = "\\My Documents\\AISNEW.sdf";
private const string CONNECTIONSTRING = "data source=" + LOCALDATABASE;//connection string for local database
private SqlCeConnection ceConn = null;
Button btn;
int a, b, c, d, i, f, g;
PictureBox pic;

private void CatgoryQuestion_Load(object sender, EventArgs e)
{
this.Text = "Vehicle Inspection";
a = 30;
b = 50;
c = 52;
d = 0;
f = 0;
ceConn = new SqlCeConnection(CONNECTIONSTRING);
ceConn.Open();
string sSQL = "SELECT QuestionID, Title, Reference1, Reference2 FROM QuestionTree WHERE ParentId = 0 AND TemplateID = '19' ORDER BY Position";

SqlCeCommand cmd = new SqlCeCommand(sSQL, ceConn);
SqlCeDataReader rdr = cmd.ExecuteReader();
int iFieldCount = 0;

try
{
// Iterate through the results
while (rdr.Read())
{
btn = new Button();
btn.Text = rdr.GetValue(1).ToString();
btn.Name = rdr.GetValue(1).ToString();

btn.Tag = d;
btn.Location = new Point(a, b);
btn.Size = new Size(175, 23);
panel1.Controls.Add(btn);

btn.Click += new EventHandler(btnclick);
pic = new PictureBox();

//pic.Name = rdr.GetValue(0).ToString();
//pic.Location = new Point(205, c);
//pic.Size = new Size(16, 16);
//pic.Image = ((System.Drawing.Image)(pictureBox2.Image)); //resources.GetObject("pictureBox2.Image"); //StartInspection.Properties.Resources.checkmark;
//panel1.Controls.Add(pic);

if (GlobalClass.btntag.ToString() == "")
{
pic = new PictureBox();
pic.Name = rdr.GetValue(0).ToString();
pic.Location = new Point(205, c);
pic.Size = new Size(16, 16);
pic.Image = ((System.Drawing.Image)(pictureBox2.Image)); //resources.GetObject("pictureBox2.Image"); //StartInspection.Properties.Resources.checkmark;
panel1.Controls.Add(pic);
}
else
{
int caseswitch = Convert.ToInt32(GlobalClass.ImageStatus[f]);
switch (caseswitch)
{
case 1:
//MessageBox.Show("case1" + GlobalClass.ImageStatus[f]);

pic = new PictureBox();
pic.Image = ((System.Drawing.Image)(pictureBox1.Image));//StartInspection.Properties.Resources.checkmark;
pic.Name = rdr.GetValue(0).ToString();

pic.Location = new Point(205, c);
pic.Size = new Size(16, 16);
panel1.Controls.Add(pic);
GlobalClass.ImgStatus[f] = "Pass";
break;
case 2:
//MessageBox.Show("case2" + GlobalClass.ImageStatus[f]);
//string chkstus = "";

pic = new PictureBox();
pic.Image = ((System.Drawing.Image)(pictureBox2.Image));//StartInspection.Properties.Resources.xmark;
pic.Name = rdr.GetValue(0).ToString();
pic.Location = new Point(205, c);
pic.Size = new Size(16, 16);
panel1.Controls.Add(pic);
GlobalClass.ImgStatus[f] = "Fail";
break;
//case 3:
// // MessageBox.Show("case3" + GlobalClass.ImageStatus[f]);
// pic = new PictureBox();
// pic.Image = StartInspection.Properties.Resources.questionmark;
// pic.Name = dr.GetValue(0).ToString();
// pic.Location = new Point(a + 85, c);
// pic.Size = new Size(16, 16);
// this.Controls.Add(pic);
// GlobalClass.ImgStatus[f] = "Not Applicable";
// break;
default:
pic = new PictureBox();
pic.Name = rdr.GetValue(0).ToString();
pic.Location = new Point(205, c);
pic.Size = new Size(16, 16);
panel1.Controls.Add(pic);
break;
}
}
b = b + 22;
c = c + 22;
d = d + 1;
f = f + 1;

}
}
finally
{
// Always call Close when done reading
rdr.Close();
// Always call Close when done reading
ceConn.Close();
}

}

private void button1_Click(object sender, EventArgs e)
{

}

private void label1_ParentChanged(object sender, EventArgs e)
{

}
private void btnclick(object sender, EventArgs e)
{
Button currentButton = (Button)sender;
GlobalClass.EmpName = currentButton.Name;
GlobalClass.btntag = Convert.ToInt32(currentButton.Tag);
i = GlobalClass.btntag;
ceConn = new SqlCeConnection(CONNECTIONSTRING);
ceConn.Open();
string sSQL = "select QuestionID from QuestionTree WHERE TemplateID = '19' and Title = '" + currentButton.Name + "'";
SqlCeCommand cmd = new SqlCeCommand(sSQL, ceConn);
SqlCeDataReader rdr = cmd.ExecuteReader();
int iFieldCount = 0;
try
{
// Iterate through the results
while (rdr.Read())
{
GlobalClass.QuestionId = Convert.ToInt32(rdr.GetValue(0).ToString());
iFieldCount = iFieldCount + 1;
}
}
finally
{
// Always call Close when done reading
rdr.Close();
// Always call Close when done reading
ceConn.Close();
}
GlobalClass.parent = false;
CatagoryQuestion2 cq2 = new CatagoryQuestion2();
cq2.ShowDialog();
this.Close();
//this.Hide();
}

private void toolBar1_ButtonClick(object sender, ToolBarButtonClickEventArgs e)
{
Select_Inspection_start se = new Select_Inspection_start();
se.ShowDialog();
this.Close();
//Login la = new Login();
//la.ShowDialog();
}
}
}

Question Form

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
namespace AIS_Start
{
public partial class CatagoryQuestion2 : Form
{
string status;
private bool m_sync = true;
public CatagoryQuestion2()
{
InitializeComponent();
}
private const string LOCALDATABASE = "\\My Documents\\AISNEW.sdf";
private const string CONNECTIONSTRING = "data source=" + LOCALDATABASE;//connection string for local database
private SqlCeConnection ceConn = new SqlCeConnection(CONNECTIONSTRING);
int a, b, c, d, i, f, g;
Button btn;
PictureBox pic;
private void label1_ParentChanged(object sender, EventArgs e)
{

}

private void CatagoryQuestion2_Load(object sender, EventArgs e)
{
//this.Text = GlobalClass.QuestionId.ToString();

if (GlobalClass.parent == true)
{
this.Text = GlobalClass.EmpName.ToString();
a = 30;
b = 50;
c = 52;
d = 0;
f = 0;
ceConn.Open();

//this.Text = GlobalClass.QuestionId.ToString();
string sSQL = "SELECT QuestionID, Title, Reference1, Reference2 FROM QuestionTree WHERE ParentId = '" + GlobalClass.QuestionId.ToString() + "' AND TemplateID = '19' ORDER BY Position";
SqlCeCommand cmd = new SqlCeCommand(sSQL, ceConn);
SqlCeDataReader dr1 = cmd.ExecuteReader();
while (dr1.Read())
{
btn = new Button();
btn.Text = dr1.GetValue(1).ToString();
if (btn.Text.StartsWith("Z"))
{
btn.Text =dr1.GetValue(1).ToString()+"*" ;
}
btn.Name = dr1.GetValue(1).ToString();
btn.Tag = d;
btn.Location = new Point(a, b);
btn.Size = new Size(150, 23);
panel1.Controls.Add(btn);
btn.Click += new EventHandler(btnclick);
//------------------------------------
SqlCeConnection ceConn1 = new SqlCeConnection(CONNECTIONSTRING);
ceConn1.Open();
string sSQL1 = "select QuestionID from Standards where QuestionID='" + dr1.GetValue(0).ToString() + "'";
SqlCeCommand cmd1 = new SqlCeCommand(sSQL1, ceConn1);
SqlCeDataReader dr2 = cmd1.ExecuteReader();
while (dr2.Read())
{
string bid = dr2.GetValue(0).ToString();
if (bid == dr1.GetValue(0).ToString())
{
btn.BackColor = Color.Tomato;
}
}
dr2.Close();
ceConn1.Close();
//------------------------------------
//panel1.Controls.Add(pic);
if (GlobalClass.btntagSub.ToString() == "")
{

pic = new PictureBox();
pic.Image = ((System.Drawing.Image)(pictureBox1.Image));
pic.Name = dr1.GetValue(0).ToString();
pic.Location = new Point(195, c);
pic.Size = new Size(16, 16);
panel1.Controls.Add(pic);
}
else
{
int caseswitch = Convert.ToInt32(GlobalClass.ImageStatusSub[f]);
switch (caseswitch)
{
case 1:

//MessageBox.Show("case1"+GlobalClass.ImageStatusSub[f]);
pic = new PictureBox();
pic.Image = ((System.Drawing.Image)(pictureBox2.Image));
pic.Name = dr1.GetValue(0).ToString();
//MessageBox.Show(pic.Name );
pic.Location = new Point(195, c);
pic.Size = new Size(16, 16);
panel1.Controls.Add(pic);
GlobalClass.ImgStatusSub[f] = "Pass";
break;
case 2:

//MessageBox.Show("case2"+GlobalClass.ImageStatusSub[f]);
pic = new PictureBox();
pic.Image = ((System.Drawing.Image)(pictureBox3.Image));
pic.Name = dr1.GetValue(0).ToString();
pic.Location = new Point(195, c);
pic.Size = new Size(16, 16);
panel1.Controls.Add(pic);
GlobalClass.ImgStatusSub[f] = "Fail";
break;
case 3:
//MessageBox.Show("cae3"+GlobalClass.ImageStatusSub[f]);
pic = new PictureBox();
pic.Image = ((System.Drawing.Image)(pictureBox3.Image));
pic.Name = dr1.GetValue(0).ToString();
pic.Location = new Point(195, c);
pic.Size = new Size(16, 16);
panel1.Controls.Add(pic);
GlobalClass.ImgStatusSub[f] = "Not Applicable";
break;
default:
pic = new PictureBox();
pic.Name = dr1.GetValue(0).ToString();
pic.Location = new Point(a + 85, c);
pic.Size = new Size(16, 16);
panel1.Controls.Add(pic);
break;
}
}
b = b + 22;
c = c + 22;
d = d + 1;
f = f + 1;
}
dr1.Close();
ceConn.Close();
}
else if (GlobalClass.parent == false)
{
this.Text = GlobalClass.EmpName.ToString();
int i;
GlobalClass.EmpNameSub = "";
GlobalClass.btntagSub = 0;
GlobalClass.FailSub = "";
for (i = 0; i < 100; i++)
{
GlobalClass.ImgStatusSub[i] = "";
}
for (i = 0; i < 101; i++)
{
GlobalClass.ImageStatusSub[i] = 0;
}
GlobalClass.NotApplSub = "";
GlobalClass.PassSub = "";
GlobalClass.QuestionIdSub = 0;

a = 30;
b = 50;
c = 52;
d = 0;
f = 0;

ceConn = new SqlCeConnection(CONNECTIONSTRING);
ceConn.Open();
string sSQL2 = "SELECT QuestionID, Title, Reference1, Reference2 FROM QuestionTree WHERE ParentId = '" + GlobalClass.QuestionId.ToString() + "' AND TemplateID = '19' ORDER BY Position";
SqlCeCommand cmd1 = new SqlCeCommand(sSQL2, ceConn);
SqlCeDataReader dr1;
dr1= cmd1.ExecuteReader();
while (dr1.Read())
{
btn = new Button();
btn.Text = dr1.GetValue(1).ToString();
if (btn.Text.StartsWith("Z"))
{
btn.Text = dr1.GetValue(1).ToString() + "*";
}
btn.Name = dr1.GetValue(1).ToString();
btn.Tag = d;
btn.Location = new Point(a, b);
btn.Size = new Size(150, 23);
panel1.Controls.Add(btn);
btn.Click += new EventHandler(btnclick);

//------------------------------------

SqlCeConnection ceConn1 = new SqlCeConnection(CONNECTIONSTRING);
ceConn1.Open();
string sSQL3 = "select QuestionID from Standards where QuestionID='" + dr1.GetValue(0).ToString() + "'";
SqlCeCommand cmd2 = new SqlCeCommand(sSQL3, ceConn1);
SqlCeDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
{
string bid = dr2.GetValue(0).ToString();
if (bid == dr1.GetValue(0).ToString())
{
btn.BackColor = Color.Tomato;
}
}
dr2.Close();
ceConn1.Close();
//pic = new PictureBox();
//pic.Image = ((System.Drawing.Image)(pictureBox1.Image));
//pic.Name = dr1.GetValue(0).ToString();
//pic.Location = new Point(195, c);
//pic.Size = new Size(16, 16);
//panel1.Controls.Add(pic);
//------------------------------------
if (GlobalClass.btntagSub.ToString() == "")
{

pic = new PictureBox();
pic.Image = ((System.Drawing.Image)(pictureBox1.Image));
pic.Name = dr1.GetValue(0).ToString();
pic.Location = new Point(195, c);
pic.Size = new Size(16, 16);
panel1.Controls.Add(pic);
}
b = b + 22;
c = c + 22;
d = d + 1;
f = f + 1;
}

dr1.Close();
ceConn.Close();
}

}
private void btnclick(object sender, EventArgs e)
{
if (m_sync)
{
m_sync = false;
try
{
Button currentButton = (Button)sender;
GlobalClass.EmpNameSub = currentButton.Name;
GlobalClass.btntagSub = Convert.ToInt32(currentButton.Tag);
i = GlobalClass.btntagSub;

SqlCeConnection ceConn1 = new SqlCeConnection(CONNECTIONSTRING);
ceConn1.Open();

string sSQL4 = "select QuestionID from QuestionTree WHERE TemplateID = '19' and Title = '" + currentButton.Name + "'";

SqlCeCommand cmd = new SqlCeCommand(sSQL4, ceConn1);
SqlCeDataReader dr = cmd.ExecuteReader();

while (dr.Read())
{
GlobalClass.QuestionIdSub = Convert.ToInt32(dr.GetValue(0).ToString());
}
dr.Close();
ceConn1.Close();

Adverts ad = new Adverts();
ad.ShowDialog();
this.Close();
}
catch (StackOverflowException ex)
{
string msg = ex.Message;
MessageBox.Show(ex.Message);
}
m_sync = true;
}

}

private void button1_Click(object sender, EventArgs e)
{
bool chkst = false;
g = 0;
SqlCeConnection ceConn1 = new SqlCeConnection(CONNECTIONSTRING);
ceConn1.Open();

string sSQL4 = "SELECT QuestionID, Title, Reference1, Reference2 FROM QuestionTree WHERE ParentId = '" + GlobalClass.QuestionId.ToString() + "' AND TemplateID = '19' ORDER BY Position";
SqlCeCommand cmd = new SqlCeCommand(sSQL4, ceConn1);
SqlCeDataReader dr = cmd.ExecuteReader();
GlobalClass.ImageStatus[GlobalClass.btntag] = 1;

while (dr.Read())
{

if (GlobalClass.ImgStatusSub[g].ToString() == "Fail")
{
GlobalClass.ImageStatus[GlobalClass.btntag] = 2;
}
if (GlobalClass.ImgStatusSub[g].ToString() == "")
{
chkst = true;
}
g = g + 1;
}

dr.Close();
ceConn1.Close();
GlobalClass.ImgStatusSub[f] = "";
if (chkst == false)
{

CatgoryQuestion cq = new CatgoryQuestion();
cq.Show();
//this.Hide();
}
else
{
MessageBox.Show("Inspection not done perfectly!");
}

}

private void toolBar1_ButtonClick(object sender, ToolBarButtonClickEventArgs e)
{
//switch (toolBar1.Buttons.IndexOf(e.Button))
//{

// //case 0:
// // this.Close();
// // break;
// //case 1:
// // //MessageBox.Show("Button2");
// // //if (treeView1.SelectedNode.Text == "")
// // //{
// // // MessageBox.Show("Please select an Asset to view details");
// // //}
// // //else
// // //{
// // // GlobalClass.GlobaltvselItem = treeView1.SelectedNode.Text;
// // // Assets_Information frm = new Assets_Information();
// // // frm.Show();
// // //}

// // Assets_Information asset = new Assets_Information();
// // asset.ShowDialog();
// // break;
//}
//CatgoryQuestion frm = new CatgoryQuestion();
//frm.Show();

CatgoryQuestion frm = new CatgoryQuestion();
frm.ShowDialog();
this.Close();
}

}
}

The Global Class

using System;
using System.Collections.Generic;
using System.Text;

namespace AIS_Start
{
static class GlobalClass
{

private static string tvselItem = "";
public static string GlobaltvselItem
{
get
{
return tvselItem;
}
set
{
tvselItem = value;
}
}
private static string type = "";
public static string typeasset
{
get
{
return type;
}
set
{
type = value;
}
}
private static bool inspection = false;
public static bool inspectionstart
{
get
{
return inspection;
}
set
{
inspection = value;
}
}
private static bool sta = false;
public static bool status
{
get
{
return sta;
}
set
{
sta = value;
}
}
private static string stand = "";
public static string standards
{
get
{
return stand;
}
set
{
stand = value;
}
}
private static string desc = "";
public static string description
{
get
{
return desc;
}
set
{
desc = value;
}
}

// Values that will be stored in InspectionResult table for BrakePad Liner Thickness Question when the user presses NA
private static int autoid;
public static int InspeResid
{
get
{
return autoid;
}
set
{
autoid = value;
}
}
private static int thi;
public static int thickness
{
get
{
return thi;
}
set
{
thi = value;
}
}
private static string stat = "";
public static string InspeResStatus
{
get
{
return stat;
}
set
{
stat = value;
}
}
private static string det = "";
public static string InspeResDetails
{
get
{
return det;
}
set
{
det = value;
}
}
// Values that will be stored in the InspectionDefects

private static string defect = "";
public static string defectPrior
{
get
{
return defect;
}
set
{
defect = value;
}
}
private static string abc = "";
public static string AVCode
{
get
{
return abc;
}
set
{
abc = value;
}
}
private static string abc1 = "";
public static string AVGCode
{
get
{
return abc1;
}
set
{
abc1 = value;
}
}
private static string abc2 = "";
public static string ADV
{
get
{
return abc2;
}
set
{
abc2 = value;
}
}
private static string abc3 = "";
public static string CauseGroupCode
{
get
{
return abc3;
}
set
{
abc3 = value;
}
}
private static string abc4 = "";
public static string CauseCode
{
get
{
return abc4;
}
set
{
abc4 = value;
}
}
private static string abc5 = "";
public static string DefaultText
{
get
{
return abc5;
}
set
{
abc5 = value;
}
}
private static string abc6 = "";
public static string CauseText
{
get
{
return abc6;
}
set
{
abc6 = value;
}
}
//Variable declaration to store variable by retriving data from System settings
private static int sbe;
public static int ServiceBrakeEff
{
get
{
return sbe;
}
set
{
sbe = value;
}
}
private static string emi = "";
public static string emiStatus
{
get
{
return emi;
}
set
{
emi = value;
}
}
private static string emid = "";
public static string emiDetail
{
get
{
return emid;
}
set
{
emid = value;
}
}
private static string emid1 = "";
public static string emiDefectText
{
get
{
return emid1;
}
set
{
emid1 = value;
}
}
private static string emid2 = "";
public static string emiCauseText
{
get
{
return emid2;
}
set
{
emid2 = value;
}
}
private static string numq1 = "";
public static string numberQStatus
{
get
{
return numq1;
}
set
{
numq1 = value;
}
}
private static string numq2 = "";
public static string numberQDetail
{
get
{
return numq2;
}
set
{
numq2 = value;
}
}
private static string numq3 = "";
public static string numberQDefectText
{
get
{
return numq3;
}
set
{
numq3 = value;
}
}
private static string numq4 = "";
public static string numberQCauseText
{
get
{
return numq4;
}
set
{
numq4 = value;
}
}
private static string perq1 = "";
public static string percentageStatus
{
get
{
return perq1;
}
set
{
perq1 = value;
}
}
private static string perq2 = "";
public static string percentageDetail
{
get
{
return perq2;
}
set
{
perq2 = value;
}
}
private static string perq3 = "";
public static string percentageDefectText
{
get
{
return perq3;
}
set
{
perq3 = value;
}
}
private static string perq4 = "";
public static string percentageCauseText
{
get
{
return perq4;
}
set
{
perq4 = value;
}
}
private static string trd1 = "";
public static string TreadDefectText
{
get
{
return trd1;
}
set
{
trd1 = value;
}
}
private static string trd2 = "";
public static string TradeCauseText
{
get
{
return trd2;
}
set
{
trd2 = value;
}
}
private static string tp6 = "";
public static string TPaxile //Vehicle Axile type
{
get
{
return tp6;
}
set
{
tp6 = value;
}
}
private static string tp1 = "";
public static string TPVehicleType
{
get
{
return tp1;
}
set
{
tp1 = value;
}
}
private static string tp3 = "";
public static string TPFrontOS //TyrePressure Off Side
{
get
{
return tp3;
}
set
{
tp3 = value;
}
}
//---------------------------------------------------------------
private static string tp4 = "";
public static string TPFrontNSUI //TyrePressure Near Side UI
{
get
{
return tp4;
}
set
{
tp4 = value;
}
}
//-----------------------------------------------------------
private static string tp5 = "";
public static string TPFrontOSUI //TyrePressure Near Side UI
{
get
{
return tp5;
}
set
{
tp5 = value;
}
}
//-----------------------------Centre--------------------------------------
//-----------------------------TyrePressure Question(Front)----------------------------------------------------
private static string tpc2 = "";
public static string TPCNS //TyrePressure Near Side
{
get
{
return tpc2;
}
set
{
tpc2 = value;
}
}
//---------------------------------------------------------------
private static string tpc3 = "";
public static string TPCOS //TyrePressure Off Side
{
get
{
return tpc3;
}
set
{
tpc3 = value;
}
}
//---------------------------------------------------------------
private static string tpc4 = "";
public static string TPCNSUI //TyrePressure Near Side UI
{
get
{
return tpc4;
}
set
{
tpc4 = value;
}
}
//-----------------------------------------------------------
private static string tpc5 = "";
public static string TPCOSUI //TyrePressure Near Side UI
{
get
{
return tpc5;
}
set
{
tpc5 = value;
}
}
private static string tp2 = "";
public static string TPFrontNS //TyrePressure Near Side
{
get
{
return tp2;
}
set
{
tp2 = value;
}
}
//----------------------------------------------------------------------
//-----------------------No of axile------------------------------------
//private static string tp6 = "";
//public static string TPaxile //Vehicle Axile type
//{
// get
// {
// return tp6;
// }
// set
// {
// tp6 = value;
// }
//}
//---------------------------------------------------------------
//---------------------------------------------------------------
private static string tp7 = "";
public static string TPRearInnerNSUI //TyrePressure Inner Near Side UI
{
get
{
return tp7;
}
set
{
tp7 = value;
}
}
//-----------------------------------------------------------
private static string tp8 = "";
public static string TPRearInnerOSUI //TyrePressure Inner Off Side UI
{
get
{
return tp8;
}
set
{
tp8 = value;
}
}
//---------------------------------------------------------------
private static string tp9 = "";
public static string TPRearOuterNSUI //TyrePressure Outer Near Side UI
{
get
{
return tp9;
}
set
{
tp9 = value;
}
}
//-----------------------------------------------------------
private static string tp10 = "";
public static string TPRearOuterOSUI //TyrePressure Outer Off Side UI
{
get
{
return tp10;
}
set
{
tp10 = value;
}
}
//===================================
//-----------------------------TyrePressure Question(Rear)----------------------------------------------------
private static string tp11 = "";
public static string TPRearInnerNS //TyrePressure Inner Near Side
{
get
{
return tp11;
}
set
{
tp11 = value;
}
}
//---------------------------------------------------------------
private static string tp12 = "";
public static string TPRearInnerOS //TyrePressure Inner Off Side
{
get
{
return tp12;
}
set
{
tp12 = value;
}
}
//====================================
//-----------------------------TyrePressure Question(Front)----------------------------------------------------
private static string tp13 = "";
public static string TPRearOuterNS //TyrePressure Inner Near Side
{
get
{
return tp13;
}
set
{
tp13 = value;
}
}
//---------------------------------------------------------------
private static string tp14 = "";
public static string TPRearOuterOS //TyrePressure Inner Off Side
{
get
{
return tp14;
}
set
{
tp14 = value;
}
}//-------------------
//======================================================================
//----------------------------------------------------------------------
//---------------------------------------------------------------
private static string tpc7 = "";
public static string TPCentreInnerNSUI //TyrePressure Inner Near Side UI
{
get
{
return tpc7;
}
set
{
tpc7 = value;
}
}
//-----------------------------------------------------------
private static string tpc8 = "";
public static string TPCentreInnerOSUI //TyrePressure Inner Off Side UI
{
get
{
return tpc8;
}
set
{
tpc8 = value;
}
}
//---------------------------------------------------------------
private static string tpc9 = "";
public static string TPCentreOuterNSUI //TyrePressure Outer Near Side UI
{
get
{
return tpc9;
}
set
{
tpc9 = value;
}
}
//-----------------------------------------------------------
private static string tpc10 = "";
public static string TPCentreOuterOSUI //TyrePressure Outer Off Side UI
{
get
{
return tpc10;
}
set
{
tpc10 = value;
}
}
//===================================
//-----------------------------TyrePressure Question(Rear)----------------------------------------------------
private static string tpc11 = "";
public static string TPCentreInnerNS //TyrePressure Inner Near Side
{
get
{
return tpc11;
}
set
{
tpc11 = value;
}
}
//---------------------------------------------------------------
private static string tpc12 = "";
public static string TPCentreInnerOS //TyrePressure Inner Off Side
{
get
{
return tpc12;
}
set
{
tpc12 = value;
}
}
//====================================
//-----------------------------TyrePressure Question(Front)----------------------------------------------------
private static string tpc13 = "";
public static string TPCentreOuterNS //TyrePressure Inner Near Side
{
get
{
return tpc13;
}
set
{
tpc13 = value;
}
}
//---------------------------------------------------------------
private static string tpc14 = "";
public static string TPCentreOuterOS //TyrePressure Inner Off Side
{
get
{
return tpc14;
}
set
{
tpc14 = value;
}
}
//---------------------------------------------------------------
private static string failcategory = "";
public static string FailureCategory//Used in showing the name of form zAuto Adjuster.cs while form loading.
{
get
{
return failcategory;
}
set
{
failcategory = value;
}
}
// private static string ename = "";
// public static string EmpName
// {
// get
// {
// return ename;
// }
// set
// {
// ename = value;
// }
// }
// private static string pa = "";
// public static string Pass
// {
// get
// {
// return pa;
// }
// set
// {
// pa = value;
// }
// }
// private static string Fa = "";
// public static string Fail
// {
// get
// {
// return Fa;
// }
// set
// {
// Fa = value;
// }
// }
// private static string na = "";
// public static string NotAppl
// {
// get
// {
// return na;
// }
// set
// {
// na = value;
// }
// }
// ///

// /// ////////////
// /// question parent id
private static string Question = "";
public static string QuestionID
{
get
{
return Question;
}
set
{
Question = value;
}
}
//------------------question id1
private static string Question1 = "";
public static string QuesID
{
get
{
return Question1;
}
set
{
Question1 = value;
}
}
////------------question type
// /// question parent id
private static string Questiontyp = "";
public static string QuestionType
{
get
{
return Questiontyp;
}
set
{
Questiontyp = value;
}
}
// ///

// ///
// private static int[] imgSta = new int[10];
// public static int[] ImageStatus
// {
// get
// {
// return imgSta;
// }
// set
// {
// imgSta = value;
// }
// }
// private static int abcbtn;
// public static int btntag
// {
// get
// {
// return abcbtn;
// }
// set
// {
// abcbtn = value;
// }
// }
// private static string[] empname = new string[10];
// public static string[] employeename
// {
// get
// {
// return empname;
// }
// set
// {
// empname = value;
// }
// }
// private static string[] img = new string[10];
// public static string[] ImgStatus
// {
// get
// {
// return img;
// }
// set
// {
// img = value;
// }
// }
private static string ename = "";
public static string EmpName
{
get
{
return ename;
}
set
{
ename = value;
}
}
private static string pa = "";
public static string Pass
{
get
{
return pa;
}
set
{
pa = value;
}
}
private static string Fa = "";
public static string Fail
{
get
{
return Fa;
}
set
{
Fa = value;
}
}
private static string na = "";
public static string NotAppl
{
get
{
return na;
}
set
{
na = value;
}
}
private static int[] imgSta = new int[201];
public static int[] ImageStatus
{
get
{
return imgSta;
}
set
{
imgSta = value;
}
}
//private static int abc;
//public static int btntag
//{
// get
// {
// return abc;
// }
// set
// {
// abc = value;
// }
//}
////private static string[] empname = new string[100];
//public static string[] employeename
//{
// get
// {
// return empname;
// }
// set
// {
// empname = value;
// }
//}
private static string[] img = new string[200];
public static string[] ImgStatus
{
get
{
return img;
}
set
{
img = value;
}
}
private static int qid;
public static int QuestionId
{
get
{
return qid;
}
set
{
qid = value;
}
}
//--------------------------For Sub Question------------------------------------
private static string enameSub = "";
public static string EmpNameSub
{
get
{
return enameSub;
}
set
{
enameSub = value;
}
}
private static string paSub = "";
public static string PassSub
{
get
{
return paSub;
}
set
{
paSub = value;
}
}
private static string FaSub = "";
public static string FailSub
{
get
{
return FaSub;
}
set
{
FaSub = value;
}
}
private static string naSub = "";
public static string NotApplSub
{
get
{
return naSub;
}
set
{
naSub = value;
}
}
private static int[] imgStaSub = new int[201];
public static int[] ImageStatusSub
{
get
{
return imgStaSub;
}
set
{
imgStaSub = value;
}
}
private static int abcSub;
public static int btntagSub
{
get
{
return abcSub;
}
set
{
abcSub = value;
}
}

private static string[] imgSub = new string[200];
public static string[] ImgStatusSub
{
get
{
return imgSub;
}
set
{
imgSub = value;
}
}
private static int qidSub;
public static int QuestionIdSub
{
get
{
return qidSub;
}
set
{
qidSub = value;
}
}
private static bool paren;
public static bool parent
{
get
{
return paren;
}
set
{
paren = value;
}
}
private static int btnabc;
public static int btntag
{
get
{
return btnabc;
}
set
{
btnabc = value;
}
}
//---------------------FaultLocation for Positional Screen---------------------------------
private static string fl = "";
public static string faultLocation
{
get
{
return fl;
}
set
{
fl = value;
}
}
//---------------------Variables for Positional Screen---------------------------------
private static string psp = "";
public static string PSposition
{
get
{
return psp;
}
set
{
psp = value;
}
}
//---------------------Variables for Positional Screen---------------------------------
private static string psd = "";
public static string PSdetail
{
get
{
return psd;
}
set
{
psd = value;
}
}
//---------------------Variables for Positional Screen---------------------------------
private static string psi = "";
public static string PSitemno
{
get
{
return psi;
}
set
{
psi = value;
}
}
//--------------------------------------------------------------------------------------

}
}

Please help me in this. I am helpless. Any help will be appriciated.

Sagar Pattnayak
Software Developer
Sun-Dew Solutions
+91-9831169962

Hi,

I'm new to mobile development. I was wondering if it were possible to access the phone functions on a Windows Mobile 2003. I was thinking more of an application which is able to obtain the cell id, bcch etc, like the parameters available in a Satgem phone. Which programming language would be able to obtain these parameters if possible? I am learning C# currently, would it be possible to do this through the APIs?

Thank you.

Hello everyone,

I am building a DLL using embedded VC 4. There is a .exp file generated into the same folder of the output DLL file.

I am wondering what is the usage of this file? How to control embedded VC not to generate this file?

thanks in advance,
George