2.0: well-written sample application?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - TransactionScope exception handling Is there any way to have an DataReader.Read part of a TransactionScope but not cancel the transaction if the read fails? I'm using a DataReader to get the result of a stored procedure which increments a counter. I'd like to add the read to the transaction only if the read is successful. If the read isn't successful I don't want it to cancel the entire distributed transaction but I will need to roll it back (since the SP updates a table) if some other part of the transaction fails. Tag: 2.0: well-written sample application? Tag: 134722
  - 2
    - DataSet has no rows when proc is returning rows?? Hello, Im going insane with this problem. I have a stored proc that returns 2 recordsets to a dataset. In the dataset i reference the recordsets by their tables like below. ds.tables[0] ds.tables[1] In the first table it says their are 0 rows. The columns get populated but no rows. I run the proc outside VS and the results are correct. In the datase i can reference the second table and pull the rows i need. For what ever reason the first dataset is always empty. I have used this methods before and works great but for some reason it doesnt like the first recordset. In my proc I have 'set nocount on' code below. Here is a run down of the proc..... Query 1: SELECT a.first_name ,a.last_name, upa.organization_id, b.index_code as EmployeeID FROM person_name a, person_indices b, v_user_profile_app upa WHERE a.person_nbr = b.person_nbr AND b.index_code = (SELECT c.code_nbr FROM v_code_entries c WHERE c.table_code = "INDXTP" AND c.code = "EMPNUM") Query 2: Select RoleName FROM UserRoles WHERE person_nber=@person_nbr Tag: 2.0: well-written sample application? Tag: 134719
  - 3
    - DaatSet has no rows when proc is returning rows?? Hello, Im going insane with this problem. I have a stored proc that returns 2 recordsets to a dataset. In the dataset i reference the recordsets by their tables like below. ds.tables[0] ds.tables[1] In the first table it says their are 0 rows. The columns get populated but no rows. I run the proc outside VS and the results are correct. In the datase i can reference the second table and pull the rows i need. For what ever reason the first dataset is always empty. I have used this methods before and works great but for some reason it doesnt like the first recordset. In my proc I have 'set nocount on' code below. Here is a run down of the proc..... Query 1: SELECT a.first_name ,a.last_name, upa.organization_id, b.index_code as EmployeeID FROM person_name a, person_indices b, v_user_profile_app upa WHERE a.person_nbr = b.person_nbr AND b.index_code = (SELECT c.code_nbr FROM v_code_entries c WHERE c.table_code = "INDXTP" AND c.code = "EMPNUM") Query 2: Select RoleName FROM UserRoles WHERE person_nber=@person_nbr Tag: 2.0: well-written sample application? Tag: 134718
  - 4
    - Optimize DataTable Select Method Hi all, How can I optimize the DataTable Select Method to make it faster Can I create a Text Index Search ? Thanks alot Regards Tag: 2.0: well-written sample application? Tag: 134715
  - 5
    - Opening PDF document in new window on click of linkbutton column in datagrid Hi, I need to open PDF document in new window when i click on linkbutton in datagrid.For that i have written code as below: But the problem with this code is that it opens the new window ,but not loading the pdf.Please let me know how can i solve this issue. private void grdTest_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { if(e.CommandName=="View") { LinkButton btn = e.Item.FindControl("linkView") as LinkButton; GetPDF(); btn.Attributes.Add("Onclick","window.open('TestData.aspx');" + "return false;"); } } Here is the GetPDF function: public void GetPDF() { FileStream fs; string fname; fname = MapPath("../") + "via project/documents/Mass_title.pdf"; fs = File.Open(fname, FileMode.Open); byte[] data = new byte[fs.Length]; int i=(int)fs.Length; fs.Read(data, 0, i); fs.Close(); Response.Clear(); Response.Charset = ""; Response.ContentType = "application/pdf"; Response.AddHeader("Content-Disposition", "inline;filename=pdfTest.pdf"); Response.BinaryWrite(data); Response.End(); } Thanks, Vishnu Tag: 2.0: well-written sample application? Tag: 134714
  - 6
    - BindingSource1.AddNew() Help, I have created Windows app with VS2005. I then drop the datanavigator control and bindingsource control to the form. I bind a dataset tablet to the binding source and set the navigator to the bindingsource control , all wonderfull. The Problem I click to add a new record , it doesnt go to the end ? it goes to record 1 and seems to lose records 1 data. I have tried adding my own button on there with the code BindingSource1.AddNew() , but this does the same. How do I got to the newly created record. Thanks Neil Tag: 2.0: well-written sample application? Tag: 134712
  - 7
    - MS Data Application Block Hi, In .NET 1.0 and 1.1 I used the Microsoft Data Application Blocks for executing Stored Procedures etc. In .NET 2.0 is there a newer version of these blocks or has the way Data Access works been changed? Thanks, C Tag: 2.0: well-written sample application? Tag: 134710
  - 8
    - Why 1990 for ShortDate I use a update command to update a smallDateTime filed: Update [Checks] set Checks.CheckDate='' It udpate the CheckDate field to 1990/01/01 Why? Tag: 2.0: well-written sample application? Tag: 134707
  - 9
    - Concurrency violation I'm just starting to try and learn ADO.NET and was following along in Murach's VB.NET/ADO.NET book samples for typed databases with unbound controls. When I try to execute an update with the my data adapter and the data table as a parameter, daMembers.Update(dsMembers.Member_Listing), I get a concurrency violation. I'm not sure how to track down the problem. Basically I'm doing the following; open the connection, set data adapters selectcommand text, fill the dataset, get a data row from the table, put the data into controls on a form, change the data, put the changes into the data row, and execute the update command. ' load dataset cnRosterDB.Open() daMemberList.SelectCommand.CommandText = sSelectCommand daMemberList.Fill(dsMembers) cnRosterDB.Close() ' get a record drMemberRow = dsMembers.Member_Listing(0) With drMemberRow txtID.Text = .member_ID If .Islast_nameNull Then txtLName.Text = "" Else txtLName.Text = .last_name End If If .Isfirst_nameNull Then txtFName.Text = "" Else txtFName.Text = .first_name End If end with ' put edited data into data row With drMemberRow .member_ID = CInt(txtID.Text) .last_name = txtLName.Text .first_name = txtFName.Text end with ' try to update the database daMemberList.Update(DsMembers.Member_Listing) Any guidance would be appreciated, Thanks Dave Tag: 2.0: well-written sample application? Tag: 134697
  - 10
    - update values to excel data source using ADO.NET I've been able to connect to my excel spreadsheet using ADO.NET and display the data in a Datagrid. Now I need to know how to take the values in the datagrid and repopulate the excel spreadsheet. The end users will be editing the data in the datagrid and I have another application that will be consuming the excel file. Again any help on how to repopulate the entire datagrid to the existing excel spreadsheet will be greatly appreciated. Thanks Christian Tag: 2.0: well-written sample application? Tag: 134696
  - 11
    - convert DataColumn.GetType() into a DbType or SqlDbType? I have a DataColumn, want to derive the DbType. I can do column.GetType() but that's a system type, not a db type. How do I convert it to the corresponding type? Thanks much! Chris B. Tag: 2.0: well-written sample application? Tag: 134695
  - 12
    - Typed DataTable Question Someone told me that I could create a Typed DataTable WITHOUT first creating a Typed DataSet. I may be new to .NET programming, but I know that, based on what I've learned, this isn't correct. Am I right or not? Thanks! Tag: 2.0: well-written sample application? Tag: 134694
  - 13
    - More advanced examples for the impatient "newby" Well, I've taken poetic license with "newby" having been programming for more than a couple dozen years, but I have recently started studying .NET and ADO.NET, leveraging my experience with other frameworks such as Borland's VCL, and MS' MFC, and technologies such as ADO and MDAC, to speed things up. I have the professional edition of Visual Studio 2005, with MS SQL Server 2005, and I downloaded and installed ADO.NET 3, the relevant SDK and extensions to Visual Studio for it. I intend to experiment with ADO.NET with both a windows forms application and a web application using ASP.NET. With my readings so far, I see only simple examples where the master control (either a text box or a combo box) determines what is seen in a details grid. The example I want to use in my experiments is a recipe management database. The user's user ID will be a parameter in all queries. But there will be several combo boxes for "Cuisine type" (e.g. Thai, Mandarin, French, &c.), author (e.g. the user's name, some other author's name), kind of dish (breakfast, lunch, entrez, appetiser, desert), possibly with subtypes (e.g. for deserts, cake, pie pudding, &c.). Some of these combo boxes will have a default value and require selection of either the default or one other item in the combo box. Others will allow a NULL value, and if the user decides there should be a value other than NULL, he or she is constrained to select from the items in the combo box. The author, for example, might be NULL, to indicate the recipe may be an old family recipe or a recipe for which the author is unknown. I guess this is simpler than some cases in that the user will not be able to type entries into the fields, except for the author, for which I'll need a validator. OTOH, it is more complex in that the entries in the combo boxes do NOT affect in any way the possible choices in any of the other combo boxes. The question I'm wrestling with is how to use such a collection of controls to manage what is shown in (in my case) a pair of details grids (one for ingredients and another for instructions for a given recipe). Can anyone provide an example, or an URL to a page that gives an example, that shows how to do this? The second example I am looking for is how to use a combo box tied to one table as an editor for the cells in one column of the gridview tied to another. For example, for the grid representing the ingredients used in a recipe, the second last column will be a number representing a quantity and the last column will be units of measure such as grams, kilograms, ounces, pounds, teaspoons, table spoons, &c. Of course, the number of possible units is limited, and should be selected from a combo box rather than entered by the user typing (with all the related potential sources of error such as typos). But to make things more interesting, I want to give the user the option of selecting what system of units (cgs, SI, Imperial) will be used both for entering and for viewing a recipe, by default but with the option of changing the system of units used for a given recipe (so a user prefering to use metric can enter a recipe provided in imperial units and have my program automatically convert it to metric). After all, a person most familiar with metric might have, for whatever reason, a cookbook in which all recipes are provided with imperial units. Like I said, it is trivially easy for me to get applications similar to the examples I have found (both in the provided MS documentation and the multitude of books I have bought) to work, but their extension to situations like what I describe above is not obvious. I had thought about doing most of this in code, but I want to know if there is an easy way to accomplish this using Visual Studio 2005's form designer before I start writing n-factorial parameterized SQL statements or a function to create them at run time. Pointers(URLS) to more useful examples of using ADO.NET2/3 would be greatly appreciated. Thanks Ted Tag: 2.0: well-written sample application? Tag: 134691
  - 14
    - changing the text of linkbutton column in Datagrid Hi, I have the problem with the datagrid display. I want to change the display text of linkbutton.Please help me how can i do that. <asp:TemplateColumn HeaderText="Minute Order" > <ItemTemplate> <asp:LinkButton ID="linkView" runat="server" CausesValidation="false" CommandName="View" Text='<%# DataBinder.Eval(Container, "DMS Id") %>' ></asp:LinkButton> </ItemTemplate> </asp:TemplateColumn> When i use the above code,it displays the DMS ID which i should not,instead i should display View .How can i do that? Please suggest me the solution. It has to display as shown below: Minute Order View View View View View Thanks, Vishnu Tag: 2.0: well-written sample application? Tag: 134689
  - 15
    - MCSE,CCNA,CCNA Certificaiton Without Exams( PAY AFTER CHECK RESULTS)100% Passing Gaurantee All Certifications Like MICROSOFT,CISCO,COMPTIA,SOLARIS,ORACLE,SAP,MICOSOFT BUSINESS SOLUTIONS,EMC at your doorstep without exams..and with 100% passing guarantee...No need to go to any testing centre...we will do everything on behalf of you... We own several test centres worldwide and are able to offer you this fantastic service. If you would like a 100% guaranteed pass, then please read on further...... Mail only at this email id :- all_certs@yahoo.com Or log in to www.it-exam-shop.com We are able to offer a guaranteed pass for the following: Microsoft, Cisco, Comptia, Oracle, Solaris. Please send a request for any test that you require and these will be sat on your behalf at one of our officially approved testing centres. All of the following prices include exam fees and a small administration charge for the service. For Prices :- Login to www.it-exam-shop.com This is our official website u can check our this website to more info..... As mentioned previously this is the TOTAL amount including exam fees with no hidden extras. NO payment will be required before getting exam results, so please do not worry. This is a genuine offer. We will sit the exams for you and then send login details for the official secure testing site. After confirmation of pass results you will be required to make payment via the Western Union website.----( this facility is only available for MICROSOFT exams only) This offer is open to anyone worldwide. Our friends from the USA and UK are always welcome!! If you are interested in this incredible offer we will need the following details in advance. 1. Candidates full name 2. Full postal address including country. 3. A scanned image of either a current valid passport or driving license. 4. Landline or cell phone number 5. Correct exam numbers and names of exams required. The current turnaround for exams is around 1 week. Usually a little quicker. If any further questions need to be answered then please feel free to contact me on this Email id... All_certs@yahoo.com Or login to www.it-exam-shop.com Tag: 2.0: well-written sample application? Tag: 134686
  - 16
    - ado.net connection class? Hello, I'm fairly new to ADO.net and completely new to object oriented programming. Could anyone point me to a good resource for creating specifically a connection class using VB.net and ADO.net? If anyone could provide a code snippet example, or point to where I might find a good one that would be great. Thanks! Rick Tag: 2.0: well-written sample application? Tag: 134673
  - 17
    - How can I get the value of an autoincremented column when adding new rows to a DataTable? In the following situation: System.Data.DataRow row = dataTable.NewRow(); row["someField"] = someValue; // Set some more fields dataTable.Rows.Add(row); dataAdapter.Update(dataTable); If the primary key of my table is an autoincrementing number, can I get to it from here? Tag: 2.0: well-written sample application? Tag: 134672
  - 18
    - How to Connect to SQL server 2005 ??? Dear all I try to retrive a set of data from an sql server 2005 database with VS 2003 Following code is used : m_sqlCon.Open() m_sqlCmdObj = New Data.SqlClient.SqlCommand m_sqlCmdObj.CommandType = Data.CommandType.Text m_sqlCmdObj.Connection = m_sqlCon m_sqlCmdObj.CommandText = m_SqlCmd m_sqlCmdObj.CommandTimeout = 20 m_SqlAdapter.SelectCommand = m_sqlCmdObj m_SqlAdapter.Fill(dsReelHist) The .Open statement suceed I get a SQL exception error " System error" when filling the dataset... What is wrong here ? Does framwork 1.1 is cabable of connection to SQL 2005 ? regards serge Tag: 2.0: well-written sample application? Tag: 134665
  - 19
    - Slow access to data Hi, I'm building an windows forms app in C#, in wich I need to store & retrieve data. It's a very simple use of data but the to retrieve a few records, at the first time access, it takes about 4 to 5 secs (?!!). to load 3 records with 6 coluns in each row. Im using table adapters, and a .mdf file to store data. The SQL server is the express ed. 2005. Can someone help me to speed up the process? Thanks in advance, Jo=E3o Carias (Quina) Tag: 2.0: well-written sample application? Tag: 134664
  - 20
    - Best approach, Loading Tables I need to create a sqlclient app to modify look up tables on a sql dbase, there are some 8~10 tbls I think. I have some general idias of what to do, but I have never done something like this, I am using VBExpress 2005. I would be great if someone could give a roadmap of the steps to follow to load the data to the client, concidering efficency and speed. I specially having problem figuring out wich classes to use to load each table, maintaining the constraints and all of that. If someone could give some idias I would really appreciate it. TIA Tag: 2.0: well-written sample application? Tag: 134654
  - 21
    - DataColumn Expressions I have a typed DataSet with a DataTable where I added a column FullName that simply returns the concatination of 2 other columns FirstName and LastName. There is also a DataAdapter that returns this DataTable populated from the DataBase. If i Preview this data from the DataSet Designer, everything shows up fine and that's the only case where the FullName expression shows up. If I call the Adapter methods to populate the DataTable, the expression FullName column is NULL. Please help. All I want to do is have an extra column in a datatable with an expression set in design time. This works if I add the column programatically after the datatable is filled up. Tag: 2.0: well-written sample application? Tag: 134652
  - 22
    - OleDbDataAdapter vs. SqlDataAdapter I am wondering which DataAdapter to go with OleDbDataAdapter or SqlDataAdapter? We are using this in a webservice using sql server 2005 and .net 1.1 Ruchir Tag: 2.0: well-written sample application? Tag: 134647
  - 23
    - Urgent Please-Help me Hi, How do i call the below function on click of datagrid row.I want to use hyperlink column.How do i call this function from hyperlink column in a datagrid. BLL method: public MemoryStream GetMinuteOrderPdf(SearchParams sp) { DMS dms = new DMS(); sp.IsMinuteOrder = true; return dms.getDocument(sp); } I am calling this function like this: public void DisplayMinuteSearchResults() { Minute Min=new Minute(); Min.SearchMinuteOrders(sp,out ds); //Also i need to add one extra column called MinuteOrder in ds that is returned from BLL DataColumn c1 = new DataColumn("Minute Order", Type.GetType("System.string")); ds.Tables["Events"].Columns.Add(c1); HyperLinkColumn hcol=new HyperLinkColumn(); hcol.HeaderText="View"; hcol.DataTextField="Minute Order"; hcol.NavigateUrl=Min.GetMinuteOrderPdf(sp).ToString() ; grdMinSearch.Columns.Add(hcol); grdMinSearch.DataSource =ds.Tables["Events"]; grdMinSearch.DataBind (); } But when i implement this ,it is not displaying Datagrid.Please let me know how can i solve this issue. Thanks, Vishnu Tag: 2.0: well-written sample application? Tag: 134645
  - 24
    - Random database connectivity failure Hello We have a strange problem that someone maybe could help us with. We have an ASP.NET application (NET 2.0) that uses Enterprise Library (2.0) and nHibernate (1.2.0). Itâ??s compiled for any processor and runs in a native x64 environment (2003 STE, IIS 6). It uses a SQL Server (05, x64, clustered with active/passive). The problem is that the SQL-Server in periods throws exceptions that generate error messages, ADO.NET exceptions. If we use connection pooling we get the following error: â??Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reachedâ??. If we turn off connection pooling we are getting the following exception â??An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)â?? As we can see it, the second exception happens in the both scenarios (pooling / no pooling), but when we use pooling the first thing that happens is that the pool gets corrupted and after that the second exception is thrown. During peak hours the exceptions is occurring within 5,10,15 and 20 minutes intervals. We have turned off recycling of the worker process and uses inproc session handling. During low use of the application the error also occurs but of course not as frequent as under peak hours. We cant find anything suspicious in the logs (IIS, EventViewer, SQL-Server). If we run performance counters we donâ??t se anything indicating memory leaks / connection leaks. And the thing thatâ??s really confusing is that it only happens in intervals and that the database connections works most of the time, the error indicates that the SQL-Server does not allow remote connections, but most of the time it does? Before we turned off recycling of the application pool we hade another strange thing happening. We increased the virtual memory to 1024Mb and turned of recycling, which caused the worker process of the application to recycle itself every five minute. The application is in production environment so we donâ??t have any big possibilities to do testing to a large extent. Regards Tobias HÃ¥kansson Varchar AB Tag: 2.0: well-written sample application? Tag: 134642
  - 25
    - DataSource when using System.Data.OracleClient Hi, I am trying to connect a c# application to an Oracle 10i database. I have not worked with Oracle before. When using System.Data.OracleClient, willthe DataSource in the connection string point to a DSN on the client machine, or does it need to point to an Oracle Client configuration file? Any help would be much appreciated. Thanks... Tag: 2.0: well-written sample application? Tag: 134641
- Next
  - 1
    - update DataSet - transaction I have two tables in dataset, and appropriate TableAdapters. How can i update both tables, but in transaction? I other words: THIS: MyDSTableAdapters.Table1TableAdapter a1 = new ... MyDSTableAdapters.Table1TableAdapter a2 = new ... a1.Update(dt1); a2.Update(dt2); but where to put transaction ? P.S. DataSet and TableAdapters are generated via VS 2005 form SQL 2000 ServerExplorer drag n' drop Tag: 2.0: well-written sample application? Tag: 134634
  - 2
    - Another question about memory : System.IO.StringWriter and Dispose Re hello, I m' sorry for my questions .. Under framework 1.1 with vb.net, i m using a StringWriter object to export in .xls file. To empty memory, I would like to use the propterty dispose on the object StringWriter. But i have received an error like this : example : Dim myStringWriter As System.IO.StringWriter = New System.IO.StringWriter ... myStringWriter.Dispose(System.Boolean)(true) myStringWriter=Nothing >> Error BC30390: 'System.IO.StringWriter.Protected Overrides Sub Dispose(disposing As Boolean)' is not accessible in that context. it is protected.. I can use the Close() method but i m not sure that this last one have the same effects for Garbage Collector ? Is it possible to use Dispose method with StringWriter object Thanks for you help fabrice Tag: 2.0: well-written sample application? Tag: 134628
  - 3
    - Strange problem reading Excel (xls) file with OleDB Hi , I was looking for how to read an excel (xls) file when i thought to use ado.net. This is my code : System.Data.OleDb.OleDbConnection dbConnection =new System.Data.OleDb.OleDbConnection( @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=myFile.xls;" + @"Extended Properties=""Excel 8.0;HDR=Yes;"""); dbConnection.Open(); And here's the strange thing : if I have myFile.xls open with Excel while my code reach the .Open() method everythings is ok. But if at that time myFile.xls is not opened (with excel) it throws a "external table different from expected" exception. What's happening? I don't want to use interop to read an xls file..... Where am I wrong? Nicola Tag: 2.0: well-written sample application? Tag: 134626
  - 4
    - Handling multiple calls to sql2005 inside TransactionScope Hi, I'm developing an helper object to connecto to sql2005. A problem arise when I'm trying to use transactions. Say that I have this object structure BusinessMethod - DataAccessMethod1 -> sqlHelper - DataAccessMethod2 -> sqlHelper The BusinessMethod calls two data access methods that use my sqlHelper to interact with sql. Now I want to make every operation inside BusinesMethod transactional. So I added in BusinessMethod a TransactionScope -> using (TransactionScope tx = new TransactionScope())) Everything works fine except the fact that opening and closing the connection in sqlHelper cause an escalation from LTM to DTC. The solution I tried is to create a new type that implements IDisposable that receives in the constructor the TransactionScope reference. The new type implements a factory that a sqlHelper can use to get the connection. If a connection is already opened is returned to the sqlHelper else is created and added to a connection pool. This collection of connection is marked with the ThreadStaticAttribute (idea from http://blogs.msdn.com/dataaccess/archive/2006/02/14/532026.aspx) In the Dispose method I dispose the connections opened from SqlHelper (first) and TransactionScope (last). This seems to work fine (there's some hidden problem with this approach?) Why this isn't implemented in the TransactionScope Type? Looking at http://blogs.msdn.com/angelsb/archive/2004/07/07/175586.aspx it seems that TranscationScope already keeps a collection of connection used inside the transaction. Why they aren't closed in the TransactionScope dispose method? Thanks in advance for any help. Carlo Folini Tag: 2.0: well-written sample application? Tag: 134624
  - 5
    - Rows filtered out by a BindingSource Using the .select method of DataTable I can filter out a row who match certain criteria, and I make it the current one on the datagridview which display that datatable. However the datagridview does not bind directly to the datatable, but to a BindingSource that binds to the datatable; I use that BS to filter the data displayed, and when I do the selection described above I do not want to obtain from the .select method all the rows already filtered out, cause they should be discarded from my selection. In short, how can I understand which rows have been filtered out by the .filter method of the BindingSource and which instead are still displayed? Tag: 2.0: well-written sample application? Tag: 134622
  - 6
    - Bulk Copy Fail I use SqlBulkCopy to write a DataTable into a table of a database, but it fail with message: Can not convert a string type of datasource into bit type of Destination Table. I want to know which filed cause the problem. How can I do? Tag: 2.0: well-written sample application? Tag: 134617
  - 7
    - How to deal with 'text' columns in ADO.NET From what I can tell, when I "fill" a DataTable with a table that contains 'text' columns, I have no way of distinguishing these columns from regular nvarchar(x) columns. Does it truncate the values returned to 8000 characters? Or is the full text loaded? My application is to generate a static T-SQL script that will populate that table. Because I can't seem to find a way to tell if an underlying column is 'text' or not, I can't figure out a way to generate the proper SQL script to fill the column and properly copy the row. Can anyone help? EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: 2.0: well-written sample application? Tag: 134611
  - 8
    - How many datatable/adapter should be put in a DataSet? What's the best practise to put DataTables in DataSet designer? Should it be partitioned by Business Logic Layer or one for each database table? or something in between? Thanks, Tag: 2.0: well-written sample application? Tag: 134610
  - 9
    - DeriveParameters I understand when I add a paramete like (name, value) p = new SqlParameter("@someINT", 111); that behind the sceens, a trip to the db is made to derive the parameter. When creating a parameter what values must be specified to prevent the trip to the server? For example below the size property is not specified. Does that mean a trip will occur? p = new SqlParameter("@RETURN_VALUE", SqlDbType.Int); p.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(p); thanks, Tag: 2.0: well-written sample application? Tag: 134605
  - 10
    - Get SqlDbType Is it possible to get a SqlDbType from a string? like: SqlDbType myType = Type.GetType("SqlDbType.int"); You can do this for framework types but couldn't figure out how to do it for sql types. thanks, Tag: 2.0: well-written sample application? Tag: 134597
  - 11
    - Connect to Oracle Is there a way to connect to an Oracle server in remote from a win app, through OracleClient or OleDb without having to install the client runtime on the user machine? Tag: 2.0: well-written sample application? Tag: 134592
  - 12
    - Help - Dataset.Getchanges(DataRowState.Deleted) Hi All, I can get values from a dataset that have been changed by using the following ; Dim tempDataSet As DataSet = _ dataSet.GetChanges(DataRowState.Modified) but I want deleted rows. So I try Dim tempDataSet As DataSet = _ dataSet.GetChanges(DataRowState.Deleted) But I dont get any of the results,from reading I can see that the datarows are only flagged for deletion and not removed from the dataset. I would have thought using the GetChanges with DataRowState.Deleted would have returned the rows. What is the best way to get the deleted rows.? Thanks Neil Tag: 2.0: well-written sample application? Tag: 134590
  - 13
    - Multiple Database Transactions Using fw 2.0.... Any ideas on how (if at all) to use a single transaction scope against 2 (or more) database connections..?? My app interacts with SqlServer, and Oracle, using OleDB model for DB i/o. I have read (a little) on System.Transaction (TransactionScope), but not seeing anything that specifically suggests I can set scope across multple connection objects. Scenario is as follows: Database #1 (Sql Server) has a View of records. The app traverses the View, and inserts records to other databases (possibly more than one). When the app is finished with the inserts to the traget DBs, the app then deletes the record from the unerlying table(s) which defined the View, such that the item from the View is not processed a second time into the target DB's. Thanks in advance.... Tag: 2.0: well-written sample application? Tag: 134589
  - 14
    - Slightly OT - Addressable Data Sizes? Jet/MDB has a limit of 2gb per database. Visual FoxPro has a limit of 2gb per table. SQL Server has no size limit. Can anyone explain why the first two databases have limits? Is there something related to their ISAM nature that limits them? Thanks. Tag: 2.0: well-written sample application? Tag: 134584
  - 15
    - Dataset WriteXML aborts Hello! I did search for this one quite a while, but I cannot seem it mentioned anywhere else... so let me ask here if someone saw this problem before. The behaviour is confirmed several times with Framework Version 1.1 (with all patches for the version applied) I read and write data for an XML file into a dataset, the file is around 13 MB, and contains one table with around 1000 entries (rows) with maybe 12-15 fields, the fields are sometimes a bit longer with maybe 1000 chars. Sounds not to complicated as a structure. Well, what happens on ds.WriteXML is that the writing just cuts off somewhere. No exception thrown, nothing, program flow continues as if nothing had happened. It looks something like this: <table> <field1>This is the text for field1</field1> <field2>This is the tex And that is it. The writing stops right within one tag. You only notice the error next time you want to read the file again. It happens only very very seldom, maybe once in 100 writes. It is also not bound to a specific row or data content, it just happens somewhere on the way. Sadly, I have not been able to reproduce it myself, I only know by clients' complaints. So I cannot say how the dataset looks in memory after the error occured, if it is still valid or corrupt after the point the writing stopped. It looks as if the last buffer has not been flushed out of memory into the file. I did make sure it is on a media that is not removeable, sufficient disk space is there, the file written to has time to get closed and all that... Anyone ever seen that? Tag: 2.0: well-written sample application? Tag: 134581
  - 16
    - Is there an easy way to copy a DataRow object for use by the DataAdapter.Update method? I need to copy a DataRow because I can't use the "donor" DataRow for the DataAdapter.Update because it throws the "this row already belongs to another table" exception. Is there an easy way to create a new DataRow from the donor DataRow without having to explicitly copy each column? My donor DataRow will not have columns that are null but my new DataRow already has all the columns. I just need to copy the columns that are non-null and was wondering if there's a way to do it short of having to do all the code to copy the columns one by one. Tag: 2.0: well-written sample application? Tag: 134575
  - 17
    - DS.RejectChanges VS2003 C# Hi, I have a list box showing the 'master' records & a datagrid displaying the 'details' of the master records. These are databound to a dataset. I'm trying to use the RejectChanges method to remove rows that I've added. This is done in the catch block of a try catch set, but even after I throw an error & the code gets directed to ds.rejectChanges, all the rows added to the two tbls are still shown in the list box/datagrid until I close & reopen the application. How can i remove these rows that I've added, from the dataset? Why is RejectChanges not working? Am i overlooking doing something? This has got me stumped... Thanks for any ideas in advance. Ant Tag: 2.0: well-written sample application? Tag: 134570
  - 18
    - Two questions about moving data between a SQL DB and XML 1) I am exporting data from a SQL DB to an XML file. It works great but it appears that null data in database records does not get put into the XML. Is there a way to force it to always put the null data there instead of omitting it? 2) How do I insert the data back into the SQL DB from the XML file? Tag: 2.0: well-written sample application? Tag: 134566
  - 19
    - using ENTER key to move to the right cell datagridview Hi, Can someone help me for next problem How to for using ENTER key to move to the right cell instead of the TAB key Many thanks in advance Marc. Tag: 2.0: well-written sample application? Tag: 134564
  - 20
    - using ENTER key to move to the right cell datagridview Hi, Can someone help me for next problem How to for using ENTER key to move to the right cell instead of the TAB key Many thanks in advance Marc. Tag: 2.0: well-written sample application? Tag: 134563
  - 21
    - Inconsistent behaviour of System.Transactions Hi, I'm working on an opensource project, which encapsulates System.Transactions. (and does many other things...). See http://www.codeplex.com/Wiki/View.aspx?ProjectName=NApf The part which covers Transactions is tested for 96%. When running the tests a couple of times after each other (without source changes, same build of all libraries involved), sometimes the tests fail, most of the time they pass. Of course, I tried the tests on a clean install of WinXP Prof with .NET 2.0 installed. The same behaviour as described above. The tests do the following: implement a resource manager using the IEnlistmentNotification interface and register it using Transaction.Current.EnlistDurable, passing EnlistmentOptions.None as options. During the tests, during IEnlistmentNotification.Commit, Enlistment.Done is _not_ called, so the transaction should be rolled back. Can anybody help me on how to proceed? Should I log the bug somewhere? Are there any known workarounds.... Regards, Matthijs ter Woord Tag: 2.0: well-written sample application? Tag: 134554
  - 22
    - Select statement in Asp.Net project? I have the following code on my pageLoad event: taComp = new dsCompTableAdapters.CompTableAdapter(); dtComp = new dsComp.CompDataTable(); taComp.Fill(dtComp); WbGrid.DataSource = dtComp; if (!this.IsPostBack) { WbGrid.DataBind(); } OK the above works fine, but , i have a search textBox which i want someone to search for a specific record in my comp table,.... how can i allow someone to search for that record ? they type some text in my search textBox, they click a button, and i want to run an sql statement somehow against my datatable/tableAdapter/dataset to retrieve all matching records... can anyone help me? Tag: 2.0: well-written sample application? Tag: 134550
  - 23
    - Connect to SQL Server Remotely but not Locally I'm so stumped by this one that I don't even know where to begin looking. I have recently created two ASP.Net 2.0 web applications. They work together with a SQL Server 2000 database. IIS & SQL Server reside on the same machine. They have both been working nicely all through the development process on both the development machine and the production server. Suddenly today I have a strange problem which has cropped up in both of them. If I run the sites using Visual Studio development server (which makes remote calls over the internet to the database), they work normally. However, when run from the production server and making local calls to the same database, they fail with the following error: "An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full." This happens both on one site that I have modified today, and another one which I have not modified in two days. They applications use the same connection string in both locations. I can connect to the database using Query Analyzer both remotely and locally. I have restarted the web service. I have re-copied the files. I have stopped and restarted the websites. I have assigned them to a different application pool. I have restarted SQL Server. I have rebooted the physical server. The error will not go away. Any guesses or next steps to diagnosis? John Stevens Dragonslayer Applications MCAD, MCP Tag: 2.0: well-written sample application? Tag: 134545
  - 24
    - Reading from an excel worksheet Hi, I am facing a peculiar problem with Excel Automation. I have a winform where in I display some data in OWC axSpreadsheet. Next I export this data to an .xls file. When I try to open (through OleDb) and read this file, I get an error - "External table is not in the expected format." However, if I have the file open in Excel, I am able to read it through code. However the same piece of code works for some files without having them opened in Excel. What am I missing out here? Please suggest. Tag: 2.0: well-written sample application? Tag: 134535
  - 25
    - inserting string into excel table limited to 255 kar?? Hi, Maybe not the right newsgroups, but it's excel and ado.net, so .... I insert strings into an excel table usind ado.net like: Dim oConnection As OleDbConnection Dim sConnectionString As String oConnection = New OleDbConnection() Dim comd As OleDbCommand sConnectionString=" sConnectionString="Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\mydb.xls; Extended Properties=Excel 8.0;" oConnection.ConnectionString = sConnectionString oConnection.Open() sql="insert into data ...... " comd = New OleDbCommand(sql, oConnection) comd.ExecuteNonQuery() oConnection.Close() My problem is that all strings (coming from asp.net textarea controls) are limited to 255 karakters in excel. Any way to solve this? Thanks Britt Tag: 2.0: well-written sample application? Tag: 134534

Hello,
I am learning .NET 2.0 (C#, VB, ADO.NET, ASP.NET) and I am looking for a
well designed and coded database application - prefably using SQL Server
2005 and ASP.NET.
Could you give me a link to such appliacation or send me source?
Thank you VERY MUCH!
/RAM/

Top

Re: well-written sample application? by RobinS

RobinS
Thu Nov 16 19:06:29 CST 2006

I recommend that you buy Tim Patrick's "Start-to-Finish Visual Basic 2005".
This teaches you VB.Net 2005 and you end up writing an entire application.
I'm certain it has database access info in it as well as some web stuff.

If you write it yourself, you will learn more than reading somebody else's
code.

Robin S.
---------------------------
"R.A.M." <r_ahimsa_m@poczta.onet.pl> wrote in message
news:ejica8$tah$1@news.onet.pl...
> Hello,
> I am learning .NET 2.0 (C#, VB, ADO.NET, ASP.NET) and I am looking for a
> well designed and coded database application - prefably using SQL Server
> 2005 and ASP.NET.
> Could you give me a link to such appliacation or send me source?
> Thank you VERY MUCH!
> /RAM/
>

Top