A ListBox is being filled from the database, from a SQLDataSource. Im setting the parameters in its _Selecting event. Except when it is done getting its new Data, the ListBox isn't updated with this new data. Eventhough i rebind my ListBox to the DataSource.
View 3 RepliesI'm trying to auto-populate a listbox of zip codes from a database table state_zipcode_plans based on the state a user selects from the previous listbox. I'm getting the error: Must declare the scalar variable @state_code.
[code]....
There are quite a few questions around this topic,but I can't seem to get it figured out.I'm trying to bind a listbox to an ObservableCollection and keep the listbox updated when items are added to the collection.
[code]...
Beyond this, I have a simple textbox and button on a page.When a name is entered into the textbox,and the button is clickedI call the addBlog(passing in name from textbox) sub routine in the ITRSBlogs Class (back up the page a bit) to add the item to the collection.Problem is,when I add an item to the collection,the listbox is not updated.I'm new to Observable Collections (and many other things : ),so maybe I'm just really off here.
I do have a listbox control and a button to update values of the list box with few other values of the form to the database. If i select 3 values in the listbox, it has to update the database in 3 rows (Unique for Listbox value) with the other value being the same. I use a details value for inserting values.
View 5 RepliesI have a webpage with multiple updatepanels on. One of the panels takes a long time to load. I therefore start a timer on page load and the timer.tick event populates the accordion control within the panel. Because of the amount of data I have used a paged data source and have link buttons to scroll through the results.
I need to implement animation, both on the initial page load and each time the button is clicked to move through the pages. The animation is, show a loading icon and hide the accordion/grid, once the data is loaded, display the accordion/grid and hide the loading icon. I have tried both the PageRequestManager and AnimationExtender, which I fail to get working for both the initial page load and Updating/Updated events.
I have a webservice - called MyCompany.WebService1
I reference this using a web reference in my ASP.net web application.
Theres a method called "GetDeal" in this web service, that returns a "Deal" Object.
The deal object currently looks (for example) like this:
[code]....
This class is in a different assembly: MyCompany.Model
The web service references this assembly.
In my web app, I can call the GetDeal method. This returns Service1.Deal (service1 is just the name of the web reference)
I can access both properties above. I have now changed the Deal class, and added a couple more properties.
However, I can't see these new properties in my web application. I've updated the web service in the web application. I rebuilt the web service several times, tried removing the MyCompany.Model reference and re-addding it etc...
I can't figure out what has changed... This was working - I have changed the model before, and it's updated the reference correctly...
I have dataset which is called at page load event. Also every time i clicked on refresh it will call refresh function where it store updated values from database.
Now I want only updated fields row and want to store into datatable or another dataset.
I dont want to cmp each and every iteration of the dataset. I used Getchanges() of dataset but not working.
I have a Iqueryable problem
<%= Article.Replies.OrderBy(r => r.Created).First().Member.Username %>
I want to get the most recent Replies that is part of the Article
"Article.Replies" gets all the replies
So now I want to Order by Replies.Created by descending And then just take the first one from which i can get the members username fine. Im having a syntax problem with doing the orderby descending and by picking the first.
i have a vb.net application that contains and MDF file that holds 2 tables, when i execute an SQL update command it executes fine and the data are updated only in cache, so when i clean my solution the updated data disappears ( database gets back to its original state ) and does not actullay commit in the tables.
View 4 Replieshave detailsview
<asp:DetailsView
ID="dtlviewRecommendation" DataSourceID="LinqDataSourceRecommendation"
DataKeyNames="PK_TT_RecommendationsSysId">
[code]...
We have a SQL agent job tied to an SSIS package that process does an Update process on the dimensions and a full process on the Facts. In the morning the cube is showing that it is processed but the new data is not present. When it is manually run the SSIS package, it seems to work fine. Basically there is job having two steps, one is to update the BI Cube and next step is to update dimensions and facts. This jobs runs perfectly without any error, but first step executes as per the expectation and second fails to update with latest data. If we try to manually run the SSIS Package of the second step it perfectly updates with the latest data.
View 2 RepliesI have a web page with a gridview & formview (master/detail relationship) combo. On page load the gridview shows all records from a SQL table. On my page I have a button that when clicked shows the formview in Insert mode to allow users to add a new record to the data. I have also added a column to my gridview that has a link. When a user clicks this link it hides the gridview and shows the formview in edit mode with the detail from the record selected from the gridview.
In my formview I am using a listbox control to allow users to select multiple values. The choices in the listbox are populated by a SQL data table. I have successfully written code to post the selected listbox values to my SQL data field during Insert. When the user selects a record to edit I have code in the databound event to select values in the listbox from the choices based on the value in the sql data field. This works as well. My problem is that I cannot figure out the correct code to update my SqL data when a user is editing the record and makes changes to the selected listbox value. I have included my design code for my listbox in my formview edittemplate and also my behind code that I have attempted.
<td
style="width: 454px">
<asp:ListBox
ID="lbox_ConstructionType"
runat="server"
DataSourceID="SqlDataConstructionTypes"
DataTextField="Construction_Type"
DataValueField="Construction_Type"
SelectionMode="Multiple"
Width="144px"></asp:ListBox>
<asp:TextBox
ID="tbox_Ctype"
runat="server"
Text='<%# Bind("ConstructionTypeID") %>'></asp:TextBox></td>
[Code]....
Is there a way I can automatically update a 'Date' column in my database table to the current date whenever any cell in that record is updated?I've started looking into table triggers a little bit and I'm wondering whether I can do it using this?
View 1 RepliesI am having a table named Invoices.From that table I want everything the newly inserted and updated rows from that table.
View 3 Replieshere is my code for selectiong some records from db table
string strSql = "select * from mtblNBD where SentTo=@SentTo and InternalStatus Is NULL order by DeadLine desc";
SqlCommand com = new SqlCommand(strSql, con);
com.Parameters.Add("@SentTo", SqlDbType.NVarChar, 50).Value = (string)Session["uname"];
here I am using parameters for SenTo field but not for NULL so it is ok... or should I use parameters for this field where value is NULL , if yes then how can I use parameter for this
I am currently working with a large query of client name, and instead of using a dropdownlist, I have done the follow:
I setup a Textbox for the user to enter some text, and then click the search button. Using a modalpopupextender (AJAX), and panel appears showing a listbox displaying clients that are like the text entered. The user then picks one, hits ok, and the value is returned to the text box.
Currently, the listbox is not displaying anything. Here is what I have:
[Code]....
I have a listbox in my view:
@Html.ListBoxFor(m => Model.Runtimes, new SelectList(Model.Runtimes, "Id", "Runtime"))and when I access the page all the runtimes in the model are displayed as expected. I also have a button in my view with a jQuery function attached to it: btnIntermediate.click(function () { timer.addIntermediate(function (runtime) { url = "/Timer/SaveRuntime/?runtime=" + runtime; $.get(url); }); });It saves the runtimes to the model. My problem is how to update my Listbox with the new entry in the model without triggering a postback(since it will stop my timer)?I'm
I have a DB in which looks like this:
Game
WinningID (FK)
LoosingID (FK)
Score
Player
ID (PK)
Name
Rank
Country
My Game Table contains score of Players wins against each other. So WinnindID (Player1) Vs. LoosingID (Player2) has a score of 4.
That being said. I am creating a web page in which I have to show the score. I populated ListBoxes with the Player Names and have two labels to show the score.
Label 1: Showing Player1 as opponent and won.
Label 2: Showing Player2 as opponent and won.
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
I'm trying (poorly I might add) to set up a select statement and due to my noobishness I simply have not found a way to do it RIGHT. Then again - I'm probably starting entirely wrong - but I've gotta' learn somewhere.I'm attempting to track product usage (think mild inventory tracking). In the system, I have independent parts and builds (combination of independent parts) - each has its own SQL table. Each time a "build" is completed, I want to update my part inventory with an updated count of that item.
Build_tbl
Build_ID (int/spec)B_nameB_desc
Part_tbl
Part_id (int/spec)P_nameP_cost
Build_asmb_tbl
[code]...
I am trying a programming example, which I saw in a book, in an attempt to learn ASP.NET and figure out how to pass parameters to a simple query. Here is my HTML:
[Code]....
The page loads but the ListBox does not fill. As a consequence, or maybe as an aside, the button click_event does absolutely nothing. Here is my VB:
[Code]....
I need to populate a listbox with queries from 2 sql tables, but I can only see how to populate it with 1 datasource.
Do I need to do some hand coding? If so, where should I put it?
I'd also like to add some text items to the listbox so I could say populate the listbox with a query, plus an "other" option, so that if "other" is selected, a textbox will appear that will let the user specify a new item.
I need a program that lets me enter the name of an item to swap and adds it to an array list when a button Add is pressed.
Once the item is added to the array list a sub procedure should be called which displays the contents of the array list in a list box.
The system will also allow me to remove items from the array list and then the list box is updated.
I am looking for a way to groupby a listbox. I get some of my listitems from the database with this linq query:
[Code]....
But i tried to make it here groupby but cant seem to get it work. It must groupby for : product.Vendor
Here is the listbox code:
[Code]....
If anyone know the answer for this i would be very happy. Also here is screenshot for what i want to do:
The "Wrong" part is what i get now, but i want it like the "Good" part.
[Code]....
Updating the database using ado.net