C# Discussion Boards - CodeProject

Re: increment by 1

eyeseetee7-Dec-07 6:26

eyeseetee

7-Dec-07 6:26

Hi
How would i set the int to the object, woudl i not declare an int at all?

cheers sp far

Re: increment by 1

Ian Shlasko7-Dec-07 7:27

Ian Shlasko

7-Dec-07 7:27

As I said, figure out what type you're getting back. If it's a different type of number (long, short, byte, float, etc), you can use Convert.ToInt32(x) to convert x into a standard int.

If you messed up the query and are getting a date, a string, a DBNull, or something weird, well then you have another bug.

Re: increment by 1

Ennis Ray Lynch, Jr.7-Dec-07 4:58

Ennis Ray Lynch, Jr.

7-Dec-07 4:58

If it is SQL Server you should use an identity and if it is oracle you should use a Sequence.

The code you have is not updating the database because ADO.NET is disconnected from the database.

"SELECT @maxValue = MAX(activity_order) FROM table WHERE clause;
UPDATE table SET activity = @maxValue + 1 WHERE clause;
"

Will do what you want (make sure to add an output parameter to the command) but it is sloppy.

Need a C# Consultant? I'm available.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

Re: increment by 1

eyeseetee7-Dec-07 5:10

eyeseetee

7-Dec-07 5:10

can the above used in c#?
e.g. string maxquery2 = "SELECT @maxValue = MAX(activity_order) FROM roomactivitylk WHERE room_code = 'v1106';UPDATE roomactivitylk SET activity_order = @maxValue + 1 WHERE room_code = 'v1106';";

cheers

Yes

Ennis Ray Lynch, Jr.7-Dec-07 5:13

Ennis Ray Lynch, Jr.

7-Dec-07 5:13

But you need to place a parameter in your command object.

Need a C# Consultant? I'm available.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

Re: Yes

eyeseetee7-Dec-07 5:18

eyeseetee

7-Dec-07 5:18

Hi
so this statement isnt working is it cos im using an insert
string maxquery2 = "SELECT @maxValue = MAX(activity_order) FROM roomactivitylk WHERE room_code = 'v1106';INSERT INTO roomactivitylk (room_code, activity_order, instance_variant, activity_code, ignore_flag) VALUES ('" + room_code + "', @maxValue + 1, '1', '" + activity_code + "')";

??
thanksoyu

Re: Yes

Ennis Ray Lynch, Jr.7-Dec-07 5:19

Ennis Ray Lynch, Jr.

7-Dec-07 5:19

What are the errors?

Need a C# Consultant? I'm available.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

Re: Yes

eyeseetee7-Dec-07 5:21

eyeseetee

7-Dec-07 5:21

it just wont insert
the appication is set to custom errors
it wont insert into the database, does ythe syntax look correct?

Re: Yes

Xmen Real 7-Dec-07 5:54

Xmen Real

7-Dec-07 5:54

yeah, value for "ignore_flag" isnt exist

Becoming Programmer...

Re: Yes

Guffa7-Dec-07 7:20

Guffa

7-Dec-07 7:20

That can't be used safely anywhere. As the select and insert are executed in separate transactions, there is no guarantee that the @maxValue is still the hightest value when you use it in the insert.

Why aren't you using an identity field? It will increment automatically.

Experience is the sum of all the mistakes you have done.

Hiding a tabsheet

Dewald7-Dec-07 4:38

Dewald

7-Dec-07 4:38

I have a tabcontrol with say, 5 tabsheets. I would like to be able to hide one or more of these tabsheets during runtime (and make it visible again at a later stage) but can't seem to figure out how. I was hoping for something like
myTabSheet.visible = false;
but there's no such property.

Any tips? Thanks in advance.

Re: Hiding a tabsheet

Anthony Mushrow7-Dec-07 6:20

Anthony Mushrow

7-Dec-07 6:20

The actual tab pages are separate controls that than the tab control itself.

So you can remove the tabpage from the list of tab pages the tab control has, and add it back later.

this.tabControl.TabPages.Remove(tabPage);<br />
this.tabControl.TabPages.Add(tabPage);

My current favourite word is: Bauble!

-SK Genius

Setting focus on new DeckItem [modified]

oracleConvert7-Dec-07 4:24

oracleConvert

7-Dec-07 4:24

I have deckControl that we allow users to create new deck items with. When they create a new deck item we want them to be able to enter the name for the deckitem in the textbox that we have as part of the deckitem. We give the new deckitem a default name of 'New Category' so when they create a deck item we want the textbox displayed with the name 'New Category' selected/highlighted so they can type in their name for the item.

I can get the textbox to display, but it never gets focus, so the text is not highlighted and the cursor is not in the textbox, even tho the IsFocused property is true. One thing I did notice was that the IsLoaded property is false, does this have anything to do with it? How do I force the new deck item to be loaded? The new deckItem is visibily displayed, and it is set to be the selectedItem in the deckControl. This is my first WPF project so I am sure I am missing something obvious.

As a side note the method I am calling to handle this also gets called if the user wants to rename a deckItem and it works fine on an existing deckItem, just not when they create a new deckItem.

Thanks!

modified on Friday, December 07, 2007 10:38:46 AM

Re: Setting focus on new DeckItem

Skippums7-Dec-07 5:14

Skippums

7-Dec-07 5:14

Are you setting the focus in the constructor? If so, move it to the OnLoad event, or the OnShown event. Sometimes setting focus in the constructor doesn't do anything for some reason. Let me know if this helps.

-Jeff

Re: Setting focus on new DeckItem

oracleConvert7-Dec-07 5:51

oracleConvert

7-Dec-07 5:51

No, I do not have the focus in the constructor, it is in the method we call to show the textbox, select the text.

Here is the code where I create the deckItem:

DeckItem item = CreateDeckPage(statLibDO);
statLibDO.Order = this.View.ControlDeck.Count;
this.View.ControlDeck.Add(item);
this.View.ControlDeck.SelectedItem = item;

EnableEditMode(this.currentDeckItem.DeckHeader as ReportTreeViewHeader);

Here is the EnableEditMode method:

private static void EnableEditMode(ReportTreeViewHeader header)
{
if (header != null)
{
header.EditHeaderText();
if (!header.HeaderEditor.IsFocused)
header.HeaderEditor.Focus();

}
}

Finally, here is the code for header.EditHeaderText that does all the work:
public void EditHeaderText()
{
//this.headerEditor.Text = this.headerText.Content.ToString();
this.headerText.Visibility = Visibility.Hidden;
this.headerEditor.Visibility = Visibility.Visible;

this.headerEditor.SelectAll();
this.headerEditor.Focus();
ReportDragDropManager.SuspendDragDropActivity = true;

}

Also, here is the code when the want to rename an existing deckItem whick works fine:
private void MenuItem_ClickRename(object sender, RoutedEventArgs e)
{
if (this.targetDeckItem != null)
EnableEditMode(this.targetDeckItem.DeckHeader as ReportTreeViewHeader);
else if (this.targetTreeViewItem != null)
EnableEditMode(this.targetTreeViewItem.ReportTreeViewItemHeader);

}

This calls the same EnableEditMode method that gets called when I create a new deckitme. The problem seems to me that the new deck item is not yet loaded (IsLoaded is false) so I am thinking that is why I can not get focus on the deck. How do I get the new deckItem loaded?

Thanks for your reply!

Re: Setting focus on new DeckItem

Skippums7-Dec-07 6:13

Skippums

7-Dec-07 6:13

Ok, change the following and see if it changes the result:

EnableEditMode(this.currentDeckItem.DeckHeader as ReportTreeViewHeader);
-to-
EnableEditMode(item.DeckHeader as ReportTreeViewHeader);

I doubt it will, otherwise you would have seen a non-default header title as the title of the textBox. Also ensure that the ReportTreeViewHeader being passed in is NOT null. Another idea is to call "this.Refresh()", "this.View.ControlDeck.Refresh();", or "item.Refresh()", prior to and after setting the focus (try both separately, and together). If none of this works, then I really don't have any additional ideas. I think I know what the problem is, though... the textBox isn't actually displayed until the next call OnPaint method is executed. Since you set the focus prior to the textBox actually being visually created, it is not being drawn properly. Hopefully calling one of the Refresh() methods will halt execution on the main thread until the textbox's GUI has been created. This appears to be a similar problem to what I was describing with the constructor... stuff isn't drawn until AFTER the constructor yields control of the main thread to the message pump. Good luck!

-Jeff

Re: Setting focus on new DeckItem

oracleConvert7-Dec-07 6:21

oracleConvert

7-Dec-07 6:21

I do not have the refresh option available on any of the items you specified, so I can not try that. Is there a way to navigate to off my current deck item and then back on to it to cause it to repaint?

Thanks for all your help!

Re: Setting focus on new DeckItem

Skippums7-Dec-07 9:18

Skippums

7-Dec-07 9:18

Presumably you are adding the textbox to some sort of UserControl object, right? Just refresh the control that contains the textbox (after the control is visible and the textbox has been added to it's children), and that may solve the problem.

-Jeff

Re: Setting focus on new DeckItem

oracleConvert7-Dec-07 9:44

oracleConvert

7-Dec-07 9:44

when you say 'refresh' what do you mean? I do not have a refresh option available when I do this.

Re: Setting focus on new DeckItem

Skippums10-Dec-07 3:52

Skippums

10-Dec-07 3:52

All things that inherit from type "System.Windows.Forms.Control" have a method, declared as "public void Refresh();". This method invalidates and repaints the control, so whatever the TextBox (which is a control, and therefore should have this method) is added to when you try to display it should have this method on it. Let me know if it works.

-Jeff

Re: Setting focus on new DeckItem

oracleConvert10-Dec-07 4:57

oracleConvert

10-Dec-07 4:57

Hi Jeff!

Thanks for all your help and suggestions, I really appreaciate it!.

What I ended up doing was creating an item_Loaded event handler and placing the EnableEnditMode method call in the event handler, and then it started working!

I think you suggested that in one of your earlier posts but I didn't do it because the Isloaded for the item always said false so I figured adding an event handler was pointless.

Thanks again!
Bob

Get Data From OLEDBDataReader

tr_thorn7-Dec-07 3:34

tr_thorn

7-Dec-07 3:34

I want from data reader coloumn 2 data to MessageBox.But gettin error.!

string strBaglanti = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=ftakip.mdb";
// Baglanti nesnemiz:
OleDbConnection conBaglanti = new OleDbConnection(strBaglanti);

// Komutumuzu tanimlayalim
OleDbCommand cmdKayitEkle = new OleDbCommand();

// komutumuzun tipini ve ismini verelim:

cmdKayitEkle.CommandType = CommandType.Text;
cmdKayitEkle.CommandText = "SELECT F_NO FROM F_KAYIT" +
" WHERE F_NO = '1231'";
cmdKayitEkle.Connection = conBaglanti;
conBaglanti.Open();
OleDbDataReader dr = cmdKayitEkle.ExecuteReader();

while (dr.Read())
{
MessageBox.Show(dr[2].ToString());
}
dr.Close();
conBaglanti.Close();
}

Re: Get Data From OLEDBDataReader

Pete O'Hanlon7-Dec-07 3:48

Pete O'Hanlon

7-Dec-07 3:48

Your command text only contains 1 column. How could you read from any other column? BTW - you should use GetOrdinal to find the ordinal position of this column, e.g. dr.GetString(dr.GetOrdinal("F_NO"));

Deja View - the feeling that you've seen this post before.

My blog | My articles

Re: Get Data From OLEDBDataReader

pmarfleet7-Dec-07 3:49

pmarfleet

7-Dec-07 3:49

Your query only returns 1 column. How can you reference a second column?

BTW, DataReader column indexers are zero-based. dr[2] actually returns the 3rd column.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Get Data From OLEDBDataReader

Dr. Emmett Brown7-Dec-07 3:57

Dr. Emmett Brown

7-Dec-07 3:57

Have you tried dr[1] ?
I don't remember how it was in C# but I think datareader's indexes begin in 0.

Hope it helps

rotter

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