.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

DetailsView + SQLDataSource How to get data from onselected

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :ASP.Net

Hello all,

I have a form using a sqldatasource and detailsview. I have a couple of textboxes outsite of the DetailsView whose text values I would like to set from the SqlDatasource. How can I access this data and set these stray fields? Seems like the Detailsview component consumes the sqldatasource? Also, these two textboxes display (fields) data that is in the datasource but I elected not to display in the detailsview.

In the form load now, I run (Dataview)sqldatasource.select to get at the data for those stray fields now. But then the DetailsView is then running it again, so the database is being hit twice which seems a bit inefficient. :)


I would like to access the data something like text1,text = var[0]["username"].



View Complete Post

More Related Resource Links

How to retrieve data from SqlDataSource and pass to a variable?


Hi there,

I have a page in my website where there is very little code-behind. I only have two lines of code in Page_Load() and the rest of the code is declarative ASP.NET code. I have a FormView control which uses a SqlDataSource to get some order information. The SqlDataSource calls a stored procedure called usp_GetOrderDetails, here's the code for the SqlDataSource:

    <asp:SqlDataSource ID="sdsFormOrderDetails" runat="server" 
ConnectionString="<%$ ConnectionStrings:ForexDB %>"
ProviderName="<%$ ConnectionStrings:ForexDB.ProviderName %>"
SelectCommand="usp_GetOrderDetails" SelectCommandType="StoredProcedure"
UpdateCommand="usp_UpdateOrder" UpdateCommandType="StoredProcedure"
<asp:ControlParameter Name="orderId" ControlID="grdOrders" PropertyName="SelectedDataKey.Value" />
<asp:ControlParameter Name="orderId" ControlID="frmOrderDetails" PropertyName="SelectedValue" />

Passing data from a DetailsView to an Applet

I have a DetailsView that I am trying to use to pass results to an applet's parameter list but I can't figure it out. Example: <asp:DetailsView ID="..."....     <Fields>         <asp:boundfield Datafield="Name".../>         <asp:boundfield Datafield="Name2".../>          ...etc.   <applet codebase="http:/..." ...> param name="Name" value="value of Name from my DetailsView" /> param name="Name2" value="value of Name2 from my DetailsView" /> ...etc. I have been trying all sorts of things and viewing tutorials, etc, but I just don't seem to be able to figure this out.        

insert data in SqlDataSource

hellomy database insertion is working good with normal asp.net page but when it is a content page of master page, stucking me to insert data in database. is there something to change, for to insert data in database even through master page child pages or say from content page.thanks in advance

Problem binding data to DropDownList in DetailsView

Hi guys. I have a slight issue I awas trying to fix for 2-3 days, but nothing I try works. The scenario: DetailsView control in edit mode, I pass parameters to the SqlDataSourceProducts (edit.aspx?id=2) and the data source selects the appropriate data and fills in the DetailsView form. Except two drop down lists. These two DDLs (DDL2 and DDL3) are dependent on the previous DDL (DDL1) in the DetailsView. Thanks to PeteNet, when the selected value of the DDL1 changes, DDL2 and 3 change their lists and get bound to the database. The problem is: when I edit something from the database, DDL2 and 3 appear empty and when I update any other field and leave these, they get blanked in the database.  My goal is to set the selected value of DDL2 and 3 to the values in the database WHERE ID = QueryStringField="id". I can go for not binding the data unless the field is changed, but does not sound professional and user friendly. code: The SqlDataSource used to select the parameters from the table and populate the DetailsView <asp:SqlDataSource ID="SqlDataSourceProduct" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT ID, wm_number, upc, check_digit, unit, price_unit, brand, category, shelves, type, cooking, storage, packaging, origin, nutriti

Find and Set DetailsView Controls In Empty Data Template in Gridview



I would like to find controls in the detailsview control placed in the EmptyData Template of the gridview.   I am trying to create Insert new record for the gridview control.

1. If there are existing records in the table - works fine and sets my two values:
 placed Detailsview and Insert Button in the footer of the gridview.  I needed to set the values of two fields.  When I click on the Insert button it saves new record and sets the field with the value (code attached - works fine).  I also have a popup extender that opens detailsview - this works just fine.

2, If ther are not records in the table - saves record but cannot find and set controls on the detailsview
Same thing setup in the EmptyData Template.  The record is saved but I cannot Find and set the field value on the control.

Here is code:

1.  Link button (on click) in the gridview footer (works fine)

protected void LinkButton1_Click1(object sender, EventArgs e)


        string zupa1;

        zupa1 = ddlSelectEmployee.SelectedValue;





DropDownList in DetailsView Without SQLDataSource


I am trying to use a DropDownList in a DetailsView for the ItemTemplate, InsertItemTemplate, and EditItemTemplate. I must bind this DropDownList to a SQL-Server support table using a function that returns a DataTable. I am not allowed to use a SQLDataSource in my backwards IT department. So, not only do I need to load the DropDownList, I also need to make the SelectedValue equal to the current record that I am viewing, editing. Any ideas how I do this? 

displaying a range of data in detailsview.


hi all , I am an absolute beginner and do not as such write code with any confidence yet.  I am persevering with visual developer express 2010 whilst learning visual basic from hello world stage onward. In the meantime I have a difficulty . I am trying to display a range of data in details view which is being fed a parameter from a dropdown  list. I cannot seem to come up with a query that will pull over all data from a column that is less than a certain number and then display it with distinct values in the dropdown. for example I would like say to pull over height data where it displays all data below  20m all data below 30m etc. is this possible without heavy coding? 

Pls help to post the code to get data from sqldatasource into a list


I have this code but dunno how to get the data from the existing sqldatasource1 into the list. Pls help to post the code. 

ie the code for this line:        ' Get Data from Database and Fill DataReader and we will pass values to List

The sqldatasource1 returns only one field of data called holiday which is a date field. Thanks


<%@ Page Title="" Language="VB" MasterPageFile="~/00_MasterPage.master" %>

<script runat="server">

    Private Function GetPublicHolidays() As List(Of DateTime)

        Dim list As New List(Of DateTime)()

        ' Get Data from Database and Fill DataReader and we will pass values to List

    End Function


    <asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>

How to change this code to get data from sqldatasource control instead of a list


I have googled a relevant code for my control on ASP.net page but it get data from a har code list. How to modify the code so it get the data from the sqldatasource which I have already built instead of getting data from the list?


protected void calDT_DayRender(object sender, DayRenderEventArgs e)


        if (dtholidays.Contains(e.Day.Date))


            e.Day.IsSelectable = false;




private List<DateTime> GetPublicHolidays()


        List<DateTime> list = new List<DateTime>(); 

        //populate from database or other sources

        list.Add(new DateTime(2010, 01, 01));

        list.Add(new DateTime(2010, 02, 02));

        list.Add(new DateTime(2010, 02, 14));

        list.Add(new DateTime(2010, 03, 02));


Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Master-Detail with the GridView, DetailsView and jQuery's ThickBox

One more article about grids from Matt Berseth. This time he shows how to create master-detail with the gridview, detailsview and jQuery's ThickBox. He writes:
So I thought I would check some of this out and along the way rebuild my Master-Detail with the GridView, DetailView and ModalPopup Controls and replace the ModalPopup with jQuery's ThickBox. I found it pretty interesting - read on to see how it went

Displaying Data using ASP.NET 2.0 Repeater and C#

This tutorial will show you how to display data using the .NET Repeater Control, ASP.NET 2.0 and C#.NET

The Repeater control is a powerful tool and is easy to use.

First, you will need to import the System.Data.SqlClient namespace.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend