Forms Data Controls :: Change Stored Procedure When Dropdown Item Is Selected And Show Repeater?
Jul 9, 2010
I have one repeater on page which has his own sql data source. I've placed 2 dropdown lists on the page. The repeater has jQuery DataTable plugin. With 2 dropdownlist I wish to change the sql stored procedures so when each will be selected the data in repeater will change. When user select the first there will be only data (users) according to selected item and in the second the same. I wrote 2 simple functions for changing stored procedure of repeater and rebiding it. Everything works but when I try the second one and then the first I always get warning about error "Procedure or function .... has too many arguments specified".
I think that when I select the first one the second function is still called although I don't call it.
For every search result I create a dropdown list with 2 month booking overview.
<ddl> <item value = "1"> January - February </item> <item value = "2"> February - March </item>
etc.
Then I call function to generate 2 months calendar view, which has two parameters generate(startmonth as Integer, sku as string)
Everything works when I hardcode starmonth as some integer.
I spent all day with no progress on how to pass value. I need a guide. I guess second problem will be to restore changed dropdown values on Postback, but one step at a time.
But what I want to do, to pass selected item value, to function, that would change view for property associated with this dropdown.
I have three tables: Book, author and Book_Author. The third table make them one to many relation.One book may have more than one authors. Book table has Title column and Author table has AuthorName Column.
I have this query to display BookID, Title, AuthorName where name display in single query separating by comma.
What is the best way to create procedure or view so that I can call this query and display into repeater ??
Girdview has dropdownlist TemplateField called ddlSate, how to bind state field value in sql table to selected value of ddlState dropdownlist control? For example the sql table has AL value for state field, (Note by default ddlState lists all states options with sqldatasource), how AL is selected in ddlState when binding to ddlState?
Secondly, when user selects different state like GA, how below update stored precedure works? that means how to find ddl selected value in update procedure as shown below question mark line:
I'm currently working on a project and I want to make as much things as possible performing on client side - with as little loading as possible. The project consist of three "main" pages. On one page I use jQuery DataTable plugin which is working great. One page has tabs (using jQuery). I want to put datacontrol (repeater) on this site and when user selects one item in dropdown, data in repeater loads on client side, without performing the action on server.
I am trying to populate a dropdown from a stored procedure that includes parameters. The parameters are programmatically defined variables. I have been working at this for hours, and scoured the internet for a tutorial. I have come up with the following solution below. However, it does not work. Its not pulling any data, and I am not even sure that the page is making it into the GetLast5Schedules_Selecting Event. There has to be a more efficient/less time consuming way to do this!
i have a stored procedure with this values and i need just to make a button that will send something to "Equip" column,how to do it? write the values on my webpage and make a button to exec the procedu
i have a dropdown with month names if the user has data for the month tht is selected then gridview displays the rows with day nos as per the month but if the gridview has no data for the same the dropdown or gridview via some event should call a insert procedure to insert data into the table for tht month with daynos ad rebind the gridview witht the rows just created
Initially, I have tried to use stored procedure. But I changed my mind and preferred to call sql query in codebase with command text. However, it stills tries to find initially-called stored procedure (which is neither called or exists).I think that it is related caching. But I tried it with different browsers it did not work.What might be the reason?
I use telerik radgrid, where i add dropdown column for add and edit new grid row.When i update grid row item the dropdown value is not disply in dropdown list, but disply in dropdown first data.
