ASP.NET

FirstPrevNext

Re: how to open a page in new window [modified] Abhishek Sur15-Jul-09 5:08 Abhishek Sur 15-Jul-09 5:08  If it is an anchor tag, please ensure you are using html. Also if you want this anchor tag to be placed on an HTML document please use &lt;a href="http://dotnetblogengine.net" target="_blank" &gt;BlogEngine.NET&lt;/a&gt; rather than &lt;a href="http://dotnetblogengine.net"&gt;BlogEngine.NET&lt; target="_blank" /a&gt; as target ="_blank" is misplaced on your place. Abhishek Sur My Latest Articles Working with Excel using MDAC Basics on LINQ and Lambda Expressions Create .NET Templates modified on Wednesday, July 15, 2009 11:48 AM Reading Excel File Data ! rajg8215-Jul-09 3:43 rajg82 15-Jul-09 3:43  I'm reading excel file data using sql bulk copy and uploading the same inside sql server database: My current code is: public bool ImportMethod() { string sqlConnectionString = "Data Source=192.1.1.10;Initial Catalog=GePReleaseStatus;user=sa;password=sa;Integrated Security=True"; //Create Connection to Excel WorkBook using (OleDbConnection connection = new OleDbConnection(excelConnectionString)) { connection.Open(); OleDbCommand command = new OleDbCommand("SELECT SrNo AS SrNo,Module AS vcrModule,DefectNoClientName AS intDefectNo, FeratureID AS intFeratureID,Priority AS vcrPriority,Description AS vcrDescription FROM [eContract_4.0.13$]", connection); using (System.Data.Common.DbDataReader dr = command.ExecuteReader()) { // Bulk Copy to SQL Server using (System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(sqlConnectionString)) { bulkCopy.DestinationTableName = "ExcelData"; bulkCopy.WriteToServer(dr); return true; } } connection.Close(); } } Now the problem is:- 1) I'm unable to read the excel, as it has formatted cells at top ? (common error: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).) 2) how to read the excel from any particular row ? 3) Is it possible to read multiple sheets from a single excel file, how ? Thanks Raj raj problems with webservices!!!!!! shankbond15-Jul-09 3:28 shankbond 15-Jul-09 3:28  Hi, I am developing a webapplication in Visual Studio-2008(AsP.net/C#). I am trying to integrate my webapplication with webservice.The webservice is such that it will put all my request in asynchronous mode. My webapplication, I am sending a mail with Cc and Bcc fields, for the body of my mail I am using a rich textbox from richer components. Rich text box is used to send the data in formatted text. I am using the code below: Service webServ = new Service(); // Make an Asynchronous Call by calling the start method. webServ.BeginSendMailAll(dsRec, strSubj, RichTextBox1.Text , new AsyncCallback(WsCallback), webServ); while using the webservice how to implement: The Bcc and Cc in the code above. Also the body of the mail goes(to the recepient) in html format, instead of the fromatted text I am sending. please help me out thanks Re: problems with webservices!!!!!! Christian Graus15-Jul-09 3:35 Christian Graus 15-Jul-09 3:35  Sounds like you need to make changes to the actual webservice code to make it do what you want it to. Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: problems with webservices!!!!!! shankbond15-Jul-09 3:51 shankbond 15-Jul-09 3:51  any good ideas how? Re: problems with webservices!!!!!! DoctorMick15-Jul-09 6:28 DoctorMick 15-Jul-09 6:28  I usually use Visual Studio to change code. report viewer cann't run on internet Bhim Prakash Singh15-Jul-09 2:37 Bhim Prakash Singh 15-Jul-09 2:37  i have developed a web application, but i facing problem in reportviewer. recportviewer cann't run on internet plz help me Re: report viewer cann't run on internet Christian Graus15-Jul-09 2:48 Christian Graus 15-Jul-09 2:48  Is this a question ? If 'reportviewer can't run on the internet', then you need to find some other way of doing whatever it is you want to do, surely ? Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. IE8 font error when scrolling krishna.kommula15-Jul-09 2:23 krishna.kommula 15-Jul-09 2:23  Hi everybody, I have a pllication developed for ie(fully compatible with ie6) i want it to run in ie8 as well.so i added to emulate IE7 in the meta of my master page as follows <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" /> Every thing seems ok i have many drop downs in the page.i am using a css to set the dropdown properties font-size:11px; but when i scroll down the page and scroll back up again the text displayed in the drop down is streched vertically.When i point my mouse near the drop down control it comes back to the original size. I have tried all the css properties but no result; Can anyone suggest how i can solve this How to create a mobile application in ASP.Net Sabari MD15-Jul-09 1:05 Sabari MD 15-Jul-09 1:05  Friends, I need a good tutorial for creating mobile applications using ASP.net . Can any one suggest good links for that.... Sabari MD Application Developer Veloxit Info Solutions Re: How to create a mobile application in ASP.Net Christian Graus15-Jul-09 1:16 Christian Graus 15-Jul-09 1:16  You won't find any, because the question is illogical. ASP.NET apps are all mobile by definition, they run in the browser. They also run off a server, so you won't write something to run on a mobile device in ASP.NET. Or do you mean detecting the browser type and working out if it's a mobile device ? You don't need a tutorial, you just examine the browser type and redirect to a subsite that draws itself to fit, or write every page to change it's format accordingly. Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: How to create a mobile application in ASP.Net Manas Bhardwaj15-Jul-09 1:24 Manas Bhardwaj 15-Jul-09 1:24  These can be a good start for you. http://msdn.microsoft.com/en-us/library/aa286514.aspx[^] http://msdn.microsoft.com/en-us/library/ms178619.aspx[^] Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good. Re: How to create a mobile application in ASP.Net r a m e s h15-Jul-09 1:25 r a m e s h 15-Jul-09 1:25  Refere these links: http://blogs.msdn.com/trobbins/archive/2007/07/13/mobile-web-development-with-asp-net-2-0.aspx[^] http://www.asp.net/mobile/[^] Assign a value to a hidden field from javascript yesu prakash15-Jul-09 0:53 yesu prakash 15-Jul-09 0:53  Hi, How to assign a value to a hidden field from javascript in page load. eg: I when a page load the screen resolution is taken from javascript and assign to a hidden field, and i need to do some work using the hiddenfield in code behind When i try the value is assign in javascript but in code behind it shown blank in hiddenfield Thankyou YPKI Re: Assign a value to a hidden field from javascript Sabari MD15-Jul-09 1:00 Sabari MD 15-Jul-09 1:00  show your code first Sabari MD Application Developer Veloxit Info Solutions Re: Assign a value to a hidden field from javascript yesu prakash15-Jul-09 1:04 yesu prakash 15-Jul-09 1:04  function SetValue() { var width = screen.width; var height = screen.height; document.getElementById('hdnVal').value = width+'*'+height; } after i call the function window.onload = SetValue(); <script> Re: Assign a value to a hidden field from javascript Sabari MD15-Jul-09 1:07 Sabari MD 15-Jul-09 1:07  try by calling inside or inside Sabari MD Application Developer Veloxit Info Solutions Re: Assign a value to a hidden field from javascript Sabari MD15-Jul-09 1:14 Sabari MD 15-Jul-09 1:14  function SetValue() { var width = screen.width; var height = screen.height; document.getElementById("hdnVal").value = width+"*"+height; } chk this Sabari MD Application Developer Veloxit Info Solutions Re: Assign a value to a hidden field from javascript janani1315-Jul-09 1:10 janani13 15-Jul-09 1:10  print the value in alert and check whether it is called and its value. Re: Assign a value to a hidden field from javascript Christian Graus15-Jul-09 1:17 Christian Graus 15-Jul-09 1:17  I suspect your issue is that you use the server side id of the control. You need to use the ClientID property of the control to work out the id you need to pass to the client to search for the control. You can also use Firebug in Firefox to step through your js and see what is happening. Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: Assign a value to a hidden field from javascript yesu prakash15-Jul-09 1:22 yesu prakash 15-Jul-09 1:22  When i give in alert, the value is displayed in alert box, but it is empty in code behind. Re: Assign a value to a hidden field from javascript Christian Graus15-Jul-09 1:29 Christian Graus 15-Jul-09 1:29  Well, your code sucks because it called getElementById and does not check that something was returned. Have you tried what I suggested ? Are you SURE you're using the right client side id ? Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: Assign a value to a hidden field from javascript yesu prakash15-Jul-09 1:46 yesu prakash 15-Jul-09 1:46  contols i tried, <asp:hiddenfield id="hdnResolution" runat="server"> and i try getElementById and getElementsByName also both giving right result in alert box, but blank in code behind. A javascrprt error:'Not Implemented' also Re: Assign a value to a hidden field from javascript Christian Graus15-Jul-09 2:34 Christian Graus 15-Jul-09 2:34  ypki wrote: A javascrprt error:'Not Implemented' also So there is your issue. Again, you need to pass the client id through in your script. Just like I told you in my first reply Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: Assign a value to a hidden field from javascript yesu prakash15-Jul-09 2:59 yesu prakash 15-Jul-09 2:59  how?

Last Visit: 31-Dec-99 18:00     Last Update: 15-Jun-24 3:00 Refresh ᐊ Prev1...1767176817691770177117721773177417751776 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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