|
I will give it a try - Thanks for your help
|
|
|
|
|
how can i paste an item from a listbox to a textbox in the same form with a click of a button?
|
|
|
|
|
Without further detail, it's impossible to know exactly what you want. But, in the Click event of the button:
TextBox1.Text = ListBox1.SelectedItem.ToString()
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have installed Active Reports, now how do i get them to work with vb.net
Active Reports help file only tells you how to add it in VB6. I cant figure it out.
|
|
|
|
|
A better bet would be to ask Data Dynamics support to see what you have to do. As I understand it, it may not be supported under .NET, though, they do have a version specifically for .NET.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i m also looking for idea about active report. plz guide me too
|
|
|
|
|
I'll do the same as I did before. I'll guide you straight to Data Dynamics web site for support.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have this Access Database with a table which showes the name list of the pictures and the other one contents the pictures. The names should show in a Listbox and the Pictures in the picturebox. Can somebody help me how I can show the pictures into the Picturebox??????????/
many Thanks and regards
kaly
|
|
|
|
|
get picture in an array like below
Dim arr() As Byte
arr = ds.Tables("TableName").Rows(0).Item("ColumnName")
' CompanyLogo is the name of PictureBox Control
CompanyLogo.Image = CompanyLogo.Image.FromStream(New IO.MemoryStream(arr))
hope it'll help
|
|
|
|
|
Where shall I put the code? in the PictureBox Section or at Form L
|
|
|
|
|
its upto u. this code is for reading data from database . I think u have to put this code under the method where u want to display the picture
|
|
|
|
|
ok one thing more... the code looks fine except the "DS"? i have to decalre it first before I can use it...
|
|
|
|
|
ds is DataSet. i thought u can easily get it .anyway declare it as
Dim ds As New DataSet()
|
|
|
|
|
Hi ive programmed this: but it doesnt work, there are no errors showing just it doesnt wants to show the list from the Database in the Listbox...
Private Sub ListBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DBPicturename.SelectedIndexChanged
myConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = U:\VB_assign.mdb"
myConnection.Open()
myDataAdapter = New OleDb.OleDbDataAdapter("Select * From Pictures", myConnection)
mycommandbuilder = New OleDb.OleDbCommandBuilder(myDataAdapter)
myDataAdapter.Fill(myTable)
End Sub
regards kaly
|
|
|
|
|
Did you bind the listbox to the appropriate column in the dataset?
|
|
|
|
|
yes I did, the column name for the pictures name is "pictures"
|
|
|
|
|
Hi I just tested with an textbox instead of an listbox.. it seems that the code works only with the Textbox and not with an listbox..
regards kaly
|
|
|
|
|
My reports take about 30 seconds to load, how do i create a message box that
is displayed during that time period and dissapears when the report loads????
|
|
|
|
|
|
What code do i put behind the progress bar?? Any? Ive never used one
|
|
|
|
|
If your using CrystalReports for your report, it doesn't report progress as the report loads, so displaying an actual progress won't work. Your "progress bar" could be as simple a a moving box, or whatever, incremented by a Timer Tick event.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Everyone,
I stuck on trying to figure out how to accomplish my task, which is build a string search that calls back all tables that contain the given string. This is what I have so far:
Step 1: I have a public method that the value is pass. I then go to step 2
Step 2: CheckTable which takes the value of the table name and fieldvalue - however I get an error message stating that a datareader is open. I'm not sure how to handle this.
Class Object:
Public Function OracleValueFinder(ByVal FieldValue As String)
Dim SQLTable As String = "SELECT table_name FROM user_tables ORDER BY table_name"
oConnection.Open()
Dim oCmd As New OdbcCommand(SQLTable, oConnection)
Dim oDR As OdbcDataReader = oCmd.ExecuteReader
While oDR.Read
checkTable(oDR(0), FieldValue)
End While
oDR.Close()
End Function
Public Sub checkTable(ByVal TableName As String, ByVal FieldValue As String)
Dim length As Integer = 0
Dim SQLColumn As String = "SELECT column_name FROM user_tab_columns " & _
"WHERE table_name = '" & TableName & "' " & _
"AND data_type = 'VARCHAR2' " & _
"AND data_length >= " & length & " " & _
"ORDER BY column_id"
Dim oCmd As New OdbcCommand(SQLColumn, oConnection)
Dim oDR1 As OdbcDataReader = oCmd.ExecuteReader
While oDR1.Read
CheckColumn(TableName, oDR1(0), FieldValue)
End While
oDR1.Close()
End Sub
Public Sub CheckColumn(ByVal TableName As String, ByVal columnName As String, ByVal FieldValue As String)
Dim sSQL As String = "SELECT COUNT(*) FROM " & TableName & _
" WHERE " & columnName & " LIKE '%" & FieldValue & "%'"
oConnection.Open()
Dim oCmd As New OdbcCommand(sSQL, oConnection)
Dim oDR3 As OdbcDataReader = oCmd.ExecuteReader
While oDR3.Read
Console.WriteLine(oDR3(0) & " - " & oDR3(1))
End While
End Sub
End Class
Thanks,
|
|
|
|
|
Well, I'm not familiar with Oracle, but if I were using MS SQL Server, I'd write the entire search process in a stored procedure that accepts the search string as its only parameter, and returns the results in a single result set. This would avoid having to submit multiple queries over the ODBC connecton, as well as simplify everything.
|
|
|
|
|
The issue I'm facing with this is that the company policy is you are not allowed to write stored procedures for this Oracle database. I've written stored procedures for both Oracle and SQL Server for this task. I have to use .NET for this task.
Thanks,
|
|
|
|
|
Hello there
I need to put the background image on Treeview / list view. if any one has the code would be highly appreciated..
Best Regards
Rizwan Bashir
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
