Comments by BoySetsFire

BoySetsFire 22-Aug-17 9:13am View

Deleted

ih this case i become this result:

User
UserID	Name	Adress	bla... 	RoomID	Room	...
a	Max			x	Room1
a	Max			y	Room2
a	Max			z	Room2
b	Peter			x	Room1
b	Peter			y	Room2
b	Peter			z	Room3

and I want a result like this:

UserID
a	Max
b	Peter

BoySetsFire 22-Aug-17 6:56am View

select * from User

join Join_User_Room on UserID	= UserID	
join Room on RoomID = RoomID 

where  RoomID in( X, Y, Z)

now has the result set to many rows. from the join table... but, i want to see onley two rows, the row from user a and the row from user b...

Br,

Benny

BoySetsFire 15-Feb-17 4:56am View

Hi & Thx for your answer... the dynamic comes from testing... if i cast by hand is works like convert.tobool(val)

the datatype in the db is a bit

br,
Benny

BoySetsFire 30-Mar-16 5:29am View

thx! That's a good idea, but i can't configure the FTP-Server

BoySetsFire 30-Mar-16 3:39am View

Many thanks for the answers!

Now i will describe in more detail:
1. We have a linux based FTP server.
2. The customers use OSX computers.
3. They upload files/folders with illegal characters (it is possible with OSX).
4. My .Net application process the files ie. System.io.file.copy() (if the filename/path is ok), but has the file illegal characters, i get an exception.
5. Now i must rename the files with a OSX computer.

the function system.io.Path.GetInvalidFileNameChars() returns the illegal chars, but how can i rename illegal files on the windows side

BoySetsFire 20-Apr-15 6:50am View

Hi Bill!

Thx for your answer!!!

This is my code :)

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.ComponentModel.DataAnnotations;
using System.Reflection;
using System.Configuration;

namespace PropertyGrid1
{
public partial class Form1 : Form
{

private void Form1_Load(object sender, EventArgs e)
{
PDFSettings settings = new PDFSettings();
propertyGrid1.SelectedObject = settings;
}
}

class PDFSettings
{
[Range(1,100)]
[DefaultValue(85)]
public int PDFJPEGQUALITY { get; set; }
}

BoySetsFire 16-Jul-12 9:40am View

Force the Resize....
http://social.msdn.microsoft.com/Forums/en/wpf/thread/9fe240ea-cc56-412c-8549-224b0a95ae57

Comments by BoySetsFire (Top 7 by date)