surfmuggle

1

votes
0

answer
487

views

Compare Names using Levenshtein distance

In my application i need to identify a person by searching for their lastname and firstname. One requirement is to accept spelling errors to a certain degree. My attempts to identify a person given a firstname and lastname were: sql query using soundex sql query using levenshtein-distance (LD) wh...
surfmuggle
1

votes
1

answer
71

views

SQL Server Trace file create unique identifier for field TextData of type NTEXT

To analyse my imported trace file it would like to have a unique value for Select Distinct TextData from myImportedTraceFile I tried using hashbyte although i am not sure if MD5 is the right tool to create a unique identifier. Even if this were the case (please tell me if it is so) then i still ha...
surfmuggle
1

votes
1

answer
35

views

Code disentangle - what does query of T do

We have three components: WinForm-Rich-Client, IIS-Webserver using WebApi, entity framework for most of the database queries. I was given a code base and i am lost. I unterstand that some classes Student are passed dynamically around using TEntityType. I the msdn docs i read that you can use this...
surfmuggle
5

votes
2

answer
856

views

Using Extension methods in RoslynPad

I try to understand an extension method similar to this code var p = new Person('Tim'); p.LastName = 'Meier'; // reader.Get('IsDerivat'); var IsOlivia = p.Get('Olivia'); This is my code inside RoslynPad: public static class PersonExtensions { public static T Get(this Person person, string nam...
surfmuggle
1

votes
2

answer
11.2k

views

app.config read value of key connection string from other node

On stackoverflow are a couple of questions regarding how the get app.config values from code or using windows path variables. But I would like to know if i can use an already defined key inside the app.config xml file? The purpose is to avoid entereing the connection string many times. Below you can...
surfmuggle
21

votes
4

answer
10.3k

views

Are security concerns sending a password using a GET request over https valid?

We have webpage which uses the sapui5-framework to build a spa. The communication between the browser and the server uses https. The interaction to log into the page is the following: The user opens the website by entering https://myserver.com in the browser A login dialogue with two form fields fo...
surfmuggle
1

votes
3

answer
1.2k

views

Pivoting 2 columns from 3 Tables and creating pivot-column-names to avoid conflict - SQL-Server 2008R2

Intro and Problem In my example i have teachers, students and courses.I would like to have an overview which course is teached by whom in which rooms and all the studends in this course. I have the basic setup runnig (with some handcoded statements). But until now i had no luck to prepare the correc...
surfmuggle
3

votes
1

answer
2.8k

views

Return only certain columns / fields from Dapper connection.Query<T>(sql)

The problem and the question Problem: I thought that connection.Query('Select A, C from myTable'); would only fill the selected columns and the matching fields of the underlying class / object. But it seems that this is not the case - (although the reason might be my misuse or how i serialize the re...
surfmuggle
4

votes
1

answer
904

views

plugin illuminate 0.7 incompatible to jQuery 1.9.1 or jQuery-UI 1.10.3 -> TypeError: $.css(…) is undefined

Changes in jQuery or jQuery-UI are incompatible to plugin jquery.illuminate.0.7 The plugin jquery.illuminate.0.7 works in chrome 30, firefox 22 and IE 10. It uses jquery_1.6.1.min.js jquery-ui_1.8.13.min.js jquery.illuminate.0.7.js But changing the version of jQuery and jQuery-UI the causes the demo...
surfmuggle
3

votes
2

answer
7.6k

views

How to get and extract matched css rules on dom-node?

I would like to know an easy way to get all the css rules and classes on a certain DOM node and the subtree programmatically. Chrome Dev Tools Inspecting the style of an element in the chrome dev tools returns 2 panels Computed Style Styles The Styles-Panel has 3 different style categories: element...
surfmuggle
2

votes
1

answer
150

views

Select returns no rows - queries in trace file

I imported a trace file using SELECT * INTO trace_table FROM ::fn_trace_gettable('c:\my_trace.trc', default) While analyzing my imported trace file i noticed that certain select statements take a significant amount of time (duration) and cpu but at the end do not return any rows (RowsCount == NULL)...
surfmuggle
8

votes
2

answer
1.2k

views

Binding custom objects (List<T>) that have Sublists to a Grid by pivoting the sublist

I would like to bind a List of CourseDetails List to a grid / xtragrid. Each CourseDetail has a Property StudentList of type List. The List of students should be pivoted so that the result looks like this: My Question How can i pivot every student in the StudentList so that i can databind a List to...
surfmuggle
3

votes
1

answer
9.3k

views

Create BandedGridView for DevExpress XtraGrid

I would like to know how the XtraGrid and the BandedGrid play togehter and are bound to the underlaying data. The documentation has some explanatory tl;dr-text but i am missing a full working example to set it up in code. So it took me about 2 hours to figure it out. Based on this blog entry i wo...
surfmuggle
3

votes
1

answer
865

views

How to create an anonymous type like this var c = List<string, string[]>()

I would like to create a anonymous type that can be iterated, takes a string and a string array. The goal is to create a list of groups and each group contains persons: I would like to know if something like this Pseudo-Code is possible: var myAnoty =new List(); myAnoty.add('Programmers', ['Linus',...
surfmuggle
2

votes
3

answer
210

views

Understanding scope, ng-click and the angular-way

While working on the phone tutorial i wondered how to implement this use case user clicks on add phone the function addItem is fired and the phone.id is passed the relevant phone is retrieved and the quantity increased by 1 the increased quantity should be displayed in the input You can find my...
surfmuggle
0

votes
2

answer
575

views

Adding item to model and refresh a second ng-repeat

While working on the phone tutorial i wondered how to implement this use case browser renders a list of phones user clicks on add phone for one of these phones the function addItem is fired and adds this phone into the array phonesInCart the list with phones in cart $scope.phonesInCart = []; is upd...
surfmuggle