| ODBC.NET Data Provider and RC (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Could anyone tell me whether ODBC.NET Beta1 is compatible with the Visual Studio.NET Release Candidate? tia Gary Lewis |
|
| SQL2000 DATATYPE NTEXT (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, I am having trouble adding html code to the database from a form. I have a datatype of ntext with a length of 16. But is is cutting off my data When I add it to the db the when I retriev it, it is only displaying the first 16 characters. If I put quite a considerable amount of data in the field it says hat is too big. So I was how can I extend The capacity of this field. I a using Server.HtmlE... |
|
| Dataset be used to update the underlying database tables. (6 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, Can a dataset be used to update the underlying database tables if the dataset has been derived from say a Join query or some other multi table query? Stef. |
|
| Custom DataPaging returning x records not all records. (3 replies) |
| ASPFriends.com 'aspngdata' list |
| I've already used this code for paging: http://www.4guysfromrolla.com/webtech/072101 1.2.shtml I need to know what is the fastest way to return 10 records from a SP. I've seen people returning 10 records from a temp table and then selecting it. Is this scalable? Are there any other ways? Samples/examples would be helpful. Thanks in advance, George. |
|
| ASP.NET and MySQL? (7 replies) |
| ASPFriends.com 'aspngdata' list |
| Does anyone have any experience using MySQL as the backend database, with an ASP.NET front end? Cost factors are raising the question of whether it is necessary to go SQL Server in our environment. Obviously MySQL comes at a much more attractive price tag. I would also appreciate any overall arguments pro and con on this question that anyone could offer. I know SQL Server has a native data provide... |
|
| Displaying Exception Error Message (6 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Hi All, I have been hitting the books and FAQ's but can't seem to find this. I am trying to display the actual error message when an exception is thrown. I am doing an update and it occasionally errors for things like duplicate keys, invalid types, etc. I can set trace "true" and see that there is an error, but is there a way to grab what that error is to display it? I am using a VB and a SQL 2000... |
|
| Looking for sql 2000 mailling list -off topic- (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Hey does anyone know of a good list to join for t sql queries? Thanks David |
|
| Creating user control to get data from SQL server used in code-behind (5 replies) |
| ASPFriends.com 'aspngdata' list |
| DotNetJunkies Custom Datagrid Paging Sample and T SQL ProcI am trying componetize my database functions. I'd like to make a method call in the Page Load event in the code behind page passing in the stored proc with any parameters to retrieve the data needed for the page. I'd like the method to get the connection string from either web.config, an application variable or a static variable (having tr... |
|
| DropDownList within a DataGrid (10 replies) |
| ASPFriends.com 'aspngdata' list |
| I'm building a control that contains a DataGrid control which has a Template column which contains a DropDownList. The DropDownList renders fine with it's DataSource, but I would like to add a blank row to the items and select a default item. He is a stripped down code of my control: protected override void OnInit(EventArgs E) { myTemplateColumn new TemplateColumn(); myTemplateColumn.HeaderText "R... |
|
| Object must implement IConvertible (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I have tried everything just cant seem to beat this error I am getting. Could anybody from the group please lead me in the right direction I have included all the code. And the error. ######################################################################## ### Error Message ######################################################################## ###3 Object must implement IConvertible. Message Sys... |
|
| Return One Row of Data (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, How can I return just one row of data from the db? Here is my code it is returning 20 rows I just want one row that is equal to the The variable I pass it. private ArrayList GetContent(String Panel) { SitePages objSitePages new SitePages(); Props objProps new Props(); if(Request.Params["SitePageID"] ! null) { objProps.PageID Int32.Parse(Request.Params["SitePageID"]); } ArrayList ContentPanels ... |
|
| creating/destroying, Dispose(), Close(), and all that... (4 replies) |
| ASPFriends.com 'aspngdata' list |
| How much garbage collection and cleanup is done automatically in .NET? What do I not need to worry about destroying or nulling, when done with it? Some examples... 1 SqlCommand cmd CreateCommand(sp name); 2 SqlDataAdapter da new SqlDataAdapter(); 3 DataSet ds new DataSet(); 4 da.SelectCommand cmd; 5 da.Fill(ds, name table); 6 cmd.Dispose(); 7 da.Dispose(); 8 ds.Dispose(); 9 cmd null; 10 da null; 1... |
|
| Caheing DataSet question (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Any general best practice info I should follow when cahcing a dataset. I have a room.aspx page. I am caching the dataset of items that the user sees whgen coming to their room. However, because each users room is different I have to cache a unique dataset. I am doing something like this: Cache.Insert("room" Session["Id"].ToString(), myDataSet,null,System.Web.Caching.Cache.NoAbsoluteExpiration,Time... |
|
| How do I run through the Hierarchical data inside the DataSet using a loop? (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi guys, This is my code that get's a related tables into the dataset. string sql1 "SELECT OrderID, Ordername from Orders"; string sql2 "SELECT CustomerID, OrderID FROM OrderDetails"; string connStr "Dsn Orders" SqlConnection dataConn new SqlConnection(connStr); dataConn.Open(); DataSet ds new DataSet("OrdersMenu"); SqlDataAdapter dsc new SqlDataAdapter(sql1,dataConn); SqlDataAdapter dsc2 new SqlD... |
|
| DataSet memory size (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Is there a simple way to obtain the memory footprint size of a DataSet? Dan Green [ http://dotnetdan.com putting the dan in .net ] |
|
| DropDownBox not showing in DataGrid (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi All, I haven't been able to figure out why my dropdownbox isn't working in my Datagrid. I am defining it in the Sub Page Load... it is as follows Dim strConnect As String "........." Dim strSQL as string "select distinct name,ID from languages" Dim Conn as New OLEDBConnection(strConnect) Dim Cmd as New OLEDBCommand(strSQL,Conn) Conn.Open() langdropdownbox.DataSource Cmd.ExecuteReader(system.dat... |
|
| Error Passing Nulls to Function (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi All, I have a dropdownbox in a Datagrid using a function to build a dataview. I am also using another function to determine which value is selected by default. The problem is passing the value to be checked into the function. When that value is Null in the DB, it blows up when it hits the function. I am using: SelectedIndex ' %# GetLangIndex(Container.DataItem("Language")) % ' inside of my drop... |
|
| how do u display 2 connections? (4 replies) |
| ASPFriends.com 'aspngdata' list |
| In classic ASP you would do this: while NOT oRs.EOF while NOT oRs2.EOF oRs2.MoveNExt Wend oRs.MoveNExt Wend How would u do such a thing with a Repeater? I need something very fast, dataGrid's are slow (so i've read). Thanks! Join the world s largest e mail service with MSN Hotmail. http://www.hotmail.com |
|
| Asp.net DataGrid (5 replies) |
| ASPFriends.com 'aspngdata' list |
| HI All, I am using the ASP.net Data Grid, to list my records. I have few doubts about using Datagrid 1) While in edit mode, how do you control the users from typing Invalid chars or empty value inside the textbox on the clientside 2) How do I access a template column in Datagrid, for eg for an ordinary datagrid textbox I use NewServiceName CType(e.Item.Cells(1).Controls(0), TextBox).Text() Similar... |
|
| code question (6 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngvs] to [aspngdata] by G. Andrew Duthie (Moderator) graymad@att.net This is a multi part message in MIME format. NextPart 000 003B 01C17756.0883E940 Content Type: text/plain; charset "iso 8859 1" Content Transfer Encoding: quoted printable I don't know if this is the proper forum for this question, and if it isn't I'd appreciate it if someone could point me in the right direction. ... |
|
| Retrieve value from a datagrid. (4 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| How can I retrieve the value of each column for a giving line of a datagrid..? For example: I have a datagrid with two columns: Item Id, and Item Desc; It display 10 detail lines and I select to update the 9th line. So, I want the value of the first column(variable) "Item Id" for the 9th Line. I got the value of the index based in: MyDataGrid.EditItemIndex MyDataGrid.SelectedItem.ItemIndex This va... |
|
| thin data clients (2 replies) |
| ASPFriends.com 'aspngdata' list |
| When doing data access I have seen 2 methodologies, one being assigned the data retrieved from the database to a sqlDataReader and returned that back to the calling code behind page. The second method takes the data from the Db and inserts into a ArrayList, or somekind of 'thin client' which is basically a class with property accessors. What is the advantage of this besides adding extra layers and... |
|
| making data persistant (12 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspserver] to [aspngdata] by Brad Kingsley sbradk@orcsweb.com Hi, Does anybody know how to make data persistant in a dataset or how an intance of an object can me made persistant in business layer ?? cheers Nik Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com |
|
| Connection state checking when closing (4 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| I often see code that looks something like... if( conn ! null && conn.State ConnectionState.Open ) conn.Close() There are other possible connection states, however, such as Connecting, Executing and Fetching, which also imply an open connection that needs to be closed. My assumption is that those states would only be relevant to the above code in a multi threaded scenario. Is that valid? Or should... |
|
| Data Ouput (2 replies) |
| ASPFriends.com 'aspngdata' list |
| This call: %# DataBinder.Eval(Container.DataItem, "name")% can be replaced with: %# Container.DataItem("name") % Returns me a error. CS0118: 'System.Web.UI.WebControls.RepeaterItem.DataItem' denotes a 'property' where a 'method' was expected Source Error: Line 39: /td Line 40: td Line 41: %# Container.DataItem("szSKU") % Line 42: /td Line 43: td ////////////////////// I read that since no formatti... |
|
