Display SQL Results On A Webpage Without Using Data Controls?

Apr 7, 2010

I would like to query a DB and output the results to the webpage. What is the best way to do this while avoiding gridview, etc?

So far I have the following code: (which works)

sqlLookup = "SELECT * FROM locations";
string connectionString = WebConfigurationManager.ConnectionStrings["LocationDatabaseConnectionString"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionString);
myConnection.Open();
SqlCommand myCommand = new SqlCommand(sqlLookup, myConnection);
SqlDataReader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
locationCode = myReader["locationCode"].ToString();
locationName = myReader["locationName"].ToString();
notes = myReader["notes"].ToString();
}

In the past I used to inject HTML into a DIV element via the WHILE loop but this always creates a huge delay when renering the page. Is there a better method?

View 4 Replies


Similar Messages:

Forms Data Controls :: Adding Controls To A Webpage Based On The Results Of A SQL Sproc

May 11, 2010

Depending on the data returned from a Stored Procedure, I need to add specific controls to a page and then when they are populated by the user, write them back to the database. What is the easiest way of doing this?

View 9 Replies

Forms Data Controls :: How To Display Results From Database On A Gridview

Jan 17, 2011

I am using visual studio 2010, asp.net 4.0 (c#)

My problem is:

How do I display results from my database on a gridview based on the selected row of another gridview.

For example, I have a e-shop web app and I have a product categories table in my database displaying the data on a gridview.

I want to be able to click on the select button on each row and use that event to populate another gridview based on the ID of the product category that is clicked. E.g say the 'CDs' row is clicked, another gridview shows all the different CDs.

As a result, I need the select(sql) statement for the second table to be dynamic based on what the user clicks.

Has anyone done anything like this before?

View 2 Replies

Forms Data Controls :: Checkboxlist To Retrieve Data From Database To Display Results In Gridview?

Jun 23, 2010

I have a page where I will insert all the data into the database. The page where I'm having problems is when I select an item from the checkboxlist it only displays one item. The data which is displayed is only the one that was inserted with one selected item from the checkboxlist. The following code is the page I'm using to try to retrieve the data from the database. I am trying to do is when a user selects the first, second, or third, or fourth item. The corresponding data appears in the gridview. In my current code, the record which has one item selected appears. If the user has more than one selected it does not appear. It comes up as empty. Is there a way I can do it?

[Code]....

View 4 Replies

Forms Data Controls :: DataPager Is Not Working To Display The Searching Results?

Jan 20, 2011

I have DataPager and ListView in one page aspx. DataPager is working if I do not search item. DataPager is not working to display the searching reasults. Below is the complete code in one page aspx. I am using VS 2008.

[Code]....

View 1 Replies

Data Controls :: Search Multiple Columns In Database And Display Results

Dec 8, 2012

I want to search record based on  Name, ID, Date, Report Type. from same table with one textbox. I can do search with one column how can do it with multiple column ...

protected void Button2_Click(object sender, EventArgs e)
{
DateTime dt = Convert.ToDateTime(TextBox1.Text);
SqlCommand cmd = new SqlCommand("SELECT * FROM Transactions where report_type = @report_type ");
cmd.Connection = con;

[Code] .....

View 1 Replies

Forms Data Controls :: Paging Datalist - Display The Next Page Of Results Doesn't Do Anything

Feb 9, 2010

I have a datalist and want the results paged I have written a pager.ascx page and have an aspx and aspx.cs page to display the results. I have a stored procedure to pull the data out of the database and a class to talk between the stored procedure and presentation controls I have the pager being displayed when the results get over the limit I have set to 10 in the web.config file but when i click on the next link to display the next page of results it doesn't do anything. my aspx page is

<uc1:Pager ID="topPager" runat="server" Visible="False" />
<asp:DataList ID="newsList" runat="server" CssClass="List" align="center">
<ItemStyle CssClass="ItemList" />
<ItemTemplate>
<h2><%# Eval("Title") %></h2>
<p>Posted <%# Eval("Date") %></p>
<p><%# Eval("News").ToString().Replace("
", "<br />") %></p>
</ItemTemplate>
</asp:DataList>
<uc1:Pager ID="bottomPager" runat="server" Visible="False" />
my aspx.cs page is
protected void Page_Load(object sender, EventArgs e)
{
// Retreive page from the query string
string page = Request.QueryString["Page"];
if (page == null) page = "1";
// How many pages of posts
int howManyPages = 1;
// pager links format
string firstPageUrl = "";
string pagerFormat = "";
//DataAccess.GetNews returns a DataTable object containing news data which is read into datalist
newsList.DataSource = DataAccess.GetNews(page, out howManyPages);
// Bind the data to the data source
newsList.DataBind();
// have the current page as interger
int currentPage = Int32.Parse(page);
// Display pager controls
topPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, false);
bottomPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, true);
}
my pager.ascx page is
<p>
Page
<asp:Label ID="currentPagelabel" runat="server" />
of
<asp:Label ID="howManyPageLabel" runat="server" />
|
<asp:HyperLink ID="previousLink" runat="server">Previous</asp:HyperLink>
<asp:Repeater ID="pagesRepeater" runat="server">
<ItemTemplate>
<asp:HyperLink ID="hyperlink" runat="server" Text='<%# Eval("Page") %>' NavigateUrl='<%# Eval("Url") %>' />
</ItemTemplate>
</asp:Repeater>
<asp:HyperLink ID="nextLink" runat="server">Next</asp:HyperLink>
</p>
my pager.aspx.cs page is
using System;
// Simple struct that represents a (page number, url) association
public struct PageUrl
{
private string page;
private string url;
// Page property definition
public string Page
{
get
{
return page;
}
}
// Url property definition
public string Url
{
get
{
return url;
}
}
// Constructor
public PageUrl(string page, string url)
{
this.page = page;
this.url = url;
}
}
// The pager control
public partial class UserControls_Pager : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
}
// Show the pager
public void Show(int currentPage, int howManyPages, string firstPageUrl, string pageUrlFormat, bool showPages)
{
// Display paging controls
if (howManyPages > 1)
{
// make the pager visable
this.Visible = true;
// Display the current page
currentPagelabel.Text = currentPage.ToString();
howManyPageLabel.Text = howManyPages.ToString();
// Create the Previous link
if (currentPage == 1)
{
previousLink.Enabled = false;
}
else
{
previousLink.NavigateUrl = (currentPage == 2) ? firstPageUrl : String.Format(pageUrlFormat, currentPage - 1);
}
// Create the Next link
if (currentPage == howManyPages)
{
nextLink.Enabled = false;
}
else
{
nextLink.NavigateUrl = String.Format(pageUrlFormat, currentPage + 1);
}
// Create the page links
if (showPages)
{
// The list of pages and their URLs as an array
PageUrl[] pages = new PageUrl[howManyPages];
// Generate (page, url) elements
pages[0] = new PageUrl("1", firstPageUrl);
for (int i = 2; i <= howManyPages; i++)
{
pages[i - 1] = new PageUrl(i.ToString(), String.Format(pageUrlFormat, i));
}
// Do not generate a link for current page
pages[currentPage - 1] = new PageUrl((currentPage).ToString(), "");
// Feed the pages to the repeater
pagesRepeater.DataSource = pages;
pagesRepeater.DataBind();
}
}
}
}
my class file is
// Retreive the list of news posts
public static DataTable GetNews(string pageNumber, out int howManyPages)
{
// Get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// Set the stored procedure name
comm.CommandText = "GetNews";
// create a new parameter for page number
DbParameter param = comm.CreateParameter();
param.ParameterName = "@PageNumber";
param.Value = pageNumber;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter for products per page
param = comm.CreateParameter();
param.ParameterName = "@PostsPerPage";
param.Value = PlatiumMindProductionsConfiguration.PostsPerPage;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@HowManyPosts";
param.Direction = ParameterDirection.Output;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// Execute the stored procedure and saven the results in a DataTable
DataTable table = GenericDataAccess.ExecuteSelectCommand(comm);
// Calculate how many pages of posts and set the out parameter
int howManyPosts = Int32.Parse(comm.Parameters["@HowManyPosts"].Value.ToString());
howManyPages = (int)Math.Ceiling((double)howManyPosts / (double)PlatiumMindProductionsConfiguration.PostsPerPage);
// return the page of posts
return table;
}
my stored procedure is
ALTER PROCEDURE [dbo].[GetNews]
(@PageNumber INT,
@PostsPerPage INT,
@HowManyPosts INT OUTPUT)
AS
-- Declare a new table
DECLARE @News TABLE
(RowNumber INT,
NewsID INT,
Title NVARCHAR(50),
Date DATETIME,
News NVARCHAR(MAX))
-- Populate the table with the complete list
INSERT INTO @News
SELECT ROW_NUMBER() OVER (ORDER BY NewsID desc),
NewsID, Title, Date, News
FROM News
-- return the total number of posts
SELECT @HowManyPosts = COUNT(NewsID) FROM News
-- extract the request page of posts
SELECT NewsID, Title, DATE, News
FROM @News
WHERE RowNumber > (@PageNumber - 1) * @PostsPerPage
AND RowNumber <= @PageNumber * @PostsPerPage

View 1 Replies

Data Controls :: Search Database Using Partial Text And Display Results In GridView?

Mar 23, 2013

I need a query to fetch records from data from database based on partial text entered in textbox like search data from College table based on College Name entered in text box. I want that all record containing that College name displayed in grid view.

View 1 Replies

Forms Data Controls :: Select Row On GridView By Clicking Next Button / Want To Display 3rd Row Results In A Panel

Oct 27, 2010

I have a button called Next outside the GridView. If I click on Next, I want to highlite the 2nd row and display the details of the 2nd row below in panel. If again I click on Nextm i want to highlite 3rd row and want to display 3rd row results in a panel

View 8 Replies

Forms Data Controls :: Gridview: Filter Display Results Based On What Roll A User Belongs

Oct 20, 2010

I have enabled User Rolls and assigned several Roll names such as 10, 11, 12, etc. I have a SQL Table that contains various fields of information including one named AuthorizedUserRoll, it's nchar(2).

A logged in user should only see the records in Gridview that matches his/her roll.

I'm using Web Forms and VB.

View 1 Replies

Forms Data Controls :: How To Display News In Webpage

Feb 25, 2010

I Have a Dropdown which list the names of countries.

when i select a country, the top news related to that country must be displayed in grid.

may i know the RSS feed of every country for this application?

Any API to list all URL for RSS feed?

View 5 Replies

Forms Data Controls :: Display Dynamic Graph On Webpage?

Jan 25, 2011

I have a requirment to draw a graph (Cartesion chart), where the data will be changed 40 to 50 times within hour , i want to refresh data automatically.

Which chart component should i use for drawing graph and how do i make sure that the data will be refreshed very fast on the graph web page.

View 2 Replies

Forms Data Controls :: Using A Button To Display A Gridview Containing Certain Information In A New Webpage?

Jun 1, 2010

I have a button on info.aspx and I would like a situation whenever the button is pressed to display two gridview containing certain information on a new web page called full_info.aspx.

View 5 Replies

Data Controls :: Search In Multiple Tables Using One TextBox And Display Results In Multiple GridView

Jul 22, 2013

I created 3 product  table . A,B and c.

I show product of table in different gridview.  

Now I am using one search box. but how to search product name with image in one query all of three table.... 

Simple how to search product from multiple table and show result...

View 1 Replies

DataSource Controls :: Display All Results In ObjectDataSource?

Oct 23, 2010

I have objectDataSource connected to report viewer.

This datasource have a select method to filter the results by Dep_id parameter

Now if i want to include all results(All Departments) what should i do ???

View 5 Replies

Retrieve Data On Database And Display The Results Assyncronously

Feb 5, 2010

I would like to retrive data on database and display the results assyncronously

I think of using 2 threads : one thread reads data database and another thread displays the data that arrives.

View 5 Replies

Web Forms :: Displaying The Webpage Instead It Is Searching The Results Related To Localhost?

Jan 17, 2011

[URL] - Internet explorer is not displaying the webpage instead it is searching the results related to localhost.

If i browse the virtual directory then the webapplication is working absolutely fine. everything is being configured properly and i also checked the services which are also running.

View 5 Replies

DataSource Controls :: Database Design - Display Results On A Web Page Via The Grid View

Mar 10, 2010

Not sure if this is for SQL or .net! I have 3 tables which looks like

table1
ID Name
1 Jon

and

table2
ID Number Job
1 1 IT
2 1 Web
3 1 Admin

table1
ID ContractType
1 Temp
1 Perm

An inner join makes one table with 3 rows (I excluding the ID from table 2 for the join) which is saved as a view

viewTable
ID Name Number Job ContractType
1 Jon 1 IT Temp
2 Jon 1 Web Temp
3 Jon 1 Admin Temp
4 Jon 1 IT Perm
5 Jon 1 Web Perm
6 Jon 1 Admin Perm

I want to display these results on a web page via the grid view. However, I don't want to show the user 6 times! I want to show the user name once, the contract type once and each Job! What is the best way to do this? Is there a fault with the database design already? I assume the easiest answer is to not join them in a view but query each section 3 times from the website but I'd rather 1 connection only!

View 10 Replies

Databases :: The Webpage Didn't Show Any Results After 5 Minutes Which Normally Takes About 3 Secs?

Feb 9, 2010

am querying an Oracle database thru an ASP.NET web page, but the other day, the webpage didn't show any results after 5 minutes which normally takes about 3 secs. Then, 3 hours after, I got an email from the IT Dept asking me to kill my task which was taking a lot of ressources, but I couldn't since there is no way to send a user cancel request as I can do for instance with SQL Naviguator. So, they had to kill it for me. However, I do't want it to happen again because I don't want to overload the servers because of a query that didn't execute properly.

So, I thought about including connection timeout into my connection string, but there is already a default value. So, is it possible to avoid that kind of situation?My code contains a try {} finally {} to trap errors, but I didn't seem to work in this case.

View 7 Replies

Web Forms :: Display Binary Data In Webpage?

Jul 28, 2010

I need to display binary data (that is stored in the database) in the aspx page. The file types are word and pdf. Since there might be multiple files, what I did was created IFrames dynamically and tried to embed the binary data. The problem is rather than embeding the word doc or pdf doc in the page, it displays the open/save dialog box.

is there any way to solve this (embed the word/pdf doc in the page itself)?

View 3 Replies

Controls :: Display Word Document On Webpage?

Dec 27, 2013

How Can i Show the resume on web page after uploading the resume .......

View 1 Replies

DataSource Controls :: How To Create User Ability To Upload Excel To Sql And Display Results As Table On .aspx Page

Mar 12, 2010

Hardware involved:
SQL Server 2000
Microsoft Server 2003 with IIS6 [code]...

The goal, from internal department (user) perspective:A department wants to "upload" an excel spreadsheet of data (product, term, rate, etc) to SQL (this will be from the internal network). The data is then saved to a webpage location for that department to view and approve. Once "approved," this data is displayed on the live web servers (public-facing website which is two load balancing servers).
Bonus:

The .NET application/SQL Server can send an email to the department reminding them to upload the latest rates (each weekday morning, then each Thursday afternoon) if rates have not yet been "approved."

From the development perspective, this is my general idea, but I may be wrong.There are three spreadsheets, each with one tab. The first spreadsheet is uploaded, and the .NET application puts it in a SQL table. I then need to display this table of data on a .aspx page for the department to approve before the .aspx page is pushed to the live web servers.

First, I need an interface for this department to upload Excel files. I need this application to save the data to SQL and display it in a .aspx page so that the department can look it over and approve it. The department needs a way to "approve" the page, and this action will push the data to the live web servers. Will this involve SQL data transformation services?

View 2 Replies

Databases :: How To Display Data In Columnar Format On Webpage

Feb 17, 2010

I am a new user of ASP.NET 2.0 (VB.NET)

I am facing a problem related to GridView Control

I have a table <UsersDetail> with following structure in MySQL

[Code]....

how i can achieve this using GridView, ASP.NET 2.0, MySql.

View 5 Replies

Custom Server Controls :: Display Image On Webpage?

Feb 23, 2010

I want to display an image on a page with Image control on it.

I know this is very simple but tweak in my case is that image is available as a stream variable (which I am getting as a response from one of the server) instead of physical file.

Eventually I want to create a control for this with some other feature on it.

My question is how to assign "stream" variable to Image control?

View 10 Replies

Controls :: Display Word Document On Webpage - Unable To Find The File Error

Jan 17, 2014

I downloaded the example from the article Display Word Document on web page asp.net

I'm showing the following error when i try to run it

System.Runtime.InteropServices.COMException:Unable to find the file (C:Windowssystem32PROGRAMAS.doc)

And its supposed to be on this line :

applicationclass.Documents.Open(fileName, readOnlyObject, missingType, missingType, missingType, missingType, missingType, missingType, missingType, missingType, isVisible, missingType, missingType, missingType, missingType, missingType)

View 1 Replies







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