C# Discussion Boards - CodeProject

First Prev Next

Re: loop an existenting Labels from my aspx page in my cs page

F-ES Sitecore12-Mar-15 1:34

F-ES Sitecore

12-Mar-15 1:34

Label[] labels = form1.Controls.OfType<Label>().ToArray();
for(int i = 0; i < labels.Length; i++)
{
    labels[i].Text = someFunction(i);
}

Re: loop an existenting Labels from my aspx page in my cs page

Member 1151896215-Mar-15 22:44

Member 11518962

15-Mar-15 22:44

Thanks but now i get another error:

Error 25 'System.Web.UI.ControlCollection' does not contain a definition for 'o' and no extension method 'o' accepting a first argument of type 'System.Web.UI.ControlCollection' could be found (are you missing a using directive or an assembly reference?)

When I try do add a using it cannot be found...
(I am working on a web.net project not a console one)
What am I missing??

Re: loop an existenting Labels from my aspx page in my cs page

Member 1151896215-Mar-15 22:51

Member 11518962

15-Mar-15 22:51

Thanks but now I get this error

Error 25 'System.Web.UI.ControlCollection' does not contain a definition for 'o' and no extension method 'o' accepting a first argument of type 'System.Web.UI.ControlCollection' could be found (are you missing a using directive or an assembly reference?)

When I tried to add the using it cannot be found
What am I missing here?

Thanks!

Quickly find the information on the GridView ?

Member 245846711-Mar-15 19:59

Member 2458467

11-Mar-15 19:59

See attached image file: [IMG]http://imagizer.imageshack.com/img908/3636/urFBbz.jpg[/IMG]

assuming the data is loaded from SQL Server GridView includes 5 columns as shown above, cells Search of textbox where you find out quickly (due to its use on the image for illustration), in his cell this search textbox enter any value in the column that has (according to this column 5), the GridView grid lines present value of the lookup value, usually looking to have a value equal to 1 column with which to look, if you use fast search method does not need to specify one column before it, how to write this quickly find how to load into the GridView ?

Re: Quickly find the information on the GridView ?

OriginalGriff12-Mar-15 0:02

OriginalGriff

12-Mar-15 0:02

1) No, I'm not going to random sites to look ate random images.
2) None of that makes any sense. It's probably a translation problem, but in English I can;t work out what you are trying to do, much less what help you need. Laugh | :laugh:

Remember that we can't see your screen, access your HDD, or read your mind. So try to give us information - perhaps an example - which means we can work out what the problem is.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: Quickly find the information on the GridView ?

Matt T Heffron12-Mar-15 10:24

Matt T Heffron

12-Mar-15 10:24

This is not really a C# issue.
It could be Windows Forms, Silverlight/WPF, or ASP.
Please use the correct forum.

A positive attitude may not solve every problem, but it will annoy enough people to be worth the effort.

How to Save changes in Dataset back to my Database

David_Pollard11-Mar-15 19:24

David_Pollard

11-Mar-15 19:24

Hi Guys,
I'm running Visual Studio 2008. I have a simple project that displays data in a DataGridView that is linked to Dataset, BindingSource and TableAdapter.

My data is in SQL Server and in a single table.

My program so far reads the data in no problem but I'm stuck saving my changes back to the database.

I can see I need to create an update query. I found the properties of the TableAdapter named "UpdateCommand" When I run Query Builder it creates a query like this.

SQL

UPDATE       ExecuteItem
SET                iOrderBy =, sDescription =, bContinueOnFailure =, dLastRunTime =, bLastRunStatus =, sSQLCode =, bActive =

Obviously it is missing a name between the equals and the comma.

What is the syntax for specifying the names of my fields in the dataset?
Can someone point me to an example of how this query should look for a simple single table update?

Thanks
David

Re: How to Save changes in Dataset back to my Database

Matt T Heffron12-Mar-15 10:25

Matt T Heffron

12-Mar-15 10:25

This is not really a C# issue.
Please use the Database forum.

A positive attitude may not solve every problem, but it will annoy enough people to be worth the effort.

Re: How to Save changes in Dataset back to my Database

David_Pollard12-Mar-15 12:36

David_Pollard

12-Mar-15 12:36

Hello Again,
After a good nights sleep the answer to my initial problem was obvious.
As it is SQL the only answer can be parameters.

So within the Query Builder I inserted Paramaters in the format of @FieldName in the "New Value" column.

Now my SQL code looks like this.

SQL

UPDATE       ExecuteItem
SET                iOrderBy = @iOrderBy, sDescription = @sDescription, bContinueOnFailure = @bContinueOnFailure, dLastRunTime = @dLastRunTime, 
                         bLastRunStatus = @bLastRunStatus, sSQLCode = @sSQLCode, bActive = @bActive

Now when I execute my program and change one row in the Datagridview it updates every row in the database with the same value.

This now seems like a question about Visual Studio more than anything else. I'll take my question else where if you still think it isn't appropriate here.

Thanks
David.

Re: How to Save changes in Dataset back to my Database

David_Pollard12-Mar-15 12:54

David_Pollard

12-Mar-15 12:54

Again Obvious when I think more about it.

I needed to put a WHERE clause in my SQL.

SQL

UPDATE       ExecuteItem
SET                iOrderBy = @iOrderBy, sDescription = @sDescription, bContinueOnFailure = @bContinueOnFailure, dLastRunTime = @dLastRunTime, 
                         bLastRunStatus = @bLastRunStatus, sSQLCode = @sSQLCode, bActive = @bActive
WHERE        (lExecuteItemID = @lExecuteItemID)

So you are right not a C# problem at all Smile | :)

I don't know why I couldn't get the auto generate feature of Visual Studio to create this SQL. It reports success but does not create anything. (Insert and Select are created OK)

I also don't know how Visual Studio magically assigns the correct values to my parameters. I use the same field names just stuck an @ sign in front of them. I also kept them in the same order but this seems to rely heavily on luck. They must be assigned somewhere.

Anyway sorry to bother you guys with this. Smile | :)

Thanks
David

Re: How to Save changes in Dataset back to my Database

Matt T Heffron12-Mar-15 13:04

Matt T Heffron

12-Mar-15 13:04

David_Pollard wrote:
I'll take my question else where if you still think it isn't appropriate here

Don't worry about it, but in the future, choosing the correct forum means the people who see your question are the ones who are most likely to be able to help!

A positive attitude may not solve every problem, but it will annoy enough people to be worth the effort.

activex control

Member 1149283311-Mar-15 16:20

Member 11492833

11-Mar-15 16:20

SQL

I am developing an activex control for use with ie.   The javascript code responds to dragdrop event and calls activex control's c# function.  At this point I need to gain access to clipboard and retrieve custom data based on format code.  There is an interface IDataObject which could be used for that.  But I need to gain access to parent form.  Is there a way to access browser form from activex control?  If you know of a better way to get to the same clipboard data,  please, let me know.

Any help is appreciated.

  Thanks in advance

Message Removed

11-Mar-15 10:22

N_tro_P

11-Mar-15 10:22

Message Removed

Re: EntityFramework Self referencing one to many

Gerry Schmitz11-Mar-15 13:02

Gerry Schmitz

11-Mar-15 13:02

Where's the definition for .subFolderField?

The getter and setter don't make sense.

A collection that triggers OnPropertyChanged events is generally defined somewhere as an ObservableCollection.

Message Removed

12-Mar-15 2:38

N_tro_P

12-Mar-15 2:38

Message Removed

Re: EntityFramework Self referencing one to many

Gerry Schmitz12-Mar-15 3:28

Gerry Schmitz

12-Mar-15 3:28

I'm not confused; I've just never had a reason to fire an OnPropertyChanged event when "setting an entire collection"; particularly in the context of simply communicating with EF (regardless of the type of collection: array or otherwise).

What is supposed to happen (in your case) when the OnPropertyChanged event fires?

Who or what is subscribing to that event?

Anyway ...
http://stackoverflow.com/questions/12656914/how-to-map-recursive-relation-on-self-in-entity-framework-code-first-approach[^]

modified 12-Mar-15 9:45am.

Message Removed

12-Mar-15 4:25

N_tro_P

12-Mar-15 4:25

Message Removed

Re: EntityFramework Self referencing one to many

Gerry Schmitz12-Mar-15 4:47

Gerry Schmitz

12-Mar-15 4:47

You didn't read the whole thing ... I would consider the last entry on that page ... using your array and a partial class, if need be.

Message Removed

12-Mar-15 5:04

N_tro_P

12-Mar-15 5:04

Message Removed

Re: EntityFramework Self referencing one to many

Gerry Schmitz12-Mar-15 5:43

Gerry Schmitz

12-Mar-15 5:43

I was suggesting it as a "pattern".

If you can't apply it to your situation, then I don't know what will.

Trick IIS forms authentification

jonas7811-Mar-15 4:14

jonas78

11-Mar-15 4:14

Hi We have a standard application that uses AD sso, using forms authentification.
Before last upgrade of this system I wrote a small c# code that opend a browser with a different account than computer user account.
Witch worked fine becuse windows auth. where used then. So user become that new user instead of computer user.

But when they switched to forms auth. in IIS this no longer works. I have no clue how to trick authentification mechanism in this case. Any who hade done this?

Described in Another way;
User (AD-user), let say ABC is logged in to computer. But whants to start application (webpage, IE) as user BBB.
And no, I cant get any Changes in application itself.

\Jonas

Re: Trick IIS forms authentification

F-ES Sitecore11-Mar-15 4:39

F-ES Sitecore

11-Mar-15 4:39

Simplest way will be to programmatically populate the username and password boxes then click the login button.

Re: Trick IIS forms authentification

jonas7813-Mar-15 1:51

jonas78

13-Mar-15 1:51

What do you mean?
If I browse to the application my computer AD-account is automaticly used. No login page is used.
Starting browser like "run-as" doesn't help. (that works if win.auth. is used in IIS).
What credidentials is forms auth using? Doesn't seem to be browsers cred.

\jonas

Updating Code For a Newer Version

Member 997225111-Mar-15 2:52

Member 9972251

11-Mar-15 2:52

After carefull reading and understanding this link "http://www.codeproject.com/Articles/42258/Particle-swarm-optimization-for-function-optimizat".
I was trying to use the code , but because i am using Visual Studio 2012 and the code is from 2009 maybe the errors that i found were because of the evolution of the C# languange.

Can someone with C# experience help me update the code for the new Version ?

Re: Updating Code For a Newer Version

Richard Deeming11-Mar-15 3:04

Richard Deeming

11-Mar-15 3:04

If you have questions about the code in an article, use the forum at the bottom of the article[^] to ask the author.

The person who wrote the code is the person most likely to be able to help you with it.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Last Visit: 31-Dec-99 18:00 Last Update: 23-Jun-24 5:49

Refresh

ᐊ Prev 1...988 989 990 991992993 994 995 996 997 Next ᐅ

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