Visual Basic

Re: SQL query is not making permanent changes in database.

24-Mar-09 3:37

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.

जय हिंद

Gagan.2024-Mar-09 3:42

Gagan.20

24-Mar-09 3:42

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

Re: SQL query is not making permanent changes in database.

Jon_Boy24-Mar-09 3:50

Re: SQL query is not making permanent changes in database.

24-Mar-09 3:50

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

Gagan.2024-Mar-09 3:57

Gagan.20

24-Mar-09 3:57

Ok Jon but from where I can run Sql profiler to check my query???

Thanks.

Gagan

Re: SQL query is not making permanent changes in database.

dan!sh 24-Mar-09 4:18

Re: SQL query is not making permanent changes in database.

24-Mar-09 4:18

On your computer. Cant you even find a software installed on your machine and run it?

जय हिंद

Jon_Boy24-Mar-09 4:33

Re: SQL query is not making permanent changes in database.

24-Mar-09 4:33

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

dan!sh 24-Mar-09 4:47

Re: SQL query is not making permanent changes in database.

24-Mar-09 4:47

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.

जय हिंद

Jon_Boy24-Mar-09 4:30

Re: SQL query is not making permanent changes in database.

24-Mar-09 4:30

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

Jon_Boy24-Mar-09 6:04

24-Mar-09 6:04

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

Transactions ?

David Mujica24-Mar-09 3:18

David Mujica

24-Mar-09 3:18

If you are performing these updates inside a transaction, then you have to make sure that you perform a commit.

Text File to Dataset

vijay248224-Mar-09 3:06

vijay2482

24-Mar-09 3:06

I have a .txt file.
i want to read that .txtc file as a DataSet
any help on how to do?

Re: Text File to Dataset

dan!sh 24-Mar-09 3:09

24-Mar-09 3:09

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.

जय हिंद

Message Closed

24-Mar-09 3:49

vijay2482

24-Mar-09 3:49

Message Closed

Re: Text File to Dataset

dan!sh 24-Mar-09 4:16

Reporting and external images

24-Mar-09 4:16

What do you want to do? Write data to text file or read data from text file?

जय हिंद

Stephen Lintott24-Mar-09 1:39

Stephen Lintott

24-Mar-09 1:39

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)

Text File using VB.Net

vijay248224-Mar-09 1:00

vijay2482

24-Mar-09 1:00

modified 28-Nov-12 8:53am.

Re: Text File using VB.Net

Jon_Boy24-Mar-09 1:27

How OOPs is better than Procedural

24-Mar-09 1:27

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

sunil goyalG23-Mar-09 22:52

sunil goyalG

23-Mar-09 22:52

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

Eddy Vluggen23-Mar-09 23:25

Eddy Vluggen

23-Mar-09 23:25

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 Smile | :)

--edit--
I'm not calling one better than the other, each has it's own place.

I are troll Smile | :)

Jon_Boy24-Mar-09 1:18

24-Mar-09 1:18

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

EliottA24-Mar-09 4:20

EliottA

24-Mar-09 4:20

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

Check out the CodeProject forum Guidelines[^]

Jon_Boy24-Mar-09 8:22

24-Mar-09 8:22

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

EliottA24-Mar-09 8:27

EliottA

24-Mar-09 8:27

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.

Check out the CodeProject forum Guidelines[^]

Jon_Boy24-Mar-09 9:10