ASP.NET

Reading files from server and displaying links

30-Dec-07 6:40

I think that you are asking about how to use Reporting Service in ASP.NET. If we are using Reporting service, we used to have one project for reports and one project for website.

You can google about this if you want to get the sample.. ASP.NET SQL Reporting Service[^]

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

CodeBase2530-Dec-07 5:08

CodeBase25

30-Dec-07 5:08

Hey all,

Just want to say I've used this site several times for help in the past and finally decided to join up and become a part of it. Before I ask my question I want you to know that I am not an experienced Web programmer. As of now I am strictly application based. I have a new, and somewhat small assignment ahead and I have an idea of how I would do it from an application side, so please let me know if this would work on the Web side as well.

The Problem -

We need a Web site that will look on our server for flash files and text files. The site will be pulling in some data from another program to let us know which videos and text files they need. On the web page it should have a link for each video avaliable in the folder. When they click on one it should take them to a page that displays the flash video as well as shows a text area with the contents of the text file that match that video.

One Solution -

Speaking of the page opening for the video to play, I thought it would be easier to use AJAX to embed the flash video in. Would this allow me to make the page more dynamic and not have so many individual pages? Or else, could I use one template page for the flash video and dynamically insert a different flash video object depending on which is clicked?

I know this may be a poor description, but it's the best I can explain in text. If anybody has any insight or thoughts on this please let me know. Thanks for reading and have a great day!

modified on Sunday, December 30, 2007 12:21:30 PM

Re: New Project, please advise!!

Michael Sync30-Dec-07 6:35

Re: New Project, please advise!!

30-Dec-07 6:35

ZakkFan25 wrote:
The Problem

I feel like this is like a requirement.. not a problem...

ZakkFan25 wrote:
thought it would be easier to use AJAX to embed the flash video in. Would this allow me to make the page more dynamic and not have so many individual pages? Or else, could I use one template page for the flash video and dynamically insert a different flash video object depending on which is clicked?

I think both ways will works. So, if you want "partial rendering", you should use Ajax and if you don't care about postback, Ajax won't be necessary..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

CodeBase2530-Dec-07 12:21

CodeBase25

30-Dec-07 12:21

Thanks for the input. I guess by "the problem" I mean the problem that I know what needs to but done but not exactly the best technique to go about doing it. Not sure how exactly I am going to list the files on the site for each file that is in the directory when I search for the files. Thanks for the reply.

ObjectDatasource Edit/Delete problem

arefkarimi29-Dec-07 23:47

arefkarimi

29-Dec-07 23:47

Hi,
I want to work with some data with an ObjectDataSource. The data comes from a DB table which have two fields: ID (primary key) and Title.

I have created such a class:

[System.ComponentModel.ObjectData(true)]
class Biz
{
public Biz() {}

[System.ComponentModel.ObjectMethod(Select)]
public DataSet FetchAll() { ... }

[System.ComponentModel.ObjectMethod(Update)]
public void Update(int Serial, string Title) {...}

}

I have assigned this class to my ObjectDatasource. And I show the records with a Gridview control. Since ID field is PK it must not be update. so I make Id field Invisible or Readonly. Then when updating the records, only Title field is edditable. Afterwards, in Update method, Serial parameter is always 0 (becasue Id was not editted) and only Title field has a correct value. I need Serial field's value to update the Table because more than one person may have the same name. I have written a code in GridView's RowUpdating event and bypassed the Biz.Update method but I am quite sure it is a wrong job.

Please let me know what to do to make the ObjectDataSource update records by itself.

Thanks

Aref

Problem updating database

David Kalkwarf29-Dec-07 12:11

David Kalkwarf

29-Dec-07 12:11

I am having a problem updating a table field in my database. Note that I am using Visual Web Developer 2008 Express.

I am using the asp_XYZ tables for membership, etc. My table (MyTable) contains a UserId field, which comes from the aspnet_Users table. The field I wish to update is MyField and is of type 'image'

I would like to populate my WebForm/FormView with MyField and allow the user to edit/update it. I do not have a problem populating the view, but cannot figure out the UpdateCommand. BTW, my SELECT command is something like this:

SELECT MyTable.MyField
FROM MyTable
INNER JOIN aspnet_Users ON MyTable.UserId = aspnet_Users.UserId
WHERE aspnet_Users.UserName = @UserName

I cannot figure out how to update. When I use the Configure Data Source wizard, it only allows me to choose fields from one table. I thought that I would be able to specify MyTable.MyField as a field to update and aspnet_Users.UserName as a field to filter. Confusion is setting in...

Since I thought I basically knew what my eventual UPDATE command was going to be, I went ahead and typed it myself. The following is that command and its UpdateParameters.

UPDATE MyTable
SET MyField = @MyField
FROM MyTable INNER JOIN aspnet_Users ON MyTable.UserId = aspnet_Users.UserId WHERE (aspnet_Users.UserName = @UserName)

asp:Parameter Name="MyField"
asp:SessionParameter Name="UserName" SessionField="UserName"

When I used the above command/parameters, the following exception was thrown:

"System.Data.SqlClient.SqlException: Operand type clash: nvarchar is incompatible with image"

Obviously, I am no SQL expert. Can someone explain where I am going wrong? Any comments on my approach are welcome.

Thanks.

Re: Problem updating database

Michael Sync30-Dec-07 5:40

Unable to work with IIS server

30-Dec-07 5:40

I think you need to define the type of parameter.

With SQL command, we used to do like that

<br />
this.sqlCommand1.Parameters.Add("@Picture",<br />
          System.Data.SqlDbType.Image);<br />
this.sqlCommand1.Parameters["@Picture"].Value=this.ImageByte;

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Roney29-Dec-07 7:21

Roney

29-Dec-07 7:21

I installed IIS server in 2003 operating system and it is installed successfully and iam changed the port no to 90.problem is typing localhost (or) also i given my host name and port no in web browser it is not giving my 2003 o/s home page why it is not giving.
What should i do. Is this IIS installed successfully or not.

Re: Unable to work with IIS server

Michael Sync29-Dec-07 7:51

29-Dec-07 7:51

If you are hosting the website on Windows 2003, you need to enabled the ASP.NET script in IIS.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Local CSS returns a 404?

Mustafa Ismail Mustafa29-Dec-07 6:43

Re: Local CSS returns a 404?

29-Dec-07 6:43

How the hell does this happen?

My CSS page for the site is not loading. Using firebug, it turns out that a 404 (File not found) is being returned. WTF? This is local to my machine, how the heck is this happening?

This is the first time it has happened but nothing is fixing it. I've restarted my laptop and still nothing Confused | :confused:

The website if File System Based rather than IIS based.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

"There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib

"Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"

Paul Conrad29-Dec-07 7:09

Paul Conrad

29-Dec-07 7:09

Is there something missing in a reference somewheres?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: Local CSS returns a 404?

Mustafa Ismail Mustafa29-Dec-07 9:32

Re: Local CSS returns a 404?

29-Dec-07 9:32

It appears that VS 2008 F-ed up the associations. I restored a back up and now the sub is shining again. Thank God for backups Cool | :cool:

Michael Sync29-Dec-07 7:53

29-Dec-07 7:53

As you are using Firebug, you can check the url of 404 CSS. and if you got the url then I think you will be figure out the problem..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

jQuery & ASP.NET

Mustafa Ismail Mustafa29-Dec-07 3:46

29-Dec-07 3:46

Is there a trick to including jQuery (the intent is to add ThickBox) into ASP.NET master pages?

It works fine on an html page, but when I add it to the master page, I get a "CS1056: Unexpected character '$'"

Here's the code in the of the master page:

<br />
<head runat="server"><br />
    <title>Untitled Page</title><br />
    <link type="text/css" rel="Stylesheet" href="../css/default.css" /><br />
    <link rel="stylesheet" href="../css/thickbox.css" type="text/css" media="screen" /><br />
<br />
    <script type="text/javascript" src="../js/jquery.js"></script><br />
<br />
    <script type="text/javascript"><br />
     jQuery.noConflict();<br />
     <br />
     // Use jQuery via jQuery(...)<br />
     jQuery(document).ready(function(){<br />
       jQuery("div").hide();<br />
     });<br />
     <br />
     // Use Prototype with $(...), etc.<br />
     $('someid').style.display = 'none';<br />
    </script><br />
<br />
    <script type="text/javascript" src="../js/thickbox.js" runat="server"></script><br />
<br />
</head>

Am I doing something wrong that I can't see? Confused | :confused:

Michael Sync29-Dec-07 7:56

29-Dec-07 7:56

Mustafa Ismail Mustafa wrote:
// Use Prototype with $(...), etc.
$('someid').style.display = 'none';

Is that code required? (You are not referencing the prototype but you used $().) I think that you won't need this line.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Mustafa Ismail Mustafa29-Dec-07 9:37

29-Dec-07 9:37

I honestly don't know Mike. I've wasted 2 days trying to get either LightBox or ThickBox to work on my site. Neither did.

SO...

I've decided to write my own gallery control $Shucks | :-\$ :sneaky:

As soon as I'm done with my ABE article, coming up real soon.

Michael Sync29-Dec-07 17:35

29-Dec-07 17:35

If you want to use the Lightbox, I can help you.. I love that box and used it for a lot of projects..

You can read the instruction from this link http://www.huddletogether.com/projects/lightbox2/[^]

there are only 5 steps to do.. I suggest you to try and take a look.. let me know if you get any error..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Mustafa Ismail Mustafa29-Dec-07 18:57