ASPFriends.com 'aspngdata' list Archive - October 2001
Messages
Page: 1234
Edit multiple rows of a dataset and save changes all at once (3 replies)
ASPFriends.com 'aspngdata' list
Hi, Was hoping this would be addressed in the "Programming Data Driven Web Applications with ASP.NET" book and it kinda is, but I'm still not very happy with the options. In several spots in my applications, I have a situation where I have multiple related rows where only 1 or 2 columns are going to need to be edited. I'll give you one example, song titles for a CD. I was hoping there was going to...
make hyperlink in datagrid from part of string (3 replies)
ASPFriends.com 'aspngdata' list
I have some but not all product desriptions looking like this: X LINCAT EB3 MK1 WATER BOILER 68E500 basically the X means the item is obsolete, in some cases a replacement is available. the 68E500 points to the replacement part number. What would be really helpfull is if i could make this to a hyperlink. I'm doing this in the onitemdatabound. So far I have this which first concanates two descripti...
DB2 access (5 replies)
ASPFriends.com 'aspngdata' list
Does anyone know of a solution to access a DB2 database on a mainframe from an ASP.NET application? Is a "special" driver needed or is it built into .NET? Any information on this would be much appreciated. Sean ************************* Sean Bytnar MCSE, MCP I Illinois State University Technology Specialist Campus Box 2202 Normal, IL 61790 v 309 438 7355 f 309 438 7761 sdbytna@ilstu.edu
Difference between SQLConnection and OLEDBConnection (3 replies, VIP)
ASPFriends.com 'aspngdata' list
Moved from [aspngcommunity] to [aspngdata] by darthcarroll@asplists.com Hi, What is the difference between using SQLConnection and OLEDBConnection..? Thanks Somu
DroopDownList Selection (2 replies)
ASPFriends.com 'aspngdata' list
I am trying to select an entry of a datalist right after binding the datasource. I am trying to use "mnGroup.SelectedItem.Value mGroupId", but that does not seem to work. Thanks, Chris Love President Extreme Web Works www.extremewebworks.com
Datawarehousing Class in ADO.NET (4 replies)
ASPFriends.com 'aspngdata' list
Hi! Fellows, Do we have any kind of Date Warehousing Class in ADO.NET? Take Care, Mudassir "There is only a hairline difference between Love & Friendship "
SqlDbType.TEXT datatype as OUTPUT paramater (3 replies, VIP)
ASPFriends.com 'aspngdata' list
Hi All, I've spent the afternoon understanding that using a SqldbType.TEXT isn't available to be used as an OUTPUT parameter. Below is the code, if i choose the sqldbtype.varchar the page works. According to the doc's, the varchar or nvarchar is only good for 4000 characters. After 4000 you have to explicitly declare the # of characters. What SqlDBType would be most recommend when dealing with TEX...
FormatNumber in ItemTemplate (3 replies)
ASPFriends.com 'aspngdata' list
Moved from [aspngbeta] to [aspngdata] by darthcarroll@asplists.com This is a multi part message in MIME format. NextPart 000 002C 01C139E6.F7C18240 Content Type: text/plain; charset "iso 8859 1" Content Transfer Encoding: 7bit I have a bound repeater where I need to format the field using FormatNumber function to display 10 as 10.00 TD Class tdValueRt %#Container.DataItem("price")% /td works fine ...
DataSet In Memory (5 replies)
ASPFriends.com 'aspngdata' list
I need a little DataSet clarification, Going through a tutorial book I keep reading that you should be very careful about how much data you load into a DataSet via the Datagrid. Every time a sample code is shown, the DataSet is rebuilt when the first instance of the page is instantiated via IsPostBack property. If the records are loaded into memory and carried each re request of the same page (dat...
Text/checked property of a control (4 replies)
ASPFriends.com 'aspngdata' list
Moved from [aspngbeta] to [aspngdata] by darthcarroll@asplists.com This is a multi part message in MIME format. NextPart 000 00DA 01C13AA0.2E542790 Content Type: text/plain; charset "iso 8859 1" Content Transfer Encoding: 7bit When I try to access the text/checked property of a control in a repeater/datalist, I get the following error. I'm using Beta 2. What is the correct syntax? Compiler Error M...
Inserting records using DataAdapter.Update (3 replies)
ASPFriends.com 'aspngdata' list
Is there a way to return the value of an identity field when a new record has been inserted using the Update method of the DataAdapter? thanks, Ray
ItemIndex of repeater ctrl (4 replies)
ASPFriends.com 'aspngdata' list
I want to get the itemindex of a repeater control to get another control in the repeater with the same itemindex. I tried the following sample code & got an error. How to get itemindex? Compiler Error Message: BC30456: The name 'ItemIndex' is not a member of 'System.Web.UI.WebControls.Repeater'. Source Error: Line 44: End Sub Line 45: Public Sub txtRetailQty TextChanged(Sender As Object, E As Even...
Question about templates and DataGrid (2 replies, VIP)
ASPFriends.com 'aspngdata' list
Hello !!! I know I can customize the DataGrid using the labels EditTemplate , ItemTemplate , etc. In some situations, I would like to include HTML labels in this template. By means of EditTemplate , etc. it is easier to make this task. My question is how I can do to obtain the same result using the properties of the grid control?? Thanks in advance!!! Erich B&#FC;hler.
Question About DataGrids (4 replies)
ASPFriends.com 'aspngdata' list
I am trying to display data in a datagrid. I would like to be able to display that data by creating a datagrid within another datagrid; is that possible? If so, could anyone tell me where to get an idea of how to do that. I am currently able to display the data just fine in a single datagrid. Regards, Aaron Monroe Software Engineer Unisys
FormatNumber (4 replies)
ASPFriends.com 'aspngdata' list
I display numerical values in as %#Container.DataItem("price")% This displays numbers without decimal part like 50 30 100 I'm not able to use FormatNumber function to display the valuses as 50.00 30.00 100.00 Is there an alternative? Regards, S.Malathi, IT Project Analyst ADNOC Distribution, IT Division P.O. 4188 Abu Dhabi, U.A.E. Tel : 971 2 6959480 Fax : 971 2 6742265
Retrieving DataGrid DataSource - Aaron Monroe on the scent? (3 replies, VIP)
ASPFriends.com 'aspngdata' list
Does anyone know how to get hold of the original DataSource of a DataGrid/DataList etc so that functions such as Paging and sorting can be done without having to re create the datasource. Imagine for example that if the Request is a PostBack function you could do the following. DataView dv myDataGrid.DataSource; dv.Sort "Name"; myDataGrid.DataSource dv; myDataGrid.DataBind(); What I really want is...
Values in Cookies (4 replies)
ASPFriends.com 'aspngdata' list
cookies are stored as Response.Cookies("cookie").values("Sts") &# l;stSts.SelectedIndex & retrieved using lstSts.SelectedIndex &# c;int(request.cookies("cookie").values("Sts")) Values are lost if I surf to some other URL on the same instance of the browser & come back to my application. Where am I going wrong? Regards, S.Malathi, IT Project Analyst ADNOC Distribution, IT Division P.O. 4188 Abu Dha...
DataGrid And EnableViewState (4 replies)
ASPFriends.com 'aspngdata' list
Hi all, Can someone explain me why when I put EnableViewState to False to the DataGrid Control, the DataGrid doesn't display the record ? In the MyDataGrid Edit event we Bind the DataGrid to the source so why we don't see the records? /quickstart/aspplus/samples/webforms/data/VB/datagrid6.aspx Any workaround ?! cause the hidden field " VIEWSTATE" is very large and its seen to be not scalable for a...
Option buttons in datagrid (2 replies, VIP)
ASPFriends.com 'aspngdata' list
well, i have an option button inside a datagrid's cells, i am not able to have it as an "option group".i am able to select more than one choice. which doesnt go with my business logic. the first column of the entire datagrid will have options buttons . and i should be able to select only one at a time. is that possible? venkat Original Message From: "Saurabh Nandu" saurabhn@mastercsharp.com To: "a...
Join (6 replies, VIP)
ASPFriends.com 'aspngdata' list
I usually don't have problems with SQL queries but it seems to be something wrong with this one: SELECT DISTINCT P.ID,P.*,I.* FROM P JOIN I ON P.ID I.ID PROP The error is System.Data.SqlClient.SqlException: The text, ntext, or image data type cannot be selected as DISTINCT It seems that there's a text field inside P that generates this error. What I don't understand is that the DISTINCT should onl...
Populating a Checkbox Datalist (3 replies)
ASPFriends.com 'aspngdata' list
I have a Checkbox Datalist that I would like to populate based off a couple of tables in the following situation. I have a table of available Content that a user can subscribe from that is Bound into a CheckBox Datalist, when the user selects desired content, an association is made in a UserContentAssociation table where I capture the UserID and the Content ID. This process works fine for register...
simple query (6 replies)
ASPFriends.com 'aspngdata' list
Moved from [aspsqlhowto] to [aspngdata] by darthcarroll@asplists.com a bit of simple question, but if I have a dataset with several tables from a database, you don't have to necessarily display it. I want to pick and choose bits of information and display it in different parts of the page. This is assuming that I have only one record row. i.e. I have used an sql statement to extract information re...
Misc Editable Grid Questions (4 replies, VIP)
ASPFriends.com 'aspngdata' list
I am in the process of creating an editable grid. The grid is quite wide, and I have put some buttons on the page to do the horizontal scrolling for me. My original intent was to allow the user to make all the changes they want, and commit them in 1 step. I was originally hoping that invisible columns still persisted through viewstate, but no such luck. This would have been the preferred (easy) me...
OnEditCommand in a Web User Control (2 replies, VIP)
ASPFriends.com 'aspngdata' list
Moved from [aspngcommunity] to [aspngdata] by darthcarroll@asplists.com This is a multi part message in MIME format. NextPart 000 032B 01C022A8.E78F6B40 Content Type: text/plain; charset "iso 8859 1" Content Transfer Encoding: quoted printable Hello, I am having trouble editing a DataList that is a Web User Contol bound to a database. If I place the code into a Web Form it works perfectly. Can any...
When deleting from DataGrid.... (4 replies)
ASPFriends.com 'aspngdata' list
Has anyone figured out how to show a confirm message when deleting a row from a datagrid? I know how to do this from a normal page linkbutton. But in a grid, the actual control ID changes for each row. Thanks, Alan
Ad
Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification