Databases :: Oracleparameter From A Dropdownlist, No Selection Shows All Records?
Dec 10, 2010
I am trying to find out the best method or practice to use a dropdownlist to feed my oracleparameter value. I currently have this working when I have a value selected in the dropdownlist. My issue is how to account for if the user leaves the dropdownlist empty. I want this to then return all data. My SQL has a where clause = to :HRM. I use a function that gets the text for my SQL from a text file. My dropdownlist box is populated via databind. I then inserted a item in my dropdown with 0 index with no text display and a value of "novalue" Below is my code to populate my dropdownlist
[Code]....
[Code]....
If I select an item and run my code it works great. This doesnt work with the no selection tho. Do I have to build the SQL dynamically with a check if the listbox is empty or not and then add the criteria? I was hoping there was a eailer way since I have many queries and parameters to build.
Here is part of my code using the oracleparameter.
[Code]....
I also saw a post about trying this, but I get an illegal error.
[Code]....
Not sure if I can replace the "AND HRM_FIELD = " text and use :HRM instead and then build the oracleparameter with an IIF to include the AND HRM_FIELD part.
I downloaded the OracleHelper.cs & I use VisualStudio 2008,I'm suppose to pass values to a stored procedure which accepts 2 parametersWhen i pass from codebehind it says,
I have repeater control on page which bind with sql data source.i have dropdown to filter the records of repeater on button click event it refresh complete page i just want to show a wait message to user and just refresh repeater data instead of complete page refresh.i do not want to use ajax update panel.
I have a question about datalist control. See I only need to display 12 records when the users are viewing in a small preview setting. How can I achieve that? I know I can get TOP 12 from the sql query, but is there a way I can modify in the datalist control itself? DataTable dt = new DataTable();
I am getting a DataTable from query against AS400 database. The field that clearly contains birth dates is interpreted as decimal. I am having trouble even converting it to string.
I have written a code from here http://www.aspsnippets.com/Articles/Display-GridView-with-Empty-Message-and-Header-and-Footer-when-no-data-in-ASP.Net.aspx. I just edited this as follows. this is my gridview code:-
and my code file code is as follows SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["contest"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Bind_Grid(); } } protected void Bind_Grid() { string strSql = "select * from mtblInformation"; SqlCommand com = new SqlCommand(strSql,con); SqlDataAdapter sda = new SqlDataAdapter(com); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { gvCustomers.DataSource = dt; gvCustomers.DataBind(); } }
when in database table have records then gridview binds and its showing records, But when there is no record in DB , instead of showing msgs that "No Data found." gridview doesn't appear.
There is a gridview and I am binding some records to it. in my database there are 4 records but gridview always shows 3 records. Even I have given PageSize 10.
I am having two dropdownlist in my project,one dropdownlist for empid, another dropdownlist for month, if the user select the empid, the values are retrieved in the textbox.
In the second dropdownlist, if the user select the month in the dropdownlist it will display the leave details, its all working fine, if the user again select the first dropdownlist that means empid, I want to show the second dropdownlist as select month, how can do this.....
I have a dropdownlist on my page with dates such as 1/1/2013, 2/1/2013, etc.
Then there is a second ddl.
If the date in ddl #1 is before 1/10/2013 I want to enable ddl #2. If the date in ddl #1 is on or after 1/10/2013 I want to either disable ddl #2 or hide it (whichever's easier).
Disabling ddl #2 based on the selected date is a new requirement so I am enhancing the existing code. Obviously I want to do this without a postback, but I don't know what is the best way. I am trying to understand what an AsyncPostBackTrigger is because this is the existing code:
I have 2 dropdownlist, one is to dropdown department, and another dropdown staffnames. the secong dropdownlist will based on the selection of department as each department has different staffs i have 2 tables department and staff in my database , in my department table i have departmentid as PK and departmentname, in my staff table i have staffname and departmentid as FK. So my ques is how am i going to populate staffname in the dropdownlist according to the selection of department.
I have one table which contains branch codes(primary key), Branch name and bank name columns. I have 3 dropdownlist boxes. the first dropdownlist is for the branch codes. When i select the a branch code i need the second dropdownlist box to populate with the appropriate branch name and the third dropdownlist box to populate the bank name at the same time.
Is it possible to have one table like mine and acheive this, if so how do i go about doing this?
I did read up on this but only came across ones with 3 tables.
Well the dropdownlist has an existing items. I just want the selected gridview record to be displayed in the dropdownlist. The dropdownlist has several DataTextField in string and consist of DataValueField in numeric. The gridview passes a string text to the box which has an equal or same item inside the dropdownlist. Whenever i passed a record from a gridview to be viewed in the dropdownlist it just duplicates the same item. Q: How can i simply pass a text inside the dropdown and just simply display it without adding on the list.
sample item on the dropdown: --Select-- Account Savings
after selecting on the gridview and display inside the dropdown: Account Account Savings
(you see the '--Select--' was erase and replace with the selected record)
I have an ASP.net VB Web app I'm working on that has a requirement to provide a list of all our component part numbers to our engineers for selection into a custom Bill of Materials for reworking of an assembly. The list of part numbers is currently generated from a stored proc in our MRP systems/SQL database. The number of records being generated is slightly over 39K part numbers.
Although the SP only takes a few seconds to generate the data the web page is taking a couple of minutes to load, primarily because of the time to fill the control presenting the records to the engineers. I've bound the data to a combobox control to the engineer. They want to be able to type the first few characters of the part number if they know it and have the list filtered or be able to just scroll the data to find the part they are looking for.
I've read elsewhere that they may be a way to only populate a certain quantity of records rather than all 39K then filter based on the users actions. Unfortunately the discussions about doing this didn't provide any examples, references, etc.
My questions are these...
Is there a better way to handle this quantity of records than a stored proc and combobox? A
ny examples of a method to populate a certain number of records then filter based on user action?
I' using ASP.net2.0 and SQL server2005.I have installed AJAX toolkit.
i want to make a search similar to google search ie retrieve from a database a list based on user typing characters and clicking search.
i have used a text box and AJAX autocomplete extender .i have made a connection to DB and able to make a list from a field. But when i select one list elment and click search button it doesn't go into the Search button on click event.Without using autocomplete i'm able retrieve records and display it on data grid view.Do i need to convert the list returned to an array.
Using checkboxes, can the row of record(s) be inserted into a database? I am populating a Gridview. Done. A checkbox field has been added, when the user selects one or more rows, a submit button (which is not working) needs to inserting those records into a table. The insert statment will work outside of the page but is not working using the scenario I jut described. Is this task as I have outlined doable?
I have created a table in my Oracle database and am trying to add / edit / delete/ query the records. This table already has 4000000 records. Now when I try to query the database, it takes close to 3 minuetes to return records. I have tried creating indexes, but was not successfull so far.
Following is the structure:
User : varchar(20) Fac : varchar(10) Prm: varchar(100)
I have Revision column in Quote table with time stamp (MySql table) now i am viewing the entire date and time my end user want to view only Date he doesnot want to see time how can i pull only date.i am displaying revision column in two ways one in grid view and another one in field value
Query in my Grid view
Dim query As String = "SELECT QuoteNumber,Revision,Vendor,PartNumber,status,Customer,Requestor from quotes"
On select check box in grid view, filed values will be loaded with data.
I am using asp.net 2010 with mysql database. Is it practical for large amounts of data ? say 10 million records ? cuz some people said to me that using this combination, i'll be having performance issues as database grows.
