|
First don't use bold on your question.
Check if string exists in database,if that string exists then don't insert otherwise do insert.
if (select count('stringvalue') from tablename where stringvaluecolumn='stringvalue')=0<br />
begin<br />
insert into tablename values('stringvalue')<br />
end<br />
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
you may want to do that in sql, database stuff you do in database ok?
ask if value exists?
NO can add to table
YES can´t add already there
(don´t know your database here)
create a procedure my_insert_procedure
@whatever varchar(50)
as
begin
if not exists(select * from my_table where whatever = @whatever)
begin
insert into my_table values (@whatever)
select 'OK: value added'
end
else
begin
select 'ERROR: that value already exists'
end
end
go
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hey guys.
How can we find windows Temp folder in c# ?
Like this :
C:\Documents and Settings\Mds\Local Settings\Temp
Thanks in advance.
|
|
|
|
|
System.IO.Path.GetTempPath() should about do it
--
Real programmers don't comment their code. It was hard to write, it should be hard to understand.
|
|
|
|
|
|
The previous answer is correct and is what I use but (for the sake of completeness) there's also
Environment.GetEnvironmentVariable("TEMP");
or
Environment.GetEnvironmentVariable("TMP");
<edit>Didn't see Giorgi's answer till after posting as it was on the next page!
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Expect everything to be hard and then enjoy the things that come easy. (code-frog)
|
|
|
|
|
Thanks a lot DaveyM69.
But I want to know is this correct :
Environment.GetEnvironmentVariable("temp");
|
|
|
|
|
It works (tried on XP Pro SP3) so I guess the string parameter isn't case sensitive. They are saved however in upper case so it would be safer to pass it that way.
You can see all the variables by opening control panel and selecting System (or right click My Computer and chose properties). On the Advanced tab click the Environment Variables button.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Expect everything to be hard and then enjoy the things that come easy. (code-frog)
|
|
|
|
|
Thank you very much DaveyM69.
|
|
|
|
|
I'm creating a simple remoting application on images and this is how my program goes. There's a server and there's a client and there's this DLL file that they commonly use so that they can communicate to each other remotely... The server contains the images. So when the client is executed, it contacts the server to get a specific image. So the request is successfuly sent to the server. The server found the image so it made use of the "Image theImage = Image.getFromFile('etc. etc.')" function.. it was successful, (i'm assuming the image now is in the "theImage" variable)... so the next thing the server to do now is to send the image back to the client to be displayed on a picture box... then BAAMM!! then the error popped out on the client side that "Native Image Not Found". How do i resolve this?
|
|
|
|
|
You'll want to be sending that image as a stream, then recreating a bitmap from that stream. It's quit simple really:
[server]
Bitmap img = new Bitmap(@"path");
Stream myStream = new MemoryStream();
img.Save(myStream, ImageFormat.Bmp);
...
[client]
Bitmap img = new Bitmap(myStream);
If this is what you'r already doing then err... I don't know. Sorry.
My current favourite word is: Nipple!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
yup.. i sent it as stream.. cause i thought you can just pass image objects that easy.. anyways thanks for the help
|
|
|
|
|
You can try out this.
In Server,
1. Read the image from the file.
2. Save the image onto a MemoryStream object.
3. Get the buffer from the MemoryStream using GetBuffer() method, this method will return the bytes from the memory stream.
Now you send this byte array to the client.
Now In Client,
1. Create new MemoryStream object and write the byte array received from server onto the MemoryStream.
2. Create new Image object from the MemoryStream using Image.FromStream() method and use this image object in the PictureBox.
Do more work
Make more mistakes
Learn more things
|
|
|
|
|
hi every body
i want know hot can i get the last word from string which inputed from user
example:
user entered:"my favorite song is ttt.mp3";
my question is how can i get "ttt.mp3" from the string
thanx every one
|
|
|
|
|
string txt = "some sample text";
string lastWord = txt.Substring(txt.LastIndexOf(" ")+1);
caveat: off the top of my head, not thoroughly unit-tested
|
|
|
|
|
ahmedhassan96 wrote: i want know hot can i get the last word from string which inputed from user
Two ways I can think of immediately:
String.Split()
or
String.LastIndexOf() and String.Substring()
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
split the string into an array using a space as the delimiter and get the last element in the array
or
identify the last space in the string and get the trailing characters
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
System.Text.RegularExpressions.Regex.Match(input, @"\S*$");
Edit: a better solution here[^].
Eslam Afifi
modified on Sunday, September 14, 2008 11:21 AM
|
|
|
|
|
Try this :
static void Main()
{
string temp = "my favorite song is ttt.mp3";
Console.WriteLine("Last word = {0}", Regex.Match(temp.Trim(), @"[^\s]*$" ).ToString() ) ;
Console.ReadKey();
}
|
|
|
|
|
I hate people who know regex - what an arcane, completely undecipherable load of...
Take 5
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Why burden the app with regex? Someone else gave what is, in my humble aopinion, a much better solution using LastIndexOf(" ") .
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
You're right.
Thank you John.
|
|
|
|
|
In my humble opinion, the LastIndexOf(" ") solution will fail in case of other white space characters or if the string contains one word only. In fact an expression like @"\S*(?=\s*$)" would be better as it matches the last non-whitespace character combination in the string.
Eslam Afifi
|
|
|
|
|
The OP's example CLEARLY indicatedc spaces were being used to separate words in a TextBox. What other kind of whitespace characters did you have in mind?
First, using RegEx obfuscates the intent of the code, and slows it down besides. I can count on ONE HAND the number of people I know that would use RegEx over the much simpler construct of LastIndexOf() . As soon as new programmers learn that readability and maintainability is much more important than "clever code", we'll all be a lot better off. Sure, RegEx has it's place, but not for this problem.
A valid example of requiring RegEx is validating that an email address is properly formatted. But for finding the last word in a string of words separated by spaces? Not on your life.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
John Simmons / outlaw programmer wrote: The OP's example CLEARLY indicatedc spaces were being used to separate words in a TextBox.
but the question stated
ahmedhassan96 wrote: hot can i get the last word from string which inputed from user
and he didn't explicitly mention the delimiter used.
Your post made me think of other white space characters such as Tab and NewLine (depends on how he gets the input string from the user). I'm aware that readability and maintainability is more important than clever code, and i wasn't trying to be clever. I just think a simple regex is much less in code than using LastIndexOfAny and handling the -1 return case.
Eslam Afifi
|
|
|
|