Here is the Grid view code: I want to get the selected row when the user click "Select"
I think it might related to the database Table !!
Expand|Select|Wrap|Line Numbers
- <asp:SqlDataSource ID="sdsCustomer" runat="server" ConflictDetection="CompareAllValues"
- ConnectionString="Data Source=.;Initial Catalog=TimeSheet;Integrated Security=True"
- DeleteCommand="DELETE FROM [CustomerTable] WHERE [DocumentID] = @original_DocumentID AND [CustomerName] = @original_CustomerName AND [Phone] = @original_Phone AND [Phone2] = @original_Phone2 AND [Phone3] = @original_Phone3 AND [Address] = @original_Address AND [Fax] = @original_Fax AND [email] = @original_Email AND [Representetive] = @original_Representetive AND [DomainName] = @original_DomainName AND [RenewDate] = @original_RenewDate AND [CompanyActivity] = @original_CompanyActivity AND [HowToRecognize] = @original_HowToRecognize"
- InsertCommand="INSERT INTO [CustomerTable] ([CustomerName], [Phone], [Phone2], [Phone3], [Address], [Fax], [email], [Representetive], [DomainName], [RenewDate], [CompanyActivity], [HowToRecognize]) VALUES (@CustomerName, @Phone, @Phone2, @Phone3, @Address, @Fax, @Email, @Representetive, @DomainName, @RenewDate, @CompanyActivity, @HowToRecognize)"
- OldValuesParameterFormatString="original_{0}" OnUpdated="sdsAllCustomers_Updated"
- ProviderName="System.Data.SqlClient" SelectCommand="SELECT [DocumentID], [CustomerName], [Phone], [Phone2], [Phone3], [Address], [Fax], [email], [Representetive], [DomainName], [RenewDate], [CompanyActivity], [HowToRecognize] FROM [CustomerTable] ORDER BY [CustomerName]"
- UpdateCommand="UPDATE [CustomerTable] SET [CustomerName] = @CustomerName, [Phone] = @Phone, [Phone2] = @Phone2, [Phone3] = @Phone3, [Address] = @Address, [Fax] = @Fax, [email] = @Email, [Representetive] = @Representetive, [DomainName] = @DomainName, [RenewDate] = @RenewDate, [CompanyActivity] = @CompanyActivity, [HowToRecognize] = @HowToRecognize WHERE [DocumentID] = @original_DocumentID AND [CustomerName] = @original_CustomerName AND [Phone] = @original_Phone AND [Phone2] = @original_Phone2 AND [Phone3] = @original_Phone3 AND [Address] = @original_Address AND [Fax] = @original_Fax AND [email] = @original_Email AND [Representetive] = @original_Representetive AND [DomainName] = @original_DomainName AND [RenewDate] = @original_RenewDate AND [CompanyActivity] = @original_CompanyActivity AND [HowToRecognize] = @original_HowToRecognize">
- <DeleteParameters>
- <asp:Parameter Name="original_DocumentID" Type="Object" />
- <asp:Parameter Name="original_CustomerName" Type="String" />
- <asp:Parameter Name="original_Phone" Type="String" />
- <asp:Parameter Name="original_Phone2" Type="String" />
- <asp:Parameter Name="original_Phone3" Type="String" />
- <asp:Parameter Name="original_Address" Type="String" />
- <asp:Parameter Name="original_Fax" Type="String" />
- <asp:Parameter Name="original_Email" Type="String" />
- <asp:Parameter Name="original_Representetive" Type="String" />
- <asp:Parameter Name="original_DomainName" Type="String" />
- <asp:Parameter Name="original_RenewDate" Type="String" />
- <asp:Parameter Name="original_CompanyActivity" Type="String" />
- <asp:Parameter Name="original_HowToRecognize" Type="String" />
- </DeleteParameters>
- <UpdateParameters>
- <asp:Parameter Name="CustomerName" Type="String" />
- <asp:Parameter Name="Phone" Type="String" />
- <asp:Parameter Name="Phone2" Type="String" />
- <asp:Parameter Name="Phone3" Type="String" />
- <asp:Parameter Name="Address" Type="String" />
- <asp:Parameter Name="Fax" Type="String" />
- <asp:Parameter Name="Email" Type="String" />
- <asp:Parameter Name="Representetive" Type="String" />
- <asp:Parameter Name="DomainName" Type="String" />
- <asp:Parameter Name="RenewDate" Type="String" />
- <asp:Parameter Name="CompanyActivity" Type="String" />
- <asp:Parameter Name="HowToRecognize" Type="String" />
- <asp:Parameter Name="original_DocumentID" Type="Object" />
- <asp:Parameter Name="original_CustomerName" Type="String" />
- <asp:Parameter Name="original_Phone" Type="String" />
- <asp:Parameter Name="original_Phone2" Type="String" />
- <asp:Parameter Name="original_Phone3" Type="String" />
- <asp:Parameter Name="original_Address" Type="String" />
- <asp:Parameter Name="original_Fax" Type="String" />
- <asp:Parameter Name="original_Email" Type="String" />
- <asp:Parameter Name="original_Representetive" Type="String" />
- <asp:Parameter Name="original_DomainName" Type="String" />
- <asp:Parameter Name="original_RenewDate" Type="String" />
- <asp:Parameter Name="original_CompanyActivity" Type="String" />
- <asp:Parameter Name="original_HowToRecognize" Type="String" />
- </UpdateParameters>
- <InsertParameters>
- <asp:Parameter Name="CustomerName" Type="String" />
- <asp:Parameter Name="Phone" Type="String" />
- <asp:Parameter Name="Phone2" Type="String" />
- <asp:Parameter Name="Phone3" Type="String" />
- <asp:Parameter Name="Address" Type="String" />
- <asp:Parameter Name="Fax" Type="String" />
- <asp:Parameter Name="Email" Type="String" />
- <asp:Parameter Name="Representetive" Type="String" />
- <asp:Parameter Name="DomainName" Type="String" />
- <asp:Parameter Name="RenewDate" Type="String" />
- <asp:Parameter Name="CompanyActivity" Type="String" />
- <asp:Parameter Name="HowToRecognize" Type="String" />
- </InsertParameters>
- </asp:SqlDataSource>
- <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="528px" AllowPaging="True" AutoGenerateRows="False" DataKeyNames="DocumentID" DataSourceID="sdsCustomer">
- <Fields>
- <asp:BoundField DataField="DocumentID" HeaderText="DocumentID" ReadOnly="True" SortExpression="DocumentID" />
- <asp:BoundField DataField="CustomerName" HeaderText="CustomerName" SortExpression="CustomerName" />
- <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
- <asp:BoundField DataField="Phone2" HeaderText="Phone2" SortExpression="Phone2" />
- <asp:BoundField DataField="Phone3" HeaderText="Phone3" SortExpression="Phone3" />
- <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
- <asp:BoundField DataField="Fax" HeaderText="Fax" SortExpression="Fax" />
- <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
- <asp:BoundField DataField="Representetive" HeaderText="Representetive" SortExpression="Representetive" />
- <asp:BoundField DataField="DomainName" HeaderText="DomainName" SortExpression="DomainName" />
- <asp:BoundField DataField="RenewDate" HeaderText="RenewDate" SortExpression="RenewDate" />
- <asp:BoundField DataField="CompanyActivity" HeaderText="CompanyActivity" SortExpression="CompanyActivity" />
- <asp:BoundField DataField="HowToRecognize" HeaderText="HowToRecognize" SortExpression="HowToRecognize" />
- <asp:TemplateField ShowHeader="False">
- <EditItemTemplate>
- <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"
- Text="Update"></asp:LinkButton>
- <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"
- Text="Cancel"></asp:LinkButton>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Insert"
- Text="Insert"></asp:LinkButton>
- <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"
- Text="Cancel"></asp:LinkButton>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit"
- Text="Edit"></asp:LinkButton>
- <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="New"
- Text="New"></asp:LinkButton>
- <asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" CommandName="Delete"
- Text="Delete"></asp:LinkButton>
- </ItemTemplate>
- </asp:TemplateField>
- </Fields>
- </asp:DetailsView>
Expand|Select|Wrap|Line Numbers
- protected void sdsAllCustomers_Updated(object sender, SqlDataSourceStatusEventArgs e)
- {
- lblErr.Visible = true;
- if (e.Exception != null)
- {
- lblErr.Text = e.Exception.Message;
- e.ExceptionHandled = true;
- }
- else
- {
- lblErr.Text = "Your data have been modified successfuly";
- }
- }
- Any Help Please