retriving the DNS server ip of my computer. But with my codes i only manage to the IP address of my computer.
Dim IPAddress As IPAddress = Dns.GetHostEntry(Dns.GetHostName).AddressList(1)
Dim strIPAddress As String = IPAddress.ToString
TextBox3.Text = strIPAddress
I am facing a problem when i am retrieving image from sql-server's database. I am using this code
View 6 Repliesmy code doesn't show anything when ever I start on my button "start recording" it starts to record every keystroke on the and show it in a textbox and after that i am trying to get that data into text of a sql 2005 database with vb vs2008 but when ever I click on the button to show me the saved data , retrieve from database, it doesn't show anything, why?
and I also want to create new row everytime the new object is created...thnx
Databse Class
[code]
Imports System.Data.SqlClient
Public Class DataSaver
Private sqlConnection1 As SqlConnection
[Code].....
I have a website that was written in VBSCRIPT that I am moving over to VB.NET. Until I have time to get to rewriting some pages/applications,I would like to update some of the code so they work a bit better.I am trying to grab a server variable on the VBSCRIPT page that contains our username from the enterprise login.I have 2 test pages here, one with language="VB" at the top and the other language="VBSCRIPT".
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Server Variables</title>[code].....
The VBSCRIPT page will list variables with no data when they have data on the VB page and in ALL_HTTP. Is there any way I can get VBSCRIPT to gather the correct info for all the server variables?
EDIT: These are the variables that vary between VB and VBS AUTH_USER, REMOTE_USER - logged in user on VBS, iis_anon on VB REMOTE_PORT - not listed in VBS
The following are listed in VBS, but have no data
HTTP_SERVER_PROTOCOL
HTTP_SM_TRANSACTIONID[code].....
Also there is a custom on I wish to get that is used for our enterprise authentication.
I have stored an excel file within an SQL Server Table having the corresponding column data type as varbinary (MAX) through a VB .NET windows application form. how can I retrieve and open the stored excel file for manipulation?
View 2 Repliesi have been in state of hectic for the last 2 days making lot of research and finally made this code worked it for me. My problem is that, how can i make this code retrieve the image from sql server database...use picturebox to load it in the vb.net program.
Dim myfilelocation
As
String =
"C:myPicturesmyimage.png"
[code]....
Is it also possible to change the location of image where its getting the image. i mean, i would like to tell other computers to get their images from anywhere as long as it brings images to my server.i mean, say that comp1 which is connected to my database server for storing and retreiving information, gets his image from his location then the application sends the image to my server...the application retreives the image from the server..as simple as that.
I have Memberships and Bookings tables in database containing an attribute cust_id which is primary key in Memberships and reference key in Bookings. When i am executing data reader I want it to read cust_id values from membership table but it is reading it from the bookings table. Also when i compare two cust_id values, 1 taken from a textbox and the other taken from database column, even though both are same but the comparison result is false. I have compared using string.equals(str1, str2) and have also compared the two directly using if statement but in both cases even if the string is same but result is otherwise. [Code]
View 2 Repliesi have return the follwoing to retrieving server date
Private Structure TIME_OF_DAY_INFO
Dim tod_elapsedt As Long
Dim tod_msecs As Long
Dim tod_hours As Long
[code]....
im getting error "arithematic operation resulted in an overflow
I am kinda new to VB, but have used C# to pull data from a SQL Server db using DataTables and Reader, etc, however I am at a loss as to how to accomplish this in VB.I have a variable, which the user specifies, that I wish to use as a parameter in a SQL string, much like the following: "SELECT x FROM y WHERE x = '@param'" The result will then be stored in a string variable and I wiill do what I have to do with it.
[code]...
i have created a table named students with photo as varbinary(max)
i have designed a form with two buttons(insert and retrieve) and a picture box on it
Under insert button:
Try
Dim st As
New FileStream(OpenFileDialog1.FileName, FileMode.Open, FileAccess.Read)
[Code]....
inserting image is no problem but when i retrive image in picturebox it gives i message as "invalid object name students"
I'm using this code to retrieve the list of files from a FTP server
Dim request As FtpWebRequest = WebRequest.Create("[URL]")
request.Credentials = New NetworkCredential(username, password)
request.Method = WebRequestMethods.Ftp.ListDirectoryDetails
Dim response As FtpWebResponse = request.GetResponse()
Dim responseStream As Stream = response.GetResponseStream()
Dim reader As StreamReader = New StreamReader(responseStream)
messagebox.show (reader.ReadLine)
It gives me alot of information that I dont need, I know that I can use:
request.Method = WebRequestMethods.Ftp.ListDirectory
Which only retrieves the file name but when I try to change it, it gives me an error. Error number 550. ListDirectory so I can only get the file name?
I'm currently battling to retrieve an image from SQL Server 2008 R2 in an asp webapplication using vb.net. The image is stored in the SQL Server 2008 R2 database as an image type. I've been researching for the past few days and can't seem to find anything solid on this topic. Apparently, the image has to be retrieved using
View 1 RepliesIs there a way to set session variables during login that are then available to reports? We have a reporting services server where we move and denormalize data from our transaction system for reporting purposes. In order to allow our users to login with the same user name and password from the transactional system we have set up custom forms authentication and after much trial and error it is finally working. In addition we have the authorization accessing our transactional system so that any changes in user authority is immediately reflected in Reporting Services.
Our problem now is that we would like to add some additional features such as locking down parameters depending on user authority/groups in our transactional system. We have found a way to do it but it's inefficient, basically we have stored procedures that will query our transactional system to check for access. The problem is that these queries will often be run for every report request even though the answer is unlikely to change. It would be nice to have access to session level data that can be set once during log in and then accessed from the reports.
i am working on my academic project in which i need to retrieve data from sql server table to textbox and image in vb.net . i am able to retrive data either in text box or only image can anyone help me out to get data in textbox as wel as image in picturebox.
View 1 RepliesYes, you read it right! Exchange Server 2000. I want to create a script that retrieve information(ie. Last Access Time) of all the files that are place within the public folder of the Exchange Server 2000.
View 2 RepliesI have a databound combobox that contains 2 fields but obviously only 1 is displayed. My question is...how do I retrieve the field that is NOT the "Displaymember"?
View 2 Replieshow come when I retrieve my data from SQL my date field returns the date along with a time of 12:00:00 AM???? The Sql BD Type is Date and it is a date only in the SqlDB. I'm populating the date into a textbox.
View 2 RepliesMy problem:
Given a list of DLL paths, find their version number and all assemblies referenced. Some may point to the same DLL but with a different path or version.
My Code:
Dim otherDomain As AppDomain = AppDomain.CreateDomain("otherDomain")
otherDomain.DoCallBack(Sub()
Assembly.ReflectionOnlyLoadFrom("filePath")
[Code].....
I'm trying to download files and fill the progressbar correctly. The problem is that I'm missing something in the code below, because it doesn't work:
Dim streamer As MemoryStream = New MemoryStream
Dim reader As StreamReader = New StreamReader(streamer)
Using fs As New IO.FileStream(PathAndFile, IO.FileMode.Create, IO.FileAccess.Write)
[code]....
However, this is downloading the file.
I have a rather simple task, retrieving an image file from a virtual folder outside of my ASP.Net web Application (The Virtual Folder is in the root of the website) and then displaying it in an image control. I am able to to access a Virtual Folder that is within the web site. Here is my code that
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim sourcefile As String = Server.MapPath("~/Common/Images/LAPDPatch.jpg")
Image1.ImageUrl = sourcefile
End Sub
What am I doing wrong?
Ok, I was able to figure it out: Ok, I was able to get it working, I was using the wrong "slash" character I was using the forward slash instead of the back slash:
Dim sourcefile As String = Server.MapPath("VitualFolderName") & "ImagesLAPDPatch.jpg"
I got a weird problem here like I got a site that users can post comments on a friend profile page.Everytime a user post a comment my application sends e-mail to that page owner, you know to inform for a new posted comment on his/her profile page.The problem is I want to stop the application from sending email if that user has just recently posted a comment say like 5 hours ago/earlier.Here is the function I use that would try to check it:
[Code]...
I've created a module for my website and when a button is clicked, it calls a VB sub on the server.
I need this sub to retrieve the values that were filled in on the form, but the things I need to retrieve values from are not asp controls, they are simple <input> and <select> tags.
How can I retrieve values from input on a .aspx page from VB code executed behind it?
Public Class Class1
Public mSize As Integer
End Class
1) How to define another method inside the Class1 that allows other programs to retrieve the value of mSize
and
2) How to disallow client programs from directly accessing mSize.
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
[Code].....
how do we connect database in access after con.Close() since we do all operation after the con.Close() and works properly.
I am doing invoicing using VS2008 VB. I use Crystal Reports to produce the invoice. I create an in memory dataset to pass to Crystal Reports. What I would like to do is save the dataset I sent to Crystal Reports as an audit trail of the exact invoice. It would only be retrieved in the event of a dispute concerning the original invoice. I thought of using the WriteXML, ReadXML. But that would overwrite the existing XML. Does anyone have a better way of saving the XML for future retrieval?
View 7 RepliesI have MSaccess database.I have 2 tables 1) CUSTOMER TABLE=----CUSTOMER ID-Primary --AUTO NUMBER2) ORDER TABLE =----(CUSTOMER ID--Foreign KEY) Now From the front end using VB.net I have an page in which if i enter Customer details and press button add .I have to INSERT into values into CUSTOMER TABLE and I Also at the same time INSERT into ORDER TABLE with this CUSTOMER ID which i generated now.How is it possibl
View 13 RepliesDim NewOutwarsDeliveryNoteNumber As Integer
Dim iSql As String = "SELECT MAX(OutwardsRefNumber) FROM NewOutwards"
Dim da As OleDbDataAdapter = New OleDbDataAdapter(iSql, LoginForm1.Conn)
[code]....
when I try and run this code it gives me the error that says "Column 'OutwardsRefNumber' does not belong to table ."BUt I am 100% sure this column is in my table. what can I do to correct it?
I have a code here which is to insert values in both the tables which has Relationship.[code]...
View 4 RepliesI'm uploading a flv / swf file and I need to capture the dimensions of those files so I could later retrieve it from a database and embed it into a page.
how I could do it in code behind?
I'd like my application to be able to detect a where a particular USB device has been mounted, and adapt accordingly. Ideally, I'd associate paths with a USB serial number, rather than with a given path. However, I cannot figure out a simple way to access these unique IDs from VB.Net code.
View 1 Replies