actually i was thinking in code behind...
here is my insert form....
protected void VideoLinkVnos(object sender, EventArgs e)
{
// Determine the currently logged on user's UserId
MembershipUser currentUser = Membership.GetUser();
Int32 currentUserId = (Int32)currentUser.ProviderUserKey;
string getLastPartURL = "@VideoPovezava";
getLastPartURL = getLastPartURL.Split('=')[1];
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\Orozje-Reloading-Center.mdb";
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO VIDEO_MOJI(VideoNaslov, VideoPovezava, UserId) VALUES(?, ?, ?)";
cmd.Parameters.AddWithValue("@VideoNaslov", VideoNaslovTextBox.Text.Trim());
cmd.Parameters.AddWithValue("@VideoPovezava", getLastPartURL);
cmd.Parameters.AddWithValue("@UserId", currentUserId);
cmd.ExecuteNonQuery();
conn.Close();
// "Reset" TextBoxes
VideoNaslovTextBox.Text = string.Empty;
VideoPovezavaTextBox.Text = string.Empty;
Uspeh.Text = "Video je uspešno dodan!";
}
VideoPovezava holds the URL...so i tried to write that code above to insert form but it's not entering to db now.