Hi Friends, How to get a web page view source using sql stored procedure and then view source should be saved as a record in a table. Kindly please help me? Thanks & Regards Senthil Kumar.T.S

Hi Friends, I have used Ajax for paging in my application its work fine but when i click on my page at anywhere its getting a javascript error like top.screenleft is null or not an object when i debug it the error is pointing to ScriptResource.axd file. Please help me to give solution. Thanks

Hi Friends, I want to retreive the complete datagrid values from another website.Is it possible? Please can you give me the solution? Thanks & Regards Senthil Kumar

Hi Friends, In select html control,how to clear optgroup values(option group values)? Kindly help me..... Thanks & Regards Senthil Kumar.T.S

Hi Friends, I have a dropdownlistbox which contains all name of the colors like (white,black...) and another dropdownlistbox i am having font names when i select the color from the first dropdownlistbox the web page background color should be changed and when i select font names the web page title should be changed.Please help me how to do. Thanks in Advance

Thanks Mr.Christian Graus for your guidelines......

Hi Friends, I need to develop CMS Tool in ASP.NET,can anyone tell me how to develop CMS Tool in ASP.NET with examples,i have searched in google but i can't able to get it.So please help me.... Thanks & Regards Senthil Kumar

Hi Friends, I m doing crystal report in asp.net2.0 using c#,i have written the code for crystal report dynamically getting the database connection from web.config file and i have created the crystal report manually making the database connection mapping the stored procedure.I m getting the output correctly.The problem is if i need to change the database server name means i should change only in web.config file,but i have given the connection for crystal report in code behind and crystal report manually.When i change the database server name in web.config file its not getting the effect only when i connect crystal report manually its getting connected.Sorry for long comments here is the coding for database connection.Please help me to solve the solution protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { string from = ""; string id = ""; string to = ""; string mode = ""; from =Request.QueryString["FromDate"]; id = Request.QueryString["id"]; to = Request.QueryString["toDate"]; mode =Request.QueryString["mode"]; ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("TourOperator.rpt")); rd.SetParameterValue(0, mode); rd.SetParameterValue(1, id); rd.SetParameterValue(2, from); rd.SetParameterValue(3, to); GetServerName(rd); Session["torRep"] = rd; foreach (CrystalDecisions.CrystalReports.Engine.ReportObject obj in rd.ReportDefinition.ReportObjects) { if (obj.Name == "txtfromdate") { ((TextObject)obj).Text = from; } if(obj.Name=="txttodate") { ((TextObject)obj).Text = to; } } if (rd.Rows.Count > 0) { CrystalReportViewer1.Visible = true; CrystalReportViewer1.ReportSource = rd; CrystalReportViewer1.DataBind(); } else { CrystalReportViewer1.Visible = false; ltl.Text = "<b><font color='red'>No Records Found</font></b>"; } } else { CrystalReportViewer1.ReportSource = (ReportDocument)Session["torRep"];

Hi Mycroft Holmes, Thanks for reply whether it is possible to do in VB.NET using Serial Port if can.Give me some idea Thanks in Advance

Hi Friends, How to transfer datas from one computer to another computer using VB.NET.Kindly help me please. Thanks in Advance

Hi Vasudevan Deepak Kumar, I m passing querystring from javascript, as you told i have used escape(hid.value) but when i retreving the value at server side Request.QueryString["Path"].ToString() its not getting right path and also its getting half of the letter from filename.Please Help me Sorry for disturbing. Thanks in Advance

Hi Vasudevan Deepak Kumar, Thanks for reply i have one doubt whether we have to put UrlEncode(hid.value) in the querystring. Thanks in Advance

Hi Friends, How to pass FileName Path as querystring in javascript.I have passed like this var file='comment_popup.aspx?Path='+hid.value; when i put alert(file) its getting D:workReview115-02.xml but the path name should come like this D:\work\Review\15-02.xml.How to pass the correct path name as querystring please help me. Thanks in Advance

Hi, Sorry the details are displayed in textbox ie multiline textbox.Can you please tell me how to do. Thanks In Advance

Hi Friends, I am having a multiline text box which contains all details,another textbox is available which i have entered a word and click a find button it should highlight a particular word in a richtextbox like Find and Replace in windows.Can anyone help me how to do in javascript. Thanks in Advance

modified on Friday, May 23, 2008 3:48 AM

Hi Friends, I am updating and inserting excel datas from sql stored procedure alter PROCEDURE SP_ExcelMan @File_Name as varchar(50) = '' AS BEGIN SET NOCOUNT ON DECLARE @Cmd varchar(1000) DECLARE @fn varchar(500) DECLARE @provider varchar(100) DECLARE @ExcelString varchar(100) -- New File Name to be created IF @File_Name = '' Select @fn = 'D:\Test.xls' ELSE Select @fn = 'D:\' + @File_Name + '.xls' -- FileCopy command string formation SELECT @Cmd = 'Copy D:\Template.xls ' + @fn -- FielCopy command execution through Shell Command EXEC MASTER..XP_CMDSHELL @cmd, NO_OUTPUT -- Mentioning the OLEDB Rpovider and excel destination filename set @provider = 'Provider=Microsoft.Jet.OLEDB.4.0' set @ExcelString = 'Excel 8.0;HDR=Yes;Database=' + @fn -- Executing the OPENROWSET Command for copying the select contents to Excel sheet. exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT FirstName,LastName,Phone,Address,City,State,Zip FROM [Sheet1$]'') select au_fname as FirstName,au_lname as LastName,phone,address,city,State,Zip from authors') exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT StoreId, OrderNo, OrderDate, Quantity FROM [Sheet2$]'') select stor_id as StoreId,Ord_Num as OrderNo,Ord_Date as OrderDate,qty as Quantity from sales') SET NOCOUNT OFF END But i am getting the error Could not locate registry entry for OLE DB provider 'Provider=Microsoft.Jet.OLEDB.4.0'. OLE DB error trace [Non-interface error: Provider not registered.]. Please help me to clear the error Thanks in Advance

Hi Friends, Can anyone tell me how to get the datas from excel to ASP.NET and adding datas to excel from ASP.NET using C#. Thanks in Advance For Your Help.

Hi Friends, Can you tell me how to connect .CSV file with C# and retreive the values.As CG said by File.ReadAllText we can split the string and get the method.Can give me a example code so that i can get an idea, because i searched in google but i can't get the solution. Thanks & Regards Senthil Kumar.T.S

Hi Christian Graus, Can you give me a example? Please?

Hi Friends, How to retreive values from .CSV file in C#.Please help me how to do. Thanks & Regards Senthil Kumar.T.S