Amit Bansal's Q&A profile

• Visual Studio Tools for Office Excel from web data

  Not even sure if I'm in the right place, but here goes. I am trying to get info off a web page that updates every hour. And that I can do, the problem I have is that it erases the old data. I need it to post data every hour, with out losing the previous hour. If you can't help can you tell me where to go to get this answer Nneuromancer , It seems you are not having problems with Excel programming but with general use. I tried the feature you are using but it seems there is not default support for what you are trying to accomplish. This means that you might need to write some code either using VBA (Excel Macros) or writing your own .NET solution. You might want to try the attached l ...Show All

• Windows Forms AddHandler - pass info

  I loop through a number of small images and need a click event on each of them So, I use an AddHandler. For k = 1 To iNumOfImages Dim box As PictureBox = CType ( Me .Controls( "pbImg" & k), PictureBox) AddHandler box.Click, AddressOf DoImageClick Next Private Sub DoImageClick( ByVal sender As System.Object, ByVal e As System.EventArgs) 'What Image Was Clicked End Sub In the DoImageClick, I need to find the name of the item clicked. Or pass a var there. I've looked in the System.Object and the EventArgs extensivelly but found nothing I can use. Suggestions Thanks, Zath The sender parameter will the the contol that ...Show All

• Visual Basic Add any null bytes into file

  I'm creating a Console Application I inserted a "seek" class and i want that it adds 8 bytes null ( 00 ) in the pointer's position. I created a Console APplication, i inserted a StreamReader and StreamWriter Class. And i want also the file that it must have 8 bytes null added come drag in console application's icon and the TOol starts and add 8 bytes null. How can i do I have also another problem, any Console Application that I create closes in 2 seconds so i want to know if there is a good way for quiting ConsoleApplication clicking a Key of the Keyboard. Thanks 2 all. :D Here's an example: Public Function OpenByteWrite(ByVal Filespec As String, ByVal Mode As System.IO. ...Show All

• SQL Server Questions on backup and report services

  Hi, I am thinking of using SQL and VB express for a project. Reading different versions information lead me to the following understanding on bakups and report services. Please comfirm my understanding or correct me if I am wrong. Any suggestion is always welcome. 1. SQL express does not include Agent Job Service so I cannot schedule a backup job or daily report to run automatically at a specific time. Is there a work around on this 2. If I install the SQL express with the Advance Services edition, I still have to install the express tool kit to get the business intelligence developer studio in order to generate the reports. Do I have to install both on the same machine (the server) or the advance edition on the server and the too ...Show All

• Software Development for Windows Vista Bug!? global transaction with SQL Server connection + TransactionCompleted event

  This is an example of a problematic behavior that we encountered during trying to trigger an action after a successful database commit. It took a while to find characterize the behavior and to bring it down to an example like this. I am pretty sure it is a bug! Just to outline the global scenario: The application has several objects which may open a database connection and select or manipulate data. As some of the calls are expensive the data should be cached in a cache. On database updates the cache should of course be synchronized so an obvious idea is to have objects which manipulate such cached data to hook up to the TransactionCompleted event and check for the transaction outcome to do something. Another idea is to use e.g. Juval L ...Show All

• Visual Studio Express Editions my web appliation don't run in the windows server 2003?

  Hello everyone: I have a web application,it is not runing in the windows server 2003.when you click the button in the webform,the webform have no action.when i remove the validating control ,the application is runing good at the windows server 2003 i don't want to remove the all validating controls .my application is written by vb.net 2003 in windows xp. please help me. marcyduan, Thank you for your question, Mr Duan. Actually your problem always happens in the IIS when using the .NET Framework. I checkd your IP address is Beijing while I am working in Shanghai, a Chinese, too. :-) I suggest you to write the posts in English because it is known that in many other countries, Chinese Character (Han Zi) cannot be ...Show All

• SQL Server Unable to set Default Schema for a group

  We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a problem with our SQL Server installation Updated on 2005/08/29 My first try was done at through Database\Security\Users.  I tried going through Server\Security\Logins and I got this error message    Alter failed for User 'Domain\Group'. (Microsoft.SqlServer.SMO)   Additional Information:   --> An exception occured while ...Show All

• Windows Forms select distinct

  Hello, i hope someone could assist me... i could display my data by datagridveiw but found that there're some duplicated rows. how could i implement "select distinct" DML or same function working with datagridview but no DB existed. there're six columns on my datagridview, some lines(rows) are the same... msgsender msgreceiver subject date size msgid thanks in advance Richard Check out these kb articles on how to implement DataSet Select Distinct in VB or C# ...Show All

• SQL Server Invoice Detail

  Hi I have a invoice that displays the company name in a rectangle on top then it has a list in the list it has details tables my problem is that the invoice detail goes on the next page I need to have the company name as well on the second page I cant put it in the same table as the detail because I have a few tables in the detail so it is actually no header is it possible to have Repeated the Company name information on the next page Thanks A bit of a hack, but how about just creating another rectangle with visibility property =IIF(Globals!PageNumber.Value > 2) Not sure if that will work though since the body does not know about page numbers. Did you try Chris Hays's fix http:// ...Show All

• Visual Studio Express Editions text box to end of URL and open in new window

  I have a text box that I would like to have the user enter a stock symbol, click a botton and get the stock quote. I think the best way to do this to have what they typed pasted at the end of http://moneycentral.msn.com/detail/stock_quote Symbol = then open in a new window. It would be better if I could getthe quote displayed on in the program, but I'm sure that's far to complicated for me. I'm just starting here, (obviously), so any help would be appreciated greatly. Put a WebBrowser control on the form. In the button's Click event handler, call WebBrowser1.Navigate("http://..." + TextBox1.Text). ...Show All

• Visual C# Newbie Question: creating GIF images from c#

  all, I am new to graphics programming in c# and am looking for a tutorial that will take me from creation of a graphic through exporting it as a gif (or jpeg). I have kind of figured out the creation of the graphic using System.Drawing but am not sure where to go from here. Anyone solved this problem before Many thanks in advance. Kevin Jeff, Thank you, this is exactly what I needed. One other question, does it work with system.drawing objects as well Thanks again, Kevin ...Show All

• SQL Server Layout problem

  Layout problem - I've created a report with the wizard and it looks fine. It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table. Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is. I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header. Can anybody help me with the title part to make it visible in all pages Thank alo ...Show All

• SQL Server SQL Server 2005 - Log Shipping - Missing sp_change_primary_role and sp_change_secondary_role

  I have installed SQL Server 2005 and setup a cluster and log shipping. I decided to perform a planned failover and realized that there are no sp_change_primary_role and sp_change_secondary_role stored procedures. I checked on both the SQL Server 2005 installations and could not find them. My question is : "Is it safe to get these stored procedures from a SQL Server 2000 database and run them on the SQL Server 2005 database " "Has anyone come across such missing stored procedures in SQL Server 2005 and know the reason why it is so (so that I can avoid it in the future if it due to a faulty installation) " Cheers NEVILLE GEORGE In SQL 2005 BOL, there is a topic on changing r ...Show All

• Visual Studio 2008 (Pre-release) Can't use attached properties inside a DataTemplate

  I have the following DataTemplate defined, and I'm trying to set the "Offset" attached property that is found on my SlotItemPanel: <DataTemplate DataType="{x:Type tll:TimelineEvent}"> <StackPanel Orientation="Horizontal" HorizontalAlignment="Left" Background="BlanchedAlmond" tlc:SlotItemPanel.Offset="25" > <Rectangle Width="{Binding DatePixelRange}" Height="10" Fill="Red" Margin="10 0 10 0" RadiusX="10" RadiusY="10" /> <TextBlock Text="{Binding DateAsString}" VerticalAlignment="Center" FontStyle="Italic" FontSize="12 ...Show All

• SQL Server Exception from HRESULT: 0x800A0BCD

  Exception from HRESULT: 0x800A0BCD This is the error comes when I try to Browse cube from SSMS or SSBIDS. This type of error may come for other issues and reinstalling OWC may be fix but in my case it didn't worked. I have a cube in that all my measures are visible = false because I create calculated members in linked cube using measures of that cube and don't want to show underline measures to users. When I tried to Browse cube whose all measures are visible = false I got this error. I understand why should I browse that cube when there is no measures visible but that was by mistake and I got this error. To make it more clear based on my case If you have a cube and all measures are visible = false and if you try to Brows ...Show All