Visual Basic

31-Aug-07 5:22

I have a dataGrid that is populated by SQL table. The Datagrid has two dynamic columns - that I created to for calculations. I want to sort the grid on frmload by one of the dynamic columns is that possible - if so; what will be the best way to do this?

Thank You

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

Vimalsoft(Pty) Ltd

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

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

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

moving text from one RTB to another RTB

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

Vimalsoft(Pty) Ltd

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

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