Re: sqldataadapter? - Visual Basic Discussion Boards

Re: Simple .. Dropdownlist

Dave Kreskowiak10-Jun-04 9:00

Dave Kreskowiak

10-Jun-04 9:00

Then take out the if statement. This won't catch any errors and doesn't put any restrictions on what will be displayed.

Private Sub DropDownList1_SelectedIndexChanged( _
        ByVal sender As System.Object, ByVal e As System.EventArgs) _
        Handles DropDownList1.SelectedIndexChanged

        Label3.Text = DropDownList1.SelectedItem.Text
End Sub
 

RageInTheMachine9532<font size="-1">
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome</font>

Re: Simple .. Dropdownlist

dotnet_cpp10-Jun-04 11:06

dotnet_cpp

10-Jun-04 11:06

Still same thing

Re: Simple .. Dropdownlist

Dave Kreskowiak10-Jun-04 11:38

Dave Kreskowiak

10-Jun-04 11:38

I have no idea what your doing wrong, because the same code works fine for me...

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

VBA/Excel - Charting question

Jon G10-Jun-04 5:10

Jon G

10-Jun-04 5:10

(REVISED)

I am trying to do the following:

-Check each Point of a chart series to ensure it is within specific limits
-If Point is not in limit, change the Marker type of that Point

What my question is, how do you check specific Points in a series using VBA?

---------------------------------

After posting this question, I found out how to check the point values. I still cannot figure out how to change these individual Marker types to what I want.

Here is the code to check the values:

'***Checks series points, and colors them if need be<br />
Function RefreshPoints(ChartName)<br />
    <br />
    Dim nPts As Integer<br />
    Dim aVals As Variant<br />
    <br />
    Worksheets(ChartName).ChartObjects(1).Activate<br />
<br />
    With ActiveChart.SeriesCollection(1)<br />
        nPts = .Points.Count<br />
        aVals = .Values<br />
        For iPts = 1 To nPts<br />
            MsgBox aVals(iPts)<br />
        Next iPts<br />
    End With<br />
<br />
End Function

Can anyone tell me how to build on that above function to change the marker type of a single Point?

Re: VBA/Excel - Charting question

Jon G10-Jun-04 5:25

Jon G

10-Jun-04 5:25

For those who care, I have solved my problem.. here is the final code:

'***Checks series points, and colors them if need be<br />
Function RefreshPoints(ChartName)<br />
    <br />
    Dim nPts As Integer<br />
    Dim aVals As Variant<br />
    <br />
    Worksheets(ChartName).ChartObjects(1).Activate<br />
<br />
    With ActiveChart.SeriesCollection(1)<br />
        nPts = .Points.Count<br />
        aVals = .Values<br />
        For iPts = 1 To nPts<br />
            .Points(iPts).MarkerBackgroundColorIndex = 35<br />
            .Points(iPts).MarkerForegroundColorIndex = 1<br />
            .Points(iPts).MarkerStyle = xlTriangle<br />
            .Points(iPts).MarkerSize = 13<br />
            .Points(iPts).Shadow = False<br />
        Next iPts<br />
    End With<br />
<br />
End Function

Now its just missing a few If statements to finish up, but thats what got it working. Just thought I'd post the code if anyone was interested.

sqldataadapter?

ymohd_22210-Jun-04 3:20

ymohd_222

10-Jun-04 3:20

When I use this code:
Dim pubsadapter As sqldataadapter = New sqldataadapter("select*from authors", pubssqlconn)

And Build It. the results gives me that sqldataadapter not defined.
I Imports the following before:
Imports System.Data
Imports System.Data.SqlClient
Thanks

Go forward and never Stop....

Re: sqldataadapter?

Dave Kreskowiak10-Jun-04 4:11

Dave Kreskowiak

10-Jun-04 4:11

Then it should work. The lowercase spelling of the SqlDataAdapter name tells me that the Imports statements are incorrect somehow. They are spelled correctly, but possible not at the very top of the code file? They should normally come before any Namespace or Class statements.

You might want to try posting the code so we can see it?

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

Re: sqldataadapter?

VenkatFor.NET10-Jun-04 11:01

VenkatFor.NET

10-Jun-04 11:01

Does it give any error at 'Imports' statement. VS.NET includes reference to System.Data.dll in most of the project templates. If we remove this reference to System.Data.dll, Imports will have no meaning. Imports is just to import the namespaces just for coding purpose but we still have to have a reference in the project.

BK

TreeView --> Move Nodes

Brad Fackrell10-Jun-04 3:04

Brad Fackrell

10-Jun-04 3:04

Hi.

Can anybody tell me if there is a way to move nodes within a TreeView? I have found how to use drag-and-drop between two different TreeViews but haven’t been able to figure out how to tweak the code to make it work within ONE TreeView.

I would like to be able to simply move child nodes (and parent, if possible) up and down in the Tree.

Thanks
Brad

Input Data From Data Grid

Jakarta_Project10-Jun-04 1:17

Jakarta_Project

10-Jun-04 1:17

Hi......

I'm a newbie here.

I have a question about how to input data from data grid control in Visual Basic.
I hope somebody can help me about this problem.
Thanks Smile | :)

Re: Input Data From Data Grid

Dave Kreskowiak10-Jun-04 3:50

Dave Kreskowiak

10-Jun-04 3:50

Jakarta_Project wrote:
I have a question about how to input data from data grid control in Visual Basic.

And that question would be ..........???

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

Re: Input Data From Data Grid

tramdtt10-Jun-04 20:55

tramdtt

10-Jun-04 20:55

You should Vsflexgrid to input direct data

tramdtt

system analysis and design

len_ems9-Jun-04 22:36

len_ems

9-Jun-04 22:36

hello guys...

It's our first semester here in our school and part of our 4th year standing here is to create our own information system. Can you suggest some systems except enrolment systems, election systems, point-of-sale systems, accounting systems, etc...

Thanks...

Re: system analysis and design

RichardGrimmer9-Jun-04 23:14

RichardGrimmer

9-Jun-04 23:14

Bug tracking?
Timesheet analysis?
Expenses?

(And there are ASP.NET reference applications for all of these (www.asp.net[^])if you need some "inspiration")

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Re: system analysis and design

Anonymous14-Jun-04 18:26

Anonymous

14-Jun-04 18:26

Dear Sir,

Thanks for your suggestion... Good luck and Mabuhay...

len_ems

byte length restriction in text box

Rohitse9-Jun-04 22:14

Rohitse

9-Jun-04 22:14

Hey All,

I have a simple quetion to ask.
The maxlength property of an edit box restricts user to enter more than the specified characters. But in the Japanese system, if user enters double-byte characters, then the actual byte would exceed that limit.
Do we have similar restriction on byte length as well?
I used LenB() method but it considers even the Ascii characters in the English language to be 2 bytes long.
e.g LenB("123") gives me 6.

So is there any generic function which would return me the exact bytes in a string (considering the 1 byte and 2 byte characters differently) and that can be used with English system and Japanese systems where user can enter Japanese as well as English character in the text box.

Thanks
Rohit

Re: byte length restriction in text box

RichardGrimmer9-Jun-04 23:17

RichardGrimmer

9-Jun-04 23:17

VB (6 at least - not sure about .NET) uses BSTRs to handle strings, which are always two bytes / char (AKAIK), with a couple at the front end for length...

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Re: byte length restriction in text box

Dave Kreskowiak10-Jun-04 3:49

Dave Kreskowiak

10-Jun-04 3:49

All Strings in the .NET Framework are Unicode strings. They all have double-byte characters, so yes, "123" will return 6 bytes.

You can't have two different encodings in the same string. It's either going to be all single-byte, or all double-byte, not both...

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

Scheduler sample code

MrBean9-Jun-04 22:01

MrBean

9-Jun-04 22:01

I'm developing a simple scheduler application for my company in VB.NET (Windows Forms).

(No, I can't use a standard product due to reasons I can't go into here)

Anybody have any sample code or simple framework which can help me getting started so I don't have to start from scratch ?

I'm looking for some simple code which shows how to make different schedules (every hour/day/week/month/date, on fixed times/dates, etc)
I of course know how to make timers, services, execute stuff, UI, and the rest of the application - only need help for the shedule checking part.
Maybe some kind of simple class library...

TIA Smile | :)

Re: Scheduler sample code

Dave Kreskowiak10-Jun-04 3:46

Dave Kreskowiak

10-Jun-04 3:46

A simple search on Google for "Scheduler source code" revealed tons of examples:
Google search results[^]

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

Custom Draw TabControl

beowulfagate9-Jun-04 20:47

beowulfagate

9-Jun-04 20:47

Ever seen the tab control on Windows messenger? I know that it is actually a web page but I got the idea of somehow turning it into a windows forms control. However, I got into a snag custom drawing the tabcontrol. I can't seem to resize it so that it has space to display an icon instead of text nor can I custom draw the tab itself, just the same old boring rectangle - not the cool, new curved tabs like messenger. Any ideas?

Create application shortcut

?!?9-Jun-04 20:42

?!?

9-Jun-04 20:42

Hi Is there a function that let me create a shortcut to an app?
say on the desktop?
Thanks

Re: Create application shortcut

Dave Kreskowiak10-Jun-04 3:42

Dave Kreskowiak

10-Jun-04 3:42

There is no function in the .NET BCL that will handle this. You will have to use the Microsoft Scripting Runtime (set a COM reference to this!), create a Windows Scripting Shell object and use it to create the shortcut. Something like this (I think!):

Dim WshShell As New WScript.Shell
Dim oShellLink As WScript.Shortcut = WshShell.CreateShortcut(strDesktopPath & "\Shortcut Script.lnk")
oShellLink.TargetPath = WScript.ScriptFullName
oShellLink.WindowStyle = 1
oShellLink.Hotkey = "CTRL+SHIFT+F"
oShellLink.IconLocation = "notepad.exe, 0"
oShellLink.Description = "Shortcut Script"
oShellLink.WorkingDirectory = strDesktop
oShellLink.Save

I haven't tested this code, but it should look SOMETHING like this. I don't have Visual Studio where I'm at work, so I would have to wait until I got home to create a runnable example.

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

Re: Create application shortcut

VenkatFor.NET10-Jun-04 11:10

VenkatFor.NET

10-Jun-04 11:10

See if you can consider creating shortcut at the time of deployment wherever you need using Setup projects. I suppose, this would be the best .NET solution.

BK

How can I add one menu item on menu system of Window???

tramdtt9-Jun-04 17:59

tramdtt

9-Jun-04 17:59

Hi Im writing a app and I have a problem. I want my app will add one menuitem on menu system of Window???
Example::: When I open Window Explorer, click right mouse button on a folder, will appear one menupopup of window. I want on that menu will contain my menuitem. Its the same as Winzip application. Winzip has one menuitem on menu system of Window after you installed winzip...
Who can help me????
Thanks
Good luck

tramdtt

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