Comments by Mathi Mani

Mathi Mani 12-Apr-16 14:06pm View

I do not understand, why your code uses the command object with query set only once, for filling dataset/datatable and running non-query. You might want to check that. Use debugger to see what is really causing the issue and finally, as Richard mentioned, remove the username and password from the posted code.

Mathi Mani 12-Apr-16 13:28pm View

Ok, but what is the question?

Mathi Mani 31-Mar-16 17:26pm View

Seems like the source path is incorrect. Should it be a relative path, beginning with "~"?

Mathi Mani 23-Mar-16 16:40pm View

You are calling Test.aspx and you are getting the page content. It seems like it is working correct. May be if that is not what you want, then change the URL to the correct one.

Mathi Mani 23-Mar-16 13:58pm View

The example is using JSON, but you are expecting XML. Try changing the dataType to XML and see what happens.

Mathi Mani 18-Mar-16 12:56pm View

There is no postback in mvc. Whenever the user submits the form after filling the details, the controller action method receives the values entered by the user and Title will be a part of it. Or you can also use jQuery to get the selected value as mentioned in comments by Rishikesh.

Mathi Mani 2-Mar-16 15:24pm View

Can you please share what the error is?

Mathi Mani 27-Jan-16 13:53pm View

It is a 5!!

Mathi Mani 6-Jan-16 17:09pm View

Did you try placing Database1.mdf in App_Data folder? If not place it under that folder and try to access.

Mathi Mani 23-Dec-15 14:27pm View

Please check whether the URI you are using is valid, by directly putting it in the address bar of the browser.

Mathi Mani 14-Dec-15 17:50pm View

Your update statement is missing Where clause, causing all the rows to be updated. Add a where clause and it should fix the issue

Mathi Mani 12-Nov-15 20:20pm View

I think what you need to use is IDENTITY at the database level for the column you want to be in sequence and auto generated.

Mathi Mani 11-Nov-15 19:26pm View

Since this page requires data from a previous page, check if the data is populated in page load method of the page you do not want to be directly accessed by URL. If it is not, throw an exception and show page based on that.

Mathi Mani 5-Nov-15 19:19pm View

Your code is good as it is. Just check whether the inputs are populated with values as you expect. If you can post the SP here, it can help identify the issue if any.

Mathi Mani 5-Oct-15 13:16pm View

Did you set AutoPostBack="True" in the aspx file?

Mathi Mani 5-Oct-15 12:59pm View

Try calling BindEmpGrid() method from ddlEmpRecord_SelectedIndexChanged

Mathi Mani 28-Sep-15 17:15pm View

Can you add the code show where you are binding data to the DropDownList?

Mathi Mani 29-Jul-15 16:59pm View

Usually authentication details will be sent as part of request header. You are sending as the content. Try changing that. This tip might help you http://www.codeproject.com/Tips/996401/Authenticate-WebAPIs-with-Basic-and-Windows-Authen

Mathi Mani 28-Jul-15 13:27pm View

Yes, you can write left join in trigger. AFAIK, it is not possible to create a trigger bound to more than one table. For your case, you should have some kind of relationship between the two tables and you can used that to get the data from the other table.

Mathi Mani 29-Jun-15 12:57pm View

The syntax for insert is INSERT INTO @return_value followed by the SELECT statement. Your insert query is missing INTO. Please add it and see if it works.

Mathi Mani 25-Jun-15 15:22pm View

Can you update your question with some sample data for the tables used in the query? It may help to determine what might be causing the issue?

Mathi Mani 25-Jun-15 13:00pm View

Deleted

Just a thought. Instead of doing PIVOT and MAX in one statement, try separating them into two. Pivot the data and store in a temp table and then get the max of whatever you want from that temp table.

Mathi Mani 23-Jun-15 14:42pm View

Yes, >= operator cannot be applied to string and string. What are you trying to achieve?

Mathi Mani 19-Jun-15 12:53pm View

Refer this link http://stackoverflow.com/questions/8398031/how-to-insert-data-into-an-existing-xml-file-in-asp-net for inserting data into an existing XML

Mathi Mani 13-Jun-15 14:38pm View

What do mean by does not work? What is issue or error message?

Mathi Mani 13-Jun-15 3:46am View

Glad it helped in some way :)

Mathi Mani 12-Jun-15 17:39pm View

What is your question? Is it why hex code is added? or are you facing any problem in accessing your temp table?

Mathi Mani 12-Jun-15 14:37pm View

Create a model with all the properties you need and use it instead of List<keyvlauepair>. It will make your code clean and reduce the complexities.

Mathi Mani 9-Jun-15 20:26pm View

Is it the same url returning different type of response or different urls? If you can improve the question by providing more details, you may get an answer.

Mathi Mani 9-Jun-15 15:44pm View

What do you mean by "Smaller than"?

Mathi Mani 9-Jun-15 15:30pm View

Does your table has the required indexes? You can see the execution plan of the query to figure out what is taking time. If you are looking for an answer, you can post the time it is taking and query if possible.

Mathi Mani 5-Jun-15 20:11pm View

It seems you are trying to send too many attachments in one email. That may be the reason. Try sending with 1 or 2 attachment and see if it works.

Mathi Mani 4-Jun-15 18:12pm View

It seems like it is a problem with your windows service, as you are saying, the same is working from console application. Try to find out why it is stopping and what is causing NullReference exception. You may get an answer.

Mathi Mani 4-Jun-15 15:53pm View

Question is bit unclear. Are you calling the WebAPI service from windows service or hosting it in windows service?

Mathi Mani 3-Jun-15 16:40pm View

What are you trying to achieve by doing this?

Mathi Mani 3-Jun-15 15:11pm View

What did you try? If you are you facing any issues, post it.

Mathi Mani 2-Jun-15 17:34pm View

What is the error message? What is the name of the class that contains this code?

Mathi Mani 2-Jun-15 13:49pm View

As far as I know, Asp.Net Web forms are the ones with .aspx extension as I mention in my comment. If you are talking about something else, do share that info.

Mathi Mani 2-Jun-15 13:07pm View

Your url seems incorrect. You have to give the correct url. For example, if you have a aspx page called Bind that has BindDatatable method (this method had to be marked as web method in Bind.aspx.cs), then the url should be like:
url:"Bind.aspx/BindDatatable".

Mathi Mani 1-Jun-15 19:19pm View

Where do you keep the details of user's display name? Are you planning to get them from Environment or from some other data source?

Mathi Mani 1-Jun-15 18:55pm View

The question is not clear. What is "client side PC"? What is the type of attachment? To which domain are you sending the email?

Mathi Mani 1-Jun-15 18:39pm View

Please improve the question as well by providing what error you are facing.

Mathi Mani 1-Jun-15 18:38pm View

From where are you getting the Display name? Where are you setting value to it? The code does not have one.

Mathi Mani 30-May-15 3:59am View

Is this happening in the development environment? Are you running the application in debug mode?

Mathi Mani 30-May-15 3:48am View

What do you mean by frequently?

Mathi Mani 29-May-15 0:17am View

It is a code dump, and makes it difficult to see what the problems is. Please improve the question.

Mathi Mani 28-May-15 17:13pm View

Thank you, Sergey.

Mathi Mani 27-May-15 19:27pm View

Implementation seems wrong. Why are you marking Service implementation as [DataContract]?

Mathi Mani 27-May-15 2:03am View

If you are calling any of the methods from FxCOP library, you should reference it in your project. How can you call a method from a library that your project is not aware of?

Mathi Mani 27-May-15 1:54am View

Is this the main class or some other class utilizes this class (by creating object of this class). This kind of error happens when one or more of the dependent libraries (DLLs) are not present in the referenced folders. Did you check that?

Mathi Mani 26-May-15 18:07pm View

Is this the complete code? Which line throws the exception? Shed some light.

Mathi Mani 24-May-15 15:16pm View

What is the error? Can you post it?

Mathi Mani 24-May-15 2:06am View

What do you mean by webservice? Legacy web service, WCF or Asp.Net WebAPI?

Mathi Mani 23-May-15 19:27pm View

Hi, updated the solution. Try now and see if it works.

Mathi Mani 22-May-15 17:38pm View

Because you are having a FOR loop inside FOREACH.

Mathi Mani 22-May-15 13:53pm View

Hi, get the required attribute while getting the value attribute and create a Dictionary<string,string> with these values, having column name as key. Then you can do the validation for all the columns that have the required attribute as true.

Mathi Mani 22-May-15 12:46pm View

What did you try? Can you share the query you have?

Mathi Mani 22-May-15 2:26am View

This is a lot of code and it is poorly formatted. Please improve your question. Sharing the code where you get the exception should be good. Also check the syntax of your insert query. It seems to be the cause.

Mathi Mani 22-May-15 1:49am View

Can you post a sample message body? It will help identify the issue.

Mathi Mani 21-May-15 15:38pm View

You are getting one row each for U0002 and U0003. Is it because these IDs have only one record for each of them in the table?
Try splitting this query. That might help.
First get the ids of interest into some temp table. Then get the details for each ID from this temp table.

Mathi Mani 21-May-15 12:46pm View

Are you using Asp.Net WebAPI?

Mathi Mani 20-May-15 15:44pm View

Where are you getting the error? What is the error you are getting? Provide some more details.

Mathi Mani 19-May-15 13:00pm View

Are you trying to get the count of items with Regid entered by the user in TextBox8? Use TextBox8.Text to get the text instead of passing the TextBox control as input.

Mathi Mani 18-May-15 16:40pm View

Thanks you Maciej. Updated the solution to Vb.net.

Mathi Mani 18-May-15 16:35pm View

Sergy, thank you for your suggestions. But if you look closely at the solution provided, you can find the words "sample code" and "You have to modify the code to suit your needs". And there is no need to down vote the solution as it has answer for Winforms. "3" was hard-coded to make it easy for the person raised the question to understand the solution and relate it to his problem in hand.

Mathi Mani 18-May-15 14:20pm View

By datarow do you mean a row in data gridview? If it is a data gridview you can make use of RowDataBound event to add formatting to the loaded data, which in your case is changing background color.

Mathi Mani 15-May-15 20:34pm View

It seems like you are not binding the data back to the control after filtering. Please check that.

Mathi Mani 15-May-15 19:55pm View

I would suggest LINQ. For joins in LINQ, please search the web. There are a lot of articles that can help you.

Mathi Mani 14-May-15 18:38pm View

Hi, you have to install HtmlAgilityPack from NuGet. Run this command from Package Manager Console to install package.

Install-Package HtmlAgilityPack

Add "using HtmlAgilityPack;" to your class once the installation is completed.

Comments by Mathi Mani (Top 69 by date)