Click here to Skip to main content
15,888,816 members
Home / Discussions / C#
   

C#

 
GeneralListView grouping Pin
dpmIris4-Feb-05 2:49
dpmIris4-Feb-05 2:49 
GeneralRe: ListView grouping Pin
Heath Stewart4-Feb-05 6:07
protectorHeath Stewart4-Feb-05 6:07 
GeneralRe: ListView grouping Pin
dpmIris6-Feb-05 22:01
dpmIris6-Feb-05 22:01 
GeneralRe: ListView grouping Pin
Heath Stewart7-Feb-05 6:47
protectorHeath Stewart7-Feb-05 6:47 
GeneralRe: ListView grouping Pin
Joel Lucsy4-Feb-05 9:51
Joel Lucsy4-Feb-05 9:51 
QuestionHow can I controle by resource in C# !!!! Pin
students552 university4-Feb-05 2:49
students552 university4-Feb-05 2:49 
AnswerRe: How can I controle by resource in C# !!!! Pin
Heath Stewart4-Feb-05 6:06
protectorHeath Stewart4-Feb-05 6:06 
GeneralUsing a View in SQL server and SqlCommandBuilder at the same time Pin
hajob4-Feb-05 2:13
hajob4-Feb-05 2:13 
Hi everyone,
I am using a view in SQL server as a filter in order to show only a subset of rows to the user (depending on specific rights noted in a separate table).

At the same time I make use of the SqlCommandBuilder because I do not need any specific control over the sql statements.

This works nicely as long as select rights are granted to the user to both the view AND the underlying table. If I switch off the select right on the table (which is why I am doing this in the first place) the CommandBuilder cant find the schema information necessary to build the commands.

Now: The necessary schema information is present in the program in the form of a dataset containing all the tables, PKs and FKs (it gets the information at design time, no need to access the DB at runtime).

Does anyone have an idea how I can convince the SqlDataAdapter or the SqlCommandBuilder to make use of this information rather than to retrieve it from the server?

Anything that would save me writing tons of dumb sql-statements would be greatly appreciated!

hajo
GeneralRe: Using a View in SQL server and SqlCommandBuilder at the same time Pin
Heath Stewart4-Feb-05 6:02
protectorHeath Stewart4-Feb-05 6:02 
GeneralRe: Using a View in SQL server and SqlCommandBuilder at the same time Pin
Scott Serl4-Feb-05 8:25
Scott Serl4-Feb-05 8:25 
GeneralRe: Using a View in SQL server and SqlCommandBuilder at the same time Pin
hajob6-Feb-05 0:10
hajob6-Feb-05 0:10 
GeneralRe: Using a View in SQL server and SqlCommandBuilder at the same time Pin
Heath Stewart6-Feb-05 5:49
protectorHeath Stewart6-Feb-05 5:49 
GeneralRe: Using a View in SQL server and SqlCommandBuilder at the same time Pin
hajob6-Feb-05 22:41
hajob6-Feb-05 22:41 
GeneralMultiple Assemblies Pin
innocent734-Feb-05 1:52
innocent734-Feb-05 1:52 
GeneralRe: Multiple Assemblies Pin
SimonS4-Feb-05 2:11
SimonS4-Feb-05 2:11 
GeneralRe: Multiple Assemblies Pin
innocent734-Feb-05 2:35
innocent734-Feb-05 2:35 
GeneralRe: Multiple Assemblies Pin
Stefan Troschuetz4-Feb-05 3:15
Stefan Troschuetz4-Feb-05 3:15 
GeneralRe: Multiple Assemblies Pin
Heath Stewart4-Feb-05 5:57
protectorHeath Stewart4-Feb-05 5:57 
Questionhow to install a self made windows service on other machines.. Pin
just_starting4-Feb-05 1:47
just_starting4-Feb-05 1:47 
AnswerRe: how to install a self made windows service on other machines.. Pin
Esmo20004-Feb-05 4:28
Esmo20004-Feb-05 4:28 
GeneralRe: how to install a self made windows service on other machines.. Pin
Heath Stewart4-Feb-05 5:46
protectorHeath Stewart4-Feb-05 5:46 
AnswerRe: how to install a self made windows service on other machines.. Pin
Heath Stewart4-Feb-05 5:53
protectorHeath Stewart4-Feb-05 5:53 
GeneralRe: how to install a self made windows service on other machines.. Pin
just_starting4-Feb-05 9:32
just_starting4-Feb-05 9:32 
GeneralRe: how to install a self made windows service on other machines.. Pin
Heath Stewart4-Feb-05 12:56
protectorHeath Stewart4-Feb-05 12:56 
GeneralSintax error in the INSERT INTO instruction Pin
Sasuko4-Feb-05 0:34
Sasuko4-Feb-05 0:34 

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.