Lady_A's Q&A profile
SQL Server Scrpting to genrate surrogate keys
This is the code iam using to get the incremental surrogate keys: Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent 'Declare a variable scoped to class ScriptMain Dim counter As Integer Public Sub New() 'This method gets called only once per execution 'Initialise the variable counter = 1093 End Sub 'This method gets called for each row in the InputBuffer Public Overrides Sub Input_ProcessInputRow(ByVal Row As InputBuffer ) 'Increment the variable counter += 1 'O ...Show All
.NET Development PLEASE SHOW ME THE STEPS TO RUN THIS CODE ON VISUAL STUDIO 2003?
Hi All, Just started learning XMLHTTP. I am trying to run the example code below on an ASP page on IIS server to retrieve a code behind the sourceforge.net recommended reading page. Will someone show me the steps involved in running this code using VISUAL STUDIO 2003 Thanks <html> <head> <title> XMLHTTP Example </title> </head> <body bgcolor="#FFFFFF" text="#000000"> <% dim objXMLHTTP set objXMLHTTP = Server.CreateObject("Microsoft.XMLHTTP") objXMLHTTP.Open "GET", "http://junit.sourceforge.net/", false objXMLHTTP.SetReq ...Show All
.NET Development '\0' in xml string
hi i am reading an xml document from a string which i receive bytewise from the network. the string is assembled out of char like that s\0e\0n\0d\0 for "send" for example. i really don't know how the '\0' came in there, but so far they didn't bother me. but no with an xmldocument they do. if i try to load the string with either document.LoadXml(string) or document.innerXml = string then i get an exception saying "name cannot begin with '.' character, line 1, position 2", so there seems to be a '.' right where the \0 is in the string (so my assumption is that \0 stands for a '.', but i am really not that good at this chara ...Show All
Visual Studio Loading a image into Crystal report using dataset (PUSH MODEL)
I have stored a image in a database as byte[] when i use the pull model and connect directly to the database i can drag and drop the image field into the designer i can see the picture in design time and in runtime. this works ok. But the thing is that i want to use the push model. I make a dataset with the same fields as the table, and when i drag and drop the image field from til dataset i cant see the picture in runtime or design time. The field is a crBlobFieldObject does anyone know how i can push a image into crystal reports using datasets Im using the Crystal Reports v. 9 within visual studio Any help will be ...Show All
Visual C# C# Access
Hey all,thank u very much for your all because of reading my question; I have a big problem about saving data which I typed to textboxes to my database... I need your help, are there anyone can tell us "step by step" the db connection, saving,deleting,sorting,searching with c# etc... peaceforce18@hotmail.com waitin for your help... I must learn it... Thank u very much... there are many samples for ASO.NET with c# take a look ath these URLs http://www.c-sharpcorner.com/Database.asp http://msdn.microsoft.com/library/en-us/vbcon/html/vbconFundamentalDataConceptsInVisualStudioNET.asp frame=true ...Show All
Visual Studio Tools for Office ClickOnce with VSTO - The application is improperly formatted.
Hi, I am trying to deploy a VSTO application using ClickOnce. I am getting the following warning in Visual Studio's Error List. Warning 1 Assembly 'VstoSmartTagDemo.dll.manifest' has mismatched identity 'VstoSmartTagDemo.manifest', expected filename: 'VstoSmartTagDemo.manifest.manifest'. C:\Programme\MSBuild\Microsoft.VisualStudio.OfficeTools.targets 0 0 Note that the status bar displays the message "Publish Succeeded". I notice that a file with an extension of ".manifest.manifest" is not being found. The extension seems a bit unusual, is this expected behaviour When I go the publish location and click on th ...Show All
SQL Server another simple question, please help, thx a lot!
I have some issues for remotely connection a sqlexpress server 2005 with a c# desktop app, in my local network, after I set a port forwarding service for the computer which runs sqlexpress server, I want my c# app connect to the sqlexpress server in another machine under same local network, the connection string is: "server= 62.31.81.210.\SQLEXPRESS,1921; Database='EvoHealthSQLex'; Integrated Security=True" however, that one only work in the sqlexpress server machine, if I try to use it in another machine, i got error 'Login failed for user 'BRISTOL-1\Guest', BRISTOL-1 is the full computer name of sqlexpress server machine, I found ...Show All
Visual C++ Someone knows about hash?
I was asked to develop an endless loop to capture information and display how many times it has been captured. I have tried looking for hash information but it doesn't seem to help at all. Does anyone know how hash works A hash is nothing else than a function that converts some complex information to a smaller result set. A check sum is a kind of hash. A hash can help to find information faster but a hash is no 100% guarantee for identity. Why do you think a hash can help you Just count the number of captutred images and check the time your loop is running. Upon those values you can calculatethe fr ...Show All
Smart Device Development Folder level Security
Can we provide a folder level security on a PDA having Windows Mobile 5.0 version installed on it. Please reply asap. No, no such thing on CE/WM. May be some 3rd party products are available, but I'm not aware of any. Consider using encryption in your application instead. ...Show All
Windows Forms unable to install TaskVision in Windows 2000 Advance Server
i have all the requirements needed including .net and sql server in our windows 2000 advance server but still i cant stall taskvision web services into it! can somebody help me thnx a lot! CHECK FOR A SOLUTION Installing Taskvision on a 2000 server I was having the same issues... could not find ASP user. One of my friend got the solution, ...Show All
SQL Server Bulk Insert from Mapped Network Drive
Hi, I am trying to perform bulk insert using mapped network drive, but getting following error: Server: Msg 4861, Level 16, State 1, Line 1 Could not bulk insert because file ' F:\Download\MVY.b45 ' could not be opened. Operating system error code 5(Access is denied.). F is mapped network drive pointing to my SQL Database Server. While searching, i got the following link but not able to relate with my problem: http://support.microsoft.com/default.aspx scid=kb;en-us;238238 One exe is running on component server [CTom] and copying the data file to mapped drive (i.e. F:\), then bulk insert is trying to insert from that mapped drive. ...Show All
Windows Forms choosing a data provider( design issue)
hi I have a main windows from which connects to an Access database whan it loads up...ie when i create an instance of the class in the form code. I want to change this so that a have another form show up firts with 2 radio buttons to either select an Oledb or an Sql data provider. Upon selecting this will connect to the chosen ...Show All
Windows Forms MDI Child form with webcontrol not showing properly after hiding in MDI scenario
I have a MDI application in which there are child forms with web(Browser) control in it.I programatically hide all the child forms by calling Hide() method. But when I try to make them visible by calling Show() method, the app shows two weird behaviours as follows, 1. The child form is shown as a seperate window on the taskbar and yet it is s ...Show All
SQL Server How to get programatic access to SSIS Service run time pkg monitoring info...?
If running pkg from file system ( not deployed to SQL ), how do you interrogate the DTExec process to get pkg info, similar to the info the SSIS service shows...is this exposed somewhere in the API, to get runtime info for a pkg... Want to expand on what SSIS Service monitoring provides... Thanks in advance... RC There is no management APIs per se. You have to hook into the normal runtime provided services to get event and log information. The execute method allows you to specify an event sink that all event information from a package is sent to. You would have to write that sink and pass ...Show All
Software Development for Windows Vista Where can I download Visual Studio 2005 Beta 2 (builds 50215.44 & .45).
I'm trying to work with the WWF, I've installed several different VS 2005s, team and Pro from MSDN, and I tried unsuccessfully to install from the 'bad' CDs from PDC. Many other folks seem to be working with the right version, so I assume I'm just not looking in the right place. Can someone point me to Visual Studio 2005 Beta 2 (builds 50215.44 & .45) bits , please Try it out online at MSDN Virtual Labs , no install required. Pretty unlikely you'll get a new copy og Beta 2 now that the Visual Studio 2005 launch is on Monday. Regards, Paul ...Show All