DataSource Controls :: Retrieving Data From SQL Server?

Mar 17, 2010

I try to use one Calendar, i have example with XML, but i wont to read from SQL,


View 2 Replies

Similar Messages:

DataSource Controls :: Storing And Retrieving Doc / Pdf / Xls Files In SQL Server 2005?

Jan 8, 2010

I am working on document management system. finding guide / code for Storing and Retrieving doc/pdf/xls files in SQL Server 2005.

View 1 Replies

DataSource Controls :: Saving And Retrieving Images From Sql Server 2005

Jan 5, 2010

I am facing a problem with retrieving an image and showing it on grid. I migrated MS Access database to sql server. Image are visible in Crystal report when fetched from the same database (migrated sql server database). But same images are not visible in ASP.Net grid view or simple image control. Following is my code

SqlConnection oConn =
SqlCommand oraCmd = oConn.CreateCommand();
oraCmd.CommandText = "select top 1 photo from [test] where photo is not null";
SqlDataReader dr =
dr = oraCmd .ExecuteReader ();
if(dr.Read ())
if (dr["photo"] !=
Response.ContentType = "image/gif";

This function is getting called from another page . "hlopen" is hyper link in the grid. hlopen.NavigateUrl = "GetPhoto.aspx?id=1";

View 1 Replies

DataSource Controls :: Storing Image To SQL Server And Retrieving From Two Diff Sources?

Feb 18, 2010

I am storing image (jpeg) files into SQL server 2005 using MS Access Forms. When I try to read and render it on a webpage using and C# code behind, it could not read it.

But if I write the image to SQL server using ASP.NET C# and then read it back using ASP.NET C#, it render the image just fine in the browser.

Does anyone know if Access write the blob is difference than ASP.NET write the blob into SQL server? I am using the same varbinary as my column in the database.

View 3 Replies

DataSource Controls :: Retrieving Sql Data Into An Array?

Feb 24, 2010

I'm new to, 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")


View 6 Replies

DataSource Controls :: Retrieving Data From Multiple Tables?

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:



View 3 Replies

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

DataSource Controls :: Data Retrieving And Checking Queries?

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

DataSource Controls :: Select Query For Retrieving Data Between 2 Dates?

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

DataSource Controls :: Retrieving And Displaying Only Current User's Data?

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

DataSource Controls :: Is Linq Just For Retrieving Data Or Can You Send Data To The Database Using It?

Mar 18, 2010

Is linq just for retrieving data or can you send data to the database using it?

View 3 Replies

DataSource Controls :: Retrieving SQL Filestream Data With Visual Studio SQLDataSource?

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)">
<asp:Parameter Name="CP_IDString" Type="String" />

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())

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

DataSource Controls :: Retrieving Image Binary Data And Displaying On Gridview

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

DataSource Controls :: Binding Controls And Retrieving Data?

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


View 7 Replies

DataSource Controls :: Retrieving Records From DB Using SQL Class

Feb 3, 2011

When I used the (way #1) below I could retrieve search result from my DB

Way #1:


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)


data access layer:


I keep getting this error: Procedure or function 'SP_Search' expects parameter '@SEARCHTYPE', which was not supplied.

View 6 Replies

DataSource Controls :: Retrieving Tables Using Reader?

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;


View 2 Replies

DataSource Controls :: Retrieving Images From Database?

May 1, 2010

iam using with c#

iam saving two images in database but while retreving only one image is displaying

can you correct my code


View 5 Replies

DataSource Controls :: Retrieving A Guid From The Database?

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:


I keep getting the error: Specified cast is not valid.

View 2 Replies

DataSource Controls :: Uploading And Retrieving Picture From Database .net

May 26, 2010

I have a picture that i would like to upload to a database. I am really new to this so i am not sure what to do. I have been using the following code below to upload and retrieve the picture, looks like its uploading ok, but i cant retrieve it. The code i am using comes from this site,

Uploading Content to database

if (cmboTopic.Text == "Blu-Ray Movie")[code].....

View 4 Replies

DataSource Controls :: Retrieving List Of Categories For A Post?

Jun 4, 2010

I have a ListView inside my UserControl which is showing a list of posts from the table named posts. I've also got a category table which is full of the categories. I then have another table which contains the PostID and the CategoryID so that posts can have multiple categories. I was wondering, in my ListView at the moment I only have a list of the posts but I would like to add, for every post in the listview, the cateogires it is in.

View 12 Replies

DataSource Controls :: Retrieving Identity Value After Using DataAdapter.Update?

Jul 29, 2010

I am not sure how to do this. I would like to merge the identity back into the dataset.

View 2 Replies

DataSource Controls :: Retrieving Properties Of Anonymous Type?

Apr 12, 2010

Usual situation: DataList and LinqDataSource with anonymous types...

Is there any way besides reflection to retrieve properties of anonymous typed DataItem in DataList_ItemDataBound event?

View 2 Replies

DataSource Controls :: Retrieving Binary Files From SQL And Download It?

Mar 17, 2010

My apps required me to store upload files into SQL binary fields. And then allow users to retrieve the files and either chose an apps to view them or save on disk. These files can be in diff formats, not just one type.

I have been reading about using the Response.ContentType method and Response.AddHeader method. The issue is the users can upload anykind of documents, ie: MS words, Xcel, JPEG,TIFF.... So at the time of downloading, I have no way of knowing that type it is to put in the Response.ContentType.

Can't I just stream it to the browser, let the download dialog box handle the type selection? as in when you download a file, the dialog box would ask if you want to select an app to open the file or save it on disk. How would I do so ?

View 1 Replies

DataSource Controls :: Error Retrieving Image From DB In Binary Format?

Jun 10, 2010


I am using above mentioned code to insert image in binary format and display

Insertion code is working fine but image cannot be retrieved from DB

(Note: there is no syntex error in Code)

View 1 Replies

DataSource Controls :: Retrieving Strings From Database Table Instead DateTime - Formatting

Mar 23, 2010

On UI Ajax calendar control is used to allow the user Expiry Date as shown below. As this is one of the controls in search, when the Search button is pressed using SQL statement (copied below) data is retrieved from ExpiryDate column of the table. The table creator declared the column type as string and the dates are saved as single digits(Example: 2/2/10 sometimes and sometime as double digits (Example: 02/02/10) I like to know the best practice in retrieving both type of strings from database table. Calendar control


SQL(part of stored proc)


with in button click event stored procedure is called to return search results.

View 7 Replies

Copyrights 2005-15, All rights reserved