SQL Connetion from Pocket PC2003 to SQL2000-SP4 Arabic Coallation - Mobile Discussion Boards

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

Hello everyone,

I am building a DLL using embedded VC 4. When building a DLL (written in C) for platform MIPSFPU, there is a strange link error.

fatal error LNK1112: module machine type 'MIPS' conflicts with target machine type 'MIPSFPU'

Here is the link option I am using. I am wondering what is wrong with the settings?

commctrl.lib coredll.lib /nologo /base:"0x00100000" /stack:0x10000,0x1000 /entry:"_DllMainCRTStartup" /dll /incremental:yes /pdb:"MIPSIVRel/recover.pdb" /debug /nodefaultlib:"$(CENoDefaultLib)" /out:"MIPSIVRel/recover.dll" /implib:"MIPSIVRel/recover.lib" /subsystem:$(CESubsystem) /MACHINE:MIPSFPU

thanks in advance,
George

Under wince, how to get window hanlde of other process which is activing. I mean our application is not the activing one for the moment. AttachThreadInput seems unavailable under wince. How could it do? Confused | :confused:

One day a pretty girl asked me:"Do u think you are handsome?" "I don't think so!".She gave a slap in my face:"Why lying?"...

I am working on a project that will require the user to send a message and a PIN to an sms center then gets a message related to the PIN sent from th sms center.... how can i do this using the vb.net environment and MSSQL2000. Thanks Confused | :confused:

cxheun

Dear All
Please help in this ,it is very crtical and very urgent.I am using SQL
Client in Vb.net Compact Framework 2.0 to connect SQL Server 2000.It is
working fine with English collation (SQL_LATIN1_General) but same code gives
error with Arabic collation.
Error was Plattform not supported Exception and SQL error number is 5.
IF i try to connect with Server name i am getting error as SQL Exception.
Please help me out to solve this.
Thanks & Regards
Peer

hi

Hi,

I've not done any mobile coding before so am unsure how to do this. Basically, I'm writing a program in C# and running it in VS2005 under the emulator.

When the emulator shows up, it doesn't display my form I've created, it waits around 1min and then it suddenly appears. I want to make it so it displays instantly, or if anyone knows how to do this which would be a much better way, is to add it to the "Programs" list on the smart device, since i will need to deploy it onto a device and not use the emulator when the project is completed.

Any ideas, like i said, I've only been playing around figuring out how to do the basics, e.g: display something!

Regards,
Gareth.

don't worry gare,
when you run your application,it takes less time.you can feel this thing by running other program of real device & your program. Both takes approx same time.but within your application if your data loading time is too much then you can try following statement.
Cursor.Current = Cursors.WaitCursor
above statement change your default cursor to wait cursor.
and after loading data, change your wait cursor to default cursor using following statement
Cursor.Current = Cursors.Default

hope this helps

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

My Company

Hi Rupesh,

I already know how to change the cursor so no, it doesn't really answer my question. Sorry.
The problem is, i don't have any control on loading the program, it just appears, also if i click close, i cant re-open it. Thats why i asked if anyone knew how to add it to the "Programs" list or another method.

Regards,
Gareth.

The startup time might be an emulator issue which goes away when deployed on the actual device. First the emulator has to load and start, then it needs to run your application. Even running on the actual device, there is a start-up time to sync up with the IDE environment when connected. Just something you live with.

The program is likely defaulted to download into the root directory on the emulator/device.

You can copy a shortcut to your application into the Windows\Start Menu\Programs folder.

You can do this automatically by using a CAB file to install your application on the target device. See linky.

Gary

Hello,

VS 2005 CF 2.0

I have created a PDA device and will allow the user to write their signature.

However, I am having problems with the saving part.

http://msdn2.microsoft.com/en-us/library/aa446559.aspx

I used the above as a example, and took out all the code I needed to draw the signature and the new button.

I need to save the signature and add it to the database as an image. I think I need to convert the signature to an bitmap, but not sure how to do this.

Many thanks for any help and advice,

Steve

Rather than a BMP file, it is more memory efficient for a hand held to save the signature as a series of X-Y coordinates and pen-down/pen-up notations.

Have you looked at this CP article which stores signature in BMP file?

Gary

hi ,
can any one tell me is there any ip addres for windows based mobile device ... if it is How to find it and can i ping it from my computer synced with device ...

thanks :
rituparn...

" Life is like a box of chocolates; you never know what you gonna get "

RST

Has anyone had any success installing the CE 5 emulator on Vista 64? It fails on the install for me, saying it was interrupted. Event viewer yields this result:

\??\C:\Windows\SysWOW64\Drivers\vmm.sys has been blocked from loading due to incompatibility with this system. 
Please contact your software vendor for a compatible version of the driver.

"It was the day before today.... I remember it like it was yesterday."

-Moleman

Hi, I am developing a PIM using MFC.

I wish to know the ways to make my PIM mobile enabled ?
(ex Sync Contacts with my PIM and Mobile etc)

Is there any generic programming Interface which i need to expose to make the mobile software(like Nokia PC Suite) to communicate with my PIM and vice versa ?

Thanks

There's OMA DS[^], formerly known as SyncML[^].

Thanks for the reply i will go through the spec.

Hi folks,

I was messing with a GSM modem in Hyperterminal and saw a multimedia message come across. It was expected to look like a string of characters (it was a picture), so it worked fine. I'm curious though--is there a way to translate that string into an actual picture on the computer? Like some kind of applet that, if I take that string and copy/paste it, would make a picture on the spot?

Hello,

I have created a PDA application using VS 2005 in VB and CF 2.0.

The customer wants to be able to write their signature using the stencil into a text box. This will then be saved to a SQL Server 2005.

Is there a method which the user can write their signature into a text box?

Another problem is how will this be saved to the database? will it have to be a picture or image datatype in the database?

Many thanks for any suggestions,

Steve

Have a look at the "Ink" SDK on MSDN.

Otherwise look at making your own ownerdraw control that tracks the pen and draws on a bitmap and save that to the database.

You might also what to check the rules for digital evidence in your juristiction if these signatures are supposed to have legal weight.

Mark Churchill
Director
Dunn & Churchill

hi my application is written in Compact framework 2003. it works for both on desktop and device but i need to show tooltips for the desktop version. the tooltip control is not present as it is CF.
any help please...
thanks.

i found some code in xml to setupgprs but i dont know how to deployed this.can anybody help me.can we used this in compact framework.

<wap-provisioningdoc>
<characteristic type="CM_GPRSEntries">
<characteristic type="GPRS1">
<parm name="DestId" value="{436EF144-B4FB-4863-A041-8F905A62C572}" />
<characteristic type="DevSpecificCellular">
<parm name="BearerInfoValid" value="1" />
<parm name="GPRSInfoValid" value="1" />
<parm name="GPRSInfoProtocolType" value="2" />
<parm name="GPRSInfoL2ProtocolType" value="PPP" />
<parm name="GPRSInfoAccessPointName" value="internet3.thephone-company.com" />
<parm name="GPRSInfoAddress" value="" />
<parm name="GPRSInfoDataCompression" value="1" />
<parm name="GPRSInfoHeaderCompression" value="1" />
<parm name="GPRSInfoParameters" value="" />
</characteristic>
</characteristic>
</characteristic>
</wap-provisioningdoc> Confused | :confused:

@h3aR

Hi guys.
I'm having a really hard time installing the .NET Compact Framework 2.0 on a Compaq iPaq 3950 that has Windows CE 3.0 as OS. I'm new in the Mobile Programming... The first thing I'd like to know is if the CF 2.0 is compatible with this Pocket PC 2003.
The other thing is: Pocket PC 2003 is different from Windows CE 3.0 ?
Thank you !!

Raffaele Rotondo
www.raffaelerotondo.com