Visual Basic

11-Apr-05 6:15

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemsecurityprincipalwindowsidentityclassimpersonatetopic.asp

Query Help

Anonymous11-Apr-05 3:57

11-Apr-05 3:57

Hi All,

I need to assign ranks to the people according to their scores (within each exam).

Id ExamCode Total
1 C1 100
1 C2 98
2 C1 100
2 C2 97
3 C1 89
3 C2 99

how can i accomplish this..
Can anyone help me

Thanks in advance,
Smile | :)

Re: Query Help

Dave Kreskowiak11-Apr-05 4:11

Dave Kreskowiak

11-Apr-05 4:11

Please don't make a second post. Click on your original message then click Modify in the bottom right of your message window.

This reeks of homework. You haven't given any details of the code you've already written (a code snippet might help), so there's not much we can do to help you. We also don't know what concepts have been covered in your class. If we tell you a method of how to do something that wasn't covered in the class, your Prof is going to get VERY suspicious about where your code really came from.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Query Help

rhenerlau19-Apr-05 17:47

rhenerlau

19-Apr-05 17:47

Sort Asc (ascending 1-100) or Desc (decending 100-1) ORDER BY whatever you called your "Score" column (SQL statement)

You might check the documentation for whatever your database software is to find out how to do those two statements. Hope this helps!

Help Needed

Anonymous11-Apr-05 1:43

11-Apr-05 1:43

Hi All,

I want to have some help.
Iam having a student table. I want to assign the ranks according to their totals...

How can i accomplish this in vb.net

Need Help

Anonymous11-Apr-05 1:36

11-Apr-05 1:36

Hi All,

I want to round a number using the formula in crystalreports
I did it using round(xxx,0) but nothing happened still it continued with 2 decimal places....

What should i want to do now. What might be wrong ...

Can anyone help me..
Thanks in advance,
Smile | :)

Re: Need Help

Anonymous11-Apr-05 5:51

Using buttons instead of linklabels

11-Apr-05 5:51

How To Implement Custom Rounding Procedures

http://support.microsoft.com/default.aspx?scid=kb;EN-US;196652

kwttrev11-Apr-05 0:56

kwttrev

11-Apr-05 0:56

I am a web developer and new to windows applications(VB). I have a client that wants a windows application with buttons that links to his various websites. He is not happy with the linklabel method and wants buttons to link to his sites when clicked on. Can anyone help with a sample code for buttons in a windows form to link to various url's.

Trevor

Re: Using buttons instead of linklabels

Dave Kreskowiak11-Apr-05 3:51

Dave Kreskowiak

11-Apr-05 3:51

I'm assuming you want to launch a new browser window when the button is clicked?

In either case, your code is going to go into the button Click event handler. In the Form designer, just double-click the button and an enpty Click event handler will be created for you. Then just drop the code in that to launch a new browser:

Dim startBrowser As New Process()
startBrowser.StartInfo.UseShellExecute = True
startBrowser.Start("http://www.codeproject.com")

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Using buttons instead of linklabels

kwttrev11-Apr-05 19:48

kwttrev

11-Apr-05 19:48

Thank you, this is what I was loooking for.

Trevor

Parameterized query in Oledb by code

Suman Singh10-Apr-05 23:39

Re: Parameterized query in Oledb by code

10-Apr-05 23:39

The code given below is not working.....

Dim ds1 As New DataSet()
Dim adap As New OleDbDataAdapter()

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con1 As New OleDbConnection ("Provider=SQLOLEDB.1; User ID=sa;Initial Catalog=pubs;Data Source=.;password=;")
Dim com As New OleDbCommand("select name from student where roll = ?", con1)
ds1.Clear()
adap.SelectCommand.Parameters("roll").Value = TextBox1.Text
adap.SelectCommand = com
adap.Fill(ds1, "student")
TextBox2.Text = ds1.Tables("student").Rows(0).Item("name")

End Sub
End Class

Ritesh123411-Apr-05 2:15

Re: Parameterized query in Oledb by code

11-Apr-05 2:15

Hi,
If ur using SQL Database than rather than going for OLEDB object u should use SQLDB object.....Try this code

Imports System.Data.SqlClient
..............
................

    Dim ds1 As New DataSet()
    Dim adap As New SqlDataAdapter()
    Private Sub Button11_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim con1 As New SqlConnection("Data Source=(local); User ID=sa;Initial Catalog=pubs;password=;")
        Dim com As New SqlCommand("select name from student where roll = @Roll", con1)
        ds1.Clear()
        adap.SelectCommand.Parameters.Add("@Roll", TextBox1.Text.trim)
        adap.SelectCommand = com
        adap.Fill(ds1, "student")
        TextBox2.Text = ds1.Tables("student").Rows(0).Item("name")

    End Sub

........................
........................

I hope this will help u.............:->

Regards,
Ritesh

Suman Singh11-Apr-05 11:35

Find method is not working with untyped datatype

11-Apr-05 11:35

Thanks for your reply...

But I m using oracle as backend.

Please advise.

Suman Singh10-Apr-05 23:23

Re: Find method is not working with untyped datatype

10-Apr-05 23:23

When a dataset is created by code (Untyped) the

Datatable.find(Textbox1.text)

Find method is not working...

But when dataset is created by Wizard, it is working fine..

Why ????

Ritesh123411-Apr-05 2:01

Re: Find method is not working with untyped datatype

11-Apr-05 2:01

Hi,
I guess there is no method like "Find" for Datatable Object....

u can use

drFoundRow = Datatable.Rows.find(Textbox1.text.Trim)

to get the appropriate Row.

Regards,
Ritesh

Suman Singh14-Apr-05 11:43

What is the main difference between Display member and Valuemember

14-Apr-05 11:43

I m exactly using this code..

But when I use untyped dataset

dim ds as dataset

it gives error..

I f i take dataset from controls(toolbox) which is the typed sataset..

It is working fine.

I wanted to know .. why ???

Thanks in advance for your reply

Suman Singh

Suman Singh10-Apr-05 23:17

Re: What is the main difference between Display member and Valuemember

10-Apr-05 23:17

What is the main difference between Display member and Valuemember property of a listbox or a combobox.

Ritesh123411-Apr-05 1:57

Re: What is the main difference between Display member and Valuemember

11-Apr-05 1:57

Hi,
The very basic difference is that user/Customer can see "DisplayMember" on UI while Developer can work with "Valuemember" which is hidden behind the DisplayMember..

I would like to give u one simple example........let's say ur combobox supposed to show the Country list. when u fetch the records from DB u will select Country name along with it'd ID.(select C_ID,C_Name from country)
Now while showing these records u will show the Country Name on ur UI hance u will set "DisplayMember" of combobox to "C_Country" while doing any DB related thing u will require the ID of the selected Country hence u will set Valuemember with "C_ID"

Now u can access the ID of selected Country using SelectedValue Property of Combobox as cboCountry.SelectedValue Property

I hope this will help u...............:->

Regards,
Ritesh

AmbiguousName6-Feb-12 19:13

AmbiguousName

6-Feb-12 19:13

hi,

almost 7 years later, you answer helped me understand the difference Smile | :)

Re: What is the main difference between Display member and Valuemember

lelouch_vi 215-Mar-20 1:59

lelouch_vi 2

15-Mar-20 1:59

15 years later... Now it helps me a lot. Thank you for this answer. Very clear and concise.

How to validate dataview is NULL

Suman Singh10-Apr-05 23:15

Re: How to validate dataview is NULL

10-Apr-05 23:15

I want to chech whether a dataset is blank or there are any record in it ?

A sample code will be more helpful.

Thanks

Ritesh123411-Apr-05 1:44

How to fetch rows from a dataview?

11-Apr-05 1:44

Hi,
U can check the Dataset or Datatable whether they have any data(Rows) in it as follows..........

If Not dsNewData Is Nothing Then<br />
                If dsNewData.Tables.Count > 0 Then<br />
                    If Not dsNewData.Tables("TableName") Is Nothing Then<br />
                    'If u want u can check for dsNewData.Tables("TableName").Rows.Count>0<br />
                        MessageBox.Show("Table has :" & dsNewData.Tables("TableName").Rows.Count & " Rows")<br />
                    End If<br />
<br />
                End If<br />
            End If

I hope this will help u..............

Regards,
Ritesh

Suman Singh10-Apr-05 23:14

Re: How to fetch rows from a dataview?

10-Apr-05 23:14

I m trying to fetch rows from dataview.

Can anyone help me?

A sample code will be more helpful.

Thanks

Ritesh123411-Apr-05 1:40

Re: How to fetch rows from a dataview?

11-Apr-05 1:40

Hi,
U can access the records detail from dataview as follows.......

For intRowIndex = 0 To pi_dtTable.DefaultView.Count - 1<br />
        MessageBox.Show(pi_dtTable.DefaultView.Item(intRowIndex).Item("ColName"))<br />
    Next

I hope this will help u...........:->

Regards,
Riesh

Suman Singh11-Apr-05 11:43