Browse by Tags

Related Posts

  • Re: Return a DataReader - Is this good practice?

    [quote user="ElCapitan"]...Yeh I understand that this is a good way of doing things too but not without its drawbacks. Many hits to a page that constantly calls a couple of hundred 'rows' of business objects will be much heavier on the application surely because all the data is 'in...
    Posted to Architecture (Forum) by SergeyS on 03-24-2008, 12:00 AM
    Filed under: scalability, SQL Server 2005, 3-Layer Architecture, 3tier, 3-Tier Architecture, 3-tier programming, asp .NET 2.0, Basic Architecture Design, Best Practices, bll, Buisness layer, business logic layer, Connection pooling, dal, data access layer, datalogic layer, dataobjects, Dataset, dataset datareader 3-tier mvc, datatable, database object, asp.net2.0, ASP.NET Architecture, sql server, Typed DataSet tableadapter, arcitecture, asp.net 2.0 sql server, datareader, load balancing, Patterns & Practices, N-Tier, Asp.Net 2.0
  • Re: Return a DataReader - Is this good practice?

    [quote user="ElCapitan"]...The function in the DAL is called by the BLL and the DAL opens a connection, and the command does an ExecuteReader. I understand that it is a good option for retrieving data. Surely though if the dr is returned to the BLL, the connection is still open...[/quote] It's...
    Posted to Architecture (Forum) by SergeyS on 03-22-2008, 12:00 AM
    Filed under: scalability, SQL Server 2005, 3-Layer Architecture, 3tier, 3-Tier Architecture, 3-tier programming, architecture, asp .NET 2.0, Basic Architecture Design, Best Practices, bll, Buisness layer, business logic layer, dal, data access layer, datalogic layer, dataobjects, Dataset, dataset datareader 3-tier mvc, datatable, database driven, database object, asp.net2.0, ASP.NET Architecture, Typed DataSet tableadapter, "system Design", arcitecture, asp.net 2.0 sql server, datareader, N-Tier, Asp.Net 2.0
  • Accessing SQL Server Database through XML Scema

    Hi, I have a file Data.xsd in my ASP.NET 2.0 project. It contains a table called "cnt_mstr", I have configured it to Fill by queries, now when I execute the following code it does not inserts in the database and niether it shows it in the GridView. Here is the code on Button Cick, Data . cnt_mstrDataTable...
    Posted to Data Access and ObjectDataSource Control (Forum) by amrhsn on 11-07-2007, 12:00 AM
    Filed under: UPDATE, .NET 2.0, ADO.NET data access, c#, data access, dataset, Datatables, XML SQL, asp.net2.0, .NET SQL Server 2000, ASP .NET 2, app_code, data access insert mssql
  • Employee Attendance Application

    Hai to all I'm new to asp.net. I'm creating Employee Attendance Details application in Asp.Net with C#, which is a Windows application. I have searched in internet regarding this application. But I'm unable to found it. If any one knows this application, please provide me the link. Thanks...
    Posted to Free For All (Forum) by sureshkumar.veesam on 10-24-2007, 12:00 AM
    Filed under: 3rd Party controls for asp.net, ASP.NET, Asp.Net 2.0, asp.net 2.0 asp.net, asp.net 2.0 Template Field, Data Grid, database, DataGrid, Datalist control, dataset, folder, FormView, Interview Questions, javascrip, javascript code behind, Localization, Login Control, LoginView, Master page, Membership, Menu, menu control, MultiLanguage, Asp.NET2.0, grid view, GridView, ASP.NET Sites, .NET Framework 3.0, Asp.Net 1.1
  • How to copy data from one excel file to other excel file

    Hi I have two excel file (Ex1 and Ex2), both have same template (headers) and data will be populated from the dataset. Upto this step its works fine. My question : How to copy the data form 6th row to last row of "Ex2" and paste it into the "Ex1" after the last row in Ex1. Advance...
    Posted to Enterprise Services Integration (Forum) by SudhaYogesh on 09-12-2007, 12:00 AM
    Filed under: postback variables, querystring, selection, sql, sqldatabase, t code behind, update, VB.Net, ado.net, asp, ASP.NET, Asp.Net 1.1, Asp.Net 2.0, Asp.Net 2.0 and MS SQL Server 2005, asp.net 2.0 asp.net, asp.net 2.0 export to excel, Asp.Net 2.0 session, ASP.net 2.0 Tutorials, ASP.NET Sites, ASP.NET.NET 2.0, c#, C# code, database, datareader, dataset, datasource, excel, GridView field, Asp.NET2.0, grid view, reports, DotNet, Find Control
  • Performance - Which way is faster to select a row in a DataTable?

    Assuming that we "know" that we will always receive a single row on a table select, is this faster? Private Sub MoveData() Dim ColumnName As String = "some value" Dim ColumnValue As String = "some value" Dim objRow As DataRow For Each objRow in MyTable.Rows objRow( "ColumnName"...
    Posted to Getting Started (Forum) by hismightiness on 05-25-2007, 12:00 AM
    Filed under: .Net 2.0, approach, asp.net 2.0, asp.net 2.0., Best Practice, data, data access, data handling, data manipulation, dataset, datatable, DataTable.Select Method, asp.net2.0
  • How to transform XML to wellformed XML using XSLT ?

    HI I have the below XML generated from dataset , but some of the elements (columns) missing because of empty value in the database. So I have to use XSLT to transform the xml to xml to have the emptyelements. Please someone giude how do I start XSLT for the below XML structure. It is a table about the...
    Posted to XML and XmlDataSource Control (Forum) by SudhaYogesh on 09-04-2009, 12:00 AM
    Filed under: xml, XML DataSet root element writexml readxml, element Xml load only after focus, xml include schema, DataTable.GetXml, flash xml, ASP.NET, XML control, xslt, XML deserialize deployment, kml xsl xslt xml xpath string functions, xml import, xml database, XML DropDownList control DataSource XmlDataSource, XML Copy, Asp.net XML, DataSets, xml data editing, xml data, XML datatype column, editing xml data in xml datatype column, datset, xml appearace, dataset, XML document, asp.NET 2.0, xml attribute xmltextwriter, XSLT Transformation javascript, Read xml file, XSLTContext, XML fragment, XML caching, .NET 2.0, Datatable, xml in .net, asp net 2.0, asp.net2.0, Writing XML, Creating XML string, asp.net 2.0 xml, xslt xml, XML default namespace, xslt asp.net control event, WriteAttributeString, database, Also i tried with the sourcecode that u have put above but when the program executes the following path doc.Load(Server.MapPath("lab.xml")), xml data file translation, ByteArray[] to XmlDocument [Edit Tags], ByteArray[] to XmlDocument [Edit Tags] [Edit Tags] [Edit Tags], write xml, xml explicit ordering, xslt visual studio 2008 xhtml validation, xml edit, sitemap xml xmldatasource treeview NavigationUrl valuetext, sqll and xml, innerxml, edi to xml, c# datatable datasource readxml readxmlschema xmldocument, XML events, xml data into database sql, child nodes, FOR XML EXPLICIT sqlparameter DataSet, ADO/XML, XML datagrid asp.net, XML data source, xml grid datagrid gridview, count XMLDataSource, empty element xmlwriter formatting full element writefullendelement, XML encoding/decoding, xml gridview repeater subitems, generating XSLT, Insert Data Into Multi-Level XML file, Excel XML Formula WorksheetOptions Worksheet Table Row Cell Data Styles, DOM, reading xml and dataset, XSLT 2.0, XSLT implementation, exslt, xml and XmlDataSource Control and Gridview inside GridView, XML and XmlDataSource Control Gridview Master Detail
Page 1 of 1 (7 items)