Below are codes in c# and vb.net

Carlos kambui

9y1.2kVisual Basic .NET

vb.net

when run below code the run without an error

If result.return_code = 1 Then

result.return_identity_id = Command.Parameters("@patient_id").Value

result.return_message = "Patient Process succesfull"

Else

End If

c# but this has an error

if (result.return_code == 1) {

result.return_identity_id = Command.Parameters("@patient_id").Value;

result.return_message = "Patient Process succesfull";

} else {

}

kindly rectify my errors

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Carlos kambui9y ago
Thanks all for your support Below solved my issue
returns.return_code = Command.ExecuteNonQuery();
Int32 trans_id;
trans_id = Convert.ToInt32(Command.ExecuteScalar());
if (returns.return_code == 1)
{
returns.return_identity_id = trans_id;
returns.return_message = "Process succesfull";
}
else
{
}
and this
Command.CommandText = "INSERT INTO Trans_file (trans_date,trans_reference,trans_type_id,trans_quantity,product_id,del_note,inv_no,lpo_no,cost_price,staff_id,shift_day) VALUES (@trans_date,@trans_reference,@trans_type_id,@trans_quantity,@product_id,@del_note,@inv_no,@lpo_no,@cost_price,@staff_id,@shift_day) SELECT SCOPE_IDENTITY()";
instead of
Command.CommandText = "INSERT INTO Trans_file (trans_date,trans_reference,trans_type_id,trans_quantity,product_id,del_note,inv_no,lpo_no,cost_price,staff_id,shift_day) VALUES (@trans_date,@trans_reference,@trans_type_id,@trans_quantity,@product_id,@del_note,@inv_no,@lpo_no,@cost_price,@staff_id,@shift_day) SET @tran_id = (SELECT SCOPE_IDENTITY())"
Rafnas T P9y ago
try this
if result.return_identity_id is string data type

result.return_identity_id = Command.Parameters["@patient_id"].Value.ToString();

if result.return_identity_id is int data type

result.return_identity_id = Convert.ToInt32(Command.Parameters["@patient_id"].Value.ToString());
Tapan Patel9y ago
This should do it.
result.return_identity_id = (int)(Command.Parameters["@patient_id"].Value);
Carlos kambui9y ago
password 0000
sql 2012
vs 2013
Carlos kambui9y ago
attached is the project
password 0000
Gnanavel Sekar9y ago
can you give me your full project because here is no error's maybe error's in updating or inserting data only....we will get the 0 while failed ..so i need to run and check that file.. with db backup...there is no issue in frontend...
Carlos kambui9y ago
i end up geting return=0
is there another method i can you other than this
public TransfileType SetTransfiles(TransfileType transfile)
{
ReturnType returns = new ReturnType();
BuildConnstring();
using (SqlConnection conn = new SqlConnection(connstring))
{
using (SqlCommand Command = conn.CreateCommand())
{
conn.Open();
if (transfile.trans_id == 0)
{
Command.CommandText = "INSERT INTO Trans_file (trans_date,trans_reference,trans_type_id,trans_quantity,product_id,del_note,inv_no,lpo_no,cost_price,staff_id,shift_day) VALUES (@trans_date,@trans_reference,@trans_type_id,@trans_quantity,@product_id,@del_note,@inv_no,@lpo_no,@cost_price,@staff_id,@shift_day) SET @trans_id = (SELECT SCOPE_IDENTITY())";
}
else
{
Command.CommandText = "UPDATE Trans_file set trans_date=@trans_date,trans_reference=@trans_reference,trans_type_id=@trans_type_id ,trans_quantity=@trans_quantity,product_id=@product_id,del_note=@del_note,inv_no=@inv_no,lpo_no=@lpo_no,cost_price=@cost_price,staff_id=@staff_id,shift_day=@shift_day WHERE trans_id=@trans_id";
}
Command.Parameters.Add("@trans_id", SqlDbType.Int).Value = transfile.trans_id;
Command.Parameters.Add("@trans_date", SqlDbType.DateTime).Value = transfile.trans_date;
Command.Parameters.Add("@trans_reference", SqlDbType.VarChar,255,ParameterDirection.Input.ToString()).Value = transfile.trans_reference;
Command.Parameters.Add("@trans_type_id", SqlDbType.Int).Value = 9;
Command.Parameters.Add("@trans_quantity", SqlDbType.VarChar, 255, ParameterDirection.Input.ToString()).Value = transfile.trans_quantity;
Command.Parameters.Add("@product_id", SqlDbType.Int).Value = transfile.product_id;
Command.Parameters.Add("@del_note", SqlDbType.VarChar, 255, ParameterDirection.Input.ToString()).Value = transfile.del_note;
Command.Parameters.Add("@inv_no", SqlDbType.VarChar, 255, ParameterDirection.Input.ToString()).Value = transfile.inv_no;
Command.Parameters.Add("@lpo_no", SqlDbType.VarChar, 255, ParameterDirection.Input.ToString()).Value = transfile.lpo_no;
//Command.Parameters.Add("@running_balance", SqlDbType.Decimal, 18).Value = transfile.running_balance;
Command.Parameters.Add("@cost_price", SqlDbType.Decimal, 18).Value = transfile.cost_price;
Command.Parameters.Add("@staff_id", SqlDbType.Int).Value = transfile.staff_id;
if (transfile.shift_day == true)
{
Command.Parameters.Add("@shift_day", SqlDbType.Char, 1).Value = "Y";
}
else
{
Command.Parameters.Add("@shift_day", SqlDbType.Char, 1).Value = "N";
}
int status = Command.ExecuteNonQuery();
if (status == 1)
{
returns.return_code = 1;
returns.return_identity_id =Convert.ToInt32( Command.Parameters["@trans_id"].Value);
returns.return_message = "Transaction Process succesfull";
}
else
{
}
return transfile;
}
}
}
Carlos kambui9y ago
public class ReturnType
{
public int return_code { get; set; }
public String return_message { get; set; }
public Boolean return_error { get; set; }
public int return_identity_id { get; set; }
public String return_identity_code { get; set; }
public ReturnType()
{
return_code = 0;
return_message = string.Empty;
return_error = false;
return_identity_id = 0;
return_identity_code = string.Empty;
}
}
Gnanavel Sekar9y ago
Yeah upload your source code.

Cannot implicitly convert type 'object' to 'int'. An explicit conversion exists (are you missing a cast?)
Answer : use int variablename=Convert.ToInt32(object)
Carlos kambui9y ago
attached is my source code kindly assists
Carlos kambui9y ago
still i get this
Cannot implicitly convert type 'object' to 'int'. An explicit conversion exists (are you missing a cast?)
can i upload my source code you do collection please
Gnanavel Sekar9y ago
Just try this...

result.return_identity_id = Command.Parameters["@patient_id"].Value;
Carlos kambui9y ago
i get this error
System.Data.SqlClient.SqlCommand.Parameters' cannot be used like a method.
ankit srivastava9y ago
var return_code=result.return_code;
if (return_code== 1) {
result.return_identity_id = Command.Parameters("@patient_id").Value;
result.return_message = "Patient Process succesfull";
} else {
}