how to create a dependent drop down list i.e Country,State,City like that using asp.net - ASP.NET Discussion Boards

Re: how to extract the category and subcategory dynamically in navigation bar in asp.net

ZurdoDev5-Nov-14 2:18

ZurdoDev

5-Nov-14 2:18

What is your question?

There are only 10 types of people in the world, those who understand binary and those who don't.

Re: how to extract the category and subcategory dynamically in navigation bar in asp.net

aawajaarughat5-Nov-14 17:48

aawajaarughat

5-Nov-14 17:48

i made a static navigation bar using css and i want to make a dynamic navigatiob bar usig sqlserver and if anybody have a tutorial for the related question please help me... Smile | :)

Re: how to extract the category and subcategory dynamically in navigation bar in asp.net

ZurdoDev6-Nov-14 1:26

ZurdoDev

6-Nov-14 1:26

Do you know how to write SQL? Do you know how to write C# to get the values from SQL?

You still haven't asked a specific question. You need to show us where you are stuck. Right now, all you've told us is what you want to do but we can't see what you have so far.

There are only 10 types of people in the world, those who understand binary and those who don't.

integrating geocoding with geolocation

Member 99545493-Nov-14 7:16

Member 9954549

3-Nov-14 7:16

following is my code when user enters hospital name and city, he will be navigated to this page to show location on map. now i want to get user current location and draw the route between current location and destination. is there any way to integrate to geocoding and geolocation? please help me out. i'll be very thankful.

XML

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style>
        html, body, #map-canvas
        {
            margin: 0;
            padding: 0;
            height: 700px;
            width: 1350px;
        }
    </style>

    <script src="http://maps.googleapis.com/maps/api/js??key=AIzaSyBcM1JmHJLyPH6m5xF0WzrqWJ9pSjCTQR4&sensor=false"></script>

<script>
    var geocoder;
    var map;
    var marker;
    function initialize() {
        var mapOptions = {
            zoom: 17,
            center: new google.maps.LatLng(-34.397, 150.644),
            mapTypeId: google.maps.MapTypeId.ROADMAP
        };
        map = new google.maps.Map(document.getElementById('map-canvas'),
            mapOptions);
        geocoder = new google.maps.Geocoder();

    }

    function geocode() {
       var loc = '<%= Session["hname"] %>';
        var city = '<%= Session["city"] %>';

        geocoder.geocode({ address: loc+city }, function (results, status) {
            if (status === google.maps.GeocoderStatus.OK) {
                map.setCenter(results[0].geometry.location);

                var contentString = '<div id="content">' +
        'Lat :' + results[0].geometry.location.lat() + '</br>lng :' + results[0].geometry.location.lng() +
        '</div>';
        var infowindow = new google.maps.InfoWindow({
                    content: contentString
                });

                marker = new google.maps.Marker({
                    position: results[0].geometry.location,
                    map: map,
                    title: results[0].geometry.location.lat() + ' , ' + results[0].geometry.location.lng()
                });

                google.maps.event.addListener(marker, 'click', function () {
                    infowindow.open(map, marker);
                );

            }
        });
        return false;
    }
         google.maps.event.addDomListener(window, 'load', initialize);
</script>

</head>
<body onload="initialize();return geocode()" >
    <form id="form2" runat="server">
    <div id="map-canvas">
    </div>
        </form>
</body>
</html>

Two Web APIs 2.2 with Identity 2.0 for one database

Quarenta3-Nov-14 3:49

Quarenta

3-Nov-14 3:49

Hello. Can i create two Web APIs 2.2 with Identity 2.0 for one database?

I want to create one Web API for some actions( to the public ), and another Web API for some other actions( administrators only ). Just for a security measure i want to separate them, so that the public doesn't even get to know about the existence of the second Web API.

Both must use authentication, but for the same database.

Would this strategy be a problem? How can i achieve this?

I also want to know which information does the Bearer Token contains... i read in an article that it contains infos of the fields in the user table, is that right? If it is, so whenever the client tries to access some method of the Web API, the ASP.Net Identity goes to the database or just analyse the Token at the application layer?

Thanks

modified 3-Nov-14 11:19am.

Error: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at

Harishankar Maurya2-Nov-14 21:30

Harishankar Maurya

2-Nov-14 21:30

Error: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at

Re: Error: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at

ZurdoDev3-Nov-14 2:43

ZurdoDev

3-Nov-14 2:43

The error is very clear. Did you have a question?

There are only 10 types of people in the world, those who understand binary and those who don't.

how to create a dependent drop down list i.e Country,State,City like that using asp.net

Shivaram_i2-Nov-14 20:08

Shivaram_i

2-Nov-14 20:08

I created one data base for Country,State,City with using foreign key...but i am fully confused to create a dropdown list for using that data base...Anybody please help me...

Thanks in advance...

Re: how to create a dependent drop down list i.e Country,State,City like that using asp.net

Kornfeld Eliyahu Peter2-Nov-14 21:04

Kornfeld Eliyahu Peter

2-Nov-14 21:04

http://mattgemmell.com/what-have-you-tried/[^]

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
תפסיק לספר לה' כמה הצרות שלך גדולות, תספר לצרות שלך כמה ה' גדול!

Re: how to create a dependent drop down list i.e Country,State,City like that using asp.net

jbhaskar2-Nov-14 23:04

jbhaskar

2-Nov-14 23:04

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindContrydropdown();
}
}
///

/// Bind COuntrydropdown
///

protected void BindContrydropdown()
{
//conenction path for database
using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"))
{
con.Open();
SqlCommand cmd = new SqlCommand("Select UserId,UserName FROM UserInformation", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
ddlCountry.DataSource = ds;
ddlCountry.DataTextField = "UserName";
ddlCountry.DataValueField = "UserId";
ddlCountry.DataBind();
ddlCountry.Items.Insert(0, new ListItem("--Select--", "0"));
con.Close();
}
}

Returning the date and 'Page_Load' question

Member 87616672-Nov-14 11:30

Member 8761667

2-Nov-14 11:30

Hello

I show the date script on an aspx.vb page and have inserted the

LblDate.Text = ReturnDate()

in an unrelated 'Page_load' since you can only have one Page_Load' per aspx.vb file, can't you? I thought I could 'piggy-back' onto another 'Page_Load' event.

Unfortunately, it is not working and I assume it is due to my not placing it properly in the aspx.vb file.

How can I deploy

LblDate.Text = ReturnDate()

in its own event in the aspx.vb file without it being compromised?

Thank you!

Open Source Reporting Tools in .Net

meeram3931-Oct-14 23:19

meeram39

31-Oct-14 23:19

There are variety of tools in Java for designing and developing Reporting like Jasper, BIRT etc. Does .Net have anything like that? I believe that there are only SSRS which is fully licensed. Earlier Crystal Reports were part of VS, but now, it needs tobe purchased separately.

Do we have anything similar reporting designing tool that can be used in ASP.Net or MVC?

Re: Open Source Reporting Tools in .Net

Peter Leow31-Oct-14 23:35

Peter Leow

31-Oct-14 23:35

Try Seal Report[^]

Re: Open Source Reporting Tools in .Net

meeram395-Nov-14 21:11

meeram39

5-Nov-14 21:11

Thank you. I have tried this and looks promising...

how to redirect pages in asp.net usint c#

manvapradhan30-Oct-14 23:42

manvapradhan

30-Oct-14 23:42

plz send me the code

Re: how to redirect pages in asp.net usint c#

member1000031-Oct-14 23:23

member10000

31-Oct-14 23:23

Responce.redirect("Pagename.aspx");

Re: how to redirect pages in asp.net usint c#

keyboard warrior4-Nov-14 5:21

keyboard warrior

4-Nov-14 5:21

member10000 wrote:
Responce.redirect("Pagename.aspx");

responSe.redirect("url");

http://www.twitter.com/otherjimmie

Re: how to redirect pages in asp.net usint c#

shaluIT8-Nov-14 14:29

shaluIT

8-Nov-14 14:29

use Response.Redirect

Small ordinals?

Member 876166730-Oct-14 11:18

Member 8761667

30-Oct-14 11:18

Hello

The following produces a date in this ordinal format:

30th October 2014:

Function ReturnDate() As String

        Dim theDate As String = ""

        Dim NumericDayofMonth As Integer = Date.Now.Day
        Dim OrdinalSuffix As String = ""

        Select Case NumericDayofMonth
            Case 1, 21, 31
                OrdinalSuffix = "st"
            Case 2, 22
                OrdinalSuffix = "nd"
            Case 3, 23
                OrdinalSuffix = "rd"
            Case Else
                OrdinalSuffix = "th"
        End Select

        Dim NumericMonthofYear As Integer = Date.Now.Month
        Dim MonthofYear As String = ""

        Select Case NumericMonthofYear
            Case 1
                MonthofYear = "January"
            Case 2
                MonthofYear = "February"
            Case 3
                MonthofYear = "March"
            Case 4
                MonthofYear = "April"
            Case 5
                MonthofYear = "May"
            Case 6
                MonthofYear = "June"
            Case 7
                MonthofYear = "July"
            Case 8
                MonthofYear = "August"
            Case 9
                MonthofYear = "September"
            Case 10
                MonthofYear = "October"
            Case 11
                MonthofYear = "November"
            Case 12
                MonthofYear = "December"
        End Select

        'Dim NumericDayofWeek As Integer = Date.Now.DayOfWeek
        'Dim DayofWeek As String = ""

        'Select Case NumericDayofWeek
        '    Case 1
        '        DayofWeek = "Monday"
        '    Case 2
        '        DayofWeek = "Tuesday"
        '    Case 3
        '        DayofWeek = "Wednesday"
        '    Case 4
        '        DayofWeek = "Thursday"
        '    Case 5
        '        DayofWeek = "Friday"
        '    Case 6
        '        DayofWeek = "Saturday"
        '    Case 7
        '        DayofWeek = "Sunday"
        'End Select

        'theDate &= DayofWeek & " " 'Monday, Tuesday, Wednesday etc
        theDate &= DateTime.Now.Day.ToString() '1, 2, 3, 4 etc
        theDate &= OrdinalSuffix & " " 'st, nd, rd, th
        theDate &= MonthofYear & " " 'Jan, Feb etc
        theDate &= DateTime.Now.Year.ToString() '2013, 2014 etc

        Return theDate
    End Function

and then, in a sub page_load:

LblDate.Text = ReturnDate()

But how would I make the 'st', 'nd', 'rd', and 'th' small and raised, just as you would find in a letter?

Thank you.

Blue

Re: Small ordinals?

jkirkerx30-Oct-14 12:00

jkirkerx

30-Oct-14 12:00

Have you tried

OrdinalSuffix = "<small>st</small>"

I don't know what raised means, but you can use span, an inline element to adjust how it looks

http://webdesign.about.com/od/fonts/a/aa082400a.htm[^]

Re: Small ordinals?

Member 876166730-Oct-14 12:18

Member 8761667

30-Oct-14 12:18

That's great, jkirkerx.

It looks like this now:

http://www.bayingwolf.com/Ordinal.jpg[^]

Raised means like this:

http://www.bayingwolf.com/Raised.jpg[^]

Thank you!

Re: Small ordinals?

jkirkerx30-Oct-14 12:32

jkirkerx

30-Oct-14 12:32

10th October 2014

<span style="font-size: 50%; vertical-align: top;">th</span>

modified 31-Oct-14 15:24pm.

Re: Small ordinals?

Rajesh waran30-Oct-14 20:25

Rajesh waran

30-Oct-14 20:25

Nice to see the link that you have provided.

~R@JEES#

Re: Small ordinals?

Richard Deeming30-Oct-14 12:44

Richard Deeming

30-Oct-14 12:44

It sounds like you're looking for the <sup> (superscript) element:

HTML

30<sup>th</sup> October 2014

30^th October 2014

There's also a <sub> (subscript) element:

HTML

H<sub>2</sub>O

H₂O

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Small ordinals?

Member 876166730-Oct-14 12:51

Member 8761667

30-Oct-14 12:51

[^]

Wonderful stuff!! Thank you again!

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.