| RecordCount in ADO.NET (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi! All, In ADO we use the RecordCount property of Recordset Object, what is the alternate of RecordCount in DataReader Object? Regards Mudassir Cell: 0300 9274871 Office: 5800861/2 Web: http://www.magsnet.net Email: mmudassir@mags.net.pk |
|
| Stored Proc Structure (9 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngcs] to [aspngdata] by Devin devinr@drone interactive.com Does anyone know how in ADO.Net to get the structure of a stored procedure. I would like to be able to get the parameters and there datatypes dynamically. |
|
| Not clear on InferXmlSchema method... (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I'm not clear on how the InferXmlSchema method of the DataSet object works. My WROX beta 2 book says the following: "Uses a schema provided in a TextReader, XmlReader, or Stream object, or in a specified disk file, to infer the structure of the data in the DataSet." The .NET SDK (both beta 2 and final) say this: "Infers the XML schema from the specified TextReader or file into the DataSet." They t... |
|
| Binding to a custom data object. (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, I've created an object that retrieves data from a database. The data is stored internally as a DataSet. Externally, the object implements IEnumerator and IEnumerable. I can bind the contents of my object (called 'SiteSet') to a DataGrid e.g. protected void Page Init(object o, EventArgs e){ SiteSet c 3D new SiteSet(); dg1.DataSource 3Dc; dg1.DataBind(); } With this code, the DataGrid shows the ... |
|
| Shuffle a DataSet (31 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Anybody have some code to randomize the contents of a table in a dataset? Thanks, Steve |
|
| trying to resolve a issue (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Is ADO 2.7 ADO.NET if not what is the difference ?? Thanks for your input Gene |
|
| SV: TextBox binding problem (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, I want bind the data to a textbox. But if I use the following code ASP:TextBox id 3D"txtName" Size 3D "60" Text 3D' %# Container.DataItem("Name") % ' runat 3D "server" / where name is the database field name But same code will work if I use it as in itemtemplate for an datagrid what should I do to bind the data to a textbox??? If you know the solution then kindly reply back Regards Sachin 20 |
|
| SV: Re: SV: TextBox binding problem (4 replies) |
| ASPFriends.com 'aspngdata' list |
| In that case you can do something like this: /////////////////// EXAMPLE //////////////////////////// Script Runat 3D"server" 'DATABIND ON PAGE LOAD Sub Page Load DataBind() End Sub 'WRITE A FUNCTION TO GET THE VALUE YOU WANT TO DISPLAY IN A TEXTBOX Function GetValue() As String '//CODE TO GET YOUR VALUE 09 End Function /script !DOCTYPE HTML PUBLIC " //W3C//DTD HTML 4.01 Transitional//EN" html hea... |
|
| SV: Column Identity (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Here is an excerpt from the Vs.Net help files: ///////////////// Snip //////////////////////////////////////// A database table commonly has a column, or group of columns, that uniquely identifies each row in the table. This identifying column or group of columns is called the primary key. When you identify a single DataColumn as the PrimaryKey for a DataTable, the table automatically sets the All... |
|
| Still a .NET SQLParameter Bug (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| I ran across this issue in BETA 2 and it appears it is still not fixed. If I create a SQL parameter like this in the constructor. Dim paramRetVal As New SqlParameter("RETURN VALUE", SqlDbType.BigInt, 8, ParameterDirection.ReturnValue) cmd.Parameters.Add(paramRetVal) The ParameterDirection does not get correctly.. It stays as ParameterDirection.Input However if I set the direction outside the const... |
|
| .NET Data Access Application Block (2 replies) |
| ASPFriends.com 'aspngdata' list |
| How does the .NET Data Access Application Block fit into your understanding of ADO.NET. Do you expect books that mention ADO programming to cover this set of classes? Is this technology key to your use of ADO.NET? Thanks. j Jesse Liberty Liberty Associates, Inc. .NET Training & Development http://www.LibertyAssociates.com |
|
| How to populate an XSD file (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi all, I'm working on a crystal report and I need to populate an xsd file. I've got code that goes and get's the data already and creates a dataset. I just want to copy the contents of the one dataset into the contents of the xsd file. How would I do this TIA Scott |
|
| Managed Provider for Oracle (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| http://www.microsoft.com/downloads/release.asp?ReleaseID 37805 |
|
| Sorting Dataset (4 replies) |
| ASPFriends.com 'aspngdata' list |
| hi, can i sort the table of a dataset, without using dataview and use to this sorted table in some processing. Please suggest. Thanks in advance. Satish Pahade |
|
| columns of a dataTable (4 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| hi all, I have a function that is getting passed a DataTable. Speed is of the utmost importance. What is the most efficient way of finding the column names of a DataTable? Thanks, dave |
|
| Update fails (9 replies) |
| ASPFriends.com 'aspngdata' list |
| Can somebody please tell me why the following code fails to update the database, but doesn't produce an error? I have stared at in and tried many things, but it doesn't work. I added trace statements (not added here) to see if it gets executed and it does. All params are fine, ID values match... what am I missing? void DataGrid Update(Object sender, DataGridCommandEventArgs e){ string GroepId ((Te... |
|
| recordcount (4 replies) |
| ASPFriends.com 'aspngdata' list |
| How to get the recordcout from a dataset which is populated from a database? Regards Sachin |
|
| Data relations (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi there I'm trying to create a relation between two tables in a DataSet both of which have been loaded using the ReadXML method. I want to create a relation between the 'pages' table and the 'category' table based on a category id but the DataSet.Relations.Add() Method fails because the category id values are not unique in the pages table (there could be several pages in the same category) . Obvi... |
|
| Will I need two versions of code for different databases? (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hi, I am developing software in ASP.NET which will be available in two versions, one for SQL Server, and one for MS Access. Now will I have to have two coding versions because of this? i.e all my code that works with Access will use the OleDBConnection commands, and all code for SQL Server version will u... |
|
| Parameter binding (2 replies) |
| ASPFriends.com 'aspngdata' list |
| To bind params I use the following code in asp. How to do the same in asp .net? I do cal stored proc in aspx. Hope the syntax is close to it. Any hlp? SQL "Select reg no from sw users where user code ?" Set cmd Server.CreateObject("ADODB.Command") cmd.ActiveConnection Conn Set Param cmd.Parameters Param.Append cmd.CreateParameter("user code", 200, 1, 10, UCase(NTUserName)) cmd.CommandType 1 'adCmd... |
|
| Oracle DB Connection Time (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Mitch Denny mitch.denny@warbyte.com I have two same ASP.Net applications, one use the Oracle Database and another one use the SQL Database. The two DBs have same schema. But somehow, the connection time to Oracle is much longer than SQL. The time to get the connection between Oracle and and ASP.Net web page is about 30 seconds. Does anyone experience ... |
|
| SV: Parameter binding (5 replies) |
| ASPFriends.com 'aspngdata' list |
| This is an example of how to use parameters in Asp.Net: Dim conCmm As SqlConnection New SqlConnection( strConn ) Dim dtrLang As SqlDataReader 'This is referrring to a stored proc. called GetLangs Dim cmdSelect New SqlCommand( "GetLangs", conCMM ) 'This states that I am using a stored proc cmdSelect.CommandType CommandType.StoredProcedure 'Add the necessary parameters in this fashion cmdSelect.Para... |
|
| Dataset or Datatable? (15 replies) |
| ASPFriends.com 'aspngdata' list |
| Which is faster a dataset or a datatable? |
|
| Commandbuilder questions (4 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| I have always preferred to execute straight SQL for adding, updating and deleting records in database, but am now being steered in the direction of using commandbuilder object. Whilst I wait for Amazon to deliver a detailed book on the subject I was wondering if someone here could answer some questions on it. 1. When using the commandbuilder, do I still need to worry about delimiting the single qu... |
|
| usage of SQL stored procedures (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngdatagridrepeaterdatalist] to [aspngdata] by Yannick Smits dotnet@stepcompany.com Hi All Should I only use store procedures for common searches, queries and things like custom paging ??? For dynamic generated SQL statements (for custom searches by selective criteria), should I just run them as statements or as store procedures ?? Is there any difference in performance ?? CHEERS !! ... |
|
