hi.. i am using birthdate field in createuserwizard control.. in my computer its working with fromat mm/dd/yyyy bt at collge same code raise error...
i have use compare validator for date type check..
<tr>
<%-- Birthdate --%>
<td align="right" style="width: 156px">
<asp:Label ID="lblbdate" Text="Birthdate(mm/dd/yyyy)" runat="server" AssociatedControlID="txtbdate"/>td><td>
<asp:TextBox runat="server" ID="txtbdate"/>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="txtbdate" ErrorMessage="Enter Birthdate" ValidationGroup="CreateUserWizard1" Text="*" />
<asp:CompareValidator ID="cmpbdate" runat="server" ControlToValidate="txtbdate" ErrorMessage="Invalid Date"Operator="DataTypeCheck" Text="#" Type="Date" Font-Size="Smaller"/>
td>tr> <tr>
.cs
public void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
//// Create an empty Profile for the newly created user
ProfileCommon p = (ProfileCommon)ProfileCommon.Create(CreateUserWizard1.UserName, true);
p.Country = ((DropDownList)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Country")).SelectedValue;
p.Gender = ((DropDownList)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Gender")).SelectedValue;
p.FirstName = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtfname")).Text;
p.LastName = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtlname")).Text;
p.Email = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Email")).Text;
p.BirthDate = Convert.ToDateTime(((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtbdate")).Text);
p.City = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("city")).Text;
p.PostCode = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtpcode")).Text;
p.uimage = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtPictureURL")).Text;
//// Save the profile - must be done since we explicitly created this profile instance
da.Fill(ds, "profile");
int count = ds.Tables[0].Rows.Count;
int pid = 0;
if (count > 0)
{
pid = Convert.ToInt32(ds.Tables[0].Rows[count - 1][0].ToString());
pid = pid + 1;
}
else
{
pid = 1;
}
p.profile_Id = pid;
p.Save();
//adding data to profile....
TextBox uname=((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("UserName"));
string username = uname.Text;
objconnection.Open();
string c1 = "insert into profile(profileId,pimage,fname,lname,Username,Email,Sex,Birthdate,city_town,Country,Zip)values(@pid,@pimage,@fname,@lname,@uname,@Email,@sex,@bdate,@city,@country,@zip)";
SqlCommand comm = new SqlCommand(c1, objconnection);
comm.Parameters.AddWithValue("@pid", pid);
comm.Parameters.AddWithValue("@pimage", p.uimage.ToString());
comm.Parameters.AddWithValue("@fname", p.FirstName.ToString());
comm.Parameters.AddWithValue("@lname", p.LastName.ToString());
comm.Parameters.AddWithValue("@uname", username.ToString());
comm.Parameters.AddWithValue("@Email", p.Email.ToString());
comm.Parameters.AddWithValue("@sex", p.Gender.ToString());
Error @this line here:
comm.Parameters.AddWithValue("@bdate", Convert.ToDateTime(p.BirthDate.ToString()));
Loading
ajay rajuPosted Mar 1, 2010, 2:23 AM
some controls take month in second position ex: 2 jan 2010 control take date format is 1/2/2010.
best way to solve this is goto control panel select regional and language options into English(united Kingdom) in regional options tab.
if help this solution then don't forget mark on Accept Answer Checkbox.
Thanks
Vamsi GarudaPosted Feb 26, 2010, 10:40 AM
comm.Parameters.Add("@bdate", SqlDbType.DateTime);
try above line before
comm.Parameters.AddWithValue("@bdate", Convert.ToDateTime(p.BirthDate.ToString()));
otherwise let me know the error description.