13,153 Topics
 | |
 | This is my code : [CODE] icrosoft.Office.Interop.Excel.Application(); string filePath = Server.MapPath(@"~\\Staf\\TestLucene\\" + strFileName.ToString()); Microsoft.Office.Interop.Excel.Workbook workbook = application.Workbooks.Open(filePath, Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing, Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing); int numSheet = workbook.Sheets.Count; for (int num = 1; num < numSheet + 1; num++) { Microsoft.Office.Interop.Excel.Worksheet sheet = (Worksheet)workbook.Worksheets[num]; Range excelRange = (Range) sheet.get_Range("A1", "H10"); object[,] valueArray = (object[,])excelRange.Value2; for … |
| | good day, im practicing databases and .net, can you help me in relating multiple tables and manipulating a listview? my scenario is about school subjects of a student, i have a database with data that has 2 tables, which is 'fnsh_table' and 'ofrd_subjects' fnsh_table Student_No nchar(4) Subj_No nvarchar(10) Title nvarchar(20) … |
| | Hello, So I am using microsoft visual C++ 2010 and I was wondering is there a way to avoid using .NET implementations? If so, what would I need to do and what are the drawbacks. Thanks  |
| | I getting an error that one when click on the Export Button in the show shows the data of GridView Along with PageIndexing NUmbers also [CODE] protected void btnexcel_Click(object sender, EventArgs e) { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=Emp.xls"); Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); GridView1.RenderControl(htw); … |
| | |
| | hi there, i have been asking this question every time. [CODE] public bool ValidateTelNo(string TelNo) { bool value = false; string rePhoneNumber = @"[1-9]\d{2}\s?\d{3}\d{4}$"; string PhoneNoFormat = @"\([1-9]\d{2}\)\s?\d{3}\-\d{4}$"; Regex re = new Regex(rePhoneNumber); Regex re1 = new Regex(PhoneNoFormat); if (re.IsMatch(TelNo) || (re1.IsMatch(TelNo))) value = true; else value = false; return …  |
| | Hello, I currently have hashed passwords in my database. I want to set them for clear. I do not care about any kind of security. I just want plain, simple passwords. I don't even care if I have to delete all my users and start over fresh. I desperately have … |
| | Hi everyone I have created a GridView having Columns as Marks1,Marks2,Marks3 and total the values of marks are entered through SQL Query and The GridView is bind to dataset now i want to Display Total in the front end not through the Sql query Please help me in this Regard!!! |
| | Dear Friends, I have developed 3 asp.net applications deployed in 3 different servers located in the same domain. All servers running win2003 server and IIS 6. Currently a user required to login 3 times if he planned to use all 3 applications. I would like to make it in such …  |
| | [code] cmd=new sqlcommand("insert_student",con) cmd.commandtype=commandType.StoredProcedure Add.Parameters.AddwithValue("@stuid",txtstuid.text) Add.Parameters.AddwithValue("@name",txtname.text) Add.Parameters.AddwithValue("@course",txtcourse.text) con.open() cmd.ExecuteNonQuery() [/code] i want to create method for executing procedure but how it possible... [code] Function ExecuteStoredProc(Proc as String) cmd=new sqlcommand(Proc,con) cmd.commandtype=commandType.StoredProcedure Add.Parameters.AddwithValue(????,?????) con.open() cmd.ExecuteNonQuery() end function [/code] how to call this function can anybody help me......... |
| | hi, i've got error like this : CS0012: The type 'Microsoft.Office.Core.MsoTriState' is defined in an assembly that is not referenced. You must add a reference to assembly 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. whats wrong?? |
| | Hello everyone ive been going crazy looking for a tutorial or something that would do what i need. i want to make a website that user register and have a profile and they can exchange books with others example: [url]www.alacan.com[/url] where it says libros its in spanish i posted here … |
| | Hello, Does anyone know any code or control used to allow clients to manage their own articles/news (text + images) on their asp.net websites? I mean only text and images with exact structure, not modifying the whole layout. Thank you |
| | I have search on google about the polling application and i have not yet got the proper solution so that i can understand. Can anyone help me where can i find this which can help me to develop this web app for my company. Thanks |
| | Hi there, I have a question in EncryptByPassPhrase. I am trying to encrypt the source column in the database table PForm. When I run the code it sasys, “Failed to convert parameter value from a String to a Byte[].” the SourcePath column in the database is varBinary(256) type. What is … |
| | Hi All, I am working in an web application where I getting inputs from user for number of controls to be displayed in the form. I am generating that number of controls dynamically. Now I want to allow my user to change or drag the controls in the screen and … |
| | hi... i have one application.. when i run that application the data is shown correctly and also with proper alignment.. i have hosted that application.. but in hosted application the report header size is reduced and the bank name and the narration values are same..(those should be separate) the problem … |
| | [ICODE]it won't show any error but after clicking the update it show the previous data again[/ICODE] [CODE]protected void gvdatatable_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { GridViewRow row = (GridViewRow)gvdatatablle.Rows[e.RowIndex]; Label lbl = (Label)row.FindControl("lblid"); TextBox txt1 = (TextBox)row.FindControl("txtpassword"); TextBox txt2 = (TextBox)row.FindControl("txtconpassword"); TextBox txt3 = (TextBox)row.FindControl("txtemail"); gvdatatablle.EditIndex = -1; SqlConnection con … |
| | Hello gurus I am making a website for my friend. In the website i have included a contact us page in which a potential client would send an email. heres the address of the page if it helps, SNIP, it is constantly changing cause i am trying new techniques but … |
| | Hi i want to binding data.. i have two dropdownlist 1-depart 2-Programme.. i want that when i select any depart so i get programme in my programme dropdowlist related to depart.... i know it will be from sqldatasource.. but i m not able to do it... Regards.. Farhad |
| | hello guys :) I'm here again to ask some questions :) how can I put the value of a gridview in textbox and dropdown when I click the "select" thanks! :D |
| | Hi, I am trying to download data using a dataset, but I keep getting the error "Failed to enable constraints" On Debug, I get the suggestion 'Relax or turn off constraints in your dataset" refers to "aRow.EmployeeID" my dataset has this query: [CODE]select isnull(c.Answer,'') Answer,isnull(b.Comment,'') Comment from Questions a left … |
| | [code] <ul id="verticalmenu" class="glossymenu"> <li><a href="http://www.javascriptkit.com/">JavaScript Kit</a></li> <li><a href="http://www.javascriptkit.com/cutpastejava.shtml" >Free JavaScripts</a></li> <li><a href="http://www.javascriptkit.com/">JavaScript Tutorials</a></li> <li><a href="#">References</a> <ul> <li><a href="http://www.javascriptkit.com/jsref/">JavaScript Reference</a></li> <li><a href="http://www.javascriptkit.com/domref/">DOM Reference</a></li> <li><a href="http://www.javascriptkit.com/dhtmltutors/cssreference.shtml">CSS Reference</a></li> </ul> </li> <li><a href="http://www.javascriptkit.com/cutpastejava.shtml" >DHTML/ CSS Tutorials</a></li> <li><a href="http://www.javascriptkit.com/howto/">web Design Tutorials</a></li> <li><a href="#" >Helpful Resources</a> <ul> <li><a href="http://www.dynamicdrive.com">Dynamic HTML</a></li> <li><a href="http://www.codingforums.com">Coding Forums</a></li> <li><a href="http://www.cssdrive.com">CSS … |
| | hello :) I just want to ask a favor regarding the code on how to Update the edited data from the gridview. thanks. here's the code. [ICODE]<%@ Page Language="VB"%> <%--AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default"--%> <%@ Import Namespace="System.Data.Oledb" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> Private Sub Page_Load() Dim … |
 | Hello Daniweb Users... I have A GridView in ASP.Net with VB.net code I load the Table with data for example ID, Name, Surname... below i have 3 labels I want when I press in GridView label1 to be selected ID label2 Name and label3 Surname... Any Idea how to do … |
| | can you help me to get value in excel spreadsheet using excel interop so that i can saving it into a 'variabel' or as text.. Thx a lot.. |
| | Hello, I am just starting to play with ASP.NET MVC, I need to build a project for my school activities and I'm stuck with this (probably) simple thing, but I haven't got a clue... I need to present a View that contains checkboxes to choose from, this part of the … |
| | Hi all, I have a website hosted in a shared webserver. The problem iam facing is that the sessions get expired unexpectedly which results in the logging out of the user. The problem does not happen when I run the application locally in my system. On contacting my vendor he … |
| | I want to stream a program , any program you can think of over a website ,I want users to have to install nothing , so programs must just be able to stream . any help would be appreciated thanks! |
| | Recently I had an idea for an Asp.net website and now I wonder if you guys think this could generate a lot of traffic. The idea is that I want to make an interactive website where the users can download all kind of kmz files which can be opened in … |
The End.