Re: How to set value of third column if first two are null in sql - ASP.NET Discussion Boards

Re: asp.net page size (height and width of tables are dynamicaly changed) - a very serious problem

ChrisKo4-Sep-07 8:42

4-Sep-07 8:42

You could set the validator Display property to "none" and use a ValidationSummary so you can move the error message into it's own table. This way, it's display doesn't affect your control layout.

how can insert master table information in separate page in crystal report?

B.A3-Sep-07 5:10

B.A

3-Sep-07 5:10

hi
i want to create a report with crystal report. my report has two table (master ,detail).
in this report each master information must be in separate page as page header and detail information must be in a table under header.

how can i create this report?

tanks

How to set value of third column if first two are null in sql

rahul.net113-Sep-07 5:05

rahul.net11

3-Sep-07 5:05

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

Re: How to set value of third column if first two are null in sql

Talal Sultan3-Sep-07 5:13

Talal Sultan

3-Sep-07 5:13

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

Re: How to set value of third column if first two are null in sql

B.A3-Sep-07 5:15

B.A

3-Sep-07 5:15

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.

Re: How to set value of third column if first two are null in sql

Christian Graus3-Sep-07 5:21

Christian Graus

3-Sep-07 5:21

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 )

Re: How to set value of third column if first two are null in sql

rahul.net113-Sep-07 6:16

rahul.net11

3-Sep-07 6:16

Thanks for reply but
what is Coalesce i dont know about it.Can u please tell me about that?

Thanks.

Rahul

Re: How to set value of third column if first two are null in sql

Christian Graus3-Sep-07 6:26

Christian Graus

3-Sep-07 6:26

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 )

Removing References

Brendan Vogt3-Sep-07 4:40

Brendan Vogt

3-Sep-07 4:40

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

Re: Removing References

Sandeep Akhare6-Sep-07 0:39

Sandeep Akhare

6-Sep-07 0:39

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... "

How to open uploaded files

n_gchaitra3-Sep-07 2:57

n_gchaitra

3-Sep-07 2:57

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

Re: How to open uploaded files

-- Abhi --3-Sep-07 3:12

-- Abhi --

3-Sep-07 3:12

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

Re: How to open uploaded files

n_gchaitra3-Sep-07 17:20

n_gchaitra

3-Sep-07 17:20

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

Re: How to open uploaded files

Sandeep Akhare3-Sep-07 4:08

Sandeep Akhare

3-Sep-07 4:08

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... "

Re: How to open uploaded files

n_gchaitra3-Sep-07 17:58

n_gchaitra

3-Sep-07 17:58

Even when i keep the files in the current application, how to open that? Are u suggesting Response.redirect

Chaitra N

Re: How to open uploaded files

Sandeep Akhare6-Sep-07 0:40

Sandeep Akhare

6-Sep-07 0:40

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... "

Image Editor for Asp.Net 2.0

Mustakim Mansuri3-Sep-07 2:44

Mustakim Mansuri

3-Sep-07 2:44

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

Re: Image Editor for Asp.Net 2.0

-- Abhi --3-Sep-07 2:52

-- Abhi --

3-Sep-07 2:52

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.

Re: Image Editor for Asp.Net 2.0

Mustakim Mansuri3-Sep-07 2:56

Mustakim Mansuri

3-Sep-07 2:56

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

Re: Image Editor for Asp.Net 2.0

-- Abhi --3-Sep-07 3:01

-- Abhi --

3-Sep-07 3:01

Hope you will find yourself..!!

Regards,

Abhi

Re: Image Editor for Asp.Net 2.0

Mustakim Mansuri3-Sep-07 3:02

Mustakim Mansuri

3-Sep-07 3:02

Not yet.

Please help me.

Thanks

Mustakim Mansuri

Email with embedded image

.NET- India 3-Sep-07 2:20

.NET- India

3-Sep-07 2:20

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.......

Re: Email with embedded image

varshavmane3-Sep-07 2:23

varshavmane

3-Sep-07 2:23

I suppose u need to upload that Image on server and then send it.

Re: Email with embedded image

.NET- India 3-Sep-07 2:27

.NET- India

3-Sep-07 2:27

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;
}

Re: Email with embedded image

varshavmane3-Sep-07 2:30

varshavmane

3-Sep-07 2:30

Please check whether that Image in there in Images Folder??

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