Forms Data Controls :: DataSet Populated But Data Does Not Display In GridView
Aug 23, 2010
I have the following code:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Oracle.DataAccess.Client; // ODP.NET Oracle managed provider
using Oracle.DataAccess.Types;
namespace MyTestApp {
public partial class _Default : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
OracleConnection conn = new OracleConnection("User Id=UID; Password=PWD; Data Source=XE; Pooling=false"); try { conn.Open(); } catch ( OracleException oe ){
Console.WriteLine("ERROR : " + oe.Message); }
if ( !Page.IsPostBack ) {
if (conn.State == ConnectionState.Open) {
// get data GetMoleculesToShow(conn); } }
// clean up connection conn.Dispose(); }
static void GetMoleculesToShow( OracleConnection conn ){
String division; String rxotc; String molecule_name;
String prodnum; String proddesc; String molecule_class; String nonactive;
// create command object and set attributes
OracleCommand cmd = new OracleCommand("schema.package.procedure", conn);
cmd.CommandType = CommandType.StoredProcedure;
//Bind values
cmd.Parameters.Add("mol_to_show_cur", OracleDbType.RefCursor);
cmd.Parameters[0].Direction = ParameterDirection.Output; try {
// Execute command, have parameters populated cmd.ExecuteNonQuery();
// Create OracleDataAdapter, data provider object to populate dataset
OracleDataAdapter da = new OracleDataAdapter(cmd);
//Populate dataset with "molrefcur"
DataSet ds = new DataSet();
da.Fill(ds, "mol_to_show_cur", (OracleRefCursor)(cmd.Parameters["mol_to_show_cur"].Value));
//Verify dataset is begin populated //DataTable dt = ds.Tables[0];
//foreach ( DataRow dr in ds.Tables[0].Rows ) //{
// division = dr["division"].ToString();
// rxotc = dr["rxotc"].ToString();
// molecule_name = dr["molecule_name"].ToString();
// prodnum = dr["prodnum"].ToString();
// proddesc = dr["proddesc"].ToString();
// molecule_class = dr["molecule_class"].ToString();
// nonactive = dr["nonactive"].ToString(); //}
if (ds.Tables[0].Rows.Count != 0) {
// display dataset values GridView gvMolecules = new GridView();
gvMolecules.DataSource = ds.Tables["mol_to_show_cur"].Rows;
gvMolecules.DataBind(); } }
catch (OracleException oe) {
Console.WriteLine("ERROR : " + oe.Message); }
finally { cmd.Dispose(); } } } }
The dataset is being populated, however when the page renders, the data nor the gridview are visible. I have tried using both IE and Firefox, binding / not binding the columns, AutoGenerateColumns Y / N with no success. As I am new to all of this ( VS2008, ASP.NET, C# ) I can't help but to think I am overlooking something basic.
I am using the following :
- VS 2008
- MS Vista SP2
- Oracle XE ( local )
How to generate Radio button list based on data fetched from server in front of gridview,i am facing problem in generating a particular no. of Radio Buttion list as per the data fetched.
Suppose if i fethed 20 records then 20 radio button lists should be generated.
and the values like a or b or c should be submitted in the tables.
If the gridview binds to empty dataset, I need to still show a gridview so that users can ADD more using the textfields in the bottom of the footer template. Since the gridview is empty it won't bind not allowing rendering of the <footer template> I guess I should create a empty dataset if the gridview is empty. How do I check for this and can this be done in GridviewRowEventArgs
I need to know how to display a single row(or particular row)from dataset and display into gridview... i tried by using some codes, like the following, If strCourseLevelId <> "" Then Dim ds2 As DataSet Dim currentbundlenid As Int16 Dim prevbundleid As Int16 = "0" Dim bundlenos As Int16 = "0" Dim bundlecontent As Bundledata = New Bundledata ds2 = bundlecontent.GetBundleData(strCourseLevelId) If ds2.Tables.Count = 1 Then If ds2.Tables(0).Rows.Count > 0 Then With ds2.Tables(0) Dim strCnt As Int16 For strCnt = 0 To .Rows.Count - 1 With .Rows(strCnt) currentbundlenid = .Item("Bundleid") If currentbundlenid <> prevbundleid Then bundlenos = bundlenos + 1 End If If bundlenos = "1" Then GridView1.DataSource = ds2 GridView1.DataBind() ElseIf bundlenos = "2" Then GridView2.DataSource = ds2 GridView2.DataBind() ElseIf bundlenos = "3" Then GridView3.DataSource = ds2 GridView3.DataBind() End If prevbundleid = .Item("Bundleid") 'next write the main page content End With Next End With End If End If.
I am having some difficulty enabling sorting on a gridview that has data in it that has come from an objectdatasource.
The AllowSorting="True" function doesnt work for ObjectDataSource so I need to find a work around...I am guessing that I will need to do something in code in order to get this off the ground.
I have a gridview which contains a templatefield. Inside this is an ImageButton and a dropdownlist. This is all created in the aspx page, although the ddl list items are populated in the RowDataBound event in the vb page. When i change the selected item in the drop down list and hit the imagebutton, the selected item is not maintained after postback. Instead the first record is displayed in the dropdownlist. I have wrapped an If Not Page.IsPostback around the datasource and databind's but this doesn't help. I have tried enabling viewstate in all areas on the page too, but still nothing. The list items for the ddl must be created on RowDataBound also. As far as I am aware, my ddl is not really dynamic, its just the list items which I add in the code behind which are classed as dynamic.
I have a gridview thats being populated from an excel file that is loaded through a fileupload control. I want to save the contents of that gridview to a table in my SQL database. I've searched the web and tried to loop through the gridview, but failed at it.
I'm a little new in ASP.NET, so i don't know how the .NET machine fully works..I'm using two strategies to solve my problem, both invoked by a Button.Click event, but i don't know which one is better..My worries are about the server overload and page load time.This is the regular approuch i've used..
[Code]....
The second one is by using a funtion (named checkIfNumberExistsInDataTable) that does a binary search in a datatable to find a number
conn.Open() Dim dr As SqlDataReader = cmd.ExecuteReader Dim da As New DataTable()
I'm a bit new to VB .NET programming. I was given a project to build a web page for our Shipping department to pull up some order & invoice numbers, based on an order number parameter.
Basically, what I'm trying to do is, when the user enters an order number, I want the web page to display the invoices & invoice dates that are associated with the order number.
I've put together some code already, but not sure it is actually working. The web page comes up in Debugging mode and it acts like it is pulling data from the Oracle database, but nothing shows up in the Gridview (which I bound to the dataset... I think).
[Code]....
Being new to VB, I'm guessing my code may not be totally correct. I've tried lots of things and done tons of searching on Google, but nothing I've tried seems to work. At this point, I'm not even sure if the dataset is being populated correctly or at all either. I'm a bit lost right now and could use some expert thoughts.
In case it helps, my dataset has one data table in it (dtShipData). My dataset class is sdDataSet. I added 3 columns to the data table and the gridview, manually. Not sure if should do that or not. I don't have any SQL behind the datatable itself...
not quite sure where I'm going wrong here. I'm trying to manually handle sorting in a Gridview that is populated with the following data source:
[Code]....
[Code]....
[Code]....
At the moment, nothing is happening when I click on the column headings. I ran it in debugging mode in Visual Studio and put a breakpoint on the Sorting event handler. I noticed that the variable dtSortTable is empty even after the TryCast(VacanciesGV.DataSource, DataTable). If I hover over this statement in debugging, it shows the data from the file system, so it does appear to be reading it.
We do have a search page for customers which returns a list of data from a table.
Once we select on an item it should redirect to another page with customerId as a querystring parameter..
Now the problem is we have to save all the customerIds and need to send them to display page..and need to select next one once they done with previous one without going to the search page again..
Example:
if they got 10 customers in the search page then we need to send all 10 ids to display page by starting display of firstone and once they select next button on display page they have to move on to the next cutomer from that list..if they reached the end of list they have to start again from the first...we need to avoid the user going to the search page for each customer every time...
Codebehind: creating dataset, getting data from sql with adaptor and filling into dataset object, then setting detailsview's datasource. I add 2 button to above template to able to edit data at asp page, and added event handlers:buttons:
[Code]....
My question is, what to do inside the detailsview update event function to able to edit and update data. My method can be wrong too.
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).
ASPX CODE
[Code].... C#
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
i have dataset containing multiple images in binary format,how i can use handler to display those images from dataset which i am having,without needing to pass id in query string to handler each time?
I've been given this existing web service [URL] and I need to use the GetQuoteDataSet method to display the dataset in a Grid View control on my aspx page, anyone got any clue as to how I could do this?
I want to display child rows in the datagrid after the + sign is selected (like grouping & outlining in excel). This is automatic in infragistic grids but when i did in asp (no more infragistics) it doesnt work. here is my code (very simple stuff)
I `m working in aprojct taht read Excel files then insert tables from excel files to dataset then display these tables into Gridview , All these ok with me
The problem here is
How to insert updated data from gridview to dataset again?
I search for it more & more but i didn`t find any thing to do it
I am having a problem with this code, i had a post on this however this code is slightly different to that so i thought i would post a spearate thread.
Anyway, what i am trying to do is display job vacancies by the result of a DropDownList value. Now each job name has a description. The problem i am having is i need to display the results in this logic:
Job nameJob descriptionJob location. But what is happening is the job description (body) is repeating the more vacancies there are. This is the page:
If you select Deputy Nursery Manager from the DropDown and hit the Search button you will see the results. After listing the first two locations the description is repeated and then the 3rd location is shown after this. This is my code:
I have been looking at this article: [URL] However, I have a question: Can't this be used with a sqldatasource, instead of binding the gridview behind? If so, how?