InsertParameters For SqlDataSource

Nov 30, 2007

Hello, I have a SqlDataSource named "OrderHistoryDataSource" that I want to add a parameter to from the code behind file. THe reason I want to do this is todynamicly  add the UserID from a currently logged on user. What am I doing wrong? Is there a better way?My code below:
 --------------------------------------------------------------------Code behind file----------------------------------------------------------------------------
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class OrderHistory : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//If the user is not logged in this will redirect to Login.aspx
if (!Request.IsAuthenticated)
{
Response.Redirect("~/Login.aspx");
}

//test to display userID
MembershipUser myObject = Membership.GetUser();
string UserGUID = myObject.ProviderUserKey.ToString();

SqlDataSource DataSource = Page.FindControl("OrderHistoryDataSource");

DataSource.InsertParameters.Add("CurrentUserId", UserGUID.ToString());

DataSource.Select();
}
}
  
  --------------------------------------------------------------------Asp.net
file----------------------------------------------------------------------------<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="OrderHistory.aspx.cs" Inherits="OrderHistory" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="CONTENT" Runat="Server">
<table id="ContentTable">
<tr>
<td id="ContentTitleCell" colspan="3" style="width: 684px">
ORDER HISTORY</td>
</tr>
<tr>
<td colspan="3" rowspan="2" style="width: 684px">
<asp:GridView ID="OrderHistoryGrid" runat="server">
</asp:GridView>
 
<asp:SqlDataSource ID="OrderHistoryDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [UserOrders] WHERE ([UserID] = [CurrentUserID]) ORDER BY [OrderID]

VALUES (@UserId, @Address, @City, @State, @Zip)"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>">
<InsertParameters></InsertParameters>
</asp:SqlDataSource>
</td>
</tr>
<tr>
</tr>
</table>
</asp:Content>
   

View 3 Replies


ADVERTISEMENT

Passing ANY Value To The &<InsertParameters&> Section Of A SQLDataSource

Jun 6, 2007

Ok-I'm new at this, but just found out that to get data off a form and insert into SQL I can scrape it off the form and insert it in the <insertParameter> section by using  <asp:ControlParameter Name="text2" Type="String" ControlID="TextBox2" PropertyName="Text">  (Thanks CSharpSean) Now I ALSO need to set the user name in the same insert statement. I put in a UserName control that is populated when a signed in user shows up on the page. But in my code I've tried:                             <asp:ControlParameter Name="UserName" Type="String" ControlID="LoginName1"  DefaultValue="Daniel" PropertyName="Text"/> and I get teh errorDataBinding: 'System.Web.UI.WebControls.LoginName' does not contain a
property with the name 'Text'. So I take PropertyName="Text" out, and get the error:PropertyName must be set to a valid property name of the control named
'LoginName1' in ControlParameter 'UserName'. what is the proper property value?  SO.....BIG question...Is there a clean way to pass UserName to the insert parameters? Or ANY value for that matter? Id like to know how to write somehting likeString s_test = "test string";then in the updateparameter part of the sqldatasource pass  SOMEHITNG like (in bold)     <asp:Parameter Name="UserName" Type="String" Value=s_test /> Thanks in advance...again! Dan  

View 5 Replies View Related

Insertparameters In Code-behind

Mar 1, 2007

Hi,How do I use insertparameters in code-behind? This is the code that I have  Dim insertSql As String
insertSql = "INSERT INTO [xyzTable] ([x], [y]) VALUES (@x, @y)"
SqlDataSource1.InsertCommand = insertSql
SqlDataSource1.InsertParameters.Add("@x", "124")
SqlDataSource1.InsertParameters.Add("@y", "456")
SqlDataSource1.Insert()  When I execute these line of code I get an error saying "Must declare the variable '@x'." Please help 

View 2 Replies View Related

InsertParameters Problem

Jan 25, 2008

Hi - any idea why I'm getting the following? I've got it to work on other pages with different data but I can't work it out.  thanks,mander  Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.Source Error: Line 32:     protected void Button1_Click(object sender, EventArgs e)Line 33:     {Line 34:         SqlDataSource1.InsertParameters["AdminNotes1"].DefaultValue = TextBox1.Text.ToString();Line 35:         SqlDataSource1.Insert();Line 36:     } Source File: ..adminindex.aspx.cs    Line: 34 Stack Trace: [NullReferenceException: Object reference not set to an instance of an object.]   Default2.Button1_Click(Object sender, EventArgs e) in c:Documents and Settings..adminindex.aspx.cs:34   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +97   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4886

View 6 Replies View Related

Correct InsertParameters Syntax

Jan 29, 2008

If someone can show me the correct syntax for the right side of the code below, I'd appreciate it.
srcMoreInfo.InsertParameters("Address").DefaultValue =       DirectCast(cuwMoreInfo.FindControl("txtAddress"), TextBox).Text 

View 11 Replies View Related

SELECT A Single Row With One SqlDataSource, Then INSERT One Of The Fields Into Another SqlDataSource

Jul 23, 2007

What is the C# code I use to do this?
I'm guessing it should be fairly simple, as there is only one row selected. I just need to pull out a specific field from that row and then insert that value into a different SqlDataSource.

View 7 Replies View Related

Individual SqlDataSource() Or Common SqlDataSource() ?

Mar 8, 2007

i am using visual web developer 2005 with SQL Express 2005 with VB as the code behindi have one database and three tables in itfor manipulating each table i am using separate SqlDataSource() is it sufficient to use one SqlDataSource() for manipulating all the three tables ? i am manipulating all the tables in the same page only please help me

View 1 Replies View Related

Asp:sqldatasource - Sum And Contains

Aug 20, 2006

I have an asp:sqldatasource which is bound to a gridviewIn addition to this I would like it to a) see if there is a specif row/ item in it (ie item_id = 10 for any of the rows it has received) as I conditionally want to show another item outside of the gridview subject to if it is in the gridview or notb) show the sum of all the values within a certain column of returned rowsMany thanks

View 1 Replies View Related

SqlDataSource

Oct 11, 2006

How do I get the result of this select into a variableDim sqldsFindUserId As SqlDataSource = New SqlDataSource        sqldsFindUserId.ConnectionString = ConfigurationManager.ConnectionStrings("bluConnectionString2").ToString        sqldsFindUserId.SelectCommandType = SqlDataSourceCommandType.Text        Dim myUserIdCmd As String = "select pkUser from tblUsers where strDisplayName='" + myDisplayname + ""        sqldsFindUserId.SelectCommand = myUserIdCmd  '  The result  of this select statement is to be stored in a variable, how do I do it?

View 2 Replies View Related

SqlDatasource

Dec 18, 2006

Hi all

View 2 Replies View Related

Sqldatasource

Jan 15, 2007

hi all,
in all my 2.0 learnings and books i keep coming across the page element <asp:sqldatasource>.
I have always (in 1.1) used server side connections and adapters to bind my Sql datasets to any control needed.  Now that im learning 2.0 im finding it difficult to understand using control on the page to bind my data.  Can someone explain the benefits of using this data source?  Ideally i would like to keep my data access layer separate from my presentation layer but i'd really like to understand why this method seems so popular.
thanks in advance,
mcm

View 2 Replies View Related

Using SQLDataSource

Feb 23, 2007

Hi, I am new to ASP.NET 2.0 and I am trying to use VWB to bind my web site to a SQL Express edition. I used SQLDataSource to specify the .mdf file so I can connect to my tables but when I click on the advanced button to generate the Insert, Update, Delete SQL I find it grayed out and it cannot be clicked. I looked into several tutorials online and I couldn't find the problem, can anyone explain what I am missing or doing wrong? Any suggestion is very appreciated. Thanks 

View 2 Replies View Related

SQLDataSource

Mar 30, 2007

SELECT * FROM [CONTACTS] WHERE @ddl_value LIKE '%@txt_value%'
 
Why doesn't this not working
I am using SQLdatasource control to bind a gridview
If my query is wrong then what might be the correct one to work with like operator in the sqldatasource
Can any ony help me!

View 4 Replies View Related

SqlDataSource

Apr 12, 2007

Hello All,
 I have quick question ..
In my aspx page i have gridview  and Sql DataSource  object as you can see
<asp:sqldatasource id="SqlDataSource1" runat="server" ></asp:sqldatasource>
 
<asp:gridview id="GridView1" runat="server" allowpaging="True" allowsorting="True" autogeneratecolumns="False" datasourceid="SqlDataSource1">
<columns>
<asp:boundfield datafield="breakdownid" headertext="breakdownid" insertvisible="False"
readonly="True" sortexpression="breakdownid" />
<asp:boundfield datafield="ticketno" headertext="ticketno" sortexpression="ticketno" />
<asp:boundfield datafield="systemtype" headertext="systemtype" sortexpression="systemtype" />
<asp:boundfield datafield="break_date" headertext="break_date" readonly="True" sortexpression="break_date" />
<asp:boundfield datafield="subject" headertext="subject" sortexpression="subject" />
<asp:boundfield datafield="status" headertext="status" sortexpression="status" />
<asp:boundfield datafield="prioritylevel" headertext="prioritylevel" sortexpression="prioritylevel" />
<asp:boundfield datafield="mobiletype" headertext="mobiletype" sortexpression="mobiletype" />
</columns>
</asp:gridview>
In codebehind file  i call a function to get data from database. what i want is to bind the result to the sqlDataSourse not the gridview.
 I need to have the SqlDataSourse thier..  Any help please
 
 
Sub Page_load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
Dim objReader As New Dynamic.Reportsdemo
SqlDataSource1 = .objReader.Get_Tickets(1, 0, "all")
 
SqlDataSource1.DataBind()
objReader.objconnection.Close()
 
End If
End Sub
Thanks.
 
 

View 1 Replies View Related

How To Get A Value From SQLDataSource

May 28, 2007

Hi!Please tell me, how to get a simple value using SQLDataSource, I mean a number, or char, or string - any value, NOT DataTable 

View 3 Replies View Related

EOF With SqlDataSource

Jul 23, 2007

I am trying to get record from a table and verify it with a textbox i have a sqldatasource.
 i have a text box called txtEmail and this is my Select command. how can i get this working if its possible ?
something like txtEmail.text = SqlDataSource1.Secect then ... my code. (i dont know if this a correct way to do this)
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:imacstestConnectionString %>"
SelectCommand="SELECT FROM [t_CustomerAcct]"
 
thanks,

View 1 Replies View Related

Something About Sqldatasource

Aug 13, 2007

hi all,i am using sqldatasource for gridviewso that i can edit and update any row at the same place ..... and not to write any code for that....now later on if i wanna change the selectcommand of that sqldatasource how can i ? so that the edit and update will be same as it was.... 

View 2 Replies View Related

Using An SQLDataSource For Than Once

Aug 21, 2007

Hi,
I'm trying to go through a checkbox list and inserting them into a database using a sqldatasource with the following code:For Each li As ListItem In Locations_Checkbox.Items
If li.Selected = True Then
 
Dim DataSource2 As SqlDataSource = CType(InsertProgrammeLocations, SqlDataSource) DataSource2.InsertParameters.Add("ProgrammeID", li.Value)
DataSource2.Insert()
 
 
End If
Next
When more than one checkbox is ticked, I'm getting the error 'The variable name '@ProgrammeID' has already been declared'. How do I close or reset my Datasource before I try and use it again?
Thanks for your help
  
 

View 3 Replies View Related

Sqldatasource

Oct 28, 2007

please explain selectparameter collection and conflict detection property and filterparameter
mohsen

View 1 Replies View Related

What Is SqlDataSource

Oct 29, 2007

Hi, I want to know when to use an sqlDataSource object because I used to populate for example a listBox control in visual studio net 2003 from AQLK server database by using a connection object, command object, dataAdapter object and a DataSet object. I discovered if I use sqlDataSource object (using visual studio net 2005) ,all I need is to write the connection string and a Select statement as properties for that sqlDataSource, so why to use the above mentioned objects(connection,command,adapter,dataset) while I can access any database in sql server through the use of sqlDataSource?
I appreciate if you can explain to me the difference and when to use an sqlDataSource
thx

View 1 Replies View Related

SqlDataSource

Dec 4, 2007

How can I update more than one table with one UpdateString in SqlDataSource?

View 5 Replies View Related

Do You Really Use SqlDataSource?

Dec 9, 2007

Hi,
I have an application w/ n-tier design so I've never used the SqlDataSource up to this point but having to do my own sorting for GridViews is not something I want to keep dealing with. I'd like to take advantage of some of the packaged features too.
My question is: are there any purists out there who opted to use SqlDataSource. If so, what do you think about it? It's nice that SqlDataSource makes things simple but having data classes and dealing w/ exceptions in those classes certainly make an application pretty robust. Should I entertain the idea of using SqlDataSource or stay as a purist and keep doing things the old fashioned way?

View 1 Replies View Related

Sqldatasource?

Dec 30, 2007

How to display returned data from sqldatasurce in a textbox.
This code is not working TextBox1.Text = SqlDataSource2.ToString(); Thanks Lot.

View 2 Replies View Related

SqlDataSource

Jan 16, 2008

Hey all,I've just started to use asp.net and so far have found it fairly easy. The only problem I've come across is with putting variable clauses into the SqlDataSources.This is one example of what I've done trying to get this to work. <asp:SqlDataSource ID="ClaimsDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT TOP 20 dbo_ClaimStatus.ClaimStatus, dbo_CLAIMS.PACKET, dbo_INSURED.NAME, dbo_FEES.INSURER, dbo_FEES.CLAIM_NUMBER, dbo_CLAIMS.LOSS_DATE, dbo_CLAIMS.RECEIVED, dbo_CLAIMS.LOSS_LOCATION, dbo_CLAIM_TYPES.CODE FROM ( ( ( ( dbo_CLAIMS INNER JOIN dbo_CLAIM_TYPES ON dbo_CLAIMS.CLAIM_TYPE = dbo_CLAIM_TYPES.CODE ) INNER JOIN dbo_ClaimStatus ON dbo_CLAIMS.StatusID = dbo_ClaimStatus.ClaimStatusID ) INNER JOIN dbo_FEES ON dbo_CLAIMS.PACKET = dbo_FEES.PACKET ) INNER JOIN dbo_INSURED ON dbo_CLAIMS.PACKET = dbo_INSURED.PACKET ) WHERE dbo_ClaimStatus.ClaimStatus = @claimStatus"> <FilterParameters> <asp:QueryStringParameter Name="claimStatus" QueryStringField="ctl00$MainContent$claimStatus" /> </FilterParameters></asp:SqlDataSource>I'm posting claimStatus from a previous page using PostBackUrl on an <asp:Button /> tag and claimStatus is an <asp:DropDownList /> tag.Any idea's as to why this doesn't work?Nalum 

View 2 Replies View Related

SqlDataSource

Feb 24, 2008

Dear Friends in my project , i' ve used two SqlDataSource, one button and one gridview control;
the process that i want to do is when i click the button control ,according the  if structure in this button control ; one of the SqlDataSource control assign to the gridview control DataSource property (but i assign the DataSourceID property for the gridview , it runs);
but i couldnt do it, what can i do for it? (my code  doesnt give any errors but doesnt do anything too)
my code is here;
protected void btnSearch_Click(object sender, EventArgs e)     {         if (txtSearch.Text != null){             SqlDataSource3.SelectParameter["key"].DefaultValue = txtsearch.Text;             Gridview1.DataSource = SqlDataSource3;             GridView1.DataBind();         }         else         {             SqlDataSource1.SelectParameters["keySession"].DefaultValue = cbSession.SelectedItem.ToString();             SqlDataSource1.SelectParameters["keyClass"].DefaultValue = cbClass.SelectedItem.ToString();             SqlDataSource1.SelectParameters["keyUnit"].DefaultValue = cbUnit.SelectedItem.ToString();             Gridview2.DataSource = SqlDataSource1;             GridView2.DataBind();         }
 

View 1 Replies View Related

SqlDataSource

Feb 24, 2008

Dear Friends in my project , i' ve used two SqlDataSource, one button and one gridview control;
the process that i want to do is when i click the button control ,according the  if structure in this button control ; one of the SqlDataSource control assign to the gridview control DataSource property (but i assign the DataSourceID property for the gridview , it runs);
but i couldnt do it, what can i do for it? (my code  doesnt give any errors but doesnt do anything too)
my code is here;
protected void btnSearch_Click(object sender, EventArgs e)     {         if (txtSearch.Text != null){             SqlDataSource3.SelectParameter["key"].DefaultValue = txtsearch.Text;             Gridview1.DataSource = SqlDataSource3;             GridView1.DataBind();         }         else         {             SqlDataSource1.SelectParameters["keySession"].DefaultValue = cbSession.SelectedItem.ToString();             SqlDataSource1.SelectParameters["keyClass"].DefaultValue = cbClass.SelectedItem.ToString();             SqlDataSource1.SelectParameters["keyUnit"].DefaultValue = cbUnit.SelectedItem.ToString();             Gridview1.DataSource = SqlDataSource1;             GridView1.DataBind();         } }

View 1 Replies View Related

SQLDataSource && ADO.Net

Apr 16, 2008

Could someone help me with syntax?  Everything works until line 23.  At that point, I get a NullReferenceException.  When I examine the SqlDataSource object, everything inside reads "Object cannot be null" or "The pointer for this method was null."  The SQLDataSource looks ok, just before executing line 23.
Does anyone have a complete example of how to do this ADO operation?
Thank you. 1 Dim fv As FormView = Nothing
2 Dim sds As New SqlDataSource
3
4 ' ===== Lookup connection string =====
5 sds.ConnectionString = ConfigurationManager.ConnectionStrings("LocalSQLServer").ToString
6
7 ' ===== Define command statements =====
8 cmdSelect = _
9 "SELECT rowid, FRScrnLev, FRPgmLev, " + _
10 "FRFName, FRLName, FRIDate, OverRide, OverRideDesc " + _
11 "FROM PSB_Pre WHERE PSBid = @PSBid"
12
13 ' ===== Get handle to Formview =====
14 fv = CType(MultiView1.Views(0).FindControl(ViewState(VS_VIEW).ToString), FormView)
15
16 ' ===== Complete definition of data source =====
17 sds.SelectCommand = cmdSelect
18 sds.SelectCommandType = SqlDataSourceCommandType.Text
19
20 sds.UpdateCommand = cmdUpdate
21 sds.UpdateCommandType = SqlDataSourceCommandType.Text
22
23 sds.SelectParameters("PSBid").DefaultValue = CP.PsbId
24
25 ' ===== Bind data source to FormView. =====
26 fv.DataSource = sds
27 fv.DataBind()

View 2 Replies View Related

Get A Value From Sqldatasource

May 26, 2008

I have an sqldatasource that has a select statement and i just wanna pull a value out of it
a single value
row 0 colum 0
and assign it to a string
the coloum is an interger in the database

View 1 Replies View Related

Sqldatasource Help

Jun 4, 2008

Hi, i am trying to use a sqldatasource to update a table and when i go and update the table it puts a null value in for all of my fields. I am not sure what is happening and i have never used on of these before. Is there some code that i need to write to accompany the sqldatasource or am i just missing something. I have posted the code below. Thanks.<asp:GridView ID="grdSize" runat="server" AutoGenerateColumns="False"
DataSourceID="sqlbk" Width="295px" BackColor="White" BorderColor="#999999"
BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<RowStyle CssClass="grdsizerow" BackColor="#EEEEEE" ForeColor="Black" />
<EditRowStyle CssClass="grdsizeedit" />
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" />
<asp:TemplateField HeaderText="Diameter" SortExpression="Diameter">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" Width="60px" Height="16px" runat="server" Text='<%# Eval("Diameter") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Diameter") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="HighLimit" SortExpression="HighLimit">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" Width="60px" Height="16px" runat="server" Text='<%# Eval("HighLimit") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("HighLimit") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="LowLimit" SortExpression="LowLimit">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" Width="60px" Height="16px" runat="server" Text='<%# Eval("LowLimit") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("LowLimit") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle CssClass="grdsizeheader" BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView><asp:SqlDataSource ID="sqlbk" runat="server"
ConnectionString="<%$ ConnectionStrings:qdbConnectionString %>" SelectCommand="Select ID, screwdia as Diameter , HighLimit, LowLimit from ScrewSize"
 
UpdateCommand="UPDATE ScrewSize SET screwdia = @dia, HighLimit = @high, LowLimit = @low WHERE (ID = @ID)">
<UpdateParameters>
<asp:Parameter Name="dia" Type="String" />
<asp:Parameter Name="high" Type="String" />
<asp:Parameter Name="low" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>

View 4 Replies View Related

SQLdatasource

Nov 22, 2005

Hi
When i am configuring the SQLdatasource control the checkbox of  Generate insert,updata and delete is disabled i wnat to check this checkbox
can anybody tell me how i enable this checkbox
 
thanks

View 1 Replies View Related

SQLDATASOURCE VS. ADO.NET

Nov 27, 2005

Hello,What's the difference between using sqldatasource to get data vis-a-vis ado.net?Both can retrieve datareaders and datasets.Any thoughts? Which one is better?From my experience, code-wise, sqldatasource is muuuuch easier.a s a f.  . .

View 1 Replies View Related

SqlDataSource

Jan 18, 2006

I have my table on the page with data in it from my database but I can't see the SqlDataSource below it where it should be. Is something wrong with the program or is there a way to turn it on so I can see it?A quick response would be greatly appreciated.

View 2 Replies View Related

How To Use SQLDataSource

Jan 27, 2006

Hello guys i am a bit confused, because i cannot do a simple select using the SQLDataSource  from ASP.NET 2.0
 
here is how was doing after droping the SQLDatAdapter using the VS2003
Example
SqlDataAdapter1.SelectCommand="select * from users"
SQLDataAdapter1.Fill(Datasource1,"users")
TextBox1.DataBind()
 
my question is how to do it in VS2005 since that i dont see theDataAdapter anywhere, do i have to do by hand like declaring everything??
 
 
thank you in advance!!
 

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved