Re: about database - C# Discussion Boards

29-Oct-09 19:00

the first ,last,next and Previous record of database table
how could i search?
after succeed connect the database
code...?use dataset? i m a beginner
thanks everyone

miss YY29-Oct-09 19:07

29-Oct-09 19:07

got it

padmanabhan N29-Oct-09 19:57

padmanabhan N

29-Oct-09 19:57

Can you post your answer so that it would be useful for others.....

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Christian Graus29-Oct-09 20:57

29-Oct-09 20:57

In this case, that seems doubtful....

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

miss YY1-Nov-09 20:40

1-Nov-09 20:40

use BindingManagerBase Class,it can be finished

private void GetBindingManagerBase()
{
/* CustomersToOrders is the RelationName of a DataRelation.
Therefore, the list maintained by the BindingManagerBase is the
list of orders that belong to a specific customer in the
DataTable named Customers, found in DataSet1. */
myBindingManagerBase =
this.BindingContext[DataSet1, "Customers.CustomersToOrders"];

// Adds delegates to the CurrentChanged and PositionChanged events.
myBindingManagerBase.PositionChanged +=
new EventHandler(BindingManagerBase_PositionChanged);
myBindingManagerBase.CurrentChanged +=
new EventHandler(BindingManagerBase_CurrentChanged);
}

private void BindingManagerBase_PositionChanged
(object sender, EventArgs e)
{
// Prints the new Position of the BindingManagerBase.
Console.Write("Position Changed: ");
Console.WriteLine(((BindingManagerBase)sender).Position);
}

private void BindingManagerBase_CurrentChanged
(object sender, EventArgs e)
{
// Prints the new value of the current object.
Console.Write("Current Changed: ");
Console.WriteLine(((BindingManagerBase)sender).Current);
}

private void MoveNext()
{
// Increments the Position property value by one.
myBindingManagerBase.Position += 1;
}

private void MovePrevious()
{
// Decrements the Position property value by one.
myBindingManagerBase.Position -= 1;
}

private void MoveFirst()
{
// Goes to the first row in the list.
myBindingManagerBase.Position = 0;
}

private void MoveLast()
{
// Goes to the last row in the list.
myBindingManagerBase.Position =
myBindingManagerBase.Count - 1;
}

about tree view

miss YY29-Oct-09 18:35

29-Oct-09 18:35

hi everyone,
i want to create a tree view based on data return from a database.

show the data from database ,but i dnt know which Property of tree view to use

and how could the code be.....
thanks to all

Re: about tree view

Christian Graus29-Oct-09 18:45

Need advice and help with editing arraylists

29-Oct-09 18:45

I believe the treeview has a Nodes collection that you add to. There's no one property that magically works out your data format and turns it into a tree view.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: about tree view

vivasaayi29-Oct-09 19:09

vivasaayi

29-Oct-09 19:09

Look at this

Data Binding TreeView in C#[^]

http://msdn.microsoft.com/en-us/library/aa972151.aspx

rooster215429-Oct-09 17:17

rooster2154

29-Oct-09 17:17

I've got 32 arraylists, each representing one team. I also will have 1696 players, with 53 players assigned to each team. Each player is one array (named by player number) that contains that player's attributes (first name, last name, speed, position, etc). I'm having trouble pointing my main menu to a method that will go through all of these players and send players of particular positions to particular methods to obtain their overall rating. Like, for example, if the player is a CB, that player will be sent to the CBCalculator, obtain his overall rating, input it into the player's array, and then loop to the next player in the list. Also, I'm having trouble setting a rating cap--the maximum attainable overall rating will be 99; anything overall rating that is calculated to be above 99 will be set at 99.

This is what I have so far for the position "sorter":

foreach (Player i in teams) //teams is an arraylist of all 32 team arraylists
{
    switch (position)
    {
        case "CB":
            CBCalc(int SPD);
            break;
        case "FS":
            FSCalc();
            break;
        default:
            Console.WriteLine("Error 2");
            break;
    }

This is what I have so far for a test Calculator method:

public static void CBCalc(int SPD)
{
    //CB
    double cbOverall = 28 + ((SPD - 50) / 2.5)
    int cbOverall2 = Convert.ToInt32(cbOverall);
    if (cbOverall2 >= 99)
    {
        cbOverall2 == 99;           //overall rating limit set at 99
    }

http://i783.photobucket.com/albums/yy112/rooster2154/ProgramLayout_10-29-09.jpg
The above link is to help clarify what i'm trying to do and how the program is set up

If you think you can help me along in my project please add me:
YIM: rooster2154

Re: Need advice and help with editing arraylists

Luc Pattyn29-Oct-09 17:33

Luc Pattyn

29-Oct-09 17:33

Hi,

first some comments on your current code:
1. you have "Player" as a type although your description said a player was an array.
2. the foreach loop won't compile as teams does not contain players, it contains zero or more teams.
3. the first line "CBCalc(int SPD);" won't compile as you don't specify type when calling a method, and SPD is unknown.

I do not particularly like your data organization; the structure is OK, the types are not:

1. each player should be an object, an instance of class Player, and not an array. Inside class Player, you could store whatever data you want to keep for players (first name, last name, day of birth, ...), each using the proper type.

2. assuming each player belongs to a single team, each team should be a List<Player> which is slightly easier to use than an ArrayList. I would be inclined to have a Team class that inherits from List<Player>

3. and then you could have a List<Team> to hold your teams.

So the fundamental organization remains the same, the collections used are different (no arrays and no ArrayLists).

Now to iterate over all players, the code would be:

foreach (Team team in teams) {
    foreach (Player player in team) {
        ... whatever
    }
}

// where
public class Player {
    string lastName;
    DateTime DOB;
    ...
}

public class Team : List<Player> {
    ... you don't need much code in here, as you can use all the methods inherited from List,
    ... e.g. you can do Team.Add(new Player());
}

Hope this helps. If you're unfamiliar with any of this, try reading a book on C#, then come back with specific questions.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Need advice and help with editing arraylists

rooster215431-Oct-09 14:49

rooster2154

31-Oct-09 14:49

How do I read from a text document while along the way putting selected objects from each line into a particular array? and how would i go about creating a counter so that for each line, the counter is increased by 1 and it automatically creates a new list for that line? (I created a Player class.) Also, how would i tell the it to disregard certain lines that have certain symbols at the beginning?
For example:

* Team 1
* firstName LastName position speed etc...
john jackson CB 88
jack robinson QB 55
* Team 2
* firstName LastName position speed etc...
jim johnson FS 92
etc.

in the first line of text the code will read (disregarding the lines marked with asterisks), "john" will be put in a player's firstName, "Jackson" would be put in that same player's lastName variable, same with position, speed, etc.

i already have some of the code i think i will use ( at http://www.csharp411.com/c-read-text-file-line-by-line/[^] )

Re: Need advice and help with editing arraylists

Luc Pattyn31-Oct-09 15:17

Luc Pattyn

31-Oct-09 15:17

Hi,

1.
you need more structure in your file, how about:

; comments start with this special character (choose one)
; whereas keywords start with another special character (choose one)
; $TEAM is a keyword, it is followed by the team name
$TEAM red
; players are listed: firstName; lastName; ...
Jan;Van den Broeck; CB; 88
Gill;Bates; ZZ; 00
$TEAM blue
...
; end-of-file marker
EOF

FWIW: others will recommend other syntax, maybe an XML file; I tend to keep things simple here.

2.
define Player and Team class as I told before; then use List<T> where T is Player/Team (ArrayList is outdated, arrays are no good, you don't know the dimension).

3.
for small files, you can get all lines at once into memory using File.ReadAllLines()

4.
use foreach to iterate over the lines, then test first char for ; and $

5.
make sure you have a "current team", to which the "current player" gets added.

BTW: I strongly advice you buy and study a book on C#.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Take pictures with multiple webcams

toby3129-Oct-09 17:09

toby31

29-Oct-09 17:09

I'm working on an application that is supposed to take picture from 6 different web cams. I found some code that can be used to take pictures from one web cam, but i was wondering what the i have to do to select
the camera i need.

Any help would be apreciated.

Thanks

Re: Take pictures with multiple webcams

Christian Graus29-Oct-09 18:46

Pressing buttons in a webpage programmatically

29-Oct-09 18:46

I am sure there are examples here on CP that illustrate listing available input devices and selecting which one to work with

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Nanostrike29-Oct-09 12:07

Nanostrike

29-Oct-09 12:07

Hey there everyone,
I'm working on a program that gets information from websites. However, there are a few things I'm not really sure how to do.

Basically, I need to go to a page, select a specific radio button, and then hit a button to submit the information. Is there a good way to do this in C#?

Thanks in advance!

*insert sig here*

Re: Pressing buttons in a webpage programmatically

Christian Graus29-Oct-09 12:33