ASP.NET

Not Active15-Feb-07 4:19

Not Active

15-Feb-07 4:19

A little more background might be useful. What are trying to do? What have you done?

only two letters away from being an asset

Sarfaraj Ahmed15-Feb-07 5:24

Sarfaraj Ahmed

15-Feb-07 5:24

1. Pulling or Talking data from Server
2. Using Microsoft Reporting Service to create Report
3. VS2005-->>ASP.NET-->>REPORT.RDLC

Thanks

Sarfarj Ahmed

Not Active15-Feb-07 5:47

Not Active

15-Feb-07 5:47

This is pretty obvious from the error message. Now how about giving some info that will actually help.

only two letters away from being an asset

Increase Upload File size

Sarfaraj Ahmed15-Feb-07 6:14

Sarfaraj Ahmed

15-Feb-07 6:14

Actually I dont know wot information you need.

Basically, Source File: /Lesson/Lessons.aspx suppose to show CustomerReports.rdlc report From the Server, Where Server got SQL SERVER DATABASE, When I will click SHOW button on that time report should be come but If I click .aspx file on that time Im getting error.

Thanks

Sarfarj Ahmed

R.Palanivel15-Feb-07 3:26

Re: Increase Upload File size

15-Feb-07 3:26

Hi
Im Developing file upload /download process. i can upload 600 MB file when i run my application locally. i Can not achieve this on live sever. i updated my web.config file as

<httpRuntime executionTimeout="1800" appRequestQueueLimit="100" maxRequestLength="655600" useFullyQualifiedRedirectUrl="false" enableVersionHeader="true" minFreeThreads="8" minLocalRequestFreeThreads="4" />

r_palanivel83 10:01 4 Jan '06

BINOVAR15-Feb-07 17:33

BINOVAR

15-Feb-07 17:33

I used this n its working fine for me ...pls check

<httpruntime
executiontimeout="90"
maxrequestlength="512000"
usefullyqualifiedredirecturl="false"
minfreethreads="8"
minlocalrequestfreethreads="4"
apprequestqueuelimit="100"
>

Re: Increase Upload File size

R.Palanivel15-Feb-07 22:00

Re: Increase Upload File size

15-Feb-07 22:00

Hi actually i have done this on my web.config but its not working in my live server. is it working locally or online for u?

r_palanivel83 10:01 4 Jan '06

BINOVAR15-Feb-07 22:09

BINOVAR

15-Feb-07 22:09

Its working for me locally as well as online too...

Inserting date

Kunal P15-Feb-07 3:13

15-Feb-07 3:13

i m developing a web based application in c#. i just wanted to ask the most basic qn..

how to insert the current date in the database... how shud i provide the option on the webpage.. and wat all is required in the database.

till yet i have created a field named Dt and datatype datetime..

Kunal Piyush

R.Palanivel15-Feb-07 3:33

15-Feb-07 3:33

Hi
You can insert Data in many ways . try to use stored procedures(for good programming).

here i give u some sample code

SqlConnection sqlCon=new SqlConnection("connection string");
sqlCon.Open();
SqlCommand insertCmd = new SqlCommand("stored procedure name", sqlCon);
insertCmd.CommandType = CommandType.StoredProcedure;

//Create parameter and Set values
insertCmd.Parameters.Add(<parameter name>, <DataType>,<size>);
insertCmd.Parameters[<parameter name>].Value = <Value>

insertCmd.ExecuteNonQuery();
sqlCon.Close();

r_palanivel83 10:01 4 Jan '06

Kunal P15-Feb-07 3:45

15-Feb-07 3:45

hey

i m sorry if i cudnt clarify myself..

wanted a walthrough ragarding inserting a DATE...

thx..

Kunal Piyush

badgrs15-Feb-07 3:51

badgrs

15-Feb-07 3:51

DateTime.Now is the .NET method of getting the current date object.

or if your using SQL Server you can use the GETDATE() SQL command directly in your query

R.Palanivel15-Feb-07 4:14

15-Feb-07 4:14

HI
you just use this code

insertCmd.Parameters.Add("@DateVale", SqlDbType.DateTime,10);

insertCmd.Parameters["@DateVale"].Value = DateTime.Today.ToString("MM/dd/yyyy")

r_palanivel83 10:01 4 Jan '06

Colin Angus Mackay15-Feb-07 4:41

Colin Angus Mackay

15-Feb-07 4:41

r_palanivel83 wrote:
insertCmd.Parameters["@DateVale"].Value = DateTime.Today.ToString("MM/dd/yyyy")

Why on Earth would you convert the date to a string?! Just pass it the DateTime object.

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

Kunal P15-Feb-07 5:00

15-Feb-07 5:00

i am now able to add the date to the database.. bu there is on problem.. when i retrive the date when the employee was added.. it will also the time along the date..

i dont want the time to at all get into the database... is it possible.

Kunal Piyush

badgrs15-Feb-07 5:34

badgrs

15-Feb-07 5:34

A date field also includes the time - I see no reason why you wouldn't want this information available even if you don't want to display it. Use DateTime.ToString(format) to format the output without time.

Kunal P17-Feb-07 3:18

17-Feb-07 3:18

a lil bit of problem..
the date would be retrieved from the database... now how shud i fomat it without the time.. and in DD/MM/YYYY format..

to retrieve i m using this line of code

Label1.Text = "" + dread["dt"].ToString();

where dt is the datetime field in the database.

Kunal Piyush

badgrs18-Feb-07 0:37

badgrs

18-Feb-07 0:37

Kunal P wrote:
Label1.Text = "" + dread["dt"].ToString();

If you look in the documentation you'll see the ToString method is overloaded (has several different methods with different parameters). You can feed is a string format like this: (and you don't need the initial blank string - that just creates another object to be cleaned up by the GC)

Label1.Text = dread["dt"].ToString("dd/MM/yyyy");

You'll probably find you need to cast it to a DateTime object first:

Label1.Text = ((DateTime)dread["dt"]).ToString("dd/MM/yyyy");

This documents the possible formating strings:
Custom DateTime Format Strings

Kunal P19-Feb-07 1:35