• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Buried in cloud files? We can help with Spring cleaning!

    Whether you use Dropbox, Drive, G-Suite, OneDrive, Gmail, Slack, Notion, or all of the above, Dokkio will organize your files for you. Try Dokkio (from the makers of PBworks) for free today.

  • Dokkio (from the makers of PBworks) was #2 on Product Hunt! Check out what people are saying by clicking here.


Medicare Database Visual Studio Code Example

Page history last edited by Christopher Cole 8 years, 4 months ago

Medicare Database Visual Studio Code Example




Topics covered in this video;


-Code Behind
-Populating Dropdown List
-using's (ie system.data, system.configuration)
-\ (escape sequences)
-SQL/Data Adapters
-Session Variable
-Creating a button
-Variables being passed over
-Debugging for drop down list




This example uses the  Case Study - Medicare Database


It duplicates code from the lecture Getting Started with Database Tools in Visual Studio







Code for Select State with Explanation


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;

namespace CMS_Example2
    public partial class SelectState : System.Web.UI.Page
        protected void Page_Load(object sender, EventArgs e)
            if (!IsPostBack)
                String cStr = @"Data Source=A30609\EAGLIN;Initial Catalog=PatientSurvey;Integrated Security=True";


System.Data.SqlClient.SqlConnection sConn = new System.Data.SqlClient.SqlConnection(cStr);


                System.Data.SqlClient.SqlDataAdapter sAdpt = new System.Data.SqlClient.SqlDataAdapter("SELECT DISTINCT(State) FROM RawData", sConn);

                DataSet ds = new DataSet();





                ddlSelectState.DataSource = ds;
                ddlSelectState.DataTextField = "State";
                ddlSelectState.DataValueField = "State";

        protected void btnDone_Click(object sender, EventArgs e)

            String rStr = ddlSelectState.SelectedValue;
            Session.Add("State", rStr);






Most important section is System.Data to have access to Data Objects.








page load event is triggered


Only perform this if not a post back


This the connection string for the database, the @ symbol means to use it as a literal string.


Create a new SqlConnection object using the connection string.


Create a SQL Adapter to run a SQL command and fill DataSet.




Create a DataSet to hold the results of the query.



Put the Query results in the DataSet.




Set the DataSource for the drop down list to the DataSet and specify parameters. Bind the drop down to the dataset






If the Done button is pressed, get the selected value, store it in the Session and pass control of program to new page.



Comments (0)

You don't have permission to comment on this page.