Hi All, I am able to read the file from database and save it as a mpp file. But when i tried to open in MS Project, its saying the following error, "Project cannot recognize this file format" The following is my code, DataSet ds = new DataSet(); SqlConnection con = new SqlConnection("data source=hariharan; initial catalog=ProjectServer; integrated security=true"); con.Open(); SqlCommand cmd = new SqlCommand("select reserved_binary_Data from MSP_PROJECTS where proj_name = 'TestProject.Published'", con); cmd.CommandType = CommandType.Text; SqlDataAdapter ada = new SqlDataAdapter(cmd); ada.Fill(ds); byte[] contentArray = (byte[])ds.Tables[0].Rows[0][0]; int len = contentArray.Length; FileStream docStream = new FileStream("C:\\testing.mpp", FileMode.CreateNew, FileAccess.ReadWrite); docStream.Write(contentArray, 0, len); docStream.Close(); con.Close(); Regards, Hariharan.

Hi All, My requirement is to read an image file from database and to save it as project file (.mpp) file in C# .Net Many thanks in advance. Thanks and Regards, Hariharan C

Hi Navaneeth, Thanks a lot for your kindly help. It's working fine now. Regards, Hariharan C

Hi, I would like to open a crystal report in a new window by passing two query strings. The code i am using as of now is as follows, protected void btnShowReport_Click(object sender, EventArgs e) { .. .. .. .. Server.Transfer("ReportViewer.aspx?ReportName=" + "rptCostByTaskLevel" + "&ReportFormat=" + format); } Could anyone help me on this above issue. Many thanks in advance. Thanks and Regards, Hariharan C

Can anyone specify a 3d geometry library with all functionalities.

Hi all, When i select a file to upload in the file upload control, I am not able to see the file name in the control after i selects the file. For eg: Suppose if i select a file from desktop, then in the file upload control i can see only "C:\Documents and settings", where i am not able to see the file name by default. Here my requirement is after i select the file to upload, I want the cursor to be get focused to the last in the control. So that I can see the file name as "\Desktop\Form.doc". Thanks and Regards, Hariharan C

Hi Michael, In the function "foo(event,id)", can you tell me what is the use of the event. See in my website I got this dropdown list in a formview insert template where it bound to the object data source. I have added your script to my master page. And the function calling is as follows, protected void FormView1_DataBound(object sender, EventArgs e) { switch (FormView1.CurrentMode) { case FormViewMode.Insert: ((DropDownList)FormView1.FindControl("DropDownList3")).Attributes.Add ("onkeypress", "javascript:return foo(event,'ctl00_ContentPlaceHolder1_FormView1_DropDownList3');"); break; } } But its not working in my page. So can you please help me on this. Dont worry Michael defenitely i am going to vote for you. Thanks in advance. Thanks and Regards, Hariharan C

Hi Michael, Now I have added one more dropdownlist and bound to the object data source(says Employee name). Then I tried to call your script, where its not working. Can you please tell me what I have to do now. Thanks and Regards, Hariharan C

Hi Michael, Very good morning. I just saw your reply after the weekend. You are correct. Yes i forget to uncomment the code. Now its working fine. Thanks a lot man. This is going to be very useful for me. Thanks and Regards, Hariharan

Hi Michael, I checked it again. For me its working fine for the first time only. Anyway Michael thanks a lot for your help. Thanks and Regards, Hariharan C

Hi Michael, Ya its working fine for me. Thanks a lot for your kind help. But again there is one small problem. When i type 'pe' it goes to 'Peter'. After that when i do it for the second time, its not working.(i.e After i typed 'pe', I wait for 1000 ms for the dropdownlist to select 'peter'. That's fine. Then I typed 'Ki', the dropdownlist has not select the name 'Kiran'. It selects "Indhu"). Have you checked that. If you know the answer let me know. Else again thanks a lot for your kind help. Thanks and Regards, Hariharan C

Hi Michael, Have you got the solution for me. I am not able to get it. So if you got the solution let me know please. Thanks and Regards, Hariharan C

Hi Michael, I have checked your code, its not working in IE6. There is a small doubt, is there 'onkeypress' event for Dropdownlist. Thanks and Regards, Hariharan C

Hi Michael, Yes its working fine in firefox. But its there any other way to make it work in IE. If you got the solution let me know it. Thanks and Regards, Hariharan C

Hi Michael, I dont have firefox in my system. Thanks for your help michael. Let me know if you find the solution for me. Thanks and Regards, Hariharan C

Hi Michael, I know there is a solution in Ajax. But if i select Ajax, then i will find difficult to implement in my project. So is there any solution without using Ajax. Thanks and Regards, Hariharan C

So if there is any custom controls you can help me. Thanks and Regards, Hariharan C

Hi all, There is a small requirement in drop down list. Suppose I have bounded the employee names to the drop down list. Now I am searching for a name “Peter”. So if I press ‘p’ and then ‘e’ it should go to Peter’s name. But it goes to Elizabeth’s name. Is there any solution for that? Could anyone of you please help me on that? I am using .Net version 2.0 Thanks and Regards, Hariharan C

Hi, What i meant is? If you go to any website there will be a text running in the home page. For eg.. log on to anna university website, you can see the latest news running. When you move the mouse cursor to that news it will stop. Then you can click and view the news. Like that I want to implement something in my home page. Regards, Hariharan C

Hi Deepak, I tried to run the statement you have provided "select * from deleted". But its saying "Invalid object name deleted". I am using SQL Server 2005. Regards, Hariharan C