Visual Basic

Vimalsoft(Pty) Ltd31-Aug-07 5:27

31-Aug-07 5:27

hi

Use Orderby in your SQl statement.

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com

Smokeywade31-Aug-07 7:16

Smokeywade

31-Aug-07 7:16

How will I do that? - this is my code below - the Sql statement will order by a column in the table - in my situation I have a column that is not part of the table it was created dynamically - below is my code

Dim command1 As New SqlCommand("Select * FROM LateOrders_query_view order by requested_date desc", cnn1)
Dim SqlReader As SqlDataReader

cnn1.Open()<br />
<br />
                        Dim dt As New DataTable("LateOrders_query_view")<br />
                        Dim DirAdapter As New SqlDataAdapter(command1)<br />
            DirAdapter.Fill(MyDataSet, "LateOrders_query_view")<br />
<br />
            dgOrderReport.DataSource = MyDataSet.Tables("LateOrders_query_view").DefaultView<br />
<br />
'Create Dynamic Columns call related function<br />
            Dim dc As DataColumn<br />
            dc = New DataColumn("Days Open") ', Type.GetType("System.double"))<br />
            MyDataSet.Tables(0).Columns.Add(dc)<br />
            fncGetOpenDays()<br />
<br />
            Dim dc2 As DataColumn<br />
            dc2 = New DataColumn("Days Late")<br />
            MyDataSet.Tables(0).Columns.Add(dc2)<br />
            fncGetDays()

Is there away for me to sort by a dynamic column (the dynamic column is not part of my table in the database)

Thank You

Smokeywade31-Aug-07 9:23

Smokeywade

31-Aug-07 9:23

I figured how to make it sort - its pretty simple here is the code

Dim dc2 As DataColumn<br />
            dc2 = New DataColumn("Days Late")<br />
            With dc2<br />
                .AutoIncrement = True<br />
                .AutoIncrementSeed = 1<br />
                .AutoIncrementStep = 1<br />
             End With

Now I just need to get it to do this on load not when I click on that column...
Help will be appreciated. Thanks

Thank You

Vimalsoft(Pty) Ltd2-Sep-07 20:53

moving text from one RTB to another RTB

2-Sep-07 20:53

hi KA National Marker
am sorry i could not reply, it was friday, i dont access the net on weekends. i do that when am at my workplace. am glad you find your answer.

i know you are smart after all

Smile | :)

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com

BooleanTrue31-Aug-07 2:39

BooleanTrue

31-Aug-07 2:39

Hello!
I have two rich text boxes RTB1 and RTB2.
I have text with different fonts,colors and styles in RTB1 and RTB2 is empty.
when i use this code:
RTB2.text = RTB1.text
RTB2 displays the text but with its default font and color.
How can i keep the fonts and styles used in source text box to the destination textbox.

Thanks for Any help!

colgateas900197

Tom Deketelaere31-Aug-07 2:58

Tom Deketelaere

31-Aug-07 2:58

use the copy and paste methodes:

RichTextBox1.SelectAll()
        RichTextBox1.Copy()
        RichTextBox1.DeselectAll()
        RichTextBox2.Paste()

tested it with bold text and works

hope this helps

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

BooleanTrue31-Aug-07 3:16

BooleanTrue

31-Aug-07 3:16

Thanks! It works....
It work for different colors and fonts as well.
Thanks again!

colgateas900197

Rupesh Kumar Swami31-Aug-07 3:12

Rupesh Kumar Swami

31-Aug-07 3:12

hi,
use following code
rtb2.rtf = rtb1.rtf
hope this helps

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

My Company

BooleanTrue31-Aug-07 3:22

BooleanTrue

31-Aug-07 3:22

thank you Rupesh!
it works...
i have used (as suggested by TDDragon)
RTB1.SellectAll()
RTB1.copy()
RTB1.deselectAll()
RTB2.Paste()

It also works!
Could you please tell me what is the difference? What are limitations? These are same or one has advantage over other?

colgateas900197

Johan Hakkesteegt1-Sep-07 6:58

Johan Hakkesteegt

1-Sep-07 6:58

Rupesh Kumar Swami... wrote:
rtb2.rtf = rtb1.rtf

is a single line of code.

SoInnocentIAm... wrote:

RTB1.SellectAll()<br />
RTB1.copy()<br />
RTB1.deselectAll()<br />
RTB2.Paste()

is four lines of code.

Although for all intents and purposes there is no difference, RPS's solution is meant to do do what you wanted, while TDDragon's suggestion does what you wanted as a side effect.
I would recommend using RPS's code, simply because keeping your code as small as possible is always preferable.

My advice is free, and you may get what you paid for.

Print DataGrid

Xerox431-Aug-07 1:59

Xerox4

31-Aug-07 1:59

Hi, Am new to Dot net. I would like to print the data in the data grid in a VB.NET application.

Anyway to go round this?

All effort put is highly appreciated.

Duncan Edwards Jones31-Aug-07 2:04

Duncan Edwards Jones

31-Aug-07 2:04

Here's one article about just that[^] and others exist too...

'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd

Xerox431-Aug-07 2:16

Xerox4

31-Aug-07 2:16

Thanks you for the reply

Am using print document class and datagridView. Using vs 2005.

Smokeywade31-Aug-07 8:53

Smokeywade

31-Aug-07 8:53

I don't know how important it is for you to print from your created app. But you can try exporting the grid to an excel spreadsheet which is very easy - and you will be able to print from excel.

Thank You

http://www.c-sharpcorner.com/UploadFile/mgold/HowToPrintaDataGridinCsHARPand.NET11212005060838AM/HowToPrintaDataGridinCsHARPand.NET.aspx[^]

Vasudevan Deepak Kumar1-Sep-07 0:39

Vasudevan Deepak Kumar

1-Sep-07 0:39

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Checking for Nothing before disposing

intonet31-Aug-07 0:25

intonet

31-Aug-07 0:25

Is there any benefit to doing this:

If obj isnot Nothing Then
obj.Dispose
obj = Nothing
End If

I'm not sure there is. Your views are appreciated!

Tim

Re: Checking for Nothing before disposing

Colin Angus Mackay31-Aug-07 1:03

Colin Angus Mackay

31-Aug-07 1:03

intonet wrote:
Is there any benefit to doing this

Yes, it prevents an exception being thrown when you attempt to call a method on Nothing.

Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ...

My website

Re: Checking for Nothing before disposing

Vasudevan Deepak Kumar1-Sep-07 0:41

Vasudevan Deepak Kumar

1-Sep-07 0:41

intonet wrote:
I'm not sure there is.

You save yourself from being entrapped with the dreaded exception like this:

System.NullReferenceException Object Reference Not Set To An Instance Of An Object

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Vb.net Crystal report Question?

i gr830-Aug-07 23:59

i gr8

30-Aug-07 23:59

How to Set CustomPaperSize For Crystal Report From Coding in Vb.net?

prabumj@gmail.com

Re: Vb.net Crystal report Question?

Salman Sheikh2-Sep-07 21:59

Salman Sheikh

2-Sep-07 21:59

do you want to design crystal report on a custom page size or just want to set the size of paper at printing time

Salman Sheikh

How to Combine two vb.net Projects in one Project

Vimalsoft(Pty) Ltd30-Aug-07 22:45

Re: How to Combine two vb.net Projects in one Project

30-Aug-07 22:45

hi All

i have two vb.net Projects,and i have added them together in one Solution and its fine. i want to calla form of the second Project in the first project, when Project one is finished executing it task. how do i achieve that

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com

Tom Deketelaere30-Aug-07 23:14

Tom Deketelaere

30-Aug-07 23:14

add a reference from the project that does the calling to the other project (right mouse click on project select add reference tab projects)

then add an imports statement to the form (or class) that does the calling
imports project2

after that you can use everything from project2 as if it was in project1

Remarks:
-you can do it without the imports too
just add project2.Form1 when calling the form1 in project2 instead of form1
-when you have a reference from project1 to project2 you cannot add a reference from project2 to project1 this would couse a circular dependency (straight from the error from vs.net Poke tongue | ;-P

)

hope this helps

Re: How to Combine two vb.net Projects in one Project

Vimalsoft(Pty) Ltd31-Aug-07 1:26