asp.net.data_access-data_access_and_objectdatasource

CodeVerge.Net ^Beta
Item Entry Register Login

Novell Forums

> Asp.Net Forum > data_access.data_access_and_objectdatasource_control

Type

Replies

Views

Date

LINQ help for select functions

Hi,

Currently I have the following functions. As you can see subroutines are identical except for the Where clause.

Is there a way to assign

11/29/2009 4:27:37 AM

LINQ/VB - Method 'Boolean IsUserInRole(System.String)' has no supported tra nslation to SQL

Hi,

Having a bit of difficulty with LINQ. I'm trying to filter a set of data (Membership Users based on their roles, to be precise) depending on what role the user has picked in the dro

11/29/2009 3:07:55 AM

Updating Table From VB.NET

Hey, I am trying to add a value into just once column in a certain row of a table.

For instance I have a table that stores, date, user ID, ClockIn, ClockOut, BreakOut, BreakIn.

11/28/2009 11:17:50 PM

Linq "Take" method: Sequence Contains No Elements

I'm using the Take method in Linq:

public MyObject GetMyObject()
{
    return (from myObject in db.MyObjects
            where

11/28/2009 8:07:45 PM

execute after sqldatasource fills

i have a page with a drop down list that is populated by a SQLDataSource. thats all well and good. then, based on the selected value, another SQL query is run, but because of what im doing its vi

11/27/2009 11:03:45 PM

Unable to cast object of type .....

i have following code :

-------

System.Collections.ObjectModel.ObservableCollection

11/27/2009 11:03:43 PM

public class LoginDB

11/27/2009 11:03:43 PM

Cannot convert value of parameter from 'System.String' to 'System.Guid'

I have a FormView bound to an ObjectDataSource.

The select method of the DataSource takes in a GUID.
The SelectParameters collection sets the GUID param to pull in a userId:

11/27/2009 11:03:36 PM

Asp.net excel

Hi all

i have generated a excel on a button click in my project now i want to write array values (for eg mohan,test,cobine) in to th

11/27/2009 4:10:02 PM

getting error using LINQ to sql

I'm using LINQ to sql

?var advisorsList

11/27/2009 4:10:01 PM

Using same data source for two pages

Hi,

I am creating a online photo contest website, I have two pages Home.aspx and Vote.aspx, both pages uses ObjectDataSource to get the images from DB.

My question is how can I utiliz

11/27/2009 1:56:57 PM

can sqlcommandbuilder generate update command using primary key

hi,

can sqlcommandbuilder generate update command using primary key?

i have set the primary key in datatable. UpdateCommand generates

UPDATE [table1]

11/27/2009 10:55:05 AM

SQLDataAdapter with SQLTransaction fail for the second update

Hi,

I need to update table regularly. So i create a dataset with sqldataadapter and update it with transaction. It works for the frist time call and rais

11/27/2009 12:14:10 AM

LINQ database model to SQL diagram?

Hallo, I took over a project from someone and I have to change the database (add columns, add associations,...).

Now when I work with linq I make an SQL diagram in SQL first and then make t

11/26/2009 4:59:21 PM

LINQ: Problem with updating nullable datetime field automatically

Hi guys,

I use LINQ to SQL and Dynamic Data controls.

I have created a partial class that represents a table in my database. The table has three datetime fields (among some othe

11/26/2009 4:59:20 PM

binding small datatable that we made from big one takes lot of time !

I have a large datatable (matrixdisplay) that includes 51 rows * 420 columns.

I want to bind only 50 columns. if I remove from datatable 370 columns before I even bind , it is stuck for 3

11/26/2009 4:59:18 PM

Update from datatable to db not working...

Hi everybody,

I've got the following code, everything works except the db isn't updated.
The code isn't giving me any error. I printed out the data from tbl with some garba

11/26/2009 4:28:43 PM

Unformated Excel sheet upload using asp.net ( windows application)

Hi,

I am working in asp.net windows application. I want to upload the excel sheet value into SQL. But the excel sheet is unformatted one. I have

11/26/2009 3:58:38 PM

Filtering the Dataviewstate

In my dataview is

Code Name Password

01 Jed 1

02 Goff &nbs

11/26/2009 10:33:01 AM

Communication between Sql Sever 2005 and VS2005

Goodmorning to everyone!

My problem is that i have created a table in sql server but when i try to retrieve data from that table i get this:

Error 1

11/26/2009 9:26:36 AM

Using Custom SQL Queries with LINQ to SQL... Help

I have followed this tutorial by Scott pretty much to the T against my own database.

11/26/2009 4:28:04 AM

Need help on manipulate DataSet

I've DataSet as following,
TrnxID | EmployerCd | EmployerDesc
-------------------------------------------------------

11/26/2009 1:58:40 AM

Connection string in HKEY_USERS in registry

Hi,

How can I save my connection string in HKEY_USERS key in registry?

Is it good to save in HKEY_LOCAL_MACHINE?I have win 7 as my OS.

Thanks.

11/25/2009 10:52:37 PM

Error-the number of input array is longer than number of cloumn !!

hi i have dataset and i want to make 2 DataTable from it , and bind each datatable to Gridview.

My Scenario as follow:

Student st=new Student();

11/25/2009 9:32:15 PM

Check for database nulll value?

hi all,

I already search around but I still couldn't get it to work. Could someone help me with this?

Invalid attempt to read when no data is present.

11/25/2009 3:59:58 PM

DataSet With Stored Procedure?

hi all,

in fact im working with stored procedure rather than command text,

in my dataset i have more than one stored procedure to get data from more than

11/25/2009 1:22:03 PM

Sql Time Out

Hi all,

When I am trying to download an excel file in Production Server(Client machine) through web application the following error is coming in the log file.

11/25/2009 1:22:02 PM

OleDB excel import character limit

hello all,

I am trying to import data from an sql table to excel file through OleDB connection.
My code works well without a column having value greater than 255 characters.

11/25/2009 8:19:26 AM

Sql server connection error

Hi,

I am using asp.net(2.0)with c# and sql server 2005.

When i am insert the data in table with the help of web application,i am in

11/25/2009 8:19:20 AM

Export data in excel not in excel spreadsheet

I want to export data in excel file not in excel spreadsheet using c#

Please help me

Regards

Mamta

11/25/2009 7:14:18 AM

Using db xsd - need to change the connectionstring dynamically

I need to change the connectionstring of the web.config dynamically. But I don't know how to do it in the db xsd. Is there a way to dynamically change the connectionstring through

11/25/2009 7:14:16 AM

Invalid attempt to read when no data is present.

I am an absolute beginner. Please check my code for mistakes. Any help will be appreciated

The web.config file contains the following connection string

<ap

11/25/2009 6:12:53 AM

Using a stored procedure in linq in a Data Access Layer

I've hit a brick wall on trying to get this to work... I have a stored procedure that groups and counts records. This particular query will return 5 rows with 2 columns.&nbs

11/25/2009 2:19:07 AM

BOs issue

hi guys,

i am new to linq . i have created many n-tier applications in which there are three layers UI,BAL,DAL
but when i come to linq i am a bit confused about my business ent

11/24/2009 9:54:57 PM

Bulk Insert into table - How to manage the transaction?

From article, http://forums.asp.net/t/1493571.aspx -- i got an idea, how to manage the transaction

using (SqlConnect

11/24/2009 8:25:17 PM

C# How to delete a row in my database via a DataSet?

I am using DataSet to transfer data back and forth in between a database and clients via a Web Service.

So far I am able to present my data, edit my data

11/24/2009 5:57:52 PM

join cells in datatable

Hi.

I want to join cells of the last column vertically in a datatable.

I don't want to merge just the information in the cells. I want to transform 3 cells to 1 cell.

Does a

11/24/2009 4:56:41 PM

is there any size limit ds.Tables[0].Rows[0][0].ToString();

i'm trying to return a set of records..which xml

and then i store it to string...

but somehow it returns 3/4 of m

11/24/2009 4:56:40 PM

Inserting a data into database in two different table

I have a product insert form that takes a data and insert into the database.

My problem is I am accepting the data and then insert that data in to product table as well as product category

11/24/2009 3:21:32 PM

selecting event of objectdatasource triggering/invoking multiple times.

Hello friends,

I have develop a small application. In that I have used objectdatasource for inster update delete and view data in grid.

I used 3 dropdown and

11/24/2009 1:41:11 PM

Random ASP.NET 2.0 crashes under load (A field or property with the name X was not found on the selected data source)

We have an application that is an extension of Nav to the web. The system is used for accounting and approval of invoices/credit memos. The app is written in C#, and is run on an IIS webserver.

11/24/2009 1:41:10 PM

very urjent

public DataTable bindEmployee(EmployeeUInfo objemp)
        {
            DataT

11/24/2009 1:06:20 PM

Reading Excel Spreadsheet

Hello All,

I have an application that reads from an Excel spreadsheet in to a standard GridView.

The spread sheet contains item numbers

11/24/2009 9:51:41 AM

sqlbulkcopy error

hi all,

i am using sqlbulkcopy to copy the excel data into the sql database

i got error at this point sqlbulkcopy.writetoserver(dt)

error is "acc_no "

11/24/2009 7:44:47 AM

Passing parameters to stored procedure

Hi friends,

I've implement paging in my datalist. I've followed the steps given in this link.

11/24/2009 7:44:46 AM

Error: String was not recognized as a valid DateTime.

Hi All,

Below is the sample code where it throws an error while doing dt.Select() saying "String was not recognized as a valid DateTime". Any ideas?

11/24/2009 3:49:27 AM

coding problem

I am using this code to query a database and it is working, but not providing correct answers. I believe the code needs tightening up. Can anyone please help? The from/to dates come fro

11/24/2009 2:32:57 AM

Linq to XML Query

Hi,

I'm new to using LINQ and XML.

I have the following snippet of information (It is within a larger document but i figured out how to

11/23/2009 8:20:56 PM

Property evaluation failed - Error in .XSD Page

Hi All,

I am working on an enhancement project,screens use schemas(xsd) to interact with Database.Now i need to expose one existing column (Totalcnt int default 0 not null)<

11/23/2009 6:43:08 PM

ADO.NET Entities: First access is really slow

I have a web forms page that uses an ADO.NET Entity Model to get some data from the database using a LINQ query and builds the HTML to display in code behind C#.

The problem is,

11/23/2009 4:57:20 PM

12793 Items, 256 Pages 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 41 81 121 161 201 241 |< << Go >> >|

Invite

Members

SiteMap

Privacy | Contact Us
All Times Are GMT