| Dynamic table name (3 replies) |
| ASPFriends.com 'aspngdata' list |
| I have multiple database tables that are basically identical, only one column name differs. A0I'd like to be able to dynamically supply the table name that should be used. A0I don't see a way to do this. Any suggestions? p.s. I'm attempting to do this using Visual Studio .NET Thanks, Dan |
|
| DataBinder.Eval not firing in a function parameter (3 replies) |
| ASPFriends.com 'aspngdata' list |
| A utility function I've written to accept an integer for a dataview RowFilter fails when I pass the parameter like this in the aspx page: asp:DataGrid DataSource ' %# FilterProducts(DataBinder.Eval(Container.DataItem, "CategoryID")) % ' Runat "server" / The code of the utility function is fine. public DataView FilterProducts(int intCatID) { dvProducts.RowFilter "CategoryID " intCatID; return dvPro... |
|
| Equivalent to joins using Dataset (5 replies) |
| ASPFriends.com 'aspngdata' list |
| I've been trying to research an idea I have. I don't think it is possible but I wanted to see if anyone with more experience working with DataSets, DataTables, etc. could confirm my thoughts: I'd like to be able to pull data from a datasource into a single dataset. The dataset would contain multiple DataTables. With this set of related DataTables, I would like to perform the equivalent of a SQL jo... |
|
| How to process insert to database from DataSet Object... (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, I want to make method that will process the object reference DataSet included in the parameter to be Inserted to database. Do I have to process foreach DataRow and then inserting them, or are there any way with more effective process..? public void DataInsert(DataSet myDS) { //inserting code... } Thanks,.. |
|
| Arraylist and Dataset (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngcommunity] to [aspngdata] by Rob Caron robcaron@microsoft.com The following is the raw output which I need to format and store in the database. s a00000000040000 b00012300000000 c000Message Here 0000 a00000000050000 b00023400000000 c000Message 2 Here 0000 e The output will look like this after formating. Value A 40000 Value B 123 Value C Message Here Value A 50000 Value B 234 Valu... |
|
| Command Builder vs. Loop. - (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Copied from [aspngarchitecture] to [aspngdata] by Rob Caron robcaron@microsoft.com Hi, I was just wondering if anyone could point me to an SQL Command Builder snippet. ie. Look at the method below and let me know if this is the most efficient for doing multiple insert statements. I beleive there is a way to build one big command and then send it all at the same time. SqlService sql new SqlService(... |
|
| OleDbConnection and Connection Pooling (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi all. Currently, I'm studying ADO.NET. During my study, I found that ADO.NET support transparent connection pooling with SQL Server. But, with OleDb : To do connection pooling with OleDbConnection You can use the connection string to configure, enable, or disable resource pooling. You can use the registry. You can programmatically configure resource pooling. So, If I want to make connection pool... |
|
| Index Server via OLEDB/ASP.Net permissions (2 replies) |
| ASPFriends.com 'aspngdata' list |
| We have a client who is trying to access an Index Server catalog from ASP.Net using OLE DB but is getting Access Denied. On the same machine he can access the catalog using the "ixsso.query" server object with no errors. Below is the code being used. Has anyone seen this before? Private Function SearchIdx(ByVal SearchAll As String) As DataView 'Connect to the indexing service through OLE DB oConId... |
|
| reader to array (5 replies) |
| ASPFriends.com 'aspngdata' list |
| After executing a stored proc, is it possible to insert the result set into array automagically..or is this a manual process? |
|
| Calling Ora Stored Proc that returns "Table type" variables? (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Does anyone have an example of how to call an Oracle Stored procedure that returns variable of type "TABLE" using ADO.NET? 20 Given the following definitions, how would you call "MyProcedure" and capture the returned information? I have looked around and I haven't seen anything like this posted. Package MYTYPE AS TYPE arrCODE IS TABLE OF tempdb.result1.code%TYPE INDEX BY BINARY INTEGER; TYPE arrDE... |
|
| update relational DB (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hi, another basic question that i just can't seem to find an answer for. I have a record that pulls in from other 4 "many to many" relations and I need to update it. I'm writing a stored proc. that will accept all the changes, (VS won't generate insert/update statment for relational data) and for the mai... |
|
| DataTable and DataSet (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Charles M. Carroll charlesmarkcarroll@yahoo.com How can I add one DataTable to another DataSet. ? |
|
| Wildcards with RowFilter? (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngdatagridrepeaterdatalist] to [aspngdata] by Charles M. Carroll charlesmarkcarroll@yahoo.com I have been working for hours, but begin to suspect that wildcards cant be used with DataView.RowFilter. Is this correct? Regards/H E4lsningar Andr E9 Colbi F6rnsen 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D Sonnenburg Communications Berg... |
|
| Decimal Data Type/Large Identity Columns (4 replies) |
| ASPFriends.com 'aspngdata' list |
| I am just curious about why in the .NET framework the decimal is defined as a 96 bit number. That is 3 bytes. In OLE DB, the DB NUMERIC is defined as 4 bytes and that maps correctly onto the maximum size of the numeric data type in SQL Server 2000. If I need to get a number of an identity that is larger than 2^96 then am I out of luck? This was handled in the COM world with the use of Variants. I ... |
|
| New article on MSDN online: Performance Comparison: Data Access Techniques (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| http://msdn.microsoft.com/library/default.asp?url 3D/library/en us/Dnbda/ h tml/Bdadotnetarch031.asp (watch for URL wrapping) This article discusses the relative performance of DataSets, DataReaders, and XmlReaders for a variety of data access tasks. The benchmarks in the article apply to Beta 2 and SQL Server 2000, but it's probably reasonable to assume that while the raw numbers may chance in RT... |
|
| simple typed dataset generation? (4 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| has anybody out there created a simple application that makes it easy to create typed datasets from sql? I'm thinking of something along the lines of inputing a connection string, a sql statement, hitting go, and getting the code to the typed dataset class. anybody got one? Andy Smith Chief Code Monkey |
|
| looping through a DataTable...code sample? (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I can't find a good code sample demonstrating looping through a DataTable, and copying the rows to the DB. Here's the DataTable: private DataTable Log new DataTable("History"); public DataTable Log { get { return Log; } set { Log value; } } Here's my method for populating the log: public void AddEntry(string DatabaseID) { DataRow tempRow Log.NewRow(); tempRow[1] HttpContext.Current.Session.Session... |
|
| DataTable question... (4 replies) |
| ASPFriends.com 'aspngdata' list |
| What is the most efficient technique to loop through a DataTable and INSERT each row into SQL? I have a DataTable in Application which is basically a log of activity, and every 20 minutes I want to grab it all and dump it into SQL. How do I make it happen every n minutes, and what's the best way to loop through n records, then purge the DataTable so it can start collecting new log entries over aga... |
|
| "value" assigned to datareader? (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi What is the easiest way of doing this: I have a querystring that sends the groupnumber, and a windows login that identifies a person (username). I check in my db (oledb) with a datareader if a person(username) is on a group. If this person is in the group, I will give him edit rights, otherwise not, by sending him to different methods. How can I do this. Now I check if ojDataReader is nothing o... |
|
| Hierarchical data to XML (Data Shaping?) (6 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, I have two tables in a database, one storing content for a website and one for the showing the document hierarchy as illustrated below: Content Table ContentID Primary Key Content Actual Site Content ContentLinks Table ContentID FK of ContentID from Content Table ParentID the ContentID of the Parent Page. I've created a separate table for the parent child relationship because sometimes a child... |
|
| Can ASP.net manipulate Visual Foxpro 3.0 Databases and Tables (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngdatagridrepeaterdatalist] to [aspngdata] by Charles M. Carroll charlesmarkcarroll@yahoo.com Can ASP.net manipulate Visual Foxpro 3.0 Databases and Tables ??? Has anyone got any information on how I can do it ?? CHEERS !! Sum |
|
| UNANSWERED: DataGrid w/multi-key records (6 replies) |
| ASPFriends.com 'aspngdata' list |
| I have seen this question asked in several ways on this list, but never answered. The problem is in using a DataGrid to update a record based on multiple key fields. You need to retrieve the values of two key fields for a selected row. The Problem Is: 1) The Grid.DataKeyField allows for one column to be stored in an array, but not two (that I can tell anyway). 2) If I try to add a hidden column co... |
|
| getting multiple tables back from proc (3 replies) |
| ASPFriends.com 'aspngdata' list |
| hey, I want to get 3 datatables back from my proc something like: create proc select * from a select * from b select * from c I want that back in one dataset holding the 3 datasets? How do I do that? David Everything in this e mail and any attachments relating to the official business of Isonet ZA is proprietary to the company. It is confidential, legally privileged and protected by law. Isonet ZA... |
|
| NOT ANSWERED : Which have the best performance in Data Layer method... (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi,.. I need some advice about encapsulation technique if i want to make data layer method to be consumed for business layer or presentation layer in another class.. In case i have two way (maybe there are another way) to do with : 1. SqlDataReader public SqldataReader myDataLayer (int myParam) { SqlCommand Comm SqlCommand("SELECT * FROM myTable WHERE id " myParam,Conn); Conn.Open(); return Comm.E... |
|
| adding rows to the top of databound listbox (6 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Hi Again! I've got my nice databound listboxes now (thanks to jim, steve, jesse & mark). Now what I would really like to do is add a row to the top of my listbox to signify "Select All". I have added to row to my dataset thus: drowItem dstAreas.Tables( "Areas" ).NewRow() drowItem( "Group Area" ) ".." drowItem( "Part Area" ) ".." dstAreas.Tables( "Areas" ).Rows.Add( drowItem ) But when I bind the d... |
|
