Comments by Member 8780842 (Top 55 by date)

I tried this sir

public string show(decimal busid,decimal totalseats,string bustype,string journeydate,string arrtime,string depttime,string source,string destination,decimal ticketprice,string bpoint,string dpoint)
{
string var;

OleDbConnection cn = new OleDbConnection("Provider=MSDAORA.1;User ID=system;password=tiger;Data Source=XE;Persist Security Infor=False");


try
{
cn.Open();
string s = "Insert into busdetails(BUS_ID,TOTAL_SEATS,BUS_TYPE,JOURNEY_DATE,ARR_TIME,DEPT_TIME,SOURCE,DESTINATION,TICKET_PRICE,B_POINT,D_POINT) values(:busid,:totseats,:bustype,:jdate,:arrtime,:dtime,:source,:dest,:tickprice,:bpoint,:dpoint)";


OleDbCommand cmd = new OleDbCommand(s, cn);
//@busid,@totseats,@bustype,@jdate,@arrtime,@dtime,@source,@dest,@tickprice,@bpoint,@dpoint
cmd.Parameters.AddWithValue("busid", Convert.ToDecimal(busid));
cmd.Parameters.AddWithValue("totseats", Convert.ToDecimal(totalseats));
cmd.Parameters.AddWithValue("bustype", bustype);
cmd.Parameters.AddWithValue("jdate", journeydate);
cmd.Parameters.AddWithValue("arrtime", arrtime);
cmd.Parameters.AddWithValue("dtime", depttime);
cmd.Parameters.AddWithValue("source", source);
cmd.Parameters.AddWithValue("dest", destination);
cmd.Parameters.AddWithValue("tickprice", Convert.ToDecimal(ticketprice));
cmd.Parameters.AddWithValue("bpoint", bpoint);
cmd.Parameters.AddWithValue("dpoint", dpoint);

cmd.ExecuteNonQuery();
var="success";
}
catch (OleDbException e1)
{
Console.Write(e1.Message);
Console.Write(e1.StackTrace);
var = e1.Message;
}
cn.Close();
return var;
}
}

table format is
bus_id not null nummber(6,2)
total_seats number
bus_type varchar2<4000>
journey_date varchar2<4000>
arr_time varchar2<4000>
dept_time varchar2<4000>
source varchar2<4000>
destination varchar2<4000>
ticket_price number(5,2)
b_point varchar2<4000>
d_point varchar2<4000>
I am getting this error

ORA 0:01008: Not all variables bound