Comments by Guirec (Top 68 by date)

Use a List... that is your best option here.

Vicious solution :)
You are right that is doing the job but I would still not consider that as a viable answer : apart if you want to appear in coding horror's hall of fame :)

Yes you first problem is fixed... that was for sure.
Now as I told your query is pretty messy and I am not surprised it is not bringing the result you expect.

If you need some help regarding this then you'd better describe your tables and the expected output...

Statements like : "give a result set and a single row for each center_id" does not mean much. In SQL a select always return a result set and nothing else. a result set period.

I suggest you open a second question.

If on -- client -- side the uploaded document is located at "D:/Document.xls" then every standard browser will send you back that path without any error.
So whether something in your question is not making sense or your clients are using self-made browsers :)

no you can't... that answer is misleading

I understood it is not notepad you want to launch in the end and you just use that as an example. That is the same for my answer... Replace Notepad with CutomExe and the answer remains exactly the same.

Maybe your design could be changed to an alternative solution...
it is much more common practice to see rich client applications (winforms, wpf, gtk, ...) embedding a browser control rahter than trying to perform rich client things inside the browser (this ususally leads to too many incompatibilities and security issues).

Hi Johnny J Don't lose your time answering these guys. You can report them using the red flag.

If you start debugging on your test server then it is not a test server anymore but a development server.

You'd rather implement logging and tracing.

your question can not be answered: Cache, cookies and ViewState are 3 completely different things.
If you want to persist data on your server side and retrieve it in a fast manner then caching is your solution.

the method is probably returning null because the value of your xpath param is not a one which returns any result...
If you want to get some result you should use :

GetLinkOfNews("//a");

is this what you are doing?

then you don't need to transform into a datatable...
you just have to bind your result to the listBox.

what do you mean by "relevant" ?

if you mean equals you just can do : text.Contains(searchedThing);

Client side? javascript ? jquery?
Server side? .net? php?

What is the sql type of afa.address ?

do you have the html part?

who's downvoting this?? It is a pretty straightforward answere and which works for sure...

Your problem is a bit more complex than it looks.
The simple way is to store your filenames in the user session object and then when the user submit the form you get all the filenames but that is a pretty poor design which can have a lot of side effects (eg: if the user has 2 browsers open to upload files for 2 different 'things')

The proper way to handle it is to store the filenames in a hidden field of the page. You can do so by registering a javascript function to the OnClientUploadComplete attribute of your FileUploader control.

if your viewbag contains the imageName are you sure it does not contain its extension as well? If yes you have to remove the +".jpg" part in your model.

In my opinion there is no contest: I vote for MVC.
The fundamentals of a protocol agnostic service mechanism (WCF) is very interesting in theroy but in reality it is a pain in the neck (debugging and configuration) for almost every user. Many architecs are reverting from it now in favor of home made API or technology like WebAPI.
MVC will serve you more on your resume.

ok so don't transform it to a string represnetation but to a Decimal one.

ah ok, sorry.
To solve your issue I suggest you add an additional property to your source object. This new property (let's say you call it MoneycolumConverted) would be the ToString() value (or whatever string representation...) of your Money property then you could write your filter like :

dt.DefaultView.RowFilter = "MoneycolumConverted = 12345.67"

should work...

Did you try with '==' instead of '=' ?

Message to the serial downvoter.... My answer was pretty valid before "Member 7993229" edited his question...

Could also be that you are behind a proxy. No problem within browser but you have to set the proxy details inside the code as well (or in the System.Net part of your web.config). Check here : http://msdn.microsoft.com/en-us/library/kd3cf2ex.aspx

does the account (user) running the IIS process has any right on that directory? On your local mahine you are probably admin so it definitely works.

diffgram.getProperty("NewDataSet") ;

diffgram must be null... I don't see any "diffgram" prooerty in your wsdl either..

sql engines are usually very good at interpreting....

I suppose you want to open communication with an external device using a serial port. Right?

Do you suggest we count the lines ?

Your question is a bit unclear to me. Could you be more specific on your goals and also tell why reflection is not suitable? If you want to loa a 3rd party dll at runtime I guess you don't have much choice...

Please complete your question:
do you want to completely get rid of the stored procedure and then do a rewrite in C# ? or do you want to make a call to your procedure from C#?

Do you have the excel manual as a file already?

You should try to save your file to disk before giving it to the SmtpClient class.
1. you can make sure your file is actually not empty before you send
2. when sending the fule it is most likely that the HttpResponse (container for your input stream) has been disposed already.

simply replace 'Response.OutputStream' by a variable you will declare as new MemoryStream();
then you can uset the newly created stream to save the file to disk and render it in a windows form.

it is you File.OpenRead(blobfilePath.Replace("https","http")); which does not support URI formats.
To open your azure file you should do WebRequest.Create as well if it is distant or File.OpenRead but then with a path not a url.

Just an idea... Create a user in the destination machine with the same login as the one who was 'owning' the backed-up database...

Good to you.

Sorry mate but your question started with "i want to put a lot of items in the toolstrip about 150 item ".
if that's not what your aimming for then click the "Improve question" link and modify your question. We are not psychics.

In your case the proper way of doing it should have been:

var bytesArray = System.IO.File.ReadAllBytes(filenpath);
var decodedString = ASCIIEncoding.ASCII.GetString(bytesArray);

But I'm not even sure that's what you are aiming at given the code you announced as being a solution.

This post is a pure delight!
"Text into Key" means nothing my friend....
What were you looking for? a function to decode a set of ascii characters into a string? Why don't you ask for that then?

Oooohh dude! the more you explain the less understandable it gets.

I am wondering how you guys do... I mean you, OG and all others dedicate people! I am happy to help either but there are times when we are not talking about helping!

There is really few chances your code is raising an exception with a catch{ /* DO NOTHING */}

Is the user (windows account) trusted to access SQL Server?

Ooooch!

It was originally intended to deal with any alphabet based written language.

your second select should return values for columns paid_amt, payment_mode, etc... (even if null values)

that's most probably where your mismatch come from I suppose.

What do you mean by you are unable?
Don't you even know how to start or do you already have some code producing an error?

Whether your function is not called at all for the last line, whether your "oldValue" is not in the line... Your function should work fine. Problem must be external.

Is your first database setup with AutoIncrement on primary key ? If yes check that second one has the same setup.

But what are you trying to achieve?
You retrieve a list of entities from db
You enumerate the list a first time. In that enumeration you (in a weird way) delete the object from the entities set.
Then you save : at that point your table should be empty.
You enumerate the list a second time. In this new enumeration you create a copy of the object to add it again to your table.

In the end your method is just doing nothing but consuming system resource.... I mean I don't see the point in removing all records of a table and recreate them at identical.

I guess you understand the issue the same way as we are when reading the exception...

When you look at the generated source (before you click the button) do you have 3 <td> in per row?

What is your intent? Do you want to prevent people being able to read your source code? If yes, you need an obfuscation tool. Otherwise please rephrase your question.

If I understand correctly you have some sql which makes usage of the "print" function and you want to get the output string appearing on a web page. Right?
if Yes then there is no direct way. You have to modify the sql so that you create a variable which is the concatenation of what you are printing and then use that variable as an output command of your ado.net query.

It is actually not stripping the html off... but it uses the "plain text" flavor of the Clipboard while Word is using the "rich text" flavor...
If you want to strip html tags you can do this in c# using a regular expression. Something like:


public static string RemoveTags(string html)
{
return Regex.Replace(html, "<.*?>", string.Empty);
}

I don't know who downvoted the solution to 1 but some explanations would probably make sense :)

I have to tell your sp is a bit 'unreadable' but as far as I see :
1. your cursors usage seems to be correct
2. I don't think you need cursors at all. You should be able to do the same job with some standard insert/updates clause. You just need to insert/update based on joins and where clauses.

in your cursor's loop you can use commands like :
print 'I am getting there'

You can then trace execution.

This will affect security but give it a try to check if your problem comes from there. You can change that afterwards if issue sits there.
You have to be admin of IIS for that. Are you?

Nothing related to cursor...
You explicitely said sql server not to show how many records are affected.
Comment the line: SET NOCOUNT ON

What credentials is your XMLDownloadManager using when getting the stream (see stacktrace) ?
I would say you have an error while reading rather than when writing. Did you try to enable anonymous access in IIS?