ASP.NET Discussion Boards

Sathesh Sakthivel9-Jul-07 20:42

9-Jul-07 20:42

Allow the User to rate only once. Once if the user voted and get the data and store it in the DB and once again if the user tries to vote pls send the message that "you have rated it before."

Hope you got it.

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Disabling checkbox/row in repeater?

kbalias9-Jul-07 19:55

kbalias

9-Jul-07 19:55

Hi
I am using Visual Studio 2005 and ASP.Net to develop a Web application. I created a web usercontrol that contains a Repeater. I bind the repeater to a DataTable that is loaded from a database. Each row in the repeater has a CheckBox. Is it possible disable certain of the checkboxes/rows depending on some criteria?

For example the repeater will show all students that have classes for that day. That means a student may appear in more than one row in the repeater, but he can only physically attend one class at a time. Therefore I would like to disable the other rows or checkboxes for that student so that the teacher cannot check more than one checkbox by accident.

Can this be done and how would I go about it?

Thanks.

Kobus

master page

ravikiranreddydharmannagari9-Jul-07 19:35

ravikiranreddydharmannagari

9-Jul-07 19:35

having text box and button in a master page.....

issue is

in child page.... when i clik on the (master) button iam not able to retain the value of (master) text box...

plz help me out

Re: master page

Sven Cipido9-Jul-07 20:13

Sven Cipido

9-Jul-07 20:13

Events (as for controls are handled locally. See more in this article : http://msdn2.microsoft.com/en-us/library/dct97kc3.aspx[^].

Bit it can be solved. All info can be found in this article : http://msdn2.microsoft.com/en-us/library/c8y19k6h.aspx[^].

Hopes this helps you out.

Sven Cipido
(http://blog.svencipido.be)

Re: master page

Michael Sync9-Jul-07 20:15

Michael Sync

9-Jul-07 20:15

Suppose: You have one textbox called "TextBox1" in MasterPage. You wanna get the value of Textbox1 from child page..

So, use the following code.

object txt = this.Master.FindControl("TextBox1");<br />
Console.Write(txt.Text);

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

Re: master page

ravikiranreddydharmannagari9-Jul-07 20:22

ravikiranreddydharmannagari

9-Jul-07 20:22

hi
thank u for ur reply
iam able to read the values but the issue is once i clk Master(button) iam not able to retain the values of textbox....

Re: master page

Michael Sync9-Jul-07 20:27

Michael Sync

9-Jul-07 20:27

humm..

You have one textbox called Textbox1 and Button1 in your Masterpage. what you wanna do is that you wanna get the value of textbox1 in the click event of button1.

Is that what you want??

protected void Button1_Click(object sender, EventArgs e)<br />
    {<br />
        Console.WriteLine(TextBox1.Text);<br />
    }

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

Re: master page

ravikiranreddydharmannagari9-Jul-07 20:38

ravikiranreddydharmannagari

9-Jul-07 20:38

on the postback iam not able maintain the state of (master)text box in child page.....

In Master Page
<asp:button id="Button2" runat="server" style="color:White;background-color:#67AEE4;border-width:0px" postbackurl="~/Default6.aspx" text="Button">
<asp:textbox id="Header1_txtword" runat="server" enableviewstate="true">

In child page
if i enter "ravi" in textbox and clik on button iam not able to see the ravi in textbox..........

i hope its clear.....

Re: master page

Michael Sync9-Jul-07 20:46

Michael Sync

9-Jul-07 20:46

Master Page.
==========

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %>

<!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 runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /></div>
<asp:contentplaceholder id="ContentPlaceHolder1" runat="server">
</asp:contentplaceholder>

</form>
</body>
</html>

----------------------
Child Page
==========

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
</asp:Content>

Run the application. Put "ravi" in Textbox1. Click Button1. You will still see the "ravi" that you put..

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

Re: master page [modified]

ravikiranreddydharmannagari9-Jul-07 21:09

ravikiranreddydharmannagari

9-Jul-07 21:09

hey

iam using postback url for (master) button to redirect to another child page
where i need to display the data....

In master page

<asp:button id="Button2" runat="server" text="search" postbackurl="~/Default6.aspx?">
<asp:textbox id="Header1_txtword" runat="server" enableviewstate="true">

In Child Page..

string str = Request.Form["ctl00$Header1_txtword"].ToString();

once i clik on button the value in text box disapperaing....

-- modified at 3:24 Tuesday 10th July, 2007

Re: master page

sidbaruah9-Jul-07 22:02

sidbaruah

9-Jul-07 22:02

create a master page object and call the master page controls using this master page object!!!!

I was born dumb!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

Re: master page

ravikiranreddydharmannagari9-Jul-07 23:03

ravikiranreddydharmannagari

9-Jul-07 23:03

in master page
<asp:textbox id="TextBox1" runat="server">
<asp:button id="Button1" runat="server" postbackurl="default.aspx">

in default.aspx

if i clk on button i am not able to retain the value....

BackGround Sound In the web site

EEmaan9-Jul-07 19:18

EEmaan

9-Jul-07 19:18

Hi...!
i want to play a single background sound\music through out my website. I dont want to break the sequence of this BAckground sound even the page changes.

Re: BackGround Sound In the web site

Michael Sync9-Jul-07 20:08

Michael Sync

9-Jul-07 20:08

>>I dont want to break the sequence of this BAckground sound even the page changes.

Very tough requirement.... Blush | :O

Maybe. you can create the whole website with Flash.

OR maybe. you can use ajax to change the page without loading the whole page.

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

Re: BackGround Sound In the web site

Ken Fan9-Jul-07 21:53

Ken Fan

9-Jul-07 21:53

you can use iframe and hedden iframe

study hard

Re: BackGround Sound In the web site

Vasudevan Deepak Kumar9-Jul-07 22:35

Vasudevan Deepak Kumar

9-Jul-07 22:35

1. When the website homepage loads make a frameset like 0%,100% with 0 border.
2) Your website should in the 100% frame always.
3) Now you can have a EMBED tag with the sound\music with loop=1 in the top frame.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

how to session storing in database with exception handling

avananda reddys 1239-Jul-07 19:12

avananda reddys 123

9-Jul-07 19:12

hi ..
exception handling with session store the data in database in asp.net 2.0..
some times session end so but the data is not disply &(closed).so .how to restrict this problem plz tell me as soon as possible.....

avananda reddy

Re: how to session storing in database with exception handling

N a v a n e e t h9-Jul-07 19:21

N a v a n e e t h

9-Jul-07 19:21

avananda reddys 123 wrote:
exception handling with session store the data in database in asp.net 2.0..

Please make your question more clear ? Are you using SQL Server session mode ?

My Website | Ask smart questions

Reading Blob [modified]

ASPnoob9-Jul-07 18:49

ASPnoob

9-Jul-07 18:49

Hi, I'm trying to read a blob with the following code but got the error message"You have an error in your SQL syntax".

 Dim i As Integer<br />
            For i = 0 To ListBox2.Items.Count - 1<br />
                If ListBox2.Items(i).Selected Then<br />
                    Dim myCon As New OdbcConnection<br />
<br />
<br />
                    myCon = New OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=myServer;Database=myDB;User=myUser;Password=myPass;Option=3;")<br />
                    Dim cmd As New OdbcCommand("SELECT * FROM myTable where Professions = 'ListBox2.Items(i).Text' ")<br />
<br />
                    myCon.Open()<br />
<br />
                    cmd.Connection = myCon<br />
<br />
                    Dim ds As New DataSet<br />
<br />
                    Dim ad As New OdbcDataAdapter(cmd)<br />
<br />
                    ad.Fill(ds)<br />
<br />
                    Me.ListBox2.DataSource = ds<br />
<br />
                    Me.ListBox2.DataTextField = "CategoryName"<br />
<br />
                    'Me.ListBox2.DataValueField = "CategoryID"<br />
<br />
                    Me.ListBox2.DataBind()<br />
                End If<br />
            Next<br />

I have looked up the Select statement and the where clause online to see if they are in the correct format. As far as I can see they appear to be in the correct format. Please help me determine the cause of the error, thank you in advance for your help.

-- modified at 1:44 Tuesday 10th July, 2007 Confused | :confused:

Re: Reading Blob

Sathesh Sakthivel9-Jul-07 19:00

Sathesh Sakthivel

9-Jul-07 19:00

Did you Run your Query in the SQL Server.

What error it shows?

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Re: Reading Blob

ASPnoob9-Jul-07 19:03

ASPnoob

9-Jul-07 19:03

The error message that VS2003 shows is as follows.
ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.Text' at line 1

Line 92: Dim ad As New OdbcDataAdapter(cmd)
Line 93:
Line 94: ad.Fill(ds)
Line 95:
Line 96: Me.ListBox2.DataSource = ds

Re: Reading Blob

Rhys Gravell9-Jul-07 19:46

Rhys Gravell

9-Jul-07 19:46

Look more closely at the select statement you're constructing...
"SELECT * FROM myTable where Professions = 'ListBox2.Items(i).Text' "

You are not appending the Text property of ListBox2.Items(i), the WHERE clause is being set to the string literal 'ListBox2.Items(i).Text'.

Rhys

"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"

They say a little knowledge is a dangerous thing, but it's not one half so bad as a lot of ignorance."
Terry Pratchett

Re: Reading Blob

ASPnoob9-Jul-07 20:00

ASPnoob

9-Jul-07 20:00

That's exactly what I wanted. The select statement is supposed to select my table where the name of the profession is equal to the text of the list item being selected. I'm trying to display the content of the field Resume Where the profession field is equal to list item being selected.

Re: Reading Blob

Rhys Gravell10-Jul-07 6:46

Rhys Gravell

10-Jul-07 6:46

Look at it again. The query you're sending is;

SELECT * FROM myTable where Professions = 'ListBox2.Items(i).Text'

NOT

SELECT * FROM myTable where Professions = 'ExampleProfessionFromListBox'

Re: Reading Blob [modified]

ASPnoob10-Jul-07 8:25

ASPnoob

10-Jul-07 8:25

Hi, in my database table the Resumes field stores resumes in blobs and each resume in the Resumes field has a corresponding profession which is stored in the Professions field. I am trying to enable users to search for resumes by selecting a single profession or many professions in the listbox. The select statement is supposed to select the resumes in mytable where the Professions field has the profession(s) that is/are equal to the text of the listitem(s) that the user has selected. Is this the wrong way to go about it? If it is how should I utilize the For-Next loop so that the listitem selected matches the profession in the Professions field? I tried your example but it didn't work, perhaps I did not know how to implement your example correctly. Please elaborate a little more and give another example. This is what I had done after seeing your example
("SELECT * FROM Contenttbl where Professions = 'ListBox2.Items(i).Text from ListBox2'")
Thank you again for your help.

-- modified at 14:39 Tuesday 10th July, 2007

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