I am developing an application using ASP.NET with C#.NET.in my application i have a gridview control and radobutton list having the values as Manufacturer and Distributor. based on the radiobutton selected value,the gridview will bindedup.
i am using SQL SERVER 2005 as backend server. in my database i have one table with columns as
My gridview has 3 columns as Opendate,closedate,awarddate.
if user select the radiobutton as manufacturer,only mfropendate,mfrclosedate,mfrawarddate have to bind. and if user select the distributor the remaining 3 fields will have to bind. for that i had write a storedproc as create procedure sp_GetDraftBids as begin select mfropendate as opendate,mfrclosedate as closedate,mfrawarddate as awarddate, distopendate as opendate,distclosedate closedate,distawarddate awarddate from draftbids end GO
i.e i had taken the alias names for that fields so that i will bind the only 3 columns to grid view as opendate,closedate,awarddate.
My gridview code is
here i had taken the same alias names as i have to bind only 3 columns to gridview.when i run my application i am getting the records in data table with column names as opendate,closedate,awarddate,opendate1,closedate1,awarddate1.i.e it does not allow the same alias name.
for two radio button conditions i.e for manufacturer and distributor the gridview binded with opendate,closedate and awarddate columns as i had binded the gridview boundfields withat names.
but when user select the distributor radiobutton i have to bind the opendate1,closedate1 and awarddate1 to the gridview. for that should i can i change the storedproc are any other solution is there?
I have a gridview to which I am binding a database values. My requirement is to bind the values to the gridview by sorting 3 columns as a default sorting with ASC order in one column and descending order in other two.. Can I do it in my .Net code or should I do that in Stored Procedure? If it can be done in .net code Can you tel me how it can be done.
Is it possible to bind data to specfic columns in Gridview?
I mean, if I send a query to my database and it returns 1 column, then bind that column to the first column in the gridview, then send another query and bind the resulting column from that query to the second column without erasing the data of the first column etc etc.
I have a dropdownlist that's being populated from a SQL datasource. I would also like to have a tooltip for each dropdownlist list item on mouse over. I found the example below which adds a title attribute for each list item using the listitem text as a tooltip but I want to make the title/tooltip value another field in the database. In other words,
I am new to ASP.NET, trying to learn it. I am using ASP.NET 3.5 with VB for scripting. Also read some books. I just can't figure out how to bind a DropDown List inside a Repeater Control. I saw a few examples but none were clear enough and explained all the details. I want to populate the Drop-Down using values from a Database inside the repeater.
I also read this article [URL] but still can't understand how to bind dropdown in a repeater.
I want to display 2 things inside the Repeater Control.
1. User Selected Values (which comes in the form of an Arraylist) from a previous page using "PostBackUrl" method.
2. Then allow users to select values from a Dropdown list corresponding to each design code they selected on previous page. (the dropdown values here must come from a backend db)
Also, I want to control the number or rows displayed inside the repeater control. It should be equal to the number of "design codes" selected by the user on a previous page.
I have an emergency request that I need to sort it out very quickly as I did not notice it early :(.
I have a dropdownlist, the contnet in the gridview (sqldatasource connection) changes based on the value the user slects, say I have play1, play2 from the dropdownlist, I would like to show column1, column2 and column3 with user selects play1; show column4, column5, and clomn6 when use selects play2; the datatable actually includes all 6 columns.
I understand that I need to use something like RowCreated event, and I need to set up condition based on the dropdownlist value, but I dont really know how to.
I'm modifying an existing application. I need to be able to bind the Text property of an asp:DropDownList control to one of two fields when the page is rendered. The existing code is like this:
I've tried to use conditional logic on the .aspx page when setting the Text property, but everything I've tried results in an error. I've also tried using code-behind to set the Tetxt property in the Page_Load event. This doesn't generate an error, but it doesn't set the property either.
I have a Gridview and two link button in that GridView , one link button click is to add edit row ( Edit ), one link button click is to select row ( Select ). I have a dropdownlist inside row which selected when i click link button Select in the gridview edit template, as of my business logic i need to show the dropdownlist only when the user clicks Edit button and when the user clicks Select button . That mean when the user clicks Select button then they clicks Edit button on the gridvview i should allow him to edit the dropdownlist (showing the value to the user through a label).
When I click Select link button , then I click Edit link button . They have errors : Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" I don't know what error?. How to fix it