Re: Replace ImagePlaceHolder1 in Word 2007 with the image selected in Combo box in C#.net Windows Application - ASP.NET Discussion Boards

First Prev Next

Re: (DropDownList.DataSource == null) after postback

Łukasz Nowakowski10-Aug-10 8:10

Łukasz Nowakowski

10-Aug-10 8:10

Yeah... it is this way... I was writing this code from memory, not copied from Visual Studio. Sorry for mistake Smile | :)

Don't forget to rate answer, that helped you. It will allow other people find their answers faster.

Excel Error :(

Mugdha_Aditya10-Aug-10 3:12

Mugdha_Aditya

10-Aug-10 3:12

I'm sending mail with excel attchment and it's working fine when I run it from my local
machine. but if I try to access it from another machine it's giving me this
Error:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.

Error coming on first line of below code
Microsoft.Office.Interop.Excel.Workbook aBook;
Microsoft.Office.Interop.Excel.Application ExlApp = new Microsoft.Office.Interop.Excel.Application();

i have given all rights (http://blog.crowe.co.nz/archive/2006/03/02/589.aspx[^]) still error is coming
please help me out as soon as possible

Re: Excel Error :(

Paladin200010-Aug-10 3:51

Paladin2000

10-Aug-10 3:51

Please don't cross-post.

Re: Excel Error :(

Prosanta Kundu online10-Aug-10 18:07

Prosanta Kundu online

10-Aug-10 18:07

Don't cross post here. If anybody answers your previous question then you will be notified in your registered email.

More than one programmer working on the EF4 model file

Brendan Vogt10-Aug-10 2:48

Brendan Vogt

10-Aug-10 2:48

Hi,

We might want to use Entity Framework 4 for a project. Everything that we need is in the context. We have a couple of guys working on this project, how do we all work on the model if it creates just 1 file?

Is it possible to add additional properties to a class that was created?

Also, how would I use classes that I have created already in my project? Lets say I have a User class and a User class that the EF creates, what now?

Thanks

Replace ImagePlaceHolder1 in Word 2007 with the image selected in Combo box in C#.net Windows Application

raghvendrapanda10-Aug-10 0:02

raghvendrapanda

10-Aug-10 0:02

Hi,

I have created one template in MsWord 2007 and placed ImagePlaceHolder1 in it.I am able to find and replace the text but how to find ImagePlaceHolder1 in that Word Doc and replace with the one i select in the combo.
At the end I want to save it in .pdf format as shown below.

object format = Word.WdSaveFormat.wdFormatPDF;

_wordapp.ActiveDocument.SaveAs(ref save, ref format, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing);

Want to submit this project today.
Any help is appreciated.

Thanks,
Harish

Re: Replace ImagePlaceHolder1 in Word 2007 with the image selected in Combo box in C#.net Windows Application

Prosanta Kundu online10-Aug-10 18:02

Prosanta Kundu online

10-Aug-10 18:02

See the example in VB Code, How to find a imageplaceholder in the document

Selection.GoTo What:=wdGoToGraphic, Which:=wdGoToFirst, Count:=1, Name:=""
    Selection.Find.ClearFormatting
    With Selection.Find
        .Text = "ImagePlaceHolder1"
        .Replacement.Text = ""
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With

Also this [link] might help you.

Re: Replace ImagePlaceHolder1 in Word 2007 with the image selected in Combo box in C#.net Windows Application

raghvendrapanda10-Aug-10 22:42

raghvendrapanda

10-Aug-10 22:42

Instead of place holder i placed 'Sign1' Text in Word 2007 with this i tried your code to replace it with image but iam getting System.Drawing.Bitmap in .pdf while saving instead i should .jpg image

Below is my code
object[] Parameters;
Parameters = new object[15];
Parameters[0] = "Sign1";
Parameters[1] = _missing;
Parameters[2] = _missing; ;
Parameters[3] = _missing; ;
Parameters[4] = _missing; ;
Parameters[5] = _missing;
Parameters[6] = _missing;
Parameters[7] = _missing;
Parameters[8] = _missing;
Parameters[9] = img;
Parameters[10] = _missing;
Parameters[11] = _missing;
Parameters[12] = _missing;
Parameters[13] = _missing;
Parameters[14] = _missing;
myfind.GetType().InvokeMember("Execute", BindingFlags.InvokeMethod, null, myfind, Parameters);

I am getting from img = GetSignPath();//method used to
Clipboard.SetDataObject(img);

i am getting img from below mentioned code inside GetSignPath();
MemoryStream ms = new MemoryStream((byte[])ds.Tables[0].Rows[0]["SignatureImage"]);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);

imgPath = "C:\\" + comboempname.Text + ".JPG".Trim();
img.Save(imgPath);
//return imgPath;
return img;

Any Help is Appreciated

Thanks,
Harish

hex string to sql and to website

meenu s9-Aug-10 12:32

meenu s

9-Aug-10 12:32

dears,i am using vs2005 web application.

one image information in hex format is like as follows.

000125262728292A3435363738393A434445464748494A535455565758595A636465666768696A737475767778797A838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE1E2E3E4E5E6E7E8E9EAF1F2F3F4F5F6F7F8F9FAFFC4001F0100030101010101010101010000000000000102030405060708090A0BFFC400B51100020102040403040705040400010277000102031104052131061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A262728292A35363738393A434445464748494A535455565758595A636465666768696A73740D0A

my requirement is this hex data need to store in sql db and need to display in a website.
can anybdy help me to solve my problem??

In sql i inserted this data in an image coloumn like as follows(added ox).

INSERT INTO [Test_mm].[dbo].[PictureTable]
([Title]
,[DateAdded]
,[MIMEType]
,[Image])
VALUES
('jjj'
,'6/22/2010 3:12:04 PM'
,'hjhg'
,0x000125262728292A3435363738393A434445464748494A535455565758595A636465666768696A737475767778797A838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE1E2E3E4E5E6E7E8E9EAF1F2F3F4F5F6F7F8F9FAFFC4001F0100030101010101010101010000000000000102030405060708090A0BFFC400B51100020102040403040705040400010277000102031104052131061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A262728292A35363738393A434445464748494A535455565758595A636465666768696A73740D0A)

after inserting the data i tried to display this using the code below.But the picture box is coming with a red colour cross button?

Dim ImageID As Integer = Convert.ToInt32(Request.QueryString("ImageID"))
Using myConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("NorthwindConnection").ConnectionString)
Const SQL As String = "SELECT [MIMEType], [Image] FROM [PictureTable] WHERE [ImageID] = @ImageID"

Dim myCommand As New SqlCommand(SQL, myConnection)
myCommand.Parameters.AddWithValue("@ImageID", ImageID)

myConnection.Open()
Dim myReader As SqlDataReader = myCommand.ExecuteReader

If myReader.Read Then
Response.ContentType = myReader("MIMEType").ToString()
Response.BinaryWrite(myReader("Image"))
End If

myReader.Close()
myConnection.Close()
End Using

can anybdy help me to solve this ?i am troubling lot..pls pls help me

MEENU

Question about saving an image to SQL database

Aptiva Dave9-Aug-10 10:09

Aptiva Dave

9-Aug-10 10:09

Okay, here is my problem: I've got a web site that allows users to edit their profile. Part of this profile information will be used to populate a contact page which will include a picture of the user. Now, I'm able to upload the pictures just fine into a sql 2005 database and display that image, but if the user doesn't add an image (which they are allow not to do) then I get stuck on how to populate that into my sql stored procedure's parameter list. I keep getting an error every time I try saving the profile without an image in the file upload box. Here is the code that I am using to try to put in a dbnull value:

cmd.Parameters.AddWithValue("@picture", SqlDbType.Image).Value = DBNull.Value

Any ideas on what I'm doing wrong?

Re: Question about saving an image to SQL database

NeverHeardOfMe9-Aug-10 10:32

NeverHeardOfMe

9-Aug-10 10:32

That doesn't look right to me. Can't you just put

cmd.Parameters.AddWithValue("@picture", DBNull.Value)

?
(Assuming your "picture" field allows nulls, of course...)

Re: Question about saving an image to SQL database

InderK10-Aug-10 1:29

InderK

10-Aug-10 1:29

I guess make image field mandatory or call this method only if there is value in @picture.

Thanks,
RK..

Thread from code behind aspx

devvvy9-Aug-10 2:34

devvvy

9-Aug-10 2:34

hello

Can I start a thread from aspx code behind (long running stored proc call)

Thread SomeThread = new Thread(this.RunLongRunningCommand);
SomeThread.Start(SomeArg);

I'm worried aspx page worker's thread life cycle.

dev

Re: Thread from code behind aspx

Prosanta Kundu online9-Aug-10 2:52

Prosanta Kundu online

9-Aug-10 2:52

Check this
1. [Threading in ASP.NET]
2. [Multi-Threading in ASP.NET]

Re: Thread from code behind aspx

NeverHeardOfMe9-Aug-10 3:27

NeverHeardOfMe

9-Aug-10 3:27

As an alternative to using System.Threading, which I have to admit I find a difficult class to get to grips with, can I suggest an alternative method for executing a long running process (LRP) within as ASP.NET appliucation...

..this is only of any real use when you can set up your LRP in such a way that you can execute it by passing just an ID number (say to a database record), or at least only a relatively small amount of data to it via a QueryString.

Set up your LRP within a generic handler, say "lrp.ashx"

Them, in your webapage when you want to execute this, add:

Try
   Dim request As System.Net.HttpWebRequest = DirectCast(System.Net.WebRequest.Create(HttpPathOf("lrp.ashx")), System.Net.HttpWebRequest)
   request.Method = "POST"
   request.ContentType = "application/x-www-form-urlencoded"
   Dim postData As String = "id=" & nid.ToString  ' for example - set up whatever data you need to post to the handler here
   request.ContentLength = postData.Length

   Dim writer As New System.IO.StreamWriter(request.GetRequestStream(), System.Text.Encoding.ASCII)
   writer.Write(postData)
   writer.Close()

Catch ex As Exception
   ' whatever
End Try

Note: by

HttpPathOf("lrp.ashx")

I mean the full URL (ie starting "http://www.mydomain...." to lrp.ashx - you can't just use a relative URL or Server.MapPath

The above code will execute lrp.ashx in a new process, adn you can (for example) immediately redirect to another page while it is still executing, adn yor users will never know....

Perhaps someone here willl tell me why I shouldn't be doiung this, but I've found it works very well Smile | :)

And no, I can't translate it into C#! Poke tongue | ;-P

Need example code for making an universal table editor...

Hrizip8-Aug-10 21:14

Hrizip

8-Aug-10 21:14

I have just gotten my new assignment; which is to design an universal (generic) table editor in ASP.NET, that fetches data from SQL and is able to CRUD this data.

I quess this is a well known area to most experienced ASP.NET developers (I have just started with ASP.NET) so I presume there are solid code examples "out there".

I would be most thankful if someone provided a good solid example for the above mentioned.

Thanks in advance.

Re: Need example code for making an universal table editor...

R. Giskard Reventlov8-Aug-10 21:48

R. Giskard Reventlov

8-Aug-10 21:48

Have you tried Googling[^]?

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

Re: Need example code for making an universal table editor...

Hrizip9-Aug-10 1:41

Hrizip

9-Aug-10 1:41

I have spent the entire day googling for the info, found most of it, here are the two best sites with the needed info:

http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-cs[^]

http://weblogs.asp.net/scottgu/archive/2006/01/15/435498.aspx[^]

sum of work hours in rdlc

Thanusree Duth8-Aug-10 19:14

Thanusree Duth

8-Aug-10 19:14

It is easy to calculate the SUM of Integers or Float values using Aggregate function 'SUM' in RDLC Report Viewer. But I am unable to calculate the SUM of Total Hrs Worked for an employee.Datatype of Total Hrs is varchar.That creates error.Is there any way out for this?Please suggest a wy to calculate sum in rdlc. Roll eyes | :rolleyes:

Re: sum of work hours in rdlc

Tej Aj9-Aug-10 23:54

Tej Aj

9-Aug-10 23:54

Check this latest post for ur issue:

http://opexsolution.com/forum/viewtopic.php?f=15&t=82[^]

Fan of:
http://www.abtstudioz.com/[^]

POP Up control Extender validation

Amit Patel19858-Aug-10 19:01

Amit Patel1985

8-Aug-10 19:01

Hi All,

I have one Ajax ModalPopupExtender whose target id is one panel when inside panel i have say 2 text box say name and lastname

this contains one add button . validation i can do through java script but if i enter something here i want to check whether user exist or not if exist then this pop up should not go ...but it goes i can show it again through show javascript function
but it looks really odd

how to fix this issue.

Thanks,

amit

Re: POP Up control Extender validation

T M Gray9-Aug-10 11:17

T M Gray

9-Aug-10 11:17

I think you should use a CustomValidator and an UpdatePanel inside the Panel that is displayed by the ModalPopupExtender.

Re: POP Up control Extender validation

Amit Patel19859-Aug-10 19:42

Amit Patel1985

9-Aug-10 19:42