.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Beginner's book for ado.net 2.0

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net


Can anyone suggest me a book for beginners in ADO.NET 2.0 ? 

View Complete Post

More Related Resource Links

Beginner: this doesn't make sense to me


Do you need and "empty" script tag in the head to run scripts that are in the body?  Also, can you run JQuery scripts if they're in the <head> tag?  The first sample only works if the JQuery script is in the form (and body) tag, not in the head - even if I add $(document).ready(function() { });

This works

<head runat="server">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" />
<script type="text/javascript">
<form id="form1" runat="server">
<a href="">Here is a link</a>
<script type="text/javascript">
$('a').click(function () {
alert("you clicked me!");


This doesn't work.  Notice I removed the second <script> tag from the head

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="serve

Mobile beginner's inquiry


I've developed web applictions in VB in VS2005 pro and want to get started on developing mobile applications in VB now that I've upgraded to VS2010 pro.  It's proving to be more difficult to get off the ground than I expected.  It would seem that there have been several toolkits for developing mobile applications since NET 2.0 -- some obsolete -- and the web refences I've been going through seem to be a mishmash of broken links, circular references and dead ends.

When I click on toolbox -> choose toolbox items, all of the system.web.ui.mobilecontrols are there.  But they never turn up in my toolbox.  And I can't find a way of beginning a  mobile website project, either.  Nor can I find any examples of mobile ASP.NET development in either the samples included with VS2010 or online at http://msdn.microsoft.com/en-us/vstudio/dd238515.aspx

My needs are simple: can somebody tell me what additions or configuration changes I need to make to prepare my VS2010 setup for working with ASP.NET 4.0 mobile controls?  And once this is there any good tutorial for learning mobile website develpment that doesn't involve contracting with a third party?  How about a good book for learning the CURRENT tec

Writing a Telephone Book / Corporate Phone Directory...

Hey everyone, I'm attempting to write one aspx page (vb.net back end) that pulls the following using an LDAP query from my active directory and dumps it into either a datagrid or a gridview control.  The fields I want to show from Active directory are;  1. Last Name 2. First Name 3. Office 4. Email 5. Telephone number (primary) 6. Mobile  7. Title 8. Department 9. Company ---- I only want to show the "active" users and then again, dump the results in a dataset and populate a datagrid / gridview control.  Does anyone have any sample code of this or can walk me through on how to do this - thanks in advance... Best regards, Ryan  

Book review: Patterns of Enterprise Application Architecture

   Lately I finished reading the famous patterns book by Martin Fowler - Patterns of Enterprise Application Architecture. This book introduces and describes design patterns you will usually see when building enterprise applications. There are also examples for patterns and although they are simple and primitive they give you the idea how to implement or use specific patterns. If you are working on enterprise applications every day you will find this book very useful and I'm sure you will use it as manual. Yes, you can read this book as any other book and you can also use it as manual. In the end of this review you can find table of patterns with links to short introduction for each pattern. Are these patterns platform specific somehow? No, they are not. It doesn't matter what platform or language you are using. Of course, you must know your platform well because some of problems solved in this book maybe also already solved on platform you are working on. Don't try to push all available patterns to your application - use patterns of this book when you face problems that your tools doesn't solve or that your tools solve poorly. Of course, you can consult with this book if you are not sure how to implement one or another pattern in your application. My suggestion is to read this book with two other books (of course, there are more recommended books but le

SharePoint Beginner

Hi What do I need to do to start developing in sharepoint locally? does it work like Visual Studio where I can develop a site locally and then deploy it to a server? what do I need to have installed on my PC?   Thanks in advance

I need a workflow triggered by a workflow...how do I design this? Beginner question

I've added the Approval workflow to a forms library and it generates the necessary tasks and emails for 2 levels (serial) of Approval on the form. When the form has been approved the 2nd time, I want it to trigger another workflow that notifies a 3rd person of the existence of the form and assigns her a separate non-approval task. I'm creating it in SharePoint Designer, and I can do most of it, but I'm not sure what field I'm looking for, at the beginning in order to start the workflow. Currently, there is no column for Approval Status in the form library, only a column that shows the status of the workflow (In Progress or Approved).  I tried If Workflow Status equals Approved then email.... but that didn't work. Any help is greatly appreciated.  I'm looking for the data source field and the list item field and value, I guess.  

Beginner question about eliminating Dups

I looked at a couple of links about eliminating dups. One  link suggested RowNUmber() function which is fine for 2005 (but I wanted something that would also work on 2000).  Another link was a MS article advising to select the dups into a temporary table. http://support.microsoft.com/kb/139444/en-us I found this article confusing, and I don't see why it suggests we need a holding table. So I propose this approach - is there any reason NOT to do it my way? (Is there a bug here I'm overlooking?) IF EXISTS(SELECT 1 FROM sys.tables WHERE NAME = 'Facilities' ) DROP Table dbo.Facilities; CREATE TABLE [dbo].[Facilities] ( [ID] int IDENTITY, [FacNo] varChar(3) , [theState] varchar(2) ) INSERT INTO Facilities ([FacNo], theState)VALUES ('1', 'FL') INSERT INTO Facilities ([FacNo], theState)VALUES ('7', 'FL') INSERT INTO Facilities ([FacNo], theState)VALUES ('25', 'FL') --- DUPLICATE THE FIRST THREE ROWS INSERT INTO Facilities ([FacNo], theState)VALUES ('1', 'FL') INSERT INTO Facilities ([FacNo], theState)VALUES ('7', 'FL') INSERT INTO Facilities ([FacNo], theState)VALUES ('25', 'FL') -- ADD some new rows. INSERT INTO Facilities ([FacNo], theState)VALUES ('4', 'VA' ) INSERT INTO Facilities ([FacNo], theState)VALUES ('5', 'VA' ) INSERT INTO Facilities ([FacNo], theState)VALUES ('10','Va') INSERT INTO

Trying to build query using DISTINCT or GROUP BY...beginner here

Hi all, I have a table with the following format: instanceID    timeStamp  stepID 28B2D4FB-67F6-40CA-84A2-839BF3CC4B91 2010-09-07 20:36:32.807 1 28B2D4FB-67F6-40CA-84A2-839BF3CC4B91 2010-09-07 20:36:33.807 2 28B2D4FB-67F6-40CA-84A2-839BF3CC4B91 2010-09-07 20:36:34.807 3 ... EADD3AAA-5E93-4311-A844-9A7BE53A9606 2010-09-09 22:18:25.757 1 EADD3AAA-5E93-4311-A844-9A7BE53A9606 2010-09-09 22:18:26.773 2 so I need to build a query which will return 1 instanceID and all its stepIDs in one row. So the results would have to be something like this: instanceID    timeStamp  StepIDs 28B2D4FB-67F6-40CA-84A2-839BF3CC4B91 2010-09-07 20:36:32.807 1,2,3 EADD3AAA-5E93-4311-A844-9A7BE53A9606 2010-09-09 22:18:25.757 1,2 and if possible I would like to specify something like...bring me the data where 'timeStamp' > 2010-09-07 20:35 ps: I tried using DISCTINCT and GROUP BY but could not reach the desired results. Thank you!JCD

Book to learn and Develop enterprise application using InfoPath with workflow in MOSS 2007

Hi all, I'm new to infopath forms and i dont find much articles to develop enterprise application (I'm coding for an ERP module). I have sys environement of MOSS 2007, windows 2008 (64 bit), MS SQL 2008  Though it is easy to design and publish form to a site,  devloping the form with more business rules and validation seems to be vague for me. So please refer a good book to find the deveopment procedures to master Infopath with workflow integration. it is quite urgent. Thanks Gomathi Sha   sharepoint development

101 question - New to VS 2010, create connection string to perform test with Oreilly txt book

Hello, I have installed VS 2010 Ultimate and it came with SQL 2008.  I am trying to figure out what version it is and also how to create a connection in place to keep using the Oreilly examples to hopefully learn how to develop in C#.  I have been learning but it is getting more difficult.   I try to follow the steps but it just does not make sense.  If anyone could provide some easy steps to check version and connection method to sql using 2010, I would be grateful. I did see a post for sql management(http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en).  I am going to download to hopefully be able to view the database.  We have sql server 2008 at work and I have used the studio management for sql to run queries and would like to do the same with the version that was installed with the installation of 2010 ultimate.Hopefully I can get the connection to the database so I can start learning how to build a dictionary and list for some queries.  My goal is to create a aspx file that will show entries in a database we have at work.  Trying to take baby steps.Thanks for the help.

Got error in Pro Asp.Net MVC Framework book's example

[InvalidOperationException: An error occurred when trying to create a controller of type 'WebUI.Controllers.ProductsController'. Make sure that the controller has a parameterless public constructor.]Got this error after registration castle windsor, here my codeusing System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using DomainModel.Abstract; using DomainModel.Concrete; namespace WebUI.Controllers { public class ProductsController : Controller { private IProductsRepository productsRepository; public ProductsController(IProductsRepository productsRepository) { this.productsRepository = productsRepository; //temporary, later use IoC /* const string connString = @"Server=.\SQLEXPRESS; Database = SportStore; Trusted_Connection = yes;"; productsRepository = new SqlProductsRepository(connString);*/ } public ViewResult List() { return View(productsRepository.Products.ToList()); } } } and this my part of web.configconfigSections> <section name="castle" type="Castle.Windsor.Configuration.AppDomain.CastleSectionHandler, Castle.Windsor" /> </configSections> <connectionStrings> <add name="ApplicationServices"

Implement Google Book functionality??

I would like to implement Google Book functionality similar to http://www.billboard.com/archive#/archive ??Functionality Similar to http://www.billboard.com/archive#/archivearchive#/archive?I couldn't find the code in google api's. Requirement as IT IS from billboard,1) Search Box2) Scroll bar with magazines archive [Ebony Magazine Collection]3) on click on the magazine in the scroll bar should bring up viewer at the bottom of the page.

in need of sql 2005 e-book on store procedure

i need e-book on sql 2005 express on STORE PROCEDURE TUTORIAL including how to use IF AND ELSE STATEMENT in SQL

New book: Ultra-Fast ASP.NET


My new book has been released:

Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable Websites Using ASP.NET and SQL Server

An eBook is also available from Apress.

If you have a chance to take a look, I would be very interested in your feedback.

Permissions Beginner


Hi All,

I've been using basic SQL Server tools for a couple of years now and i'm having to administer my first database now.

I have a completely stand-alone machine with 2 user accounts - Admin and User.

I've developed 7 executable applications, 6 of which are available to the User and all 7 of which are available to the Admin.

I'm assuming that when the User runs one of the executables, the executable assumes the same access rights (i.e. at the moment, the application does not find the database). I Think I have set the User account up as a valid SQL Server Logon via the Security / Logins / New Login... option from the object explorer, however I'm not sure how to restrict them to only Insert, Select and Connect securables - it seems that all I can update is the securables for the server, not the database its self.

I would search the internet for the answer but I'm not sure of the specific terminology to search for.

Thanks in advance



Error Message Implementing AdminCategories.aspx - book Beginning ASP.NET E-Commerce in C #



I'm following the book "Beginning ASP.NET E-Commerce in C #, and I can not move because I get an error.

I'm trying to work some days and I can not solve.

I'm on page 325, "Implementing AdminCategories.aspx" in GridView.

When I debug,
appears a error message.

Procedure or function 'CatalogGetCategoriesInDepartment' expects parameter '@ DepartmentID' Which was not supplied.

Detalhes da Exceção: System.Data.SqlClient.SqlException: Procedure or function 'CatalogGetCategoriesInDepartment' expects parameter '@DepartmentID', which was not supplied.

I've already made that part several times, I always get the same error.

I have this.

    //retrieve the list of categories in a department
    public static DataTable GetCategoriesInDepartment(string departmentId)
        //Get a configured DbCommand object
        DbCommand comm = GenericDataAccess.CreateCommand();
        //Set the stored procedure name

Beginner in using Rest web services


Hi All,

I have a site that contains all the information about the employees of my company. They gae me documentatation to access. Please see below.

I am really confused.

1. Ask your  administrator to request a Service Account with appropriate privileges. - Done

2. Use your web browser to explore the read-only web services. Start by downloading the most
recent version of this document from the Documentation Resource. Next, view the Schema List
Resource to find your Schema Key(s), which is used by many other service resources.

(How can I do that???)

3. Consider installing the RESTTest Firefox Extension (a simple interface for testing readable and
writeable REST web services), available at http://www.xucia.com/#RestTest.
( I did installed the rest test but I dont know how to use it properly)

4. Find appropriate HTTP Connection sample code for your development platform.

I am able to connect to the site using the service account through the code.

but GET/POST request I dont know how can I make it if I dont know which webservice to retrieve

 Please help me.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend