distinct values in dataset

.NET Framework Data Access and Storage

- Previous
  - 1
    - Win APIs Hi there, To add a printer port why not just use WMI, its alot more easier than having to deal with Win32 directly. I have had more success with WMI than Win32. Try this code snippet, I cant be sure it will compile. You will need to use the System.Management namespace. ManagementScope managementScope = new ManagementScope( "\\\\192.168.0.1\\root\\cimv2" ); //this needs to be defined if the port is being created on another computer, if on the same computer than skip this step. managementScope .Options.Username = username; managementScope .Options.Password = password; managementScope .Options.Impersonation = ImpersonationLevel.Impersonate; ManagementPath managementPath = new ManagementPath(" Win32_TCPIPPrinterPort" ); ManagementClass managementClass = new ManagementClass(managementScope, managementPath, null ); ManagementObject managementObjectInstance = managementClass.CreateInstance(); managementObjectInstance[ "HostAddress" ] = "192.168.0.1" ; //hostname managementObjectInstance[ "Name" ] = "lp_192.170.1.1" //PortName managementObjectInstance[ "PortNumber" ] = 9100; //standard port number managementObjectInstance[ "Protocol" ] = 1; //1 implies RAW Protocol managementObjectInstance[ "SNMPEnabled" ] = true ; //boolean managementObjectInstance[ "SNMPCommunity" ] = "public" ; managementObjectInstance[ "SNMPDevIndex" ] = 1; managementObjectInstance.Put(); //this method actually creates the port Hope this helps edit: removed the enum object from ManagementPath constructor and substituted with the correct information, Win32_TCPIPPrinterPort. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 2
    - WSDL.EXE - Cannot create proxy file Hi Marc, It seems to be a problem with the WSDL or something is not compatible with the tool "wsdl". Is the Wsdl to big to post it here Regards, Pablo. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 3
    - CodeEntryPointMethod and adding parameters I could reproduce your problem. Looking at the CSharpCodeGenerator class, it outputs "Main()" and pays no attention to the Parameters property. You'll have to use CodeMemberMethod and hard-code the name to "Main". Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 4
    - what is masterpage concept? is it diffrnt than user controls' part? Hi, Below is a link that can help you find some information regarding master pages http://msdn2.microsoft.com/en-us/library/aa581782.aspx (The same reply given as in post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1612118&SiteID=1&mode=1 ) Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 5
    - escaping special characters during XSLT conversion You should not need to worry about this because ® and R are logically identical unicode characters. If you are having issues it's probably because of the way your XSLT output is being "encoded" into bytes and then being "decoded" back into unicode characters by whatever application is displaying the result. If you "encode" the output into bytes using the UTF-8 encoding then everything should work fine since UTF-8 supports the full range of unicode character values. If you chose some other limited encoding then you might be running into issues where the character value is not represented in the encoding you have chosen. One common trap is piping output through the Console.Write since the Console by default encodes characters using a very limited ASCII range. It is always better to write output directly to a file so that it gets encoded correctly. For help on encoding issues, see How to Encode XML Data . -Chris. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 6
    - Proxied HTTPS Request Not Supported I would look at the network traffic using Microsoft Network Monitor, or tcptrace from http://www.pocketsoap.com . Compare the system that fails against the system that succeeds. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 7
    - How can I loop the recordset? Code Block private static void ReadOrderData(string connectionString) { string queryString = "SELECT OrderID, CustomerID FROM dbo.Orders;"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); // Call Read before accessing data. while (reader.Read()) { Console.WriteLine(String.Format("{0}, {1}", reader[0], reader[1])); } // Call Close when done reading. reader.Close(); } } OR private static DataSet SelectRows(DataSet dataset, string connectionString,string queryString) { using (SqlConnection connection = new SqlConnection(connectionString)) { SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand( queryString, connection); adapter.Fill(dataset); return dataset; } } you can use foreach(DataRow row in DataSet.Tables[0].Rows) { ... } Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 8
    - Associate custom serializer with class? How about add a placeholder attribution to force Windows to be treated as an object Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 9
    - Advice re transactions across multiple SqlConnections... May I know why you are using multiple SqlConnection pointing to same MS SQL 2005. Can't u use a single instance of SqlConnection If you don't want to use TransactionScope in that case every SqlConnection has maintain its own SqlTransaction. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 10
    - aspnet_wp.exe could not be launched This was a known bug in ASP.NET 1.0 when run on a Domain Controller but it should have been fixed in ASP.NET 1.1. Verify that the Reports and ReportServer web sites are configured for ASP.NET 2.0 If you need further assistance I recommend that you post your questions on the following forum: ASP.NET - Installation & Setup Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 11
    - .NET 2.0 redistributable (x86 and x64 operating systems) no it is not available... Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 12
    - decoding email subject text Looks like a variation of "quoted-printable" MIME encoding. Usually, non-printable characters are encoded as "=XX" where XX is a hexadecimal number for the ASCII character. But, that encoding doesn't replace space with underscore or embed the character set (like iso-8859-1) into the stream. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 13
    - Datasets and variable table names I couldn't manage to work with variable tablenames on the tableadapter create with the disegner. The work around was to create a database for each year Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 14
    - How to use IDataAdapter ?? Since IDataAdapter is just an interface and not the actual class, you have to assign to this variable specific adapter, same as you do with the command. Otherwise you cannot fill the data. You could pass it as a parameter from outside to keep this part of code generic. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 15
    - Inserting elements to a collection ICollection is an interface, not an abstract base class. When you implement an interface, you are forced to implement all of its methods, nothing is inherited. You are free to throw an exception in such a method implementation if you decide not to support it. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 16
    - Cannot serialize XML from loaded assembly. Please help! This appears to be some kind of anomaly in Visual C# 2005 (express). I moved my files to a new project and it disappears, but now I get this exception: I have two projects, one depends on the other and uses it as a reference. So what would I see this error System.InvalidOperationException: There was an error generating the XML document. ---> System.TypeLoadException: Could not load type 'NWN2Fusion.ConnectionList' from assembly 'NWN2Fusion, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'. at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterConnectionList.Write4_ConnectionList(Object o) --- End of inner exception stack trace --- at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id) at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o) at NWN2Fusion.ConnectionForm.button1_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
- Next
  - 1
    - Obtaining a COM object via it's Guid in C# I think your answer is in the System.Activator namespace. There are several methods to create instances there. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 2
    - Socket.Disconnect & .Net socket reuse question The latter I think. See BeginAccept method http://msdn2.microsoft.com/en-us/library/6y709t3b.aspx where one can pass in the socket to use for an accepted connection. Code Snippet public IAsyncResult BeginAccept ( Socket acceptSocket, int receiveSize, AsyncCallback callback, Object state ) See Winsock's AcceptEx http://msdn2.microsoft.com/en-us/library/ms737524.aspx and DisconnectEx Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 3
    - System.Array to pointer To make that work, you'd need to be able to do this: fixed (void* ptr = arr[0]) { } That won't fly when "arr" is of type Array, you can't index a plain Array. It works fine when "arr" has a declared type. The Array class does have an internal method that does what you want to do: Array.InternalGetReference(void* elementRef, int rank, int* indices). Unfortunately, there's no way to call this method using Reflection, you can't get the arguments converted to object[]. When you're trying to break the rules like this, there usually is a better approach than resorting to void*. One that might actually work if the array element alignment is not what a void* would expect. An Array(struct) wouldn't typically meet that requirement. What are you trying to do Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 4
    - aspnet_wp.exe could not be launched Have fixed problem. Still don't know what caused problem but have run repair on .NET Framework and now can run ASP.NET applications under IIS. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 5
    - How to Read the Character From image Hi, I have One Image File......I that image File have some character and number...How can i read the character and number from the Image File.. Advance Thanks, Thanks & Regards, S.Sajan Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 6
    - System.Uri not cleaning up additional slashes I found the Windows Update that installs the new version of System.dll, so to those that's experiencing problems with their applications because of this behavior, you may want to uninstall the following Windows Update (for the time being until the appropriate solution is found): ��Security Update for Microsoft .NET Framework, Version 2.0 (KB928365)�� Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 7
    - strange Thread-pool behavior behind WebService I'm not clear what the purpose of this custom thread pool is Website requests are already served from the managed System.Threading.ThreadPool so you have your own thread to work on at the time. It seems like you're trying to find a very complex solution to a problem that's already been solved - though it is quite possible that I misunderstand what you are trying to achieve. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 8
    - Windbg slow when debugging managed executables Ekart, What version of WinDbg are you using Does the slowness reproduce if you remove the network location from your symbol path Jon Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 9
    - Regular expression is never finishing match! Help me tune it, please... The periods in the address in line 10 are going to be problematic...if you want to match an address that uses commas here is a much better one that won't cause the regex process to get locked up...Here is one where the data is placed into named match capture groups for easy extraction. Note match index 0 is the whole match. Input Text 2121 1st ave nw, calgary, alberta, canada Regular Expression ( < Street >[^,]*) # Put street into named group street. ( :,) # Match but don't capture (MBDC) the comma ( < City >[^,]*) # Extract the city. ( :,) # MBDC , ( < Province >[^,]*) # Province named match capture. ( :,) # MBDC , ( < Country >[^\r\n]*) # All into country Group Captures Groups: (0) (Street) (City) (Province) (Country) Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 10
    - Web Services - can only be used by other ASP.NET apps? If you mean can you call web services built with vs2005 from non .net applications the answer is generally speaking yes. If you mean can you publish a .net web service to IIS (with .net 2.0) and then deploy it on another web server not running the .net framework then I believe the answer would be no. Thanks, -Stephen Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 11
    - Event Handlers Dynamic controls You could start with posting in a forum where it's relevant, eg: http://forums.microsoft.com/MSDN/default.aspx ForumGroupID=2&SiteID=1 Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 12
    - Protected Memory Error Your C++ code appears to implement a COM server. Instead of redeclaring its interfaces, you probably should generate an interop assembly. Project + Properties, Add Reference, COM tab, select your COM server. The IDE automatically runs Tlbimp.exe to generate the interop DLL. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 13
    - How to send a SMS message programatically from a desktop app using C#? you would require an SMS gateway from somewhere, a webservice so you can use this within your C# application. There maybe free ones but most of them you will have to pay for the service. Once you have obtained this service, simply follow the instructions on how to implement it and use it into your application. Generally its a case of adding a reference to the webservice, and calling the methods on the webservice, perhaps also giving the credentials of your account for authentication/verification, then send the SMS message. Hope this helps. Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 14
    - difference between web service and website in VWD 2005? Shobha, Visual Studio differentiates their web-based applications in 2 different project templates (by default): WebSites and WebService. Actually both are ASP.NET hosted applications or web applications and actually you could for example convert or mix a WebSite project into/and a WebService project (manually).... With the current releases of Atlas... you can also see that in VS there's a new project template called "Ajax enabled WebSite" that is actually the same as a WebSite with Ajax extensions. So, project templates are just a shortcut for creating typical applications... in this case you have 2 templates for creating ASP.NET applications. However, those templates are there for some purpose.... I mean, it has sense to have 2 project templates for the same kind of application... why Because usually ASP.NET WebSites represents a web application front-end, with screens, CSS, and UI components... and ASP.NET WebServices exposes WebServices that usually exposes business functionality through its webmethods just like a ClassLibrary exposed with a facade.... but in this case using SOAP and XML protocols. So... WebSites are just the user interface of your application.... and WebService are intended to expose some functionality to the outside or to some other layer as a service..... for example a typical scenario is to have a WebSite (UI) that consumes a WebService with the business logic layer. Regards Rodrigo Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 15
    - MessageBox display called from a separate thread No Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development
  - 16
    - Opening resource files / Object not found error Hi DB-9_Connector, What kind of exception you received Please post your exception in detail, include the exception message, stack trace. Thanks! Tag: .NET Framework Data Access and Storage distinct values in dataset .NET Development

arkiboys

I have populated a dataset with one table.
The data in the table looks as follows:
Index1Name Index2Name City Value
Indexk Indexk city1 2
Indexk Indexk city1 3
Indexk Indexd city1 2
Indexk Indexy city1 1
Indexy Indexk city1 1
Indexx Indexk city1
Indext Indexq city1 5
Indexs Indexs city1 6

Now I would like to have an array which gets populated from the distinct values in columns of Index1Name and Index2Name
So the array should contain something like:
Indexd Indexk Indexy Indexx Indext Indexs Indexq

Thanks

Top

Re: .NET Framework Data Access and Storage distinct values in dataset

Steve Tighe

If you are using .net 2.0 then you can quickly create a dataview of column you are intrested in and the then use the ToTable method of the view to create a table filled with the distinct values. The performance of that would be directly related to the number of records present. If you are using .net 1.0 then you will need to loop the tablerows and populate your array, this will be slower because you will need to check for the existence of the value in your collection before you add it.

Hope that helps, sorry its a bit brief.

Cheers

Steve

Top