ASP.NET Discussion Boards

Re: asp.net and access database

Christian Graus18-Jun-07 20:26

Christian Graus

18-Jun-07 20:26

http://www.google.com.au/search?sourceid=navclient&ie=UTF-8&rlz=1T4ADBS_enAU225AU226&q=javascript+remove+dropdown[^]

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

pass values

seemamltn18-Jun-07 13:03

seemamltn

18-Jun-07 13:03

I have the following Stored procedure. There is column named
"tcktreceived" in my database and I want to pass all the rows one by
one to the parameter @starttime. I don't know how to do it.

CREATE PROCEDURE [twcsan].[usp_DateDiff]
-- Add the parameters for the stored procedure here
@starttime DateTime

AS
BEGIN
DECLARE @Diff Varchar(15)
DECLARE @Day INT
DECLARE @Hour INT
DECLARE @Minute INT
DECLARE @Start_Date DateTime
DECLARE @End_Date DateTime
DECLARE @itemReceived DateTime
DECLARE @ID INT
DECLARE @message VARCHAR(50)

DECLARE @table TABLE
(
ItemReceived DateTime,
ID INT,
message text,
Differnce VARCHAR(20)

)
SET NOCOUNT ON;
SET @Start_Date = @starttime

SET @End_Date = GETDATE()
SET @Day = DATEDIFF( day, @Start_Date, @End_Date)
SET @Hour = DATEDIFF(hour , @Start_Date, @End_Date)
SET @Minute = DATEDIFF(minute , @Start_Date, @End_Date)
SET @Minute = @Minute-(@HOUR* 60)
SET @Hour = @Hour-(24* @Day)
SET @Diff = CONVERT(Varchar, @Day) +'d ' + CONVERT(Varchar , @Hour) +
'h ' + CONVERT(Varchar , @Minute) +'m'

INSERT INTO @table(ItemReceived, ID, message, Differnce)
select tck.tcktreceived, tck.ticketid,tckmsg.tcktmessage,@Diff
from tbtickets tck inner join tbticketsmessages tckmsg
on tck.ticketid = tckmsg.ticketid

select * from @table

END

seema

Re: pass values

Christian Graus18-Jun-07 13:10

Christian Graus

18-Jun-07 13:10

This is a SQL question, it has nothing to do with ASP.NET, I recommend asking in the SQL forum.

Re: pass values

Tarik Guney18-Jun-07 16:36

Tarik Guney

18-Jun-07 16:36

Hi my fellow this question belongs to sql forums so i recommed you to ask this in sql forums to take an answer quickly and easiyl Smile | :)

Best Greetings

Re: pass values

Sathesh Sakthivel18-Jun-07 16:47

Sathesh Sakthivel

18-Jun-07 16:47

Please post your Question in the Correct Forum.

Regards,

Satips. Rose | [Rose]

aransiola18-Jun-07 9:43

aransiola

18-Jun-07 9:43

I have this error when testing my aspx page on intranet.

Server Error in '/smartproject' Application.
-----------------------------------------------------------------------------
Login failed for user 'DIGITAL-NB\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'DIGITAL-NB\ASPNET'.

Source Error:
Line 22: oCnn = New SqlConnection(strConn)
Line 23: If oCnn.State = ConnectionState.Closed Then
Line 24: oCnn.Open()
Line 25: End If
Line 26:

Source File: C:\WebSites\SmartProject\App_Code\SmartPTier.vb Line: 24

I assigned the user ASPNET to Administrator group, and the thing worked.

1. What is the implication of this?
2. Is there any other way to solve this problem without assigning the ASPNET user to Administrator?
3. What is the function of the user ASPNET?

thank u for your response

t.aransiola

Re: Login failed for user 'DIGITAL-NB\ASPNET'.

Not Active18-Jun-07 12:33

Not Active

18-Jun-07 12:33

1) Any user and applicaiton running in the ASP.NET process has complete control of your database and server.

2) Grant the ASPNET account access to the specific database necessary or create a sql login account for that database and use it in the connection string. Not using Integrated Security of course.

3) To run ASP.NET D'Oh! | :doh:

only two letters away from being an asset

date time difference

seemamltn18-Jun-07 7:36

seemamltn

18-Jun-07 7:36

Hi,

I have a table which has a field ItemsReceived of type datetime. I
have a grid view which has two columns.

In first column i have to show the data from field ItemsReceived and
in second column I have to show
difference between Currenttime and date from ItemReceived. How can I
do that.

e'g

ItemRecieved Difference
6/13/2007 12:38am 1d 21h 45m
6/13/2007 3:54pm 1d 06h 10m
6/15/2007 12:26pm 34m

So the second coulmn displays the difference of current time minus
ItemRecieved. the format shouild be <mintues>m,
or<hours>h, <mintues>m, or <days>d.

How can I do that.

seema

Re: date time difference

Not Active18-Jun-07 7:58

Not Active

18-Jun-07 7:58

http://msdn2.microsoft.com/en-us/library/system.datetime_members(vs.80).aspx[^]

only two letters away from being an asset

asp.net help

jonniebigodes18-Jun-07 6:50

jonniebigodes

18-Jun-07 6:50

i'm using vs 2003 to develop an web app.
it exports data to a excell worksheet and fills some charts.
what is bugging me is that i can't select a chart, fill it and then select another chart and fill it.

in asp i use this

iExcel.Sheets("Graficos").ChartObjects("Gráfico 1025").Activate<br />
	Set crt = iExcel.Sheets("Graficos").ChartObjects("Gráfico 1025")<br />

to select the chart and then work with it.

and in asp.net???
how can i do this???

help would be appreciated
thanks in advance

Re: asp.net help

Christian Graus18-Jun-07 12:52

Christian Graus

18-Jun-07 12:52

In ASP.NET it will work exactly the same, as in both cases, you're just using a COM object.

Re: asp.net help

jonniebigodes18-Jun-07 22:32

jonniebigodes

18-Jun-07 22:32

it worked...to some extent, i can select the chart
but this piece of code doesn't work

while i try to define the series colection by doing this.

oChart.Chart.SeriesCollection(1).XValues = "=Dados!R3C1:R" & maxapos & "C1">

it shows me this error

Not possible to define XValue property in class Series

ASP tags in VS2005

Heavy Storm18-Jun-07 6:21

Heavy Storm

18-Jun-07 6:21

This is more a Visual Studio doubt than an ASPX question, but anyway:

I'm currently using VS2005 to develop ASP 2.0 (aspx) pages. Our pages template are somewhat different from your usual ASP Web Form, in that it doesn't have the html xmlns tag and DOCTYPE tag, which VS usually inserts on its default Web Form pages.

Very well, the problem is this: for some reason, VS doesn't recognizes ASP tags (<asp:xxx />) on our document. This fact blocks the use of AutoComplete and worse yet, it messes up with the "format" funcionality because everything inside a asp:panel is inserted on a single line.

Anyone has any ideia on what makes VS recognize asp tags inside a aspx document? Does it has anything to do with the inherited class or with some "include-like" tag on the code, such as link and @Page?

Could it be that some of our header code is messing things up? Our page doesn't have <body> or <head> or any other default html tags because the architecture inserts the webcode into another page (something like the "master" functionality).

Thanks in advance for any light on the subject.

Re: ASP tags in VS2005

Christian Graus18-Jun-07 12:58

Christian Graus

18-Jun-07 12:58

No, I don't use that tag, and auto complete works fine for me.

Problem with Dataset

anshina@advantech.ca18-Jun-07 6:05

anshina@advantech.ca

18-Jun-07 6:05

Hello,

In my first web application I have the problem with my dataset.
In the Page_Load I fill my dataset and I see the information in the Datagrid.
Next I click the button and want to do something with the information. But I don't see it. DataView.count returns 0. What should I do?

Thanks for help

Tan

Re: Problem with Dataset

Heavy Storm18-Jun-07 6:26

Heavy Storm

18-Jun-07 6:26

Are you messing up with the dataset on every Page_Load call? You should just fill the dataset if the page isn't being refresh:

if (!IsPostBack)
{
// load in here your dataset
}

Re: Problem with Dataset

anshina@advantech.ca18-Jun-07 6:32

anshina@advantech.ca

18-Jun-07 6:32

No I load my dataset inside the block !IsPostBack.

Re: Problem with Dataset

Not Active18-Jun-07 7:55

Not Active

18-Jun-07 7:55

Set a break point in your Page_Load event. You should find that your datagrid is being loaded during the initial event int the !IsPostback block. However, when you click a button on the page it is causing a postback, which will cause this block of code to not execute.

To solve, in your case, move the code where you bind the datagrid to a datasource out of the !IsPostback block.

only two letters away from being an asset

PowerPoint

deepaks318-Jun-07 5:18

deepaks3

18-Jun-07 5:18

Hi ,
I want to run a powerpoint slide show in a ASPX with some buttons like auto,next forward and so on.
Is is possible that we can show the slide show on the asp.net page so that the user cannot download the presentation, and can only view it online.

Thanks.

Deepak Surana

Re: PowerPoint

Christian Graus18-Jun-07 13:08

Christian Graus

18-Jun-07 13:08

No - you'd have to write your own pages to show still images which you then feed yourself to the user. You're not going to get any animations, unless you write them with flash or SVG or something.

how to convert value to boolean

asifbhura18-Jun-07 4:01

asifbhura

18-Jun-07 4:01

hi everyone,

i have one field in my table of database like "display" it is varchar data type.

it contains only true or false value.

now

in my webform, I m using 2005 C#

in repeater control

i have put this code,

<asp:image runat="server" id="imgdis" imageurl="~/images/attachment.png">

like this it doesnt work, it gives error like "String was not recognized as a valid Boolean."

same code works perfectly in .NET 2003

please help me

regards,
ASIF

Re: how to convert value to boolean

Christian Graus18-Jun-07 13:01

Christian Graus

18-Jun-07 13:01

What if you make your tag call a method in the code behind, pasing in the dataitem, so you can do the cast in C# code ? Then you can also see the data, to confirm that it's only ever true/false ( I doubt it is, this should work )

DataView Problems with web service

Fatbuddha 118-Jun-07 3:58

Fatbuddha 1

18-Jun-07 3:58

Hy.
In my first App. I hab a DataView where i concat a string for the Rowfilter. After that I returned the DataView
I exicuted it and it worked.
Now I have to sent the result via a Webservice.
The first Prob was that the WebService doesn´t know the DataView so I changed it into a DataTable.
Now I have the problem that I return a DataTable, and the changes from the filter are not in it.

data.RowFilter = filter;<br />
<br />
return data.Table;

where data is a normal DataView and filter is just a String.

So here is my question:
How do I get the result of the rowFilter() ??? D'Oh! | :doh:

Thx Cheers

Sorry! Sorry!
Just did it! After one hour work!
If someone is interested in this here is the code:

data.RowFilter = filter;<br />
<br />
System.Data.DataTable table = new System.Data.DataTable();<br />
table= data.ToTable();<br />
return table;

It isn´t nice I know, nut what the hack Smile | :)

Cheers

You have the thought that modern physics just relay on assumptions, that somehow depends on a smile of a cat, which isn’t there.( Albert Einstein)

Verifying a Certificate Chain by using x509certificate

suprajav18-Jun-07 3:41

suprajav

18-Jun-07 3:41

Hi Friends,

i am new to this technology.please help out on this problem
plese follow the below link and let me know any one have idea on this .
https://www.redhat.com/docs/manuals/cert-system/7.3/html/Administration_Guide/How_CA_Certificates_Establish_Trust-Verifying_a_Certificate_Chain.html[^]

Cheers..........Happy Coding

Re: Verifying a Certificate Chain by using x509certificate

Sathesh Sakthivel18-Jun-07 3:50

Sathesh Sakthivel

18-Jun-07 3:50

Don't Repost.

Regards,

Satips. Rose | [Rose]

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