Ravenbutterfly's Q&A profile
SQL Server Error while importing Text file using Import Export Wizard
Hi all i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import O peration stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Success) - Prepare ...Show All
SQL Server Debugging a script component task???
How to debug a Script Component task For instance, I’ve got a Input0_ProcessInputRow procedure and I’d like to see what happen when compiler reach this line: dFecha = Left(Row.Column19, 4) & "-" & Mid(Row.Column19, 5, 2) & "-" & Right(Row.Column19, 2) I’ve put a toogle breakpoint there and then saved but when I run the package to ignore at all. This topic has been ...Show All
Visual Studio Express Editions C#.net Form Close event
In VB 6 we have query unload event which is called before form unload event...so by this before closing a form I can chk any criteria...if it satisfies then only It closes the form...else no. So we are restrictly the form close event from occuring ---could I know the similar way in C3.net windows form events. Hi, Were you able to do it thank you, Bhanu. ...Show All
Windows Forms Timer Problem
hi iam having two windows forms , one form is using timer for refreshing, but if i open the other form in front of the first one the second one disappears i want to refresh the first window with timer only if it has the focus pls help Thanks in advance The form has a Focused property. I just did this: namespace WindowsApplication13 { public partial class Form1 : Form { private Timer timer = new Timer ...Show All
SQL Server Access is Denied in Upgrade Advisor
Hi all, I have run the SQL Server 2005 Upgrade Advisor against a default instance of SQL Server 2000 server running on Windows Server 2003. One thing I need to fix before I upgrade is: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED) SVCACCTREQ I'm not sure what this means or what I need to do before I can upgrade. Does anyone have a clue on this one. Thanks, David ...Show All
SQL Server Programatic Fuzzy Lookup
I want to use Fuzzy lookup to search a table for similar matches. I would like to do this from code in Visual C#. How do I do this or can I If I cannot, will this be something available in the future Thanks for the compliment. I have been programming for about 13 years and the last few years have been in .NET. The 2005 version has seen a lot of improvements and changes especially in the SQL Server side of things. We just installed the Be ...Show All
Visual Studio Express Editions Handling SQLException with a DataGridView
I have a bound datagridview that is displaying data from a table with a unique key. If I change an exising value to match another entry and then save I get an SQLexception error. How can I manage this type of error to display a nice dialog message to user I have tried the DataGridView.DataError but this doesnt seem to catch this type of exception (does catch entering a NULL value is this field though ) hi ...Show All
SQL Server try to setup membership with ASP.NET configuration
When I whant the use the new ASP.NET configuration tool (2005) and I want to define a provider I get the following error. You should know that on installation of VS 2005 SQL-Server Express did not install and I installed SQL-Server 2005 (shiped with VS 2005). So now it seems that VS waits for the Express edition. I changed under Tools/Options/Database Tools/Data Connections the SQL Server Instance Name to "MSSQLSERVER" but this does ...Show All
SQL Server Reporting Services: timeout issue
Hi there, I've just developed this big report in RS SQL 2000 that includes 6 subreports (repeated for each item in the database) and that should print some 800 pages. A light version of the report that only queries part of the data (about 10%, for testing purposes) run with success, including all subreports in about 15 minutes. Once I try to test the report with all the data (all subreports and the main report query directly from th ...Show All
Visual C++ load win32 dll dynamically
Hi, I had a win32 dll which i need to load it with the help of LoadLibrary from my client application. i am facing a problem in loading and calling the dll functions. here is the code.. some body please help me. DLL code: win32dll.h #ifndef _WIN32DLL #define _WIN32DLL #include <windows.h> #define DLL_EXPORT __declspec(dllexport) DLL_EXPORT void sayhai(void); #endif Win32dll.c #include "Win32dll.h&qu ...Show All
.NET Development Embed a usercontrol C# .dll into a HTML page
Hello Sir, Thanks for your time. My question is- Can we embed a usercontrol written in C# to a plain HTML page.if yes then how. i want to run this webpage in a TOMCAT v3.2.3 not IIS.when i try the same in IIS, its working perfectly. Below is my code snippet-- kindly correct me and give me a solution ,thank you. Usercontrol code - using System; using System.Collections; using System.ComponentModel; using System.Drawing; using System.Data; ...Show All
Visual C# Code Behind pages for VS C# 2005
Hello, In the class that I was in, double clicking on the .aspx page (in D esign mode)would open a file for the .aspx.cs page. However, when I do a double click in VS C# 2005 on the .aspx page, I get the following inserted into my .aspx page -------------------------------------------------------------- < script runat ="server"> protected void Page_Load( object sender, EventArgs e) { } </ script > ------------------- ...Show All
Windows Forms TreeView in WinForms 2.0 dosen't update itself when nodes are added
Hi everyone, Within a Winform application, a treeview is contained in a User Control and the User Control is then located within a splitview. When the UserControl added some nodes into the Treeview, the treeview is not displaying the added nodes, it just keep displaying the initial node added to it during initallisation. Tried variious method like TreeView.Invalidate() and TreeView.Update(). The code which adds nodes to the treeview is a ...Show All
Windows Forms DataBinding to Textbox
Hi , I have a dataset ds with 2 tables artist --> table1 name artistid artistname collecion - --> table 2name collectionid collectiondate artistid etc.. have created a datarelation dr between artist and collection dr = new datarealtion("artistcollection",ds.tables("artist").columns("artistid"), ds.tables("collection").columns("artistid")) I have a form which displays all collection information which includes the artist name. I can nav ...Show All
.NET Development Type sharing
Is there a way to use type sharing in vs2005 With wsdl.exe i can use /sharetypes switch to do this by specifying the wsdl from where I want to share types. It would be great to have some trick to make vs2005 share all types from all the web references in a project. Crasch No, only wsdl.exe has the capability to use share types. You can use wsdl.exe to generate a single reference.cs for all web references ...Show All
