| Exception Vs Errors (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I just want to know what the difference is between Exception and Err object. Also, i see that Exception does not provide any number attribute unlike Err.Nnmber in VB. So, how do we suppose to raise an exception for a business rule violation which are usually implemented by specifing err.number in VB6 and dislaying a user friendly message fromt the database. I looked at Microsoft Application... |
|
| Update Data with "Where" Clause with only modified fields (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, is it possible to configure ADO.NET the way that an Update Command to the Database has a Where clause where only the modified fields would use for concurrency? As example i have a Table1 with Field1, Field2, Field3: What i want is an automated genereted Update like: If the user modified Field1 Update Tablle1 Set Field1 ? NewValue where ID ID and Field1 OldValue So if a user modifies field1 and... |
|
| ADO.Net and Transaction support (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| If I need to have a transaction support across .NET components with ADO.Net, Isn't passing the connection across components an overhead? Regards. Nitin |
|
| VB.NET Datagrid (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Does anybody know how to show cells in a windows form datagrid as comboboxes in addition to built in textbox or boolean checkbox control? Thanks, Sal Sarhangi |
|
| Downloading a file from a database? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, There are many sites which show you the upload of a file. How can I download this file back to the local disk? Thanks in advance. |
|
| OLEDB (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Has anyone devised a way to extract the "modifiedConnectionString" property from an OLEDBConnection object (this is listed as private in the object but there must be a way to access it). The initial connection string is a refrence to a UDL |
|
| Memory used by a Dataset (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I've been watching the memory used by my application and have noticed that when I open a dataset the memory usage increases, as expected, but when the dataset is closed and Disposed the memory is not returned. Using VS.Net Released Version. Am I missing something ? Thanks, Fred Jones |
|
| data grid format (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| hi, I got a simple question. I have bound a database table to a datagrid. when I display a field which is of type decimal, the datagrid seems to be truncating the last 0 after the decimal...like ..if the value in my database table is 1234.50, in datagrid it is showing up like 1234.5... I tried to parse the values..it didnt work out...has anybody else run into this , and found a way around it.. tha... |
|
| Dataset namespace question (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I had created a web service using C# Beta 2 (and running on the Beta 2 version of the .NET framework) that returned a dataset. The client that called this webservice had code to parse the dataset using XPath. When I moved the web service to work with the .NET framework 1.0 (final version), I noticed that a prefix to a namespace changed from xsd to xs. For example: Here is a portion of the data... |
|
| DataRelations on Multiple Columns (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi Is it possible to include more than one column in parent/child relationships? I have a central table (SQL Server 2000) which requires the combination of two columns to create the primary key and I would like to add this db relationship into my Dataset. Example: tblCustomers CustomerID (PK) CustomerAddress (PK) tblOrders OrderID (PK) CustomerID (FK) CustomerAddress (FK) I know that the syntax fo... |
|
| DefaultView == null !? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm trying Dataview dv myDataSet.Tables[0].DefaultView; and getting null. Isn't there always a DefaultView |
|
| DataSet and Recordset! (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Isn't Dataset similar to shaped Recordset? With Best Regards... Vesel Sharan |
|
| Excention Vs Err (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I just want to know what the difference is between Exception and Err object. Also, i see that Exception does not provide any number attribute unlike Err.Nnmber in VB. So, how do we suppose to raise an exception for a business rule violation which are usually implemented by specifing err.number in VB6 and dislaying a user friendly message fromt the database. I looked at Microsoft Application... |
|
| Displaying data from dataset in a label (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Can anyone tell me how I can display information pulled from a database into a label? I already have the dataset working properly. For example, I have a field called "Name" (its a string, obviously). How would I display the information returned from a SQL statement in a label? I tested the webservices, and its all working fine. I just can't figure out how to display it. |
|
| paging (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| paging Am I right that there is no built in means to paginate records returned by stored procedure with parameters? I can send parameters to db through Command object only and read returned recordset by DataReader object only, while as far as I understand paging is provided for records sets produced by SqlDataAdapter and kept in DataSet which don't support parameters. What is the solution then? Or... |
|
| Can I do joins and queries on my DataTables? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| If I've got a DataSet with a buncha DataTables and constraints and relations and stuff, its like I have a little database all residing in memory. Can I do queries and joins and return "views" of my data in this way? It seems that I have everything I need to do that. The docs say that the DataView object can't be used to join tables. |
|
| How do I get user id from SqlConnection. (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| How do I get user id from SqlConnection object. Documentation says that property is there but I do not see it. I am using .net beta version. Is it there in release version? If not does any one know how do I get it. I am using Integrated Authentication to the SQL server and it loges in using doamin user name and password. Thanks Anil Gupta |
|
| exporting data from datagrid into excel sheet (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| hi , i exported data from datagrid into an excel sheet...my null values in datagrid are coming as "&nbsp" in excel sheet...i tried to make the strings null..but its not workin ...can anybody suggest me wat to do...thanks in advance krishna chaitanya kanthety |
|
| Programmatically Connecting to SQL server using windows authentication... (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I am trying to connect to SQL server from my C#.Net code using Windows authentication. The following is the code snippet I am using: SqlConnection cn new SqlConnection("server (MYSERVER);uid myuserid; pwd mypwd;database mydb"); cn.Open(); SqlCommand insert new SqlCommand("Insert into test values ('value1','value2')"); cn.Close(); I am getting a connection failure exception. Now, myuserid and m... |
|
| SQL Server Connection timeout (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I keep getting a Connection timeout error filling a DataTable from an DataAdapter. I have set the query timeout on the server to 0(also tried setting it to a large value). I have set the 'Connect Timeout' connection property to 0 (also tried setting it to a large value). I have tried both the SQLConnection and the OleDbConnection. I have tried SQL Server 7 as well as Sql Server 2000. I have tr... |
|
| Database Schema to XML Doc? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is there an easy way to transform a SQL Server 2000 database schema, specifically tables and sp's, to an XML document? Thanks, Todd Plambeck |
|
| Relational Data (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have table that has fields that are foreign keys. In my datagrid I do not want to display the id of the field but the name. If I create a dataset and have a data relation with the table. I am able to access the fields name. How would I display this in a datagrid, It seems that I can only set the defaultview of a table. Is there a way I can create One dataview for the Dataset? |
|
| e.Item.FindControl("Column5Control") returns old value instead (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi All! I used the following code from one of cuttingedge columns.But this code returns old value of the column insted of the newly entered value through the TextBox. The code listing is as follows, void Grid Update(Object Sender, DataGridCommandEventArgs e) { TextBox tb; tb (TextBox) e.Item.FindControl("Column5Control"); } Could you please help me in resolvind this problem! Thanks, Vasudevan. ***... |
|
| Http post and get. (long) (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| In old ASP/VB script I can have a html page request data and display it without refreshing the entire page. I have been spinning my wheels attempting to reconstruct this in Beta 2 .net using c# and I'm about to give up. Has anyone done anything like this before? If so, can you send some advice my way? I was thinking the server side component could be a web service but I haven't done it yet. Its ne... |
|
| Inserting DataSet into DataSet (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello! If I have a DataSet with XML that looks something like the Northwind database: customer customerid ALFKI /customerid /customer and another DataSet looking like: orders orderid 12 /orderid customerid ALFKI /customerid /orders can I "join" the two DataSets so I get a resulting one appearing like: customer customerid ALFKI /customerid orders orderid 12 /orderid customerid ALFKI /customerid /or... |
|
