Bind Two Table Adapters to a Datalist - ASP.NET Discussion Boards

Changing the bgcolor and font of an ASP.Net page

Tina P7-Dec-06 12:50

7-Dec-06 12:50

Hi guys, I was wondering how do I change the color of an asp.Net page when a user click a button or simply click a link which says change page color. In Page_Load() event handler I tried to access the form element (HTMLFORM) but it doesnt have the bgColor property. Can someone please tell me what to do here.

Thanks
Tina

Re: Changing the bgcolor and font of an ASP.Net page

M LN Rao7-Dec-06 17:44

M LN Rao

7-Dec-06 17:44

you have to either use themes/skins/stylesheets. If your need is just to change background color (non-persistent/un-profiled) then use javascript.
function chgBkColor()
{
document.bgColor = "red";
return false;
}

<asp:button ....="" onclientclick="return chgBkColor()">

Intelligence is measured by common sense not by how many scholarly books you read.

Re: Changing the bgcolor and font of an ASP.Net page

Tina P8-Dec-06 4:40

Tina P

8-Dec-06 4:40

Hello, like I said I would like to do the color and font change stuff when a button or a link is clicked (so it has to be an event triggered by a user). I can’t just use CSS since that’s static and it will be changed forever and not dynamically on the button click event. And I don’t want to use JavaScript because of the browser restrictions that we are running into. So I have to do it on the server side (that is in the button1_click event). Please help me out with that.
Also I noticed you mentioned themes/skins….I believe those are the features of ASP.Net 2.0. I’m using 1.1.
Thanks
Tina

Getting FileInfo from a file on a remote server

code_guy0007-Dec-06 10:49

code_guy000

7-Dec-06 10:49

Hi there...

I've been trying and trying to find a way to use an absolute URL to connect to a file X on server B from my ASP.NET program on server A in order to retrieve information regarding when file X was created and last modified. I'm using VB.Net.

I thought

Dim path As String = "http://www.someURL.ext/.../index.htm"
Dim fiNextBro As FileInfo = New FileInfo(path)

might work, but all I've gotten are errors saying that URI formats are not supported.

Could someone explain to me which methods in which class from the .Net library I need to use and how I can go about retrieving the file information I need please? This has me totally lost Confused | :confused:

Re: Getting FileInfo from a file on a remote server

M LN Rao7-Dec-06 17:47

M LN Rao

7-Dec-06 17:47

May I know whether you want to read Web Page FileInfo or a file in LAN?

Intelligence is measured by common sense not by how many scholarly books you read.

Re: Getting FileInfo from a file on a remote server

code_guy0008-Dec-06 6:50

code_guy000

8-Dec-06 6:50

I believe they are on the same LAN. They both show up in My Network Places.

Re: Getting FileInfo from a file on a remote server

ed^nrgc8-Dec-06 3:13

ed^nrgc

8-Dec-06 3:13

If you have permissions you can check a file on a lan.

Bind Two Table Adapters to a Datalist

navruzahmet7-Dec-06 10:42

navruzahmet

7-Dec-06 10:42

Hi,
I am trying to write a generic blog or guestbook kind control to use in my further projects. And in somewhere i need to read info from two different table adapters to use in a datalist control.

For convenience let me explain my environment:
In a Database I have two tables: Messages and Comments. Messages table contains the messages sent from the administrators and comments table contains the comments that is sent for the messages.

I have One DataSet that is responsible for these tables, which contains two table adapters for each table. one(adapter of the comments table) has an query that returns the number of comments for a message, and the other returns simply messages.

I want to list messages in a datalist control which has been binded to the Messages Tableadapter(no problem with this), and want to add an extra label which shows the number of comments related to this message.

But, there is no option to bind a control, inside the datalist, to another table adapter.

Is there any method to show data from another tableAdapter for datalist?

Thanks.

Ahmet Recep Navruz

Re: Bind Two Table Adapters to a Datalist

minhpc_bk7-Dec-06 14:59

minhpc_bk

7-Dec-06 14:59

You can use the ItemDataBound[^] event to set the number of comments for each message in the datalist control. Another option IMO is that you can have an additional column in the message table stored in the dataset, this column basically contains the message count and you can easily bind it to the label control.

Re: Bind Two Table Adapters to a Datalist

navruzahmet8-Dec-06 1:36

navruzahmet

8-Dec-06 1:36

Thanks for reply, this was really helpfull.
ItemDataBound resolved the problem.
For the second solution, i don't want to include comment number in the message table. So can we create a table on the fly which contains the the messages table and an additional column, comment_count. I mean what can be done in the Dataset so we can inherit the messages table and add an comment count column which's value evaluated by another SQL statement.

Re: Bind Two Table Adapters to a Datalist

minhpc_bk8-Dec-06 5:38

minhpc_bk

8-Dec-06 5:38

navruzahmet wrote:
So can we create a table on the fly which contains the the messages table and an additional column, comment_count. I mean what can be done in the Dataset so we can inherit the messages table and add an comment count column which's value evaluated by another SQL statement.

That's also what I mean, you can add a new column to the current messages table and manually add the values for this column from executing another statement or you can manipulate the values from the second table in the dataset. In addition, you might also consider creating view or store procedure to populate the messages table with the comment count in one go.

Changing ASP.Net Controls.

legionnaire7-Dec-06 9:40

legionnaire

7-Dec-06 9:40

Hello,

I am working on a form to edit some users information. As I have it right now, when the administrator is going to change a user's info, they first search the user to make sure it exists. The information appears on screen - or gives an error if the user doesn't exit - and the admin now presses the "Modify" button.

Here's my question: Is there a simple way that I could change the tags in which the information is shown to a drop down list? I know I can do it in the code behind using a string that contains the HTML code and then output it with Response.Write; but then my drop down list would lose all it's ASP.Net functionality.

I figure I could do it on the aspx file if I use a lot of conditionals to go around the HTML/ASP.Net code that I don't want; but I don't find this a clean way to do it.

Thanks in advance!

Re: Changing ASP.Net Controls.

minhpc_bk7-Dec-06 14:51

minhpc_bk

7-Dec-06 14:51

You can simply add two controls in the web page and depending on the context you can set the Visible property of the control accordingly to show/hide the control. Another option is that you can dynamically add the control (not the html markup) to the web page at runtime, but you should be aware of a couple of things when working with dynamic controls.

Re: Changing ASP.Net Controls.

legionnaire8-Dec-06 7:33

legionnaire

8-Dec-06 7:33

Hello,

Thanks for your reply! Even though I had thought of what you speak, it didn't sound "clean" to me. Yet, I recently found an article explaining exactly what I wanted to do. You can find them here:

Dynamic Controls in ASP.Net -> http://aspnet.4guysfromrolla.com/articles/081402-1.aspx
Working with Dynamically Created Controls -> http://aspnet.4guysfromrolla.com/articles/082102-1.aspx
Dynamic Web Controls, Postbacks and View State -> http://aspnet.4guysfromrolla.com/articles/092904-1.aspx

I hope this can help the community!

selectcommand in asp.net

saravanan057-Dec-06 8:55

saravanan05

7-Dec-06 8:55

hi to all

SqlConnection con = new SqlConnection(connstring);
SqlCommand cmd = new SqlCommand("SELECT * FROM customers", con);
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = cmd;
da.Fill(ds);

DataTable dt = ds.Tables[0];

return dt;

what is the purpose of using selectcommand(da.SelectCommand = cmd)

regards
saravanan

Re: selectcommand in asp.net

minhpc_bk7-Dec-06 14:46

minhpc_bk

7-Dec-06 14:46

Populating a DataSet from a DataAdapter[^]

Text displayed as symbols

mikeh nz7-Dec-06 7:54

mikeh nz

7-Dec-06 7:54

Hi,
I have a web page that displays a line graph. The control I was using under .Net 1.1 was WebChart from www.carlosag. When I migrated the site to .Net 2.0 the chart started to behave strangely in that all text was displayed as symbols. I thought maybe the chart was in some way not compatible so I downloaded ZedGraph and have discovered that I get the same behaviour. So it's obviously not a control specific problem. I reloaded the .Net Framework 2.0 last night but that didn't help. I'm developing under Windows 2k SP4 using Visual Web Developer Express. Any ideas? I'm getting desperate

thanks
mike

Help for IcallBack Interface using ASP.net

meerabhuva7-Dec-06 7:28

meerabhuva

7-Dec-06 7:28

I have Dropdownlist and onSelectedIndex I want to fill another Dripdownlist ( ASP control ). How to implement the same. With HTML button control Javascript is possible but how about this? I do not have Ajax control.

Re: Help for IcallBack Interface using ASP.net

minhpc_bk7-Dec-06 14:53

minhpc_bk

7-Dec-06 14:53

The link below may get you started:

Implementing Client Callbacks Without Postbacks in ASP.NET Web Pages[^]

Populating datas from sql db and displaying them in .CSV File Format- VERY VERY URGENT

vijay_837-Dec-06 6:57

vijay_83

7-Dec-06 6:57

Hi
I have to populate some datas from sql server database and display it directly in a CSV Format or CSV file. When i run the project it should provide me an option to whether open or save or cancel the file. when i click open it should be opened and be viewed in a excel sheet in CSV format and when i click save it should ask the destination folder and should be saved there in CSV format and when i click cancel it should be cancelled and the application should be closed. pls note that all these actions should happen in the same browser and should not be redirected to anyother page. Can anybody give me the detailed description and code in Asp.Net using C# .It's very Urgent.

Regards
Vijay.

Re: Populating datas from sql db and displaying them in .CSV File Format- VERY VERY URGENT

Not Active7-Dec-06 7:45

Not Active

7-Dec-06 7:45

VERY VERY URGENT -- Forgot to do your homework eh? Roll eyes | :rolleyes:

only two letters away from being an asset

Re: Populating datas from sql db and displaying them in .CSV File Format- VERY VERY URGENT

vijay_837-Dec-06 8:57

vijay_83

7-Dec-06 8:57

Hi,

If u know answer me or else silently move to another question. pls dont post some funny messages like this;P

Re: Populating datas from sql db and displaying them in .CSV File Format- VERY VERY URGENT

Not Active7-Dec-06 9:05

Not Active

7-Dec-06 9:05

You're right, there is nothing funny about not being able to do your homework. Blush | :O

Someday we may have to work together, or some one like you, and I'll have to waste my time teaching you what you should have learned in school.

only two letters away from being an asset

Re: Populating datas from sql db and displaying them in .CSV File Format- VERY VERY URGENT

vijay_837-Dec-06 11:40

vijay_83

7-Dec-06 11:40

Dont act as if u r a smarthead and don't insult others as the same will happen to u when u r in some urgency. If u dont know the answer just shut up and get the hell out of my way.

Re: Populating datas from sql db and displaying them in .CSV File Format- VERY VERY URGENT

Not Active7-Dec-06 11:47

Not Active

7-Dec-06 11:47

Took you a while. Did you need help with that also?;P

only two letters away from being an asset

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