473,322 Members | 1,614 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Query data using SQLDatasource in .aspx file

I have a built in aspnet_users table with 2users user1 has role "BoothUser" and user2 has role "ROUser" i want to query the user with Role using SQLDatasource in .aspx file and not in Code behind file!

plz help!

Thanks in Advance!
Shekhar Shete
MCTS!
Aug 23 '11 #1
1 1574
@Shekhar Shete
create DataSet with query that select from aspnet_users and then write a code to call this DataSet.

http://www.asp.net/data-access/tutor...ccess-layer-cs
Sep 6 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

15
by: Swetha | last post by:
Hello I have a DropDownList that I am populating using the following SqlDataSource: <asp:DropDownList ID="parentIDDropDownList" runat="server" DataSourceID="SqlDataSource3"...
4
by: RAB | last post by:
I am thinking about coding an .aspx with research text that I don't want others to have access to unless they render the page. We are talking about 20,000 text strings of data. My question is, if...
5
by: Moskie | last post by:
I recently came across an application where the 'src' attribute of a script tag was an ASPX file. Like so: <script language="JavaScript" src="scriptfile.aspx"></script> This is a new idea for...
5
by: msch-prv | last post by:
Hi, I am trying to tie a SQLDataSource control to MySQL without success. The connection string works ok with an ObjectDataSource. (Native asp.net 2.0 MySQL dll loaded in /bin) For some reason,...
2
by: intscript | last post by:
Hello everyone! Is this statement is possible? here is the code: select sum(nPassengers) Planned, Actual, (sum(Planned) - Actual) Variance from ( select iDeptCode, sum(nPassengers) Planned...
4
by: Casper | last post by:
Hi, i know how to use datareader in code-behind, e.g. like this: Dim oConnection As OleDbConnection Dim comd As OleDbCommand Dim dtreader As OleDbDataReader oConnection = New...
1
by: jobs | last post by:
I have a GRIDVIEW I have bound to an OBJECTDATASOURCE that has the select pointing to a class method that uses ADO to grab a dataset from SQL Server Stored Procedure. One of the columns that...
1
by: Pipo Dyer | last post by:
Hello Everybody, I am Using @@IDENTITY from MS Access (YES-It is possible) using SqlDataSource -NO STORE PROC- in ASP.NET {VB CODE} to retrieve the ID of a inserted record. Please keep in mind I...
5
by: Eric | last post by:
Hi, i tested this sql command directly with sql server and it works: select left(field1,10) from mytable Now, i tried the same in aspx file: i dragged a sqldatasource control and changed...
3
by: JFKJr | last post by:
Hello everyone, I have been trying to solve this problem from past two days. I am working for my project and stuck with this problem. Please help me out, your help will be greatly appreciated....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.