|
I'm also facing the same problem. Any help will be appreciated.
|
|
|
|
|
|
i am working on C# code. i was faced same problem.
but i solve this by set combox value.
here carefull that combox valumember data type and your given value data type is same.
Thats the main point of datatype problem.
Thanks
Tonmoy
|
|
|
|
|
I am doing work on graphics using vb .net 2005. I have a bezier (4 points) curve. a line intersects bezier curve. i want to draw two beziers from where line has intersect. if any body help me
|
|
|
|
|
Please help me with this CODE. What I want to do is to update the existing data in my database.
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlClient.SqlDataReader
Imports System.Transactions
Imports System.Collections
Imports System.Collections.Generic
Public Class SelectStaffManager
Const strConnectionString As String = "Server=(local);Initial Catalog=VideoClub;User ID=sa;Password="
#Region "SQL Statements"
Private Const SQL_SELECT_STAFF As String = "Select * From Staff"
Public Shared Function SELECTStaff(ByVal FirstName As String, ByVal LastName As String, ByVal ContactAddress As String, ByVal MaritalStatus As String, _
ByVal Sex As String, ByVal EmailAddress As String, ByVal DateofBirth As Date, ByVal DateofEmployment As Date, _
ByVal Photograph As String, ByVal PhoneNo As String, ByRef strMessage As String) As Integer
Dim SqlConn As SqlConnection = Nothing
Dim cmd As SqlCommand = Nothing
Dim SqlParm As SqlParameter = Nothing
Dim collectdata As SqlDataReader
Try
'Prepare the SqlCommand Object and all it's neccessary properties for data commission into the database
SqlConn = New SqlConnection(strConnectionString)
cmd = New SqlCommand(SQL_SELECT_STAFF, SqlConn)
'cmd.Connection.Open()
collectdata = cmd.ExecuteReader
cmd.Connection.Close()
Catch ex As Exception
collectdata = Nothing
strMessage = ex.Message
End Try
Return collectdata
End Function
#End Region
End Class
|
|
|
|
|
So what is your question ? Do you receive an error ?
|
|
|
|
|
Your code, as far as I can see, does nothing other than open a datareader and close the connection. What are you trying to do? (please don't say "update my database", it's the most useless answer you can give)
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hello every one,
I have a public function in a existing application which is called from many different forms. The form name is also passed but as a string to his function.
What i wanted to do is close the form from which it is called depending on certain conditions
how i can do that
button_click
{
call test("frm1")
}
Public function test(byval formName as string)
{
'condition
'close the form which called this function
'I want to some how execure frm1.close()
}
|
|
|
|
|
First you need to store the collection of open forms so that you can find them again, a List or Collection. A manager class to handle adding and removing/closing would be preferred to handle the List/Collection.
In the function, look for the form with the name, and ask the manager class to close the form.
If a form is closed via UI, inform the manager class to remove itself from the List/Collection.
You will need to handle situation where multiple form of the same type has been opened.
|
|
|
|
|
I need help urgently for this question. Can someone help me on it.
|
|
|
|
|
Since you want to do this in VB.NET instead of C# I assume you already have the code in C#. Simply translate it to VB.NET (Search for a converting tool C# -> VB.NET on google).
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|
|
pls i have a project that i want to read a file from C:\WINDOWS\system32\Logfiles\MSFTPSVCg but it show error that another process is reading the file. this app uses ftp. i suggest the problem is the ftp reading the file. how can i overcome this and read the file
|
|
|
|
|
you should be able to share the file without problems
try something like:
dim fs as new system.io.filestream("yourfilenamehere", FileMode.Open, FileAccess.Read, FileShare.ReadWrite)
The part at the end of your filestream method (FileShare.ReadWrite) tells your filestream that it can share the file with other proccesses.
|
|
|
|
|
can i use sometime like
s = file.readalllines(path) after your statement to read all the line. if no how can i read all line thank
|
|
|
|
|
Hmm.. i suggest you do a little looking up on google before you continue cause looking at your pseudo code.. you are not really catching on... Depending on what you want.. you could do the following to read the entire file:
dim sMyVariableThatWillContainTheWholeEntireTextOfTheFile as string
dim fs as new system.io.filestream("yourfilenamehere", FileMode.Open, FileAccess.Read, FileShare.ReadWrite)
dim sReader as new streamreader(fs)
sMyVariableThatWillContainTheWholeEntireTextOfTheFile = sReader.ReadToEnd
However.. take under consideration that depending on the size of the file, this might not be the best way to go.. you could also do :
sReader.ReadLine()
to read the file line by line and perform actions on the content of that line..
Take a look at the streamreader class here: http://msdn.microsoft.com/en-us/library/system.io.streamreader.aspx[^]
|
|
|
|
|
if u have permission to access the file,
just copy it to a specific place then read the copy !
" I love deadlines. I like the whooshing sound they make as they fly by. "
|
|
|
|
|
I'm new to VB.NET, currently I'm learning programming here. I have a Window Form(e.g. FrmLogin.vb) and a module which used to run the program (e.g. Module1.vb).
I have declared a few public string variable as follow:
Option Explicit On
Imports System.Data
Imports System.Data.Odbc
Imports System.Configuration
Module Module1
'User detail variable
Public UserID As String
Public UserName As String
Public UserPassword As String
End Module
And I used the FrmLogin to verify the user by connecting to MySQL database. After the user successful login,I will set the UserID,UserName and UserPassword data load from the database which need to be used in my program for the future identification. But when I open another new form I found that these public variable is no value. Can anyone tell me how should I share a public variable inside VB.NET? This data will be used by alot of Form inside this application.
Thank you for reading.
Regards
Drexler
|
|
|
|
|
Sorry, we cannot see your question. Please reformat your post so all the text is visible.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Sorry Ashfield,
What I need is declaring a variable for global used in my Vb.NET Window Form Application. I am trying to declare the global variable inside a Module1.vb. I have a few forms that using this global varaiable and it doesn't really works. Anyone could tell me how to declare a global variable which can share the variable used in all other different forms or class?
Regards
Drex
|
|
|
|
|
From version 7 (VB.NET 2003) VB is an object oriented language, which means that there are no longer any global variables. All variables are either members of a class or local in a method.
To set up variables that you can use like you did use global variables, you can use static variables. You use the Shared keyword to do this, and those variables are members of a class rather than members of an instance of the class.
Public Class UserDetails
Public Shared UserId As String
Public Shared UserName As String
Public Shared UserPassword As String
End Class
You can access the variables from anywhere by specifying the class name and the variable name:
UserDetails.UserId = "42"
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hello Guffa,
Do you mean that I should create all the public share variable into one main module,so all the form can use all the data inside this main module? And how can I insert or retrieve the data of UserID when I need it in other form from this class?
Hope to get some solution about this from you all.
Thank you~!
|
|
|
|
|
Modules is something that for some reason survived from VB6. A module is compiled into a class where all the members are static, so if you declare variables in a module, you should be able to access them from anywhere.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Yeah,thanks Guffa. Can you give me some idea how should I declare the variable of my Window Form Application? Let me further explain my situation below:
Option Explicit On
Imports System.Data
Imports System.Data.Odbc
Imports System.Configuration
Module Module1
'User detail variable
Public UserID As String
Public UserName As String
Public UserPassword As String
End Module
This is how I test my retrieve data using Form from the varaiable in Module1.vb:
Messagebox.show(UserID)
Messagebox.show(UserName)
Messagebox.show(UserPassword)
But all the messagebox prompup is Nothing. So,anyone can tell me how should I declare my variable so I can used anywhere in my project? The UserID,Username and Password is used for verification when working with certain function or task.
Thank you for reading.
Regards
Drexler
|
|
|
|
|
It looks like you have declared your variables correctly, the reason the messagebox is showing nothing is becasue you haven't assigned them a value.
Try
UserID = "12345"
Messagebox.Show(UserID)
|
|
|
|
|
Yeah,thanks Liqs. I have solve it by converting the data to string instead of boolean when I assign into the variable. This solve my problem,thank you my friend.
Regards 
Drex
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
