dotnetboy's Q&A profile

• SQL Server Schema and principals (Sql Server 2005)

  Hello Everyone, There is something we don't understand on SQL Server 2005. We want to grant acces to the login MyUser in the existing database MyDb. We want this login to be known as MyUser in MyDB and being the owner of a new schema named MyUser. Here are the commands we are using: use MyDb go create user MyUser for login MyUser with default_schema = MyUser go create schema MyUser go grant Take ownership on schema::MyUser to My ...Show All

• .NET Development I can't send mail

  I write this code but it doesn't work. It just show "Email didn't send succesfully". I didn't know how to add UserName, Password and Port. Please help me. private void Button1_Click( object sender, System.EventArgs e) { Button1.Enabled = false ; try { System.Web.Mail.MailMessage myMessage = new System.Web.Mail.MailMessage(); myMesage.To = txtDen.Text; myMesage.From = txtTu.Text; myMesage.Subject = tx ...Show All

• SQL Server Enable User Instances in SQL Server

  I'm just starting out and trying to connect to my first database using the following string: Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RFPdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True I get the following error during debug: " Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances ." I've done this on every database ...Show All

• Windows Forms populate datagrid with datareader in vb.net

  hello everybody  iam unable to populate datagrid with datareader object in vb.net i am not interested in using dataset the following code is not working datagrid1.datasource=datareader datagrid1.databind Hi Scott, but I found BinidingSource is part of framework 2.0, Is there any alternative way in 1.1 to achieve the same. -prince ...Show All

• SQL Server Stepping over the line

  I'm running both SQL 2000 and SQL 2005 on the same server. I got this informational message when running a replication job in SQL 2005. It references the SQLAgent of SQL 2000 instance and says it needs to be upgraded to SQL 2005. Log Windows NT (Application) Source SQLAgent$My2000Instance Category Job Engine Event 1073742027 Computer AMWA-011605 Message SubSystem Message - Job 'MyJobRunninginSQL2005' (0xF6BA7BF3BB3EAD42BF281CA1CA3 ...Show All

• Visual Studio Report of User Settings

  Is there a way to get a report of the rights each user has in Visual SourceSafe 6.0   I have an auditor wanting this information.  Is there something out there that tells me how I can read the RIGHTS file The format of rights.dat is not published, it's internal. You can get any information you want about user rights using IVSS automation interface (through IVssUser collection) http://msdn2.mic ...Show All

• Windows Forms Strange Errors in VS.NET

  Have any of you experienced the following error while compiling a windows forms application: The application fails to compile and the errors are on lines numbered  16707566 +/- .  If you click on the error in the task list it doesn't take  ...Show All

• SQL Server T-SQL Catch-all error handling?

  Hi, Is there some equivalent in T-SQL to the notion of having a global try...catch. Basically, I have a stored procedure which evaluates a stack and then inserts the calculated value into another table. However if there are invalid values on the stack such that a calculation cannot be achieved, I just want it to insert null. (In this version). To do this I need to design some logic into the stack evaluating sp that simply catches e.g. invalid d ...Show All

• Visual C++ Interesting little problem

  I have a simple console app using C++/CLI: #include "stdafx.h" using namespace System; enum Values { ONE = 1, TWO = 2, THREE = 3 }; struct Params { public: int n; public: Values v; }; public ref class Foo { public: Params* p; public: Foo() { p = new Params; p->n = 42; p->v = ONE; } public: ~Foo() { delete p; } }; int main(array<System::String ^> ^args) { Foo^ f = gcnew Foo(); return ...Show All

• SQL Server FlatFile Parsing Problem - Urgently Need Assistance!

  We have a BIG problem that has been occurring for quite sometime. We have a RAGGED-RIGHT FFS (FlatFileSource) component which receives a FF and then transforms to XML. We define 10 FIELDS with the last field as {CRLF} per ragged right style. Simple right The source file is sent to us from multiple separate groups, some of which don’t use the last two fields and have early line termination, so they basically are not there. The problem is that wh ...Show All

• Visual Studio Express Editions Handy key-shortcuts

  Know these times when you accedently press a key and something happens i want this thread to be a place where we'll post all of the handy shortcuts on Visual Studio 2005 to ease up our work. so, the first one is F12 - when you place your text marker on a class, and hit F12, it opens a new window, that summerize all the properties/methods of that class. ...Show All

• Visual Basic Writing a .INI file

  Hi, I need help! Okay, a program that I work with uses a setup.ini file that I have to write each time, as a novice VB user I wrote a program to write the .ini file but when it writes it, the program can't read it. The only way it'll work is for me to open it in a text editor then save it. This is what i'm using at the moment to write it as it uses some input from text boxes. Can someone tell me how to succesfully write a .ini file. ...Show All

• Windows Forms Multiple tables data in dataGrid

  I have a dataGrid and my reqirements is that i want to add data in the dataGrid form two tables.Both the tables are in the dataset. How can i display data in the datagrid programatically.I think the  dataGrid.setDataBounding(ds,"Item") would not work&nbs ...Show All

• Windows Forms Menu Items just like MDI form

  Can someone please let me know how to create the menu items on the form just like MDI form Example  file        Report    Exit  Open     Monthly  Save     Weekly are you trying to make  ...Show All

• Windows Forms Data Binding

  Hi,    How should i correct the statements below, so that the ID text box will shows the ID=1 when the arrow of List View point to ID=1 Or is that any other methods to do this IdTextBox.DataBindings.Add("Text", dataset1.Tables["employee"], "ID"); Thanks. You're welcome! Glad I could help (I noticed that I left something out of the code I provided ... I forgot to add the ListViewItem to the ListView ...Show All