ASP.NET

Richard Deeming28-Jul-14 6:22

28-Jul-14 6:22

Correct.

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

byka29-Jul-14 1:51

byka

29-Jul-14 1:51

Great. Thank you a lot for help

byka29-Jul-14 1:53

byka

29-Jul-14 1:53

Last question. What if I don't want to specify min and max values?

Richard Deeming29-Jul-14 2:14

29-Jul-14 2:14

If you don't specify min and max values, you'll get any 32-bit number returned, which will probably not be 8 digits.

If you always want the number to be 8 digits, and you don't want to pass the parameters, then you can hard-code the min and max values within the function.

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

byka29-Jul-14 2:31

byka

29-Jul-14 2:31

so if I hardcoded like this:
NextRandomNumber(1, 10000000)
it should take care right?

Richard Deeming29-Jul-14 5:56

How to create ASP.NET database driven dynamic website, Database Connection, Tutorial

29-Jul-14 5:56

That would give you a number anywhere from 1 to 7 digits long. If you want the number to always be 8 digits, the min value should be 10000000, and the max should be 100000000.

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

Biplob Singha Shee28-Jul-14 2:01

Biplob Singha Shee

28-Jul-14 2:01

Hi all,

I am very new in ASP.NET. Actually I code in vb.net and trying to make a database driven dynamic website.

I use to connect database through an XML file where I put the server, database name, user id and password. Then from a class I call these to connect the database. In this class I put the connectionstring which always read the data from the XML file like...

If (IO.File.Exists("db.xml")) Then
            Dim DbXmlReader As XmlReader = New XmlTextReader("db.xml")
            While DbXmlReader.Read
                Dim DbNodeType = DbXmlReader.NodeType
                If (DbNodeType = XmlNodeType.Element) Then
                    If (DbXmlReader.Name = "server") Then
                        srv = DbXmlReader.ReadInnerXml.ToString
                    End If

the above code is just a snippet.

Now my questions are...

1. Is the above method possible in ASP.NET to connect with a database ?
2. If not, then how should I connect with the database ?
3. Lastly, is there any good tutorial for beginners that how to create a database driven dynamic website from scratch in ASP.NET?

The tutorial should have all like add a template, adding css, database connection etc.

Thanks in advance.

Re: How to create ASP.NET database driven dynamic website, Database Connection, Tutorial

Richard Deeming28-Jul-14 2:50

Re: How to create ASP.NET database driven dynamic website, Database Connection, Tutorial

28-Jul-14 2:50

Although it would be possible to read the connection details from a custom XML file, why not simply use the built-in support for configuring connection strings[^]?

web.config:

XML

<configuration>
    <connectionStrings>
        <add
            name="MyConnectionString"
            providerName="System.Data.SqlClient"
            connectionString="server=SERVER-NAME;database=DB-NAME;uid=USER-NAME;pwd=PASSWORD"
        />
        <!--
        For more examples of connection strings, see:
        http://www.connectionstrings.com/
        -->
    </connectionStrings>
</configuration>

Code:

VB.NET

Imports System.Configuration
...
Dim connectionStringSettings As ConnectionStringSettings = ConfigurationManager.ConnectionStrings("MyConnectionString")
Using connection As New SqlConnection(connectionStringSettings.ConnectionString)
    ...
End Using

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

Biplob Singha Shee28-Jul-14 3:20

Biplob Singha Shee

28-Jul-14 3:20

Thanks Richard for your answer. Is there any good tutorial for beginners like me ?

Re: How to create ASP.NET database driven dynamic website, Database Connection, Tutorial

Richard Deeming28-Jul-14 3:46

28-Jul-14 3:46

Since you're just starting, and you don't have any legacy code to support, your best bet is probably to start with ASP.NET MVC. The ASP.NET site[^] has some decent introductory tutorials.

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

Web Crawling

JaypalSinh9026-Jul-14 19:56

JaypalSinh90

26-Jul-14 19:56

Hi to all
i want to read content of website using asp.net c# and store it to excel sheet.if any one have idea plzz suggest.
thanx in advance.

Kornfeld Eliyahu Peter26-Jul-14 20:33

Kornfeld Eliyahu Peter

26-Jul-14 20:33

Google can get you very far...
C# Web Crawler[^]

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

http://www.example-code.com/csharp/spider.asp[^]

Sibeesh KV29-Sep-14 1:47

Sibeesh KV

29-Sep-14 1:47

Please up vote if it helped you Smile | :)

Thanks And Regards
Sibeesh

Kornfeld Eliyahu Peter29-Sep-14 2:08

Kornfeld Eliyahu Peter

29-Sep-14 2:08

5th place on Google!

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Sibeesh KV29-Sep-14 2:12

Sibeesh KV

29-Sep-14 2:12

Yeah

But it gives nice documentation and easy also Wink | ;)

Please up vote if it helped you Smile | :)

Thanks And Regards
Sibeesh

asp.net

naralasaimanoj25-Jul-14 6:20

naralasaimanoj

25-Jul-14 6:20

i am beginner of asp.net 4.0, need a perfect material to learn perfectly ,especially to create a website using visual studio 2010

sumitkmr6225-Jul-14 8:20

sumitkmr62

25-Jul-14 8:20

visit below link if you are a true learner

https://www.youtube.com/user/kudvenkat

sumit

thatraja25-Jul-14 16:03

thatraja

25-Jul-14 16:03

Beginner's Walk - Web Development[^]
Education Needed[^]

thatraja

Code converters | Education Needed | Improve Everything^New

Swinkaran3-Aug-14 16:41

Swinkaran

3-Aug-14 16:41

The best source to learn is http://www.pluralsight.com/training[^]

There are heaps of video tutorials goes each and every aspect of website development. This is I guess the perfect for any starter/beginner. You can even download the materials too. Then go to other tutorials and various sources on Internet. Only the cons of Pluralsight is that it is monthly subscription.

Other tutorials to learn:
http://www.w3schools.com[^]
http://www.codeproject.com[^]
www.asp.net/get-started[^]

Books(or Ebooks) are good, but they will consume lots of time. Rather start your early learning using Videos