i am tring to update but their neither any error displayed nor the data is update in the table plz help its urgent......i m using updateparameters.add ......thank u
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Label1.Text = "Hello, " + QueryString["UserEmailID"];
int cid = int.Parse(Request.QueryString["CID"]);
string conString = ConfigurationManager.ConnectionStrings["abcConnectionString"].ConnectionString;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(conString))
{
string strSQL;
strSQL = "SELECT * FROM db_main WHERE contactid=@abc";
SqlCommand com = new SqlCommand(strSQL, con);
com.Parameters.Add("@abc", SqlDbType.Int);
com.Parameters["@abc"].Value = cid;
try
{
con.Open();
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
FnameTextBox.Text = reader.IsDBNull(reader.GetOrdinal("fname")) ? null : reader
["fname"].ToString();
LNameTextBox.Text = reader.IsDBNull(reader.GetOrdinal("lname")) ? null : reader
["lname"].ToString();
MonthDropDownList.SelectedValue = reader.IsDBNull(reader.GetOrdinal("dobm")) ? "jan" : reader["dobm"].ToString();
}
}
/*catch(Exception ex)
{
throw new Exception(ex.Message);
}*/
finally
{
//reader.Close();
con.Close();
}
}
}
}
protected void ADDButton_Click(object sender, EventArgs e)
{
SqlDataSource1.UpdateParameters["userid"].DefaultValue= Request.QueryString[serEmailID].ToString();
SqlDataSource1.UpdateParameters["fname"].DefaultValue = FnameTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["lname"].DefaultValue = LNameTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["dobd"].DefaultValue = DayDropDownList.SelectedItem.ToString();
SqlDataSource1.UpdateParameters["dobm"].DefaultValue = MonthDropDownList.SelectedItem.ToString();
SqlDataSource1.UpdateParameters["doby"].DefaultValue = YearDropDownList.SelectedItem.ToString();
SqlDataSource1.UpdateParameters["marital_status"].DefaultValue = MSDropDownList.SelectedItem.ToString();
SqlDataSource1.UpdateParameters["sex"].DefaultValue = SexDropDownList.SelectedItem.ToString();
SqlDataSource1.UpdateParameters["stdcode"].DefaultValue = STDTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["telno"].DefaultValue = LandineTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["country_code"].DefaultValue = ISDDropDownList.SelectedItem.ToString();
SqlDataSource1.UpdateParameters["mobile"].DefaultValue = MobileTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["email"].DefaultValue = EmailTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["alt_email"].DefaultValue = AltEMailTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["groupname"].DefaultValue = GroupDropDownList.SelectedItem.ToString();
SqlDataSource1.UpdateParameters["houseno"].DefaultValue = HouseTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["street"].DefaultValue = StreetTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["locality"].DefaultValue = LocalityTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["city"].DefaultValue = CityTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["state"].DefaultValue = StateTextBox.Text.ToString();
SqlDataSource1.UpdateParameters["country"].DefaultValue = CountryDropDownList1.SelectedItem.ToString();
SqlDataSource1.UpdateParameters["pin"].DefaultValue = PINTextBox.Text.ToString();
SqlDataSource1.Update();
Label4.Text = "updated";
}
protected void EDITButton_Click(object sender, EventArgs e)
{
string conString = ConfigurationManager.ConnectionStrings["abcConnectionString"].ConnectionString;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(conString))
{
string strSQL;
strSQL = "SELECT * FROM db_main WHERE contactid='12'";
SqlCommand com = new SqlCommand(strSQL, con);
//com.CommandType = CommandType.StoredProcedure;
try
{
con.Open();
SqlDataReader reader=com.ExecuteReader();
while (reader.Read())
{
FnameTextBox.Text = reader.IsDBNull(reader.GetOrdinal("fname")) ? null : reader
["fname"].ToString();
LNameTextBox.Text=reader.IsDBNull(reader.GetOrdinal("lname"))? null: reader
["lname"].ToString();
MonthDropDownList.SelectedValue = reader.IsDBNull(reader.GetOrdinal("dobm"))? "jan" : reader["dobm"].ToString();
}
}
/*catch(Exception ex)
{
throw new Exception(ex.Message);
}*/
finally
{
con.Close();
}
}
}
}<%@ Page Language="C#" MasterPageFile="~/MasterPage2.master" AutoEventWireup="true" CodeFile="edit.aspx.cs" Inherits="add" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table style="height: 104%" width="100%">
<tr>
<td bgcolor="#d3dfef" style="width: 301px">
</td>
<td bgcolor="ghostwhite" bordercolor="ghostwhite" colspan="2">
<table align="center" style="width: 101px">
<tr>
<td align="center" colspan="3" style="height: 8px; width: 97px;">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></td>
</tr>
</table>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="OverwriteChanges"
ConnectionString="<%$ ConnectionStrings:abcConnectionString %>" DeleteCommand="DELETE FROM [db_main] WHERE [contactid] = @original_contactid AND [userid] = @original_userid AND (([email] = @original_email) OR ([email] IS NULL AND @original_email IS NULL)) AND (([fname] = @original_fname) OR ([fname] IS NULL AND @original_fname IS NULL)) AND (([lname] = @original_lname) OR ([lname] IS NULL AND @original_lname IS NULL)) AND (([dobd] = @original_dobd) OR ([dobd] IS NULL AND @original_dobd IS NULL)) AND (([dobm] = @original_dobm) OR ([dobm] IS NULL AND @original_dobm IS NULL)) AND (([doby] = @original_doby) OR ([doby] IS NULL AND @original_doby IS NULL)) AND (([marital_status] = @original_marital_status) OR ([marital_status] IS NULL AND @original_marital_status IS NULL)) AND (([sex] = @original_sex) OR ([sex] IS NULL AND @original_sex IS NULL)) AND (([telno] = @original_telno) OR ([telno] IS NULL AND @original_telno IS NULL)) AND (([mobile] = @original_mobile) OR ([mobile] IS NULL AND @original_mobile IS NULL)) AND (([stdcode] = @original_stdcode) OR ([stdcode] IS NULL AND @original_stdcode IS NULL)) AND (([country_code] = @original_country_code) OR ([country_code] IS NULL AND @original_country_code IS NULL)) AND (([alt_email] = @original_alt_email) OR ([alt_email] IS NULL AND @original_alt_email IS NULL)) AND (([groupname] = @original_groupname) OR ([groupname] IS NULL AND @original_groupname IS NULL)) AND (([houseno] = @original_houseno) OR ([houseno] IS NULL AND @original_houseno IS NULL)) AND (([street] = @original_street) OR ([street] IS NULL AND @original_street IS NULL)) AND (([locality] = @original_locality) OR ([locality] IS NULL AND @original_locality IS NULL)) AND (([city] = @original_city) OR ([city] IS NULL AND @original_city IS NULL)) AND (([state] = @original_state) OR ([state] IS NULL AND @original_state IS NULL)) AND (([country] = @original_country) OR ([country] IS NULL AND @original_country IS NULL)) AND (([pin] = @original_pin) OR ([pin] IS NULL AND @original_pin IS NULL))"
InsertCommand="INSERT INTO [db_main] ([userid], [email], [fname], [lname], [dobd], [dobm], [doby], [marital_status], [sex], [telno], [mobile], [stdcode], [country_code], [alt_email], [groupname], [houseno], [street], [locality], [city], [state], [country], [pin]) VALUES (@userid, @email, @fname, @lname, @dobd, @dobm, @doby, @marital_status, @sex, @telno, @mobile, @stdcode, @country_code, @alt_email, @groupname, @houseno, @street, @locality, @city, @state, @country, @pin)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [db_main]"
UpdateCommand="UPDATE [db_main] SET [userid] = @userid, [email] = @email, [fname] = @fname, [lname] = @lname, [dobd] = @dobd, [dobm] = @dobm, [doby] = @doby, [marital_status] = @marital_status, [sex] = @sex, [telno] = @telno, [mobile] = @mobile, [stdcode] = @stdcode, [country_code] = @country_code, [alt_email] = @alt_email, [groupname] = @groupname, [houseno] = @houseno, [street] = @street, [locality] = @locality, [city] = @city, [state] = @state, [country] = @country, [pin] = @pin WHERE [contactid] = @original_contactid AND [userid] = @original_userid AND (([email] = @original_email) OR ([email] IS NULL AND @original_email IS NULL)) AND (([fname] = @original_fname) OR ([fname] IS NULL AND @original_fname IS NULL)) AND (([lname] = @original_lname) OR ([lname] IS NULL AND @original_lname IS NULL)) AND (([dobd] = @original_dobd) OR ([dobd] IS NULL AND @original_dobd IS NULL)) AND (([dobm] = @original_dobm) OR ([dobm] IS NULL AND @original_dobm IS NULL)) AND (([doby] = @original_doby) OR ([doby] IS NULL AND @original_doby IS NULL)) AND (([marital_status] = @original_marital_status) OR ([marital_status] IS NULL AND @original_marital_status IS NULL)) AND (([sex] = @original_sex) OR ([sex] IS NULL AND @original_sex IS NULL)) AND (([telno] = @original_telno) OR ([telno] IS NULL AND @original_telno IS NULL)) AND (([mobile] = @original_mobile) OR ([mobile] IS NULL AND @original_mobile IS NULL)) AND (([stdcode] = @original_stdcode) OR ([stdcode] IS NULL AND @original_stdcode IS NULL)) AND (([country_code] = @original_country_code) OR ([country_code] IS NULL AND @original_country_code IS NULL)) AND (([alt_email] = @original_alt_email) OR ([alt_email] IS NULL AND @original_alt_email IS NULL)) AND (([groupname] = @original_groupname) OR ([groupname] IS NULL AND @original_groupname IS NULL)) AND (([houseno] = @original_houseno) OR ([houseno] IS NULL AND @original_houseno IS NULL)) AND (([street] = @original_street) OR ([street] IS NULL AND @original_street IS NULL)) AND (([locality] = @original_locality) OR ([locality] IS NULL AND @original_locality IS NULL)) AND (([city] = @original_city) OR ([city] IS NULL AND @original_city IS NULL)) AND (([state] = @original_state) OR ([state] IS NULL AND @original_state IS NULL)) AND (([country] = @original_country) OR ([country] IS NULL AND @original_country IS NULL)) AND (([pin] = @original_pin) OR ([pin] IS NULL AND @original_pin IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_contactid" Type="Int32" />
<asp:Parameter Name="original_userid" Type="String" />
<asp:Parameter Name="original_email" Type="String" />
<asp:Parameter Name="original_fname" Type="String" />
<asp:Parameter Name="original_lname" Type="String" />
<asp:Parameter Name="original_dobd" Type="String" />
<asp:Parameter Name="original_dobm" Type="String" />
<asp:Parameter Name="original_doby" Type="String" />
<asp:Parameter Name="original_marital_status" Type="String" />
<asp:Parameter Name="original_sex" Type="String" />
<asp:Parameter Name="original_telno" Type="String" />
<asp:Parameter Name="original_mobile" Type="String" />
<asp:Parameter Name="original_stdcode" Type="String" />
<asp:Parameter Name="original_country_code" Type="String" />
<asp:Parameter Name="original_alt_email" Type="String" />
<asp:Parameter Name="original_groupname" Type="String" />
<asp:Parameter Name="original_houseno" Type="String" />
<asp:Parameter Name="original_street" Type="String" />
<asp:Parameter Name="original_locality" Type="String" />
<asp:Parameter Name="original_city" Type="String" />
<asp:Parameter Name="original_state" Type="String" />
<asp:Parameter Name="original_country" Type="String" />
<asp:Parameter Name="original_pin" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="userid" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="fname" Type="String" />
<asp:Parameter Name="lname" Type="String" />
<asp:Parameter Name="dobd" Type="String" />
<asp:Parameter Name="dobm" Type="String" />
<asp:Parameter Name="doby" Type="String" />
<asp:Parameter Name="marital_status" Type="String" />
<asp:Parameter Name="sex" Type="String" />
<asp:Parameter Name="telno" Type="String" />
<asp:Parameter Name="mobile" Type="String" />
<asp:Parameter Name="stdcode" Type="String" />
<asp:Parameter Name="country_code" Type="String" />
<asp:Parameter Name="alt_email" Type="String" />
<asp:Parameter Name="groupname" Type="String" />
<asp:Parameter Name="houseno" Type="String" />
<asp:Parameter Name="street" Type="String" />
<asp:Parameter Name="locality" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="country" Type="String" />
<asp:Parameter Name="pin" Type="Int32" />
<asp:Parameter Name="original_contactid" Type="Int32" />
<asp:Parameter Name="original_userid" Type="String" />
<asp:Parameter Name="original_email" Type="String" />
<asp:Parameter Name="original_fname" Type="String" />
<asp:Parameter Name="original_lname" Type="String" />
<asp:Parameter Name="original_dobd" Type="String" />
<asp:Parameter Name="original_dobm" Type="String" />
<asp:Parameter Name="original_doby" Type="String" />
<asp:Parameter Name="original_marital_status" Type="String" />
<asp:Parameter Name="original_sex" Type="String" />
<asp:Parameter Name="original_telno" Type="String" />
<asp:Parameter Name="original_mobile" Type="String" />
<asp:Parameter Name="original_stdcode" Type="String" />
<asp:Parameter Name="original_country_code" Type="String" />
<asp:Parameter Name="original_alt_email" Type="String" />
<asp:Parameter Name="original_groupname" Type="String" />
<asp:Parameter Name="original_houseno" Type="String" />
<asp:Parameter Name="original_street" Type="String" />
<asp:Parameter Name="original_locality" Type="String" />
<asp:Parameter Name="original_city" Type="String" />
<asp:Parameter Name="original_state" Type="String" />
<asp:Parameter Name="original_country" Type="String" />
<asp:Parameter Name="original_pin" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="userid" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="fname" Type="String" />
<asp:Parameter Name="lname" Type="String" />
<asp:Parameter Name="dobd" Type="String" />
<asp:Parameter Name="dobm" Type="String" />
<asp:Parameter Name="doby" Type="String" />
<asp:Parameter Name="marital_status" Type="String" />
<asp:Parameter Name="sex" Type="String" />
<asp:Parameter Name="telno" Type="String" />
<asp:Parameter Name="mobile" Type="String" />
<asp:Parameter Name="stdcode" Type="String" />
<asp:Parameter Name="country_code" Type="String" />
<asp:Parameter Name="alt_email" Type="String" />
<asp:Parameter Name="groupname" Type="String" />
<asp:Parameter Name="houseno" Type="String" />
<asp:Parameter Name="street" Type="String" />
<asp:Parameter Name="locality" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="country" Type="String" />
<asp:Parameter Name="pin" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<asp:Image ID="Image1" runat="server" ImageAlign="Top" ImageUrl="~/images/add_businesswoman.png" />
<br />
<asp:Label ID="Label4" runat="server" Width="80px"></asp:Label>
<table style="color: #00467f; font-family: Arial;">
<tr>
<td colspan="2">
EDIT/VIEW CONTACT</td>
</tr>
<tr>
<td style="width: 1px; height: 6px;" align="left">
<asp:Label ID="Label3" runat="server" Text="First Name" Width="174px"></asp:Label></td>
<td style="width: 51%; height: 6px;" align="left">
<asp:TextBox ID="FnameTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label2" runat="server" Text="Last Name" Width="92px"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:TextBox ID="LNameTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px; height: 21px" align="left">
<asp:Label ID="Label5" runat="server" Text="Date of Birth" Width="171px"></asp:Label></td>
<td style="width: 51%; height: 21px" align="left">
<asp:DropDownList ID="DayDropDownList" runat="server">
<asp:ListItem>01</asp:ListItem>
<asp:ListItem>02</asp:ListItem>
<asp:ListItem>31</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="MonthDropDownList" runat="server" >
<asp:ListItem>jan</asp:ListItem>
<asp:ListItem></asp:ListItem>
<asp:ListItem>feb</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="YearDropDownList" runat="server">
<asp:ListItem>1991</asp:ListItem>
<asp:ListItem>1990</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label6" runat="server" Text="Marital Status" Width="113px"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:DropDownList ID="MSDropDownList" runat="server">
<asp:ListItem>Single</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label7" runat="server" Text="Sex"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:DropDownList ID="SexDropDownList" runat="server">
<asp:ListItem>Sex</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label8" runat="server" Text="Landline No" Width="93px"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:TextBox ID="STDTextBox" runat="server" Width="55px"></asp:TextBox>
<asp:TextBox ID="LandineTextBox" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label9" runat="server" Text="Mobile No." Width="99px"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:DropDownList ID="ISDDropDownList" runat="server">
<asp:ListItem>+91</asp:ListItem>
</asp:DropDownList>
<asp:TextBox ID="MobileTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label10" runat="server" Text="E Mail Address" Width="179px"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:TextBox ID="EmailTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px; height: 54px;" align="left">
<asp:Label ID="Label11" runat="server" Text="Alternate E Mail ID" Width="140px"></asp:Label></td>
<td style="width: 51%; height: 54px;" align="left">
<asp:TextBox ID="AltEMailTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label12" runat="server" Text="Group"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:DropDownList ID="GroupDropDownList" runat="server">
<asp:ListItem>Office</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="width: 1px; height: 21px" align="left">
<asp:Label ID="Label13" runat="server" Text="ADDRESS:"></asp:Label></td>
<td style="width: 51%; height: 21px" align="left">
</td>
</tr>
<tr>
<td style="width: 1px; height: 2px;" align="left">
<asp:Label ID="Label14" runat="server" Text="House No" Width="157px"></asp:Label></td>
<td style="width: 51%; height: 2px;" align="left">
<asp:TextBox ID="HouseTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label15" runat="server" Text="Street/Area"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:TextBox ID="StreetTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label16" runat="server" Text="Locality/Landmark"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:TextBox ID="LocalityTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label17" runat="server" Text="City"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:TextBox ID="CityTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label18" runat="server" Text="State"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:TextBox ID="StateTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 1px" align="left">
<asp:Label ID="Label19" runat="server" Text="Country"></asp:Label></td>
<td style="width: 51%" align="left">
<asp:DropDownList ID="CountryDropDownList1" runat="server">
<asp:ListItem>India</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="width: 1px; height: 26px;" align="left">
<asp:Label ID="Label20" runat="server" Text="PIN Code" Width="97px"></asp:Label></td>
<td style="width: 51%; height: 26px;" align="left">
<asp:TextBox ID="PINTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td colspan="2"><asp:Button ID="editButton" runat="server" BackColor="#4F81BC" BorderColor="White"
BorderStyle="Solid" BorderWidth="1px" Font-Bold="True" Font-Names="Arial"
Font-Size="Medium" ForeColor="White" Height="38px" OnClick="EDITButton_Click"
Text="EDIT" Width="107px" />
<asp:Button ID="ADDButton" runat="server" BackColor="#4F81BC" BorderColor="White"
BorderStyle="Solid" BorderWidth="1px" Font-Bold="True" Font-Names="Arial"
Font-Size="Medium" ForeColor="White" Height="38px" OnClick="ADDButton_Click"
Text="save" Width="107px" /></td>
</tr>
</table>
</td>
</tr>
</table>
</asp:Content>