ASP.NET

Get Date from Web Server or DB Server?

26-May-08 18:36

The default OLEDB JET Driver in your Windows should help you out right? Check out http://www.connectionstrings.com/[^] for an appropriate connection string.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Waleed Eissa26-May-08 13:27

Waleed Eissa

26-May-08 13:27

Hi gurus,

I wonder whether it's better to pass the current date to my DAL from my BLL or do this in my sproc (using GetDate() in SQL Server for example), or in others words is it better to get the date from the web server or the db server? What are the pros and cons of every approach? (in case you're wondering it's a website with a forums section and I want this for the thread adding code)

Regards

Waleed Eissa
Software Developer Sydney

Re: Get Date from Web Server or DB Server?

Christian Graus26-May-08 15:55

Christian Graus

26-May-08 15:55

I don't think it matters unless you are worried the dates will differ. I'd use getdate b/c it's there and just works without passing anything in

Re: Get Date from Web Server or DB Server?

Vasudevan Deepak Kumar26-May-08 18:37

26-May-08 18:37

Christian Graus wrote:
unless you are worried the dates will

The time component might present a problem if the servers are distributed across geographically, unless the timezones are taken care of properly.

ADO.Net

pinna_hari26-May-08 9:11

pinna_hari

26-May-08 9:11

Hello,

Disconnected(dataset,dataadaper),Coneected(Command,DataReader)
Which is better to use?

And
Please Send samples for How to Use 3-tier Architecture with helper classes for C#.Net

Pinna

Blue_Boy26-May-08 11:02

Blue_Boy

26-May-08 11:02

What excatly do u mean by

haripinna wrote:
Disconnected(dataset,dataadaper),

and

haripinna wrote:
Coneected(Command,DataReader)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

pinna_hari27-May-08 0:11

pinna_hari

27-May-08 0:11

I mean which is better to use in Project..

Pinna

Colin Angus Mackay26-May-08 12:56

26-May-08 12:56

haripinna wrote:
Disconnected(dataset,dataadaper),Coneected(Command,DataReader)
Which is better to use?

It depends on the situation you are in.

haripinna wrote:
Please Send samples for How to Use 3-tier Architecture with helper classes for C#.Net

Too vague and too large a topic. You need to buy books on the subject. It is not going to be answered in the space of a forum post.

Recent blog posts:
* Introduction to LINQ to XML (Part 1) - (Part 2) - (part 3)

My website | Blog

Vasudevan Deepak Kumar26-May-08 18:57

Re: Connecting to data base

26-May-08 18:57

haripinna wrote:
Disconnected(dataset,dataadaper),Coneected(Command,DataReader)

It depends on the specific application type that you are on.

Connecting to data base

Saba0226-May-08 8:00

Saba02

26-May-08 8:00

hello,

i have this coonectio string in my web.config.

<connectionStrings><br />
<add name="ShoppingConnectionString2" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Inetpub\wwwroot\myonlineshopping01\App_Data\MyOnlineShopping.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"<br />
providerName="System.Data.SqlClient" />

and my page.aspx.cs is this:

<code>SqlConnection MyConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShoppingConnectionString2"].ConnectionString);</code>

;

but i could not connect to database,
is this codes result of that i can't connect.

thank you,

Hoda

Colin Angus Mackay26-May-08 13:02

Re: Connecting to data base

26-May-08 13:02

Saba02 wrote:
but i could not connect to database,

*sigh* I'm going to ask some obvious questions that we shouldn't really need to ask. I mean really, do you go to your doctor and say "I'm ill! is my diet the problem?" with out giving any other information?

So, what was the error message? If there was no error message what did it do instead of connecting to the datbase? Have you checked that the connection string is actually correct for the database?

Recent blog posts:
* Introduction to LINQ to XML (Part 1) - (Part 2) - (part 3)

My website | Blog

Vasudevan Deepak Kumar26-May-08 18:38

validating the fields in msi file during the installation

26-May-08 18:38

Saba02 wrote:
i can't connect

You ought to be more clear in what you are encountering (the exact error message which you are getting) while attempting to connect to the data source.

chaitu.chinna26-May-08 7:43

chaitu.chinna

26-May-08 7:43

in the "database installer pacage" window,it is asking to give server name,name of database,user id and password. i'm able to encript the password field using ORCA, but i don't know how to validate the other fields(i don't want the end user to change the database,with out filling all the fields user should not be allowed to go forward)
plz help me out!!!!
regards,
Kranthi.

Re: validating the fields in msi file during the installation

Vasudevan Deepak Kumar26-May-08 18:58

Re: validating the fields in msi file during the installation

26-May-08 18:58

Would having some custom actions help you out?

chaitu.chinna26-May-08 20:25

chaitu.chinna

26-May-08 20:25

hi Vasudevan Deepak Kumar,
how to give custome actions. i'm new to it. can u give step wiese process?

private property value storage by ASP.NET

Nadia Monalisa26-May-08 6:31

Nadia Monalisa

26-May-08 6:31

Hi.,
Can you tell me where the Private variables are stored in ASP.NET ? as they are not stored in ViewState then where are they stored ? Any other kind of hidden type form field in the rendered Html page ? I am having a public property in my server control which will hold the LicenseKey and the LicenseKey will be assigned only in design time, not in runtime. And as ViewState is not secured, I choosed not to store my public property value in ViewState, rather I will use a static private string like this,

private static string _licenseKey; 

public string LicenseKey
{
  get 
  {
     if (!String.IsNullOrEmpty(MyClass._licenseKey)) 
       return _licenseKey; 
     else 
       return String.Empty; 
  }
  set 
  {
    if(value == "Password") 
      MyClass._licenseKey = value; 
  }
}

Can you tell me how will it work when the page is rendered, is it a safe and efficient way to store my secured data ?

Re: private property value storage by ASP.NET

Colin Angus Mackay26-May-08 13:08

Re: private property value storage by ASP.NET

26-May-08 13:08

bashiwala wrote:
Can you tell me where the Private variables are stored in ASP.NET ?

They are stored in memory for the duration of the instance of the class. When the class is no longer referenced they will be removed by the garbage collector.

You also need to know that ASP.NET is a STATELESS system. It does not hold onto state. You have to deal with state information yourself.

bashiwala wrote:
Can you tell me how will it work when the page is rendered, is it a safe and efficient way to store my secured data ?

When a page is requested from a browser ASP.NET creates the appropriate page class, processes it and then discards the page. This mean that page classes (such as the one used for processing your ASPX page) exist normally for a fraction of a second before disappearing. ASP.NET does some clever trickery to make it appear that the class lasts longer than it actually does but in fact everytime you get a postback you have a new instance of that page class.

Recent blog posts:
* Introduction to LINQ to XML (Part 1) - (Part 2) - (part 3)

My website | Blog

Nadia Monalisa27-May-08 3:26

Nadia Monalisa

27-May-08 3:26

Thank you Sir! the information you provided helped me greatly.

autosize Table td

greekius26-May-08 6:06

greekius

26-May-08 6:06

imagine a table with a row,two column on master page.
table width is contstant
first cell contains a Header Label
Second cell contains a Greetings Message Label
Greeting Message is contants for each page in web application.
but Header is set at the page load event of each Page inherited from master page.
i wanna lean Greeting message Label to right side of Header Label.
How can i do ?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head><title>
	Untitled Page
</title></head>
<body>
    <form name="form1" method="post" action="Default6.aspx" id="form1">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUJNDcyNzY3Njg2D2QWAgIDD2QWBAIHDw8WAh4EVGV4dAUFZGVubWVkZAIJDw8WAh8ABRo8bWFycXVlZT5XZWxjb21lPC9tYXJxdWVlPmRkZD0SSw5QB1+A6TeCFC/vHSi8dhU8" />
</div>

    <div>
        <input name="TextBox1" type="text" value="denme" id="TextBox1" style="width:346px;" />
        <input type="submit" name="Button2" value="ata" id="Button2" />
        <input type="submit" name="Button1" value="Button" id="Button1" />
        <table style="width: 700px">
            <tr>
                <td>
                    <span id="Label1">denme</span>
                </td>
                <td >
                    <span id="Label2"><marquee>Welcome</marquee></span>
                </td>
            </tr>
        </table>
    </div>
    
<div>

	<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="/wEWBAKzsMXJAQLs0bLrBgK7q7GGCAKM54rGBmx1oT2fU5q+sOR3MzYH/P3kbq7G" />
</div></form>
</body>
</html>

web.config file in asp.net 2.0

trilokharry26-May-08 5:10

trilokharry

26-May-08 5:10

how to pass some message like: Total Size>100 MB
from web.config file to test.aspx page

means
I will write some message in web.config somewhere how to I dont know
then I want to access this in div tag or some where in aspx page only.

please tell me how to do it ?

thanks

You get the best out of others when you give the best of yourself.

Re: web.config file in asp.net 2.0

Colin Angus Mackay26-May-08 13:10