|
code is :
imports system.data.sqlclient
try
dim str as string="update tblLogin set Uname='" & txtName.text & "',Passwd='" & txtPasswd.text & "'"
dim cmd as new sqlCommand(str,con) 'Con is declared as public sqlConnection
connectToDatabase.Connect() 'It is a method used to open connection if it is closed.
cmd.ExecuteNonQuery()
msgbox("Sucess")
catch ex as exception
msgbox("Error is : " & ex.message)
end try
'end code
Now the above code shows message "Sucess",it means query run sucessfully but it does not change actual data in database.
Suggest me what should I do now.
Thanks for quick reply.
Gagan
|
|
|
|
|
1. Check the returned value of ExecuteNonQuery statement.
2. Check the connection string if that is pointing to correct database and you are checking the same.
जय हिंद
|
|
|
|
|
The returned value of cmd.ExecuteNonQuery is 1.
I have also checked database connection string and test connection with database.Everything is ok but query is not making permanent changes in database.
What should I do now.
Thanks.
Gagan
|
|
|
|
|
David and d@nish both have good suggestions.
Here's one for ya. If the query looks ok and there isn't an obvious error - run profiler.
Open up SQL profiler and examine what's being sent to SQL server. Profiler doesn't lie and quickly will 'highlight' what the problem is. If the query is making it to the server - ensure it's hitting the right database (if the connect isn't making it, then it's a connection problem of some kind probably).
If it is making it, copy and paste the SQL statement being sent into a query window in SQL Management Studio and try to execute it. If there are errors fix them in the query window and re-execute to verify. Since your problem is that it's not updating the database, add a select statement at the end to verify the records are being updated. If correct, then update your source in VB. Also check your where clause and make sure your updating the right records. If there is transaction logic, it'll be shown (although possibly split on multiple lines in profiler).
IMO: Profiler is one of the best benchmarking and diagnostic tools for SQL.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Ok Jon but from where I can run Sql profiler to check my query???
Thanks.
Gagan
|
|
|
|
|
On your computer. Cant you even find a software installed on your machine and run it?
जय हिंद
|
|
|
|
|
He may have thought it was built into Database management studio (although you can launch it from there too under tools).
Everybody has their off days (god knows I do) - lol.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Jon_Boy wrote: although you can launch it from there too under tools
That is the reason I replied like that. One might find it rude.
If someone is using Management Studio, he/she must have seen tools menu atleast once.
जय हिंद
|
|
|
|
|
No problem Gagan,
Start Menu -> Progs -> MS SQL Server 2005 -> Performance Tools -> Profiler.
Quick and dirty usage (later, you really should learn the ins and outs of this tool - it's worth its weight x 100).
Start it up. Select the server that this query should be going to. Select the default trace.
A trace will start running reporting everything on the DB. If there are multiple devs/users using the server, then a crap load of events will be displayed rapidly.
Pause the trace (button on the toolbar ||). Put a breakpoint in VB where your CMD is about to execute. Go back to profiler, press Start |> Execute your SQL command and then repause Profiler. All the lines you see are the raw statements being sent to SQL server. Look for your update statement and copy that out to a query window. If nothing is there, prob. a connection issue of some kind.
Once you get used to profiler you can create specific traces by DB, users, events, etc.
Hope this helps ya out bud.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
So what's the word Gagan? You've left us hanging - what did you find?
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
If you are performing these updates inside a transaction, then you have to make sure that you perform a commit.
|
|
|
|
|
I have a .txt file.
i want to read that .txtc file as a DataSet
any help on how to do?
|
|
|
|
|
Create OleDbConnection to it and the fill the dataset as done with any database table. Or use methods in File class and manually fill the dataset.
जय हिंद
|
|
|
|
|
|
What do you want to do? Write data to text file or read data from text file?
जय हिंद
|
|
|
|
|
Hi all... I'm working on a report (Reporting Services) with an external image. The problem is it's not showing up. I'm passing the image through as a base64 string to the report and converting it back to bytes using the Convert.FromBase64String function. The code is as follows
Dim location As String = Configuration.ConfigurationSettings.AppSettings("location")
Dim reader1 As New System.IO.StreamReader(location)
Dim base64 As String
Dim BinRead As New BinaryReader(reader1.BaseStream)
Dim file1 As New FileInfo(location)
base64 = Convert.ToBase64String(BinRead.ReadBytes(CType(file1.Length, Integer)))
Dim param As New Microsoft.Reporting.WinForms.ReportParameter("Image", base64, False)
Dim al As New List(Of Microsoft.Reporting.WinForms.ReportParameter)
al.Add(param)
ReportViewer1.LocalReport.EnableExternalImages = True
ReportViewer1.LocalReport.SetParameters(al)
ReportViewer1.RefreshReport()
.
.
.
Please ignore the BinReader / Reader bit. I havn't fixed that up yet. If someone can please tell me why this thing is not showing an image. I would be very greatful.
Stephen Lintott Bsc IT (RAU)
|
|
|
|
|
hi
modified 28-Nov-12 8:53am.
|
|
|
|
|
I'm a little confused on your post, but I'll give it a shot.
You could read the entire file into a stringbuilder and then do the concatenation at the end or you could read the file in line by line and combine the fields. Once the string builder has been modified with the changes you want, write it back out to the new file. You'll want to use something like the stringbuilder since strings are immutable.
If there are field headers at the top of the file, you'll want to remove the AEC_COMPATIBILITY header.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
hi all,
i am very confuse about OOPs . Anybody can provide a good link which decsribe each OOPs concept and prove it is better than procedural with example (for example compare C and C++) or we can do work in more efficient way in OOPs compare to procedural language
|
|
|
|
|
OO has a set of advantages over procedural programming, but procedural has it's merits too. It's just a different way of organizing your code - You can read all about it on the Wikipedia.
Don't forget to write an article detailing your conclusions 
--edit--
I'm not calling one better than the other, each has it's own place.
I are troll
|
|
|
|
|
Sounds awfully like a homework assignment.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
The answer most often hinted for in a question like this (from what I remember from my first college course) is re usability, polymorphism and umm what was that third bullet point? *checks old notes still saved in my documents* thats it inheritance.
google / wiki
|
|
|
|
|
Funny part that was the first question during my interview and my boss said "you'd be surprised at how many people I interviewed that didn't know any of the three".
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Any? I can imagine forgetting the actual word but knowing the definition, but any? Thats just bad form. Those words where (mostly) burned into my brain for the first 3 weeks of college.
|
|
|
|
|
Yeah.......they ran an ad in the paper at first and got a bunch of people who obviously didn't know squat although claiming otherwise. After that hiring and failing phase, they went through a head hunter (who pretested candidates) prior to being interviewed by the company.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
