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 )

View 13 Replies


Similar Messages:

Data Controls :: Display RadioButtonList In GridView With Data Populated From Database

Mar 10, 2013

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.

View 1 Replies

Forms Data Controls :: Display A One Row Gridview When Gridview Is Bound To Empty Dataset

Jan 13, 2010

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

View 5 Replies

Forms Data Controls :: Display A Single Row From Dataset Into Gridview

Jan 21, 2010

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.

View 5 Replies

Forms Data Controls :: Sorting A GridView That Is Populated By An ObjectDataSource?

Mar 11, 2010

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.

View 4 Replies

Forms Data Controls :: How To Search A Record In A Already Populated Gridview

Feb 7, 2011

In a webpage in my project there is one textbox and a gridview.

Gridview is being populated by some parameters coming through Request.QueryString from previous.

When gridview is populated a very huge data appears.

In gridview there is one column:

SR status
1425688 pending
2678549 closed
5342875 transferred

What I want to do that in a textbox user type SR number and the row containing search parameter should be selected only.l

View 11 Replies

Forms Data Controls :: GridView Populated By Object's Instance?

Sep 29, 2010

I have a business class "Repositorio" with methods to create, update and delete objects.

i have a gridview and i need to fill it with the list of objects returned by these methods.

i used like this:

[Code]....

The problem is that i need to select, delete and edit itens, but the grid dont recognize the other methods...

View 2 Replies

Forms Data Controls :: Dynamically Populated Dropdownlist Inside Gridview

Mar 28, 2011

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.

View 11 Replies

Forms Data Controls :: Saving An Excel Populated Gridview Into SQL Server

Feb 14, 2011

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.

View 4 Replies

Forms Data Controls :: See If CheckBox In Populated GridView Is Checked And Compare To SQLDataReader?

May 13, 2010

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()

[code]...

View 2 Replies

ADO.NET :: Working With Dataset And Gridview To Display Data On Web Form?

Jul 26, 2010

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...

View 47 Replies

Forms Data Controls :: Manually Handling Sorting In Gridview Populated By File System?

Jun 21, 2010

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.

View 4 Replies

Forms Data Controls :: Passing Populated Search Values In A Gridview To Another Page Using Querystring Or Sessions

Nov 8, 2010

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...

View 4 Replies

Data Controls :: Scrollable GridView Plugin Not Work For GridView Populated On Button Click

May 7, 2015

URL...but I noticed that if move the bind from page load directly to button the code doesnt works?

<%@ Page Language="vb" AutoEventWireup="true" CodeBehind="WebForm1.aspx.vb" Inherits="_100yWeb.WebForm1" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<script src="Script/jquery-1.4.1.min.js" type="text/javascript"></script>

[code]...

View 1 Replies

Forms Data Controls :: Detailsview Row Update / Creating Dataset, Getting Data From Sql With Adaptor And Filling Into Dataset Object

Dec 21, 2010

I have a detailsview, template as follows:

[Code]....

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.

View 7 Replies

Forms Data Controls :: Use Dataset And Datatable To Bind Data To A Gridview?

Aug 27, 2010

on which all conditions we use dataset and datatable to bind data to a gridview?

View 2 Replies

Forms Data Controls :: Bind Data From DataSet (DataTable) To A Selectrow DropDownList In GridView?

Nov 19, 2010

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

View 3 Replies

Forms Data Controls :: Import Excel Sheet Data Into Dataset Or Gridview And Save To DB?

Mar 2, 2011

i am use this code for read excel file:

[Code]....

how to read special cells in excel and I save to DB.

for example: B4 and C4 is merged with named B4.how to read Data of this cell.

View 4 Replies

Forms Data Controls :: Display Binary Dataset In Repeater With Image Control?

Jul 19, 2010

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?

View 4 Replies

Forms Data Controls :: Display A Dataset From A Web Service In A Grid View Control?

Jan 13, 2010

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?

View 3 Replies

Forms Data Controls :: Hierarchical Data In Gridview From Dataset?

Mar 27, 2010

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)

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
DataSet ds = new DataSet();
ds.Tables.Add(myDataAccess.ExecuteSelectCommand("uspCategories"));
ds.Tables[0].TableName = "tblCategories";
ds.Tables.Add(myDataAccess.ExecuteSelectCommand("uspProducts"));
ds.Tables[1].TableName = "tblProducts";
DataRelation rel = new DataRelation("relation", ds.Tables[0].Columns["CategoryID"], ds.Tables[1].Columns["CategoryID"]);
ds.Relations.Add(rel);
GridView1.DataSource = ds;
GridView1.DataBind();

View 3 Replies

Forms Data Controls :: Insert Data From Gridview To Dataset?

Jan 19, 2010

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

View 10 Replies

Forms Data Controls :: Binding Gridview To Dataset, Field Or Property Not Found On The Selected Data Source?

Apr 9, 2010

[Code]....

[Code]....

[Code]....

View 3 Replies

Forms Data Controls :: DataSet And Looping Through Rows / Display Job Vacancies By The Result Of A DropDownList Value?

Jul 14, 2010

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:

http://kidsunlimited.co.uk/vacancies_test_two.aspx

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:

[Code]....

View 7 Replies

Data Controls :: Rotate Columns To Rows For GridView Populated Using SqlDataSource?

May 7, 2015

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?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved