|
im trying to retreave an information from a database after the person have logged in.but i can insert the data to a specific place that im intent to put it.Im using session to do that by passing the parameter to campare it.
this is the code i used:
Dim MyConn As SqlConnection<br />
Dim cmdSelect As SqlCommand<br />
<br />
userName = Session("userName")<br />
<br />
If userName <> "" Then<br />
<br />
<br />
MyConn = New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString"))<br />
cmdSelect = New SqlCommand("sp_GetUser", MyConn)<br />
<br />
cmdSelect.CommandType = CommandType.StoredProcedure<br />
<br />
Dim parameternoPekerja As New SqlParameter("@noPekerja", SqlDbType.VarChar)<br />
parameternoPekerja.Value = userName<br />
cmdSelect.Parameters.Add(parameternoPekerja)<br />
<br />
MyConn.Open()<br />
Dim dr As SqlDataReader = cmdSelect.ExecuteReader(CommandBehavior.CloseConnection)<br />
<br />
If dr.HasRows = False Then<br />
' error mesej<br />
Else<br />
txtnama.Text = CInt(dr("nama"))<br />
txtjawatan.Text = CInt(dr("jawatan"))<br />
txtjabatan.Text = CInt(dr("jabatan"))<br />
txtbidang.Text = CInt(dr("jabatan"))<br />
txtjabatan.Text = CInt(dr("jabatan"))<br />
End If<br />
Else<br />
'error
Is it wrong
|
|
|
|
|
pandapatin wrote: txtnama.Text = CInt(dr("nama"))
txtjawatan.Text = CInt(dr("jawatan"))
txtjabatan.Text = CInt(dr("jabatan"))
txtbidang.Text = CInt(dr("jabatan"))
txtjabatan.Text = CInt(dr("jabatan"))
must call dr.Read() first...
|
|
|
|
|
Hi
Does anyone know if there is some sort of button code which can close all instances of your application?
I want to be able to close all forms and all instances of an application with the click of one button.
Sometimes, when I use the Me.Visible = False code , instances of my application are still running unseen. I want to be able to avoid this.
Regards
ensuvari
|
|
|
|
|
You can use either End or Application.Exit()
chatura
|
|
|
|
|
ensuvari wrote: when I use the Me.Visible = False code , instances of my application are still running unseen
Ummmmm....who told you that Visble=False will clsoe an application???  That just hides the window you set it on, nothing more. So, yeah, the app is still running...
You'll have to use the Process[^] class, and it's GetProcessesByName method, to get an array of Process objects. Then you can call Close on each of those objects to close every instance of your app.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm beginning a new VB.NET WinForms app for my company. They have chosen to use VS 2005 for this project. I've been programming in 1.x for a while now, but I haven't really kept up on the changes/additions to 2.0.
Does anyone have any suggestions for books/websites/etc. where I can get up-to-speed on 2.0? I would prefer a book, but I don't really need a "VS 2005/.NET 2.0 for Dummies" book (or do I?) A website (or combination of sites) would be fine as well, though I don't really want to try and wade through MSDN to find what I need if I don't have to...
Anyway, any suggestions would be greatly appreciated. Thanks!
P.S. From what research I have done, having VS.NET 2003 and VS 2005 installed side-by-side on my machine will not be a problem. I don't have drive-partitioning software, so they will literally be side-by-side. Is that really the case?
Scott McChesney
|
|
|
|
|
|
Scott McChesney wrote: From what research I have done, having VS.NET 2003 and VS 2005 installed side-by-side on my machine will not be a problem. I don't have drive-partitioning software, so they will literally be side-by-side. Is that really the case?
Yes, that is really the case. I have 2003 and 2005 installed side by side, and both work great. Only problem (not so much a problem, as a minor annoyance) comes from the OS. When I double click on a file, Windows doesn't know if it's 2003 or 2005. It opens VS 2005 by default. So what I do is right click on the file, and choose "Open with - Microsoft Visual Studio 2003" if I need it. (Of course, if most of your work is done in VS2003, you could set that as your default)
Asside from that, no problems.
Roy.
|
|
|
|
|
How to run other exe from my project e.g. how to run calculator(windows) from my project??..
Nilay M Shah
|
|
|
|
|
You need to call the Win32 function ShellExecute.
First add this line to the top of your source file.
Private Declare Function ShellExecute Lib "shell32.dll" Alias _
"ShellExecuteA" (ByVal hWnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long
You can now launch the calculator program by doing this...
ShellExecute vbNull, "open", "calc.exe", "", "", 1
Another neat thing here is that you can also launch URLs and open documents like TXT, DOC, PDF, etc. with this. ShellExecute is the equivalent to double clicking a file in Windows Explorer.
|
|
|
|
|
i have this error when i try to move my image into the panel ...even when i drag the textbox inside i cant change anything with it..?
An unhandled exception of type 'System.NullReferenceException' occurred in SnL1.exe
Additional information: Object reference not set to an instance of an object
|
|
|
|
|
You'll have to run this code in the debugger to find out on what line the exception is being thrown. But, you're trying to do something with an instance of an object that doesn't exist, or is Nothing. Without seeing the section of code that is having the problem, that's pretty much all we can tell you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm having trouble passing parameters to a COM+ service. The only code I could find to do so uses XML (see below). This works, but only certain characters are allowed. Unfortunately I am passing a stream of text that includes chr(12) formfeeds and XML of course does not like this.
Any suggestions?
'<remarks>
<system.web.services.protocols.soapdocumentmethodattribute("http: tempuri.org="" maintws="" service1="" sendlist",="" requestnamespace:="http://tempuri.org/MaintWS/Service1" ,="" responsenamespace:="http://tempuri.org/MaintWS/Service1" use:="System.Web.Services.Description.SoapBindingUse.Literal," parameterstyle:="System.Web.Services.Protocols.SoapParameterStyle.Wrapped)">
Public Function SendList(ByVal filedata As String, ByVal filename As String, ByVal clientlist As String, ByVal filetype As String, ByVal directory As String, ByVal subdirectory As String, ByVal batch As String, ByVal offline As Boolean, ByVal dir2file As String, ByVal db1 As String, ByVal db2 As String, ByVal db3 As String) As String
Dim results() As Object = Me.Invoke("SendList", New Object() {filedata, filename,
clientlist, filetype, directory, subdirectory, batch, offline, dir2file, db1, db2, db3})
Return CType(results(0),String)
End Function
|
|
|
|
|
Hi,
Using the Exception Management Application Block I can create new logs in the Event Viewer by placing the following in my app.config file:
<exceptionManagement mode="on">
<publisher
assembly="MyAppBlockTest"
type="MyAppBlockTest.ExceptionPublisher"
logname="My Test Log"
applicationname="Exception Management Application Block Test"
fileName="c:\errors.txt">
</publisher>
</exceptionManagement>
I am now trying to use the Enterprise Library and I don't know how to create a new log. I can only write to the default Application log. Can anyone tell me how I can do this?
Thanks very much,
dlarkin77
|
|
|
|
|
 Please, I need a simple example of as working with Crystal Reports in Visual Basic. Net 2005, taking the data of a database made in microsoft access
Thank you
|
|
|
|
|
Hello!
My aim is to adjust (Birghtness, contrast, gamma, HZ, red, green,blue) values of video. I am able to get the pictures from a web cam but I want to be able to adjust these values also.
If you have an sample or any link, please let me know.
Thanks
|
|
|
|
|
How you'd do this would depend heavily on what you're using to get the video stream and what you're using to display it. Each library is going to have, if supported, it's own methods for doing this.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i am having problems connecting remotely to the existing database in visual basic .net2005 for connection string .
please tell me how to configure sql server2005 for remote database connections and which connection string should i use to make it working.
|
|
|
|
|
I got the same problem with 2005 and decided to use a connection string manually and then the problem has been solved... Use a connection string variable as shown below:
Public ConnStr As String = "Provider=Microsoft.jet.OleDB.4.0;Data source=" & Application.StartupPath & "\Database\lyrics.mdb;Jet OLEDB:Database Password=111111;"
|
|
|
|
|
The string you provided is for an Access database, not SQL Server 2005.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
You are abosuletly right David! It was my out of attention. anyway. He can rich the information at www.connectionstrings.org or .com
|
|
|
|
|
SQL Server 2005 has a tool called the SQL Server 2005 Surface Area Configuration tool. You'll find it under Start/Programs/SQL Server 2005/Configuration Tools. Start that, then click on Surface Area Configuration for Services and Connections. In the left side navigation pane, click on Remote Connections. I think you can figure it out from there.
As for the connection string, a basic string using standard security would look something like:
Dim connStr As String = "Data Source=serverName;Initial Catalog=databaseName;User Id=userId;Password=password"
You can find more on connection strings at http://www.connectionstrings.com[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
did i need to imports any namespace for using redim and preserve in vb.net??
|
|
|
|
|
No you don't have to. The Arrays can be re-dimenssioned unless you define the dim statement inside the block if statement 
|
|
|
|
|
I have 6 textboxes (max 5 chars)..when user fill the first textbox with the 5 chars, i want the write_cursor goes to next box..is there someone to tell me the way? is there a property for this or i must make a new sub for this? Thanx..
-- modified at 7:11 Monday 13th March, 2006
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
