| Hi (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngcommunity] to [aspngdata] by Charles M. Carroll darthcarroll@asplists.com 0 1062329826 1007358209 :58558 Content Type: text/plain; charset us ascii Hi Mr.Charles Carroll I am Srividya(vidyashan2k@yahoo.com).and i am facing a query in asp.net.Hope u friends will help me in this.The query is as follow,i need to disply parent child heirarchy in datagrid.please suggest me some ways.Be... |
|
| Quick Dumb question (2 replies) |
| ASPFriends.com 'aspngdata' list |
| How do you divide and get the actual the whole number with remainder in Sql 2000? Here's the code: Regards, Ryan SET QUOTED IDENTIFIER ON GO SET ANSI NULLS ON GO ALTER PROCEDURE updatePrice ( @id int, @oldPrice float OUTPUT, @newPrice float OUTPUT, @change float OUTPUT ) AS SET @oldPrice (SELECT price FROM collection WHERE id @id) SET @newPrice (@oldPrice 5) UPDATE collection SET price @newPrice W... |
|
| sql server timeout/max connection? (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Timeout expired. Possible reasons: the timeout period elapsed prior to completion of the operation, the server is not responding, or the maximum pool size was exceeded. Please see the documentation for further details. I'm getting that error message if do submits to my database multiple times in a row. I've have page which updates a record in the sql server. If i submit that page about 5 times in ... |
|
| Get value of row n and column y (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| For the life of me I just can't remember this. All I want to do is get a single value from row 0 column 1. Devin |
|
| ORACLE and .NET (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Hello, I'm looking to return a recordset to an ASP.NET application from my Oracle package. Does anyone have any code examples that return recordsets from packages? Specifically being called through .NET/ASP.NET All the examples i've seen are just simple select/insert/etc... Scott |
|
| building generic stored proc class (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hey, I want to build a generic SP class where I can pass in the values and the name of the stored procedure. I will then have a XML file with the parameter details in it. Does anyone have something similar that I can have a look at? BTW I have tried to do it with tables in SQL but for some reason it is not working too well. Thanks, David |
|
| DropDownList - adding a default "select" to a databound ddl (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Copied from [aspngcs] to [aspngdata] by G. Andrew Duthie (Moderator) graymad@att.net What's the trick to having select show up as the default in a ddl when it has been filled with by Database values. I tried a number of things including an asp:ListIem w/o success. any help would be greatly appreciated... thanks john |
|
| HOw to write a Store Procedure that counts (9 replies) |
| ASPFriends.com 'aspngdata' list |
| how to buid a stored procedure that would auto increment a field used has a counter by 1 for a row that was selecteded is it possible to write a proc that if the row was selected by it's ID value that a usage field (int) could be updated (incremented) and the results be return along with the selected fields. Dennis H. West West Design dotnet developer http://aspalliance.com/dotnetsolutions westdh@... |
|
| HTTP 500 Error Help (3 replies) |
| ASPFriends.com 'aspngdata' list |
| All, I couldn't fiqure out why Im getting HTTP 500 Internal server error page after login using my valid username/password that was already stored in the database. Can you tell me what I did wrong in the loginNow codes below? Global.asa SCRIPT LANGUAGE "VBScript" RUNAT "Server" Sub Session OnStart Session("Authenticated") 0 End Sub /SCRIPT Start here http://www.magnixsolutions.com/dev/tempdev/test... |
|
| Data Binding woes (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| I have followed a couple of microsoft examples and walk throughs in which the basics of data binding with Windows Forms and ADO.NET are implemented. The problem is that I receive the 'login failed for user " insert username here "' when the application is run. When the sqlConnection and SQLDataAdapter are created the connection tests fine from within visual studio. The project builds without error... |
|
| Retrieving sproc Output parameters (7 replies) |
| ASPFriends.com 'aspngdata' list |
| This code returns an error. Can somebody help me out? I don't understand why and specifically how to retrieve the output parameter from the sproc. PS: This is using the Steven Smith's DAL class: ****** script language 3D"C#" runat 3D"server" 20 void Page Load(Object sender, EventArgs e) { string strConn 3D ConfigurationSettings.AppSettings["TDSconnectionString"]; 20 SqlConnection Conn 3D new SqlCo... |
|
| 1 DataSet Multiple Stored Procs (7 replies) |
| ASPFriends.com 'aspngdata' list |
| Could someone point me to some code examples when multiple stored procedures are executed and their resultsets appended to the same dataset? The result sets have no relation. Regards, Ryan |
|
| Binding DataList controls to multiple tables in 1 DataSet? (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Is it possible to bind multiple controls within a single datalist to different tables within the same dataset? I have a DataList that contains a textbox, and a DropDownList, and want the value for the textbox to come from one table, and the DDL to contain multiple values from another table. Both tables are contained in a single DataSet. I have included the source code below. Thanks for any help in... |
|
| Iterating through a Datagrid? (5 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Is there any way to iterate through a datagrid? I have a DataGrid that I am building and one of the column is checkboxes. What I would like to do is something like : foreach row in myDataGrid { DO STUFF } Dot Net Guru |
|
| Getting the index within a DataTable (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| How can I get the index of a row within a DataTable? I have the primary key, and the DataTable, I want to know the index of that row within the DataTable. Thanks for the help. Jim Wiesen Web Applications Development Long & Foster Real Estate jim.wiesen@longandfoster.com (703)359 1655 |
|
| odbc (10 replies) |
| ASPFriends.com 'aspngdata' list |
| Can someone post some code that connects to an odbc data source, gets a dataset, then binds it to a datagrid. A million advanced thanks, Helen |
|
| Connection String (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi: I have been storing connection string in web.config file. Now all my DB dll's call ConfigurationSettings.AppSettings["ConnectionString"] to get the connection string. I now discovered, I need to add a console application and it needs to call those DB dll's. My code breaks because dll's call ConfigurationSettings.AppSettings["ConnectionString"] to get the connection string. What would be good, ... |
|
| NoCount, RowCount and DataAdapters (4 replies) |
| ASPFriends.com 'aspngdata' list |
| For Insert/Update/Delete stored procedures, what's the correct way to ensure the DataAdapter knows how many rows were affected? Here are the kinds of questions I have... Is it necessary to return @@rowcount? What's the implication of turning NOCOUNT off (in a multi statement sprocs this improves performance by reducing round trips, right)? If NOCOUNT is ON do I then need to return @@rowcount? Dan ... |
|
| Inserting NULL into the database (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Hello All, I am having problems with inserting NULL into the table, my problem is i am using the insertion using parameters method for inserting into the table. so when a user doesn't enter any value into a particular field i want NULL to be inserted into the Table for that particular field. Can anyone guide me on this!! Thanks in advance. Pradeep I am sending the code below Dim ConnStr As String ... |
|
| DataGrid SubQuery on DataGrid_Load (5 replies) |
| ASPFriends.com 'aspngdata' list |
| I have a DataGrid that allows users to edit employee records, I have successfully added dropdown menu's and check boxes where appropriate based off the Users Table. But during the DataBind I need to query a second table for a JobTitleID and StoreID based off the employees ID, and then use those ID's to pull the appropriate information from a third and forth table (JobTitles, Stores) to fill the co... |
|
| DataGrid in a webform. (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Copied from [aspngvb] to [aspngdata] by G. Andrew Duthie (Moderator) graymad@att.net I am looking for a sample, or link that shows how to implement a DataGrid on a webform. Thanks in advance for any suggestions. Edwin A. Perez peree1@supreme.com |
|
| Generic datalayer problem with implementing Idbdataadapter (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi all, For a project I am working at at the moment I am trying to design a generice data abstraction layer. The application will have to be able to run on an Microsoft Sql server database as on an Oracle database. The app will be using Stored procedures My intention was the following: I create an data abstraction base class wich will be the parent of all my data abstraction classes (DACustomer, e... |
|
| Error using DTS Com object in Visual Studio (4 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Copied from [aspngvs] to [aspngdata] by Charles M. Carroll darthcarroll@asplists.com I have a VB.net project in VS .net Beta 2 SP2 where I am referencing the DTS com objects. I have taken some code directly from Books OnLine from SQL SErver, like so: Dim DTSPackage As New DTS.Package2() Dim DTSConn1 As DTS.Connection2 Dim DTSTask As DTS.Task Dim TransFormWorked As Boolean DTSConn1 DTSPackage.Conne... |
|
| Getting Output Param's From ADO.NET (5 replies) |
| ASPFriends.com 'aspngdata' list |
| I am having problems getting the output parameter back from a SQL Stored Procedure using ADO.NET Here is my Code SQL: ALTER PROCEDURE dbo.GetUserPassword ( @vchLogin varchar(50), @vchPassword varchar(50) NULL OUTPUT ) AS SET NOCOUNT ON SELECT @vchPassword PASSWORD FROM END USER WHERE LOGIN @vchLogin RETURN (@@ROWCOUNT) VB.NET Public Function GetUserPassword(ByVal Login As String, Optional ByVal Co... |
|
| Data Grid in Oracle. (3 replies) |
| ASPFriends.com 'aspngdata' list |
| This is my first Data Grid using vb.net and Oracle, and I am getting the error: "ORA 12560 TNS protocol adapter error", with the following code. Dim objconnect As New OleDb.OleDbConnection("Provider MSDAORA;UserID anyid;Password anypwd;DataSou rce stst") Dim objDataAdapter As New OleDb.OleDbDataAdapter("select * from MUO DETAIL", objconnect) Dim objDataSet As New DataSet() objDataAdapter.Fill(objD... |
|
