| Tools Disabled in Compact Framework (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Can anyone tell me why some tools are shut off in the Compact Framework area of the Visual studios 2003. The XML tools are very usefull in the Windows Application Area, but are UNAVAILABLE in the Smart Device Area of the Editor. Is there a Fix for this ?? Thanks for your time. Dave |
|
| OleDb and .NET (7 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Are OleDb libraries installed with runtime .NET or do you have to install ADO.NET separately? Thanks czupet@wsinc.com |
|
| Designing Inventory and Payroll Applications in .NET (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello There. Anyone having experience in desiging payroll and inventory applications in Dot Net please guide me through the process of designing these kinds of Apps in VB.NET. Such as How to gather system requirements? how to design logical model,Physical model etc. Waiting for immediate feedback! Abul Hasan, MCP |
|
| an error (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I try to delete or insert to MS Access table through Web application the error occurs in statement " string s "Provider Microsoft.Jet.OLEDB.4.0;Persist Security Info False;Data Source C:\\izg\\db1.mdb;User ID Admin;"; .... int i oledBCommand1.ExecuteNonQuery; " The error message is: "Could not delete from specified tables" I don't know what is real crucial place? Juli |
|
| How to get the dataset size (in bytes)? (5 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| In Data Adapter Preview window, you can preview the size of the dataset. But how to get this value progammtaically? i tried to find proper property in dataset and data adapter but cannot find. any idea? Here is the screenshot: http://www.ezballet.com/scrdump/datasetsize.gif |
|
| Abstracting field names in strongly-typed datasets? (9 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I'm working with a table that has poorly named fields which I cannot change: dptnum dptname I'm creating a strongly typed DataSet to work with the data in this table, and I would much rather that my DataSet have fieldnames of: DepartmentNumber DepartmentName Is there some way to accomplish this without modifying the original table? some sort of "alias" that I can add to the elements in the XSD? I ... |
|
| Error filling typed DataSet with relations (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hey guys, In my schema I have created various relationships between tables in my dataset. However when I attempt to fill the data set I get a ConstraintException with the message Failed to enable constraints. One or more rows contain values violating non null, unique, or foreign key constraints. the keys that the relations are set to nullable. Does anyone have any idea? Regards, Tommy Posted Via U... |
|
| Body background (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| How can I set body background with an image, but centered and not tiled? When I put background "image1", it fills my page with the image many times. I only want to put at the beggining and centered. I don't won't to use img src "image1" because I have a choice menu that I want over the image. Thank's (if you try to help me) Hope this help you (if I try to help you) ruca |
|
| error in from clause (7 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hello I try to fill a dataset. This is my code string myConnectionString "Provider Microsoft.Jet.OLEDB.4.0;Data source C:\\Inetpub\\wwwroot\\Notenhof\\data\\notenhof.mdb;"; OleDbConnection myConnection new OleDbConnection(myConnectionString); myConnection.Open(); DataSet ds new DataSet(); OleDbDataAdapter dtad new OleDbDataAdapter("SELECT * FROM user",myConnection); dtad.Fill(ds); When I execute: ... |
|
| Load XML into typed dataset (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi. I have a typed dataset which defines several tables and the relationships between them. Most of the tables will be populated from my database and this is working already. However one table will be populated from an XML document. Any pointers as to how I do this? Thanks KH |
|
| Is ADO.net and VFPOLEDB compatible with Fox 2.6 index files. (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| HI. I am trying to transform an old application in FoxPro 2.6 into a VB.net application. I use Ado.net with the last VFPOLEDB driver. I am opening a DBF File and his .idx file index by doing : "USE c:\mytable.dbf INDEX c:\myindex.idx" into a dataset and his dataadpater. My two questions are : 1 can i use the commandbuilder to generate the updatecommand , supposing i have a unique INDEX defined in ... |
|
| 'System.Data.EvaluateException' problem (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Why do I get a 'System.Data.EvaluateException' when I do DataSet.Table(strTable).Rows.Add(DataRow) ? My DataRow have 2 fieldas than I filled with a primary key (numeric) and a text field (string). To generate that line, I did DataRow DataSet.Table(strTable).NewRow. The error says unable to assign operator ' ' on System.Int16 and System.String. (or something like that since I translate it from ... |
|
| DataGrid in VB.NET (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I have a datagrid that I am populating, and on my tab and I have a select/Deselect all checkboxes. The only column in my grid that is readable is the first column and it is a bit field displaying checkboxes. I want to cycle through and select/deselect the datagrid items based on either the Select/Deselect checkboxes on the form. Posted Via Usenet.com Premium Usenet Newsgroup Services ** SPEED ** R... |
|
| Question about data into XSDs (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hope someone can help me here... I have written a crystal report that works off a 3 table XSD which is stored in C#, but I'm having trouble getting data in there, particularly in relation to mapping. I'm running an SP to get one set of data, but I get a mapping error when I try and map it to a data table in the XSD. What's the best way of doing this, and can anyone point me at any examples/article... |
|
| Found Serious Bug! (17 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| If you have a datatable connected to a dataview. And In that dataview you have a "Sort" property set to a value; And You try to modify the "Sort" column in row in such a fashion that it gets moved in the DataView IT CAN Corrupt your database. A quick fix is to set the "Sort" property of the dataview to "" make your changes and then set it back to it's original value. Trey |
|
| New col. in a dataview (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have created a new col. in a dataview of type int. For the value of this col. related to the different records, I need to call a function GetReports(m ReportSiteKey, 'value of col["FolderKey"]); where 'value of col["FolderKey"] is the value for each row relevant to col. "FolderKey". How do I get the 'value of col["FolderKey"] ? Thanks |
|
| DataBinding (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi I am running a stored procedure on the SelectedIndexChanged event of a combobox. this stored procedure retrieves details from a database. i want to bind the results to the controls on my form but it doesnt work!! here is my code 'Display the caravan details based on the length and the caravan model. Dim cmdEditCara As New SqlCommand("SPSelCaraDetailsOnModelLength", Conn) Dim da As New SqlDataAd... |
|
| Building a Dataset with Access (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have another question about this process of getting a connection set up and then populating a drop down list box with a query. I was able to create a connection like you said, and then I created a data adapter. I then clicked on "generate dataset" and named a dataset to be created from a query I specified. I get this build error: "The type or namespace name 'dsStatements' does not exist in the c... |
|
| Design issue using ADO.NET and ASP.NET (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have an MS Access database that contains one table with the following information: Date Gallons Mileage I created an ASP.NET web appliation that can access the table via ADO.NET (using oleDB controls) so I can display the info in a web page using a DataGrid control.... Currently I have this working w/ no problems. The next thing I would like to do is add another column to the DataGrid and calcul... |
|
| Union Tables from Different Sources (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi: I am retriving data from a Text File, Oracle and SQL. Is there any way that I can perform a Union of Three data.tables from 3 Different Datasets. Thanks |
|
| Connection busy SQL Server (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| I ve an error "Connection is busy with result another command" with oledb and SQL Server 8.00.837 (SP3a) and Framework 1.1.4322.573, MDAC 2.8 RTM. It's not always on the same command and if i try on my server Oracle all are clean. I search in many forums but nothing help me for now. (apply FIX BUG #: 469661 ) Any ideas ? I switch off my virus scan but always the same bug.... Thx |
|
| Editing Parent Table does not update Child Table... inconsistent behaviour. (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| [If someone has already addressed this issue, please let me know in detail as I have actually searched all of microsft.public.dotnet.* for an answer and couldnt find it anywhere] Hello again... I have the following problem: Lets say I have a Parent DataTable (ID, col1) and a child DataTable (ID, col2) where there is a relation on the ID's and the childTable col2.expression "Parent.col1 * 10" If I ... |
|
| How should I design? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have the following scenario: I have a books database that contains several tables, with the appropriate relationships setted up. After I have the db schema, I designed the Book component, that is constructed to hold information from each table, and also the Publisher and Author components, that I thought that fits well for one to many, and many to many respective. Now, I'm retrieving and fill a ... |
|
| Odbc fails with parameters (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Posted this to 'ado' group earlier but getting no replies... I have a C# app that uses the base "System.Data" interfaces so it can switch between Oledb and Odbc (mostly accessing a Jet database). Everything has worked until I tried using parameters. The code below works perfectly in Oledb mode, but fails under Odbc. The Odbc error is "ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few... |
|
| This seems slow...Why? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi All, I'm just coming up to speed here on .NET and have a C# WinForm App that accesses a database. I've gotta form with the following code in the form load event: private void DocumentsDetail Load(object sender, System.EventArgs e) { this.dsDocuments1.Clear(); this.daDocuments.Fill(this.dsDocuments1.Documents Sel); } The DataAdapter is using Stored Procedures and I'm seeing dismal performance on... |
|
