473,789 Members | 2,799 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Detail view error

57 New Member
hi friend,

I m using asp.net2.0 with c#, I have a form where i have multiview control, and on a multiview control.....i have a combo box, and a detail view. now on the select idex change of combo box i write the below code, where i got error...

ie.
I got This Error msg "Both DataSource and DataSourceID are defined on 'DetailsView3'. Remove one definition"

my code is :-

protected void cboLoanSelect_S electedIndexCha nged(object sender, EventArgs e)
{



string connectionStrin g = ConfigurationMa nager.Connectio nStrings["sqlFWA"].ConnectionStri ng;

SqlDataAdapter ad = new SqlDataAdapter( "Select PropertyLoan_ID ,LendersName,Ac countNumber,BSB ,TermOfLoan,Pay mentDueDayOfMon th,InterestChar gedDayOfMonth,I nterestRate,Loa nAmount,LoanTyp e_ID,DateLoanCo mmenced,LoanEnd Date,LoanPaid,M onthlyPayment,I nvestmentPurpos e,LendersPhoneN umber,LoanNotes from tblPropertyLoan s where PropertyLoan_ID =" + System.Convert. ToInt32(cboLoan Select.Selected Item.Value), connectionStrin g);

DataSet ds = new DataSet();

ad.Fill(ds, "property") ;

DetailsView3.Da taSource = ds;

DetailsView3.Da taBind();

}

thnx
Jul 25 '07 #1
1 1182
kenobewan
4,871 Recognized Expert Specialist
Here is an article that may help:
ASP.NET data binding overview
Jul 25 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
2525
by: Hunters | last post by:
Once you reorder the listview items, largeicon or smallicon view will not follow the order of list or detail view which is the correct order. For example with a listview as lvProdImg.items(0).text="img0" lvProdImg.items(1).text="img1" lvProdImg.items(2).text="img2" lvProdImg.items(3).text="img3" once it is reordered as lvProdImg.items(0).text="img2" lvProdImg.items(1).text="img0" lvProdImg.items(2).text="img1"
3
2042
by: lauren quantrell | last post by:
I have an Access 2000 form that I open showing only the header. The form's detail section visible property is set to false. The detail section contains a subform. Using a command button, I use the code: Me.Detail.Visible = true Me.SubFormName.Form.RecordSource = "sprocXYZ" It returns the following error: "2455 - You have entered an expression that has an invalid reference to the property Form/Report."
1
5773
by: Tom | last post by:
In the Developers Handbook, Getz provides a way to create a survey report that displays either a line, Yes/No or multiple choice for each question. It's done by placing three controls (one for each type of answer) in the report's detail section and then making the control appropriate for each question visible in the Format event of the detail section. Can this be simulated in a form? There's no Detail Format event for a form but can it be...
4
5936
by: 2D Rick | last post by:
In Access2003 and XP. My forms detail section hides behind the header when I scroll down to see controls off screen. This is similar to freezing a pane in Excel. I'd rather this did not happen but can't find the property that controls this. When the form first opens some of the controls are behind the header and scrolling is required to see them. Help, thanks, RICK
3
1880
by: David W. Fenton | last post by:
I ran into a weird problem with a subreport with an OnFormat event of the subreport detail. When I view the field list in report design view, all the aliased fields in the recordsource are available. But when the report runs, the aliased fields are inaccessible. Of course, this is causing a problem with the report running, and I can't figure it out. I've decompiled, I've compacted, I've recreated the recordsource. I've tried moving the...
15
1792
by: Hexman | last post by:
Hello All, How do I limit the number of detail records selected in a Master-Detail set using SQL? I want to select all master records for a date, but only the first 3 records for the details (based on the primary key of the detail record). I've been trying with "TOP 3", but can't get anywhere. Using Access 2000. Something like: SELECT t1.*, TOP 3 t2.*
1
1786
by: teneesh | last post by:
I have designed a form that should display continuous records in the detail. Everytime a user (including myself) click on the view button to view the detail, it does not display until I stretch the form all the way out. What is it in the properties that I need to set to make the form display with lots of space in the detail (even when blank). So when the view button is clicked, my records will come up without a user having to modify the length...
1
1279
by: BillG | last post by:
I am developing a business app using asp.net that will have 2 different types of forms, a list view of data and then a detail view. The list views are placed on a content panel in a master page. The user can then click an Add button or edit button to add or modify an item in the list. My question is what is the best way to handle a detail form? Should the detail form appear in place of the list view in the content panel of the master...
1
1278
by: ramaswamynanda | last post by:
Hello, I have a simple vb.net 2005 application using an SQLserver database There is a form , employees that has a grid view and a detail view control The grid displays data and has a "Select" link as the leftmost column. Clicking on this displays employee details in the detail view. The detail view further has Edit, Delete and New links, that help to maintain data. My problem is this -
0
10408
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10199
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10139
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9983
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9020
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6768
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5417
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5551
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2909
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.