insert values into table using dataset and dropdownlist

Sulieman Alkatib

I just finish dataSet codes as followed:

SELECT date_E, adminname

FROM event

WHERE (ID = ?)

I have a dropDownList that allows user to select ID only and the system will insert date_E and adminname into that table

what is the proper code to get date_e and adminname to use it in my function

protected void Button1_Click(object sender, EventArgs e)
{
string id = DropDownList1.SelectedValue;
OleDbConnection con = new OleDbConnection("connectionstring");
try
{
OleDbCommand cmd = con.CreateCommand();
con.Open();
cmd.CommandText = "Insert into customer Values('" + Session["UserName"] + "','" + ????? + "' , '" + DropDownList1.SelectedValue + "' , '" + ????? + "')";
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
Label3.Text = "Registered successfully";
}
catch (Exception)
{
Label3.Text = "database connection problem";
}
}

5 Replies

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

Thiruppathi R9y ago
You may check like that

SELECT date_E, adminname FROM event WHERE (NULL(ID,0) = 0)
Thiruppathi R9y ago
Hi Sulieman Alkatib

"missing values" you mean, you want to get NULL column OR empty column in "event"?
Amit Gupta9y ago
Your question is partial understable, elaborate a bit more, what about missing values. As we are totally unaware of such things
Sulieman Alkatib9y ago
Hey Mr.Amit

I can use it but now I need a code to take missing values witch is ( date_E, adminname) from EVENT table
Amit Gupta9y ago
Hey, you are doing good.

To make your query more readable, manageable and error free, you must use the parameterized query for any CRUD operation to avoid any injection to the database.

Look at the below link for insertion using parameterized query.
https://stackoverflow.com/questions/5893837/using-parameters-inserting-data-into-access-database

Good luck !!