Click here to Skip to main content
15,912,400 members
Home / Discussions / WPF
   

WPF

 
QuestionUse dependency properties with a WPF custom control Pin
bytesport27-Mar-18 23:18
bytesport27-Mar-18 23:18 
Rant[REPOST] Use dependency properties with a WPF custom control Pin
Richard Deeming28-Mar-18 7:58
mveRichard Deeming28-Mar-18 7:58 
QuestionWPF DataGrid Group Summary Rows Pin
Kevin Marois19-Mar-18 17:26
professionalKevin Marois19-Mar-18 17:26 
AnswerRe: WPF DataGrid Group Summary Rows Pin
Mycroft Holmes19-Mar-18 21:58
professionalMycroft Holmes19-Mar-18 21:58 
GeneralRe: WPF DataGrid Group Summary Rows Pin
Kevin Marois20-Mar-18 5:01
professionalKevin Marois20-Mar-18 5:01 
GeneralRe: WPF DataGrid Group Summary Rows Pin
Mycroft Holmes20-Mar-18 12:29
professionalMycroft Holmes20-Mar-18 12:29 
AnswerRe: WPF DataGrid Group Summary Rows Pin
Gerry Schmitz20-Mar-18 8:14
mveGerry Schmitz20-Mar-18 8:14 
QuestionBind the Text property of a TextBlock inside a ListView inside a cell of a DataGrid to a ViewModel Pin
Mc_Topaz15-Mar-18 2:47
Mc_Topaz15-Mar-18 2:47 
AnswerRe: Bind the Text property of a TextBlock inside a ListView inside a cell of a DataGrid to a ViewModel Pin
Gerry Schmitz15-Mar-18 6:35
mveGerry Schmitz15-Mar-18 6:35 
QuestionWPF: GroupBox background Image Pin
Hervend8-Mar-18 22:01
Hervend8-Mar-18 22:01 
AnswerRe: WPF: GroupBox background Image Pin
Pete O'Hanlon8-Mar-18 22:44
mvePete O'Hanlon8-Mar-18 22:44 
GeneralRe: WPF: GroupBox background Image Pin
Hervend8-Mar-18 23:06
Hervend8-Mar-18 23:06 
GeneralRe: WPF: GroupBox background Image Pin
Hervend8-Mar-18 23:24
Hervend8-Mar-18 23:24 
GeneralRe: WPF: GroupBox background Image Pin
Hervend9-Mar-18 2:31
Hervend9-Mar-18 2:31 
AnswerRe: WPF: GroupBox background Image Pin
Leif Simon Goodwin8-Mar-18 22:47
Leif Simon Goodwin8-Mar-18 22:47 
AnswerRe: WPF: GroupBox background Image Pin
Leif Simon Goodwin8-Mar-18 22:49
Leif Simon Goodwin8-Mar-18 22:49 
GeneralRe: WPF: GroupBox background Image Pin
Hervend8-Mar-18 23:13
Hervend8-Mar-18 23:13 
GeneralRe: WPF: GroupBox background Image Pin
Leif Simon Goodwin9-Mar-18 0:38
Leif Simon Goodwin9-Mar-18 0:38 
QuestionPassing table value params to Sql Server from WPF app Pin
Christopher Duncan5-Mar-18 7:58
Christopher Duncan5-Mar-18 7:58 
For those familiar with them, TVPs are a great way to reduce the number of calls to the database and improve performance. I use them to great effect in the MVC web app using the general technique below. In the stored procedure I use a cursor to iterate through the rows and do all the db stuff in one whack.

I copied the same routines to a WPF app I'm doing, however, and it flames out calling the proc. I've since deleted it and gone the multiple calls route so I don't remember the precise error message but in general it was barking about not liking the parameters.

I'm on the same box, same version of VS, etc. and literally copied and pasted my routines. Works in MVC, no joy in WPF.

Have any of you successfully used table value parameters in a WPF app, and if so, is there a trick I'm missing?

DataTable tvp = new DataTable();
tvp.Columns.Add(new DataColumn("Id", Type.GetType("System.Int32")));
tvp.Columns.Add(new DataColumn("RowIdx", Type.GetType("System.Int32")));
tvp.Columns.Add(new DataColumn("ParentId", Type.GetType("System.Int32")));
tvp.Columns.Add(new DataColumn("MemberId", Type.GetType("System.Int32")));

DataRow row = null;
int iRowIdx = 0;

foreach (int iId in Ids)
{
	row = tvp.NewRow();
	row["Id"] = 0;
	row["RowIdx"] = iRowIdx++;
	row["ParentId"] = iListId;
	row["MemberId"] = iId;
	tvp.Rows.Add(row);
}
...
Command.Parameters.AddWithValue("@Entries", tvp);
... 
ExecuteNonQuery(), etc.


Thanks!

AnswerRe: Passing table value params to Sql Server from WPF app Pin
Richard Deeming5-Mar-18 8:23
mveRichard Deeming5-Mar-18 8:23 
GeneralRe: Passing table value params to Sql Server from WPF app Pin
Christopher Duncan5-Mar-18 11:03
Christopher Duncan5-Mar-18 11:03 
GeneralRe: Passing table value params to Sql Server from WPF app Pin
Richard Deeming5-Mar-18 12:35
mveRichard Deeming5-Mar-18 12:35 
GeneralRe: Passing table value params to Sql Server from WPF app Pin
Christopher Duncan6-Mar-18 0:43
Christopher Duncan6-Mar-18 0:43 
GeneralRe: Passing table value params to Sql Server from WPF app Pin
Christopher Duncan6-Mar-18 1:23
Christopher Duncan6-Mar-18 1:23 
GeneralRe: Passing table value params to Sql Server from WPF app Pin
Richard Deeming6-Mar-18 1:29
mveRichard Deeming6-Mar-18 1:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.