|
Hi Jim,
Thanks for ur response. Even then am not getting it.
Problem is Iam getting the report, its header fields and all that... but am not getting the values for them. what might be problem.
what might be the problem..?
Basically i have a form with two(let's say) fields and a submit button.On button click, I want to check the access database with these two fields and want to generate a dataset.
Finally, i want to use this dataset to generate a report
Just to test whether my dataset has values or not i just binded it to the datagrid.Its working fine.
Why am not getting the values when am passing it to the report...?If u have any samples regarding to perform the same Would you let me know..?
Thanks in advance
|
|
|
|
|
well, if you have data in the datagrid and you're using the above code to populate the report, i would have to guess that something is wrong in your report template.
check to make sure that in your report template, when you select a datasource you select ADO.Net and point to a schema file that represents the structure of your dataset. then, make sure that you set the relationships of the tables properly on the links tab.
what i actually like to do here is write my code for populating the dataset first, then step through the debugger and write the dataset out to an xml file including the schema.
then use this file as the source for your report. this way you ensure that the xml you're passing to the report template in your code is the same as what you are designing the report with.
hope this helps.
-jim
|
|
|
|
|
dear friend
Actually i have a smart card developed with vb application interface. It has a unique no in it. I want to pass that number in koha log in screen . Koha is a open source lib software built with cgi perl. whenever i will insert the smart card in the reader the specific id no will go to the text box of koha log in screen .
url:"http://hlt.katipo.co.nz/cgi-bin/koha/mainpage.pl"
My question is the id nomcan be shown in a textbox or label of an application in vb, the url can be invoked with the help of web browser.In the text box of that login screen i want to show the id no. HOW?
Thanks in advance
Rana
|
|
|
|
|
hi this is my first posting
i am using xml xttp object in vb for getting information from web i have produced one SITE CRAWLER in vb6 . i need to send multiple requests to travel whole site but while sending multiple requests the application will just hangs some time for getting reply from server so i want to uilised that time also can anybody tell me how to get / handle other events while posting http request
regards yogi
|
|
|
|
|
can we send mail from any pc without the local smtp server on that machine through code in vb or vc.
ddd
|
|
|
|
|
please help me
How j can find the dominant color in a bitmap with a function or with the ColorMatrix?
|
|
|
|
|
This should get you started, it has routines to count and average colors:
http://www.codeproject.com/vb/net/GausianBlur.asp
|
|
|
|
|
hello
i just want to know whay the boolean type take two bytes in the memory knowing that a simple one bit is enough ???
|
|
|
|
|
It actually only takes one byte. One byte is the smallest possible allocation unit in the Intel x86 architecture. The compiler maps your boolean value into that byte.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I created a DLL in VC++ 6.0. I am using it in VB 6.0. I
need to debug the DLL when I call a function in the DLL.
How do I do it from VB6?
1fm1fu
|
|
|
|
|
You are trying to do this backwards. What you do is create the VB6 application that calls the C++ DLL and then debug the DLL in the C++ debugger.
Robert
|
|
|
|
|
plz help me if any body have solution of this problem .
I have a big problem with .NET.
Short Description:
As long as I have an empty From in my Windows Application everything
works fine, but as soon as I add any kind of Control (e.g. a Button) to
the Form I get the following Exception in the InitializeComponents
method
*
An unhandled exception of type 'System.ArithmeticException' occurred in
system.drawing.dll
Additional information: Overflow or underflow in the arithmetic
operation.*
I read on a discussion board that this is caused by something called FPU
Exceptions which could be enabled by a hardware part of my machine.
Is there a Way to find out which part? Or is there a Way to turn them
off except the one on the MS Site?
Please help me if any body have solution of this problem
|
|
|
|
|
Hi all, i'm trying to create a new database in CE but it doesnt seem to work for some reason........can someone help? thanks!!
Imports System.Data.SqlServerCe
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'create DB
Dim engine As New SqlServerCe.SqlCeEngine("Data Source = \My Documents\test.sdf")
engine.CreateDatabase() 'error here
'connect to DB
Dim ssceconn As New SqlServerCe.SqlCeConnection("Data Source = \My Documents\test.sdf")
ssceconn.Open()
'ceate table
Dim sqlCreateTable As SqlServerCe.SqlCeCommand = ssceconn.CreateCommand()
sqlCreateTable.CommandText = _
"CREATE TABLE People(people_id int IDENTITY(0,1) PRIMARY KEY, f_name ntext, l_name ntext)"
sqlCreateTable.ExecuteNonQuery()
'inserting rows
Dim sqlInsertRow As SqlServerCe.SqlCeCommand = ssceconn.CreateCommand()
sqlInsertRow.CommandText = "INSERT INTO People(f_name, l_name) VALUES('John', 'Doe')"
sqlInsertRow.ExecuteNonQuery()
'close connection
ssceconn.Close()
End Sub
An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll
Additional information: SqlCeException
|
|
|
|
|
It would appear that your connection string isn't valid. Specifically, my first suspect would be the path you provided for Data Source . But, your question really belongs in the Embedded/Mobile forum.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hmm ok. i'll try my luck in the Mobile forum. thanks for the reply anyway.
|
|
|
|
|
I’m trying to write a function that returns a datatable. Within the function I’m calling a stored procedure in access. The code looks like this:
Public Shared Function LoadSearchResults(ByVal whereClause As String) As DataTable
Dim SQL As String = " EXECUTE qrySearchResult"
Dim dt As DataTable = New DataTable()
Dim da As OleDbDataAdapter = New OleDbDataAdapter()
dbConnection.Open()
'Dim Cmd As New OleDbCommand(SQL, dbConnection)
Dim Cmd As New OleDbCommand()
Cmd.CommandType = CommandType.StoredProcedure
Cmd.CommandText = "EXECUTE qrySearchResult"
Cmd.Parameters.Add(Cmd.CreateParameter())
Cmd.Parameters(0).Value = whereClause
'''''dr = Cmd.ExecuteReader()
''''''''''''''''''''
da.SelectCommand = Cmd
da.Fill(dt)
dbConnection.Close()
dbConnection.Close()
Return dt
End Function
How can I accomplish this?
Thanks,
Martin
|
|
|
|
|
Whatr's the problem ?
Why are you closing your connection twice ?
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
The problem here is that I don't know how to get a datatable from: dr = Cmd.ExecuteReader().
Please ignore the 2nd dbConnection.Close().
|
|
|
|
|
You can try this code to use your datareader to build your datatable
Dim table As New DataTable()
Dim row As DataRow
Dim rows As DataRowCollection
' read table schema from datareader
rows = DataReader.GetSchemaTable.Rows
'If you already know your field names you can use this
table.Clear()
table.Columns.Clear()
' Define the columns.
table.Columns.Add("Last Name", GetType(String))
table.Columns.Add("First Name", GetType(String))
table.Columns.Add("Phone Number", GetType(String))
table.Columns.Add("Email Address", GetType(String))
'Other wise do this
' use schema to create the columns for the new datatable
For Each row In rows
Dim col As New DataColumn()
col.ColumnName = row("ColumnName").ToString
col.Unique = System.Convert.ToBoolean(row("IsUnique"))
col.AllowDBNull = System.Convert.ToBoolean(row("AllowDBNull"))
col.ReadOnly = System.Convert.ToBoolean(row("IsReadOnly"))
col.DataType = Type.GetType(row("DataType").ToString)
table.Columns.Add(col)
Next
While DataReader.Read
row = table.NewRow
Dim col As DataColumn
For Each col In table.Columns
row(col) = DataReader(col.ColumnName)
Next
table.Rows.Add(row)
End While
Return table
Please let me know if this helped you.
|
|
|
|
|
You might also want to download this project and look at it. It has a class that might do what you are looking for.
http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=352&lngWId=10\
|
|
|
|
|
You might also want to download this project and look at it. It has a class that might do what you are looking for.
http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=352&lngWId=10\
|
|
|
|
|
Thanks for all your help. I ended up doing this:
Public Shared Function LoadSearchResults(ByVal whereClause As String) As DataTable
Dim table As DataTable = New DataTable()
table.Columns.Add(New DataColumn("SSN"))
table.Columns.Add(New DataColumn("REFERRED"))
table.Columns.Add(New DataColumn("COMMENTS"))
table.Columns.Add(New DataColumn("ADDITIONAL1"))
table.Columns.Add(New DataColumn("ADDITIONAL2"))
table.Columns.Add(New DataColumn("ADDITIONAL3"))
Dim dr As OleDbDataReader
Dim da As OleDbDataAdapter = New OleDbDataAdapter()
Dim Cmd As New OleDbCommand()
Try
Cmd.Connection = dbConnection
Cmd.CommandType = CommandType.StoredProcedure
Cmd.CommandText = "qrySearchResult"
Cmd.Parameters.Add(Cmd.CreateParameter())
Cmd.Parameters(0).Value = whereClause
dbConnection.Open()
dr = Cmd.ExecuteReader()
Dim i As Int16
While dr.Read
Dim ar As ArrayList = New ArrayList()
For i = 0 To dr.FieldCount - 1
ar.Add(dr(i))
Next
Dim row As DataRow = table.NewRow()
row.ItemArray = ar.ToArray
table.Rows.Add(row)
End While
dbConnection.Close()
Return table
End Function
and It works fine except that MS Access ignores the where clause and returns all records. Do y ou know what I should do so that the query returs according to the where clause. below it the access query.
SELECT SSN, REFERRED, COMMENTS, Additional1, Additional2, Additional3
FROM MAIN
WHERE @WhereCluase;
|
|
|
|
|
I have a combo box in my form that take values from the other table in the database on form load.
On the Click Property of the Save Button i have put the code to clear the values of all text boxes and Combo Box after saving the data.
I used the following code to clear the combo box:
cboname.listindex = -1
The style of the combo box is set to 2-dropdown.
The data is saved to the database correctly but after that while clearing the text in the combo box it gives the Run Time Error No. 381 i.e. Invalid Property Array Index.
Can any body please tell me that what code should i do to clear those values in the combo box???
|
|
|
|
|
Hi Ali
Firt of all what are you working with windows forms or webforms.
in webforms we have dropdownlist which works similar to combobox to clear a dropdownlist or a combobox on a windows forms tryusing
cboname.items.Clear
Mandar Patankar
Microsoft Certified professional
|
|
|
|
|
I am working on VB 6 Forms. I think we will call them window forms. I dont know but also plz tell me that what should we call them?
Well i have tried the code u told me but its also not working.
it doesnt have that property of Items.
it gives the error of Data Method not found.
|
|
|
|