ASP.NET

15-Aug-07 17:16

Hi,

I am storing the checkboxlist items as comma seperated values in a row. My problem is during updation of those values. When i bind the values to the checkboxlist i want to display all items but only those items have to be checked which are present in the row.

For inserting i am using the followng code,

Dim sqlstr As String
Dim str As String = ""
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
For Each item As ListItem In CheckBoxList1.Items
If item.Selected = True Then
If str = "" Then
str = item.Text
Else
str = str & "," & item.Text
End If
End If
Next
sqlstr = "insert into test(c1) values(@c)"
Dim comm As New SqlCommand(sqlstr, dbconn)
comm.Parameters.Add("@c", SqlDbType.Char, 10).Value = str
Try
comm.ExecuteNonQuery()
Label1.Visible = True
Label1.Text = "Success"
Catch ex As Exception
Label1.Visible = True
Label1.Text = ex.ToString
End Try

Michael Sync15-Aug-07 17:42

15-Aug-07 17:42

n_gchaitra wrote:
My problem is during updation of those values.

I'm not sure what problem you are facing... Can you tell us more about the problem you are facing and what you wanna do? Smile | :)

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

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

n_gchaitra15-Aug-07 17:57

15-Aug-07 17:57

Michael, I have around 20 items in which only checked items have to stored. It is working fine. When i want to update that obviously i have to see all those twenty items. Here i want to them to compare with the items present in the table and the matching rows have to get checked.

Chaitra N

Michael Sync15-Aug-07 20:03

15-Aug-07 20:03

Is that what you want?

Listbox.DataSource = Database.GetAllItems(); <br />
Listbox.DataBind();<br />
<br />
string[]  storedValues = Database.GetStoredItems().Split(",");<br />
<br />
foreach(string val in storedValues){<br />
  foreach ( ListItem itm in ListBox1.Items ){<br />
    if(itm.Value == val){<br />
       itm.Checked = true;<br />
    }<br />
  }<br />
}<br />

n_gchaitra15-Aug-07 23:09

15-Aug-07 23:09

Michael I am afraid i did not understood what is "Database" in
Listbox.DataSource = Database.GetAllItems();
Listbox.DataBind();

string[] storedValues = Database.GetStoredItems().Split(",");

The code i am using to bind the values are as follows. This works fine. I want only matching values to get checked. Can u help me please?

Dim constr As String = ConfigurationSettings.AppSettings("conn")
Dim dbconn As New SqlConnection(constr)

Sub bind()
Dim sqlstr As String
sqlstr = "select software from list where sno='" & txtsno.text & "'"
Dim comm As New SqlCommand(sqlstr, dbconn)
Dim dr As SqlDataReader
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
dr = comm.ExecuteReader
While dr.Read
CheckBoxList1.Items.Add(dr.Item(0).ToString)
End While
dr.Close()
End Sub

Chaitra N

Michael Sync15-Aug-07 23:41

15-Aug-07 23:41

Database should be a helper class that return the dataset after retrieving the data from database.

n_gchaitra wrote:
I want only matching values to get checked.

What you meant is that there are the values (1,2,3) in database. There are 5 items (1,2,3,4,5) shown in ListBox. After retrieving the data (1,2,4) from database, you want the items (1,2,3) to be checked. Is it what you want?

Let's Database.GetAllItems(); will return all data (1,2,3,4,5) from database.

this method Database.GetStoredItems() will return all saved value as a comma seperated value (eg: 1,2,3)

eg:

public class Database{<br />
  public static string GetStoredItems(){<br />
    //Get the data from Database<br />
    //Return those data as comman seperated value<br />
    return str;  // 1,2,3<br />
  }<br />
  public static DataSet GetAllItems()(){<br />
    //Get the data from Database<br />
    //Return those data as DataSet<br />
    return ds;  // 1,2,3,4,5<br />
  }<br />
}

then, bind it to Listbox. (So, 1,2,3,4,5 will be shown in Listbox. )

<br />
Listbox.DataSource = Database.GetAllItems();<br />
Listbox.DataBind();

then, get the saved values from database. (In our case, we will get "1,2,3"). Split to string array. loop through the listbox and string array to find the match. If match found, we set itm.Checked = true;

string[] storedValues = Database.GetStoredItems().Split(",");<br />
<br />
foreach(string val in storedValues){<br />
foreach ( ListItem itm in ListBox1.Items ){<br />
if(itm.Value == val){<br />
itm.Checked = true;<br />
}<br />
}<br />
}

Is the way I understand correct?

Hopefully, you got my point...

n_gchaitra16-Aug-07 23:47

16-Aug-07 23:47

i am getting "System.Data.DataRowView " error. I tried to write the function in the same class but still getting the same error.

Dim constr As String = ConfigurationSettings.AppSettings("conn")
Dim dbconn As New SqlConnection(constr)

Sub bind1()
CheckBoxList1.DataSource = GetAllItems()
CheckBoxList1.DataBind()
Dim storedValues As String() = Database.GetStoredItems().Split(",")
For Each val As String In storedValues
For Each itm As ListItem In CheckBoxList1.Items
If itm.Value = val Then
itm.Selected = True
End If
Next
Next
End Sub

Public Function GetAllItems() As DataSet
Dim ds As New DataSet()
Dim sqlstr As String = " select list from AList"
Dim comm As New SqlDataAdapter(sqlstr, dbconn)
comm.Fill(ds)
'Return those data as DataSet

Return ds
' 1,2,3,4,5
End Function
Public Function GetStoredItems() As String
'Get the data from Database
' Dim dbconn As New OleDb.OleDbConnection("provider=sqloledb;user id=sa;password=;trusted_connection=yes; initial catalog=wfphumanet;data source=localhost")
Dim ds As New DataSet()
Dim str As String = " select c1 from test where sl='" & TextBox1.text & "'"
'Return those data as comman seperated value
Return str
' 1,2,3
End Function

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
bind1()
End Sub

Chaitra N

Michael Sync17-Aug-07 2:20

17-Aug-07 2:20

n_gchaitra wrote:
CheckBoxList1.DataSource = GetAllItems()
CheckBoxList1.DataBind()

Change like that ~

<br />
CheckBoxList1.DataSource = GetAllItems().Tables(0)<br />
        CheckBoxList1.DataValueField = "list"<br />
        CheckBoxList1.DataTextField = "list"<br />
        CheckBoxList1.DataBind()

Full Code Sample

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load<br />
<br />
        CheckBoxList1.DataSource = GetAllItems().Tables(0)<br />
        CheckBoxList1.DataValueField = "Num"<br />
        CheckBoxList1.DataTextField = "Num"<br />
        CheckBoxList1.DataBind()<br />
<br />
        Dim storedValues As String() = GetStoredItems().Split(",")<br />
        For Each val As String In storedValues<br />
            For Each itm As ListItem In CheckBoxList1.Items<br />
                If itm.Value = val Then<br />
                    itm.Selected = True<br />
                End If<br />
            Next<br />
        Next<br />
<br />
    End Sub<br />
<br />
    Public Function GetAllItems() As DataSet<br />
        Dim ds As New DataSet()<br />
<br />
        Dim dt As New DataTable()<br />
        Dim dc As New DataColumn("Num")<br />
        dt.Columns.Add(dc)<br />
<br />
        For i As Integer = 1 To 5<br />
            Dim dr As DataRow = dt.NewRow()<br />
            dr(0) = i<br />
            dt.Rows.Add(dr)<br />
        Next<br />
<br />
        ds.Tables.Add(dt)<br />
        Return ds         ' 1,2,3,4,5<br />
    End Function<br />
<br />
    Public Function GetStoredItems() As String<br />
        Return "1,2,3"<br />
    End Function<br />
<br />

Hope it helps..

n_gchaitra17-Aug-07 17:28

Can I remove Master Page in the program?

17-Aug-07 17:28

But Michael it returns only the values present in a table where i am storing all the values.

See i put my requirement in another way.

For the subscription of a website i enter some area of interest in checkboxes. Suppose if i want to modify them(addition or removal), i need to see all the options(area of interest) as well a which i had selected. All the values options will be present in one table and when i request the page it displays all the options and the options i had chosed previously have to be checked.
Let say i am storing all the options in a table "Options" in the column "Interest" and when i select them i will store the values in the table "Web" which has the columns "Email" And "Area_Of_Int".

Chaitra N

J Liang15-Aug-07 16:57

J Liang

15-Aug-07 16:57

Hi,

I was wondering whether is it possible for me to remove the Master Page that was previously attached to one page in the program.

For example, when some criterias are met, I want the Master Page to off from the page so that I don not need to create another same aspx page without the Master Page.

Thanks in advance.

J Liang

Steve Echols15-Aug-07 18:16

Steve Echols

15-Aug-07 18:16

You can, but I think it needs to be in PreInit or before:

C#:

protected override void Page_PreInit(object sender, EventArgs e)
{
    this.MasterPageFile = "~/yes_my.master";
}

VB:

Protected Sub Page_PreInit(ByVal sender As Object, _
                           ByVal e As EventArgs) _
                           Handles Me.PreInit

    Me.MasterPageFile = "~/yes_my.master"

End Sub

- S
50 cups of coffee and you know it's on!

nandhububbly15-Aug-07 19:23

nandhububbly

15-Aug-07 19:23

Hi u can remove ur master page ok no problem .. what u do means ,
1.remove ur masterpage reference from ur <@ page > page directive
2. add ur user control what u mentioned in master page that user control
3.add ur HTML guide reference
4.add ur html tags like hetml,head,title,and if u r using any any some script funtion..

thats all..

incase u cant do it send ur .aspx page and ur masterpage to my id.
n.nanthakumar@gmail.com

Reg
nantha

Michael Sync15-Aug-07 20:04

Re: Can I remove Master Page in the program? [modified]

15-Aug-07 20:04

I think he wants to remove dynamically from Code.

Michael Sync15-Aug-07 19:57

15-Aug-07 19:57

I don't think you can remove the master page but you can change the master page. So, you can two master pages in your website. Change it at Page_PreInit event.

Eg:

protected void Page_PreInit(object sender, EventArgs e)<br />
   {<br />
       this.MasterPageFile = "MasterPage2.master";<br />
    <br />
   }

Edit: I didn't see Steve's reply. I think his reply is the answer.. I forget to click "Submit" button before going lunch.

-- modified at 2:07 Thursday 16th August, 2007

Can't create ASP controls from shared function

ganeshvittal15-Aug-07 20:57

ganeshvittal

15-Aug-07 20:57

Before designing a web application using Master pages try to have two master page files:

1) Master page with Header.
2) Master page without Header.

Whenever you dont require the header part do the following code

protected void Page_PreInit(object sender, EventArgs e)
{
this.MasterPageFile = "MasterWOHeader.master";
}

The Idea behind this is, normally we use to include the common javascript functions in the master page since its a generic container. If you remove the masterpage then it might give you some problem[Since masterpage holds the generic javascript code], its better to embed the common javascript files in both the masterpages and use it in the required scenario.

Thanks,
Ganesh Kumar

chris_wanaka15-Aug-07 16:51

chris_wanaka

15-Aug-07 16:51

Hi,

I'm hoping I've just overlooked something obvious here and someone will be able to help, one of those things where it's pretty simple and *should* work but doesn't...

I originally had this code on a page, which worked fine:

<div id="remote-support">
<h2>Remote Support</h2>
Pin code:
<asp:TextBox Width=80px ID="TextBox1" runat="server"></asp:TextBox>
<br /><br />
<asp:Button ID="Button1" runat="server" Text="Button" />
</div>

I replaced it with the following code on the page:

<div id="remote-support">
<% Response.Output.Write(Common.RemoteSupport(ThisPage))%>
</div>

And this is in some shared code in App_Code:

Public Shared Function RemoteSupport(ByVal ReferringPage As String) As String
RemoteSupport = "<h2>Remote Support</h2>" _
& "Pin code: <asp:TextBox Width=80px ID=""TextBox1"" runat=""server""></asp:TextBox><br />" _
& "<br />" _
& "<asp:Button ID=""Button1"" runat=""server"" Text=""Button"" />"
End Function

Now, what's happening is there's no controls appearing on the page, despite the page source containing the control tags as normal.

Suspect this has something to do with me getting something fundamental wrong, but can't quite get my head round what's going on. Surely it's possible to do this one way or another, maybe just not this way...

Any help would be greatly appreciated Smile | :)

Thanks
Chris

Re: Can't create ASP controls from shared function

Michael Sync15-Aug-07 17:30