Comments by Member 9989624

Member 9989624 28-Jul-13 3:11am View

its very simple query. I got it sorted.

Member 9989624 13-Jun-13 0:55am View

In Sql i get the correct value.

Member 9989624 13-Jun-13 0:27am View

I use the below code, this says error Index was outside the bounds of the array.. Please help

Dim connString As String = "Provider=SQLOLEDB.1;Password=$impadmins123;Persist Security Info=True;User ID=simp;Initial Catalog=Employee Information;Data Source=SRAVI6"
Dim conn As New OleDb.OleDbConnection(connString)
Dim sql As String = "SELECT count(EmployeeName) FROM AgentShiftRoster1 where Group1 ='" & Trim(ComboBox1.Text) & "'"
Dim cmd As New OleDb.OleDbCommand(sql, conn)
conn.Open()
Dim reader As OleDb.OleDbDataReader = cmd.ExecuteReader()
While reader.Read()
If reader(7) = Date.Today Then
TextBox1.Text = reader(2).ToString()
End If
End While
reader.Close()
conn.Close()

Member 9989624 8-Jun-13 1:06am View

awarding points for wrong answer is not a good thing.

Member 9989624 8-Jun-13 1:05am View

this isn't a bad design.

Member 9989624 8-Jun-13 1:04am View

This s a manual way of adding date as field. If i want to retrieve the values of current date how to do it?

Member 9989624 24-Apr-13 22:20pm View

I have got the solution thanks.

Member 9989624 19-Apr-13 0:25am View

Sorry mate..:) Got it.. Working amazingly:) you are my man.. thanks a lott

Member 9989624 19-Apr-13 0:16am View

could you please help me with the code:(

Member 9989624 18-Apr-13 23:06pm View

Or how to refer the first listbox should be first coloumn and the next listbox as second coloumn

Member 9989624 18-Apr-13 23:00pm View

i have posted another question please help.

Member 9989624 18-Apr-13 22:38pm View

Fantastic:) Thanks a lot.

Member 9989624 18-Apr-13 22:29pm View

This code wrks good. Howerever what i need is only the first index of both listbox should be added in 3rd list. once the first index of listbox 1 and listbox 2 is added those should be removed.

This should happen till the first listbox is empty.

Please help

Member 9989624 18-Apr-13 22:11pm View

i use this code. its working good for every click. how to loop this until both list is empty?

<pre lang="vb">
Dim selected As Object
Dim selected1 As Object
selected1 = ListBox2.Items(0).ToString
selected = ListBox1.Items(0).ToString
ListBox3.Items.Clear()
ListBox3.Items.Add(selected)
ListBox3.Items.Add(selected1)
ListBox2.Items.RemoveAt(0)
ListBox1.Items.RemoveAt(0)
</pre>

Member 9989624 18-Apr-13 9:42am View

i have created textboxes and buttons dynamically based on the number of items in listbox in form load.

Upon clicking the Button the value of textbox will get incremented ( 1,2,3,4,5,6....... so on..)

ther is no issue till now.

Now i have created Button manually in the form. what i need is when i click that button the current value in the dynamically created text box should get updated to listbox.

there are totally 2 set like below

This set of textbox is names as txt(i) This set of textbox is names as suptxt(i)
Button Text Button Button Text Button
Button Text Button Button Text Button

Please help me.

Member 9989624 18-Apr-13 8:44am View

Maciej Los any help pls

Member 9989624 18-Apr-13 4:48am View

we the result in textbox when we add or subtract, i need that value to be displayed in listbox on clicking button.( this button is not dynamic. its manuall button created in form design).

Member 9989624 18-Apr-13 4:02am View

Maciej Los need your help badly

Member 9989624 18-Apr-13 3:52am View

Maciej i miss u lot. neeed your help badly. Hope u remember we have the textbox and button placed dynamically.
but txt but but txt but
but txt but but txt but
but txt but but txt but

now i need the the values of the txt to be added in listbox on click of a button. ( here listbox and button are manually created).

Member 9989624 17-Apr-13 23:41pm View

Deleted

Below is the code how i have created dynamic controls

<pre lang="vb">below is the code how i have created textbox

For i = 1 To ListBox1.Items.Count
but = New Button
With but
.Location = New Point(500, 150 + (i * 25))
.Tag = i.ToString
.Name = "Button" & i
.Width = 24
.Text = "+"
.Parent = Me
AddHandler but.Click, AddressOf oBtn_Click
End With

txt = New TextBox
With txt
.Location = New Point(545, 150 + (i * 25))
.Tag = i.ToString
.Name = "TextBox" & i
.Width = 24
.Parent = Me
End With

next</pre>

Member 9989624 17-Apr-13 23:40pm View

Deleted

below is the code how i have created textbox

For i = 1 To ListBox1.Items.Count
but = New Button
With but
.Location = New Point(500, 150 + (i * 25))
.Tag = i.ToString
.Name = "Button" & i
.Width = 24
.Text = "+"
.Parent = Me
AddHandler but.Click, AddressOf oBtn_Click
End With

txt = New TextBox
With txt
.Location = New Point(545, 150 + (i * 25))
.Tag = i.ToString
.Name = "TextBox" & i
.Width = 24
.Parent = Me
End With

next

Member 9989624 17-Apr-13 21:04pm View

maciej los. need your help on this question "Adding the Dynamic textbox values to Listbox"

Member 9989624 17-Apr-13 5:41am View

this is getting the listbox items. I need the textbox values.

Member 9989624 17-Apr-13 5:41am View

I dont have any concerns with txt boxes. Moreover there is difference in Separation and understanding. My query was clear and i have not coupled them. Anyways thanks for your time.

Member 9989624 17-Apr-13 0:06am View

i need to insert all textboxs values. in short number of text boxes created dynamically.the number of text box depends on the number of items in listbox

Member 9989624 16-Apr-13 2:38am View

Am sorry:).. posted a new question with code. Please assist

Member 9989624 16-Apr-13 1:59am View

i had checked, its unique name. could you please test and help me?

Member 9989624 16-Apr-13 1:17am View

Yea i used it. I have another set as same setup. ie)

but txt but but txt but
but txt but but txt but
but txt but but txt but.

how to handle the second set? i tried with the same however value not getting incremental at second set. its getting incremented at first set only.

Member 9989624 15-Apr-13 14:15pm View

5 Star for you. You deserve it:)

Member 9989624 15-Apr-13 14:14pm View

Yea i had done those handlers. thanks a lot for your support. i got it done by adding this
txt.Text = Val(txt.Text) + 1.

That was really great to meet you. Am fully satisfied:)

Member 9989624 15-Apr-13 13:44pm View

one doubt here maciej. everything is fine.

i added this below

Dim btn As Button = sender
Dim txt As TextBox = CType(Me.Controls("TextBox" & btn.Tag), TextBox)
count = count + 1
txt.Text = count

instead typing the button text to textbox. the value should keep incremental on clicking the button. but what happens when i add above is. if i press first button once the text vale is 1 and gets incremented with no issues. when i click the next button the textbox value gets continued from the previous text box. i need each text box should hold its own increment value when i press the button. please help

Member 9989624 15-Apr-13 13:31pm View

Thanks a lot Maciej Los. I will implement it to me code. Working Really great:)

Member 9989624 15-Apr-13 12:57pm View

Thanks.tried for loop. am struck in incremental with the control variable. still its pointing the last textbox only.

Member 9989624 15-Apr-13 12:43pm View

any advice how to get it?. i have set names for each textbox's, however only last textbox value is getting incremented.

Comments by Member 9989624 (Top 34 by date)