TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Saurabh Bhardwaj
NA
14
14.1k
Data not stored in database
Dec 11 2012 4:31 AM
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Drawing;
public partial class allrishteymaster : System.Web.UI.MasterPage
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
//start making session
Session["email"] = Textmail;
Session["password"] = Textpassword;
Session["profilefor"] = profilefor;
Session["name"] = Textusername;
Session["gender"] = Radiomale;
Session["gender"] = Radiofemale;
Session["dd"] = dd;
Session["mm"] = mm;
Session["yy"] = yy;
Session["religion"] = religion;
Session["mothertongue"] = mothertongue;
Session["livingin"] = livingin;
//end making session
}
protected void regissub_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select email from userregisteration where email='" + Textmail + "'", con);
DataSet ds = new DataSet();
da.Fill(ds, "userregisteration");
if (ds.Tables[0].Rows.Count > 0)
{
error.Text = "User Name Already Exits";
}
else if (Checkbox1.Checked == true)
{
SqlCommand cmd = new SqlCommand("insert into userregisteration(uid,email,password,prpofilefor,username,gender,dob,religion,mothertongue,livingin) values(@uid,@email,@password,@prpofilefor,@username,@gender,@dob,@religion,@mothertongue,@livingin)", con);
cmd.Parameters.Add(new SqlParameter("@uid", Session["uid"]));
cmd.Parameters.Add(new SqlParameter("@email", Textmail));
cmd.Parameters.Add(new SqlParameter("@password", Textpassword));
cmd.Parameters.Add(new SqlParameter("@prpofilefor", profilefor));
cmd.Parameters.Add(new SqlParameter("@username", Textusername));
cmd.Parameters.Add(new SqlParameter("@gender", Radiomale));
cmd.Parameters.Add(new SqlParameter("@gender", Radiofemale));
cmd.Parameters.Add(new SqlParameter("@dob", dd.SelectedIndex + "-" + mm.SelectedIndex + "-" + yy));
cmd.Parameters.Add(new SqlParameter("@religion", religion));
cmd.Parameters.Add(new SqlParameter("@mothertongue", mothertongue));
cmd.Parameters.Add(new SqlParameter("@livingin", livingin));
//cmd.ExecuteNonQuery();
con.Close();
Response.Redirect("RgistrationProfile2.aspx");
}
else
{
error.Text = "Please Select Privacy Policy and T&C";
}
}
}
Reply
Answers (
2
)
Want to study some simple asp.net projects
How to show data in Gridview from different resources..?