smartclient: posting record through webservice (URGENT)

[Khamal]

What is wrong with this

[WebMethod]
public bool syncTOmysqlcon(string Query)
{
try
{string strConnA = "Database=felcradb;Data Source=development;User
Id=root;Password=citranet";

MySqlConnection myConnectionstrSQLA = new MySqlConnection(strConnA);
MySqlCommand myCommstrSQLA = new MySqlCommand(Query);
myCommstrSQLA.Connection = myConnectionstrSQLA;
myConnectionstrSQLA.Open();
int result = myCommstrSQLA.ExecuteNonQuery();
myCommstrSQLA.Connection.Close();
return (result ==1);
}
catch(Exception ex)
{
return DataError(ex);
}

it always error when i call this webservice trough my windows apps.

felcraengine.felcracall.Service1 db = new felcraengine.felcracall.Service1();
bool tebabo = db.syncTOmysqlcon("INSERT INTO pst_settlers_contract_details
(ENTITY, APPLICANT_NO, AGREEMENT_NO, AGREEMENT_STATUS, AGREEMENT_SIGNDATE,
AGREEMENT_TYPE, APPLICANT_STATUS, DATE_EFFECTIVE, STATUS_DATE,
APPLICANT_REPLACEMENT, OLD_IC_N0, NEW_IC_N0, CREATED_BY, CREATED_DATE,
UPDATED_BY, UPDATED_DATE, UPLOADED, UPLOADED_DATE) VALUES('', '', '', '',
'2005-10-9', '', '', '2005-10-9', '2005-10-9', '', '', '', '', '2005-10-9',
'', '2005-10-9', '', '2005-10-9')");

Thanks in advance!!

--
:: KHAMAL ::

[CG]

you are returning an integar, whereas you should return "true" or "false"
bool.

"Khamal" wrote:

What is wrong with this

[WebMethod]
public bool syncTOmysqlcon(string Query)
{
try
{string strConnA = "Database=felcradb;Data Source=development;User
Id=root;Password=citranet";

MySqlConnection myConnectionstrSQLA = new MySqlConnection(strConnA);
MySqlCommand myCommstrSQLA = new MySqlCommand(Query);
myCommstrSQLA.Connection = myConnectionstrSQLA;
myConnectionstrSQLA.Open();
int result = myCommstrSQLA.ExecuteNonQuery();
myCommstrSQLA.Connection.Close();
return (result ==1);
}
catch(Exception ex)
{
return DataError(ex);
}

it always error when i call this webservice trough my windows apps.

felcraengine.felcracall.Service1 db = new felcraengine.felcracall.Service1();
bool tebabo = db.syncTOmysqlcon("INSERT INTO pst_settlers_contract_details
(ENTITY, APPLICANT_NO, AGREEMENT_NO, AGREEMENT_STATUS, AGREEMENT_SIGNDATE,
AGREEMENT_TYPE, APPLICANT_STATUS, DATE_EFFECTIVE, STATUS_DATE,
APPLICANT_REPLACEMENT, OLD_IC_N0, NEW_IC_N0, CREATED_BY, CREATED_DATE,
UPDATED_BY, UPDATED_DATE, UPLOADED, UPLOADED_DATE) VALUES('', '', '', '',
'2005-10-9', '', '', '2005-10-9', '2005-10-9', '', '', '', '', '2005-10-9',
'', '2005-10-9', '', '2005-10-9')");

Thanks in advance!!

--
:: KHAMAL ::

[Khamal]

hello CG..

what i've got from mysql help is this

You can use ExecuteNonQuery to perform any type of database operation,
however any resultsets returned will not be available. Any output parameters
used in calling a stored procedure will be populated with data and can be
retrieved after execution is complete. For UPDATE, INSERT, and DELETE
statements, the return value is the number of rows affected by the command.
For all other types of statements, the return value is -1.

when invoke actually i got it false....

it is not execute why????
--
:: KHAMAL ::
"CG" wrote:

you are returning an integar, whereas you should return "true" or "false"
bool.

"Khamal" wrote:

What is wrong with this

[WebMethod]
public bool syncTOmysqlcon(string Query)
{
try
{string strConnA = "Database=felcradb;Data Source=development;User
Id=root;Password=citranet";

MySqlConnection myConnectionstrSQLA = new MySqlConnection(strConnA);
MySqlCommand myCommstrSQLA = new MySqlCommand(Query);
myCommstrSQLA.Connection = myConnectionstrSQLA;
myConnectionstrSQLA.Open();
int result = myCommstrSQLA.ExecuteNonQuery();
myCommstrSQLA.Connection.Close();
return (result ==1);
}
catch(Exception ex)
{
return DataError(ex);
}

it always error when i call this webservice trough my windows apps.

felcraengine.felcracall.Service1 db = new felcraengine.felcracall.Service1();
bool tebabo = db.syncTOmysqlcon("INSERT INTO pst_settlers_contract_details
(ENTITY, APPLICANT_NO, AGREEMENT_NO, AGREEMENT_STATUS, AGREEMENT_SIGNDATE,
AGREEMENT_TYPE, APPLICANT_STATUS, DATE_EFFECTIVE, STATUS_DATE,
APPLICANT_REPLACEMENT, OLD_IC_N0, NEW_IC_N0, CREATED_BY, CREATED_DATE,
UPDATED_BY, UPDATED_DATE, UPLOADED, UPLOADED_DATE) VALUES('', '', '', '',
'2005-10-9', '', '', '2005-10-9', '2005-10-9', '', '', '', '', '2005-10-9',
'', '2005-10-9', '', '2005-10-9')");

Thanks in advance!!

--
:: KHAMAL ::

[Khamal]

I've got it...when i remove field key in db the data will be inserted smoothly
:: KHAMAL ::
"Khamal" wrote:

hello CG..

what i've got from mysql help is this

You can use ExecuteNonQuery to perform any type of database operation,
however any resultsets returned will not be available. Any output parameters
used in calling a stored procedure will be populated with data and can be
retrieved after execution is complete. For UPDATE, INSERT, and DELETE
statements, the return value is the number of rows affected by the command.
For all other types of statements, the return value is -1.

when invoke actually i got it false....

it is not execute why????
--
:: KHAMAL ::
"CG" wrote:

you are returning an integar, whereas you should return "true" or "false"
bool.

"Khamal" wrote:

What is wrong with this

[WebMethod]
public bool syncTOmysqlcon(string Query)
{
try
{string strConnA = "Database=felcradb;Data Source=development;User
Id=root;Password=citranet";

MySqlConnection myConnectionstrSQLA = new MySqlConnection(strConnA);
MySqlCommand myCommstrSQLA = new MySqlCommand(Query);
myCommstrSQLA.Connection = myConnectionstrSQLA;
myConnectionstrSQLA.Open();
int result = myCommstrSQLA.ExecuteNonQuery();
myCommstrSQLA.Connection.Close();
return (result ==1);
}
catch(Exception ex)
{
return DataError(ex);
}

it always error when i call this webservice trough my windows apps.

felcraengine.felcracall.Service1 db = new felcraengine.felcracall.Service1();
bool tebabo = db.syncTOmysqlcon("INSERT INTO pst_settlers_contract_details
(ENTITY, APPLICANT_NO, AGREEMENT_NO, AGREEMENT_STATUS, AGREEMENT_SIGNDATE,
AGREEMENT_TYPE, APPLICANT_STATUS, DATE_EFFECTIVE, STATUS_DATE,
APPLICANT_REPLACEMENT, OLD_IC_N0, NEW_IC_N0, CREATED_BY, CREATED_DATE,
UPDATED_BY, UPDATED_DATE, UPLOADED, UPLOADED_DATE) VALUES('', '', '', '',
'2005-10-9', '', '', '2005-10-9', '2005-10-9', '', '', '', '', '2005-10-9',
'', '2005-10-9', '', '2005-10-9')");

Thanks in advance!!

--
:: KHAMAL ::

[Peter Kelcey]

Khamal,

Your return value is fine, however, I'm not sure what you're doing in
your catch block. It looks like you are returning a value retrieved
from a Function called DataError that you pass the original exception
to. I assuming that this function returns a boolean.

I'm wondering if you are actually getting an exception in one of your
lines of code that is being caught and eaten up by this DataError
function. If this is the case, you may be losing the actual exception
that might give you a better idea as to what is going wrong. Can you
confirm if you are getting an exception or not?

Peter Kelcey

[Khamal]

hi peter..

no need to have catch seem like, it will return true or false. May be i
should enable 1 more string for error handling at catch.....if the return
value is false..no dataerror anymore....

if u have any suggestion please feel fee to suggest...

thanks..
--
:: KHAMAL ::
"Peter Kelcey" wrote:

Khamal,

Your return value is fine, however, I'm not sure what you're doing in
your catch block. It looks like you are returning a value retrieved
from a Function called DataError that you pass the original exception
to. I assuming that this function returns a boolean.

I'm wondering if you are actually getting an exception in one of your
lines of code that is being caught and eaten up by this DataError
function. If this is the case, you may be losing the actual exception
that might give you a better idea as to what is going wrong. Can you
confirm if you are getting an exception or not?

Peter Kelcey