Comments by dbrenth (Top 28 by date)

If this is an exact copy paste then you need to fix your parameter names:

String query = "UPDATE TData SET agent_shortname =@agentanalysiscode WHERE company_code=@companycode";
SqlCommand cmd3 = new SqlCommand(query, conn1);
cmd3.Parameters.AddWithValue("@company_code", Convert.ToString(mapping.companycode));

In the first line it is @companycode and in the last line it is @company_code
In both places in your code. These need to match.

For the best shot at getting answers, please provide your table structure and some sample data. It is impossible to know given this information how to help.

You did not include your error messages.

What do you get when you run the SQL in the native SQL Server Management studio? It is possible you may need to qualify your table name. Make sure you log into Studio using the same user as in your connection string.

Thanks, I was simply hoping that wasn't the answer. But I understand why.

This kind of thing might be possible if the method in class A were public instead of protected. I can't change class A. Since it is protected, I can't access it except through class B.

Given this data you can do this:

select c.clientid, company, c.product, total, rcvamt, restamt
from DBHTestCustomer c left outer join
DBHTestPayment p on c.clientid = p.clientid

or, if you want to calculated it in the SQL, this:

select c.clientid, company, c.product, total, sum(rcvamt), min(restamt)
from Customer c left outer join
PaymentData p on c.clientid = p.clientid
group by c.clientid, company, c.product, total

Either one turns the above given data into your report.

So, what is RegistrationInfoSettingXref? Is there an insert trigger that writes to PluginSettingXrefValue?

Why does it have to be in LINQ? You could:
1. Create a view on the SQL Server and load the view.
2. Call the SQL directly from your program and load a data table.
3. Use LINQ to do the where clause, then post process to get the distinct items with 3 instances.

Because without it, you get that one and the '05 mar 2014' lines - which you don't want.

What is the reason for the "constraint"? Is this a homework assignment?

SQL Server Management Studio is very good at determining what indexes are missing and even gives you the script for creating the potential missing indexes (at least in version 2012). Enter your long running sql query and run Query -> Display Estimated Execution Plan.

You can pepper your procedure with select statements so it will give you feedback while it runs. This would be most helpful. We can't see what is in the Student table so it is hard to say.

I must be misunderstanding something. To know which specific row has been changed, just look at the WHERE clause in your SQL statement.

Have you tried catching the Adpater's RowUpdated event and seeing what messages appear there?

I wouldn't try to do it on a table level. You can probably mess with triggers, but triggers can be fragile. They have to be in every table that touches your data in insert update and delete functions. And if you have a bug in your calculation, good luck - it could be in any one or more of the triggers.

Using a view allows you to maintain the calculated information in one place as if it was a table. And the calculations are in one place.

I don't understand your comment about views. The purpose of a view is to display data with computed or renamed columns. They do allow multiple tables and functions, but you can't update or insert through a view with multiple tables and functions. You have to insert or update the base tables, and then the view with its calculated columns will update automatically.

The other option is redesign. You can't afford not to use parameters. You owe it to your client to deliver a product that's safe.

I recommend building your query into stored procedures. Stored procs can take comma delimited strings as an argument. And you can pass the argument in as a parameter. Or you can generate the sqlcommand dynamically as ... ItemCode = ? or ItemCode = ? or ItemCode = ? ...

If you stick with what you have, the special characters will be the least of your problems.

GetDate() is a function that doesn't run on any table. It is a function that just places the current date into the list of insert values.

I usually skip the DataSet and go straight to the DataTable.

DataTable dt = new DataTable();
sqlDataAdapter.Fill(dt);

Now you just index through the rows and columns in the DataTable.

I am just warning you of potential sql injection attacks. You may want to look at using SqlParameter's instead of just blindly throwing in whatever a user types in at the text box.

Anyway, do you get a better result when you try command.ExecuteNonQuery();?

Please define "it doesn't work well for me." That could mean anything, Including that the table keeps disappearing everytime you enter "' DROP TABLE MS4 --" in the textbox.

In that case I withdraw my solution. I think you will have to parse the Body string and save it out to a file with a good old fashioned Stream function.