The sql equivalent i&#

I have made a stored procedure in  db and able to show those data on front end by calling that stored proced

I have an existing stored procedure that I am using in a typed dataset table adapter that retrieves one value. It is just a lookup procedure that finds a product based on id, and returns the one

 I was wondering if anyone could tell me what the property values for DataTextField and DataValueField would be from the results of the Sub below. Basically I have a BulletedLis

I am in a pickle. I have a live server that presents a series of options to a user and then they pick one. The postback functions make a call to a function, SaveChoiceIteration, designed to

When I get a the property of a row of a strongly typed dataset, the designer writes code so it throws an exception if the value of the property is NULL because it can't co

The Stored procedure e

i've got 2 tables in database:
EMPLOYEES(id,name,department_id)
DEPARTMENTS(id,name,ma

I created my DAL by dragging tables onto the design surface per the MSDN tutorial.  But it forced me to use my local connection string.  I've set up my web.config file to I can chan

select distinct customerid
from orders as a

I'm using the FormView data entry control to interface with a table-adapter linked to my database. I've managed to successfully write to the database by binding with the INSERT

If i have column named (email) in table named (table1) in database named (db1.mdf) and i want to compare t

I simply right click on the folder -> add new item -> "choose dataset" ->

tasks
----------
task_id
task
type

orientation
---------------
orientation_id

Following is the sample data in my table<

I have been working in this application and I'm having trouble inserting data into the database. I posted a question this morning and two members helped me solved the issu

I can't figure out why my stored procedure is returning so many records. The search works, but it loops through the record thirteen times when binding them to the Gridview. I have

But SubmitChanges() isn't working. Everything works fine up to that point, and all the values

Have downloaded VS 2008 Express, SQL Server 2005 Express, and ASP.net Data Access Tutorials 1.  After creating a new web site
for the Data Access Tutorial 1, I also created the Nor

I

On my form I am wanting to hit the "submit button" which uses a stored procedure to update a single row in the database. I've been trying several things but haven't worked yet.