I display a message on page using the code below.  Dim msg As Message = CType(Session("Message"), Message) FreeTextBox1.Text = Server.HtmlDecode(msg.Body) What i want to do is display each bit of saved text in individual rows on page as read only content. While insert new text below content. When saved the new text is added to the list of content and saved, ready to be displayed again in order of addition ..read more

Hi  I have  written code to check if file exist in folder or no   but always code goes to else  Dim sourcefile = Request.ApplicationPath & "/Portal-Photos/" & Session("EMPNO") & ".jpg" If System.IO.File.Exists(sourcefile) = True Then  MsgBox("file is exist") Else  MsgBox("file not exist") End If ..read more

Hello, I have a very old vocalary as a text file and I would like to import it to a Access-Database table with two columns: 1)word 2) explanation. The word separation sign is #. It looks like so: #tree# It has many leafs and so on... #sun# it gives us a lot of energy and so on I could not manage to import the text. The explanations are very long, till 2000 chars. I suppose that it should be necessary to manipulate the text first to prepare it for the import.  Please help me! Krsnic ..read more

HI experts, I am the new in vb. There is an error ‘Request object’ when the compiler run to the below line: textstr = File.ReadAllText(path) This is my whole code: Private fso As New Scripting.FileSystemObject Private dataBook As Workbook, dataSheet As Worksheet Private supplierBook As Workbook, supplierSheet As Worksheet Private ConfigSheet As Worksheet Private src_pth, Output_pth As String Private datarow, i As Long Private fi As File Private textstr As String Sub findCount() Dim indexCount As Integer Application.ScreenUpdating = False Application.DisplayAlerts = False ..read more

Hi, I'm fairly new at this so it may be an easy answer but I am developing an asp.net site using vb.net. I am having problems converting a string with from a text box from user input into a Date format in order to run a SQL query to see if there is a room available. The text box uses a Textmode: Date, and I want it in the format of dd/mm/yyyy. Getting error: System.FormatException: 'String was not recognized as a valid DateTime.' All help would be muchly appreciated. Thanks. Dim room_type As String = CStr(ddlRoomType.SelectedValue) Dim checkindate = DateTime.ParseExact(Check_i ..read more

<div itemprop="upvoteCount" data-value="0"></div> <div itemprop="text"> I'm trying to read a 1GB XML file with almost 1 million records through a URL and store <file> in a dataset and save them to a database, but after 10 minutes, the application will crash and throw an Out of Memory Exception. The XML looks like this: <ICECAT-interface xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://data.icecat.biz/xsd/files.index.xsd"> <files.index Generated="20200220011050"> <file path="export/freexml.int/INT/1399.xml ..read more

Im trying to call to an URL And than i will get response into XML format and based what Response i will get it will create Tables successfully into database using Microsoft SMO (Server Management Objects) which Allowing me to create and generate databases and tables. but for some reason it coludnt insert any data to tables and they are NULL Screenshot XML: <ICECAT-interface xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://data.icecat.biz/xsd/files.index.xsd"> <files.index Generated="20200219011050"> < ..read more

Hi   In main report i have Invoice Parameter . I have passed values V0001,V0005 in TextBox.  In Subreport in each order it shows all values of V0001,V00005 whereas in V0001 it should show only details of V0001 . In V0005 it should show details of V0005. In Main report Stored Procedure i have splitted comma separated values in different rows. Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim data As New ds_CO_NET.sp_CO_NETDataTable Dim a As New ds_CO_NETTableAdapters.sp_Invoice_NETTableAdapter a.Fill(data, Tex ..read more

hi  I have  page in want to calculate  hire date  till now date       in years, months and days            textbox1   textbox2     textbox3 if month more than 12 then add on years   also for days thank you ..read more

Hi   When we drag table from toolbox for first time it asks for Dataset if no dataset exists for that report in Windows APplication. After selecting 2 tables how we can relate them together. Thanks ..read more