Difference Between ADO.NET And Using SqlDataSource?
Mar 9, 2011what is difference between developing website using ADO.NET means using connection,command... object and using sqlDataSource?
View 2 Replies
Similar Messages:
DataSource Controls :: SQLDataSource And Tie A SqlDatasource To A Stored Procedure
May 14, 2010I am trying to tie a sqlDatasource to a Stored Procedure. The stored procedure looks like...
[Code]........
SQLDataSource Versus ADO.NET
Mar 8, 2011If I want to connect to a database in ASP.Net, is it better to use ADO.NET rather than SQLDataSource? They serve a similar purpose, correct?
View 7 RepliesC# - Get Sqldatasource In Code Behind?
Mar 3, 2011To connect to my database I used the wizard to make SQLDataSource. But I need to access it in code behind, to store my data in the database. Does someone knows how I can do that?
This is the code:
<asp:SqlDataSource
ID="MySqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:HELPDESK_OUTLOOKConnectionString3 %>" SelectCommand="SELECT
hd_aanvraag_fase.aanvraag_id,
[Code]....
How To Update Database Without Using SqlDataSource
May 17, 2010If I want to access the method in which we define update query, how can I access that method on aspx page & update the data in a grid view without direct use of an query on aspx page under sql data source?
View 28 RepliesWhat Dynamic SelectCommand In SqlDataSource
Nov 17, 2010I have a DDL with 2 options: "Trainer" & "Observer." I'd like to use the selection from that DDL to reference a field in the SqlDataSource SelectCommand.
There are 2 fields in the table that may be referenced in the SelectCommand:
"Trainer_Oracle_ID" & "Observer_Oracle_ID." I'm trying to do something like:
WHERE @Oracle_ID_Type = <%=DropDownList_Oracle_ID_Type.Text%>_Oracle_ID
i.e. User selects "Trainer" and the SelectCommand references the field called:
"Trainer_Oracle_ID."
Syntax For Retrieving A Value From A SqlDataSource?
Dec 28, 2010the syntax for retrieving a value from a SqlDataSource? I've managed to get it working using numbers to represent the column, but I'd much rather use it's DB name?
[Code]....
SqlDataSource Versus ADO.NET Coding With C#
Feb 25, 2011I really do not have time to learn new language, in my case asp.net, but would like to start developing website in asp.net. I do not want to use asp:SqlDataSource control. is it ok if i write in codebehind aspx: all database connections and other CRUD operations in ado.net and c#. I already know xhtml, javascript - jquery, css, xml, json, some knowledge in sever-side coding (before php). want to start coding, instead of learning messy asp.net controls.I have to sit and learn all bloody ways of using those asp.net controls?
View 2 RepliesC# - Set Sql Parameters For An SqlDatasource In The Code Behind
Feb 9, 2011How can i set sql parameters for an sqlDatasource in the code behind?
I am trying like this:
[code]....
Web Forms :: How To Get Value From SqlDataSource In Label
Jan 19, 2011i have SQLDataSource and stored procedure "newsSelectLastHeading" that returns newsHeading
<asp:SqlDataSource ID="newsSelect" runat="server"
ConnectionString="<%$ ConnectionStrings:newsConnectionString %>"
SelectCommand="EXECUTE newsSelectLastHeading">
</asp:SqlDataSource>
[code]...
ADO.NET :: Add A Parameter To Sqldatasource During RowDataBound?
Aug 12, 2010So I have a gridview within a gridview (I have a one to many table) my first gridview is working well, but my second gridview has a sqldatasource that has a select parameter(the default value was just for testing)
<asp:SqlDataSource ID="dsCountryByTripID" runat="server" ConnectionString="<%$ ConnectionStrings:bahDatabase %>" SelectCommand="spSelectCitiesByTripID" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:Parameter Type="Int32" Name="tripID" DefaultValue="56" /> </SelectParameters> </asp:SqlDataSource>
during my Gridview1 row databound I am trying to grab the columns that match the tripID. But dsCountryByTripID which is my datasource, is only going inputted with the last tripID.
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e) { GridView gv2 = (GridView)e.Row.FindControl("GridView2"); if (e.Row.RowType == DataControlRowType.DataRow) { dsCountryByTripID.SelectParameters.Clear(); DataRowView drv = (DataRowView)e.Row.DataItem; string tripID = (drv["pkiTripId"]).ToString(); dsCountryByTripID.SelectParameters.Add("tripID", DbType.Int32, tripID); //gv2.DataBind(); //e.Row.DataBind(); } }
C# - Add A Parameter To Sqldatasource During RowDataBound
Aug 11, 2010So I have a gridview within a gridview (I have a one to many table) my first gridview is working well, but my second gridview has a sqldatasource that has a select parameter(the default value was just for testing)
<asp:SqlDataSource ID="dsCountryByTripID" runat="server"
ConnectionString="<%$ ConnectionStrings:bahDatabase %>"
SelectCommand="spSelectCitiesByTripID" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Type="Int32" Name="tripID" DefaultValue="56" />
</SelectParameters>
</asp:SqlDataSource>
during my Gridview1 row databound I am trying to grab the columns that match the tripID. But dsCountryByTripID which is my datasource, is only going inputted with the last tripID.
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
GridView gv2 = (GridView)e.Row.FindControl("GridView2");
if (e.Row.RowType == DataControlRowType.DataRow)
{
dsCountryByTripID.SelectParameters.Clear();
DataRowView drv = (DataRowView)e.Row.DataItem;
string tripID = (drv["pkiTripId"]).ToString();
dsCountryByTripID.SelectParameters.Add("tripID", DbType.Int32, tripID);
//gv2.DataBind();
//e.Row.DataBind();
}
}
SqlDataSource Set SessionParameter Programatically
Sep 6, 2010I have a StoredProcedure called "usp_posts_getall" and it has 1 parameter called "@thisCategoryID"
in my "thisCategoryID", any values other than 0(zero) will return all the records in my Posts table.
Now I have a category menu items and each time I select, I set the value in my Session name called "SelectedCID".
So, How Do I ...
Create a SessionParameter Programatically in SqlDataSource?
Listview And SQLDataSource Render Nothing?
Feb 12, 2010I've never used either of these 2 controls before and I'm stuck with no visible rendering of the page (compiles and runs but produces nothing); I have no code behind file with this simple asp.net page and I am using Visual Studio 2008:
<%@ Page Language="C#" AutoEventWireup="true"
CodeBehind="Index.aspx.cs" Inherits="zList.Index" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListView ID="CategoryList" runat="server"
DataSourceID="Categories">
<LayoutTemplate>
<ol>
<asp:PlaceHolder runat="server" ID="itemPlaceholder">
</asp:PlaceHolder>
</ol>
</LayoutTemplate>
<ItemTemplate>
<li><%# Eval("AttrDesc")%></li>
</ItemTemplate>
</asp:ListView>
</div>
</form>
</body>
</html>
<asp:sqldatasource runat="server" id="Categories"
ConnectionString="<%$ ConnectionStrings:ZIPeeeConnectionString2 %>"
SelectCommand="SELECT AttrID,AttrDesc FROM dbo.tblAttributes1">
</asp:sqldatasource>
Here is the connection string section from web.config (I have tried both connection strings separately and they both result in nothing rendered):
<connectionStrings>
<add name="ZIPeeeConnectionString" connectionString="Data Source=MOJITO;Initial Catalog=ZIPeee;Integrated Security=True" providerName="System.Data.SqlClient"/>
<add name="ZIPeeeConnectionString2" connectionString="Data Source=MOJITO;Initial Catalog=ZIPeee;User ID=sa;Password=" providerName="System.Data.SqlClient"/>
</connectionStrings>
I am getting no runtime errors and no errors during the build. The simple query works fine from SQL Query Analyzer (i.e. SQL Server 2000). Any ideas?
EDIT-UPDATE:
Here is what I have in my .ASPX.CS code behind file and I cannot get the debugger to stop on the breakpoint on the .DataBind method:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace zList
{
public partial class Index : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
CategoryList.DataBind(); // breakpoint set here but debugger won't stop here
}
}
}
By the way, I fired up SQL Profiler and it appears the SQL select is not even being fired against
the server. As I said, the page is empty - just this junk when I scrape it via View Page Source:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1 /DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head><title></title></head>
<body>
<form name="form1" method="post" action="Index.aspx" id="form1">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKMjAyMTkwMzQ3OQ9kFgQCAw9kFgICAQ8UKwACDxYEHgtfIURhdGFCb3VuZGceC18hSXRlbUNvdW50Av////8PZGRkAgUPD2QPEBYDZgIBAgIWAxYCHg5QYXJhbWV0ZXJWYWx1ZWQWAh8CZBYCHwJkFgMCAwIDAgNkZBgBBQxDYXRlZ29yeUxpc3QPZ2TCuhjvuwDRjaGJssTwiDXpAv/fdw==" />
</div>
<div>
</div>
</form>
</body>
</html>
Use A Custom Parameter With SqlDataSource?
Jan 17, 2011I want to add a GridView control to one of my views that is backed by a SqlDataSource. The SelectCommand query is parametrized on the aspnet_Users.UserId GUID for the currently-logged-in user, so I need a way to pass the user ID as a parameter.
I read How to utilize ASP.NET current user name in SqlParameter without code-behind and decided to create a custom Parameter named UserIdParameter:
namespace MyApp.Web
{
public class UserIdParameter : Parameter
{
public UserIdParameter(string name)
: base(name)
{
}
protected UserIdParameter(UserIdParameter parameter)
: base(parameter)
{
}
protected override Parameter Clone()
{
return new UserIdParameter(this);
}
protected override object Evaluate(HttpContext context, Control control)
{
return Membership.GetUser().ProviderUserKey;
}
}
}
In the ASPX view I then added:
<%@ Register TagPrefix="my" Namespace="MyApp.Web" %>
in a line after the <%@ Page ... %> line as well as:
<SelectParameters>
<my:UserIdParameter Name="UserId" />
</SelectParameters>
within the asp:SqlDataSource element.
Unfortunately I get a Parser Error ("An error occurred during the parsing of a resource required to service this request. review the following specific parse error details and modify your source file appropriately.") with the following highlighted in red:
<my:UserIdParameter Name="UserId" />
Visual Web Developer 2010 Express is also informing me that "Element 'UserIdParameter' is not a known element. This can occur if there is a compilation error in the Web site, or the web.config file is missing."
Do I need to modify Web.config in some way? If not, what do I need to do to be able to use my custom UserIdParameter parameter?
Databases :: SqlDataSource On Oracle 64 Bit?
Aug 2, 2010I have an Asp.net web application targeting .Net2.0 and my databse is oracle, I used SqlDataSource Control to communicate with oracle database its working fine on my development server, but on my production Oracle is 64 bit so im getting an error like
"<asp:ControlParameter doesnot have a property DbType="Int32"> "
i tried with Int64 also but still im getting the same error
following is the markup of sqldatasource i used
<
asp:SqlDataSource
ID="sdsEmployees"
runat="server"
ConnectionString="User Id=user;pwd=user1;server=prod" ProviderName="System.Data.OracleClient"
SelectCommand="GetEmployeeInfo" SelectCommandType="StoredProcedure"
OnSelecting="sdsEmployees_OnSelecting">
<SelectParameters> <asp:ControlParameter
ControlID="txtNumber"
DbType="Int32"
/> </SelectParameters> </asp:SqlDataSource>
C# - Using The Selected Items In Sqldatasource?
Jul 22, 2010How can I use the results of the select method in SqlDatasource like assign the returned id to a variable ?
View 1 RepliesExport To Excel Without SqlDataSource
Jul 16, 2012I am exporting gridview to excel.I have below code to generate excel sheet.I have used Datagrid to populate grid using SqlDataSource. below code generate excel sheet when used SqlDataSource.
Code:
GridView1.AllowPaging = false;
GridView1.GridLines = GridLines.None;
GridView1.DataBind();
ChangeControlsToValue(GridView1);
Response.ClearContent();
[code]...
but when i populate grid without SqlDataSource, in that case 'gridView.Controls.Count' stores 0 value and excel sheet contains zero(0) record. how to modify this code without using SqlDataSource.
What Is The Difference Between .DLL And .EXE
Jul 29, 2010I would like to know about the difference between .DLL and .EXE?
View 1 RepliesWhat Is The Difference Between <%= And <%:
Sep 2, 2010I thought that <%: had replaced <%=, since mentions on [URL]Prior to ASP.NET 4, the <%= %> syntax was used to execute code and write it out to the page. Starting with ASP.NET 4, you should always use the <%: %> syntax instead..."
However, I've noticed that
<img src='<%=ResolveUrl("~/Images/MyImage.jpg")%>' alt="blah">
works, whereas
<img src='<%: ResolveUrl("~/images/MyImage.jpg")%>' alt="blah">
doesn't.
I'm not sure what the name for these types of expressions are so I've had trouble googling it.
What Is The Difference Between The 1.0,2.0 And 3.5
Jun 22, 2010what is the difference between the 1.0,2.0 and 3.5
View 6 RepliesADO.NET :: Difference Between L2S And EF?
Jul 11, 2010What is the difference between L2S (Linq to SQL) and EF (Entity Framework), much appreciated if you highlight the cons and pros?
View 6 RepliesDifference Between <%: And <%=?
Sep 3, 2010Possible Duplicate:
ASP.NET “special” tags
I hope this isn't too much of a newbie question. I seem to always use the correct syntax, but I don't really understand why I'm using the <%: and <%= in ASP.NET, and I was hoping someone could clarify for me. I found this article which explains <%= and <%#, but wasn't able to find anything in Google on <%:.
Examples of where I have used the various syntax:
<div>
<%: Html.LabelFor(model => model.Type) %>
<%: Html.TextBoxFor(model => model.Type)%>
</div>
and
<div id="header-menu">
<ul>
<li><%= Html.ActionLink("Home", "", "Home" )%></li>
</ul>
</div>
Possible Answer (per ChrisF): ASP.NET "special" tags
Difference Between Asp And C# ?
Dec 29, 2010Are asp and c# completely different things or ..?
Is asp a language or asp.net? Are c, c++, c# languages?
What is a framework, stack, language
Difference Between C#.net And Vb.net?
Jun 18, 2010What is the difference between c#.net and vb.net ?
I faced this question in an interview. Any technical difference is there ? I heard that there are two methods additional in vb.net which are not there in vb.net.