Tok Bek's Q&A profile

• SQL Server Insert/update/delete Transaction

  Hi, I have an unbound DataGridView and I have load it with a set of records from a Data base. I modify existing rows, delete rows and add new rows to DataGridView control. I have to send a new modified dataset back to the data base. Please any suggestions how to solve the problem Thanks in advance George Hi George, I think you'll have more success posting your question on the Visual Studio forums - this is the T-SQL forum which is primarily used for back-end SQL questions, rather than user interface coding problems like DataGridViews. Hope that helps :) Menthos ...Show All

• Smart Device Development Serial Port Communication

  Hallo, I wrote a little prog, which sends a message and the messages md5 over the serial port: I'm using Visual Studio 2005.NET, PocketPc-Emulator and a virtual serialport-driver. This way I connected the emulator to COM2 and COM2 to COM15. So I can send and receive Data via the emulator on COM2 and via Win32-Application on COM15. For testing I write all incoming Data on the emulator to the serial output. Private Function com_sendString(ByVal toSend As String) As Boolean Dim hash As String hash = "##HASH:" & md5(toSend) & "##" Try If (serialPort.IsOpen = True) Then serialPort.WriteLine(toSend & hash) Else MsgBox("Port is closed!!") En ...Show All

• SQL Server Report Designer Question

  How to Add the Report Designer in my Application ...Show All

• Visual Studio Express Editions How can i Do transaction while using a dataset?

  hi guys.. im Doing a Simple Inventory Application Which Data entry might be handle by quite a few people so there will be error in database. i used dataset. i initialise my dataset on my main form Public Sub LoadData() connInventory = New Odbc.OdbcConnection(constr) DaLogin = New Odbc.OdbcDataAdapter( "Select * From Login" , connInventory) CbLogin = New Odbc.OdbcCommandBuilder(DaLogin) daWareHouseTable = New Odbc.OdbcDataAdapter( "Select * From WareHouseTable Order by WareHouseID" , connInventory) cbWareHouseTable = New Odbc.OdbcCommandBuilder(daWareHouseTable) dalocationMaster = New Odbc.OdbcDataAdapter( "Select * From locationMaster Order by LocationID&quo ...Show All

• Visual Basic VB.NET & EMAIL

  I am trying to figure out, for a friend, how to write a VB program that will launch multiple IE's and when those IE's launch fill in the appropriate login name and password for that site. Is there any way that this can be done How does this seem shady My friend has like 5 email addresses and he wants to automate it and be able to carry the .exe on his flash drive and check his mail from any computer with one click. ...Show All

• SQL Server Does tablesize affect performence on an indexed table?

  I'm facing a design choise. I'm about to create a table that will hold reading values from temperature meters. It'll need to hold about 1,5 billion records. The number of columns will be fairly limited, someting like: ID - bigint (PK) MeterID - bigint (referense to the temp meter) Temp - real (the temperature) Time - datetime (the time of the reading) Most of the select querys will look sililiar to SELECT ID, MeterID, Temp, Time FROM TempReadings WHERE Time > X AND Time < Y The time column (and probably others to) will have indexes. Meter readings from 20 years back will be stored. I've been thinking of two alternatives here. 1 - Save all readings in one table 2 - Have two tables. One for the first year and one for year 2-20. R ...Show All

• Gadgets Dynamic content from my personal site.

  Are there any good tutorials on doing this I want a small icon of my site on the side bar that when clicked opens in a window that lists recent activity on message boards and other dynamic content from my sites DB... Amature here so bare with my ignorance..:) Thanks in advance... Chris I can't tell for sure what you want, but it sounds like you want a sidebar gadget, here is the link for that forum http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=1063&SiteID=1 ...Show All

• Visual Studio Tools for Office Working with Headers

  Using VSTO in VS.net 2005.  I would like to include a picture in my MS Word 2003 header.  The picture I would like to insert at runtime will depend on an action selected by the user in a smart tag ("Insert Logo").  I would like to just include the possible pictures in the same directory with the application add-in, and refer to the paths at run time. So far I have had problems getting the header pane to close, and figuring out how to insert a picture from a file.  This is the first page header code I started with: Private Sub AddHeaderPic() Dim i as integer i=1 ' for first section For i = i to 1 Globals.ThisDocument.Section(i).Headers(Word.WDHeaderFooterIndex.wdHeaderFooterFirstPage) _  .Range.Sel ...Show All

• Microsoft ISV Community Center Forums InsertDatabase is returning error "Word was unable to open the data source"

  The code I'm trying to use is below. It is taken from MS help for InsertDatabase Method. But seems I must have missed something. In the code, "wd" is "Word.Application", the SourceFilePath has the path and name of an Excel spreedsheet (.xls). I also have a comma delimited text file in the same folder as this Excel spreadsheet. The only difference in their names is the .xls and .txt. The text file works, except that a dialog box opens asking what the delimiter is between fields. But the Excel file just gives the error, "Word was unable to open the data source". HELP!!!! Please. With wd.Selection.Range .Collapse Direction:=wdCollapseEnd .InsertDatabase _ LinkToSource:=False, DataSource:=SourceFile ...Show All

• Visual C++ How to restore old source file

  I've modified the source file a lot, as VS save the source file automatically when compiling, how can I restore the original source file pressing undo button to rollback all previous typing is not fun. Thanks. VS 2005 Professional comes with Visual SourceSafe. You can install that and will find a new Source Control submenu in the File menu. You can then add your projects to a source safe database. Now you must checkout files before you use them and when you check them in again, SourceSafe will keep a history. So you could rollback to all previously checked in versions. -- SvenC ...Show All

• SQL Server page number & records number

  1. how to show page number & total page number in report body 2. how to show total records number I'll see if there is anything I can come up with! If anyone else has any ideas or thoughts, feel free to share! I just do not understand why SSRS should not allow us to use pagenumbering in the data. It doesn't seem to make much sense to me. Thanks, Curtis ...Show All

• Visual C++ stdio.h errors in Visual Studio 2005

  I just finished installing VS 2005 (is it that hard for microsoft to just let people download like, a zip file of it, rather than an img file, which i had no idea what to do with at first ) and tried the following code: #include <stdio.h>    // include the standard input/output header file void main(void)    // our program starts here {     printf("Hello World!");    // print "Hello World!" into the console     return;    // return void to windows } It was part of an origionally blank win32 console app called test.  When i tried building the solution or compiling the file separately, I got all those errors: ------ Build started: Project: Test, Configuration: De ...Show All

• .NET Development where should i find information on interregating the system clock?

  Hi i'm new to the .NET and wonder if anyone could point me in the best direction for any information on how to go about interrogating the system clock. I am trying to create a prototype host based intrusion detection system. I'm also not sure in which language this would be best achieved. Many thanks Yes that certainly gives me somewhere to start. I'll give it a go and get back to you. Thanks for the quick reply. ...Show All

• Windows Forms Connection String

  I'd like my app. to connect to the DB in the folder that will be in the user's computer when I install it. I don't want to have to change my connection string path everytime I install my app. on a new computer. Using ADO.NET, how do I make my app. to connect to the DB everytime it's run regardless of the app.'s location eg: Dim csWBoard As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Projects\Whiteboard\WhiteboardDB.mdb" Will the above code work If not, what will This may sound stupid but, how do I go about doing that And maybe I should ask my question in a different manner: How do I make sure that when I install my app. on a new computer, the DB is installed automat ...Show All

• Visual Studio Tools for Office Fix for VSTO 2005 performance problems when using transparent proxies.

  After some study of the memory performance problems in VSTO 2005 when using transparent proxies I have discovered a bug in the class Microsoft.Office.Tools.Excel.TypeResolver. Here is the decompiled code of the static method GetTypeResolver from that class. Private Shared Function GetTypeResolver(ByVal typeLib As TYPELIBATTR ) As TypeResolver Dim resolver1 As TypeResolver = Nothing If TypeResolver . cached . TryGetValue (typeLib, resolver1) Then Return resolver1 End If If TypeResolver . ShouldWrapTypes (typeLib) Then Dim assembly1 As Assembly = TypeResolver . GetPiaOfTypeLib (typeLib) If (assembly1 Is Nothing) Then Return TypeResolver . Empty En ...Show All