.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Retrieving information from database

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :ASP.Net

Hi, I have an aspx form that is meant to add a new prescription for a doctor system. I've created the database and dataset needed, but the problem is that the doctorID and patientID has to be able to select from the database, not entered in as a plain text. The form look something like this (I did this in DetailsView in MS Visual Studio 2010):

DoctorID:  [textbox]

PatientID: [textbox]

prescription details: [textbox]

Insert   Cancel

as you can see, only the prescription details needed to be entered in and the doctorID and patientID needed to be selected from the database (in a dropdown list maybe) and it shouldnt allow any text to be entered in. I did the above tables using a DetailsView in Microsoft Visual Studio 2010. However I can't seem to make the doctor and patient ID field be dropdown box which allow me to choose the current doctor and patient in the Doctor and Patient table in the databse.  Can anyone tell me how to do it with Design View in Visual Studio? Cause the source view is kinda confusing for me. 

Thanks in advance!

View Complete Post

More Related Resource Links

ERROR [HY000] [Informix .NET provider][Informix]Database locale information mismatch


Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.

Below is the information on the server before/after the upgrade.

Before            After

---------       -----------  

Solaris 8      Solaris 10

IDS 9.40     IDS 11.50

The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.

As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.

The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.

I have gone through many articles and it suggest me to set the environement  variable in the server :  DB_LOCALE=en_us.819.

I haven't try this solution but i think that this might not be the best solution.

Is it possible to to to have this settin

How to show random information with C# from a SQL Database?

I have to do the following in my web page.  Any advice and how to do this please with C# I have a table where I have a column for different states (NY, NJ, etc).  People can join the group (in my page) for each state (the state where they live).  So I have to display the newest members for each state. So the way it should work is, every time the page is refreshed/reloaded it should show the state name as a header text and the first 5 newest members for that state.  This should be random, for example initially when the page is loaded say it will show state: New York and the 5 recent members like Stacy, Laura, Mike, Sam, Mathew. Then when the page is refreshed it will show another state like State: california and the recent 5 members All the information comes from the database How should I do this?

retrieving file from database

hi All,i saved files into database. when i'm displaying i wrote code like thisDim mySqlDataReader As System.Data.SqlClient.SqlDataReader        Dim mySqlCommand As New System.Data.SqlClient.SqlCommand("pl_Resumes", mySqlConnection)        mySqlCommand.CommandType = CommandType.StoredProcedure        Ict.Ds.AddParameterToSQL(mySqlCommand, "@resumeId", SqlDbType.Int, 10, ParameterDirection.Input, myCandidateDetails.resumeId)        mySqlDataReader = mySqlCommand.ExecuteReader()        If mySqlDataReader.Read Then            Dim ftype As String = mySqlDataReader("resumeType")            If ftype = "rtf" Then                Response.ContentType = "application/x-rtf"            ElseIf ftype = "txt" Then                Response.ContentType = "text/plain"            ElseIf ftyp

Suppose we are building a web-based application to retrieve and enter information into a database.

Please help me out with thisSuppose we are building a web-based application to retrieve and enter information into a database.  The user-interface invokes web services.  Which architecture  would use for the application.

Suggestion on retrieving data from a database

hi everyone, I have a page which will retrieve data base on drop down lists and place the data onto  a gridview. When the data was entered, each field was entered with multi-selected and delmited by a comma. In the database, some fields will have a string with multi information delmited by the comma, for example, Chicago, Atlanta, NYC will be recorded and place in the field in the database. I'm trying to search now but with a dropdown list with Chicago, Atlanta, and NYC being an individual record. If the person selects NYC, all of the records from NYC will appear even though Chicago and Atlanta are part of the string. Can someone show the right direction to do this? Thank you, Carlos The following is the code for the current page:<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ExportContacts1.aspx.vb" EnableEventValidation = "false" Inherits="ExportContacts1" %> <%@ Import Namespace="System.Web.Mail" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> Protected Sub exportcsv_Click(ByVal sender As Object, ByVal e As EventArgs) Dim objStreamWriter As IO.StreamWriter objStreamWriter = New IO.

need information on database backup

Hi, As a developer Ihave very minimal knowledge on database backups. Before reaching out to DBA I want to understand few things 1) I need to place a request to create new database on a SQL Server. There is around 540 GB space on this server but the two existing databases on this server already used 500GB space. So what option do we have to create new database? Is it a simple task to add another drive and allocate some space or use mapped drive? what options can I suggest DBA? 2) Also DBA mentioned that there is no space to take backup on this drive for the existsing database. What option can I suggest for backup incase if we plan to drop one of the database which is not actively used?

Q about retrieving data from database

Hi, I'm having a question about retrieving data. I'm using VS 2008 and I have to create a new consultation record for a patient and I've already created a database with 3 tables, which are doctor, patient and consultation. I have 10 records saved in consultation table, and I've made a aspx form which contains a DetailsView that ask for new consultation details to be added. But I have to be able to get the doctor and patient information from the database and put in the DetailsView, then fill in the rest of the consultation details. The information entered have to be written to the database in the consultation table. But I don't know how to get doctor and patient information from database and apply them into the DetailsView so that doctor who wants to add new consultation details can select patient and doctor information from the database.I was thinking maybe I need to do a query with insert statement and apply into the DetailViewthis is the query i have:INSERT INTO [Consultation] ([ConsultationID], [GPname], [PatientFirstName], [PatientLastName], [Height], [Weight], [IllnessDescription], [Diagnosis], [Date]) VALUES (@ConsultationID, @GPname, @PatientFirstName, @PatientLastName, @Height, @Weight, @IllnessDescription, @Diagnosis, @Date)as you can see, I need to get the GPname, PatientFirstName and PatientLastName from the database tables and the rest will be fi

Retrieving Data From Database


I got two tables called Genre and Albums.

I want to access data (all the albums) inside each Genre how can i do it.

Do i have to make viewModel for this  or some thing else and what sort of query can i use.

Thanks in advance

Restoring a content database from another server/AD does not synch user profile information for new


In my SharePoint 2010 beta environment, I have user profiles synching with Active Directory.  I just restored a content database from a separate environment/domain and logged in with my current account.  When I try to create an alert on a library/item, I get the error:

“You do not have an e-mail address.  Alert has been created successfully but you will not receive notifications until valid e-mail or mobile address has been provided in your profile.”

I went to My Profile and found that the My Profile had the right e-mail address (I guess because this is on my My Site Host).

But when I went to My Settings, it did not have any e-mail address for me (I guess this is because it is at the WSS content database level and the e-mail address hasn’t yet synched from the user profile database).

Does anyone the timer job that synchs the user profile with the My Settings for a site collection in a content database?

Issue is posted to my blog with screenshots here:



Retrieving image from a database


I have been able to save an image in the database but i can not preview it please i need help urgently

Retrieving user information and organization structure from AD?



We are going to use SharePoint office 2010, and are going to modify active directory to build our organization structure by setting active directory properties such as manager, department, First Name….

We want to be able to retrieve user information,  department's manager, user colleagues, permissions, is user active/disbled and organization structure from active directory for the user who was added to SharePoint.

we need to access all the above information through code.

My question:

Can we retrieve all the above information from UserProfile? Or there is another way?

I read that we need to run user profile synchronization in order to keep user profile database in sync with AD, and we have to install SharePoint on farm installat

Unable to connect to database. Check database connection information and make sure the database ser



I am using MOSS2007. My MOSS site was working fine for last 1 month and today suddenly it started to show me below message

"Unable to connect to database.  Check database connection information and make sure the database server is running."


On my server, SahrePoint admin site is working. Other port site is also working. Only my MOSS site is showing me above message.  Can anyone helkp me to resolve this issue.

Need information about Connecting to different database form with in a package


We have a UniVerse data base to connect. How to connect to universe database from within ssis package(which connection manager is to be used)?

Access report server database connection information from custom security extension



Is there any way from my custom security extension that I can get to and unencrypt the database connection information held within the RSReportServer.config file?



Retrieving data from database to link to gridview by using listbox


hello, I have a search option which a person can use a multi select listbox. I have it coded so it would loop through to see if its selected or not. I also have a stored procedure where the sql statement is coded for the select statement. For some reason, its not populating my gridview. Where am I doing wrong? Below is the code and stored procedure. Thank you, Carlos


<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ExportContacts2.aspx.vb" Inherits="ExportContacts2" %>
<%@ Import Namespace="System.Web.Mail"  %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.SqlClient" %>

<%@ Import Namespace="System.Configuration" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
    Protected Sub submit_Click(ByVal sender As Object, ByVal e As EventArgs)
        Dim strtxtevents1 As String
        Dim lin4 As ListItem
        Dim myArrayList4 As ArrayList = New ArrayList()
        Dim strarr4() As String
        For Each lin4 In eventsi.Items
            If lin4.Selected = True Then

Filling jQuery array with information out ASP database



I'm using the JQuery player for music, i want to fill that array with song files from the ASP database.

This is the Array from jquery?

   var myPlaylist = [
{ name: "16 Bit - In The Death Car", mp3: "music/16 Bit - In The Death Car.mp3", ogg: "music/16 Bit - In The Death Car.ogg" },
{ name: "Ajapai - Warning", mp3: "music/Ajapai - Warning.mp3", ogg: "music/Ajapai - Warning.ogg" },
{ name: "Dz - Oooh", mp3: "music/Dz - Oooh.mp3", ogg: "music/Dz - Oooh.ogg" },

how to use progressBar for retrieving data from the database.


Can someone tell me how to create a progressBar to show the data retrieving progress. 



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend