Comments by an0ther1 (Top 200 by date)

Thanks Maciej!

Thanks Alexvw, glad to be of service. I will add it as the answer

Kind Regards

Try changing your DB in your test environment to your Production DB or using SQL Profiler to capture your query in Production - rule out the issue is not data related

Kind Regards

Check your data - change your DB in Test environment to the Production DB or capture the Chart query using Profiler & confirm you are getting the expected data

Kind Regards

Thanks Maciej!!

Does your event handler for OnDataBound - grdLocation_RowDataBound - get fired? Use your debugger to check.
The GridView control is rendered as a Table in the client, if you have data & it is bound to the grid then it should display - I have used it hundreds of times without problem.
Once the page is rendered (visible on the client) what is in the HTML (use F12 in Chrome or IE to view the developer tools)?
Additionally, I would try making it break - change the databinding to a column that you know doesn't exist - change "Name" to "Nqme" for instance - do you get an error that the column cannot be found

Kind Regards

Please use the Reply button when replying, the person leaving the comment will be notified.
Have you checked you actually have data in your DataTable? Use your debugger & confirm.
DataGrids that have no data will not display unless ShowHeaderWhenEmpty is set to true

Kind Regards

Review your code, specifically where you have set your session value.
Object reference not set in snippets 1 & 2 are saying that the session does not contain a value named acct

If the Session does not contain this value you will get object reference not set, typically you would test for a Null value & then reset the value prior to using it, typically something like;

if(this.Session["acct"] == null)
{
// populate the value
}
// get the value and use it

Show your code used to populate the datagrid.

Debug the program - the report will be expecting specific table names in the dataset - are they present?
Does the report do a record count? What table is it looking at? This is still a formula - same as repressed sections, they rely on formulas

Kind Regards

Then the problem is within the report itself.
Reports are very difficult to troubleshoot when you supply a dataset as the source - you will need to try ruling things out - remove all formulas from the report - just comment them out is a good start - then does the report run?
If not, start looking at grouping

Kind Regards

Everything is possible, you have time, money & good... Pick 2.
EG: I want it to be fast & cheap - it will not look good
I want it fast and good - it will not be cheap

If you are creating a table on the server and inserting it into you HTML you can get the data from it in the code behind but it is messy & not really what would be considered best practice. as F-ES Sitecore has suggested, use an editable GridView - this is the correct solution.
Concatenating strings and passing them to the page means a lot of hard-coding & changes in the future will be unreasonable.
If you insist on making a table then use an ASP table & add columns and rows to it - refer; MSDN Table Class

Only thing is oda.Fill(dt) - where is dt declared and what is it declared as? It should be declared as follows;
DataTable dt;
I don't use Oracle but I think you need to include the schema name when querying a table

Kind Regards

Are you sure the path is correct & you have access to it?
For instance, what happens if you use System.IO.File.Exists("<path and file name>")? You may have a permissions issue - try running Visual Studio as an Admin..

What happens if you move the report to a directory such as C:\Temp\Report.rpt?

Kind Regards

No idea, it would depend on the service.
If you cannot just copy the reports to a sub-folder on the MVC site then you may need to look at another solution.
For instance, do you actually need to view the report in the Crystal Viewer, if not you could create a class that retrieves the report in the format requested and returns a - for instance PDF - file to the client.

If you need the Crystal Viewer then your MVC site needs access to the report itself, this can be via the Crystal Reports Enterprise Server if that is on another machine but otherwise there doesn't seem to be a way of loading the report.

Kind Regards

OK...See where you have the below;
<!--<asp:SqlDataSource ID="HPCLMR" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnEmp %>"
ProviderName="<%$ ConnectionStrings:ConnEmp.ProviderName %>"
SelectCommand="SELECT ID, DTE FROM TEST order by id desc" >
-->

This is where you have defined the datasource. You should be able to reset the SelectCommand from the code-behind and then rebind the grid without a datatable.

Kind Regards

In your GridView definition you have the following;
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="HPCLMR"
CellPadding="4" ForeColor="#333333" GridLines="None" Width="228px">
Remove; DataSourceID="HPCLMR"
This may cause other issues, depending on how your datasource "HPCLMR" is populated - there isno code here that shows that..
Personally I do not use the DataSourceId.

Kind Regards

If you have a backup, restore a copy to another location & then work out how to re-insert your data.
Any other method will take longer to resolve and will likely be unsuccessful.

As RedDK has suggested, look at IDENTITY in SQL Books on line & look at the IDENTITY_INSERT option - this allows you to re-insert data including the Identity value.
You will likely need to turn on IGNORE_DUP_KEY when re-inserting the data

Good Luck

Use your debugger - does the event handler DropDownList1_SelectedIndexChanged fire?
Does the query actually return results? It may be a typo but your query has the following in the where clause;
Stock_Take.Username = = '" + DropDownList1.SelectedValue + "'"
Note the two equals signs - that is not valid

Kind Regards

There you go, learn something every day!!
EDIT: I took another look at this & yep, char does have a ToUpper method, but it cannot be called from a char like you would do with a string, you need to use Char.ToUpper(myCharVariable) - I will add in a note on the solution I added.
Cheers & Thanks

The char datatype does not have a method 'ToUpper' or 'Upper' - refer; https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/char

Kind Regards

Thanks Maciej!

What type of command are you talking about? If you are saying you want to execute a method, then a Select..Case statement should work for you - if the command is not an exact match then handle that in the Case Else statement.
If you are talking about running a command such as 'MyExecutable.exe' then you could use Process.Start().

Kind Regards

Please check the date of the question - it was posted in 2011

Answering old questions can lead to down-votes

Kind Regards

Please update your question. We cannot see your screen & do not have access to your computer & no code has been provided.
Sorry but reading your mind is also outside of our capabilities

Kind Regards

The standard DateTime picker cannot have a null value. There is third party controls that can or you need to create a custom one yourself.
This is because DateTime is a value type - value types cannot be null, reference types can be null.

When a DateTime control is created it must have a value, if you do not initialise a specific value it will be DateTime.MinValue

Kind Regards

Fair call Maciej - have 5ed your answer. Nice solution

Both Maciej & my solution have the same problem, but neither of them is dependent on the idrubrique column value.
When a user adds a new namerubrique how does a new column get created in the Employee table?

Use the Reply button to reply to a comment.
You need to debug your code to find out why your app is closing.
I use data grid views quite frequently & NULL values never cause issues, but you could conceivably break them if you are creating your own columns in the form designer.
Additionally, the error is not "the app will not start" - that is what you are seeing. Why you are seeing this is the problem, hence debugging your code will give you more information.
Kind Regards

Have you debugged it?
What is the error you receive?
Have you defined columns in the Form Designer? have you set AutoGenerateColumns to false in your code?

Kind Regards

I would suggest that your function is being called before the DOM has been parsed. Move your script tag to the bottom of the page before the closing body tag - solution updated

Your debugger would assist with this but the reason is as follows;
When you use ParseExact & pass only a time value, the date component is assumed to be the current date.
Therefore your DateTime values will be (assuming date code runs is 1st March 2018);
dateStart = 1st March 2018 2200
dateEnd = 1st March 2018 0800
A difference of -14 hours
The easiest way to resolve this would be to check if dateEnd is earlier than dateStart & if so, add a day to dateEnd.
This may cause other issues but you should be able to resolve them

Kind Regards

Hi Minios,

I tested VerifyDatabase & it does nothing that I can see - even if I change the schema it returns nothing & does not throw an error.

As I said, you may want to change your reports to use Stored Procedures.
They are faster, especially when sub-reports are involved, and avoid the problem

Kind Regards

True, but I want it all!!

Sure, how much do you have to spend?

As far as I know, this is the only way of validating a report.
If you have that many reports you may want to think about some other method of identifying what reports should be updated or use stored procedures for your reports - this is my preference as it avoids this problem completely

Kind Regards

You are probably better off using a Report to generate an invoice. You will be able to format it to meet any requirements that you have and you will avoid a lot of effort.

As for "automatically removes the quantity of the products..." You need to do a rethink.
Each action should be considered a separate process - submit order, adjust stock quantities, create invoice, email/display invoice etc

Thanks Adarsh, my pleasure

Well apart from the obvious - you shouldn't be storing a username & password in a text file - the basic process should go as follows;
a) Capture username & password & click event
b) Increment counter
c) Pass these values to your authentication method
d) Validate the provided details
e) Store user details - if required
f) Return a value to indicate success or fail
g) If fail, check to see if login attempts have been exhausted - exit if so, if not show appropriate message
Immediate problems;
Your button_click event handler does not call your ValidatePassword method
Your StreamReader in LireClient will read each line in your file & split the content to a single element array with 2 dimensions - hence only the last line will be stored.
I suggest you look at the MSDN website for information on a StreamReader for a start, then look at how you can handle authentication
MSDN StreamReader Class
Login Form using Windows Forms - Beginners

Kind Regards

The code you have provided is C# - does this code get executed?
If the code is being executed then debug it.
If the code is not then you need to determine why, client side debugging can be done in various ways.

Kind Regards

Use your debugger - I would suggest that your Insert & Update Statements are not properly formed & do not contain the values you expect.
For instance, what is the actual value of es_click, com_click etc? If these are objects then your statement will probably fail.
Use your debugger to view & get the value of cmd.Text, can you execute this in a MySQL Workbench?
Refer; MSDN: Debugging in Visual Studio

Kind Regards

Do not use string concatenation to create SQL statements, you are leaving yourself open to SQL Injection, refer to the following links;
MSDN: Protect from SQL Injection
W3 Schools:SQL Injection

Secondly, use your debugger - does the TenantLogin session value exist? Is it populated?
If the answer is yes, then you will need to determine why you are not updating the correct record, this could be because of permissions or your statement, your debugger should be able to assist with this - refer below link;
MSDN: Debugging in Visual Studio

Kind Regards

Sorry, had to work - refer updated solution
NOTE: The XML file that is created does have closing tags but are being stripped when saving solution

Kind Regards

Thanks for the info Richard, much appreciated.

No worries, thanks for the translations!!
I go the same error when using writer.WriteAttributeString("xmlns", "xsi", "http://myurl")
You need to use the overload WriteAttributeString(string, string, string, string)
If you use writer.WriteAttributeString("xmlns", "xsi", null, "http://myurl") does it work?

Kind Regards

Am not sure you would see any improvement unless the entire DB engine was running on the GPU. When a query is executed there is the client processing time & the server processing time, since the client passes the query off to the database server for the actual execution you need to look at where the slowdown is.
High client processing time can be due to slow network, poor performance, low specs or it could be due to the presentation itself.
High server time can be caused by insufficient resources to handle a large number of concurrent requests, poor disk performance, inappropriate indexing or poor query design.
I have a table that contains ~2.9 million rows and is approx 2GB in size. A select * on this table takes ~1 minute.
The Client processing time is the majority & the server wait time is ~9 seconds.

Do some performance monitoring - I typically run a tune every 3-4 months and log all queries that take more than 'x' seconds to complete. These are then tracked down to determine the why.

Kind Regards

Refer updated solution - you need to use the WriteStartElement(String, String, String) overload method

Kind Regards

This question was raised 4 years ago & has an accepted answer.
Answering old questions will lead to down votes.

Kind Regards

Then your code should get the value from TextBox10.Text. Your code in your question at the top creates another OpenFileDialog.

Kind Regards

Short answer is yes, but how depends on many factors.
The easiest way is dependent on what your data looks like & how you authenticate the user - their login details should be available to your code behind but via what is dependent on authentication method.
Improve your question - add detail regarding the data & how the user is authenticated

Kind Regards

So what is the problem?
Are you getting an error or is the grid not refreshing when the timer tick event occurs?
Update your question with what problems you are having, but based on the code above you are querying the tempdb - refer connection string Initial Catalog value & you are querying the Products table based on your sql command - not sure how these are messages

Kind Regards

I would imagine the answer is you cannot as whatever program you are using to ZIP the file would need to process the file on the client, hence the uncompressed file would need to be downloaded to the client & then a new ZIP file would be created on the server - assuming you have write permissions to the location.
If the FTP server is yours then it would be a reasonably simple matter to have a process that creates a ZIP of each uploaded file & then deletes the original.

Kind Regards

To reply to a comment, click the Reply button next to their name, otherwise they are not notified.
The database provider determines how you get lists of the database objects. For instance in SQL you query sys.tables to get a list of the tables - NOTE: You must be either the table owner or have permissions to see a table for it to be listed.
Google will help identifying how to get a list of tables in a database - for instance; https://www.google.com.au/search?q=sql+list+tables+in+database&oq=sql+determine+tables+in+&aqs

Kind Regards

I would suggest that you are not using 64 bit Crystal on your Win7 machine.
Install the 32 bit Crystal runtime on your Win 8.1 - does that resolve the problem?

Kind Regards

Improve your question, specifically what data is returned from your query?
col1.Text & col2.Text tell us nothing.
Add some example data

Kind Regards

Step 1: Create a new query in Access & confirm it returns the results you expect.
Step 2: Replace you button click event as follows;

string queryString = "My Tested Query HERE";
LoadDataGrid(queryString);

Look at your code... You are applying the style to the button, not the text box.
Secondly, Text boxes do not have a property for horizontal alignment so you have another problem there.

You may be able to achieve it via CSS but perhaps re-thinking your design is a better option

So what happens?
If you execute the query in Access, does it work as expected?
If not then you will need to work out why it doesn't give you what you want.
If it does then you need to debug your WinForm application.
Refer updated solution for additional information

Gotta give them some credit - this is version 6... In 11 hours... Must be a slow day at work

Where should you get the value for your Group Id?
If you are inserting a child record (EG: You are making an itinerary (Group table) & the Reserving table is a line item) you insert your parent record & retrieve the Record Id & then insert the child record.
Take a look at the following link; https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/retrieving-identity-or-autonumber-values
If the Group Id is selected by the user (normally via a drop-down) then pass that value

Kind Regards

Property Settings have 2 scopes, Application & User.
Application scope is read-only but accessible to all users - Visual Studio does not natively support writing to them but you can create custom getters & setters. Problem you may end up running into though is that your User needs to be able to read & write to the location where you store the underlying file, this may fail depending on the level of user - refer; https://msdn.microsoft.com/en-us/library/system.configuration.settingsprovider(v=vs.110).aspx

User scope is read/write but is accessible to the current user only.

First off you need to work out your requirements - if 2 users operate the same machine should they both get access to your updated list?

Kind Regards

Thank-you. Glad to help, good luck

Use your debugger. 'Object reference not set...' is telling you that one of the values you are expecting is nothing.
Insert a breakpoint in you code before this line, for instance on the line 'string strItemText'
When your code breaks into the debugger test each value in the Immediate Window by entering your command (preceded by a question mark) & pressing enter - eg;
? comboBox1.SelectedValue

Kind Regards

Use your debugger as suggested.
From what I can see the standard DataGridView control does not have a property named SelectedValue hence your code should not even compile.
If you use your debugger - use the immediate window - what happens when you enter as follows?
? dg.SelectedValue.ToString()

Is it the value you are expecting?

If it is the correct value then you need to look at your TableAdapter statement, specifically; Is your delete statement well formed & does it actually do what you expect?

Kind Regards

This question was answered & accepted 5 years ago. Perhaps look at current questions that are unanswered

Do not concatenate strings when inserting or updating data, you are leaving yourself open to SQL Injection attacks, instead use parameters.
The following Code Project article will help you understand what SQL Injection is & how to avoid it; SQL Injection Knowhow[^]

Secondly, use your debugger. Your issue may be due to permissions at the SQL DB level/incorrect format of values (most likely cause)/constraint violations or many other errors.
Your debugger will allow you to see what the error is & will likely point you to the solution.
The following Code Project links will help you;
10+ powerful debugging tricks with Visual Studio[^]
Advanced Debugging in Visual Studio[^]

Thirdly, Exception Handling is not something to ignore, you should wrap all code in try/catch/finally blocks to provide appropriate handling of errors - error handling is a part of good coding
The following links will help;
Exception handling in C# and ASP .Net[^]

After going through these feel free to improve your question if you have an issue that is not resolved

Kind Regards

This question was raised over 3 years ago & an answer exists, pretty sure they are not still waiting on an answer.

The number of tables & join types is irrelevant. The joins specify what records appear in the final result set.
Lets say you have 2 tables, Company & Contacts. When you use an inner join to display Company Name & Contact Name you would only see Companies that have a Contact.
If you use a left join from Company to Contact you would get all Companies, including those that do not have Contacts. If the join was from Contact to Company, you would get all Contacts including those without a Company.
The DataGridView does not include paging, you can use a BindingNavigator & set this as the datasource for the GridView but there is other options.
Improve your question - the best option is really a combination of requirements - do you need to support sorting/filtering etc

Kind Regards

Are you calling me old? Let me get my walking frame you whipper snapper :)

A quick search suggests the following;
a) If the PDF is hosted on an external website you may experience this issue - search for cross domain access on mobile browser
b) If the PDF is local to the site you could try switching the display to block - especially as you are setting the width to 100%
c) Add some text into the iframe
Hope these help

Kind Regards

No problem, if the solution works please accept the solution

Kind Regards

As per below comment - you need to convert your DateTime value to a string in the correct format.
Refer; https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings
Converting the values to parameters will not help - DataTable.Select does not support parameters - refer; https://msdn.microsoft.com/EN-US/library/t5ce3dyt(v=VS.110,d=hv.2).aspx
Use your debugger & the Immediate window to test converting values to the various formats

What is the DataType of your StartDate & EndDate columns?
If they are DateTime columns & in the same format your select should work.
If they are not DateTime columns or in a different format you will need to convert the value you are passing in
Use your debugger & look at the DataType of your columns & check the values.

Kind Regards

From a quick bit of research you cannot do this using Acrobat - it cannot populate a document from a stream. Even if a browser control was used Acrobat never displays from a stream. The stream is saved to Temp Internet Files & then displayed.
Apparently there is a NuGet package that can display a PDF from a stream, do a search for PDFium. I cannot vouch for the functionality nor am I recommending it or endorsing it but it may solve your issue.
Perhaps you need to re-think your design here.

Kind Regards

Joining tables on dates is a bad idea. There should be a key between TbExpenses & PersonalExpenses that joins the data, otherwise you will get all Personal Expenses that match the date value & hence you may get duplicates - this depends on how your date values are stored - if you are using a DateTime datatype & populating the time component then less likely, if you are just populating the date value then you would get all Personal Expense records.
Additionally, as A_Griffin has said, your join statement for the tbExpenses table duplicates your where statement - there is no sense doing this.

Kind Regards

So what is the problem?
The Route URL maps to the controller & action and in your case passes a value to a parameter named "id"
In your controller create a action method that corresponds to the action value in the URL, once complete, create a View from the controller.
I would use a ViewModel that is populated by my controller action

You may want to improve your question here

Kind Regards

You will need to raise the issue with the developer - refer to; http://www.infragistics.com

Kind Regards

Sorry about the delay in responding, have been offline.
Upgrading will not help - refer; https://apps.support.sap.com/sap/support/knowledge/public/en/1217084

The only level of support is for formatting text, not objects such as images , tables etc.

Kind Regards

The Split method in Crystal does not work that way, it is intended to split a string into an array, if you do not specify a delimiter it assumes your delimiter is the space character, hence split(2800) will return a single element array with element 0 as 2800.

Assuming that your value of 2800 is actually a number & not a string & your value "80" is constant then the following would work.

ToString({value} - 80) + " + 80"

If not then please improve your question

I think you are confusing presentation with data.
Data returned from SQL typically comprises of one of the following;
a) A single value
b) A single table containing one or more columns & records
c) Multiple tables containing one or more columns & records
This data can then be presented using different methods - for instance a report can group data to present it like you have listed but the data coming from SQL would be option b or option c & the Report then groups the data.
The same would occur if you were using a tree-view (or similar) control

What are you trying to do with your data? I doubt that you are going to be displaying it in SQL Server Mgmt Studio

Kind Regards

Protected View is set by Excel according to the Users Trust Center settings.
By default files that meet one or more of the following criteria will open in Protected View;
a) Files originating from the Internet
b) Outlook attachments
c) Files in potentially unsafe locations
Option C is also controlled by the File Block Settings in Excel 2010 & later

Kind Regards

If you want to put "3 or 4" items into a single row then you will need another loop to add the data to your Table Cells.

theReader.Read() will read the next block of data - a single row.
If you want to put more than one row into your Cells you need to call theReader.Read() again to get more data.

Based on what you have provided, I would suggest you need to use a Dataset & DataTable instead of a DataReader - refer MSDN documentation; https://msdn.microsoft.com/EN-US/library/27y4ybxw(v=VS.100,d=hv.2).aspx
Specifically read the section on Choosing a DataReader or Dataset
I would also suggest you need to re-think your design

No problem, just trying to assist.
If this answers your question please accept it as a solution

Kind Regards

A guess would be the data types. What datatype is the Value field? If it is text there is your issue, if not what is the error you are getting?

Indexes do not need to be unique HarishRao4.
There is a need to come to a balance with them though, an indexed field allows identification of specific table rows quickly (read) but slows down write operations as the index needs to be updated when a record is inserted or updated.
have a read through the below MSDN article;
https://msdn.microsoft.com/en-us/library/jj835095(v=sql.120).aspx

Run the following query;
SELECT
CHAR(68) + CHAR(111) + CHAR(32)
+ CHAR(121) + CHAR(111) + CHAR(117)
+ CHAR(114) + CHAR(32) + CHAR(79)
+ CHAR(87) + CHAR(78) + CHAR(32)
+ CHAR(104) + CHAR(111) + CHAR(109)
+ CHAR(101) + CHAR(119) + CHAR(111)
+ CHAR(114) + CHAR(107)

Use your debugger.
Look at the contents of your 2 string builders (cb1 & cb2) and see if they make sense as SQL Statements.
If they do not you will need to debug your code to find out why.
Sorry but we have no idea what the content of CheckedBoxList1 or ListBox1 is hence cannot advise you.

Kind Regards

Without knowing how you are using linq but still a possible solution;
I have an MVC project that I needed to use DATEDIFF to group results. After much playing with Linq I found the easiest method of doing it was to use the SqlQuery method of my DbContext.
I created a ViewModel to pass the results between controller and view but you may not need to do this in your situation.
Links; https://msdn.microsoft.com/en-us/library/jj592907(v=vs.113).aspx
https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/advanced-entity-framework-scenarios-for-an-mvc-web-application


Kind Regards

Refer to the updated solution - if you cannot set the values to NULL you would need to set it to a value of the appropriate type (eg; 0 for an int, "" for a varchar etc)

Why are you trying to merge this data?
Take a look at the UNION Statement in SQL - you can retrieve results from multiple tables and return as a single table.

If you are trying to create a receipt & are using Crystal Reports/SSRS to create the receipt, then you need to use a sub-report or query the DB in a manner that retrieves the data as a single table - UNION.
If you are manually creating the file then get the datatables and write them via whatever method you are using.
If you want to display them in a datagrid then you can again use UNION in SQL to join the data and display.
Duplication of of data is typically unnecessary and a product of bad design. Re-think what you are trying to achieve and your design

Good Luck

What Chart component are you using?
If you are using the one I identified then you need to read the documentation & debug it. If not then refer to the documentation of the control you are using.
One thing I can tell you from the documentation, the method AddXY does not accept an array for your X value - refer; https://msdn.microsoft.com/en-us/library/dd456289(d=hv.2,v=vs.110).aspx
Happy to help but we can only see the information you have provided

Kind Regards

No problems buddy.
I read your reply to Maciej - if you need to get either the phone number or email you can use coalesce as follows
[ContactPhoneEmail] = COALESCE(UserEMail, PhoneNumber, 'email@gmail.com')

Cheers

Thank Maciej

Debug your code & see what DataSourceMode of you DataSource control is. If it is DataReader - the default - then you need to change it to DataSet where you define your SqlDataSource - Should be as easy updating your code as per below;
<asp:SqlDataSource ID="dscCustomers" runat="server" DataSourceMode="DataSet"
ConnectionString="<%$ ConnectionStrings:ACCDBConnection %>"
ProviderName="<%$ ConnectionStrings:ACCDBConnection.ProviderName %>"

Sorry, missed that first time I viewed it.
Where you populating dscCustomers? In the code behind? If it is a SQL Data Source then you will be unable to sort it unless you re-set the Command Text to include your sorting and reload the data.
EDIT: I read up some more on the DataSource control & you can sort it but you must set the DataSourceMode property to DataSet. The DataSet will then contain one (or more) DataTables from your query. Refer https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.datasourcemode.aspx

DefaultView is a property of a DataTable, refer; https://msdn.microsoft.com/en-us/library/340c39ak(d=hv.2,v=vs.110).aspx

If you have a small table you would typically query the DB when the page loads & then add the DataTable to the Session object as shown in the example.
When the event handler fires you would retrieve the DataTable from the Session object and apply the sorting as per example.
If it was a large table & you didn't want to add it to the Session object you would reload it from SQL and re-bind to the GridView

Hope this helps

No worries, if this resolves your question please mark it as an answer

Kind Regards

Use SQL Profiler to capture the query being passed into SQL & paste it into SQL Management Studio then verify the query.
From looking at your statement above the Parameter @DesignBuild is not included.
Additionally, your exception handler (catch) says "No Records Found". That is not an exception handler - an exception handler should catch the error and provide feedback to the user about what happened and why.
Kind Regards

This is a duplicate of your previous question (https://www.codeproject.com/Questions/1192250/An-exception-of-type-system-nullreferenceexception) and the same response applies.
Your method "InitConnection" is failing because it generates a NULL reference & code after this point is not expecting the variable to be NULL.
Use your debugger and step through the code in InitConnection.
Kind Regards

As 0x01AA has advised - I would guess you need to revisit your table structure.
DATEPART(yyyy, <datevalue>) returns an Integer, not a Date
YEAR(<datevalue>) also returns an Integer, not a Date
If Table_B.Modified has a data-type of Date you would need to convert your Integer to a Date or change the data-type of the Modified column to an Int

Kind Regards

Yep, that is correct.
The report will load from a sub directory in the folder that contains your Windows Form executable

Cheers

If you are accepting this as the answer, please mark it appropriately. If you need help with something else then you need to raise another question

Personally I wouldn't do this. You will experience performance issues at some point and you are basically letting the user query any table they want to which is probably bad.
You will also need to handle any query that the user writes - remember that crystal uses the query result to determine the fields in the report - you need to go through every variation and create an appropriate display.
A search of the net found the following through;
http://stackoverflow.com/questions/5729434/how-can-i-pass-sql-query-to-crystal-report
The page the solution is from contains a lot of examples but the links don't go anywhere, you may be able to find the examples with a bit of effort.

Re-think your design & requirements. It would be easier to have the report run from a stored procedure that takes some parameters as input and outputs in a standard way that you then display in your report.

Good luck though

I use Crystal Reports and SQL & have no problems, but then again I have 2 enterprise SQL Servers at my work & several SQL Express instances.
Typically the developer sets the requirements which includes the DB but you can support multiple DB's with a bit of effort.
The main difference within the application is the connection string but you may need to create multiple reports (one for each different DB type) depending on the DB type

Use your debugger, the values are not what you are actually expecting.
For instance - when you divide an int by an int you will always get an int (EG: 10/3 = 3, 9/3 = 3)
Math.Ceiling will round up, Math.Floor will round down & both require either a double or decimal value.

Hi Duke,
I am sure someone on here is much more knowledgeable than me but my initial thoughts are.
Based on the premise you have described database encryption will not work for you. This is because the Server Administrators will always be able to access the Database keys. - refer MSDN link; MSDN - SQL Server and Database Encryption Keys
it would be possible to encrypt and decrypt the data within whatever application you are using to read & write to the DB but this may not be practical. If you are using a web interface the web server would need to encrypt and decrypt every string you sent/received from the server. Additionally you would need to ensure you have enough storage space - Using a hash function to encrypt passwords in C# increases the amount of space required dramatically (8 characters turns into 88).
I would suggest a compromise. Encrypt some of the data - the things that are personal and can be used to identify the individuals/team - but with enough data this is sort of doomed to failure.
If I was given a database that was partially encrypted but I knew what the content was about & some of the data was public I would soon identify the individuals.
You could try something like a offline master list of the identification data - not storing it in the database & simply using a unique identifier within the remote DB. Then some encryption of sensitive data.

Kind Regards

Hi JPais,

Pagination will not help - the full result set needs to be identified and then the first 'x' number of records (10 in your case) is returned. It reduces the result set passed to the client but it doesn't speed up your query.
Additionally indexing will not help because you are using %search term%. SQL can use text prior to the first wildcard to identify a result set but that is all.
There is a few options though;
a) Implement categories in your product table - this will help limit your results.
b) Implement Full Text Search - this is probably the best option
c) Create a search table that contains the search words - this is basically re-creating full text search manually & I wouldn't recommend it.

Kind Regards

To get a field value you need to use as below;
string customID = GridView1.DataKeys[selectedIndex]["mycolumnname"].ToString();
But the column name must be included in the DataKeyNames property of the grid definition.
Assume you have the fields MaterialId, Material, pkCityId and CityName as your Grid columns & you want to get the MaterialId & pkCityId values from your code behind you would add these to the DataKeyNames and access them using the code above.
Additionally, check the value of the GridView.SelectedIndex. Personally I use the following;
int intRow = this.GridView1.SelectedRow.RowIndex;

Kind Regards

Hi,

Please improve your question with some more detail - for instance is the actual Grid View on the Master page - I would guess at probably not.

Typically to access a control on a Master page from a content page you need to create a property on the master page & mark it as public before you can access it - refer MSDN How to Reference ASP.Net Master page content
Kind Regards

Hi,

Please improve your question by indicating where you receive the error message - at a guess I would suggest it is when you hit the line "con.Open()"
If so the issue is with your connection string - refer to SQL Connection Strings for a valid connection string for SQL Server - you do not need Microsoft Engine 12.0 as pretty much every version of Windows since XP has come with out-of-the-box support for SQL.
Kind Regards

Sorry, cannot be done. The PrintDocument class is reliant on a printer to create the output. The printer driver is what is displaying the dialog asking for the save location & name.
Short answer is you need to use a 3rd party library such as iTextSharp, you are trying to do this the wrong way buddy.

Kind Regards

Where do you get the error?
Is it in the first query or the second? If it is in the second query does it complete successfully at all?
If the first query completes successfully then your connection string should be fine for the second query, therefore the problem is either you trying to use a connection that is closed (the second query runs once but then not again), your query (the second query returns the error the first time it runs) or some other problem (the second query experiences the error on the 'n'th time it runs).
Things you can try;
a) Move the code; SqlConnection connection3 = new SqlConnection(...) inside your loop foreach(string id in unit_ids)
This will ensure you dispose of your connection, once you have your result, close the connection.
b) Re-write your query. From what I see you are looping through a series of Inventory codes & dates to get your data, each time re-querying the DB & taking only the top result. This is not a good practice - depending on what the method RangeOfDates() does you are likely duplicating results - surely there is a better way of retrieving the data you require - for instance you are using the same dates for each code therefore you be better off passing in a range of dates for each code instead of running a query for each code & date value

Kind Regards

The message you are receiving is saying as follows;
The page you are trying to view has an error but I cannot show you the actual error because of the settings in your web.config file
There is a few methods of determining what the actual error is, for instance;
a) Open the web page while logged into your IIS Server
b) Add additional logging to your website to identify the error
c) Remote debugging
d) Change the setting in your web config while troubleshooting
The easiest method is option A but you may not have access, therefore try one of the others.
I would suggest that you are missing a component of SQL Reporting Services though

Try the updated solution - this should be a bit more robust

Kind Regards

A DateTime variable always includes a time component - if the time component is not set it is assumed to be 12.00 AM
What are you trying to do? If you want to view the Date part of a your DateTime variable you need to convert it to a string - you do not really look at DateTime values just string representations of them.
DateTime.ToString("dd/MM/yyyy"); will give you the value as a string containing just the day, month and year separated by "/"

Use the immediate window & check the table name in the dataset - you will probably find that you Categories table does not exist.
If you use your immediate window you can enter the following;

? DS.Tables.Count

This should return a number (0, 1, 2 etc)
Then get the actual names in the dataset by doing as follows;

? DS.Tables(0).TableName
? DS.Tables(1).TableName
Keep going until you have a name for each of your tables.

Things to note: Tables in datasets do not necessarily have a name unless you set it when you created the dataset.
Both Table and column names are case sensitive.
Object reference not set to an instance of an object means that whatever you are looking for is not there

Kind Regards

The Foxit Reader printer requires User input that you cannot really code around.
There is a few libraries that you can use but each will have different limitations - for instance some are unable to convert Word documents to PDF.
If you are using Crystal Reports to generate the document it can output a Report to PDF directly, same as MS Word - hence my question about the application you are using to create the original file - what is it?

What application is creating the original file - does it have the ability to save as a PDF? For instance, Crystal Reports can output a PDF via code as does MS Word.

If not, try searching Google - for instance;
Google Search

No problem Nikos.
Read up on how form controls raise events in Windows Forms & how you add them to a form control.

Kind Regards

Since you have removed your initial response, I will remove mine

Hi Nikoskap,

Please improve your question by advising where you are having a problem & include the code you are experiencing a problem with.
Remember, we know only what you have told us - we cannot see your screen, your code nor can we read your mind.

Kind Regards

Because Request.Params is not intended to get the value of the input field.
Firstly, change the name (the id) to something that makes sense eg: txtUserName instead of "input"
Then fire up the page & put your breakpoint in the btnSubmitClick Event Handler.
Once the breakpoint is hit, go to the Immediate window in your debugger & type ? txtUserName.Text
This is how you should be getting the value of your Text field not through the Request.Params.
You would actually find that Request.Params("input") is null as the actual key name is determined based on the client id, not the server id. You can find the Client side ID but loading the page to a browser & selecting View Source.
This can be seen by doing the following;
In your Page_Load enter the following;
System.Collections.Specialized.NameValueCollection col = Request.Params;
Create a break-point on this line.
When the line is hit, press the F11 key to step to the next line of code
If you use the Locals debugger window, you will see the client side id of the text field, not the server side id.
If you were to enter the client side name you would get the text field value but you do not need to, you have created the input & can therefore access it in your code behind by simply using txtUserName.Text

Kind Regards

Not sure why you are doing this but anyway..
Assuming you have a hidden field on your ASP page that you are populating on the server then you could populate the field with your text & delimit it with a character unlikely to be used in the text - below I have used a ";" character
eg: sara;matthew
Then on the client side, use;
var objText = document.getElementById('<%=HiddenfieldId.ClientID%>');
var objArray = objText.split(";");

Hi Chris,

There is no problem doing that. Adding a column to a table will not remove the data that exists but some changes cannot be made - for instance modifying a timestamp column is not allowed - refer to MSDN Alter Table Command for more info.

Kind Regards

I assume you are passing in a Deposit Id (or similar) when running the report?
If you were to pass in a Booking Id the Report would then print for each Deposit - if your report is setup so that each page contains a single Deposit then you would get 2 pages if there was 2 deposits, 3 pages for 3 deposits etc.
Using a loop to display multiple reports is not necessary unless there is an extremely good reason. Your code would need to show a Report Viewer, wait for it to be closed & then run the next Report - very messy.

Kind Regards

Improve your question by adding additional detail.
There is several reasons as to why the problem may be occurring but without an idea of what your Stored Procedures look like & additional details we cannot provide any information.
Typically when a stored procedure is called (assuming no record locking is used & no read hints) then both should return the expected data but if one is using ReadCommitted and the other is using ReadCommittedLock then you may experience this.

Kind Regards

1.00 is equal to 1.0000000000. The datatype of a column in a Datatable determines the precision (the number of decimal places the value is kept to) but you don't normally display them all except in certain circumstances.

Try with a different value - eg; 1.23456 or 0.1234 - what does that get converted to when you display it?
If you have 1 & then you add 0.001 & then display it does it still show as 1.00 or 1.001?

Whenever value is displayed it is converted to a string, hence some precision may be lost & there is a default conversion - Double.ToString(); is the same as Double.ToString("G"); Where as Double.ToString("F4") provides a different string value.
The links Sergey provided explain this.

Kind Regards

Create a new Datatable, new SQLCommand & new CommandText & query the DB in the cellbeginediting event.
This is not an efficient method of solving your problem as everytime the cellbeginedit event occurs you will re-query the DB.

Cheers

What are you actually trying to do? You posted another question with the same data asking about schema's for an XML file.
If you require specific elements from the XML click the Improve Question link and advise the elements that you require.
A XML document can be traversed to get specific nodes, elements, attributes &/or values using XPath which is what I would assume you require.

Kind Regards

Build a test app as per the FAQ page & confirm it is working..
https://developers.google.com/recaptcha/docs/faq#what-happens-to-recaptcha-v1

Are you using the Secure Token method?
If so it is deprecated as of 18th May 2016 - refer: https://developers.google.com/recaptcha/docs/changelog

What sort of database is it?
You cannot save SQL Authentication Passwords in the report, you would need to use Integrated Security

Hi Vivek,
What is the problem with Crystal Reports?
If that is the technology you want to use then stick with it as it is suitable - not a perfect solution but reasonably easy to implement assuming you are storing the student details in a DB.
Improve your question - do not create another - with details of where you are having a problem & I, or someone, will point you in the right direction.
Kind Regards

IPL = Indian Premier League - it is a cricket series run in India.
I think the enquirer wants to know how to extract data from one website & display it on theirs based on the comment.

Kind Regards

Hi Anish,
A quick google search on the error message returned a lot of results, some pointing to removing and re-installing VSTO, others to re-compiling the Add-In - perhaps updating the Target framework at the same time.
Have you tried either of the above?

Kind Regards

You may want to improve your question shwetakeshri, there is no xml displayed here.
If you have invalid characters at the beginning of your XML why not strip the invalid characters? Convert the response to a string & then strip everything before the first "<" character

Kind Regards

Hi Muhammad,
Refer updated solution

PIEBALDconsult is correct.
This needs to be changed via the Windows Control Panel. It is the default for a selected item.
Open Control Panel got to Personalisation & select Window Color at the bottom of the screen.
In the "Item" field select the Item "Selected Item" and change color as required.
I am not sure if you can over-ride this

Kind Regards

If you want to use proper encryption then there is at least 360,000 results for the google search "c# code to encrypt and decrypt a string"
Pick one & start coding.
If you want to manipulate the string in some manner try;
https://msdn.microsoft.com/en-us/library/ms228362(v=vs.110).aspx

Kind Regards

Duplicate question - refer;
http://www.codeproject.com/Questions/1101926/Browser-navigation-not-connecting-through-a-proxy

That depends on where you want to write it to.
Sorry but we cannot read your mind & have only the information you have provided.
If the solution offered solves the issue then please mark as Solved, work out what you want to do & then raise another Question if you need help.

Kind Regards

Debug your script to determine where you are getting the error. You need to determine if it is on reading the data from your current server or while writing to the archive server before anyone can really provide advice

Kind Regards

Have you set AutoPostBack to true on the drop-down control?

Google is your friend Baroor, you can certainly find a heap of examples by searching. But please be aware that the UpdateProgress fires for UpdatePanels in the current page, therefore I would not expect it to show for UpdatePanels in the child pages

Kind Regards

Please always reply to a comment as the author receives a notification.
If FindControl does not return your control then the ID you are using is incorrect. If you load the page in a browser window & then view the source you can see what the actual control's ID is.
Alternatively use your debugger, in your RowUpdating event handler get the GridViewRow & look at what controls it contains using the "Locals" window.
This should allow you to identify the actual controls that are contained on your row

Kind Regards

Ensure you have a valid RowIndex
And try using a GridViewRow as follows;
Dim gvrEdit as GridViewRow = gridView1.Rows(e.RowIndex)
Dim txtBox as TextBox = DirectCast(gvrEdit.FindControl("txt_Name"), textBox)
Additionally, ensure that in your RowEditing event handler make sure you set the gridView1.EditIndex

Kind Regards

I would have added this as a solution but I am not sure if it was you want.
I think you need to export the report document to a stream (after setting the export format to PDF for instance) & then adding a job to the LocalPrintServer print queue.
For info on sending a stream to the printer queue refer to https://msdn.microsoft.com/en-us/library/ms552912(v=vs.110).aspx

Kind Regards

This might be a silly question but what are the values for input & moveSpeed?
If either (or both) is zero then you would not expect the character to move at all.

Please improve the question - add in your ASP source for the GridView.
When you bind data to a grid view you can either use Template columns or set AutoGenerateColumns to true which is likely where your problem is.

Kind Regards

As PIEBALDconsult has said already, are you on a domain? If so you need to ensure the User running the application has access to the database you are attempting to connect to.
If not, you will need to use SQL Authentication and pass a Username & Password as part of your connection string.
Refer to http://www.connectionstrings.com/sql-server/ for Connection String information

Kind Regards

Nice answer, I completely missed the "...just the structure" statement

Sorry femrock1 was unavailable till today.
You need references to CrystalDecisions.CrystalReports.Engine, CrystalDecisions.Shared & CrystalDecisions.Web - which you probably already have.
Additionally you need to add the relevant "using" statements if you do not want to fully qualify your paths.
I have the following using statements.
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using CrystalDecisions.Web;

I can see you have updated your code to fully qualify the Table object - this is most likely why you are getting an error - the Table reference is ambiguous if you have System.UI.WebControls listed in your using statements, hence the line
Table rptTbl = rptTables[i];
needs to be
CrystalDecisions.CrystalReports.Engine.Table tblRpt = tblsRpt[i];

If you can run the Report outside of Crystal - am assuming it is connecting to a SQL DB or similar - you don't all the code like
crystalReport.Database.Tables["FirstTermExams"].SetDataSource(dft);

When you set the TableLogOnInfo you are telling Crystal where to get the data & the username & password to use.

Kind Regards

You need to look at the data you are binding to the gridview. The error message is telling you that the column reci_seq does not exist.
Debug your code and confirm the column actually exists in your datatable.

Kind Regards

See next comment from priyadarshini - this is what you would normally do - delete the row from your data source & then rebind the gridview.
Is there a reason that you do not want to do this?

You can set an entire row to be hidden using dataGridView.Rows[rowIndex].Visible = false
but I don't think this is what you want.
Please improve your question advising what you are trying to do & where you are having a problem.

Kind Regards

Why not?
When you create Template Fields you typically create three separate ones for each GridView column, an ItemTemplate (for reading), an EditItemTemplate (for editing) and a FooterItemTemplate (for adding).
This is the recommended method.

Sorry Raja but you haven't provided enough information though I would suggest you are trying to find how many rows have a specific value in one column.
If so you need to look at DataTable.Select(filterstring)
Take a look at; https://msdn.microsoft.com/en-us/library/system.data.datatable.select(v=vs.110).aspx

If this is not what you need improve your question - do not add another, edit this one

Kind Regards

I would suggest you use your debugger.
You will likely find that the TextBox control is not being set via FindControl.
If you have a reference to a Textbox it cannot be NULL.

Kind Regards

I would suggest that the LastClosedTimeStamp is NULL, therefore it cannot be converted to a DateTime value.
Use your debugger & check what the value of the LastClosedTimeStamp property is, if it is null then don't try to convert it.

Kind Regards

Have you installed the Crystal Reports run-times on the machine you are running the application on?
Refer http://scn.sap.com/docs/DOC-7824

Kind Regards

So where is your error?
Run the program in a debugger and step through it to see what values you are getting & are they what the code expects.

Duplicate question; original question is: http://www.codeproject.com/Questions/1090862/How-to-insert-multiple-recordes-from-grid-to-SQL-d

What error are you getting?
Have you confirmed your connection string is valid - refer www.connectionstrings.com

Windows XP is no longer supported by Microsoft & I would normally tell the User they need to update their operating system.
Since that may not be an answer you can give you need to look at the version of .Net Framework the application was compiled in.
Open your project in Visual Studio, right-click the project & select Properties. On the Application tab you will find a Target Framework field.
The Target Framework can be changed - the application will need to be recompiled and some code changes may be required.
XP supports all Frameworks prior to 4.5

Kind Regards

If the error appears when you press the button then the problem is the button click event.
Simon_Whale is right, determine where your postback is failing - add a break-point in the Page_Load method & see what is being passed

Kind Regards

Start with the basics, break the problem down into individual tasks and then write code for each step.
An list of the tasks you need to complete is not a programming problem, it is logic - for instance;
a) Determine if the product requires basic sales tax
b) Calculate the basic sales tax
c) Determine if the product requires import duty
d) Calculate the import duty
e) Calculate line item totals
f) Create the receipt
g) Print!
NOTE: The above example is not exhaustive nor does it address the object orientated requirements.
Each Task can be further broken down depending on need.

Kind Regards

ConnectionStrings.com is the best resource for specific connection strings.
For instance; http://www.connectionstrings.com/olap-analysis-services/

Hi Katherik,
The stored procedure the OP has provided will create a new Sales Order record & a new Order Item record each time it is called, therefore if there is 5 order lines in the DataGrid you would end up with 5 SalesOrder records & 5 OrderItems records.
My solution to split the SP into one that creates a SalesOrder record & another for the OrderItems records will avoid duplicating the SalesOrder records.

Kind Regards

Your connection string is incorrect.
The Data Source should point to a machine name or Server URL (EG: http://servername)

This would create multiple Sales records - one for each Order line

Assuming that internal relaying is allowed by your Email server then;

Are you trying to send on behalf of a group email address?
If so the User account that is running the code will need Send As permissions.
If you are trying to send to a Distribution Group then the User account running the code should send to the Group Email address.
If the Distribution Group is an Outlook group (Contact Group versus Exchange Distribution Group) then the User running the code will need the group defined within their Outlook profile

What are you using to create your application installer?
The current Generally Available version of MySQL is available from http://dev.mysql.com/downloads/windows/installer/5.7.html as a MSI.
Your application installer should allow you to add this as a dependency

You will need to recompile your application after adding the new Property to your control, otherwise Visual Studio may not see it.
If the User Control is built outside of your current project you may need to remove and re-add your reference.
Kind Regards

Are you getting an error? If so please edit your question and add the error message in.
You have said that you are having an issue because the location is dependent on User input.
When you debug the code in printTest is the path to the file correct? Check the file exists.
Kind Regards

Refer link provided by RickZeeland but short answer is change SqlCeCommand to SqlCommand.
Each of the objects that you require (Connection, Command, Parameter and Adapter) are available & may require an update.
Couple of other items to suggest;
Don't use "SELECT * FROM" - this requires your database engine to lookup the schema to get the column names & indexes cannot be fully utilised.
Think about moving to Stored Procedures. If you do you can minimise the amount of Transact you need to write in your application.
I have a standard static class that I include in 99% of my projects that has an internal method to execute a stored procedure and return the result as a dataset. The class has private methods to create the DB connection and create and populate the Parameters. If I have a problem with a query or an insert or update I don't need to recompile the application to change it. It saves a heap of time in the long run & my code on a Form becomes DataSet dsForm = DataAccess.ExecuteSP(spName, paramArray)
Because I open and close the connection and do it within "using" statements I don't have a multitude of open connections left hanging around.
We have a vendor provided application that never reuses connections and keeps opening them - at times it can have 300 connections to the DB. Not a big problem if you have 300 users but unfortunately there is maybe 10 users logged in...
Kind Regards

As per PIEBALDconsults answer. While not a Microsoft link, the following site provides info on migration to SQL Server Express edition;
http://erikej.blogspot.com.au/2012/02/migrating-databases-between-sql-server.html

Not sure if it working. Try restarting

You cannot. Thread.Join blocks the calling thread until a thread terminates.
You need to identify the thread that is not ending and work out why & then kill it - probably with fire :-)
Cheers

Since you are going to stop it at midnight, how do you intend to start it again?
Without looking at the actual code I would guess it is running some type of loop that executes every x minutes or runs continually.
The underlying point is that a console application will end cleanly when the Main method ends.
Is there a reason that you could not simply check the current time at the beginning of each loop & exit if the time is after 11.55pm?
It might not be pretty, or best practice, but would meet your requirements.
If you are starting threads within the application go and stop each one, then exit.

Cheers

Open SQL Management Studio as a Sysadmin, right-click on the server & select Properties.
Select Permissions page in left panel.
Select the User in the right panel & view the effective permissions.
If you receive an error 0x5 it will be due to the account you are running SQL under not having domain permissions.
I would suggest that SQL may have had the View Any Database flag set to false for the user, to undo this execute the following;
GRANT VIEW ANY DATABASE TO [login_name];

What Server Role did you apply to the User?

Take a look at the SelectionMode property of the DataGridView - refer https://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.selectionmode(v=vs.110).aspx
If you want something other than one of the available options you will need to define what you want, how it will work and start coding

Kind Regards

There is the problem. Bracketing determines the order the parameters are evaluated in. You need to find a way of introducing levels within your User interface or make an assumption such as adding brackets after an AND if the next operator is OR.
An easy way would be to add open & close brackets as options on the Query Parameters screen. I would also recommend adding some feedback to the screen so the user can see what the query is going to return.

Good Luck & Keep Going!!

According to MSDN you should have task1.Wait() after task1.Start(). This will allow you to catch exceptions.
Refer: https://msdn.microsoft.com/en-us/library/system.threading.tasks.task(v=vs.110).aspx

If the only difference is substituting 'AND' for 'OR' then the query should work as expected.
What happens? Do you get an error message or inaccurate results?

Take a look at this MSDN URL regarding how to avoid SQL Injection as an aside - https://technet.microsoft.com/en-us/library/ms161953(v=sql.105).aspx

Can you show me what finalQuery looks like when User selects Or for the where clause, run the code in a debugger & copy and paste the value to either a comment or to the original question
Ta

You should be using parameters in your query to avoid SQL Injection attacks but..
Could you please update your question to show what the strCondition string looks like.
Kind Regards

Are you prompted for the parameter prior to the report displaying?
1. Ensure the SelectionMode property of your DataGridView is set to FullRowSelect or RowHeaderSelect - if not the SelectedRows property cannot be set
2. Confirm the parameter name is correct
3. Confirm the value you are passing is valid - you may need to convert the values datatype as Cells(0).Value returns an object
You can access the Report Parameters as a collection by using the following;
For Each paramDef As ParameterFieldDefinition in report.DataDefinition.ParameterFields
Confirm the name you are using is correct.

Kind Regards

You need to do more research. Perhaps try adding in different search terms such as "Math.Pow c# alternatives" or researching what Math.Pow does so that you can determine how you could write it as a method yourself

Kind Regards

What type of application is this? Windows Forms, ASP, MVC, WPF?
Do you receive the error on the line report.Load("path")? If not, what line is the error on?
If you do get the error on this line, the issue is the name & path to the report file.
What type of authentication are you using in the Report? Integrated or Username and Password?
If you do not add in the line report.SetParameter does the ReportViewer show the report?

Sorry Diether, I believe in the teach a person to fish philosophy.
A little research on your part will help you more than me writing the code.
I have updated my answer for you though to assist.

Kind Regards

What are you using to browse to the location?
If you are using Windows Explorer - check folder permissions
If you are using the Solution Explorer in Visual Studio - see RyanDev's comment
If you are using IIS Manager - you need to browse via Windows Explorer