hai ,
i am doing project on online banking ....i got problem while trying to add parameters Using oledb connections.this is my code..how to solve this problem..
private void Button2_Click(object sender, System.EventArgs e)
{

try
{
con=new OleDbConnection("User ID=administrator;Password=sa;Data Source=express5;Tag with column collation when possible=False;Initial Catalog=EBank;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=SQLOLEDB.1;Workstation ID=EXPRESS5;Use Encryption for Data=False;Packet Size=4096");
con.Open();
ac=new OleDbCommand("INSERT INTO Regs_form (F_NAME,L_NAME,ADDRESS,DATE_OF_BIRTH,E_MAILID,CITY,PINCODE,PHONE_NUM,MOBILE_NUM) VALUES(?,?,?,?,?,?,?,?,?)",con);
pr=new OleDbParameter();
cb=new OleDbCommandBuilder();

ac.Parameters.Add(new OleDbParameter("sf",OleDbType.VarChar,50,ParameterDirection.Input,false,((System.Byte)(0)),((System.Byte)(0)),"F_NAME",DataRowVersion.Current,null));

ac.Parameters.Add(new OleDbParameter("L_NAME",OleDbType.VarChar,50,"sl"));
ac.Parameters.Add(new OleDbParameter("ADDRESS",OleDbType.VarChar,50,"sadd"));
ac.Parameters.Add(new OleDbParameter("DATE_OF_BIRTH",OleDbType.VarChar,50,"sdob"));
ac.Parameters.Add(new OleDbParameter("E_MAILID",OleDbType.VarChar,50,"se"));
ac.Parameters.Add(new OleDbParameter("CITY",OleDbType.VarChar,10,"sc"));
ac.Parameters.Add(new OleDbParameter("PINCODE",OleDbType.Integer,4,"sp"));
ac.Parameters.Add(new OleDbParameter("PHONE_NUM",OleDbType.VarChar,10,"sph"));
ac.Parameters.Add(new OleDbParameter("MOBILE_NUM",OleDbType.VarChar,10,"sm"));

OleDbParameterCollection parcol=ac.Parameters;

pr.Value=sf=fname.Text;
pr.Value=sl=lname.Text;
pr.Value=sadd=address.Text;
pr.Value=se=email.Text;
pr.Value=sc=city.Text;
pr.Value=sdob=dob.Text;
pr.Value=sp=pcode.Text;
pr.Value=sph=pnum.Text;
pr.Value=sm=mnum.Text;

ac.ExecuteNonQuery();
con.Close();



}
catch(System.Exception ex)
{
Label1.Text=ex.ToString();
}

Response.Write("ad");


}
thank you