slender_bamboo's Q&A profile
.NET Development Help: new to Data access stuff
hi all, i am completely new to working in data base access using c# and visual studio 2005. i do not have db yet. where can i get beginners tutorial on creating, and accessing data base in VS2005 and c# will really appreciate. rnv Hi there, try this article http://www.dotnetspider.com/tutorials/DatabaseAccess.aspx it explains a lot about how to access a database from C#. Also Google "Database Access ...Show All
.NET Development How do you list container names?
Say I use sn -i file container_name to install a keypair into a container. Is there a way with sn.exe to list all the container_names in a CSP Hi Keith, Unfortunately SN does not expose a list of key container names -- however, you can get at this information programatically with the CryptGetProvParam Win32 API passing in the PP_ENUMCONTAINERS flag. If you don't want to write code, you can check out Mic ...Show All
SQL Server Does anyone have a script to reset all logins on a server?
We want to merge 2 SQL servers into one. This means we will have duplicate logins with differing passwords. We want to reset all the passwords on one server to something memorable. Does anyone have a script that cursor through (or trans - I'm not shy) all the logins in a mster db I really don't fance going through hundreds of logins changing their passwords by hand! Looking into it, I think I can cursor thro ...Show All
SQL Server Does SQL Server Support the "MINUS" Keyword?
Maybe there's another better way to do this... Anyway, here's what I'm trying to do: I have two tables CarType & Cars. Table CarType has a column CarTypeId which is the primary key (int, identity). Table Cars includes a column CarTypeId (int) which is a foreign key into the CarType table. Now I am trying to build a list of all those CarTypeId entries (from the CarType table) for which there are no Cars (i.e. there is no corresponding e ...Show All
Visual C# question about retrieve single selected date in MonthCalendar
hi, i am new to c#, in my project, when a date on the monthcalendar is selected, i want to catch the date for future use (e.g. retrieve all the bookings on that date from db). i have read some articles about this, now i can call "SelectionRange.start.ToString(); " to get the starting date and call "SelectionRange.end.ToString(); " to get the ending date. what about a single date selected i tried "SelectionRange.start.ToString(); " and "Sel ...Show All
Windows Forms Bitmap editing with different bitmap formats
I have experimented with the Bitmap class and image processing. All the work I have done is on 24 bit images. To manipulate the pixels I use unsafe code and pointers. Ie for 24 bit images I have one byte for red, one for green an ...Show All
.NET Development How to find framework version no?
Hi I have .NET 2002 and .NET 2003. I'd like to know whether my framework version is older than .NET v1.0.3705 for .NET 2002, becaue some identifiers didn't recognized by compiler. Thanks, reneesol Hi, I do not have installed VS 2003 or 2002. But I think in the about Visual Studio dialog you should see your .net version. In Visual Studio 2003 you can compile against .net 1.1. You can choose this anywhere in ...Show All
Visual Studio Error 5 Unable to copy file "obj\Debug\BO.dll" to "bin\Debug\BO.dll". The process cannot access the file 'bin\Debug\BO.dll' ...
I have been successfully using VS 2005 Beta 2 (VB.NET) for about a month now. Yesterday, I started getting the error: Error 5 Unable to copy file "obj\Debug\BO.dll" to "bin\Debug\BO.dll". The process cannot access the file 'bin\Debug\BO.dll' because it is being used by another process. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\Microsoft.Common.targets 2274 9 This error does not occur the first time I build ...Show All
SQL Server SMO ScriptingOptions.NoCommandTerminator question
I'm trying to get the batch separator to show when I get the script for a SMO object. I see that I can get or set the batch separator using the ServerConnection.BatchSeparator() method. First question: Is the batch separator the same as the command terminator referenced in the ScriptingOptions.NoCommandTerminator (i.e., basically the "GO" statement by default) By default, ScriptingOptions.NoCommandTerminator is set to false, so I ...Show All
Visual Studio Express Editions Creating a MS DOS Prompt
I wold like to know how can I make a C++ program that creates a MS DOS Console, and how can this program send commands to it. Thanks, Komyg They probably need MS-DOS to run older programs ( I have Risk the game on CD that needs MS-DOS to run ) or to just get back to basic C:\ prompt DOS commands. You'll have to download it. XP has command line capability, and although some commands are iden ...Show All
Visual Studio Express Editions SQL Express Silent Install using SQLACCOUNT=”NT AUTHORITY\NetworkService”
SQL Express Silent Install using SQLACCOUNT=”NT AUTHORITY\NetworkService” I cannot get Express to install in a Workgroup environment (member not in a domain) with this setting. My full command line is: sqlexpr.exe /qb ADDLOCAL=ALL SQLBROWSERAUTOSTART=1 SECURITYMODE=SQL SAPWD=express SQLACCOUNT=”NT AUTHORITY\NetworkService” DISABLENETWORKPROTOCOLS=0 I am sure that the sqlk express system instal ...Show All
Windows Forms Datagridview - Esc key pressed on new record - NoNullAllowedException
Hi, I have a form with several related, bound datagridviews. When a new record is added to any of these dgv's starting from empty , then cancelled before it is committed using the esc key, a NoNullAllowedException is raised, with the message 'Column '[my_column]' does not allow nulls.' This is happening when a new row is being cancelled rather than committed. I do not want to change my data structure to accommodate this error and it seems ...Show All
.NET Development out-of-memory exception with plenty of memory to spare
hi all - i've developed a large jagged array object that requires 750mb but managed memory usage reaches 1300 mb. this is a dyamically expanding jagged array that when created uses 450mb of storage space but 600mb of memory. after repeated refreshing of the array elements and expanding of others, 750mb of storage should be used, but GC reports 1300mb of used memory. i have 3gb of memory in the box and i've set the process workingset to 2gb. if i ...Show All
SQL Server Query Results Truncated in SSMS
I'm running a query in SSMS that returns a large result set. The query runs fine without error. However, in the results pane the query results are truncated. I've tried adjusting every option I can find. I think I'm running into a limit on the number of characters displayed in a column in the results pane. I've already bumped up the amount to the max (8192) setting i ...Show All
Visual Studio Extending VS2005
Hi all, I have a custom tool pane to aid in the documenting of our source code, but i have no idea how to read the line where the cursor is at in the editor, i need this to see what Methode or type i have selected.. Could anyone point me in the right direction Greetings Well that makes sense because I put the interface name down wrong. Try searching for IVsCompletionSetBuilder. That will teach me to ...Show All
