DataSource Controls :: Retrieving Of The Data Using 3-tier Application?
Feb 6, 2010
but i have a problem to retrieve value from the database in the textbox using 3-tier application. ]
in the App_data i have following folder.
1> employeeBAL in this i have 1class file called empbasicinfoBLL.cs
2> employeeDAL in this i have test_data.xsd
in the basic details folder i have one page Basic information(employee basic info) in this i want that when user will log in the site [using username and password] after successful login when user will click on the Basic information then he will able to see his [name, employee no, first name, last name] etc on the page [i don't want to use grid-view to retrieve the details becoz i am using the table in this i am using Lable and Textbox for each] and this data should come from the EmployeeBAL.
View 1 Replies
Similar Messages:
Mar 10, 2010
I am upgrading and re designing my current ASP.NET 2.0 website to ASP.NET 3.5 to take advantage of the 3.5 feature set.As part of the re design I am going to use Linq to SQL classes.
The web based application I am working on is an N-Tier application. In the past I have always used an ObjectDataSource when binding against UI controls.I just read an article about the LinqDataSource.After reading this article I am toying with the idea of using the LinqDataSource for selecting data into controls where I only want to select and not change the data (i.e. drop down list boxes or gridviews that don't perform inserts,updates or deletes).Before I go down this path,I was wondering if this is a bad idea and that I should just stick with the ObjectDataSource?
View 7 Replies
Dec 20, 2010
I have a Web Application in 3 Tier(UI,BL,DAL).
I have a repeater control and I just can't figure out on how to implement the pagination in the repeater control.
Here's my code:
UI:
private void QSearchProductsWheels(int catid, int brandid, string keyword)
{
this.wheels.DataSource = QSearchProductsDS(catid, brandid, keyword);
this.wheels.DataBind();
[Code]....
DAL:
of course the data access...
View 3 Replies
Aug 31, 2010
Say you have a form designed in Silverlight(Front end)-Asp.NEt(business layer)-SQl(bakcend)Should data validation occur on all 3 layers or just the presentation layer or a combination of the front end with the other 2 e.g. validating an email address? I'm trying to undestand as to why if data has been validated on the presentation why further data validation would be necessary especially if there would be large amounts of data being validated and this could potentially slow down database transactions?
View 4 Replies
Mar 17, 2010
I try to use one Calendar, i have example with XML, but i wont to read from SQL,
[Code]....
View 2 Replies
Feb 24, 2010
I'm new to asp.net, php had this function that could store sql date in an array, I can't find something similar in .net, so this is what I came up with so far.
Sub Compareid()
Dim queryString As String = "Select top 2 id from my_videos order by id desc"
using connection As New SqlConnection(ConfigurationSettings.AppSettings("sqlacct")
[code]...
View 6 Replies
Aug 17, 2010
I have hard time trying to find the solution to retrieve data from multiple tables in one database.
table Kategorije has fields: idKategorija, naziv, opis table Clanak has fields: idClanak, idKategorija, naslov, autor,...
Kategorije.idKategorijais joined with Clanak.idKategorija, but that isn't the solution because I want my web site to show the Kategorije.naziv instead of Kategorije.idKategorija. This is the code I'm currently using to get idKategorije shown on my web site:
[Code]....
[Code]....
View 3 Replies
Jul 28, 2010
I'm currently working on a FOREX Live Trading project that I'm implementing.
I already have a database that stores the CURRENCY PAIR, BUY/SELL, PRICE AND QTY.
But I have a huge problem.
Scenario that is:
A person BUYS EUR/USD at a PRICE of 1.29900 @ quantity 100,000. (This will be recorded in the database table)
Then he BUYS EUR/USD at a PRICE of 1.29950 @ quantity 100,000. (This will then be recorded in the database also)
Then he decides to SELL his EUR/USD at a PRICE of 1.31000 @ quantity 200,000 all out. (How can I check from the database if he previously had make a transaction of BUY/SELL, so that I can do my necessary calculations for the P/L Statement)
View 3 Replies
Jan 8, 2010
I want to create an application where I need to enter date to the ms access database.
I am a bit confused regarding how to make the user to enter date. The options avaliable are:
a. Shall I use a textBox?
b. Shall I go for 3 drop down lists?
or something else.
Some more questions:
1. what date format shall i use? (dd-mm-yyyy, dd-mmm-yyyy, etc, etc or anything else)
2. What datatype shall i use to store the date in the database?
3. What SQL query shall i use to retrieve the data between 2 dates?
let me know if there are multiple options available regarding this application.
I want to make this application as easy as possible for the user.
View 4 Replies
Jan 21, 2010
Having trouble with a web page and connecting to SQL DB. Basically I have a form view table connected up to a SQLDataSourceControl and what I want displayed in the form is only data that has been assigned to the user that is logged on now. I have a "ViewAll" page, which lists EVERY field, regardless of who it is assigned to, but the "MyTasks" page should only retrieve the data of the current user.
I have two tables in my DB, the "Users" table, with user data (including an ID number) - this is used again in the "Tasks" table as a foreign key called "AssignTo". Therefore if user Joe Bloggs with ID number 5 logs on, whenever someone assigns a task to him, they will select number 5 in the "Task" table, as this relates to his User ID.
View 10 Replies
Mar 18, 2010
Is linq just for retrieving data or can you send data to the database using it?
View 3 Replies
Jun 4, 2010
Is there anything special you have to do to retrieve Filestream data using a SqlDataSource? I'm using VB and have this as my sqldatasource:
<asp:SqlDataSource ID="SqlDataSourceReadPD" runat="server" etc...
SelectCommand="SELECT [PDIPAttachment] FROM [PositionDescriptions] WHERE ([CP_IDString] = @CP_IDString)">
<SelectParameters>
<asp:Parameter Name="CP_IDString" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
PDIPAttachment is a FILESTREAM column in my table called PositionDescriptions
and this is some of my VB cod:
Dim dv As DataView = DirectCast(SqlDataSourceReadPD.Select(DataSourceSelectArguments.Empty), DataView)
Dim dr As DataRowView
For Each dr In dv
Dim data as Byte() = System.Text.Encoding.ASCII.GetBytes(dr("PDIPAttachment").ToString())
Next
The Filestream data has a PDF file in it, but what I"m getting back in "data" are 13 bytes consisting of: "System.Byte[]".
View 2 Replies
Feb 23, 2010
i am currently facing some problem retrieving image for display on a gridview control. the Image data type in the data table is "image". the data that is stored inside the database is in this format "<Binary data>". may i ask if it is possible tojust retrieve a image data of this format and display in the gridview? or do i need to store the image in a image folder for retrieval?
View 3 Replies
May 18, 2010
i have a database and binded it to a drop down list to show all the IDs on page_load. This is working fine
i have placed two textboxes and one button on my same form. when i chose a specific ID from my drop down list and click on the button the textboxes should show the respective data(name and gender). But when i click on chose an id and click the button it show datatype error...still it did not
[code]....
View 7 Replies
Mar 1, 2010
trying to switch to better coding practises, I am totally confused about which path to choose. For the past year I was just coding through classic asp coding methodology. Now I know about things as
3 tier custom 3 tier with Strongly typed data sets N tier applications Custom entity objects and so on
Can someone recommend me an approach for designing web applications from these? Some book or tutorial reference with simple CRUD application that would help me. I am currently stuck with strongly typed data sets as I cant find CRUD tutorials with that approach. I would like to just choose the right approach and build on it.
View 4 Replies
Sep 22, 2010
I'm trying to decide which of the two factory patterns I should use in my Asp.Net applications:
1 : All DAL providers derive from same abstract base class DepartmentsProvider, which defines public interface of the class ( all the necessary CRUD methods for which derived classes (providers ) provide a concrete implementation ). BLL layer instantiates correct provider by calling DepartmentsProvider.Instance:
public abstract class DepartmentsProvider
{
static private DepartmentsProvider _instance = null;
/// <summary>[code]....
In first case we implement new provider by deriving from DepartmentsProvider class, while in second case new provider is implemented by deriving from DBProviderFactory. What are pros and cons of each implementation?
View 1 Replies
Jul 2, 2010
I' am trying to write a aplication using a 3 Tier Model
Data Access Layer <--> Business Logic Layer <--> Presentation Layer
But now i am facing a problem, i need to Handle Transactions i already found a interesting article
[URL] but i have some doubts.
For example when i need to iterate to a Grid in the presentation Layer how will i Use the Transactions??
[Code]....
View 2 Replies
Nov 1, 2010
I want to develop a three tier architecture app.I have no idea when weplace our BLL and DLL code in different server how to connecct this BLL and DLL code to our Website(UI).
View 4 Replies
Feb 3, 2011
When I used the (way #1) below I could retrieve search result from my DB
Way #1:
[Code]....
But When I use( way#2) "separating my code to Presentation layer and data access layer ( using SQL HELPER CLASS )"
Way # 2
Presentation layer: protected void btn_Search_Advance_Click(object sender, EventArgs e)
[Code]....
data access layer:
[Code]....
I keep getting this error: Procedure or function 'SP_Search' expects parameter '@SEARCHTYPE', which was not supplied.
View 6 Replies
Jan 20, 2010
I'm quite new to ASP.NET and i was wondering if someone could answer some of my questions.1. What is the difference between a DataTable and an Array? Is the DataTable a serverside control? Is it exposed to the user?2. Does the reader retrieve the column names? If so- how can I capture them? Are they the first row?2. Is it possible to populate an Array using the following sort of code, and if so- how?:
SqlCommand tableCommand = new SqlCommand();
SqlConnection tableConnection = new SqlConnection();
tableCommand.Connection = tableConnection;
[code]...
View 2 Replies
May 1, 2010
iam using asp.net with c#
iam saving two images in database but while retreving only one image is displaying
can you correct my code
[Code]....
View 5 Replies
Jun 14, 2010
I am trying to retrieve a Guid from the database but my application just isnt having it. I have a field in the database called "LoginUserId" and it is of type "uniqueidentifier".In my User Model I have:
[Code]....
I keep getting the error: Specified cast is not valid.
View 2 Replies
Sep 29, 2010
I have an ASP.NET project which is pretty n-tier, by namespace, but I need to separate into three projects: Data Layer, Middle Tier and Front End.
I am doing this because...
A) It seems the right thing to do, and
B) I am having all sorts of problems running unit tests for ASP.NET hosted assemblies.
Anyway, my question is, where do you keep your config info?
Right now, for example, my middle tier classes (which uses Linq to SQL) automatically pull their connection string information from the web.config when instantiating a new data context.
If my data layer is in another project can/should it be using the web.config for configuration info?
If so, how will a unit test, (typically in a separate assembly) provide soch configuration info?
View 3 Replies
Aug 14, 2010
Well i want to know how many architecture approaches we can use in asp.net web application. i was asked about it. i told him that i use a appcode for dal and bal and the presentation layer. but he was not convince. basically i want to ask what web application architecture an asp.net web application guru would use keeping in mind the different metrics ( i am talking minus web services or any SOA thing)
View 1 Replies
Aug 2, 2010
I'm building a new n-tier web application and I would like to know the performance differences between developing my tiers in one single assembly (each tier with its own namespace) or into different assemblies, one for each tier.
View 1 Replies
