Re: Question about using an if in a string - C# Discussion Boards

Re: Question about using an if in a string

BillWoodruff1-Sep-13 19:42

1-Sep-13 19:42

I strongly agree with Dave's feedback that you need to get a good basic book on .NET, and go over the fundamentals: you are "spinning your wheels here."

Try this free book from the renowned educator Charles Petzold, ".NET Book Zero:" [^]. From that site you can download either a .pdf file, or an .xps version of the book, and a separate .zip file is available there for download that contains all the code examples in the book.

good luck, Bill

Google CEO, Erich Schmidt: "I keep asking for a product called Serendipity. This product would have access to everything ever written or recorded, know everything the user ever worked on and saved to his or her personal hard drive, and know a whole lot about the user's tastes, friends and predilections." 2004, USA Today interview

Re: Question about using an if in a string

OriginalGriff2-Sep-13 3:58

OriginalGriff

2-Sep-13 3:58

No, no, it just doesn't work like that!

Forget computers for a moment, and suppose you are on the phone, talking to a company. The lady at the other end asks you a question "What is your name?"
You reply "Skeeterz".

Does that move you physically into her company, or automatically create a file in her computer?
Of course not! That would be silly...

What it does do is transfer a small amount of information from one place (your home) to another (her office) - and she will make a note of it by jotting it on a piece of paper, perhaps, or typing it into her computer to see if there is any information on you allready.

The computer program you wrote does the same thing: It asks "What is your name?" and the user replies "ashley" - that transfers the information from the user space into the program space, and stores it in memory, putting a "reminder" for what her name is into the variable "herName". In future, whenever you want to use the users name, you just use the variable "herName":

Console.WriteLine("Hello " + herName + " and welcome!");

UserDetails herInfo = LookupInTheDatabase(herName);

This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre.
Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.

Re: Question about using an if in a string

AmitGajjar2-Sep-13 20:10

AmitGajjar

2-Sep-13 20:10

Quote:
Does that move you physically into her company, or automatically create a file in her computer?
Of course not! That would be silly...

Hahaha that would be awesome if person can physically move... kind of Mass transfer of human being!!! You will see in sci fi movies.

Thanks
-Amit Gajjar

Re: Question about using an if in a string

OriginalGriff2-Sep-13 21:24

OriginalGriff

2-Sep-13 21:24

Um. Might have side effects[^]

Re: Question about using an if in a string

Dave Kreskowiak2-Sep-13 5:58

Dave Kreskowiak

2-Sep-13 5:58

skeeterz71 wrote:
The string with the name ashley would be created at that time

Ok, think about this. You just said that if the user types a string into the Console or into a TextBox that a variable with the same name would be created. That's absurd for the following reason: What if the user typed:

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis cursus justo arcu, quis euismod sapien blandit malesuada. Nam nisl augue, ornare id ipsum a, tristique feugiat justo. Donec sed eros id metus aliquam egestas. Donec fermentum condimentum mollis. Donec at auctor velit, non elementum purus. Maecenas congue, turpis non rutrum feugiat, magna ligula iaculis libero, eget aliquam erat magna at erat. Proin at mauris scelerisque, ultrices ipsum ac, mollis magna.

?? You really think a variable with that name is going to be created??

Seriously, you REALLY need to pickup a beginners book on C#. You will only serve to frustrate yourself if you don't properly learn the fundamentals.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Question about using an if in a string

blitzkrieged2-Sep-13 14:16

blitzkrieged

2-Sep-13 14:16

Check to make sure the user entered anything by checking if the string is whitespace or null.
Checking if it is null is the most important.

Console.WriteLine(name + " What is her name?");
String herName = Console.ReadLine();
if(!String.IsWhiteSpaceOrNull(herName))
{
    if(herName == "ashley")
    {
    do this stuff..
    }
}

Re: Question about using an if in a string

liveoffedge2-Sep-13 0:15

liveoffedge

2-Sep-13 0:15

Hi, use this
if (herName == "ashley") instead of

if (herName == ashley)

This will resolve your error.

Re: Question about using an if in a string

OriginalGriff2-Sep-13 3:49

OriginalGriff

2-Sep-13 3:49

Reason for my vote of one: Three hours after Dave had posted this solution, with much better detail as to why to do it, you post exactly the same thing? How exactly is that supposed to help the OP?

Re: Question about using an if in a string

Keith Barrow2-Sep-13 6:21

Keith Barrow

2-Sep-13 6:21

For someone who posts in Q&A so much, I'm shocked at your shock Smile | :)

PB 369,783 wrote:
I just find him very unlikeable, and I think the way he looks like a prettier version of his Mum is very disturbing.[^]

Re: Question about using an if in a string

skeeterz713-Sep-13 6:30

skeeterz71

3-Sep-13 6:30

Thank you! that worked. I really appreciate your help. I got a lot of suggestions here and yours is the only one that worked.

Re: Question about using an if in a string

AmitGajjar2-Sep-13 20:02

AmitGajjar

2-Sep-13 20:02

As other suggested, You have problem with the if condition. First you need to learn about the difference between variable and it's value. In the given if condition you have herName as variable of type string. Now you need to compare string with string only. That could be possible either by comparing string variable like,

string storedName = "ashley";
if(herName == storedName)

Or by directly comparing string with the variable like,

if(herName == "ashley")

Before go for the solution oriented learning just read one of the beginner book or online materials(MSDN) to understand concepts.

Thanks
-Amit Gajjar

Distinct Row or Rows in a datatable

smh139231-Aug-13 22:00

smh1392

31-Aug-13 22:00

Hi There !
in myTable I have 4 fields , MyId,FName,Lname,Year,Code
I want to Filter "Code" when the "Year" Field is equel to TextForm Like 2005 or --> Year=2005.

try
{
  OleDbConnection ocn = new OleDbConnection(ConnectionString);
  OleDbDataAdapter oda = new OleDbDataAdapter(@"SELECT MyId,FName,Lname,Year=<a href="/Members/P1">@p1</a>,Code,FROM myTable WHERE Code=<a href="/Members/P2">@p2</a>", ocn);
  oda.SelectCommand.Parameters.Clear();
  oda.SelectCommand.Parameters.AddWithValue("<a href="/Members/P1">@p1</a>",txtYear.Text);
  oda.SelectCommand.Parameters.AddWithValue("<a href="/Members/P2">@p2</a>",txtCode.Text);
  DataTable dt = new DataTable();
  dt.Clear();
  oda.Fill(dt);
  if (dt.Rows.Count > 0)
    {
      MessageBox.Show("This Code Used Before");
      txtCode.Focus();
    }
  else
   {
      ...

Thanks a Lot

modified 1-Sep-13 4:26am.

Re: Distinct Row or Rows in a datatable

Mycroft Holmes31-Aug-13 22:42

Mycroft Holmes

31-Aug-13 22:42

Very difficult to read with the corrupted formatting.

I think the following may be what you want

Select Count(*) from MyTable where Year = @P1 or Code = @P2

Use executescalar and box the return as an int and test that value

Never underestimate the power of human stupidity
RAH

Re: Distinct Row or Rows in a datatable

smh13922-Sep-13 10:48

smh1392

2-Sep-13 10:48

Thanks
Excuse me for bad to Read :
a simple instance is Here :
I want to Edit my Records , and Prevent the Duplicate Records e.g. :
----------------------------------

YearReg                 RegNo
  1950                    112
  1950                    102
  1951                    110
  1950                    114

-----------------------------------
For example in The All Records that Year is 1950 , RegNo shoulbe Unique and if Year=1951 , RegNo also unique and etc.
heres my code For EditButton Click :
...

string strQ = @"SELECT COUNT(RegNo) FROM tblRcvLet WHERE YearReg=@s1"
OleDbDataAdapter oda_Edited = new OleDbDataAdapter(strQ, ocn);
oda_Edited.SelectCommand.Parameters.Clear();
oda_Edited.SelectCommand.Parameters.AddWithValue("  @s1", txtYearReg.Text);
DataTable dt_Edited = new DataTable();
dt_Edited.Clear();
oda_Edited.Fill(dt_Edited);
if (dt_Edited.Rows.Count > 0)
   {
      MessageBox.Show("Already Exists!! ");
      txtRegNo.Focus();
    }
   else
   {
   OleDbCommand ocmd_Edited02 = new OleDbCommand();
    ocmd_Edited02.CommandText = @"UPDATE ....

But I can Not Edit(Update) Records ...
Thanks a Lot

Re: Distinct Row or Rows in a datatable

susanna.floora1-Sep-13 19:09

susanna.floora

1-Sep-13 19:09

You can use datatable select option
string sql ="string strCondition = string.Format("Year = '{0}'", 2005);
DataRow[] row = dt.Select(strCondition);

Re: Distinct Row or Rows in a datatable

Mycroft Holmes1-Sep-13 19:52

Mycroft Holmes

1-Sep-13 19:52

I learn or relearn something every day - my excuse, I use collections these days. Blush | :O

Never underestimate the power of human stupidity
RAH

Put DLL file to another location

Midnight Ahri31-Aug-13 14:43

Midnight Ahri

31-Aug-13 14:43

I always put component dll in Application.StartupPath so user is able to run the application.
Is it possible to put it to another location to keep the application working?
Example location:

Application.StartupPath + @"\DLL\"

Edit:
I found this but I don't really understand it.
http://stackoverflow.com/questions/2445556/c-sharp-putting-the-required-dlls-somewhere-other-than-the-root-of-the-output[^]

Re: Put DLL file to another location

Dave Kreskowiak31-Aug-13 15:10

Dave Kreskowiak

31-Aug-13 15:10

Yes, it's possible. See this[^].

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Put DLL file to another location

Abhinav S31-Aug-13 15:51

Abhinav S

31-Aug-13 15:51

Absolutely yes.
You can keep the dll anywhere you want including the GAC where it could be shared across many applications.

Apps - Color Analyzer | Arctic | XKCD | Sound Meter | Speed Dial

How to get user names accessing ACCESS database

BajrangSingh31-Aug-13 8:22

BajrangSingh

31-Aug-13 8:22

HI,

Is there any way to find out user names who are currently accessing ACCESS database using C# window application.

Please suggest a solution.

Thanks

Bajrang

Re: How to get user names accessing ACCESS database

Dave Kreskowiak31-Aug-13 8:29

Dave Kreskowiak

31-Aug-13 8:29

Generally, no. Access is a file-based desktop database. It doesn't have all of the facilities of a real SQL server.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: How to get user names accessing ACCESS database

BajrangSingh31-Aug-13 9:32

BajrangSingh

31-Aug-13 9:32