|
Your post appears to be screwed up. You tried to add a reference and the .DLL does NOT show up?
That's because it doesn't exist. On .NET 4.5, the available references are System.DirectoryServices.dll, System.DirectoryServices.AccountManagement.dll and System.DirectoryServices.Protocols.dll.
I believe the one you're looking for is System.DirectoryServices.dll. It contains the NAMESPACE System.DirectoryServices.ActiveDirectory.
|
|
|
|
|
You are correct. It is screwed up. I was trying to say "does NOT appear in Reference Manager".
I tried adding System.DirectoryServices.dll and the namespace system.DirectoryServices.ActiveDirectory now appears. Thank you very much.
Time is the fire in which we burn.
|
|
|
|
|
I found the object browser in VisualStudio to be very helpful.
I put System.DirectoryServices.ActiveDirectory in the search bar and get:
namespace System.DirectoryServices.ActiveDirectory
Member of System.DirectoryServices
There are strangers on the Plain, Croaker
|
|
|
|
|
That is exactly what I tried and it did not work. In any case, the issue is resolved so thank you for your help.
Time is the fire in which we burn.
|
|
|
|
|
For an Active Directory utility I wrote, I have references to:
C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.DirectoryServices.dll
C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.DirectoryServices.AccountManagement.dll
C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.DirectoryServices.Protocols.dll
|
|
|
|
|
I managed to write what I needed with those references as well. Thank you for your reply.
Time is the fire in which we burn.
|
|
|
|
|
hey all im using visual studio 2015 rc right and i want to connect a sql table to visual studios, im watching a tutorial on youtube on the video the guy (uses 2010)goes to add new item > local database / and i dont have that option? is it removed? or has the name changed?
modified 21-Jul-15 6:30am.
|
|
|
|
|
Are you using the same version as the person in the video?
There will probably be a small difference between the free and the full version.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
no im using 2015 rc he is using 2010 , i wanted to know how do i do it on 2015
|
|
|
|
|
"release candidate"?
Of the community edition?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
i think so , its the 2015 rc but iguess its the comunity one, (free one)
|
|
|
|
|
The free edition is of course limited in functionality.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
This is not a C# issue. However, I just tried it on VS 2013 Express and the option is not available, although on VS 2010 Express it is. I suggest you contact Microsoft.
|
|
|
|
|
Doing some research on techniques for passing a variable length list of parameters of different types, I came across this: [^]
"Another possible solution that doesn’t require you to create a new type is using a Func delegate. Like so:
Func<int, string, Tuple<int, string>> c = Tuple.Create;
var list = new List<Tuple<int, string>>
{
c(1, "apples"),
c(2, "kiwiws"),
};" I've never seen the Tuple.Create method used in this way, and I am real curious about what is going on under the hood.
Appreciate hearing your thoughts on this.
thanks, Bill
«I want to stay as close to the edge as I can without going over. Out on the edge you see all kinds of things you can't see from the center» Kurt Vonnegut.
modified 20-Jul-15 16:10pm.
|
|
|
|
|
Hi Bill,
there's not a lot of magic going on there. c is basically declared as an alias for Tuple.Create(int, string). You could remove the declaration of c and replace c(.., ..) by Tuple.Create(.., ..) or new Tuple(.., ..). Whether or not this is more readable or in just any way better is up to personal taste I guess.
cheers, Sascha
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
Thanks, Sascha ! I've never seen this way of creating a "typed alias" before, and I've been working with .NET intensely for a long time
cheers, Bill
«I want to stay as close to the edge as I can without going over. Out on the edge you see all kinds of things you can't see from the center» Kurt Vonnegut.
|
|
|
|
|
Hi
I download code attached and do exact instructions in this article:
Duplex Service in WCF[^]
but client cannot connect to server.
what is the problem?
|
|
|
|
|
When you have a problem with code you got from an article, you should ask in the forum at the end of the article. It's very unlikely that the author of the piece will just happen on by and open your question.
|
|
|
|
|
I'd also recommend to include any exceptions or errors that you get. When you say that it can't connect, there's a dosen reasons, and the most likely is a firewall.
Try pinging the remote address. If it doesn't answer, then the sample-code won't work either.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I have a simple POS application. I have included the Microsoft.PointOfService and Microsoft.PointOfService.ControlBase to my project and save it in my deployment project too.
Do I need to do anything else? or just deploying those two files is enough?
Thanks,
Jassim[^]
Technology News @ www.JassimRahma.com
|
|
|
|
|
I would think that is a question for Microsoft and would depend on their licensing.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I'm building a simple windows form app which stores all of my DVD's (pet project, just for learning; I'm sure there are plenty already out there). I'm able to add items into the database (azure SQL Server) perfectly, even leaving some or most textboxes blank (the title column is setup as NOT NULL in my table) but I can't get it to retrieve any data.
Here is my OnClick method:
private void searchButton_Click(object sender, EventArgs e)
{
string qString = @"SELECT Title, Director, Genre, ReleaseYear, Length, NumberofDisks, Description FROM Base WHERE Title = '" + titleTextbox.Text + "' AND Director = '" + directorTextbox.Text + "' AND Genre = '" + genreCombobox.GetItemText(genreCombobox.SelectedItem) + "' AND ReleaseYear = '" + yearCombobox.GetItemText(yearCombobox.SelectedItem) + "' AND Length = '" + lengthTextbox.Text + "' AND NumberOfDisks = '" + numberOfDisksTextbox.Text + "' AND Description = '" + descriptionTextbox.Text + "';";
string cString = @"Server=MyAzureServer,MyPortNumber;Database=MyDatabase;User ID=me@MyAzureServer;Password=MyPassword;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";
DataTable dTable = new DataTable();
SqlConnection sConnection = new SqlConnection(cString);
sConnection.Open();
using(SqlCommand sCommand = new SqlCommand(qString, sConnection))
{
try
{
SqlDataReader sReader = sCommand.ExecuteReader();
dTable.Load(sReader);
}
catch(SqlException sEx)
{
MessageBox.Show(sEx.Message);
}
resultsDataGridView.DataSource = dTable;
}
sConnection.Close();
}
and here is my table:
CREATE TABLE [dbo].[Base]
(
[MediaID] [int] IDENTITY(1,1) PRIMARY KEY,
[Title] [nvarchar](50) NOT NULL,
[Director] [nvarchar](50) NULL,
[Genre] [nvarchar](50) NULL,
[ReleaseYear] [date] NULL,
[Length] [time] NULL,
[NumberOfDisks] [int] NULL,
[Description] [nvarchar](200) NULL
)
I absolutely realize this is open to SQL injection. My plan is to just 'get it working' and then I will go back over it and and change to parameterized queries (I have to read up on how to use them). The program compiles and runs fine. When I click the search button with all or any of the textboxes filled, it returns no results in the datagridview. The white grid shows up but it is empty. I can query the database directly and get the results I'm looking for, but not programatically. Do I need to build the query using logic? Since almost all of my columns accept null (except Title) I'm assuming leaving a field blank wouldn't be a problem, but even if I enter data into all of the available textboxes(exact matches including case just to be certain) I get no results. Am I missing something small and stupid?
Can anyone give me any help or hints? Please no laughing at my code or making fun of me
Thanks,
John
"Only a fool learns from his own mistakes, but a wise man learns from the mistakes of others." -Unknown
|
|
|
|
|
Please learn to use parameterized statements and NEVER use concatenation to provide values, especially values from the user.
That will likely solve your problem.
|
|
|
|
|
You said that you know that the code is vulnerable to SQL injections but that is not the only reason why to use parameters. Another thing is that they help you with conversions. Consider for example dates and the date format or numbers. Using a correct format is difficult when the data is in text format.
Few other reasons why the query might not return any data
- There are a lot of conditions. Since they are defined in the WHERE clause you cannot leave any of them empty and expect that the condition would be ignored. If a text box is empty the comparison will still take place
- The operator for all conditions is AND so all the the conditions you have specified must be satisfied by a single row
- You use equality in all comparisons. For example description is compared to the value from the text box using equality. This means that the text must match exactly and completely. This prbably isn't what you're after. Perhaps LIKE comparison?
|
|
|
|
|
Yeah, it'll help you to "get it working" if you just went to parameterized queries to begin with to help you avoid problems such as these and also makes it much easier to debug when you do run into problems.
Your WHERE clause is screwing you over somehow. Rewrite to help you debug the problem and make sure the parameters you're passing in are expected and correct.
|
|
|
|