Click here to Skip to main content
14,697,477 members

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

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
   
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
   
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
   
<httpRuntime maxRequestLength="150000"/>

in <system.web>
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]
Herman<T>.Instance 22-Jun-18 5:21am View
   
See here.
Herman<T>.Instance 21-Jun-18 6:42am View
   
why check on $.fn.DataTable.isDataTable($tbl_zgs)?
tblZgs = null; you stated!
Herman<T>.Instance 21-Jun-18 2:24am View
   
Does it work now?
Herman<T>.Instance 20-Jun-18 7:04am View
   
What should this part do?
select Column_1, Column_2
into New_Table_@Group
from Existing_Table where Column_3 = @Group;

trying to put data in a table without any columns?
Herman<T>.Instance 20-Jun-18 7:03am View
   
put [] around @Group It is a Variable
Better:
DECLARE @TableName NVARCHAR(200)
SET @TableName = 'dbo.New_Table_'+ [@Group]

IF OBJECT_ID([@TableName], 'U') IS NOT NULL
DROP TABLE [@TableName]
Herman<T>.Instance 20-Jun-18 7:01am View
   
Has the exception innerexceptions?
Is the path relative or absolute and is it correct?
Herman<T>.Instance 20-Jun-18 6:58am View
   
elevated rights?
Herman<T>.Instance 5-Jun-18 9:02am View
   
How is your GridView control in the ASPX file set up.
Are you using DataKeynames for your customerId?
Try catch for any error?
What is the ID of the TextBox that holds the customerID?
What is the ID of the TextBox that holds the CustomerName?
Have you set the EditIndex and the SelectedIndex when setting the GridView in the RowEditing event?

Questions end with an ? So maybe modify your question
Herman<T>.Instance 23-May-18 3:36am View
   
And why it does not work?
Herman<T>.Instance 16-May-18 12:05pm View
   
No one knows how to prevent the submenu is only partial visible?
Herman<T>.Instance 15-May-18 7:17am View
   
That is when you set GridView.EditIndex to the rownumber where the TextBox should appear
Herman<T>.Instance 9-May-18 4:41am View
   
What is the value in _UserName? If that is NULL the parameter is not send to the database. To overcome this problem set the NULL value to DBNull.Value. The parameter is send to the database in that case.
Herman<T>.Instance 9-Apr-18 3:32am View
   
In stead of ALTER check if the object exists in the DB. IF not, then CREATE!
Herman<T>.Instance 9-Apr-18 3:31am View
   
Any exceptions?
This is too less information to help you
Herman<T>.Instance 4-Apr-18 7:31am View
   
WHERE ParentId=@ChildId..that sounds strange. You never get the parent, but a child and the child of that.

A CTE would be much better
Herman<T>.Instance 29-Mar-18 9:50am View
   
That's it! Thank you
Herman<T>.Instance 28-Mar-18 18:59pm View
   
I found the problem.
Asp.Net sets the css class on the panel (=div) and not on the fieldset.

<div class="marinBottomBar">
<div id="pnlSearch" class="searchBar">
<fieldset>
<legend>
Search
</legend>
<div>
<input name="ctl00$txtSearch" type="search" id="txtSearch" />
<input type="submit" name="ctl00$BtnSearch" value="Zoek" id="BtnSearch" class="searchButton" />
</div>

</fieldset>
</div>


How can I fix that
Herman<T>.Instance 23-Mar-18 10:01am View
   
We tried that. But when running the statement SqlDependency.Start(configstring) you get 3 exceptions. The above rights where granted. Only adding role db_owner fixed this issue.
Herman<T>.Instance 23-Mar-18 10:00am View
   
No thank you
Herman<T>.Instance 19-Mar-18 17:21pm View
   
I do not see ItemsSource={Binding ...} in your XAML,neither a SelectedItem={Binding ....}
Herman<T>.Instance 17-Mar-18 5:10am View
   
I have seen the demo and it works. IS asp.net interfering in the translation to HTML?
Herman<T>.Instance 16-Mar-18 4:24am View
   
Hi Richard,

thanks for you solution, but it does not work. I don't know where it is coming from, but the texbox width = 173px. I do not set that value anywhere. Any idea's?

Using latest Chrome and IE 11
Herman<T>.Instance 14-Mar-18 10:43am View
   
the data value = 10?
Herman<T>.Instance 6-Mar-18 7:42am View
   
Because of Post_Back you have to reload complete table to show.
So... the added row should be Committed in Db
Herman<T>.Instance 2-Mar-18 10:57am View
   
please elaborate 'does not work'
Herman<T>.Instance 15-Feb-18 3:41am View
   
Better stop using SQL! If you can't understand the document and cannot google for a good example....you better stop.
Herman<T>.Instance 15-Feb-18 3:40am View
   
that's it!
Herman<T>.Instance 1-Feb-18 8:07am View
   
--> WHERE MONTH(Clock_Date) = @Month AND YEAR(Clock_Date) = @Year AND OperID=@OperID


Then you select all month data for a given year, so 28/29/30 or 31 days is no issue!
Herman<T>.Instance 30-Oct-17 7:56am View
   
Pretty obscure code!!!
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvDetails.DataSource = ds;
gvDetails.DataBind();
int columncount = gvDetails.Rows[0].Cells.Count;
gvDetails.Rows[0].Cells.Clear();
gvDetails.Rows[0].Cells.Add(new TableCell());
gvDetails.Rows[0].Cells[0].ColumnSpan = columncount;
gvDetails.Rows[0].Cells[0].Text = "No Records Found";
}
When there is no data the gridview component can set a message by using the property EmptyDataText. So you don't have to check if you really have data or not.
See: https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.emptydatatext(v=vs.110).aspx.
Herman<T>.Instance 5-Oct-17 10:46am View
   
I will test your solution this weekend. Thanks a lot for the input and the example!!
Herman<T>.Instance 5-Oct-17 8:07am View
   
Thanks for the lead. I'll investigate that.
Herman<T>.Instance 5-Oct-17 6:37am View
   
well.. the Entity InputFile IS the tablestructure.
Point is that my application receives an EXCEL file. A specific worksheet is then read and values are translated into a DATATABLE object. So that is why I only know that it is not possible to have more than 60 columns. But how many can be different.
So I hoped to find a way that based on the number of columns each datarowvalues should me mapped to the field in the table. So Columns I don't have stay NULL.
Herman<T>.Instance 5-Oct-17 2:56am View
   
Added a code bit
Herman<T>.Instance 22-Aug-17 5:53am View
   
Thanks for the lead Griff! Something to read and workout!