sat8003's Q&A profile

• SQL Server SQL Server connection from C#/asp.net

  I have a connect string to a SQL database: “Data Source=Cats;Initial Catalog=Orders;User ID=sa;Password=sa” It connects to the database correctly. If I change the string to: “Data Source=Cats;Initial Catalog=Orders;User ID=ian;Password=ih” It will not connect. “ian” is a valid SQL login to the Cats server with the same priviledges as the SA account – I can successfully login to SQL Query Analyzer with ian/ih. I tried the same thing on a “local” SQL server database too – got the same error. Any suggestions would be appreciated! Thats not a .NET issue. YOu have to grant the rights / permissions to the database for the user. By default ...Show All

• Visual C# Com+ Trancations

  I am new to COM+ , I am trying to prove the concept of tranactions in COM+ so I have create the following class [Transaction(TransactionOption.Required)] public class SPS:ServicedComponent { public SPS() {} [AutoComplete()] public void SaveStudentData() { Method1(); Method2(); } public void Method1() { StreamWriter writer= new StreamWriter("c:\\Hossam.txt", false ); writer.Write("Method One"); writer.Close(); } public void Method2() { throw new Exception("Asd"); } } I thought that when the Method2 throw exception the file created by Method1 will be deleted or where is the con ...Show All

• Visual C++ VC++ MFC static library producing a link error

  I have two projects that are part of a solution (Microsoft Development Environment 2003) that builds and runs fine when using MFC dlls. I would like to produce a standalone version that does not need the MFC dlls. I assumed this was done by setting "Use MFC in a static library", but when I do this I get a couple thousand link errors. Here is a small sampling: atls.lib(atlbase.obj) : error LNK2001: unresolved external symbol _memmove nafxcw.lib(oledoctg.obj) : error LNK2001: unresolved external symbol _memmove libcpmt.lib(string.obj) : error LNK2001: unresolved external symbol _memmove libcpmt.lib(locale0.obj) : error LNK2001: unresolved ext ...Show All

• Visual C# graphics and thread

  hi i have to draw set of line in inkpicture control. iam drawing in two diffrent threads. using the same graphics ie g = inkpicture.cretaegraphics(). normally i call two threads randomly. now it is giving error like An unhandled exception of type 'System.InvalidOperationException' occurred in system.drawing.dll Additional information: The object is currently in use elsewhere i think i have to dispose g . how can i do it. Hi! Multithreading require very careful programming... You need learn about synchronization more. using(Graphics g = CreateGraphics()) { // draw here } after '}' g will be disposed. ...Show All

• .NET Development drive types

  Hi. I know I can get the logical drives from Environment.GetLogicalDrives() which returns me a string[] of drive letters on the computer. How can I detect if a drive is a DVD (not CD) drive I can make a call to kernel32.dll (dllimport) and use the GetDriveTypeA api and it returns me 5 as a fixed drive (which is correct since it's a CD ROM type drive) but I want to go an extra step further and detect wether the computer has a DVD or CD drive... is there a way of doing this Thanks! Have a look at the System.IO.DriveInfo class. It contains a property called DriveInfo.DriveType that you can use to determine if a drive is a CDRom. ...Show All

• SQL Server High CPU utilization during full-text population in SQL 2005

  Hi, In SQL 2005 a full-text population of a text field in a table containing 1.2 million records utilizes very high CPU resources. A dual Xeon 3Ghz, 1GB memory was running at 95% during the population of the full text catalog. There was no other activity on this server besides the full-text population. It performed the population in approximately 28 minutes, which is allot faster than SQL 2000, however, the high CPU utilization would be of great concern in a production environment. I have not tested incremental or change tracking as yet but i plan to look at this very soon. Is this unusual behaviour or does the SQL full-text ...Show All

• Visual Basic How to reference an item in a formview template in vs2005

  Here is what we are trying to do, in a FormView1 Item template we would like to reference a listbox from another list box, so for example when the user clicks on the first list box and selects a state, the second list box is filled with the county name. The problem is I can't see ListBox2.text since the name of it becomes something like this: Formview1.ItemTemplate.ItemTemplate.Listbox1 but we can't reference it. Please help, thank you. Dan Stojadinovic zodex1@gmail.com Hi, You can use FormView.DataItem property. This article has good sample code http://msdn2.microsoft.com/en-us/library/system.w ...Show All

• Visual C# How to constrain generic type to a superclass instead a subclass of another type?

  In Java 5 you can use the following syntax for variance in generic types: public class A {...} public class AA extends A {...} public class MyContainer<E> { void setComparer(Comparator< super E> c) {...} ... } This means that you can pass instances of either Comparer<A> or Comparer<AA> to MyContainer<AA>.setComparer. Is there a way to specify this type of constraint in .NET The where clause can be used to restrict the type the OTHER way ("where type inherits from another type") but can I define "where type is base class of another type" In other words I need something like the following: pu ...Show All

• Windows Forms UI Patterns

  I am curious as to what patterns, if any, may have been used in the design of TaskVision. For example, Inductive User Interface (IUI), etc. Also, if there are any other WinForms reference apps that may be of similar interest, I'd appreciate some references. Thanks!!! Mark Richman Luxspes - I've seen your posts all over the place about Pattern usage  ...Show All

• .NET Development C struct in .NET

  In a C program a database file is loaded into memory IndexFile=(char*)calloc(256+Filesize,1); GET(FP1,IndexFile,Filesize); and then a struct #pragma pack (push,1) typedef struct _IndexFileData { char  CSN[4]; char  StationName[24]; char  Airport[3]; short  Latitude; short  Longitude; short  Elevation; short  FirstYear[7]; short  LastYear[7]; short  StartingRecordNumber; }IndexFileData, *LPINDEXFILEDATA; #pragma pack (pop) is loaded with an individual record from the in memory file using static IndexFileData hIndexFileData; static int     SizeOfIndexFileData; SizeOfIndexFil ...Show All

• SQL Server Task Upgrades, Update and CanUpdate methods.. Why?

  I am writing a new version of a task with and additional property, and wish to support upgrades between the versions. I have implemented the CanUpdate and Update methods, and update the Xml for the new property. The problem I then have it LoadFromXml gets called which promptly fails since it is still using the old version of the Xml. Have I misunderstood the point of the Update mechanism It would seem to me that I’d better off ignoring Update and implementing the checks defaulting my new property within LoadXml. The new version of SaveToXml would sort out the upgrade when saved again. Reviving a thread from the dead. Does anyone hav ...Show All

• .NET Development SQL SecurityException, but only when debugging remotely?

  Hi All, I'm having trouble remotely debugging a console application. The application will run on my server, but I am developing it on my desktop machine. I am using Visual Studio 2005 and C#. On both machines (server and desktop) I am logged in with my domain account that has administrator rights on both machines. When I run the executable on the server it connects to the SQL Server 2000 instance without problem and starts accessing data. However when I try to start the executable by remote debugging from my desktop machine I get to this line of code: unfetchedPhotosTableAdapter.Fill(photoDataSet.UnfetchedPhotos); ...Show All

• .NET Development Visual Studio .Net in other plataforms

  How many plataforms suport the .Net framework Can I run on Silicon Graqphics Irix .Net Programs Future Plans Greetings Hi, The .NET Framework as such is supported only on the Microsoft Windows Platform and Microsoft has *NOT* announced any roadmap for .NET Framework for other platforms although this is theoretically possible. There has been some 3rd Party efforts such as Mono: http://www.mono-project.com/Main_Page But these efforts take a longer time and usually lag behind by a version or so. As for the future, it does not look like Microsoft will release it for other platforms in the near future. Regards, Vikram ...Show All

• Visual Basic Publish two projects referenced together

  Hello, I have VB.Net 2005 Pro. I built One solution contains two projects Pro1 and Pro2. Pro2 Is a reference in Pro1, Now If I wanna publish Pro2 there is no problem, but If I wanna publish Pro1 the problem comes in this message Could not find the file "Microsoft.Windows.CommonLanguageRunTime, Version = 2.0.50727.0" How Can I publish My Sol !! Unfortunatly that is correct. You will need to build EXE1 manually before building EXE2 if you use a file reference. There is an option you might try to setup the build depenency manually. Select Project->Project Dependencies and mark EXE1 as a dependency of EXE2. T ...Show All

• Windows Forms How to set values in grid cells programmatically?

  I wonder I cannot find a way to do it... I think this should be a very common task. What I need - a kind of calculated columns. A user enters values in a row of datagrid. I want some cells to be calculated automatically, based on already entered columns. Ideally - in some cases - this automatically calculated columns may be overwritten by&nbs ...Show All