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


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

Accessing Data using SQLConnection

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :ASP.Net
 

Hi Gurus,

I want to display the EMPLOYEES data in a datagrid in asp.net using C# from the MS Access database. The Access database is in the folder C:|EXAMPLES\NorthWind.MDF.

How can I go about it using SQLConnection command. I tried, but it does not work. Please help me.

 

Isaac.

 

 




View Complete Post


More Related Resource Links

Accessing SharePoint 2010 Data with Server-Side APIs

  
Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010

  

SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010


Data Points: Accessing Data from a Mobile Application

  

This month John Papa takes a look at developing a mobile application that can access data on your application server.

John Papa

MSDN Magazine January 2008


Best practice? Accessing subset of data based on user

  

I have a DB and associated Asp.net 3.5 web app. The database holds information on our clients. We're adding client access functionality and I need to know how best to restrict user access to data only pertaining to their client.

The clients are stored in a hierarchy and each user can be associated with multiple clients. The user should only be able to access the data for their associated clients and any sub clients thereof.

My initial thought is to add a collection of clients to their profile, then use that to filter all queries; however, my gut instinct tells me that using the profile for such a security function is inadvisable.

Could anyone provide any insight on a best practice for this? I'm sure it must be a pretty common need.

Thanks!
Jay 


Quick Note: Accessing Data in a SharePoint 2010 Web Part by using LINQ

  
In this exercise, you develop and deploy a visual Web Part that reads data from two lists by using a LINQ query and displays it in a DataGrid control.

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

  
Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Sample: Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint

  
Download sample code as you learn to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Video: Accessing SharePoint 2010 List Data

  
In this video you will learn how to create strongly typed classes using a tool called SPMetal to do LINQ programming against a SharePoint 2010 list. (Length: 15:22)

Module 5: Accessing SharePoint 2010 Data with Client-Side APIs

  
SharePoint 2010 provides a new client object model that enables you to create SharePoint solutions that run remotely from the SharePoint server farm.

Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010

  
SharePoint 2010 provides a new set of technologies known as Business Connectivity Services for retrieving, editing, updating, and deleting data from external systems.

Video: Accessing SharePoint 2010 Data on the Server

  
This video provides an overview of approaches for accessing SharePoint 2010 data by using the server-side APIs. (Length: 3:32)

Video: Accessing SharePoint 2010 Data from a .NET Application

  
This demonstration shows how to use the client object model from a Windows Presentation Foundation application. (Length: 5:26)

Video: Accessing SharePoint 2010 Data in Silverlight by Using CAML

  
This demonstration shows how to use the client object model and CAML to access SharePoint data in Silverlight applications. (Length: 6:39)

2 webforms accessing same data

  
In  a Distributed web application, of an industry2 computer operators are updating their clients information.I have the problem that When those 2 operators are updating the same client's information,for example: Client's Phone numberone of the Operator should get the information that "the phonenumber is already updated"How can I do it?Thanks

Accessing data from table

  
SELECT a.ID,a.NAME,a.PARENT_ORG_ID,a.INCHARGE_ID,a.BTA_ID,a.INDEPENDENT,a.TYPE_ID,a.LOCATION,a.DESCRIPTION,a.HIRARCHY_TYPE_ID,a.CANCREATE_BRD,a.CANHAVE_BTA,c.FIELD_NAME as DIVISION,a.HAS_ALLOCATION,a.ORA_ID,d.FIELD_NAME as CAN_BENEFIT,e.FIELD_NAME as IS_RESTRICTED,f.FIELD_NAME as COST_CENTER_ID,b.FIELD_NAME as ACTIVE  FROM ORGANIZATION a,TYPE b,TYPE c,TYPE d,TYPE e,TYPE f where b.ID=a.ACTIVE and c.ID=a.DIVISION and d.ID=a.CAN_BENEFIT and e.ID=a.IS_RESTRICTED and f.ID=a.COST_CENTER_IDhi,i'm using one form to store new organization into organization table.i'm using the following query to retrieve the data in organization table and binding to gridview.SELECT a.ID,a.NAME,a.PARENT_ORG_ID,a.INCHARGE_ID,a.BTA_ID,a.INDEPENDENT,a.TYPE_ID,a.LOCATION,a.DESCRIPTION,a.HIRARCHY_TYPE_ID,a.CANCREATE_BRD,a.CANHAVE_BTA,c.FIELD_NAME as DIVISION,a.HAS_ALLOCATION,a.ORA_ID,d.FIELD_NAME as CAN_BENEFIT,e.FIELD_NAME as IS_RESTRICTED,f.FIELD_NAME as COST_CENTER_ID,b.FIELD_NAME as ACTIVE FROM ORGANIZATION a,TYPE b,TYPE c,TYPE d,TYPE e,TYPE fwhere b.ID=a.ACTIVE and c.ID=a.DIVISION and d.ID=a.CAN_BENEFIT and e.ID=a.IS_RESTRICTED and f.ID=a.COST_CENTER_IDthis query is returning table  when only  the values of the columns which are in where condition are not null.if they are null for any record it's returning empty table.is there any other way to accept the null values also?ca

SSIS multiple data flows accessing the same raw file

  
I have multiple data flow tasks accessing the same raw file at virtually the same time.  I would like to know if the data flow tasks lock the raw file during read?  Can multiple data flow tasks read the same raw file at the same time.  I'm currently developing with a very small data set, but I would like to know if I should be concerned with the possibility of the data flow tasks competing for access to the same raw file. Thanks.

The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.

  
 Hi all,When i run my project on my own computer, it works fine. But when i deploy it to server, it gives me this error. I can run my other dts and sp, but i get this error on this.. The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. I googled it but could not find a solution. How can i solve this problem? 
Categories: 
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