Visual Basic Discussion Boards

Dave Kreskowiak14-Sep-06 9:19

14-Sep-06 9:19

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

Re: Sending PDF to printer

Stephen McGuire14-Sep-06 10:24

Stephen McGuire

14-Sep-06 10:24

This may help you out:

http://www.codeproject.com/showcase/pdfrasterizer.asp[^]

Steve

Re: Sending PDF to printer

Hamid_RT15-Sep-06 7:57

Hamid_RT

15-Sep-06 7:57

See here[^] maybe it is some helpful to you

WhiteSky

While Inserting Records Multiple times under Transaction Objects getting Error Message -Connection is busy with results for another command

Nagarajan R.J14-Sep-06 4:29

Nagarajan R.J

14-Sep-06 4:29

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.

Re: While Inserting Records Multiple times under Transaction Objects getting Error Message -Connection is busy with results for another command

Dave Kreskowiak14-Sep-06 9:00

Dave Kreskowiak

14-Sep-06 9:00

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

Re: While Inserting Records Multiple times under Transaction Objects getting Error Message -Connection is busy with results for another command

Nagarajan R.J14-Sep-06 19:33

Nagarajan R.J

14-Sep-06 19:33

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.

Re: While Inserting Records Multiple times under Transaction Objects getting Error Message -Connection is busy with results for another command

Dave Kreskowiak15-Sep-06 3:26

Dave Kreskowiak

15-Sep-06 3:26

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

Pass data to a report

dptalt14-Sep-06 4:04

dptalt

14-Sep-06 4:04

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.

How do I display a Domain Name and IP Address

directred14-Sep-06 4:02

directred

14-Sep-06 4:02

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

Re: How do I display a Domain Name and IP Address

Dave Kreskowiak14-Sep-06 8:58

Dave Kreskowiak

14-Sep-06 8:58

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

How to read each item from a dataset

viji]14-Sep-06 2:46

viji]

14-Sep-06 2:46

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

Re: How to read each item from a dataset

Dave Kreskowiak14-Sep-06 8:50

Dave Kreskowiak

14-Sep-06 8:50

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

Re: How to read each item from a dataset

viji]17-Sep-06 19:56

viji]

17-Sep-06 19:56

Thanks .
it helped me verymuch

FAQs plz

Naresh111514-Sep-06 1:17

Naresh1115

14-Sep-06 1:17

Hi,

Hi frndz. please any body can give FAqs information for me. I urgently need them

NareshT

Re: FAQs plz

Dave Sexton14-Sep-06 4:51

Dave Sexton

14-Sep-06 4:51

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.

Re: FAQs plz

Christian Graus14-Sep-06 16:04

Christian Graus

14-Sep-06 16:04

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

Re: FAQs plz

Hamid_RT15-Sep-06 7:58

Hamid_RT

15-Sep-06 7:58

Can you be more specific

WhiteSky

how to enable only a single column of datagrid

Gagan G13-Sep-06 22:49

Gagan G

13-Sep-06 22:49

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.

Re: how to enable only a single column of datagrid

Stephen McGuire14-Sep-06 1:26

Stephen McGuire

14-Sep-06 1:26

Set the other columns to 'ReadOnly'.

Steve

Re: how to enable only a single column of datagrid

dptalt14-Sep-06 5:45

dptalt

14-Sep-06 5:45

Or set the visible of the columns to false.

Count the duplicate values stored in the database

Nikhil Bandekar13-Sep-06 22:45

Nikhil Bandekar

13-Sep-06 22:45

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

Re: Count the duplicate values stored in the database

Tamimi - Code13-Sep-06 23:08

Tamimi - Code

13-Sep-06 23:08

hi
try to excute this query :

SELECT Count(*) AS boos_count, book_title
FROM books_table
GROUP BY books_table.book_title

Tamimi - Code

HOW TO DISPLAY GROUP HEADER EVEN DONT HAVE RECORDS IN DETAIL SECTION

KhadijaYaseen13-Sep-06 21:32

KhadijaYaseen

13-Sep-06 21:32

<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 Frown | :(

lt;/b>

M. YASEEN
Software Engineer
MN Textiles
Karachi

Re: HOW TO DISPLAY GROUP HEADER EVEN DONT HAVE RECORDS IN DETAIL SECTION

anujose13-Sep-06 23:53

anujose

13-Sep-06 23:53

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

Merging cells in Excel using vb.net code

anujose13-Sep-06 18:48

anujose

13-Sep-06 18:48

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.