|
Hi
I am having one problem with sql query.In my application i am
taking candidate first and last name and showing them to a
column if in database both field are null then i want to show
his pet name in that column.How can i do this.Please guide me.
Ex:--If first name is john,last name is mathew and petname is abc then i
am showing fullname-john mathew if both field are null in database
then i want to show its pet name in that column
fullname--abc
Rahul
|
|
|
|
|
You can test the retrieved data against DBNull.Value and act accordingly.
Talal
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
hi
i think is better you remove allow null in your table and then set a default value such as '-' for when is not any thing for insert.
now you can simple manage your request.
|
|
|
|
|
You can use Coalesce to return a value only if previous values were null.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks for reply but
what is Coalesce i dont know about it.Can u please tell me about that?
Thanks.
Rahul
|
|
|
|
|
You can, for example, do this:
select coalesce(Name, '-') from table
I think the syntax is correct. This would return - if Name was null for a row.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi,
How do I remove references from my BIN folder? I added a reference, now I don't want to use it, so I deleted it manually, but when I build the website then it still goes and adds it.
What I did was I had Enterprise Library January 2006 installed. I removed it, and installed May 2007. Now when I build the website, it over wrote the 2.0 dlls with the 3.1 dlls.
Regards
.NET Enthusiast
|
|
|
|
|
I think you should remove it from project first go to bin folder of your application Explorer window then delete from there it will alos get deleted from project and bin folder
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
I am uploading files (.doc,.gif,.excel,etc) and storing in the server. Now I want to open those files when i click the link buttons. But I am able to get only the path but how to open it. what changes i need to the following code?
Dim SQLString As String = "SELECT filepath FROM pictures WHERE title = '" & BulletedList1.Items(e.Index).Text & "'"
Dim dr As Data.SqlClient.SqlDataReader
Dim comm As New Data.SqlClient.SqlCommand(SQLString, dbconn)
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
Dim str As String
dr = comm.ExecuteReader
While dr.Read
str = dr.Item(0)
End While
dr.Close()
TextBox1.Text = str
Chaitra N
|
|
|
|
|
You have to make a little change in your code..
Code:
=====
Remove this code
---------------
TextBox1.Text = str
Apply this code
---------------
1. Take a one image html control on the form. like.
2. In the server side , Write this code..
MyImage.Src = server.mappath("" + str);
Hope this will help you,
Regards,
Abhi
|
|
|
|
|
Thank you Abhi, but image control does not have Src property. I can open a picture file using imageurl property. But how to open other files?
Chaitra N
|
|
|
|
|
Where are you storing the uploaded files at server ?
if you want to open any of files then these files should be in current application Virtual directory or another virtual directoy
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Even when i keep the files in the current application, how to open that? Are u suggesting Response.redirect
Chaitra N
|
|
|
|
|
put the anchor tag and give the url of the file you want to open
sorry for late reply
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Hi
I need to impliment functionality for online image editing that support add text to image, rotate image, ovaerlap new image to existing image, zooming image.
Please give me refferance of such website that can provide tool for image editor.
Thanks in advance
Mustakim Mansuri
|
|
|
|
|
Try this site :
http://www.zazzle.com/
You can see the functionality and also get reference from it..
Good Luck..
God helps those, who helps other.
|
|
|
|
|
Hi
Thanks for giving reply.
I want same functionality as in http://www.zazzle.com.
I am finding tool that support this functionality.
If you know any component, free or paid please give me refferance.
Thanks
Mustakim Mansuri
|
|
|
|
|
Hope you will find yourself..!!
Regards,
Abhi
|
|
|
|
|
Not yet.
Please help me.
Thanks
Mustakim Mansuri
|
|
|
|
|
Hello Everyone,
Can anybody let me know how to send the images as an embedded image through an email in ASP.NET(1.1) with c#
Actually whenever i'm sending my this mail at my domain "mail@saamstesting.com" then it is great
But whenever i'm sending this mail at gmail, yahoo or other browsers then i'm just getting the successfull message not the image or mail.
And even i would like to tell u. I'm sending this mail as a HTML format
If someone has some ways plz let me know
Thnx.......
|
|
|
|
|
I suppose u need to upload that Image on server and then send it.
|
|
|
|
|
Here is the code plz have a look and that is uploaded on the server......
MailMessage mail1=new MailMessage();
mail1.To="manoj.msb1984@gmail.com,";
//mail1.To="mail@saamstesting.com";
mail1.From="mail@saamstesting.com";
//mail1.From="manoj.msb1984@gmail.com";
mail1.Subject="Welcome To Chinu Videos World!";
mail1.Priority=MailPriority.High;
//mail1.Body="Manoj Singh Bisht Do You Know Me";
mail1.BodyFormat=MailFormat.Html;
string body="Manoj Bisht
";
mail1.Body=body.ToString();
try
{
SmtpMail.SmtpServer="mail.saamstesting.com";
//SmtpMail.SmtpServer="127.0.0.1";
SmtpMail.Send(mail1);
lblMsg.Text="Mail Sent Successfully";
lblMsg.ForeColor=Color.DarkBlue;
}
catch(Exception ex)
{
lblMsg.Text=ex.Message.ToString();
lblMsg.ForeColor=Color.Red;
}
|
|
|
|
|
Please check whether that Image in there in Images Folder??
|
|
|
|
|
Yes that image exist in the Images folder
Here is the link given below
http://www.saamstesting.com/Images/GULFSTREAM II.jpg
|
|
|
|
|
Hello Sir,
Are u there............
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
