| login and password (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Whats the simplies way to query my database for a login and password. i'm learning with a sql database. hq |
|
| Show me your code (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Do you have a basic page with a datagrid on it which has an update feature? Please Please just paste in here. Only take 2 secs. Being at it for 3 weeks! Gary |
|
| Timeout using Fill method of adapter (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I run a query that depending on the parameters takes a while to run. Everything goes smoothly until the query takes longer than 40 seconds to complete. Then I get the following error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. What do I need to set to allow the query to run longer? Tyke |
|
| Editing Rows (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I have written a program that can add and delete rows, but I am having trouble figuring out how to edit rows. I want to search each row for a specific name in a Name column. If the Name is found, I want to edit the row. The problem Im having is I perform a For NNext loop to go through all records, and when I find the proper row and perform the edit, I receive an error. Is there a way to use SQL to... |
|
| New Column in DataSet/Dataview (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| All, I need to create a new column in a data set/dataview and populate that column with two other values from the dataview. DBA won't do it in the stored proc, so we need to do it in ADO.Net. Does anybody have a code snippet on how to do this? By the way, I'm doing this to populate the drop down description with two values instead of one. Thanks Chris |
|
| Data Adapter (Best Practices) (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I am look for opinions on how to best use the data adapter: via wizard manually (no control) Thanks Pink |
|
| Connection pooling - HELP PLEASE! (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I am experiencing a strange behavior in my .NET app. In my application, several datagrids are refreshed every 5 seconds. In that, the database is hit up and a single query is run. However, after several hours of being on, my application is throwing an exception "maximum pool size was exceeded". When I modify my connection string to explicitly turn off pooling, it works fine. I then did some invest... |
|
| DataTable (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I want to be able to sort the data in a dataTable and then return this sorted table to the user. So I looked at using a the DefaultView on the table, when you set the sort string for the view is the view sorted then or do have to call another function? Does the sorted view affect the under lying dataTable, I guess not, and if not how do I get the sorted view into another table? Cheers FB |
|
| Can not build ApplicationBlock (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I downloaded and installed MS ApplicationBlock for ADO.NET, and tried to build it. I got the following error. Since I am not experienced on ..NET I am not able to handle... Please help me. D:\Program Files\Microsoft Application Blocks for .NET\Data Access\Code\VB\Microsoft.ApplicationBlocks.Data\SQLHelper.vb(297) : error BC30390: 'System.Data.SqlClient.SqlTransaction.Private ReadOnly Property ... |
|
| runing SQL script how? (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, How can I run SQL script from my app? |
|
| dealing with many different types of integer! (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| in SQL there is tinyint, smallint, int, etc. unfortunately you cannot cast all these types to an integer when returned from a dataset. even casting from int16 to int32 doesnt seem to work. i've ended up doing int userid int.Parse(datarow["userid "].toString()); instead of int userid (int) datarow["userid"]; i dont like to do this? am i missing something obvious or will i need to parse the int or d... |
|
| InfoMessage "problem" (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello... I use some Stored Procedures which returns: 1 System/SQL Error 0 OK 2 Logical Error Logical Error here means e.g. "username not found" etc. I my c# code, I test for the return value from the Stored Procedure... If the procedure returns 2, this means I can find more information about what type of logical error occured in the procedure. The procedure will raise an error, with errorcode 5010... |
|
| Failed to enable constraints - HELP (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am struggling with this and cannot seem to solve it. I get; "Failed to enable constraints. One or more rows contain values violating non null, unique, or foriegn key constraints." First I disable constraints, then I fill my data set tables, then I re enable constraints and POW! I cannot figure out what the problem is because the exception doesn't seem to contain the information as to what Table/... |
|
| How to export datatable to excel worksheet (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| BlankHi,all: I have one urgent problem to deal with. I have to export the contents of one in memory datatable to one excel worksheet. I want to know how to do that. Any comment is appreciated. |
|
| Is there any tools or monitor that I can observe Connection Pooling? (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi all.. We know ADO.NET support Database Connection Pooling.. Is there any tools or monitor that I can observe the usage of Database Connection Pooling? Or Is there any evidence that I can convince my boss of existence of Database Connection Pooling? Thanks a lot. Clare Hsiao |
|
| Create my own updatestring (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hallo, I need to create an updatecommand for my dataadapter manually. But I have no idea how to this since the command connot be a fixed string. It depends on what is changed during the editing. Here is my selectcommand: "select order,customer ,customers.* from orders inner join customers ON orders.customer customers.id" Fortunately order is the only field that needs to be updated. How could the u... |
|
| Best Practice: Storing Connection Data (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I need to determine the best method for storing various connection related details in a location where it can be changed easily for different clients. In classic ASP, I used an include file (e.g. ConnectionString.asp) in my ASP page and could easily change the connection string depending on the machine I'm using. Is this same type of approach advisable in .Net? I'll be writing my first C# web base... |
|
| ComboBox Show distinct? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| How can I get a combo Box to show only distinct values? my combobox is bound to a table and in the display member there may be the same value repeated, I want to only show it once, how can I do that? I appreciate any assistance. Delali |
|
| OLEDb Oracle Date confusion (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| This is very strange. I've whittled the problem down to a single line example. See the following query: select (TO NUMBER(to date('18 AUG 2002') to date('14 AUG 2002'))) Age from dual If you run this in Oracle you get a result of 4 (i.e. 4 days difference from the date calculation). But, if you run exactly the same query using OleDB in ADO.NET you get a result of 1461. So, I tried changing the lay... |
|
| SqlConnection and User Id (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi. If I wish to connect to SQL Server using SqlConnection object in my ASP.NET application, is it possible for the SQL Server .NET data provider to implicitly/internally/automatically set the User Id of the SqlConnection's connection string to the client user identified by the user name set under system.web.httpcontext.user.identity.name? ... or is this the responsibility of the ASP.NET applicati... |
|
| Dataset from two tables and identical column-name (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have the following select SELECT t1.column , t2.column from t1, t1 where ..... In the dataset automatically two columns are generated columnName(0) column columnName(0) column1 But I want access via "t1.column" and "t2.column" or similiar !! ls 1 Convert.ToString(ldt 1.Rows(i).Item("t1.column")) ' Does not Work ls 1 Convert.ToString(ldt 1.Rows(i).Item("column")) ' Works, but ... ls 1 Convert.ToS... |
|
| best practices with Command object (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| BACKGROUND I'm going to execute the same (insert) command 2 million times Each time, a single row is inserted into a database table. I've defined a Parameters collection for the command object. QUESTIONS Is it better (a) to instantiate and destroy the Command object once and only once, giving the object class level scope, and then in a member function to change the CommandText and the parameter va... |
|
| ASP.net, IIS 5, SQL 2K (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am running a WIN 2K Pro Box with IIS 5 and VS.NET installed on it. I am trying to connect to a SQL Server 2K database on a WIN 2K Server using an ASP Web Form. When I try the connection I am receiving the following error. Login failed for user ('null'). Reason: Not associated with a trusted SQL Server Connection. My connection string is as follows: Dim cnMembers as Sqlconnection New SqlConnectio... |
|
| Current row....still a bit confused.. (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have been reading through the articles regarding the BindingContext and CurrencyManager and I still cannot derive what the current row is. I can move first, last, previous and next without a problem. However, I need to figure out what the row number/position I am on after the user presses Prev or Next buttons. For example, in my Next button I have the following code: Me.BindingContext(dsUsers.Ta... |
|
| Error - what does it mean? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello... I am trying to use the value of the current row via the BindingContext Position property in another command and I get the following error: An unhandled exception of type 'System.InvalidCastException' occurred in CustomerApp.exe Additional information: Specified cast is not valid. Here is my code: Dim nRow As Integer Me.BindingContext(dsUsers.Tables(0)).Position 1 nRow Me.BindingContext(ds... |
|
