Step 1. Make Table
Step 2. Make Store Procedure like this:-
ALTER procedure [dbo].[regis]
@name nvarchar(34),
@email nvarchar(45),
@password nvarchar(34),
@verify_password nvarchar(34),
@address nvarchar(78),
@phone nvarchar(23),
@state nvarchar(34),
@country nvarchar(23)
as
begin
insert into registration values(@name,@email,@password,@verify_password,@address,@phone,@state,@country);
end
Step 3. Take a Class library and write this code:-
public class connection
{
public bool save_data(string fname, string email, string password1, string verify_password, string address, string phone, string state, string country)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["con"].ToString());
SqlCommand cmd = new SqlCommand("regis", con);
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", fname);
cmd.Parameters.AddWithValue("@email", email);
cmd.Parameters.AddWithValue("@password",FormsAuthentication.HashPasswordForStoringInConfigFile ( password1,"Md5"));
cmd.Parameters.AddWithValue("@verify_password",verify_password);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@phone", phone);
cmd.Parameters.AddWithValue("@state", state);
cmd.Parameters.AddWithValue("@country", country);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
return true;
return false;
}
}
Step 4. Call this function on Registration button like this:-
protected void Registration_Click(object sender, EventArgs e)
{
connection ur = new connection();
bool check = ur.save_data(Tname.Text.Trim(),Temail.Text.Trim(),Tpassword.Text.Trim(),Tverifypassword.Text.Trim(),
Taddress.Text.Trim(),Tphone.Text.Trim(),Tstate.Text.Trim(),Dcountry.SelectedItem.Text );
if (check == true)
{
Response.Write("Congrachulations! you have succesfully registered");
}
else
{
Response.Write("Please fill information correctly");
}
}
CSS hover menu
Please note that the above code is tested on the latest version of Mozilla Firefox. It should work normally on all new browsers, which support the hover functionality.