Forms Data Controls :: ADO.NET Versus SqlDataSource
Jun 29, 2010
I am developing web-app in .NET for 5 months (and enjoying it =)) and I am reading 3 books, all of them teachs at least 2 methods for acessing data: ADO.NET and SqlDataSource object.
I am used to work with ADO.NET method because I feel that even if it needs coding by hand, I can separate the SQL routines from the page and I can customize database routines better.
For now I am using DataReader mode because the application and the database is on the same server and there is only 1Gb RAM available so there is no advantage using DataSet on this moment.
Am I thinking this right? There are some things with SqlDataSource that I don't know how to do it well...
For example:
I have a routine that inserts a record on a table then gets the ID of this record using SCOPE_IDENTITY() function of SQL Server, than it uses this ID to insert another record on another table. Because I use a one-to-many relationship on multiple tables...
How can I work this situation using SqlDataSource object, is it even possible?
View 2 Replies
Similar Messages:
Mar 8, 2011
If 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 Replies
Feb 25, 2011
I 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 Replies
Aug 28, 2010
What ive been using now is getting datas in code-behind, passing datasource into a Session, re-binds it to a gridview whenever there's paging/sorting needed. What i want to know is what is better if its performance we are talking about?
Is it datasource into a session Or SqlDataSource for which I know whenever paging/sorting needed is that sqldatasource opens up a DB connection to get the datas again?
View 6 Replies
Jan 18, 2010
1. I know about collections but I dont remember the precess. I know you drag a sqldatasource control on the form(Select everything in the database ie. selct *) and then delete it. But how do I use it i code.
Example. I need to select services where country=canada from the Agencies table.
2. I know how to manually pull data from an access database using the code below. I want to know how to pull data from a sql database just like the one below.
3. explain the difference between Collections and manually pulling it like the one bellow?
<code>
<script>
Stringpath = Server.Mappath = Server. MapPath(/website");
String connStr = Provider=Microsoft.Jet.OLEDB.4.0" +"DataSource="+path+
\Database;
OleDBConnnection conn = new OleDBConnection(connStr);
conn.open();
OleDbCommand cmd= new OleDBCommand();
cmd.COnnection = conn;
cmdCommandText = "Select * From [Suppliers];
OledbDataReader dr= cmd.ExecuteReader();
Response.write(dr.getvalue(1);
View 1 Replies
Oct 20, 2010
I have a GridView with a couple of buttons (asp:Button) in it (last row). Both of them have a CommandName attribute on them and this is handled server side in a grid_RowCommand event handler. Now, this works fine. However, I need to add client side code (Javascript/jQuery) to disable the two buttons when someone clicks on or the other. This is to prevent the user from double-clicking and creating potential havoc.
The way I have done this is by adding OnClientClick on both buttons which calls a javascript function that uses jQuery to disable the two buttons. This works fine, it's just that the page doesn't post back and so the RowCommand event handler never fires.
[code]....
View 2 Replies
Sep 16, 2010
What is the difference between; Deploying an application Releasing an application Implementing an application
View 1 Replies
Jul 23, 2010
I've gone rounds with this ever since I started programming classic ASP 12 (or so) years ago and I've never found a great solution because the architecture of ASP and ASP.NET has always been a swamp of bad practices, magic shared singletons, etc. My biggest issue is with the HttpApplication object with its non-event events (Application_Start, Application_End, etc.).
If you want to do stuff once for the entire lifespan of an HTTP application, Application_Start is the obvious place to do it. Right? Not exactly. Firstly, this is not an event per se, it's a magic naming convention that, when followed, causes the method to be called once per AppDomain created by IIS.
Besides magic naming conventions being a horrible practice, I've started to think it might be a reason there exist no such thing as a Start event on the HttpApplication object. So I've experimented with events that do exist, such as Init. Well, this isn't really an event either, it's an overridable method, which is the next best thing.
It seems that the Init() method is called for every instantiation of an HttpApplication object, which happens a lot more than once per AppDomain. This means that I might as just put my startup logic inside the HttpApplication object's constructor.
Now my question is, why shouldn't I put my startup logic in the constructor? Why does even Init() exist and do I need to care about Application_Start? If I do, can anyone explain why there is no proper event or overridable method for this pseudo-event in the HttpApplication object?
And can anyone explain to me why in a typical ASP.NET application, 8 instances of my HttpApplication are created (which causes the constructor and Init to run just as many times, of course; this can be mitigated with locking and a shared static boolean called initialized) when my application only has a single AppDomain?
View 2 Replies
May 14, 2010
I am trying to tie a sqlDatasource to a Stored Procedure. The stored procedure looks like...
[Code]........
View 2 Replies
Mar 3, 2010
I have a table with articles. Every article has a column named category which value is either 1 or 2 On my landingpage the article headers are displayed as hyperlinks. All the articles with category 1 will be displayed in a repeater control on the left side of page and all the articles with category 2 will be displayed in another repeater control on right side of page. I know I can bind the repeaters to two different sqldatasource controls with different SELECT statements. But I wonder if I can do this by only using one sqldatasource control, and if this is better and proper way of doing it. If so, do I create a (datatable?) and do the sorting there?
View 5 Replies
Nov 25, 2010
i designed a gridview to update, delete the records using sqldatasource, (there is no code in my aspx.cs file) but i dont know how to add the new row the gridview. so that if the table is empty then i cant add / update / delete the data.
how to Add new record on gridview using SQLDatasource without any code behind code?
View 6 Replies
Mar 14, 2010
I have a standard gridview, with the standard paging and sorting interface enabled.The application holds appointments for three organisational units, with a maximum of 3000 appointment records being returned across all three units. The appointment records are quite small.
The choice I am faced with is to:
1. Have an Org Unit dropdown which returns to the datasource on change of selection and at inital databind, and returns appointment records for one org unit at a time i.e. approx 1000 records.
2. Have the objectdatasource return all 3000 appointment records for all org units at initial databind, and filter the objectdatasource by org unit on change of selection, thereby saving a trip to the datasource.
I guess the question boils down to identifying the point at which querying the datasource by org unit is more efficient than filtering the records returned by org unit.
Is 3000 records a lot for a gridview to be paging and sorting etc.
View 3 Replies
Oct 4, 2010
Can anyone explain me that what is the diff between DataBinder.Eval Vs DataBinder.GetPropertyValue?
View 2 Replies
Jun 14, 2010
I Have an InsertTemplat in FormView that has a DD List.
I also have an Insert Parameter in a SQLDataSource that tries to reference it but can't.
Is my only solution to use event code to move the data to the SQL Parameters?
[Code]....
View 1 Replies
Jun 18, 2010
i am facing a minor problem but can't find out its syntaxi have listview, and inside the template i have 2 labels, in design time i bind 1 label to one column thatis 'type' and depending upon this type i want to bind other labels to different columnsif type is question than 2 label will have to show data of question columnif type is job than 2 label will have to show data of job, so on........how to accomplish this,in databinding event handler i can check the value of typebut i want to know the syntax of binding 2 label in run time, with different fields using EVAL
View 3 Replies
Mar 30, 2011
I am using Visual Web Developer (VWD)and I dragged in i.e created a Gridview. In the codebehind of the page, I will like to declare an sqldatasource and get data from a database using the sqldatasource and then bind the sqldatasource to the Gridview. PS: I know how to drag-in an sqldatasource and attach it to the gridview using VWD but this time, I want to do this declaratively in the codebehind.
View 3 Replies
Mar 17, 2011
I have a gridview tied to a sqlDataSource. I want to filter it using FilterExpression of SqlDataSource. The controlParameter that I want to use is dropdownList SelectedItem.Value. This value is an integer. I am getting this exception: System.Data.EvaluateException:{"Cannot perform '=' operation on System.Int32 and System.String."}
[Code]....
View 3 Replies
Dec 13, 2010
I have two SqlDataSources in my page for a combo box. One loads all the data from a table, and the other one will preselect the combo box data when editing the page record.
View 1 Replies
Apr 5, 2010
I want to retrieve sqldatasource row from database and if = 1/0 set checkbox to checked or not
I am using the sqldatasource and formview. The sqldatasource is bringing in 1 database item via querystring id
I want to read the row entitled 'IsCharacter' which is either 1 or 0 value. If it is 1 I want the checkbox in my formview to be checked. If it is 0, I want it to not be checked.
I could do this with a dropdownlist with value of 1 or 0 which would be easier for me, however, I don't think it would be as user friendly as a checkbox.
Perhaps a radiobuttonlist would be better?
View 7 Replies
May 27, 2010
In my application, I am using DataList. In Item Template I added One GridView and SqlDataSource to populate data in GridView. DataList having one DataKey field, I want to pass this DataKey Value to the SqlDataSource as Parameter.
I tried this by Using Following:
<SelectParameters>
View 2 Replies
Mar 15, 2011
I have big filter coming from database by using storedprocedure. This stored procedure contains about 12 parameters. In asp.net page I select these values and after doing that I want to pass these values to SqlDataSourec which is bound to gridview. How can I pass these values to SqlDataSource, manually in codebehind?
View 8 Replies
Feb 11, 2011
I need to pass a user selected value from a databound DropDownList into a GridView SQLDataSource select statement so the correct records will be selected. I have found lots of documentation on DropDownLists and sqldatasources but nothing that connect the two.
View 5 Replies
Jan 29, 2010
I am facing a small issue in using a DropDownList that has only two values (AND and OR) which i want to use to configure a SQL Query in a SqlDataSource. How can i use this thing by passing the value in a SqlDataSource Select Query in such a way to Bind the Result to a GridView. I want something like this -
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen @Option InvoiceNo = @invoiceno where @Namen is from a DropDownList and InvoiceNo is from a TextBox
I m having a problem in specifying this @Option parameter from a DropDownList which contains only two list items - AND and OR. On the Basis of the Selected Value from this DropDownList i want to execute query like
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen AND InvoiceNo = @invoiceno
or
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen OR InvoiceNo = @invoiceno
Using the Query with @Option gives me a Parsing Error. Why is that so. How can I implement this scenario.
View 3 Replies
Feb 19, 2010
I am using SqlDataSource to populate <asp:ListBox>.
Sql Select query returns all the Unique city names. Then <asp:Listbox> is populated. Populated listbox looks like
Houston
Dallas
Austin
...
...
But I want to add "Choose City" at index 0 so the listbox look like
Choose City
Houston
Dallas
Austin
I am not allowed to modify select query (otherwise I would have used the UNION in select query)
View 3 Replies
Sep 2, 2010
I am working on a form that I would like to display a dropdownlist or textbox to insert data into the same field.
Currently it is setup where the end user can use one or the other but not both. I am running into a problem getting with the insert parameters for the secondary control. In this case the textbox.
Is it possible to use and Or statment in my Insert Query? I have tried to no avail.
[Code]....
View 3 Replies
