Lets say that in the loadmain you set text for a label like this
Label1.Text = "Load Main"
But you want to do the same thing if you click a button, then create a function called for example...

Let's say you have a variable temp
Dim temp As String = "05/02/2005"
Dim ar() As String = temp.Split("/")
TextBox1.Text = ar(0)

The result of ar(0) is 05 i hope that help you.

Ok once you have a connection set up, the easiest way to go is using a dataset you can basically do this. i did not test this.

Dim statement As String = "SELECT EmployeeId, FName FROM tblEmployee"...

Hi, you should open the connection cn.Open() and then cn.Close() also you have a problem and the insert statement you are calling label1.text as lable1.text.

besides that check your table and see...

Just double check this, I am not sure. but when you say this
For i As Integer = 1 To CheckBoxList2.Items.Count
I think the checkboxlist index start in 0.

You right :).

Make sure your dropdownlist does not have duplicate values, for example if you result set when you bind the sub category dropdownlist have a duplicate value, when postback is going to go back to...

Try this

Select a.SubCat_Name from SubCategory as a inner join category as b on a.SubCat_Cat_id = b.Cat_id
where b.Cat_name = '" & DirectCast(e.Item.FindControl("chkCategory"), CheckBox).Text &...

ok, i do not know if this is the best solution but it work.

I test this try to replace your statement in values, notice the event OnItemDataBound that makes the trick.
aspx

<table>
...

well i can tell you right now why.

you are retreiving category and sub category and the same resultset and your data is show as example.
Category Sub_Categor
Network ...

Hi,
I do not know if this can help but try it
replace dr(0) for dr.GetString(0) and dr.GetString(1).
also try in the select retrieve exact the two fields that you want, i do not know what is the...