I'm new to asp.net and I have gotten quite far with books and such but I'm stuck at this point. I have a web form that is mostly populated with data pulled from AD and all the user does is make a selection in two drop lists and enter their initials to sign. I can't figure out how to insert a record into a table when buttin pressed. I verified that all the data types are correct so it shoud pass the info but its just not going anywhere. I've atached the code below.

Thanks,

string adPath = LDAP://DC=********,DC=***; //Path to your LDAP directory server

string computer_name = System.Environment.MachineName;

string install_type = installtype.SelectedValue.ToString();

string email = adAuth.getemail(Context.User.Identity.Name);

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();

System.Data.OleDb.OleDbParameter parameter1 = new System.Data.OleDb.OleDbParameter();

System.Data.OleDb.OleDbParameter parameter3 = new System.Data.OleDb.OleDbParameter();

System.Data.OleDb.OleDbParameter parameter5 = new System.Data.OleDb.OleDbParameter();

System.Data.OleDb.OleDbParameter parameter7 = new System.Data.OleDb.OleDbParameter();

command.CommandText = "INSERT INTO [download_table] (username, computer_name, computer type, install type, date, email, agree, title) VALUES (?,?,?,?,?,?,?,?)";

parameter1.ParameterName = "username";

try

finally

I think if you are using ? marks for parameters, you have to use a numeric naming convention for the parameter names.

Try replacing the ? with alpha names, like @email in the statement.  Ditto where you name the parameter later.

A word of advice, don't name your parameter objects parameter1, etc.  Name them after what they represent, like paramEmail.

That way, you're less likely to accidentally put the wrong parameter value into the wrong column.

In your catch block do "Response.Write ex.toString();" to see what the error message is. Now you just catch the error and do nothing with it, and then it's pretty hard to troubleshoot :)

One thing I'm pretty sure if is that your column names with spaces in them needs to be put inside brackets: [computer type] and [install type]

Ya After refering to the entire code i got the point that you didnot Place a sign of "@" in between declaring your parameters.Ok let me explain you the code here.I am declaring in Sqlserver please convert this into your oledbServer

The code goes like this

Sqlconnection con;

Sqlcommand cmd;

con=new sqlconnection;

con.ConnectionString=""+ConfigurationManger.ConnectionStrings["connectionstring"];

con.open();

cmd=new SqlCommand("Insert into ("Ur Tablename") ("Columname1,Columnname2,Columnname") Values("@parameter1,@parameter2,@Parameter3")",con);

cmd.Parameters.Add("@Parameter1",sqldbtype.("Ur Datatype"));

cmd.parameters["@parameter1"].Value=("The value from where you desire to insert for example("textbox1.Text"));

cmd.Parameters.Add("@Parameter2",sqldbtype.("Ur Datatype"));

cmd.parameters["@parameter2"].Value=("The value from where you desire to insert for example("textbox1.Text"));

cmd.Parameters.Add("@Parameter3",sqldbtype.("Ur Datatype"));

cmd.parameters["@parameter3"].Value=("The value from where you desire to insert for example("textbox1.Text"));

cmd.ExecuteNonQuery();

Mark As Answer if this helps you

Further Queries Recommended

Happy Coding