|
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
|
|
|
|
|
Hi friends...
Please help....
I have created a setup in VB.NET and installing in different machines. Now the problem is that the same setup is working on some machine fine, while same setup is not working. When i am trying to run the application its giving a message that "unable to find a version of the run time to run this application".
And also i want to tell you that all those machine having same configuration and same operating system, same anti virus.
Now please help me... i got frustrated with this kind of error.
krishna veer singh
|
|
|
|
|
Are those machines having .Net framework installed?
जय हिंद
|
|
|
|
|
Ditto to d@anish. Is the appropriate framework here: c:\windows\Microsoft.NET\? You could also compare the reg keys (HKEY_LOCAL_MACHINE\Software\Microsoft\NET Framework Setup\NDP\V#.
Depending on your installer, you could include the framework as a preq to be auto installed if not present.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
The error message says that you machines in question don't have the correct version of the .NET Framework installed.
|
|
|
|
|
Does anyone know where can i find a program or sample code that can perform an image or picture search on desktop screen position x and y, then perform mouse action on that image appear.
I found an example program like AutoClickExtreme, but is there any other programs or sample code that i can create in vb?
thanks
|
|
|
|
|
I doubt you're going to find an example of this. Also, VB.NET doesn't support pointers, so a fast search through pixel data would be pretty slow. Writing that aprt of the app in C# would speed it dramatically. Search the articles for "Image processing for dummies" and you'll find examples on how to examine and manipulate pixel data using pointers in C#.
The search logic would probably go something like... scan the screen for the first pixel in the top left corner of the image you're searching for. If found, then start scanning the capture image from that pixel and comparing to the pixels in the search image. If you get through the search image without missing a pixel in the capture image, you've found what you're looking for.
But, then again, you didn't describe what you meant by "image or picture search".
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
