Hlo Plz anyone give a coading of classic asp i want to save my csv and excel file in databse

Member Avatar
+0 forum 0

i have made leaves managment system ,now i want to mentioned leaves days in attendance register if employee take leave from 1-1-2019 to 4-1-2019 then 5 day display in attendance register as a (L) . kindly guide me how it will get done. here is my attendance register query in pivot table. SELECT DISTINCT ReportingDate INTO #Dates FROM EmployeesAttendance WHERE (ReportingDate BETWEEN @StartDate AND @Enddate) ORDER BY ReportingDate DECLARE @cols NVARCHAR(4000) SELECT @cols = COALESCE(@cols + ',[' + CONVERT(varchar, DATEPART(DAY, ReportingDate), 112) + ']','[' + CONVERT(varchar,DATEPART(DAY, ReportingDate), 112) + ']') FROM #Dates ORDER BY ReportingDate -- Building the query with …

Member Avatar
+0 forum 0

class AdvancedKeyboardTester { static void Main(string[] args) { for (; ;) { Console.ReadKey(); } } }

Member Avatar
-2 forum 0

I have problem while calling jquery functions it generates double output while when we do highlight questions and crossout on html content sometimes highlight and crossout also not working with selecting using Ctrl+A or select all. highlight and crossout values i am storing to database so, we can remain next time in questions. I am trying and just needs to works it well. [**Click Here For Output**](https://jsfiddle.net/17hhj61f/17/) **HTML CODE:** <style> .highlight{background:yellow;} .crossout{text-decoration: line-through;} </style> <input type="button" onClick="return false;" id="btn_highlight" unselectable="on" value="highlight" class="unselectable" alt="highlight" width="36" height="38"> <input type="button" onClick="return false;" id="btn_crossout" unselectable="on" value="crossout" class="unselectable" alt="crossout" width="36" height="38" /> <input name="highlight" id="highlight" …

Member Avatar
+0 forum 0

I am making a website using vb .net I have a datalist which has a datatable and delete button. the output llooks some thing like this below. 'X' is the delete button. --------------------- | X name1 | X name3 | | X name2 | X name4 | --------------------- When user click on the delete button(X) i want to get the id of that button and use that to delete a record in database. <asp:DataList ID="DataList1" runat="server" RepeatColumns="3" RepeatLayout="Table" DataKeyField="ID" OnDeleteCommand="DataList1_DeleteCommand"> <ItemTemplate> <asp:ImageButton ID="imgdeletebtn" ImageUrl="x-icon.png" runat="server" /> <%# DataBinder.Eval(Container.DataItem, "StringValue") %> </ItemTemplate> </asp:DataList> Protected Sub DataList1_DeleteCommand(ByVal source As Object, ByVal e …

Member Avatar
+0 forum 0

How to create a datalist table layout in vb? I am using vb .net I have a following data: DataBase: databaseName Table : tableName -------------------- | ID | randomNames | -------------------- | 1 | name1 | | 2 | name2 | | 3 | name3 | | 4 | name4 | | 5 | name5 | | 6 | name6 | -------------------- I want to take all the data from database and display datalist table in the following format. ------------------------ |name1 | name2 | name3 | |name4 | name5 | name6 | ------------------------ I set up the code but having …

Member Avatar
+0 forum 0

![as1.png](/attachments/small/4/e567c7cd76bf9f6460345131854df142.png "align-left") Please take a look at the attached image first. I would like to recreate this. I am using VB and bootstrap. Code: <div id="body_wrapper"> <div id="theCarousel" class="carousel slide" data-ride="carousel"> <!-- Text --> <div class="carousel-inner"> <div class="item active"> <div class="slide1"></div> <div class="carousel-caption"> <h1>my picture 1</h1> </div> </div> </div> <div id="search_wrapper"> <asp:TextBox ID="searchTB" runat="server" multiline="true"></asp:TextBox> <asp:ImageButton ID="searchIB" runat="server" ImageUrl="~/Images/search.png" /> </div> </div> </div> problem: I am not sure how can I write bootstrap code to move the search_wrapper above. I also want to make sure it auto-ajust when window is resize and it work for all browsers. any idea will …

Member Avatar
+0 forum 0

I am using VB. How to select mult iteams in listbox using backend code? I have a listbox where user can select muti items. <asp:ListBox ID="lb" SelectionMode="multiple" runat="server" DataValueField="dv"> <asp:ListItem>red r</asp:ListItem> <asp:ListItem>blue b</asp:ListItem> <asp:ListItem>green g</asp:ListItem> </asp:ListBox> How can I set so the value of "blue b" and "green g" is already selected? I tried setSelected but this method is not supported. lb.SetSelected(1, True) lb.SetSelected(2, True) I also tried this below which kind of works. It does select 1 value but I need to able to select multi values. lb.Text = "blue b" lb.Text = "green g" I tried this also …

Member Avatar
+0 forum 0

I have an input field which is showing vulnerable in security scan using XSS attack as: STYLE="xss:e/**/xpression(try{a=firstTime}catch(e){firstTime=1;alert(969)});" Could you please suggest how can we prevent from vulnerability like this ? Field: <input id="{ControlItemUniqueID}Data" style="width:150px" name="{ControlItemUniqueName}" type="hidden" {MaxLength}{IsEnabled} {IsReadOnly} class="datatext {CssClass}" value="{Data}" onkeypress="sanitizeEmployeeDateData()" onmouseover="sanitizeEmployeeDateData()" onblur="sanitizeEmployeeDateData()> <script> function sanitizeEmployeeDateData() { var EmployeeDate = document.getElementById('LIC1_EmployeeDateData'); if (EmployeeDate != null) { var date = new Date(); var d = date.getDate(); var day = (d < 10) ? '0' + d : d; var m = date.getMonth() + 1; var month = (m < 10) ? '0' + m : m; var yy = date.getYear(); …

Member Avatar
+0 forum 0

Hi. How can i populate asp:treeview only child populate with database query like "select databasename from databse where user_id="45" " and show these database in child treeview.Here is image [image]( tinypic.com/view.php?pic=15cyaew&s=9) I want "Database" remain same and blow child "Database Name",,only 1st 3 records replace with "Database Name" shown just,Kindly tell me how can i do this,Thanks.I search on google but i can't find this.Thanks. I'm working on database project.I'm using visual studio 2010,ASP.NET,C# (web)

Member Avatar
+0 forum 0

Hello All; I usually do everything in SQL Server these days, however, I have an site that is just so small, that it is going to be using an Access database. This is the code that I am using to generate the Google Sitemap with, however, there is code here that does not translate over to ACCESS Database. SELECT imageid, imagetitle, MedUpdate as DefaultTime, convert(varchar(11),MedUpdate,121) as UModDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedUpdate, 113), 114) AS UMilTime, convert(varchar(11),MedDate,121) as JDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedDate, 113), 114) AS JTime FROM Images GROUP BY imageid, MedUpdate, MedDate, imagetitle order by imageid Could someone please convert this …

Member Avatar
+0 forum 0

How can a table be updated in HTML with Dreamweaver using ASP on a dropdown functionality? I can only have the table bring in a table with the pageID of 1 and will not change when dropdown changes. How do I start the programming of getting every record with a specific pageID

Member Avatar
+0 forum 0

Hi , can you please help me with an advice. I have a problem with treeview. I want to show in a treeview folders but just some of them. I have several layers of folders. For example Root | =subfolder 1 | = subsubfolder1 | =subsubsubFolder1 | =subsubsubFolder2 | = subsubfolder 2 | =subsubsubfolder2 My problem is that in the last child there might be more than one folder (subsubsubfolder1,2,3..etc) and in this folders I have files. I want to have in my treeview only the folders that contain a specific file. I was trying to make an algorithm with …

Member Avatar
+0 forum 0

hi..can someone help me with this...i just want an application for fixing a table header while scrolling with repeater items (not in gridview). i tested some codes (pure css, js), but i find it hard to match the width of the header to the repeater items. Also, if records are in different length of words, the layout automatically adjusts even i declared fix width to each column.. Please help. Thanks

Member Avatar
+0 forum 0

I have been asked by my work to develop a CMS project in ASP or ASP.net. I have seen there are various open source projects taht will do that, but the server I have to work with isn't exactly new. I have found this page detailing various CMS projects: http://www.asp.net/mvc/open-source Can anyone advise a decent one. The server I am working with is .NET2 - 3.5 Any help would be appreciated. Gary

Member Avatar
+0 forum 0

I Have Local Hosted My ASP.Net Website By Following Steps 1. Open Visual Studion and Open Website 2. Go to Build Menu and Publish Website 3. I have Published it To C:\Inetpub\wwwroot 4.I have Created Virtual Directory Targetting Published Folder 5.When I am Trying to Run On Web Browser The Web Pages Are Showing But Database is not Published With Website Becuase Records Are not Showing in Gried View If I am Run this Website on Debug Mode On Visaul Studio it Is Working Please Help Me.....................Its Urgent

Member Avatar
+0 forum 0

HI, I a have inhrited administration of a work database. we currently have the ability to export data to a xls file from a customers table, but i want to add employers information from the employers table i.e employers name, address etc along with each record exported. This section deals with accessing main database/table: ..... tablename = "[TbleMaster]" strsql = "select * from [TblMaster]" SQL = SQL & " StrRecNo LIKE '%%'" ...... how do i add from table TblEmployer also, each customer in TblMaster has a Employer code from TblMaster - StrEmployer_Code which i will need to query/align with …

Member Avatar
+0 forum 0

Hello everyone I have preloaded the sounds in javascript array and then make audio object and pass the src from the array and this is working perfetly fine on local system but when we upload on server it says HTTP Error 404.3 - Not Found. How i can add Mime Type so the server know that this is audio file. Here is the link i find that have web.config file ( http://www.localwisdom.com/blog/2011/10/iis-7-web-config-change-for-html5-and-css3-mime-types/ ) but the problem is that when i add the mime types in web config file from above URL it will not load the CSS , Images , …

Member Avatar
+0 forum 0

The following code is producing this error `Microsoft VBScript compilation error 800a03f6 Expected End ` followed by `/stock/availability-quick/availability2.asp, line 130` I think it is a if else error. I have looked over the code and i don't see the error and would benefit from an expert pair of eyes to look over it. Thanks in advance David <%@LANGUAGE="VBSCRIPT"%> <!--#include file="../../includes/functions/insphire.asp"--> <!--#include file="../../includes/functions/logaccess.asp"--> <!--#include file="../../includes/functions/stock.asp"--> <% if request("Allow") = "f875eba08594178509bd3482dc0294" then ' security check passed %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Administration - Stock - Status</title> </head> <body> …

Member Avatar
+0 forum 0

Hi, I want to create an excel file from classical ASP. My client is Win 7 / IE9, Server has Windows Server 2003 and Excel 2003 I tried HTML TABLES. Response.ContentType = "application/vnd.ms-excel; charset=utf-8" Response.AddHeader "Content-Disposition", "attachment; filename=abc.xls" Response.Write(sResponseString) AT first It worked but later on the file corrupted. While opening the file in excel and import job too we are getting error saying "The file you are trying to open <filename> is in different format than specified bt file extension. Verify that the file is from a trusted source before opening the file. Do you want to open the …

Member Avatar
+0 forum 0

his one i'm working c# try to use the account database from account to customerid and then the view which is page must have from account dropdown box and toaccount dropdown box and enter the amount the submit which result the amount is deducted from balance I'm focusing on Account class has zero or one customers while Customer has many accounts Account class Accountid Type Balance Customerid Customer class Customerid name description address Transfer funds page fromaccount - dropdown box (accountid) toaccount - dropdown box(customerid) amount - input amount submit it will go to viewaccount page to show the balance …

Member Avatar
+0 forum 0

Can it be done? <asp:MenuItem Text="Queries" Value="Queries"> <asp:MenuItem Text="New Query" Value="New Query"></asp:MenuItem> <asp:MenuItem Text="Search Queries" Value="Search Queries"></asp:MenuItem> <asp:MenuItem Text="Open Queries" Value="Open Queries"></asp:MenuItem> <asp:MenuItem Text="Resolved Queries" Value="Resolved Queries"></asp:MenuItem> <asp:MenuItem Text="Closed Queries" Value="Closed Queries"></asp:MenuItem> <asp:MenuItem Text="Cancelled Queries" Value="Cancelled Queries"></asp:MenuItem> </asp:MenuItem> Thanks

Member Avatar
+0 forum 0

anyone here knows how to delete or hide an array element in asp permanently or until the application? im currently developing an application wherein once an array element matches the typed text in the textbox it should be removed from the list. what my code does is it deletes the last element and returns it when a new word is typed which is wrong. Im a newbie in asp by the way , here's my code <% Dim item Dim words(3) words(0) = "hello" words(1) = "again" words(2) = "world" words(3) = "display" Session("my_words")=words Dim i For i=LBound(words) to UBound(words) …

Member Avatar
+0 forum 0

so I got two probelms with asp.net routing, I got these these routing values in my _AppStart RouteTable.Routes.MapWebPageRoute("{rcPageName}", "~/Default.cshtml", new { rcPageName = "default"}); RouteTable.Routes.MapWebPageRoute("Tutorials/PHP/{rcPageName}", "~/Default.cshtml", new { rcPageName = "PHPTutorial"}); RouteTable.Routes.MapWebPageRoute("Tutorials/VB/{rcPageName}", "~/Default.cshtml", new { rcPageName = "VBTutorial" }); RouteTable.Routes.MapWebPageRoute("Tutorials/CSharp/{rcPageName}", "~/Default.cshtml", new { rcPageName = "C-SharpTutorial" }); RouteTable.Routes.MapWebPageRoute("Tutorials/HTML/{rcPageName}", "~/Default.cshtml", new { rcPageName = "HTMLTutorial" }); RouteTable.Routes.MapWebPageRoute("Tutorials/CSS/{rcPageName}", "~/Default.cshtml", new { rcPageName = "CSSTutorial" }); RouteTable.Routes.MapWebPageRoute("Tutorials/ASP/{rcPageName}", "~/Default.cshtml", new { rcPageName = "WebPages" }); Now they all go to the Default.cshtml page which basically requests the page (or row) from the database. and prints it out. http://www.thecodingguys.net < as you can see Here …

Member Avatar
+0 forum 0

good day, Im quite new with ASP and is still studying it Im just wondering why everytime I use Javascript codes the error Language 'JavaScript' is not supported at this moment! is appearing in my browser but then when I use VBScript it works out just fine.

Member Avatar
+0 forum 0

I want to make server page that can keep a parameter just like tracking ID. I want to pass that parameter from an asp page to another asp page when i clicked submit button. Can someone help me to solve this, i really need to finish this soon. So far have this code, this is *January.asp* page, i need to pass the **userID** parameter to *userView.asp* page : <%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%> <% if( Request.Form("button")=="Simpan") {var DSN = "Provider = Microsoft.JET.OLEDB.4.0; Data Source = C:/Inetpub/wwwroot/eKehadiran/eKehadiranDataBase.mdb"; var Conn = Server.CreateObject("ADODB.Connection"); Conn.Open(DSN); var id = Request.Form("userID");var kllsan = Request.Form("kelulusan"); var abailabel = Request.Form("available"); var …

Member Avatar
+0 forum 0

Hi Guys, The code below allows me to upload images. How would I go about inserting error checking if the user uploads a word document for example? Thanks W <!-- #INCLUDE FILE="Openconnection-for-local-use.asp" --> <!--#include file="Upload.asp" --> <% Dim Uploader, File Set Uploader = GetASPUploader Set File = Uploader.AddFile("file") File.ValidFileTypes = "jpg,gif,bmp" File.MaxSize = 1024*1024 File.Overwrite = false Uploader.Destination = "C:\TestArea\imageUpload\files\" Server.ScriptTimeout = 900 On Error Resume Next Uploader.Upload If Err Then Response.Write err.description Response.End() End If Dim myFile, myDescrition myFile=File.Name myDescription=Uploader.Form("description") StrSQL= "INSERT INTO tblUploadedFiles ( filename, description ) VALUES ( '" & File.Name & "', '" & Uploader.Form("description") & …

Member Avatar
+0 forum 0

Hi everybody, I’m a student learning ASP and I have a project to develop some VoIP applications. I would like to use sample programs by Ozeki VoIP SIP SDK because they have trial version for free. Have any of you tried these sample programs? For example this one: http://www.voip-sip-sdk.com/p_203-asp-net-sip-voip-client-voip.html If yes, could you please give me a review of it? Thanks for your time in advance! Regards,

Member Avatar
+0 forum 0

I am doing a Music store online that does selling of music albums on the internet. I would like to know how to enable a user who, say for example is viewing all my music albums, but is not registerd with my site as yet, but they do place an order for a particular album, how can i then have them register and then login it to my site and there after proceed to doing the payment of the album that they have placed? Any ideas how i should do this? I am using Frontpage to create my web pages …

Member Avatar
+0 forum 0

Hi there, I am trying to combline results form a query into one variable/string without drastically changing the sites current code. Bacically I have been trying to add **rs2("name")** for each record into one string. For example, say the customer has "item1", "item2", and "item3" in their basket, well I want to combine each of these together into one single variable called **"stuffall."** (like "item1 item2 item3") The code I am using can be found below, and I have highlighted the problem areas using <<<>>>. I assumed, as in php, this would be possible by adding **rs2("name")** into a var …

Member Avatar
+0 forum 0

The End.