|
|
Hi,
It is not the statement I want but that my following code is giving me error.:
<br />
<br />
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click<br />
SqlConn = New SqlConnection("Data Source=SOORAJ;Initial Catalog=TrackEmp;User Id=sa;Password=; ")<br />
Dim cmdText As String = "DELETE FROM EmpMaster where [Name] ='" & txtName.Text & "'"<br />
SqlConn.Open()<br />
Dim cm As New SqlCommand(cmdText, SqlConn)<br />
cm.ExecuteNonQuery()<br />
SqlConn.Close()<br />
MsgBox(" The Record has been Deleted")<br />
End Sub<br />
This is the error it is giving me
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
Can someone tell me where I am going wrong??
thanks and regards,
lis 
Thinking is like loving and dying.
Each of us must do it for himself.
|
|
|
|
|
I have icons in file dll
but I can't load icon to dll from my program
help me.
thanks
thanks for codeproject
|
|
|
|
|
Make sure your icons are set to be embedded resources by going to the properties of each icon you wish to include. Then, you can access the icon by the namespace of the DLL using the constructor for the icon class.
Dim myIcon as Icon
myIcon = New Icon(GetType(Company.MyProgram),"MyIcon.ico")
The full namespace for the icon is: Company.MyProgram.MyIcon.ico
Build actions for embedded resources are documented in the MSDN Library http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconfileproperties.asp[^].
|
|
|
|
|
Hi, is it possible to have a VB.NET application start up another application on a remote PC? I need my application (writing in VB.NET) to start up MS Word on two remote PC's everyday. Can someone please point me to a good tutrial on this or show me an example of the code that you would need to do this? I can get it to start the application on my machine but not on the remote one...
Any help wil be GREATLY appreciated.
Thanks
|
|
|
|
|
Remote execution is a HUGE security risk!
In order for Word to run, it requires a user account to be logged in. Why not just put Word in the Startup folder of All Users?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hai
I have created the coloum headers for the list view now i want to change the backcolor of the coloum header how can i do this in vb.net
Thanku
lakshmi kala
|
|
|
|
|
Not supported by normal means. You'll have to owner-draw the ListView yourself. The article search is taking awy too long to come back with results right now, but search the articles for "custom Listview" and you'll find a bunch of example on how to owner-draw a listview control.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanku for u response
kala
|
|
|
|
|
Hai,
i'm using 3 form Search,Edit,Add. After adding records in the database by dataset i'm using Search form to show records, clicking on a particular record shows it's content on the edit form. Now the problem is that i want to update that particular row in the dataset and then reflect changes to the database, How can i do that.
Thanks
Nitin
|
|
|
|
|
i have 2 text files. i need to compare both of them by line by line. if diferent then i have to prompt out msg box.
below are part of my code. i have change my code, because before i compare my string i need the file be able to read and loop. currently i have the problem of looping for all the staterment in the text files.
I mean the first line in the text file to loop with the entire of statement in text file 2. then the second line of the text file loop with the entire statement of text file 2.
thanx.. i know the code is messy the post is confusing, but i really tried my best...
Private Sub Command1_Click()
Dim lblA(1 To 10)
Dim lblD(1 To 10)
Dim k(1 To 3) As String
Dim l(1 To 10) As String
Dim line As String
Dim lines As String
i = 1
Open "D:\Documents and Settings\studentadmin\Desktop\Testing.txt" For Input As #1
Open "D:\Documents and Settings\studentadmin\Desktop\Test.txt" For Input As #2
If Not EOF(1) Then
Input #1, line
k(i) = line
lblA(i) = Trim(Left(k(i), 10))
End If
While Not EOF(2)
Input #2, lines
l(i) = lines
lblD(i) = Trim(Left(l(i), 10))
MsgBox lblA(i) & lblD(i)
Wend
Close #1, #2
End Sub
|
|
|
|
|
There are so many things wrong with this code, I don't know where to start! It desperately needs a complete rewrite. Unfortunately, if anyone here rewrote it for you, your instructor would know you didn't write it!
First, your using a for loop to read a file - don't! Use a counter and increment it for each line that you read. Use the EOF() function you used in your first loop. You'll do this twice (You actually doing this twice - once for each file.)
Next, you don't have a single if statement in this code. Where are you doing your compare?
Lastly, overhaul your design. Open one file, read it into an array, then close it. Open the next file, read it into another array, then close it. Then go through your arrays and compare them, one line at a time. If the lines are different, then show a Messagebox.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi
can any one tell me
1) how can i reach to Yahoo messenger from my vb.net
program and identify add and remove ID and ... and how can i send & recieve
message from my program to/from other yahoo messenger id?
(Port number that yahoo used and ...)
2) how can i make my id that used in my program always on?
i hope you understand what i mean !!!! 
Best Regards
M.Khayatan
MkhProgrammer
|
|
|
|
|
These questions are specifc to Yahoo functionality and must be directed to them.
They have nothing to do with VB.NET.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi
Do you somebody know how do,to at clicks right mouse button on filename in list showed shell context menu as in explorer?
Thank´s
PS: Sorry,I´m not form england,so my english isn´t very good.
|
|
|
|
|
You can't use the Shell's context menu in your application since your application is not part of the Shell.
There is nothing stopping you from writing your own context menu though.
Are you using VB6 or VB.NET?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm using VB.NET.
Can you halp me,please?
|
|
|
|
|
I´m using VB.Net.
Can you help me?
|
|
|
|
|
|
Thanks but I need the system context menu as in windows explorer.
No my context menu.
|
|
|
|
|
After further research, it can be done. There is a C++ class example here on CodeProject, Use Shell ContextMenu in your applications[^]. I have not found a signle mention of doing this in VB6 or VB.NET.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi, could any one send me the code which i can use to make treeview or list view right to left n left to right i need the code that i can write in vb6.0,
thanks aaaaaaaaaaaalllll
Thanks alot
Metal Man
|
|
|
|
|
There is no known example of such. Most controls for VB6 that (properly) supported mirroring, we're either complete rewrites, in C++, of the controls that your using or we're C++ wrappers that adapted a current control with the proper drawing code.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
ok man, but i dnt understand, d u mean that it cant be done on vb6.0
Thanks alot
Metal Man
|
|
|
|
|
Like I said in my previous post, there are no known examples of it being done.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
