|
Without some component to load, parse and render the document, you can't send a PDF to the printer. It'll just print tons a garbage.
TallComponents[^] has a couple of things that might work for you.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
|
See here[^] maybe it is some helpful to you
|
|
|
|
|
Hello,
I am using the .Net 2003
I am using the SQL Server 2000
I am using the OleDb Connection Object
I am using the ExecuteNonQuery Method
While Inserting the records Multiple times under transaction control I am getting this Error:
System.Data.OleDb.OleDbException: Connection is busy with results for another commandat System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
Please Give the soultion for this.
Nagarajan R.J.
|
|
|
|
|
Without seeing the code that's generating this error, it's impossible to tell you what you did wrong. Though, I get the feeling that you're trying to use a DataReader object for something it's not designed for.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
The code for this as follows
Dim cmdGeneral As OleDb.OleDbCommand
Private Function funInsertRecord(ByRef cnn As OleDb.OleDbConnection, ByRef trans As OleDb.OleDbTransaction) As Boolean
Try
Dim intRowIndex As Integer
Dim intResultCount As Integer
For intRowIndex = 0 To 100
Dim strSQL As String = " INSERT INTO EMPLOYEES(FirstName,LastName) VALUES('RAJ','KUMAR') "
cmdGeneral = New OleDb.OleDbCommand(strSQL, cnn, trans)
intResultCount = cmdGeneral.ExecuteNonQuery()
If intResultCount = 0 Then
funInsertRecord = False
Exit Function
End If
Next intRowIndex
funInsertRecord = True
Catch ex As Exception
funInsertRecord = False
End Try
End Function
Nagarajan R.J.
|
|
|
|
|
Well, there are multiple causes for this, including a bug in SQL Server 2000.
What is going on before you call this sub? Do you have a DataReader open on this same connection? Are you trying to work on multiple result sets at the same time, on the same connection?
MSKB Article[^]
Yahoo Results for error[^]
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I'm using the Microsoft report to print customer information. I made a setup screen that allows the user to define date ranges to run the report for. Then they click print to run the report. How can I pass the date range information they have chosen to the report so that it prints at the top of every page.
|
|
|
|
|
I wonder if anyone can help me.
I am trying to display my network domain name and IP address of a PC. I have Visual Studio 2003 and running on Windows 2003 server. I am running .Net Framework 1.1
There is a new object isn .NET Framework version 2.0 that is
Imports System.Net.NetworkInformation which runs
Dim ipproperties As IPGlobalProperties = IPGlobalProperties.GetIPGlobalProperties()
But with .Net Framework 1.1 does not.
Couple of questions
1. Do I install .Net Framework 2.0 on the user PC etc remembering that I have VS 2003
2. How was this done with version 1.1 and VS 2003
|
|
|
|
|
directred wrote: 1. Do I install .Net Framework 2.0 on the user PC etc remembering that I have VS 2003
You could, but your application will not use any of the .NET 2.0 classes. You're restricted to using only .NET 1.0 and 1.1 classes if you compile under .NET 1.1.
If you're talking about getting the DNS domain name, you can get the fully qualified DNS name of the local machine using the System.Net.Dns class as it's GetHostName() method. You can then parse the string to get everything after the first period to get the domain name.
If you're talking about getting the Windows domain name, you can get the domain of the currently logged in user from the System.Environment class and it's .UserDomainName property.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hi,
i have to read each data from a dataset
and check each value in an IF Condition
can u help me
thanks in advance
|
|
|
|
|
A DataSet is nothing more than a collection of DataTable objects, which are collections of DataRow and DataColumn objects.
As with any collection, you can enumerate them this way:
For Each dt As DataTable In myDataSet
Console.WriteLine("Table name: " & dt.Name)
For Each dr As DataRow In dt
Console.WriteLine(" Row field value: " & dr("tableFieldName") )
Next
Next
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks .
it helped me verymuch
|
|
|
|
|
Hi,
Hi frndz. please any body can give FAqs information for me. I urgently need them
NareshT
|
|
|
|
|
FAQ's on what?
You do realise the FAQ stands for Frequently Asked Questions don't you? Hence, there can be an FAQ on anything from .NET all the way through to the Art of Fly Swatting. Please be more specific.
|
|
|
|
|
I"m sorry, your question makes no sense. Why do you urgently need them ? What do you expect 'them' to be ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
|
I have a datagrid with 4 columns and i want that only 1 column can be "EDITABLE" whereas the remaining 3 cann't be editable.
|
|
|
|
|
Set the other columns to 'ReadOnly'.
Steve
|
|
|
|
|
Or set the visible of the columns to false.
|
|
|
|
|
Hii All
How can i count the dulplicate values stored in the particular column of the table in database, through windows application.
For e.g. If incase i want to display no. of books with same title from the title column in the text box.
In the window form named multiple books which has a datagrid connected to the book entry database should display only the records which are multiple. And as datagrid row is clicked the information of no. of books available should be displayed in the textbox on same form.
Suppose there are five books on Title (Gone with the winds) the datagrid will display the book details in one row as one book. And as user clicks the particular row the textbox1.text should display the no. 5 .
Please try to solute
Thanks
Nikhil Bandekar
Mumbai,
India
|
|
|
|
|
hi
try to excute this query :
SELECT Count(*) AS boos_count, book_title
FROM books_table
GROUP BY books_table.book_title
Tamimi - Code
|
|
|
|
|
<b>Hai!
I struck up badly in displaying group header even though dont have records in detal section (Using Crystal Reports 8.5).
Actually, I've a ProductId Group header in which i'm showing opening balances.
In detail section I'm showing the detail records of that productid which is in group header.
It's working when I've detail recrods to show. But its not showing the even the group header which contains opening balances when there is no records in detail section to show.
pls pls pls give any suggetion or recmondations
thanking you lt;/b>
M. YASEEN
Software Engineer
MN Textiles
Karachi
|
|
|
|
|
Hi,
Use This query in The Add Command Instead of adding Tables
SELECT *
FROM PdMaster Left Outer JOIN
Pdetails ON PdMaster.PId = Pdetails.Pid
Thanks and Regards
Anu
|
|
|
|
|
Hi,
i want to merge 2 cells in excel when i am Exporting data from datagrid to cells. how can i do that .please send me a reply.
i am using code like this to export data
Dim XlApp As Excel.Application
Dim XlBk As Excel.Workbook
Dim XlSht As Excel.Worksheet
Dim r As Excel.Range
XlApp = CreateObject("Excel.Application")
XlBk = XlApp.Workbooks.Add
XlSht = XlBk.Worksheets(1)
XlApp.Visible = True
XlApp.Cells(1, 2).Font.Name = "Arial"
XlApp.Cells(1,2).Font.Bold = True
XlApp.Cells(1, 2).Font.Size = 9
XlApp.Cells(1, 2).value = "Mode Of Shipment"
r = XlApp.Cells(1, 2)
r.ColumnWidth = "Mode Of Shipment".ToString.Length * 1.5
XlApp.Cells(2, 2).Font.Name = "Arial"
XlApp.Cells(2, 2).Font.Bold = False
XlApp.Cells(2, 2).Font.Size = 9
XlApp.Cells(2, 2).value = DtGenReport.Rows(0)("Item").
if the heading is large i want to merge 2 cells.
Thanks and Rgards
Anu
|
|
|
|