Comments by Herman<T>.Instance

Herman<T>.Instance 8-Feb-24 9:11am View

Works like a charm

Herman<T>.Instance 2-Feb-24 10:11am View

you must have the last word. Isn't it!

Herman<T>.Instance 1-Feb-24 4:30am View

Sigh....This question was not about what VNext means, but why the data was not reloaded again.

Herman<T>.Instance 31-Jan-24 9:20am View

read this than: vnext in asp.net. It is about a way to load the data

Herman<T>.Instance 30-Jan-24 3:19am View

Look at this story from Scott Guthrie from 2014.

Herman<T>.Instance 29-Aug-23 7:42am View

must be a pebcak issue

Herman<T>.Instance 5-Jan-23 3:05am View

Did you try UNION ALL between both queries?

Herman<T>.Instance 24-Nov-22 5:51am View

What are your DB settings for logging and why is your db keeping connections/transactions open?

Herman<T>.Instance 14-Nov-22 10:34am View

I am not clicking url's that say it is an image

Herman<T>.Instance 14-Nov-22 10:33am View

I am not clicking url's that say it is an image

Herman<T>.Instance 22-Aug-22 5:56am View

case when......

Herman<T>.Instance 20-Feb-22 5:22am View

Order bY Contno, EntryDate ??

Herman<T>.Instance 20-Feb-22 5:21am View

I am waiting from answers from Microsoft. Might have found strange side effects on using SqlDependency in C# and Sql Server Server Broker. When confirmed CP will get a nice article

Herman<T>.Instance 16-Jan-22 15:00pm View

It will return in 4 weeks time

Herman<T>.Instance 13-Jan-22 10:47am View

;WITH hotels AS ()

Herman<T>.Instance 13-Jan-22 10:45am View

Hi _Asif_
After restart of the DB everything runs smooth again. In 4 weeks time this issue returns.
- Sp_WHo shows no blockedby's
- dm_tranlock might show a record
Cannot find this issue!

Herman<T>.Instance 13-Jan-22 10:39am View

CREATE NONCLUSTERED INDEX [idxTest-TestProgramPart] ON [TDMS].[tests]
(
[test_program_parts_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = ON, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO

Herman<T>.Instance 13-Jan-22 10:24am View

We saw a hanging item in the dm_tranlock, removed it and select worked again

Herman<T>.Instance 13-Jan-22 10:01am View

33900

Herman<T>.Instance 3-Jan-22 9:08am View

I just don't click unknown links

Herman<T>.Instance 10-Dec-21 10:28am View

Have you tried Array.Sort()?

Herman<T>.Instance 24-Nov-21 3:29am View

We have done a restart of the DB services and the issue was solved. Thanks for helping out

Herman<T>.Instance 23-Nov-21 11:43am View

Somehow the queryplan turns over into parallelism when doing an update

Herman<T>.Instance 23-Nov-21 11:42am View

the id field is in the PK index, the bitfield in a separate index.

Herman<T>.Instance 23-Nov-21 10:45am View

But drop of that index does not solve the issue

Herman<T>.Instance 23-Nov-21 10:41am View

yes, there is 1 index on it

Herman<T>.Instance 4-Nov-21 5:19am View

I used the word LIKE It has the style of...

Herman<T>.Instance 4-Nov-21 5:19am View

Look at the clickbait title

Herman<T>.Instance 4-Nov-21 4:12am View

This is setup like a Facebook advertisement to make you click.

Herman<T>.Instance 4-Nov-21 4:11am View

Why you bring Facebook advertisements to here?

Herman<T>.Instance 2-Nov-21 8:40am View

Exaclty: A DataAdapter first fetches all data before it exposes to the client. SqlDataReader streams your data so it can be exposed faster to the client. It exposes as long as the stream is running, making your application more fluid.

Herman<T>.Instance 19-Oct-21 8:16am View

https://www.w3schools.com/sql/

Herman<T>.Instance 13-Sep-21 9:59am View

Better store the Ticks (long/Int64)

Herman<T>.Instance 8-Dec-20 16:54pm View

LEFT OUTER JOIN?

Herman<T>.Instance 20-Oct-20 5:04am View

Please use codeblocks when dumping your coding environment here.

Herman<T>.Instance 20-Oct-20 4:15am View

:0 in stead of :id ?

Herman<T>.Instance 6-Aug-20 8:43am View

To create a new user you first create a Login and then the User.

Herman<T>.Instance 6-Jul-20 13:53pm View

No errortracking, you're asking for it

Herman<T>.Instance 16-Jun-20 10:43am View

Hi CHill60,
I have just tested it and it gives me exactly 0 lines as result if the words are in correct order or in a different order. Thanks for your help, despite the result. I try to find other ways

Herman<T>.Instance 12-Jun-20 10:35am View

I can have n splitresults but they all must occur within the pv.SearchLine

Herman<T>.Instance 11-Jun-20 10:10am View

Hi CHill60,
I have accepted your solution, cause this works in a nice way.Except.... If I have n keywords and all keywords must exist not any but all. It is doing OR now in stead of AND.

My code:
DECLARE @searchtext NVARCHAR(1000)= 'vessel ship container';

;WITH containsfields as (SELECT [Value] from dbo.SplitString(@searchtext, ' '))
SELECT DISTINCT pv.[Id],
[ProjectNo],
[MainProjectNo],
[ProjectDescription],
[CustomerNo],
[CustomerName],
[Status],
CASE
WHEN [ProjectTypeCode] = 'NULL'
THEN NULL
ELSE [ProjectTypeCode]
END AS [ProjectTypeCode],
[ManagerName],
CASE
WHEN [EngineerName] = 'NULL'
THEN NULL
ELSE [EngineerName]
END AS [EngineerName],
FROM [dbo].[IProjectView] AS pv
INNER JOIN containsfields as cf
on CHARINDEX(cf.Value, pv.SearchLine) > 0
ORDER BY ProjectNo;

SearchLine is the concatenation of fields in the view.
How to change the query to have all keywords found in 1 line?

Herman<T>.Instance 11-Jun-20 8:52am View

dynamically, you mean by CTE?

Herman<T>.Instance 19-Mar-20 5:58am View

I Guess the LIKE forces a table scan. What does the query execution plan tell you?

Herman<T>.Instance 13-Mar-20 12:25pm View

You are missing setting up Routing in WebApI

Herman<T>.Instance 13-Mar-20 11:56am View

The point is, that the client creates the URI for me.

For V3 it was done right for V4 the servies needs some routing settings. That is where I am looking for.

Herman<T>.Instance 13-Mar-20 10:33am View

no the uri should be:
var uri = new Uri($"http://someapi.com/Models?modelNumber='{modelNumber}'");

Herman<T>.Instance 13-Mar-20 10:27am View

Added!

Herman<T>.Instance 13-Mar-20 10:07am View

code is calling

Herman<T>.Instance 13-Mar-20 9:54am View

How?

OData V3 dis it correctly and V4 has new ways with Routing. I can't figure it out.

Herman<T>.Instance 13-Mar-20 5:35am View

Have you seen my other question about this issue?
https://www.codeproject.com/Questions/5259132/Odata-v3-v4-issue-on-userdefined-controllers

Herman<T>.Instance 12-Mar-20 12:33pm View

Are you OK with routes?

I have function and Odata client creates
http://wrk2198:80/marinservices/ProjectUsedModels(modelNumber='10000')
Where my service says

[EnableQuery]
[ODataRoute("ProjectUsedModels?modelNumber={modelNumber}")]
public IEnumerable<projectusedmodels_result> Get([FromODataUri]string modelNumber = "")

Why the route in the service is not used by the client?

Herman<T>.Instance 12-Mar-20 12:12pm View

Library = Microsoft.aspnet.Odata.

Upgrading to V4 and adding the nested $filter in $expand did not help.

Any other options?

Herman<T>.Instance 12-Mar-20 11:39am View

I use a V3 protocol. I just started upgrading to v4 and retry the issue. Have the
config.Filter().Expand().Select().OrderBy().MaxTop(null).Count();
added

Herman<T>.Instance 12-Mar-20 11:18am View

I use OData connected services

Herman<T>.Instance 12-Mar-20 10:05am View

I have it working since begin march. What a GREAT solution. All kudos for you.

Herman<T>.Instance 28-Feb-20 5:36am View

Deleted

IENumerable needs <t> IQueryable not.

Herman<T>.Instance 27-Feb-20 14:37pm View

The type 'MARIN.DS.MarinEntities.Entities.MenuEntity' cannot be used as type parameter 'T' in the generic type or method 'ComboBoxFiller<t>'. There is no implicit reference conversion from 'MARIN.DS.MarinEntities.Entities.MenuEntity' to 'MARIN.DS.MarinEntities.Entities.IDataCollectionProvider<marin.ds.marinentities.entities.menuentity>'.

The Interface had to be:
public interface IDataCollectionProvider<t>
{
IQueryable<t> DataFromService { get; set; }
List<t> DataFromServiceList { get; }
string DropDownListDataTextField { get; }
Exception LastException { get; set; }
}

because T type holds the IQueryable data for the given Entity Framework poco

How to overcome this?

Herman<T>.Instance 5-Feb-20 3:25am View

I guess asking a question here

Herman<T>.Instance 5-Feb-20 3:23am View

One tip that does not solve your problem:
Since you use SqlParameter[] SQLPmtr
You can state:
if (SqlPmtr != null && SQLPmtr.Length > 0) cmd.Parameters.AddRange(SQLPmtr);

Herman<T>.Instance 4-Feb-20 3:35am View

This is a question in the range:
My fridge is empty and needs a refill. Please fill it up.

Herman<T>.Instance 3-Feb-20 6:26am View

I did that, but the issue is solved. Thanks

Herman<T>.Instance 3-Feb-20 5:14am View

I did read that solution to and found
https://stackoverflow.com/questions/3309188/how-to-sort-a-listt-by-a-property-in-the-object as simple answer. The option Griff gave has minimal code.
Thanks for your help!

Herman<T>.Instance 3-Feb-20 5:13am View

Thanks Mate!

I told you it is monday morning.....

Herman<T>.Instance 3-Feb-20 4:15am View

{System.Linq.OrderedEnumerable<marinmodelservice.models.modelstatu, system.type="">}

dataservice.OrderBy(x => x.GetType().GetProperty(DropDownListDataTextField)) leads to an unordered IeNumerable<t>

Herman<T>.Instance 3-Feb-20 3:59am View

<t> is the webAPI object ModelStatu (is table via EF in webAPI Controller).
DropDownListDataTextField holds the name to display in a dropdownlist and has the value "Status"

Herman<T>.Instance 3-Feb-20 3:48am View

NULL
but the column does exist.
I added .GetValue(dataservice) and then I get the error:
'this' parameter not instance of type

the var Data has the error: Object does not match target type.

Herman<T>.Instance 3-Feb-20 3:28am View

Griff, I know it is monday morning.

I did debug and I know it is the IF and not the ELSE part it is running.....

Herman<T>.Instance 23-Jan-20 5:05am View

Which type of database?

Herman<T>.Instance 10-Dec-19 7:14am View

Why you use an INSERT and a MERGE in 1 Stored Procedure. On using the MERGE you can determine if to INSERT, UPDATE or DELETE.

Herman<T>.Instance 9-Dec-19 5:17am View

Show code to see what you did

Herman<T>.Instance 9-Dec-19 5:17am View

Why not?

Herman<T>.Instance 3-Dec-19 9:15am View

Why you are using a temporary table for this? I do not understand your choice.

Herman<T>.Instance 3-Dec-19 9:13am View

I don't click dubious links/images. Don't know what I am gonna get!

Herman<T>.Instance 3-Dec-19 9:12am View

Wellllll where do you check if the row is selected? row.SelectedIndex is never used

Herman<T>.Instance 3-Dec-19 3:07am View

And what is the exact exception?
Maybe debug: your IIS

Herman<T>.Instance 29-Nov-19 8:41am View

Any Exceptions?

Herman<T>.Instance 21-Nov-19 9:27am View

Like this?

Herman<T>.Instance 21-Nov-19 3:33am View

set width and height in css class to a percentage. Than it will autoscale by resizing

Herman<T>.Instance 20-Nov-19 8:08am View

Yeah but the first new row is not added to the viewstate, so you add the second row to the original viewstate. If you put a breakpoint @ DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"]; you will see....

Herman<T>.Instance 20-Nov-19 7:57am View

I guess the problem is the viewstate. It is set once and resued. I do not see any code where the ViewState is updated after adding a row.

Herman<T>.Instance 20-Nov-19 7:52am View

Does he want mayonaise with it?

Herman<T>.Instance 20-Nov-19 4:23am View

See: Google searchresult here

Herman<T>.Instance 19-Nov-19 6:36am View

I don't see 'temperature' in your HTML

Herman<T>.Instance 7-Nov-19 4:22am View

We don't do HOMEWORK

Herman<T>.Instance 6-Nov-19 5:35am View

OK.
your part script type .... function ....

That part should be just above < /body>. You are then sure all HTML is loaded properly so the script can find all controls

Herman<T>.Instance 6-Nov-19 3:50am View

Why not use a POST?

Herman<T>.Instance 6-Nov-19 3:37am View

What is Exception message?

Herman<T>.Instance 6-Nov-19 3:35am View

What is the error/exception/message that hints the problem?

Herman<T>.Instance 23-Oct-19 6:32am View

What is the question?

Herman<T>.Instance 17-Oct-19 15:55pm View

missing the OUT in :

return new[]
{
new Person(out "Dan", out 36.294),
new Person(out "Dave", out 72.492)
};

??

Herman<T>.Instance 23-Sep-19 10:02am View

Run the installer again. It might be missing something or the service account has insufficient rights on the folder.

Herman<T>.Instance 23-Sep-19 5:40am View

'I only have one "SQL Expression" field where I can paste the code into' .....

Herman<T>.Instance 23-Sep-19 3:28am View

It is setting begin of string to 'distinct '

Herman<T>.Instance 23-Sep-19 3:09am View

SQL Injection. Always a NO GO!
What is your exact problem? Can't look in your mind

Herman<T>.Instance 23-Aug-19 8:06am View

Are the servers linked?

Herman<T>.Instance 8-Jul-19 6:59am View

Is there any exception cq fault message? What have you debugged?

Herman<T>.Instance 26-Jun-19 4:10am View

SELECT Name, ProductName
FROM
(
SELECT ROW_Number OVER(Partion By c.Name ORDER BY C.Name, p.ProductID DESC) as Rowno,
c.Name, p.productName
FROM Customer c
JOIN Purchases p on p.UserID = c.UserId

) as x
WHERE x.Rowno = 1

Herman<T>.Instance 26-Jun-19 4:05am View

Why you think row_number only works with timestamp column? order by Id DESC is valid for Row_Number

Herman<T>.Instance 25-Jun-19 8:34am View

ahummmm....ROW_NUMBER?

Herman<T>.Instance 24-Jun-19 19:03pm View

have you ever read my article about dynamic pivotting?

Herman<T>.Instance 24-Jun-19 7:51am View

Both add to the learning curve

Herman<T>.Instance 24-Jun-19 6:54am View

Is there LAG/LEAD functionality in ACCESS?

Herman<T>.Instance 24-Jun-19 6:52am View

Ojjj Griff! Use ROW_NUMBER function for such queries. It is designed for such db questions.

SELECT ProductCode, BidPrice, BidDate
FROM
(
SELECT ROW_NUMBER() OVER(PARTITION BY ProductCode, BidDate ORDER BY ProductCode, BidDate DESC) as Rowno, ProductCode, BidPrice, BidDate
FROM Purchases
) as x
WHERE Rowno = 1

Herman<T>.Instance 11-Jun-19 3:20am View

If you debug your code you would know where the index was outside the bounds. In your shown code some array with no or less then 5 items will lead to this message.

TIPS:
1: debug
2: read exception stack trace to see where the exception occurred in your code.

Herman<T>.Instance 21-May-19 8:08am View

Yep, this is the solution! Post it as a solution!

Herman<T>.Instance 17-May-19 3:40am View

Has the IIS User rights to write to the folder where you expect the uploaded file?

Herman<T>.Instance 9-Apr-19 8:48am View

HINT: SELECT format(@datetime,'yyyyMMddHHmmss')

Herman<T>.Instance 9-Apr-19 8:15am View

Maybe some background process is blocking this. I do not see anything blocking with sp_who (2). We do get some deadlocks.

Herman<T>.Instance 9-Apr-19 7:08am View

disabling en reenabling the notificationservice didnit do anything. Restart the SQl Server perhaps

Herman<T>.Instance 9-Apr-19 7:07am View

The strange situation is that the sp was no problem until last week!
If i backup that database and restore it to my own sql server the problem is gone too. DBCC Checkdb doesn't show up any problems.

Herman<T>.Instance 9-Apr-19 3:47am View

I'm using SQL Server 2014......

Herman<T>.Instance 8-Apr-19 7:14am View

Yes I do use notification subscription. They are not used in any stored procedure, but the query plan of test_insert says it is being used where the nr of estimated rows increases from 1 to 17 million and more. (That seems 4 seconds work)

Herman<T>.Instance 3-Apr-19 6:47am View

What is the problem?

Herman<T>.Instance 7-Mar-19 6:09am View

LINQ -> .Expand()
dataService.GetCars().Expand(.....);

Herman<T>.Instance 27-Feb-19 7:08am View

There are so many realy basic sql questions the last few days. This fella could have found over 1 million ways on the internet that could help him (not having server= and database= in his connectionstring). If you look at the last few days. How many of these low level question where asked by newbies / trolls?

Herman<T>.Instance 27-Feb-19 7:04am View

have you looked at www.connectionstrings.com ?

Herman<T>.Instance 26-Feb-19 6:07am View

did you try 2011/1/10 ?

Herman<T>.Instance 7-Feb-19 4:30am View

by typing it!

Herman<T>.Instance 6-Feb-19 10:51am View

thank you!

Herman<T>.Instance 4-Feb-19 3:53am View

+5ed

Herman<T>.Instance 20-Dec-18 4:45am View

... (in the past at least)... Guessing i'm working way too long....

Herman<T>.Instance 20-Dec-18 4:44am View

ORDER BY DESCENDING. That is a guarantee! If the field is Indexed is not guaranteed

Herman<T>.Instance 19-Dec-18 11:57am View

Only the last record will be taken from the db since the query asks for DESCENDING order. Despite the size of the collection. You find the MAX value in a blink of an eye. MAX (in the past at least) was a guaranteed table scan. The larger the collection, the longer it took.

Herman<T>.Instance 19-Dec-18 11:27am View

Performance wise the BEST option!

Herman<T>.Instance 19-Dec-18 4:49am View

There are many solutions to be found i the Article sections of CP:

Like mine: https://www.codeproject.com/Articles/201320/Dynamic-Pivoting-with-Cubes-and-eventhandlers-in-S

Herman<T>.Instance 12-Dec-18 17:23pm View

maybe my article will help you.

Herman<T>.Instance 20-Nov-18 3:42am View

Is this homework?

Herman<T>.Instance 16-Nov-18 5:15am View

new balls please?

Herman<T>.Instance 16-Nov-18 5:15am View

Is type smallint, int or bigint in SQL ?

Herman<T>.Instance 9-Nov-18 7:07am View

Is it running in a webfarm?

Herman<T>.Instance 9-Nov-18 7:05am View

What he seems to want is when you click row 0 that row -1 gets set in EditMode.

Herman<T>.Instance 7-Nov-18 6:30am View

Is this homework?

Herman<T>.Instance 1-Nov-18 5:18am View

Is this homework?

Herman<T>.Instance 31-Oct-18 4:34am View

if you would use an unzip program on the file you could see the inner xml content. That might give the clue to your error.

Herman<T>.Instance 30-Oct-18 11:33am View

Have you checked the contents of the xlsx file using 7-zip?
Maybe there are no rows of data in the file.

Herman<T>.Instance 24-Oct-18 2:52am View

What was it?

Herman<T>.Instance 23-Oct-18 9:08am View

And you are not getting mails when starting up the webapplication?

Herman<T>.Instance 23-Oct-18 6:09am View

With truly NO information, no one can tell.

How fast is the call in SSMS? How many read/writes (Profiler) does your update cost?
Are the updates put in a TRANSACTION?

Herman<T>.Instance 23-Oct-18 6:06am View

You call the function by value in stead of by reference. That is your problem. amd Google says:
this!! about your problem

Herman<T>.Instance 23-Oct-18 5:17am View

has your webapplication a global.asax file that handles unhandled exceptions?

Herman<T>.Instance 23-Oct-18 4:28am View

Can Fiddler give you more details about:
'You are not authorized to view this page due to invalid authentication headers.'

Herman<T>.Instance 23-Oct-18 4:27am View

Forms Authentication is Enabled under authentication? Is that what you are telling me?

Herman<T>.Instance 23-Oct-18 4:25am View

What authorisations have been setup in IIS for the webapplication?

Herman<T>.Instance 23-Oct-18 4:19am View

In the questioners style->
CSS
CSS

Herman<T>.Instance 23-Oct-18 4:18am View

What error do you get?

Herman<T>.Instance 23-Oct-18 4:17am View

And the question is?

Herman<T>.Instance 9-Oct-18 6:24am View

How does your XAML look like?

Herman<T>.Instance 5-Oct-18 10:58am View

Why you need the loop? =>
while @errorstat = 0

Why You need to call with that parameter?

If you have no problems in this code you endlessly run this SP!
You keep ALTER TABLE you Column?

Your code makes no sense to me

Herman<T>.Instance 5-Oct-18 10:51am View

What do you expect from us with NO information?

Herman<T>.Instance 5-Oct-18 10:46am View

You only googled for a solution? I would debug code in VS and SP in SSMS

Herman<T>.Instance 4-Oct-18 3:55am View

Before rebinding you can iterate the GridViewRows of the GridView and check for each checkbox by using the GridViewRow.FindControl() methods.

Herman<T>.Instance 4-Oct-18 3:46am View

Your table has less than 35 rows. That is what is is telling you.

Herman<T>.Instance 28-Sep-18 6:28am View

perimeter is a double type variable and not a method

Herman<T>.Instance 25-Sep-18 4:33am View

Unable to understand problem....

Herman<T>.Instance 25-Sep-18 3:29am View

First: What is the question?
Second:what is the real problem? We cannot read your mind.

Herman<T>.Instance 21-Sep-18 10:56am View

DB user issue?

Herman<T>.Instance 19-Sep-18 6:37am View

Seems he is trying to connect to a database before it is being created?

Herman<T>.Instance 18-Sep-18 8:51am View

2 virtual machines on your hardware?

Herman<T>.Instance 18-Sep-18 8:51am View

You can use TRY CATCH in SQL Server. In the BEGIN CATCH you can find out where the SP went wrong.

Herman<T>.Instance 18-Sep-18 3:37am View

If you are LOOKING for code, then better use Google. We provide solutions to problems, not code!

Herman<T>.Instance 18-Sep-18 3:36am View

And the question is ?

Herman<T>.Instance 14-Sep-18 4:54am View

Is this homework?

Herman<T>.Instance 4-Sep-18 8:41am View

What database server are you using?

INSERT INTO Table1 (col1, col2) VALUES (x,y)

More help needed? https://www.google.nl/search?q=msdn+insert+into&oq=msdn+insert&aqs=chrome.1.69i57j0l5.3295j1j7&sourceid=chrome&ie=UTF-8

Herman<T>.Instance 4-Sep-18 3:26am View

datacolum for datetime oftype(string). I wonder why you cannot get it working...

Herman<T>.Instance 4-Sep-18 3:18am View

is Google banned in your country?

https://www.carlosag.net/tools/codetranslator/

Herman<T>.Instance 31-Aug-18 7:30am View

Sue the system owner for neglect!

Herman<T>.Instance 31-Aug-18 7:28am View

more than 1 row and no iteration over your row collection. That's your next Google search

Herman<T>.Instance 31-Aug-18 7:27am View

Since you changed your question it is now clear what your problem is. You are trying to set a unique ID in a table in the database. Set the ID field als Identity field. Than the DB will pass unique ID's and your ASP.NET does not have to do obscure things.

Herman<T>.Instance 31-Aug-18 6:47am View

What do you mean by deleting? You are calling a function!

you can find that rowcount value in system tables:
select t.name, p.rows from sys.tables as t
JOIN sys.partitions AS p
ON t.[object_id] = p.[object_id]
WHERE t.name = '<your table name here>'

Herman<T>.Instance 30-Aug-18 6:24am View

I asked does not should.....

Herman<T>.Instance 29-Aug-18 5:18am View

Both Except and Intersect are powerful and valuable LINQ methods.

Herman<T>.Instance 29-Aug-18 4:21am View

and what does "param-name" give as result?

Herman<T>.Instance 27-Aug-18 3:41am View

Herman<T>.Instance 24-Aug-18 7:26am View

It is dangerous just to click any URL.....

Herman<T>.Instance 24-Aug-18 3:16am View

this is another problem than you have in this thread.
What is the value of quizId? Have you debugged?
You should better investigate what your problem is in stead of asking everything.
Did you Google?

Herman<T>.Instance 24-Aug-18 2:58am View

what error?

Herman<T>.Instance 23-Aug-18 9:53am View

read this.
It is about the definiton for PRIMARY KEY.

2.0 The INTEGER PRIMARY KEY
One exception to the typelessness of SQLite is a column whose type is INTEGER PRIMARY KEY. (And you must use "INTEGER" not "INT". A column of type INT PRIMARY KEY is typeless just like any other.) INTEGER PRIMARY KEY columns must contain a 32-bit signed integer. Any attempt to insert non-integer data will result in an error.

INTEGER PRIMARY KEY columns can be used to implement the equivalent of AUTOINCREMENT. If you try to insert a NULL into an INTEGER PRIMARY KEY column, the column will actually be filled with an integer that is one greater than the largest key already in the table. Or if the largest key is 2147483647, then the column will be filled with a random integer. Either way, the INTEGER PRIMARY KEY column will be assigned a unique integer. You can retrieve this integer using the sqlite_last_insert_rowid() API function or using the last_insert_rowid() SQL function in a subsequent SELECT statement.

Herman<T>.Instance 23-Aug-18 7:57am View

#page_right
{
/* add */
float: right;
}

Herman<T>.Instance 23-Aug-18 7:53am View

the table is in your SqlLite3 db. There you have to make the field PK and AutoIncrement/Identity not in your source code

Herman<T>.Instance 23-Aug-18 6:33am View

Are the correct userrights set for IIS and the folders?

Herman<T>.Instance 23-Aug-18 6:32am View

We do not provide 'the code', only solutions to a problem.

Herman<T>.Instance 23-Aug-18 5:45am View

the definition will be in the create table script where you state:
field [datatype] [not] null ..
Which datatypes are fields 1 and 2 and is field 3 nullable?

Herman<T>.Instance 23-Aug-18 4:52am View

and what is the field definition of field 3? Can the field hold NULL values?
What are the field definitions for field 1 and 2. Does that match?

Herman<T>.Instance 23-Aug-18 3:04am View

If a table has 2 fields ('and i want to store the result on third table=music_result(username,meaning)') what is the purpose of the NULL field (3rd field) in your query?

Herman<T>.Instance 22-Aug-18 11:13am View

exactly

Herman<T>.Instance 22-Aug-18 7:27am View

T-SQL WHERE Clause has AND option!

Herman<T>.Instance 22-Aug-18 7:26am View

c#? or is this AJAX ControlToolkit?

Herman<T>.Instance 22-Aug-18 7:23am View

that might be ver important to improve the query.

Why you use DISTINCT. it is an acronym for That Stinks. How do you know which record you get returned? Are you aware of the ROW_NUMBER() function in Sql Server?
By setting the correct partition and order by you can always ask for the one row desired.

In your query: CONVERT(VARCHAR(MAX),CMCD.UpdatedDateTime,113) AS [UDVal]
VARCHAR(MAX) for approx 30 chars? that is costly!

Herman<T>.Instance 21-Aug-18 9:54am View

C#-> FtpRequest (search on MSDN)

Herman<T>.Instance 20-Aug-18 10:35am View

SET Avail_seats = CASE WHEN Avail_Seats > 0 THEN Avail_Seats-1 else 0 END
WHERE Course_Name = $Course_Name

Herman<T>.Instance 20-Aug-18 8:35am View

The pint is that despite the use of a dataannotaion in EF the field was updated by query generated by EF6. I have set the column to Computed. No EF6 doesn't toch my column anymore.

Herman<T>.Instance 17-Aug-18 5:17am View

Do you have any exceptions logged? Timeout for example?

Herman<T>.Instance 16-Aug-18 3:46am View

Have you tried a TemplateField with a HeaderTemplate with a Label in it in stead of the BoundField? In code behind you could 'FindControl' the Label and set the sup in the text.

Herman<T>.Instance 15-Aug-18 9:29am View

indeed a mix up of variables to use and good logic

Herman<T>.Instance 15-Aug-18 8:47am View

WHILE @Counter = @Numgen ...... WHILE @Counter < @Numgen ??

SET @Counter = 1000 ???

What are you trying?

Herman<T>.Instance 15-Aug-18 6:35am View

why didn't you debug?

Herman<T>.Instance 4-Jul-18 3:37am View

svc is not a windows service but a service in IIS. Maybe that is why you cannot connect?

Herman<T>.Instance 26-Jun-18 10:30am View

The problem was that I used ConcurrentBag in my WCF. Changing to a List<> object solved the problem. DataGridView cannot show data from ConcurrentBAG<> objects I suppose.

Herman<T>.Instance 26-Jun-18 9:08am View

PIVOT()

Herman<T>.Instance 22-Jun-18 5:23am View

see the quotes in my example:
DECLARE @TableName NVARCHAR(200)
SET @TableName = 'dbo.New_Table_'+ [@Group]

Comments by Herman<T>.Instance (Top 200 by date)