| SqlDataReader problem (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngcs] to [aspngdata] by Charles Carroll darthcarroll@asplists.com Hi, I have this problem. I dont know how to get data out of the SqlDataReader. There are many methods to get data out of it, but they want index of the column... how do i know which index should i use? Or does anyone know how to get each value out of the sqlreader? Thanks Lukas |
|
| Nested Datalists Not Possible? (7 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, I want to put a datalist inside another datalist... why doesn't it work? does anyone know a work around... I would try datagrid but i need edit item template in each one |
|
| I am trying to build a cache for caching all records ? (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I am trying to build a cache for caching all records and even groups of records that would not be alter for even a day... even though there could be other querys that would not be cached. I would like to know how to cache the Select ALL records. I put together this code..what major mistakes have I made??? SQLStatement.Text "select * from dwKnowledgeBase "; SqlConnection myConnection new SqlConnect... |
|
| Updating a DataSet (2 replies) |
| ASPFriends.com 'aspngdata' list |
| How would I update a record in a dataset while looping through it? myConnection New SqlConnection( "server localhost;uid ;pwd ;database " ) myDataAdapter New SqlDataAdapter( "Select * From Que", myConnection ) myDataSet New DataSet() myDataAdapter.Fill( myDataSet, "MessageQue" ) For each myRow in myDataSet.Tables( "MyTable" ).Rows Response.Write( myRow( "Status" ) ) Next I want to be able to updat... |
|
| A problem that's come back. Please help I cannot see where i have made a mistake.....wirh .Stored Procedure ? (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| A problem that's come back. Please help I cannot see where i have made a mistake...... I can update if I drop the Solution updated (remove the hidden1 var and solution from the procedure and it works) this thing worked once I don't know what I did to undo it. increase to 100000 char? varchar? I have change size type ??? CREATE PROCEDURE dwUpdateknowledbase @id INT, @problem VARCHAR(100), @hidden1 ... |
|
| SQL Server 7.0 Timing Out (6 replies) |
| ASPFriends.com 'aspngdata' list |
| This is the second thread I have started on this issue this week. I got some good advice that may have helped but it is still happening. I have a site that uses a nested datalist inside another datalist. I am using the technique used in the IBUYSpy Portal discussion list. The major difference is that I am nesting the list in the regular item, not the selected item. What I am finding is multiple da... |
|
| databinding/event question (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| I have this DataList: asp:DataList id "bottomTOC" runat "server" ItemTemplate asp:LinkButton id "toclink" runat "server" OnCommand "toclink Command" cssclass "CommandButton" MaintainState "false" CommandArgument ' %# DataBinder.Eval(Container.DataItem, "page id") % ' %# DataBinder.Eval(Container.DataItem, "page title") % /asp:LinkButton /ItemTemplate FooterTemplate asp:HyperLink id "full link" run... |
|
| Query against a Dataset in ADO.NET (6 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi All, I would like to know whether a SQL query could be executed to retrieve results from a ADO.NET Dataset? The scenario is, I get a dataset back from a database query. I would like to add some tables dynamical to the dataset apart from the tables that resulted from the query. Then I would like to run some query to extract results against the tables (tables resulted from the query and the table... |
|
| DataRow.Delete() (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Hey all, Just wondering if I've run into another bug. Take these two examples, (ds is a DataSet with a single DataTable): ds.Tables[0].Rows[0].Delete(); vs. DataRow delRow ds.Tables[0].Rows[0]; ds.Tables[0].Rows.Remove(delRow); Should these not do the same thing? The first line seems to work intermittently, but sometimes throws a "Row not accessible" exception, or something along those lines. Than... |
|
| DataGrid(s) Problem (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Copied from [aspngcs] to [aspngdata] by Charles M. Carroll darthcarroll@asplists.com This is a multi part message in MIME format. NextPart 000 00FA 01C165EE.94D826A0 Content Type: text/plain; charset "iso 8859 1" Content Transfer Encoding: quoted printable hi, I am trying to have an DataGrid with in a DataGrid, by using the TemplateColumn. I am having the following code: .ASPX Page 3D 3D 3D 3D 3D ... |
|
| DataRow Runtime Exception on FieldName (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| I am having a problem in VB.net using a field name in a string variable for a datarow item name. The design is that the field name to check the datarow against is in another table. In debug mode in VS 7 I get a Runtime exception on the following line: Error Line If CheckRow(CheckFieldName) 3D GlRuleReader.Item("MatchValue") Then End Error Line Specifically the error is for CheckRow(CheckFieldName)... |
|
| Webform Controls - Formatting String (7 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngvs] to [aspngdata] by Charles M. Carroll darthcarroll@asplists.com Hi, I have a column in a datagrid, which is bound to a character field. It stores the Phone # as 1234567890 (without any formatting characters). How do I display this phone number in (123) 456 7890 format? I am using DataBinder.Eval( ) method to display it on the form. Thank you. Jayesh Patel Senior Developer Go Am... |
|
| Binding class object arrays to datagrids (7 replies) |
| ASPFriends.com 'aspngdata' list |
| How do I bind an array of object classes to a data grid? For example, I have a class called myClass, which has properties name, address, city. I put a group of these object into and array so now I have myClass[n].name, etc... Can I bind this array to a datagrid so that it displays the properties of the classes? Thanks! Devin |
|
| How to return XML using webservice, (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, I have written a Web Method which returns is Supposed to return an XML string, but it formats the string with < and >, unusable by the parser, Is there any easy way of returning XML string thru web methods. ?xml version "1.0" encoding "utf 8"? string xmlns "http://tempuri.org/" <METHODS><element type "XML" desc "return an XML" access "private" /><element type "RECORDSET" d... |
|
| ODBC DataAdapters (16 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi all, It was mentioned at Dev Days that the ODBC support for DataAdapters might be released with the RTM version, although they seemed rather non committal on that point. Does anyone have any firm information on this? Also, I was wondering if I could get some help with a situation involving cross platform data access. We have legacy data on an AS/400 and we have our website information on SQL 20... |
|
| Connection Error, Maybe OT (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I am trying to connect to an Advantage Database Server through System.Data.ODBC and I get the following error. I hope this isn't too OT. ERROR [HY000] [Extended Systems][Advantage SQL][ASA] Error 7200: AQE Error: State HY000; NativeError 5004; [Extended Systems][Advantage SQL][ASA] Error 5004: Either ACE could not find the specified file, or you do not have sufficient rights to access the file. Th... |
|
| DataGrid Paging Error (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I have the following page that implements a DataGrid with paging but when I go to click one of the numbered pages, it generates the following error. Am I implementing the DataGrid wrong? Thanks, Jim Davis Error AllowCustomPaging must be true and VirtualItemCount must be set for a DataGrid with ID myDataGrid when AllowPaging is set to true and the selected datasource does not implement ICollection.... |
|
| DataGrid - DropDown Population (3 replies) |
| ASPFriends.com 'aspngdata' list |
| I am trying to incorporate a ASP:Dropdown list into a DataGrid and want to populate the SelectedItem with info from my database (DataSet). I am doing this currently with bound columns like so: asp:BoundColumn HeaderText "First Name" DataField "FirstName" / asp:BoundColumn HeaderText "Last Name" DataField "LastName" / And my drop down menu as: ASP:TemplateColumn HeaderTemplate Employment Status /He... |
|
| dropdownlist (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngcs] to [aspngdata] by Charles M. Carroll darthcarroll@asplists.com I'm having a difficult time trying to figure out how to get a value key pair in a drop down list. for example in html i usually display the customer name to user, but track user selection with a customerID select name customer option value "customerID" customer /option /select but in the asp.net drop down control, ... |
|
| Feeding an array of parameters to a stored procedures (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi I have an array of stored procedure parameters, each of which I want to loop through and add to a SQLCommand object. Back in ASP, I was able to do this without a problem, and then execute the command: 1: For i 0 To Ubound(arrParam) 2: objCommand.Parameters.Item(i).Value arrParam(i) 3: Next However, it appears that ADO.NET requires that you provide the names of each parameter you want to add, in... |
|
| CheckBox within a datagrid (9 replies) |
| ASPFriends.com 'aspngdata' list |
| folks, I am trying to get a checkbox to populate within a datagrid and am having some difficulty. I have a bit data type in SQL Server that I want to map to this checkbox, but after reading the quickstart, I am not sure I am using the right syntax. I am building this in VS beta 2, here is the code for the checkbox: relevant code from code behind file Dim strConn As String 3D ConfigurationSettings.... |
|
| Multiple selection from Checkbox list control (6 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi All I am trying to get multiple selections from a checkboxlist control to be used as a parameter in a SQL Stored procedure. I am using the "in" sql statement . This works with one selection, but with multiple selections I get no result. Please help!! Thanking you in advance. Regards Sean Sean Bergsma Futuristix Wonderware Cellular: 27 82 859 9318 Main/Fax: 27 31 765 3453 URL: www.futuristix.co.... |
|
| One Datagrid for Multiple resultsets (11 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Hello, I want to populate my Dataset with the results of a stored procedure which returns several tables. I don't know how to fill my dataset with the content of the second, third, ... table??? Can you append the tables together? I would like one DataGrid to display the data from several tables. ' run stored procedure which returns multiple tables. Dim DS As New DataSet() myCommand.Fill(DS) Dim i ... |
|
| SqlDataReader (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| 'System.Data.SqlClient.SqlDataReader' does not contain a definition for 'Item' Does anyone know why I would receive the above error? VS.NET help tells me that Item is the indexer for a SqlDataReader object but I can't compile when I use it. My code where the error occurs is the following: Response.BinaryWrite(dr.Item["ImageData"]); Thanks, Sean ************************* Sean Bytnar MCSE, MCP I Ill... |
|
| Sending relational DataSets via web service (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Can anyone point me to a good tutorial on sending Datasets that contain relational data across the wire using Web Services. I have tried, but my XML never gets generated like I am expecting it too. Thanks Devin |
|
