Hi I need to use CLR to make a stored procedure that uses stuff in .net 3.5. If I don't put Permission_Set = UnSafe I can't do it it will just die and give me this error Deploy error SQL01268: .Net SqlClient Data Provider: Msg 6503, Level 16, State 12, Line 1 Assembly 'system.core, version=3.5.0.0, culture=neutral, publick...
I am using the below code, and it only sends one email - I have to send multiple emails. For getting more than one email I use: string connectionString = ConfigurationManager.ConnectionStrings["email_data"].ConnectionString; OleDbConnection con100 = new OleDbConnection(connectionString); OleDbCommand cmd100 = new OleDbCommand("select t...
i have array for (int i = 0; i < ds100.Tables[0].Rows.Count; i++) how to delete multi rocord for each value using c#, dot.net ...
Hi All, I've got a loop that executes the stored procedure in a loop with over 40,000 iterations, like so: SqlCommand command = new SqlCommand("WriteDataToDB"); command.Connection = _connection; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@SignalID", SqlDbType.Int).Value = Arg_Si...
This piece of code compiles OK in VS 2010 in a framework 3.5 project (I triple checked that) public LoggingClient(string uri = "net.msmq://localhost/logging"){...} Why? I see nothing in the C# 4 spec (doc version), section 21.1, that says this should be backwardly compatible. How is it that I get no compilation error? Will this fa...
I want to write a dummy printer driver which appears as a shared printer on a LAN and can accept print jobs; so when its installed on a computer other computers in the LAN can browse and add it as a usual shared network printer and send print jobs to it. I want to do this in c#, are there any better suggestions? Can anyone tell me any i...
In normal separate XML file configuration i place in my root directory my application works just fine with both appenders. However, I have found an easy and more efficient way to configure from an external file Which allowed me the flexibility of using the same config file for different applications... Also one more advantage is I don...
When will Asp .Net 4 MCTS exams available? ...
Because I haven't found a better way to handle my configuration, I have been using XmlSerializer to serialize a Dictionary (explain that later) containing all the things I want saved. Now that I have gotten more crafty, I have started to build more complex data types. The only problem is that now when I serialize the object, it throws an...
I've just begun using StringTemplate (from stringTemplate.org) and I'd like to know how to achieve grouping in the results. e.g. Month , ID __________________ Jan ,1 Jan ,2 Feb ,3 Feb ,4 Feb ,5 Mar ,6 Mar ,7 Mar ,8 Mar ,9 so that the results when grouped by mon...
i m working on installer project . where i need to extract files to the disk. how can i calculate the disk space available on hard disk using c#?? ...
I have developed a Windows application in .NET which uses a SQL Server database to store, retrieve and manipulate data and tables through sql queries. Now I want to know when I would deliver its executable (.exe) file to client then in which form I have to deliver that database so that the application can connect to database. Should I ...
Hi Can't you have a .net 4.0 web service application? When I choose .net 3.5 the "asp.net web service application" shows up in the list but once I change it back to 4.0 it goes away. Did something replace it or they just don't have a webservice at 4.0 yet? ...
Is there a way to consume events that were published on a different host? To be more exactly: if I have two CEP servers running on different hosts how can I bind a query to an event producer that's running in a different CEP engine. I would greatly appreciate some real examples, too. ...
I have a built a .net application using visual studio. This application is coded in C# and uses SQLSERVER for database purposes(storage,retrieval and manipulation of data). Please tell me how to give this application to client? Do I have to install .net framework on client's computer..? Do I need to install complete sqlserver on client...
Hi, Lets say I have a table that looks like this: Name value 1 Ford "some text here and there." 2 Honda "More Text Again" How can I write a sql function that will append me the 'value' column of all of the rows. so the result would be sometext here and there. More Text Again also it would be nice if I can...
If my application starts, I check first if there is already an instance of the app and if yes, I give focus to the running instance and terminate the newly created process. I make this with a named pipe that is registered through WCF. That works fine so far. Now my app will also be used in a terminal server environment. Is it right that...
I have a listview which is filtered by the text entered by the user. Is there anyway to get the visible items from the listview? ...
Hi, I have written one VSTS data driven test case. Where I need to update IE proxy setting for individual test cases. I have written following line of code to change proxy RegistryKey reg = Registry.CurrentUser.OpenSubKey(@"Software\Microsoft\Windows\CurrentVersion\Internet Settings\Connections", true); string va = reg....
As long as I program, I always did it with MS-technologies. There was DOS, MFC , VB6, then .net with WinForms and now WPF. In all these technologies, the GUI-thing was always more or less the same, because it based on Win32 (except DOS). With WPF now all has totally changed. MS introduced a lot of new possibilities, beginning with the d...