Visual Basic Discussion Boards

First Prev Next

Re: having a inner table in a dataset

Dave Kreskowiak30-Jul-07 9:06

Dave Kreskowiak

30-Jul-07 9:06

You'll have to write the code to serialize this yourself. The standard serializer will treat each table seperatly and not embed the data from one table into the rows of the other.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

webbrowser control

Ahmad Zaidi30-Jul-07 1:54

Ahmad Zaidi

30-Jul-07 1:54

Hi,

I have two questions:
a) How can you prevent an MDI parent form from displaying scroll bars?
b) I am using a webbrowser control which is supposed to carry out a few actions once the document has been loaded and displayed. I am writing the code in the Document_Completed event but to my surprise, it carries it out before the document has been displayed (I am actually trying to take a screenshot of the loaded page, and it ends up taking it before it has completly loaded :S). Any Ideas?

Thanks,
Ahmad

Re: webbrowser control

Dave Kreskowiak30-Jul-07 9:04

Dave Kreskowiak

30-Jul-07 9:04

Ahmad Zaidi wrote:
a) How can you prevent an MDI parent form from displaying scroll bars?

You can't. The scroll bars will appear any time a child window extends beyond the border of the MDIParent's MdiChild control. There is no way to turn them off.

Ahmad Zaidi wrote:
b) I am using a webbrowser control which is supposed to carry out a few actions once the document has been loaded and displayed. I am writing the code in the Document_Completed event but to my surprise, it carries it out before the document has been displayed (I am actually trying to take a screenshot of the loaded page, and it ends up taking it before it has completly loaded :S). Any Ideas?

The WebBrowserDocumentCompleted event will fire for each and every document that is loaded by the page. Most sites are made up of multiple documents, not just one, because of Frames. Say you have a document with 3 frames, a top site title, navigation on the left, and a content frame taking up the rest. You'll get the Document Completed event fired at least(!) 4 times. Once for the page that defines all three frames, and once for each frame in that page.

Take a look at the URL property of the WebBrowserDocumentCompletedEventArgs for which page that event is being fired for.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: webbrowser control

Ahmad Zaidi30-Jul-07 22:04

Ahmad Zaidi

30-Jul-07 22:04

Thanks!

how to update the dataset programically to database in vb.net

ajith prasath30-Jul-07 1:53

ajith prasath

30-Jul-07 1:53

hi everyone

i have given the table mappings for my dataset and database table.

i needed the query for the 4 insert,delete,update and select commands
of the dataadapter.

eg) take a table employee_hobbies haveing emp_code and emp_hobbies as coloumns

i think we should use some rowstateversion.original and current

please give me the query

Re: how to update the dataset programically to database in vb.net

DanB198330-Jul-07 9:54

DanB1983

30-Jul-07 9:54

Seriously - learning to help your self know will save loads of time in the future - just google this it is simple:

As I am in a good mood here is a good start

http://www.w3schools.com/sql/default.asp

but try working things out for yourself otherwise you wont get this off the ground.

Dan

slider on ruler control [modified]

eyes200730-Jul-07 1:11

eyes2007

30-Jul-07 1:11

hi all

i need to use the ruler control as it in word

i use it to set the page margin

but i don't know how to make the slider on the ruler control and how to use it some one help me plz

bye

how to print the contents of rich text box

eyes200730-Jul-07 1:09

eyes2007

30-Jul-07 1:09

hi all

i need to print the contents of rich text box

what can i do it

thnx

Re: how to print the contents of rich text box

Dave Kreskowiak30-Jul-07 8:59

Dave Kreskowiak

30-Jul-07 8:59

Google results for "vb.net print richtextbox[^]".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

vb.net 1.1 DataGrid

A.Surendar Reddy29-Jul-07 23:03

A.Surendar Reddy

29-Jul-07 23:03

How to set coloum size/width in Datagrid (Desktop Application)

A.Sutendar Reddy
asreddynet@yahoo.co.in

Re: vb.net 1.1 DataGrid

cutequencher29-Jul-07 23:17

cutequencher

29-Jul-07 23:17

by using the datagrid property "column.width"

Re: vb.net 1.1 DataGrid

A.Surendar Reddy31-Jul-07 1:00

A.Surendar Reddy

31-Jul-07 1:00

Pl. Can you send that code for disktop Application

Re: vb.net 1.1 DataGrid

Tamimi - Code30-Jul-07 1:05

Tamimi - Code

30-Jul-07 1:05

http://www.google.com/search?hl=en&q=format+datagrid+vb.net+

When you get mad...THINK twice that the only advice
Tamimi - Code

subreport and record number in crystal report. vb.net 2002. crystal report 8

cutequencher29-Jul-07 22:36

cutequencher

29-Jul-07 22:36

can someone please help me about subreport...
i didnt know if it is possible -- i am thinking of creating a subreport which is accepting parameters from the main report.

ifnot-- can you just guve me a tutorial on using subreports.

another one is how could i use the "record number" that is resetting every page..
this what happens. i have a report contains lot of pages... if the first page has the number 1-8, then the other page will start on 9 and so on... which should start with 1.

thanx!

What is wrong with this Following ADO.net code

Vimalsoft(Pty) Ltd29-Jul-07 22:34

Vimalsoft(Pty) Ltd

29-Jul-07 22:34

i have the Following code, it game an Error when i tried to run it without trapping the Error. now i used an error trap and the message i get from it now is

Line1 Incorect Syntax Near ')'

Please Help me to point the exact line where it occured. Heere is my code i have in my form load thanks.

Dim strErrorMsg As String<br />
        Dim strerror As System.Data.SqlClient.SqlError<br />
<br />
        Dim strconnection As String = "packet size=4096;user id=#######; Password=#########;data source=#######;persist security info=False;initial catalog=Tshwane_Valuations"<br />
        Dim cn As SqlConnection = New SqlConnection(strconnection)<br />
        cn.Open()<br />
<br />
        'set up the data soruce <br />
        Dim strSql As String = _<br />
"select Actual_Extent,Attrib_code,Lis_key,Func_key,Density," _<br />
& "New_Net_Usable_Extent,New_Total_Land_Factor,New_AdJ_Extent_1, New_Points_1, " _<br />
& "New_ADJ_Extent_2, New_Points_2, LS_Prediction, LS_Confidence from Property_Mass "<br />
        Dim da As SqlDataAdapter = New SqlDataAdapter(strSql, cn)<br />
<br />
        'load a Dataset <br />
        Dim ds As DataSet = New DataSet<br />
        da.Fill(ds, "Property_mass")<br />
<br />
        'set up a new data adapter object <br />
        strSql = _<br />
        "select Property_Mass.Actual_Extent,Property_Mass.Attrib_code,Property_Mass.Lis_key,Property_Mass.Func_key,Property_Mass.Density," _<br />
       & "Property_Mass.New_Net_Usable_Extent,Property_Mass.New_Total_Land_Factor, Property_Mass.New_AdJ_Extent_1, Property_Mass.New_Points_1," _<br />
       & "Property_Mass.New_ADJ_Extent_2, Property_Mass.New_Points_2, Property_Mass.LS_Prediction, Property_Mass.LS_Confidence, Property_Mass.LS_TYPE," _<br />
       & "Property_Summary.Purchase_Date, Property_Summary.Purchase_Price)" _<br />
        & "from(Property_Mass, Property_Summary)" _<br />
        & " where Property_Mass.Lis_key = Property_Summary.Lis_key"<br />
        da = New SqlDataAdapter(strSql, cn)<br />
<br />
        'load the Data set<br />
        Try<br />
            da.Fill(ds, "Property_Summary")<br />
            'Close the Connection<br />
            cn.Close()<br />
<br />
            'Create relations <br />
            ds.Relations.Add("Property_summary_Mass", _<br />
            ds.Tables("Property_Mass").Columns("Lis_key"), _<br />
            ds.Tables("Property_Summary").Columns("Lis_key"))<br />
<br />
            'Bind the data set to the grid.<br />
            'Assumes that Grid contains a reference to a <br />
            'system.windows.datagrid<br />
        DataGrid2.SetDataBinding(ds, "Property_Mass")<br />
        Catch ExSQL As System.Data.SqlClient.SqlException<br />
            '''All this will trap all data Problems and Network if available<br />
            For Each strerror In ExSQL.Errors<br />
            Next<br />
            Select Case strerror.Number<br />
                Case 17<br />
                    strErrorMsg = "Missing server"<br />
                Case 4060<br />
                    strErrorMsg = "Missing database"<br />
                Case 18456<br />
                    strErrorMsg = "Missing user name or password"<br />
                Case Else<br />
                    strErrorMsg = strerror.Message<br />
            End Select<br />
            MessageBox.Show(strErrorMsg, "SQL Server Error: " & strerror.Number, MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
<br />
        Catch ExcpInvOp As System.InvalidOperationException<br />
<br />
            MessageBox.Show("Close the connection first!", "Invalid Operation", MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
<br />
        Catch Excp As System.Exception ' generic exception handler<br />
<br />
            MessageBox.Show(Excp.Message, "Unexpected Exception", MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
        End Try<br />
    End Sub<br />
<br />

NOTE: The username, password, and my server are corrrect i have hid them for security purpose. Thanks

Vuyiswa Maseko

Re: What is wrong with this Following ADO.net code

Vimalsoft(Pty) Ltd29-Jul-07 22:54

Vimalsoft(Pty) Ltd

29-Jul-07 22:54

i have seen some few stupid mistakes i have done, and i fixed it to this

<br />
 Dim strErrorMsg As String<br />
        Dim strerror As System.Data.SqlClient.SqlError<br />
<br />
        Dim strconnection As String = "workstation id=5875-049;packet size=4096;user id=sde; Password=#####;data source=#######;persist security info=False;initial catalog=Tshwane_Valuations"<br />
        Dim cn As SqlConnection = New SqlConnection(strconnection)<br />
        cn.Open()<br />
        'set up the data soruce <br />
        Dim strSql As String = _<br />
"select Actual_Extent,Attrib_code,Lis_key,Func_key,Density," _<br />
& "New_Net_Usable_Extent,New_Total_Land_Factor,New_AdJ_Extent_1,New_Points_1," _<br />
& "New_ADJ_Extent_2, New_Points_2, LS_Prediction, LS_Confidence from Property_Mass "<br />
        Dim da As SqlDataAdapter = New SqlDataAdapter(strSql, cn)<br />
<br />
        'load a Dataset <br />
        Dim ds As DataSet = New DataSet<br />
        da.Fill(ds, "Property_mass")<br />
<br />
        'set up a new data adapter object <br />
        strSql = _<br />
        "select Property_Mass.Actual_Extent,Property_Mass.Attrib_code,Property_Mass.Lis_key,Property_Mass.Func_key,Property_Mass.Density," _<br />
       & "Property_Mass.New_Net_Usable_Extent,Property_Mass.New_Total_Land_Factor, Property_Mass.New_AdJ_Extent_1, Property_Mass.New_Points_1," _<br />
       & "Property_Mass.New_ADJ_Extent_2, Property_Mass.New_Points_2, Property_Mass.LS_Prediction, Property_Mass.LS_Confidence, Property_Mass.LS_TYPE," _<br />
       & "Property_Summary.Purchase_Date, Property_Summary.Purchase_Price" _<br />
        & "from Property_Mass, Property_Summary" _<br />
        & " where Property_Mass.Lis_key = Property_Summary.Lis_key"<br />
        da = New SqlDataAdapter(strSql, cn)<br />
<br />
        'load the Data set<br />
        Try<br />
            da.Fill(ds, "Property_Summary")<br />
            'Close the Connection<br />
            cn.Close()<br />
<br />
            'Create relations <br />
            ds.Relations.Add("Property_summary_Mass", _<br />
            ds.Tables("Property_Mass").Columns("Lis_key"), _<br />
            ds.Tables("Property_Summary").Columns("Lis_key"))<br />
<br />
            'Bind the data set to the grid.<br />
            'Assumes that Grid contains a reference to a <br />
            'system.windows.datagrid<br />
        DataGrid2.SetDataBinding(ds, "Property_Mass")<br />
        Catch ExSQL As System.Data.SqlClient.SqlException<br />
            '''All this will trap all data Problems and Network if available<br />
            For Each strerror In ExSQL.Errors<br />
            Next<br />
            Select Case strerror.Number<br />
                Case 17<br />
                    strErrorMsg = "Missing server"<br />
                Case 4060<br />
                    strErrorMsg = "Missing database"<br />
                Case 18456<br />
                    strErrorMsg = "Missing user name or password"<br />
                Case Else<br />
                    strErrorMsg = strerror.Message<br />
            End Select<br />
            MessageBox.Show(strErrorMsg, "SQL Server Error: " & strerror.Number, MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
<br />
        Catch ExcpInvOp As System.InvalidOperationException<br />
<br />
            MessageBox.Show("Close the connection first!", "Invalid Operation", MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
<br />
        Catch Excp As System.Exception ' generic exception handler<br />
<br />
            MessageBox.Show(Excp.Message, "Unexpected Exception", MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
        End Try<br />
    End Sub<br />

but i still have one different Error, it says

Column Prefix 'Property_Summary' does not match with a table name or alias name used in this query.

Thanks

Vuyiswa Maseko

Re: What is wrong with this Following ADO.net code

Vimalsoft(Pty) Ltd29-Jul-07 23:21

Vimalsoft(Pty) Ltd

29-Jul-07 23:21

The Problem was so small, it was the Spaces provided in strSQl,

<br />
Dim strErrorMsg As String<br />
        Dim strerror As System.Data.SqlClient.SqlError<br />
<br />
        Dim strconnection As String = "workstation id=5875-049;packet size=4096;user id=sde;Password=topology;data source=SGIICORNETGS01;persist security info=False;initial catalog=Tshwane_Valuations"<br />
        Dim cn As SqlConnection = New SqlConnection(strconnection)<br />
        cn.Open()<br />
        'set up the data soruce <br />
        Dim strSql As String = _<br />
"select Actual_Extent,Attrib_code,Lis_key,Func_key,Density," _<br />
& "New_Net_Usable_Extent,New_Total_Land_Factor,New_AdJ_Extent_1,New_Points_1," _<br />
& "New_ADJ_Extent_2, New_Points_2, LS_Prediction, LS_Confidence from Property_Mass "<br />
        Dim da As SqlDataAdapter = New SqlDataAdapter(strSql, cn)<br />
<br />
        'load a Dataset <br />
        Dim ds As DataSet = New DataSet<br />
        da.Fill(ds, "Property_mass")<br />
<br />
        'set up a new data adapter object <br />
        strSql = _<br />
        "select Property_Mass.Actual_Extent,Property_Mass.Attrib_code,Property_Mass.Lis_key,Property_Mass.Func_key,Property_Mass.Density," _<br />
       & " Property_Mass.New_Net_Usable_Extent,Property_Mass.New_Total_Land_Factor,Property_Mass.New_AdJ_Extent_1, Property_Mass.New_Points_1," _<br />
       & " Property_Mass.New_ADJ_Extent_2, Property_Mass.New_Points_2, Property_Mass.LS_Prediction, Property_Mass.LS_Confidence, Property_Mass.LS_TYPE," _<br />
       & " Property_Summary.Purchase_Date, Property_Summary.Purchase_Price" _<br />
        & " from Property_Mass, Property_Summary" _<br />
        & " where Property_Mass.Lis_key = Property_Summary.Lis_key"<br />
        da = New SqlDataAdapter(strSql, cn)<br />
<br />
        'load the Data set<br />
        Try<br />
            da.Fill(ds, "Property_Summary")<br />
            'Close the Connection<br />
            cn.Close()<br />
<br />
            'Create relations <br />
            ds.Relations.Add("Property_summary_Mass", _<br />
            ds.Tables("Property_Mass").Columns("Lis_key"), _<br />
            ds.Tables("Property_Summary").Columns("Lis_key"))<br />
<br />
            'Bind the data set to the grid.<br />
            'Assumes that Grid contains a reference to a <br />
            'system.windows.datagrid<br />
        DataGrid2.SetDataBinding(ds, "Property_Mass")<br />
        Catch ExSQL As System.Data.SqlClient.SqlException<br />
            '''All this will trap all data Problems and Network if available<br />
            For Each strerror In ExSQL.Errors<br />
            Next<br />
            Select Case strerror.Number<br />
                Case 17<br />
                    strErrorMsg = "Missing server"<br />
                Case 4060<br />
                    strErrorMsg = "Missing database"<br />
                Case 18456<br />
                    strErrorMsg = "Missing user name or password"<br />
                Case Else<br />
                    strErrorMsg = strerror.Message<br />
            End Select<br />
            MessageBox.Show(strErrorMsg, "SQL Server Error: " & strerror.Number, MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
<br />
        Catch ExcpInvOp As System.InvalidOperationException<br />
<br />
            MessageBox.Show("Close the connection first!", "Invalid Operation", MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
<br />
        Catch Excp As System.Exception ' generic exception handler<br />
<br />
            MessageBox.Show(Excp.Message, "Unexpected Exception", MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
        End Try<br />

Thanks, i think i solved my Problem myself, if you have any suggestion about my code please comment, thanks

Vuyiswa Maseko

Re: What is wrong with this Following ADO.net code

Luc Pattyn30-Jul-07 0:11

Luc Pattyn

30-Jul-07 0:11

Hi,

it is very nice of you to show an error message in PRE tags. Good.

It would be even better if you would also show your actual code in PRE tags
(instead of CODE tags); that way it would show with indentation and be much more
readable.

Doesnt your compiler give you the line numbers when it reports errors ? If your
IDE (Visual?) does not show line numbers by default in the left margin, you can
easily turn that on (Visual: Tools/Options/TextEditor/AllLanguages/DisplayLineNumbers)

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: What is wrong with this Following ADO.net code [modified]

Vimalsoft(Pty) Ltd30-Jul-07 0:24

Vimalsoft(Pty) Ltd

30-Jul-07 0:24

Hi Luc

Thanks for your comment, i will certainly show my code in a PRE tags.
about the line number i have turn it on thanks man

thank you

-- modified at 9:42 Monday 30th July, 2007

Vuyiswa Maseko

Download Manager

j5136p129-Jul-07 21:47

j5136p1

29-Jul-07 21:47

Hello,

i try to create an application that listen for download Files with a special extension.
When a user click on a Link the program must decide to download the file with default settings (e.g. Standard Firefox) or use it's own.

Can someone help me??

Thank you

Mirko Olsiewicz

Re: Download Manager

Dave Kreskowiak30-Jul-07 1:46

Dave Kreskowiak

30-Jul-07 1:46

You'd either be writing a web browser extension, in your case FireFox I assume, or a proxy server.

In either case, you're looking for the type and filename of the file being returned by the server.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Download Manager

j5136p130-Jul-07 1:54

j5136p1

30-Jul-07 1:54

Ok,

i saw something on Microsoft Homepage with activX. Will it work when i create an ativeX Control? Otherwise we build a Wrapper Class. The user then must run the exe File after download.

Thank you for help

Mirko Olsiewicz

Re: Download Manager

Dave Kreskowiak30-Jul-07 3:59

Dave Kreskowiak

30-Jul-07 3:59

I believe it's Microsoft's Download Manager that makes the request to download the file. It doesn't monitor the request/responses to see which ones it should be watching for. The code in the page specifically uses the MS Download Manager to download the files.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Control which object getobject() grabs

MadmanWoo29-Jul-07 21:00

MadmanWoo

29-Jul-07 21:00

Hi All,

I was wondering if its possible for me to control which object the function GetObject() grabs.

I have multiple copies of the same program running and I would like to be able to get an OLE object from each one. I have search all over the net but can't seem to find anyone that has done this. The only thing I can find is that GetObject only returns the last instance created.

Can I use the Getobject() function to do what I am looking for or is there a different method of doing this.

Thanks
Nathan

Re: Control which object getobject() grabs

Dave Kreskowiak30-Jul-07 1:45

Dave Kreskowiak

30-Jul-07 1:45

MadmanWoo wrote:
I was wondering if its possible for me to control which object the function GetObject() grabs.

No. It'll grab the first instance it finds. You have no control over which one that is.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Last Visit: 31-Dec-99 18:00 Last Update: 20-May-24 7:16

Refresh

ᐊ Prev 1...2291 2292 2293 229422952296 2297 2298 2299 2300 Next ᐅ

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