Comments by NaibedyaKar (Top 72 by date)

Strange!! This is working fine for me..
This is my code.

[Route("api/Products/GetPackCountsTest")]
[HttpGet]
public IHttpActionResult GetPackCountsTest()
{
var products = _productRepository.GetPackCounts();
return Content(HttpStatusCode.OK, products, Configuration.Formatters.XmlFormatter);
}

I think I understood the requirements and the output that you want. But I got confused when I see the scripts that you provided.

You need the bucket table to have the full capacity as 100, 50 and 70. Also the bucket values should be filled from B1, then B2, then B3. Then why are you inserting values as
insert into dbo.Buckets (fullcapacity,currentamount,BucketID)
select 10, 0, 1
union
select 5, 0, 2
union
select 10, 0, 3
union
select 10, 0, 4

BTW, you can insert multiple rows to table without using unions.

Then where is your 2nd table?

I think you are not inserting rows into the @BrandTable.

Use SELECT @TktId instead of Return @TktId.

Send the the code for new function. What is the error you are getting.

yes, you will have to provide the entire path for your exe. Else how it will know the path :).

Glad that it worked for you.

I have given an example how to do that for webgrid.
You can select the header element of your grid using jquery selectors and append the text to it.

check this link to understand how to return table from UDF

http://www.codeproject.com/Articles/167399/Using-Table-Valued-Functions-in-SQL-Server

I can give you a an idea how to handle this. I might not provide you the exact UDF code.
Currently as per the above function, we are checking for the angle brackets start and end after that removing the whole string inside it. And then concatenating all those string and returning as a varchar.

You can change the function to return a table.
CREATE FUNCTION [dbo].[udf_StripHTML1] (@HTMLText VARCHAR(MAX))
RETURNS @OutputTable TABLE
(
Brand VARCHAR(255),
Name nvarchar(255)
)
.. . .. . .. . . . .
.. . .. . .. . . . .

And then instead of concatenating the strings, you will have to insert that to the table. So you have to write the logic in such a way that the whole string can be separated at a proper fashion.

Bit not clear on the requirements.

You can use this inside your select query

SELECT Id, dbo.[udf_StripHTML](HTMLColum) FROM TableContainingHTMLData

ok..
STUFF function inserts a string inside another string at any given char index.
So if we will write

<pre lang="SQL">SELECT STUFF('FirstString', 4, 1, 'SecondString'); </pre>
The output will be FirSecondStringtString. This is because, the second string is inserted at the 4th position of the first string and 1 char is removed next to the first string.

Fir + SecondString + tString (s is removed from the first string).
Follow [^]

CHARINDEX, searches a string inside another string and then provides the start position for the found string.
<pre lang="SQL">SELECT CHARINDEX ('string to search', 'Original string to search or test', 0 )</pre>

The output for this will be 10. That means the 'string to search' is found at the 10th position from the 'Original string to search or test'. The 3rd parm is an optional parameter which state, after how many chars we should start searching.

Check more on CHARINDEX (Transact-SQL)[^]

What do you mean by the source code is imported by SQL.

Can you tell me which lines or keywords from the above function you need explanation.

Sorry for the late response, I was busy on something else.
You can use IsIconic(instance) to know whether the application is minimised or not. Let me show the whole code as a separate answer.

What error did you get. Did you get error while creating the function or executing the function?

Once you create the UDF, then call it as below
SELECT dbo.[udf_StripHTML] ('<div id="naver">
- <ul id="naverlist">
-- <li class="overbrand" class="navhome">HOME</li>
- <li>Acer</li>
<li class="navspecial">Contact Us</li>
</ul>
</div>') AS OutputText

The code basically checks for the angle brackets start "<" and end ">". After that it removes the text inside this. Thus by removing the html code and just keeping the plain text.

Ohh, ok.
Can you check this link http://stackoverflow.com/questions/9960753/how-to-minimize-restore-a-window-in-c-sharp?answertab=active#tab-top

foreach (Process proc in Process.GetProcesses())
{
if (proc.MainWindowTitle.Contains(p))
{
IntPtr handle = proc.Handle;
Program.WINDOWPLACEMENT wp = new Program.WINDOWPLACEMENT();
Program.GetWindowPlacement(handle, ref wp);
if ((wp.showCmd & 2) == 2)
{
wp.showCmd = 9;
MessageBox.Show("Restoring");
}
else
{
wp.showCmd = 2;
MessageBox.Show("Minimizing");
}
wp.length = Marshal.SizeOf(wp);
Program.SetWindowPlacement(handle, ref wp);
break;
}
}

Why do you want to call the windows application form the web. Can't you do the same thing using the webservice code.

Not able to get your question, can you please be more descriptive.

Just click on "here". Anyway I am providing it below.
http://www.codeproject.com/Articles/1083/Multithreaded-Programming-Using-C

Then i think that is the issue. I mean is you have applied it on the parent level and child level, the repetation is happening.

Can you provide some more details of your requirements here. Provide the table structures and the expected output.

Here is a link which you can follow to create the service.
http://www.codeproject.com/Articles/3990/Simple-Windows-Service-Sample

Good man, cheers

What have tried for this. It is as simple as checking which option of the radio button checked and then sending the email.where is the issue are you facing exactly.

Can you take a look at the below link
http://www.codeproject.com/Tips/403031/Extension-methods-for-finding-centers-of-a-rectang

Ohh yes, Gopu, you are right. My bad.
Sorry Madhuri. Please check ddlGodownName is having the autopostback is set to true or not.

I am happy that I helped you.. But Ryan advice is also correct. Why don't you try to use parameterized queries. Something like mentioned here. Else we can kill your DB server easily :)

http://stackoverflow.com/questions/17509169/parameterized-queries-vs-sql-injection

Hmm, ok. Did you check the data in the table is coming fine?

Not much sure why it happens like that. Can you check if your have applied the key above to this folder.

Well, it is just to help him knowing how to fix the issue.

Your update query is wrong.

Can you tell us what error are you getting and where

Bit confused on your above question. But what I understood is you want to use both no-cache and no-store. For that I think you can add one key as Cache-Control with value no-cache,no-store.

Did you add the fields on the report viewer?

Hi Suresh, did you try with anything that you can post here.

Did you add the fields to the report viewer properly?

yes, I think you can do that in the same way by adding a new header.
Do you really want to add no-store? Check this http://blogs.atlassian.com/2007/12/cache_control_no_store_considered_harmful/

Yes, it can be applied to all the resources. You can add it at root level or folder level.

Can you check if the excel object is being closed properly. Can you provide you code here.

Well, I think it is some work around, but might not be the best approach.
Can we not use disconnected architecture or something so that we will have all the data in place and no way we have the exceptions. Not sure if it is really a valid.

Why don't you add one condition there to check the database connection before doing any task.

Why do you want to show PDF on Picturebox. How that will help you checking all pages?

Have you tried with something yet?

Happy that it helped you

Ahh, ok. Good.

I think your application is not given permission to access that path. Can you run your application as an administrator. Right-click on it and select "Run as Administrator". If still not working, let me know. Provide me the path that you are trying access. Change the path and try to access.

We did not get your issues on this. Can you please be more clear.

Do you mean the database is hosted on your machine? If so then the connection will close when you stop the server.

Can you please paste it on a notepad first and then copy from notepad to here. If that would help.

The above code is showing image.Are you sure you provided the correct code snippet here.

What kind of validations you have used? You can also validate the textbox values on serverside code if you want to double sure on the validations.

Do you mean you want to create some unique URLs that can be used once?

I think you can do that by first importing the excel data to datatable or list and then you can play with the list data to export to any format. Hope this makes sense. let me which step you need help.

Nice reply Suraj. But I answered him :(

What do you mean by "according to the page required"

Can you check if you get data in your db if you connect these columns first. I hope you have created the relations in datbase itself before showing that on the report.

It will not affect it as each application will create it's own instance.

Hi Srinivas, I believe I answered the same issue on a different question of yours. You can achieve this by using the windows service. Or you can create a console application to connect DB and call the function/stored procedure. Then you could trigger that console from a windows scheduler.

If you want to use same logging feature on all of your projects, then better to create a separate application and use the assembly on all your projects.

Srinivas, I think you have the answer in the question itself. You can achieve this by using the windows service. Or you can create a console application to connect DB and call the function/stored procedure. Then you could trigger that console from a windows scheduler.

Actually it is very easy to do on html5 canvas. That is what I wanted to say. Anyway if you want to do it without canvas, then you might like to check the below links.
http://www.java2s.com/Tutorial/ASP.NET/0180__Development/GenerateImagepaintstringwithfontanddrawimageC.htm
http://www.codeproject.com/Articles/7462/Dynamically-Write-Text-On-An-Image

The best option for this to work with canvas

You can show validation messages like here http://www.codeproject.com/Tips/721384/Data-validation-in-WPF

Hi there, I think crystal report is not setup properly at your server. We need to add some references, create virtual directory and all. If you have installed the crystal report then things must have been setup properly. Can you please confirm.

Can you check if there is any virtual directory present for the website.

Are you doing any DB operations. Can you share the code which is creating the timeout.

I think it is always better to setup the scheduler on your server/machine where the scheduler will run. If you want to do it from your code then you would like to check the below blog.
http://bartdesmet.net/blogs/bart/archive/2008/02/23/calling-the-task-scheduler-in-windows-vista-and-windows-server-2008-from-managed-code.aspx