Hi Thanks for reply but i dont wants to generate pdf from crsytal reports. I already have pdf form file and wants to write into it. i dont know the fields name and i wants to write it . is there any way to write in a pdf form,and you dont know the name of the form fields????

Hi, It is big procee Let give you hint Use the OleDbProvider and open the file and file in to data set and update to database ExcelConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties="Excel 8.0;HDR=YES";Data Source = " & ExcelFilePath strSQL = "select Col1,Col2 from [Sheet1$]" SomeDataAdapter = New OleDbDataAdapter(strSQL, ExcelConnectionString ) have SomeDataSet declared daCollateral.Fill(SomeDataSet, ) try this if not i can help you Chinna Srihari Tech Lead, Capgemini

thanks for the help, that i did but it shows more than 4000 records while my excel file contains only 500 and the problem is that how i will transfer the same into sql tables

Two steps 1. Read Excel file into a dataset. http://www.codeproject.com/csharp/Excel_using_OLEDB.asp[^] 2. Insert values from dataset into sql server table.

yes installed. is there any way any dll in .net to send fax i don't wants to use com object any example ?

You could use Forms authentication. What I usually do is place the pages I want to secure in a separate folder than the web site's root, then secure that folder. You can either use a separate (partial) web.config in that folder, or you can use the location element to control access. For example, a typical web.config might look like (fragment): <authentication mode="Forms"> <forms loginUrl="AccessDenied.aspx" name="SomeAuthCookieName" timeout="60" path="/" /> </authentication> <authorization> <allow users="?" /> </authorization> <location path="SecuredFiles"> <system.web> <authorization> <allow roles="SpecialPeople" /> <deny users="*" /> </authorization> </system.web> </location> In the example above, anything in the root folder would be accessible to pretty much anyone who visited the site (test2.aspx in your example would go at the root, as would login.aspx). Anything in the SecuredFiles folder would be unbrowsable to anyone not in the SpecialPeople role (so, test1.aspx would go in there). Hope this helps. The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’

null means that the object does not reference an instance of any object. When you declare a variable, but have not set a value to it, it is null. When you query a database, you get back the values stored in the columns you requested. The column exists (or you would get an error), so the Item is not null; it references an object representing the value of the database column for that DataRow. The .net framework provides a special value (System.DBNull) that you can use to see if the value of the Item is Null in the database.

variable? do you mean something like that: [web.config] ... <appSettings> <add key="myKey" value="myValue"/> </appSettings> ... [application] string myValue = System.Configuration.ConfigurationSettings.AppSettings["myKey"]; ? More on MSDN[^] best regards, David 'DNH' Nohejl Never forget: "Stay kul and happy" (I.A.)

Here[^] Mazy "One who dives deep gets the pearls,the burning desire for realization brings the goal nearer." - Babuji

I'm sure there is some way to do it solely in Javascript, but it would be really freakin' hard. A much better way to do it would be on the back-end with something like asp/jsp/perl/php/etc.

The System.Drawing.Image class exposes width and height properties. How are you retrieving the image (into what kind of structure, I mean)? I assume that if you're storing it as a BLOB in the database, you're retrieving it as a byte[] initially. If so, you should be able to create a memory stream from the byte array, and use the stream to create an Image instance. The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’

how can i fix when the page runs it again shows the minimum width and height

NO,i would like to know that How can i fix height or width of a cell in datagrid. i wants all cells should have the same width ; height may differ.

What I would do is count the number of records I received, subtract from the number of lines I want, and make that the number of blank lines the page needs to create after the last response. 5 total lines - 1 response = 4 blank lines 5 total lines - 5 responses = 0 blank lines etc. Just statically set the number of total lines to the ammount of space you want to take up.

Hi: It is pretty simple. Check out http://www.systemwebmail.com/ [^] for tricks and code snippets using System.Web.Mail namespace. You can also use Persits MailSender ASPEmail component using COM Interop. Check it out at http://www.aspemail.com/[^] Deepak Deepak Kumar Vasudevan Personal Web: http://vdeepakkumar.netfirms.com/ I Blog At: http://deepak.blogdrive.com/

Fair enough. I remembered the other two posts, and that they had some truly good suggestions along with them. As I didn't really have anything to offer, I admit that I didn't follow them to the end. In this third thread, it just seemed to me that you were looking for something that you weren't getting. My reply was intended to, perhaps, point you to a place that you may find what you're looking for. I meant no insult or disrespect... and if my reply was taken that way, please accept my apologies. --Jesse