| Value returned is 0 (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi all, I have the following function to add a new User to the Db and return the value of the UserID of the just added record. In my SPROC I have Set @UserID @@Identity. The following code adds a new record but returns the value of the UserID as 0. I cant seem to figure out whats goign wrong. Please Help me Regards Srini public function AddUser(ObjUser as UserDetails)as Integer dim intID as intege... |
|
| excel.cells (7 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngstart] to [aspngdata] by Dana Coffey denigma@bellsouth.net hi all i found the info for how to export data to excel...there is a function called "cells" which will take the row number and column number...but my problem is i want to put a header "Resistance" which should wrap for 12 columns...what should i pass for columns...please help me... thanks siri Do You Yahoo!? Yahoo! Health... |
|
| DataTable.DefaultView Implications (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I noticed that every table in a DataSet has a DataView(DefaultView) associated to it. Anyone know of any implications of using it like a normal DataView? Seems that as long as I reset the RowFilter property I can save some code by using that instead of creating a new DataView on each page. Thanks, Joe Modjeski Systems Administrator CommSpeed |
|
| Move data from a SQL database to another (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi all, I have 2 tables with the same structure in 2 database. I need to copy the entire data from the first tabel to the second. How can i perform this task easily with ADO.NET? Thnaks |
|
| Collection vs. DataTable (8 replies) |
| ASPFriends.com 'aspngdata' list |
| Hello all, I am facing an difficult problem. We need to do an Synchronization functionality on our site, that the user sends a MSProject file, and then we Import them into the Database reflecting the changes made. At my technical approach, I have chosen to use Collections, and each element of this Collection is an Structure that has the fields we want to work. The big deal right now, is that I nee... |
|
| Configuration Reference (7 replies) |
| ASPFriends.com 'aspngdata' list |
| Hello list, I am getting stumped on retrieving Application Settings for a database connection string for a class library. I have a VB Class Library project called Test. In the project I have a configuration file called "test.config" that contains the following: ?xml version "1.0" encoding "utf 8" ? configuration appSettings add key "ConnectionString" value "server (local);database pubs;Trusted Con... |
|
| DataViews (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Hey all...I have a DataView that I need to apply several different filters to then use the filtered data. Heres the code (which will hopefully allow you to see what I am trying to do: string filter "DateCreated #" DateTime.Today.Subtract( new TimeSpan( (numColumns x) ,0,0,0)) "# AND DateCreated #" DateTime.Today.Subtract( new TimeSpan( (numColumns (x 1)) ,0,0,0)) "#"; dv.RowFilter filter; if (dv.C... |
|
| DataBase Question (7 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by devin devinr@drone interactive.com I am trying to pull a single row from a SQL database and assign the value of in each column to a string variable. Any ideas how to do it? |
|
| copying the structure of a datatable (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Let's say i have an instance of the datatable object named DT1..... DT1 have a structure and a number of records.... Wich is the simplest way to create another instance DT2 wich has the same structure as DT1 but no records ? in other words : Wich is the simplest way to copy the structure of an instance of a DataTable to another instance ? Is there a method to do this ? thanks, Rolando rramirezg@ho... |
|
| Adding a Dataset to a Database Table (6 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Marcie Jones marciejones@yahoo.com Hi all, I'm not sure what list to post this on, so here goes. I am creating a dataset from scratch. It is populated by a function that will add approximately 80 rows to the one table in the dataset After the dataset is populated, I would like to add all this data to a table in a database. Is there a way to insert all... |
|
| Interesting info: Sql, OleDB and ODBC (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I'm currently reviewing a new book from Apress (Database Programming with C# by Carsten Thomsen). So far it looks like a great book. I just read this quote that I had never seen before (with the numbers, at least) and found it interesting. The OdbcConnection class, which uses the Platform Invoke feature, is roughly twice as fast for standard applications than the OleDbConnection. The latter uses C... |
|
| Casting Object to a recordSet (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Dana Coffey denigma@bellsouth.net Hello I am converting a classic ASP app that has the following code: set rs myObj.CreateRecordSet("info"); the CreateRecordSet returns an Object, how can I convert this to a dataTable, dataset, or something similar? I have tried to cast the object into a DataTable, but I get the inValid cast exception error. myDataTab... |
|
| URGENT SqlCommand.ExecuteNonQuery TimeOut Problem (8 replies) |
| ASPFriends.com 'aspngdata' list |
| I am having timeout problems with some code when trying to update some data into a table in SQL 2000. The function works fine for short amounts of info, but when trying to run a query where the querystring is about 30k causes a timeout problem. Here is the code that I am using: public static string ExQry(string sQry) { SqlConnection oCon new SqlConnection(SqlCon()); oCon.Open(); SqlCommand oCom ne... |
|
| Finalise and close a generic data object? (9 replies) |
| ASPFriends.com 'aspngdata' list |
| I have some code that uses a delegate to execute a user defined method. This method returns some data. The type of the returned data is simply an object, and I assume it is IEnumerable. This way I can get the data out. I get the data out of the current row by assuming it's either an IDataRecord, DataRowView, IDictionary or IEnumerable. My code works fine I can accept SqlDateReaders, DataViews, Arr... |
|
| Determine SQL Server Table Properties In Code (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Is there an easy API to reliably determine SQL Server table properties (such as PKs, FKs, etc.)? If so, could you direct me to the documentation for it? Thanks! Ambrose ****************************************************************************** The Company reserves the right to amend statements made herein in the event of a mistake. Unless expressly stated herein to the contrary, only agreement... |
|
| SV: Determine SQL Server Table Properties In Code (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Maybe you should have a look at this: ms help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfSystemDataCommonDataAdapterC lassFillSchemaTopic.htm The FillSchema() Method have at least some of the functionality u are looking for. Hth 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 Bergsgatan 3,... |
|
| What does the Execute Scalar Command return? (7 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by devin devinr@drone interactive.com Hi all, Can anybody point me what wrong I am doing below. I thought that the ExecuteScalar returned the number of rows affected. Regards Srini Exception Details: System.FormatException: Input string was not in a correct format. Source Error: Line 25: intID CType(ObjCmdUName.ExecuteScalar, Integer) Line 26: catch ex a... |
|
| DataSource property is an object not an ICollection - why? (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Why is the DataSource property on a control always set to an object and not an ICollection? Don't all data sources have to implement ICollection? Dan Green [ http://dotnetdan.com putting the dan in .net ] |
|
| Question OnItemCreated and OnDataBound (2 replies) |
| ASPFriends.com 'aspngdata' list |
| From a progaming point of view when would you use the OnItemCreated event verus when to use the OnDataBound events? Both these event appear to perforn the same function but at different points of time in binding the data to the datagrid. So my question is when would choose one over the other and why? For 2002 ASP.NET Solutions & Articles goto: http://aspalliance.com/dotnetsolutions/ Dennis West We... |
|
| Typed datasets vs. regular datasets (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Can anyone give a rundown of the pros and cons of using typed datasets vs regular datasets? Thanks S |
|
| NOT ANSWERED BEFORE RE: Dataset inserts (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Hello All, I have a table as specified below ProductNum Product Order Des 1 1 AAAAAA 2 2 BBBBBB 3 3 CCCCCC I have a data set which is constructed using this table, so it represent the same format as above. Now I wanted to insert a row with following details : Product Num 4 Product Order 2 Des AAbb So now the original row with ProductNum 2 and Product Order 2, will become Product Order 3 and so on ... |
|
| Removing columns from a dataset table ... (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi gurus, I am getting records returned from a stored procedure and load it in a dataset table. I would like to remove the first column from the first table in the dataset in ASP.NET. How can this be accomplished? Thank you, Mazen Alzogbi http://www.mazenalzogbi.com |
|
| Using GUID's (14 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, can someone tell me if this is a good use of GUID's please: I want users to be able to sign up to a site. There are likely to be around 10,000 users and (at least for the timebeing) the data store will be Access. I want the users table to contain an ID field that can be used a join for other related tables. I had been using the autonumber from the users table but I'd like to be able to generat... |
|
| Sort datagrid (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Hi Is there way to sort datagrid based on stored procedure Thanks Vojin Lekovic |
|
| Read Excel data (4 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Where can I find ASP.Net (VB) sample of reading data from Excel sheets? Thanks. Brent Giesler Dallas, Tx 972.754.4100 www.aspguy.com brent@aspguy.com |
|
