473,765 Members | 2,086 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Ho do I access sqldatasource in Code Behind?

5 New Member
This is my sqldatasource this is on the page:

Expand|Select|Wrap|Line Numbers
  1. <asp:sqldatasource runat="server"  ID="DS_CheckUserName"  
  2.     ConnectionString="<%$ ConnectionStrings:SQL2005_355184_ConnectionString %>" 
  3.     SelectCommand="SELECT [UserName] FROM [TBL_Poets] WHERE ([UserName] = @UserName)">
  4.     <SelectParameters>
  5.         <asp:FormParameter FormField="UserName" Name="UserName" Type="String" />
  6.     </SelectParameters>
How do I access the selected UserName in in the Code Behind that might look like this...

Expand|Select|Wrap|Line Numbers
  1. if (UserName.Text != DS_CheckUserName.UserName
...where DS_CheckUserNam e.UserName is the UserName selected in the code above?
Jul 29 '08 #1
3 2927
Frinavale
9,735 Recognized Expert Moderator Expert
I'm not sure what control you are using to display the data....
Check out the SqlDataSource Class there are a bunch of tutorials listed on that page....one of which is a Walkthrough on basic data access that I think might help you.

-Frinny
Jul 30 '08 #2
markpringle
5 New Member
I'm not sure what control you are using to display the data....
Check out the SqlDataSource Class there are a bunch of tutorials listed on that page....one of which is a Walkthrough on basic data access that I think might help you.

-Frinny
That's the point. I don't want to use a control to display the data. I just want to use the data to compare to in my code behind. I don't know how (or if it is possible) to access sqldatasource in my code behind.
Aug 9 '08 #3
kenobewan
4,871 Recognized Expert Specialist
That's the point. I don't want to use a control to display the data. I just want to use the data to compare to in my code behind. I don't know how (or if it is possible) to access sqldatasource in my code behind.
There is the alternative if you are not planning to bind the data to a control, you may use a connection, command and data reader in the code behind to obtain the values you want. HTH.
Aug 10 '08 #4

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

Similar topics

15
26929
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" DataTextField="name" DataValueField="ID"></asp:DropDownList><asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
2
2043
by: prontoo | last post by:
Hello, I dont know how to get a recordset from sqldatasource with selectcommand and put in standard listbox (not html) when i press the standard button. Thank you
1
1895
by: staeri | last post by:
Hello! I would like to set the SqlDataSource in the code behind file and not to have it in the aspx file. How can I do that? Regards, Staeri
3
12734
by: Dorte | last post by:
Hi, Could someone help me with a couple of links to SqlDatasource documentation on how to use the Gridview and SqlDatasource components in code behind? Basically I'm missing some documentation on how to handle different tasks programmatically such as selects, updates, sorting of data etc. in code behind if I prefer to set all Gridview and Sqldatasource properties etc. in code behind rather than in the aspx file.
2
19794
by: phil | last post by:
Hi, I want to put a recordset in a gridview but i don't know how to pass the value of the variable in the 'where' statement. The value of the variable is set in the code-behind. i added a tag <selectParameters> but i don't know which elements are needed and how... This is my aspx file: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydb.mdb"
4
1499
by: saturnius | last post by:
Hello, I have to save the data from a gridview as XML file. The code is shown below. Is there no easier way? I would like to access either asp:SqlDataSource (me.SqlDataSource1.something) or asp:GridView (me.GridView1.something) instead I have to create a new sqlcon,selectcommand,dataset,dataadapter.... Is there no easier way?
4
11408
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 OleDbConnection() oConnection.ConnectionString = Application("connect")
1
2536
by: Vili | last post by:
Hi all I would like to get some ideas and opinions of my solution for dataconnection on asp.net 2.0 I have created a class which encapsulates the sqldatasource usage. With my class one can set select-, insert-, update- and deletecommand with and without parameters and also get output parameters
0
1303
by: ADAC | last post by:
I am very familiar with Visual studio 2003 and trying to get a handle on 2005 I can set up the datasource and make it work fine when I databind it to a control like a gridview or details view. Everything is done automatically no programming. I need to take a sqldatasource that I have already created with parameters etc. Set the parameter in the code behind, run it against the database and get the result. in 2003 I would creat a command,...
0
10153
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10007
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9946
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8830
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7371
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5272
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5413
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3921
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2800
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.