Forms Data Controls :: Reading And Paging From Datasource?
May 16, 2010
I have a form with several controls. I'm trying to read from database and navigating through single record per page. I'm displaying a single record but not navigating through. My customerID field is the primarykey. But there are gaps btw records (1,2,5,6,10...etc). Some of them were deleted.
myPage.aspx:
<%@ Page Language="VB" Debug="true" CodeFile="customer.aspx.vb" Inherits="customer" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title></title>
<head runat="server">
</head>
<body>
<form id="form1" runat="server">
Customer ID: <asp:Label ID="lblCustomerID" runat="server" ></asp:Label> <br />
Customer Name : <asp:Label ID="lblCustomerName" runat="server" ></asp:Label><br />
<asp:Button ID="btnPrev" runat="server" Text="Prev" OnClick="Prev_OnClick"/>
<asp:Button ID="btnNext" runat="server" Text="Next" OnClick="Next_OnClick"/>
</form>
</body>
</html>
code-behind:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim myReader As SqlDataReader
Dim myConnection = New SqlConnection("server=myPCSQLEXPRESS; database=CustomersDB; uid=myPC est; Password=; Trusted_Connection=yes")
myConnection.Open()
Dim myCommand = New SqlCommand("SELECT * FROM Customers", myConnection)
Dim intFirstRecord As Integer = CInt(myCommand.ExecuteScalar())
myReader = myCommand.ExecuteReader()
If myReader.Read Then
lblCustomerID.Text = myReader("customerID")
lblCustomerName.Text = myReader("CustomerName")
End If
myReader.Close()
myConnection.Close()
currentRecord = lblCustomerID.Text
End Sub
Sub Next_OnClick(ByVal sender As Object, ByVal e As System.EventArgs)
Dim myCommand As SqlCommand
Dim myConnection As SqlConnection
Dim myReader As SqlDataReader
myConnection = New SqlConnection("server=myPCSQLEXPRESS; database=CustomersDB; uid=myPC est; Password=; Trusted_Connection=yes")
myConnection.Open()
myCommand = New SqlCommand("SELECT TOP 1 customerID, CustomerName FROM Customers WHERE customerID > @customerID", myConnection)
myCommand.Parameters.Add("@customerID", SqlDbType.Int, 5).Value = currentRecord
myReader = myCommand.ExecuteReader()
If myReader.Read Then
lblCustomerID.Text = myReader("customerID")
lblCustomerName.Text = myReader("CustomerName")
End If
myReader.Close()
myConnection.Close()
End Sub
I'm being able to read first record. If I click Next button, my page goes to next record for only once. If i click several times, nothing happens. Does not go to next available records.
View 8 Replies
Similar Messages:
Feb 19, 2010
What is the process for allowing paging in a gridview on a page where the user submits information in order to fill the gridview?
The gridview is being fill without a datasource but instead with a datatable.
[Code]....
View 7 Replies
Jan 14, 2011
I am trying to sort and page a dataset/table.
Problem: it will sort and paging correctly but when after change a page, it will not display the corrected sorted order.
Protected Sub PFTGridView_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs) Handles PFTGridView.PageIndexChanging
Dim PFTObj As New PFT
Dim PFTDST As New Data.DataSet
[Code]....
View 4 Replies
Feb 26, 2010
I don't know how to read data into variables from a SELECT query. I can add, update, and delete queries with no issues. I have browsed a few books, but everyone uses a different approach. Suppose I want to to run a query and 1 record is returned. How do I get the values into my variables.
Suppose my table name is "Job Orders", and the row returned has these 3 fields:
JobNumber, FirstName, Lastname
[Code]....
[Code]....
this is where I go blank ?
"I learn by doing, not by reading"
View 1 Replies
Oct 6, 2010
I have a need to add a new report to my page, the differnent parts of the page are all using a objectdatasource to populate the data. The new report because of all the data being returned i have started to use a repeater and a table in the ItemTemplate. Just binding the objectdatasource to the repeater works fine, but returns all the records and causes the page to be very long. I found this link for adding paging to repeater, but its setup different than what i have
[URL]
Is there any way to use what i have already and add paging to the repeater?
[Code]....
View 3 Replies
Aug 17, 2010
so instead of a datasource control, I have a Data Access class that I'm using to populate the ListviewI added a datapager and everything pretty much works until I hit the first or last button. Then, I get the following error: Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/>Also, Something was mentioned about ClientScriptManager.RegisterForEventValidation - - couldnt' really find an implementationI tried setting:EnableEventValidation="false", but then, all I got was squirelly interaction with all the numbered links (sometimes having to double click them, etc) - no matter what I tried from there on out, even when I removed the enableEventValidation property altogether.
View 7 Replies
Oct 19, 2010
I have a 1.5 GB file into a table. I want to read It from server and create a file stream with it for save.
When I use DataAdapter.Fill(DataSet); code OutOfMemoryException occurs.
What should I do for read a hage file from data base?
View 8 Replies
Jan 20, 2010
I'm using asp.net 3.5 inc#.
How can I read the data from a stored procedure in Sql Server into a datatable using a datareader.
View 4 Replies
Nov 18, 2010
Is there a way to use the GridView paging and having the links not use JavaScript. So that when you click on the page number 5 (for example) that link is a hyperlink.
View 3 Replies
Feb 9, 2011
I'd like to implement a custom paging template for my formview that displays numeric paging as well as next/previous buttons. The pre-defined templates only appear to have numeric first last as an option. Can anyone recommend a good article that covers this?
View 2 Replies
May 16, 2010
I would like to check my database for to see if a user name is available but my script isn't working.
I am taking input from a text box call unametextbox and i'm trying to extract any matching username from the database, this is my code.
[Code]....
View 8 Replies
Apr 27, 2010
I have a C#/Asp.net web application which caches SQL DB schema information. Is there a way that I can determine what child relationships a given table has? I have looked into using the DataTable.ChildRelations property, but it is never populated with items unless i manually create a relationship using the .add property. I also have access to DataColumn information for each column in the database.
View 4 Replies
Sep 22, 2010
I'm trying to store multiple selected checkboxes from a single checkboxlist, but i don't know where to start. Imagine i have three tables: tbl_events, tbl_organisors and tbl_settings and i want to store the organisors of an event. Each event can have multiple organisors, so each organisor should be added as a single row into tbl_settings. I know how to bind tbl_organisors to a checkboxlist, but how do i store the results (meaning: add the rows to tbl_settings) ?
tbl_events: Event_ID (PK) and Event_Name
tbl_organisors: User_ID and user_name.
tbl_settings: Settings_ID (PK), Event_ID and User_ID
Checkboxlist:
[Code]....
SQLDatasource:
[Code]....
Initially all checkboxes will be unchecked, but users must be able to select multiple organisors from the checkboxlist and then store them into the DB by submitting a form. So the query will look something like: INSERT INTO tbl_settings (user_id, event_id) VALUES (@user_id, @event_id). And this is where my head cracks
1) How do i loop through all selected checkboxes and store each value (user_id) in a new row in tbl_settings?
2) After saving, the users reloads the page and the organisors he just selected must be selected by default in the checkboxlist. How?
View 2 Replies
Mar 2, 2010
The short story is, I'm developing an SSIS package to select from a remote Oracle database (read: no Windows Authentication) and store into an SQL Server db. I can execute the package just fine in development and after importing, but when I run it as a scheduled job, I get an ora-01017 error (bad un/pw). The details are, I built this package and tested in in BIDS but came across the problem that BIDS really doesn't save the password I'd set for the Oracle connection. After poking around a bit, I found this
[URL] which showed how to create an XML configuration which the package could then read. Fiddled around with that, got it working in BIDS. Connected to Integration Services on the server on which I want to run the package, imported it, right-clicked and did the "Run Package" option as a test, it works great. However, when I connect to the same server's Database Engine to create and schedule a job, I cannot connect to Oracle. For some reason, it seems as if the package is not reading the configuration when run in schedule.
I've tried removing the job and re-working it, thinking maybe it didn't pick up the new version when I re-imported the package. A new job had the same problem. Next, I tried re-naming the .dtsConfig and doing the "Run Package" option as a test. Failed with the same error. A bit surprised, I thought I'd get some kind of file error and we wouldn't get as far as trying to talk to Oracle. Anyway, thinking maybe it's permissions on the configuration, fixed the .dtsConfig name and gave full access to Everyone. That ought to let the Agent see it. Scheduled up the job, still can't talk to Oracle. So it seems as if the scheduled version is ignoring the configuration. Anyone have any idea what I'm missing, that scheduling an SSIS package makes it act differently than running it manually? BTW, the instance under which we're running the package is VS 2005. BIDS 2005 to build the package.
View 3 Replies
May 10, 2010
I'm able to upload and read any excel file to my server prior 2007, when I try an 07 Excel file, i'm getting the following error message:
'microsoft.ace.oledb.12.0' provider is not registered on the local machine'
do I need anything specail on the web server to allow for Excel 07 files? I'm running IIS6 and a Win 2003 server
View 1 Replies
Mar 16, 2010
iam Working on Asp.net Web apliation using c#.net, in system folder (Ex: E://Santhu) i have few Flat files and Excels Files .So My Application should read those files automatically and should store the data into my database..
View 1 Replies
Sep 23, 2010
I'm Using a DataReader to Read about 100,000 records, my code look like :
[Code]....
I have a per row computation in reading the rows on GetMyType2Info() method, and this method also another method that I return only one record by ExecuteReader(). the problem is that when the MyTypeList (List<T>) has about 21,000 Items of MyType (<T>) System.OutOfMemoryException is thrown. wanted to know how to resolve this and wanted to know more about the maximum size of List<T> capacity. in addition the execution of the main Query with 100,000 records take about 4 seconds in SQLServer a record has only types of nvarchar , float,datetime and int
View 1 Replies
Jun 4, 2010
I have a record created date stored as" 2010-05-16 15:44:18.700" in sql server database. When I read this date it gets converted to "5/16/2010 3:44:18 PM" . How should I read it so that I don't loose the ending '700' value so that it gets written exactly to another database.Code for reading the record:
String myConn = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString();
SqlConnection con = new SqlConnection(myConn);
SqlCommand cmd = new SqlCommand();[code].....
View 12 Replies
Apr 21, 2010
I'm trying to read a CSV file into a DataTable using OleDbConnection and OleDbDataAdapter. It works loading the DataTable, but only does 255 columns. The file has 362 columns.
Code is as follows -
[Code]....
I have a schema.ini too -
[Code]....
View 6 Replies
Mar 26, 2010
I have to create PDF Files reading data from SQL Server where the data is in Binary format as Image data type.
View 2 Replies
Mar 16, 2010
iam Working on Asp.net Web apliation using c#.net. in system folder (Ex: E://Santhu) i have few Flat files and Excels Files .So My Application should read those files automatically and should store the data into my database..
View 1 Replies
Mar 25, 2011
I fill a GridView from a ObjectDataSource that points to a Typed DataSet.
I need to read a couple of row columns from the object data source that IS NOT part of the Gridview.
So far, I have found out that ObjectDataSource.ObjectDataSource_Selected is the right event to do this.
Examples on the internet refers to e.OutputParameters, but that appears to be empy even though rows are returned.
e.ReturnValue seem to contain a type related to the row type, but I cannot interpret this either.
View 1 Replies
Jun 28, 2010
Both the Method 1 and Method 2 can handle the paging of GridView, could you tell me how about the performance of the Method 1?and how much will Method 1 slower than Method 2
#region ForPaging
public static List<HD_ToDoList> Get_ToDoListByUserNameForPage(string username, int StartIndex, int PageSize)
{
[code]...
View 3 Replies
Feb 1, 2010
i've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
View 1 Replies
Jun 11, 2010
I want to have a paging mechanism. Its a bit hard to show all data and tables for this query but this is the current resulset.
As you can see Id has several duplicate entries (EventId as well but thats as its supposed to be):
Rownum EventID Id UserId
1 22 10 03088B17-36B2-425C-BD08-13E63AF07254
2 22 10 03088B17-36B2-425C-BD08-13E63AF07254
3 22 11 39E49E5A-7A42-43B6-882C-B22EE4C0922A
4 22 11 39E49E5A-7A42-43B6-882C-B22EE4C0922A
5 22 12 15C405BB-BD9A-4C6A-BF21-A95763FAD613
6 22 12 15C405BB-BD9A-4C6A-BF21-A95763FAD613
7 22 13 15C405BB-BD9A-4C6A-BF21-A95763FAD613
8 22 13 15C405BB-BD9A-4C6A-BF21-A95763FAD613
9 22 15 00000000-0000-0000-0000-000000000000
10 22 15 00000000-0000-0000-0000-000000000000
Now, I want to have paging and I'm doing that like this:
[code]...
In thew above query, when I leave out seltion of the RowNum column (so instead having: "SELECT distinct eventid,id,userid FROM") only 3 records are shown when I have a maximum pagesize of 5 passed to the @maximumRows variable.
What can I do to have exactly 5 records shown?
View 6 Replies
