LINQ with SQL Server

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ VB
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
 - 1
 - Is Visual Studio 2008 for developer released I want to know if VS 2008 released or not. If not then when we should expect it. Thanks, Mire Tag: LINQ with SQL Server Tag: 407163
 - 2
 - Help with slow running XL Automation Code I have this code that takes ~3 Mins to run while automating an XL Instance (XL 2003). There are 558 Rows and 15 Columns in rngSelection. So it is adding Named ranges on 8,000+ Cells. Is this just as good as it's going to get? Imports Excel = Microsoft.Office.Interop.Excel <<Snip>> With XL .Application.Calculation = Excel.XlCalculation.xlCalculationManual .Application.ScreenUpdating = False <<Snip>> Dim rngSelection As Excel.Range = CType(.Range("A1").CurrentRegion, Excel.Range) .Range("B3").Select() For iRow = 2 To CShort(rngSelection.Rows.Count) For iColumn = 2 To CShort(rngSelection.Columns.Count) .ActiveWorkbook.Names.Add(Name:="_" _ & Trim(Replace(CType(.ActiveCell.Value, String), "-", "_")) & "_" _ & CType(.Range("O2").Offset(0, - rngSelection.Columns.Count + iColumn + 1).Value, String) _ , RefersToR1C1:=.ActiveCell.Offset(0, iColumn - 1)) Next iColumn .ActiveCell.Offset(1, 0).Select() Next iRow <<Snip>> Tag: LINQ with SQL Server Tag: 407162
 - 3
 - How to make common connection string for diff program? Hi i have a problem where as i want to use two different C# net program in a single system where i have used 2 different sql server name. when i execute those program each time iam renaming the sql server name and executing the programs. Is there any way where i can write a connection string without using a sql server name or is there any other possibility to solve this problem. [Note : i don't want to use the same sql serve name for both the programs.] Tag: LINQ with SQL Server Tag: 407152
 - 4
 - Reporting options question I have an app( vb .net 2.0) that I am about to get into the reporting portion, the app has an access 2007 db, and have logo file stored in a directory on the computer (to save space in the database). I want to be able to show the logos at the top of the report. Depending on the options selected I want to be able to color code the report (text, boxes and linesâ?¦). IT seems that I have to reports to choose from, Crystal, vb built in reporting, last was to make my own. I need to be able to customize the report for color code print logos on the report. What do you all think on the options of doing: Crystal report â?? doesnâ??t seem like I can dynamically change a picture objection the report and I keep running into logon error. Vb built in report â?? it doesnâ??t seem as easy to customize an in vb6, I canâ??t seem to write any code and use my on connection string with data sets. Building my own report â?? I am just wandering if it is work building your own reports, making a form to show the data, then having to print or print preview it. I am kind of at a decision point and wanted to see what some of you thought or have experience with some of the options? Tag: LINQ with SQL Server Tag: 407150
 - 5
 - Timeouts when getting picture from network camera I am performing the following bass tasks to get an image from a network camera: Dim WebRequest As WebRequest Dim newpic As Image Command = "http://192.168.0.200/jpg/image.jpg" WebRequest = System.Net.WebRequest.Create(Command) WebRequest.Timeout = 5000 Dim webresponse As System.Net.WebResponse webresponse = WebRequest.GetResponse() Dim respStream As System.IO.Stream = webresponse.GetResponseStream() newpic = Image.FromStream(respStream) My problem is that occasionally it hangs on the last line when trying to get the actual stream. Whilst you can specify a timeout for WebRequest, there is no timeout for WebResponse or respStream. As a result the process hangs for 5 minutes (which seems to be the default timeout) Is there any way round this? Should I be doing this a different way? -Jerry Tag: LINQ with SQL Server Tag: 407147
 - 6
 - Polling Another App Hi, I've got two applications. The job of the second application is to make sure that the first application is running; if it's not, it relaunches it. Is there a good code snippet that somebody can point me to that would accomplish this? Regards, Scott Tag: LINQ with SQL Server Tag: 407142
 - 7
 - NotifyIcon Confusion Hello, I am a little confused over the behavior of a form with a NotifyIcon. The property ShowInTasbar of the form is set to false. The NotifyIcon does have an Icon set. When I minimize the form, the Icon appears in the system tray as expected. But, when I click on the icon the first time, the form restores to a small window just above the Taskbar as if it had been minimized. A second mouse click on the Icon restores the form in its full glory. The code below is complete. I created this simple test application just to test the NotifyIcon behavior. The behavior I would like is as follows. 1. Not visible in the Taskbar 2. Minimize hides the form. 3. An attempt to Close the form without password hides the form. 4. Click on the Icon restores the Form to previous location. Public Class formTest Private Sub formTest_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing If TextBox1.Text = "PASS" Then e.Cancel = False Else e.Cancel = True Me.WindowState = FormWindowState.Minimized End If End Sub Private Sub formTest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load NotifyIconX.Text = "Just_A_Icon :" & vbCr & "Double Click to Activate." End Sub Private Sub formTest_Resize(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Resize If Me.WindowState = FormWindowState.Minimized Then Hide() End If If Me.WindowState = FormWindowState.Maximized Then Debug.Print("Showing") Me.WindowState = FormWindowState.Normal Show() End If End Sub Private Sub NotifyIconX_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles NotifyIconX.Click Me.WindowState = FormWindowState.Normal Show() End Sub End Class Thanks, Tag: LINQ with SQL Server Tag: 407139
 - 8
 - Cannot Reference Parent variables from a MDI Child Form Hi everyone Some help pls. 1. MDI Parent Form Have a variable Public TestVariable As String = "AAA" In the Load procedure TestVariable = "BBB" 2. MDI Child Form Do a debug.print (TestVariable) and displays "AAA" If I hold my cursor over TestVariable in the IDE it displays "BBB" I do not see how I can reference the current value in TestVariable of "BBB" in my code The real reason for this is that I am in 1 MDI child form and I want to determine if another MDI Child form is active I want to get the value MDIParentForm.MdiChildren.Length so I can manipulate the forms to determine if the form I am concerned with is not open. When I reference MDIParentForm.MdiChildren.Length from the MDI Child in the coder it always shows 0 (Zero) When I hold my cursor over MDIParentForm.MdiChildren.Length in the IDE it displays 3 which is the correct number of MDI Child forms that are open. Totally confusing thanks sandy Tag: LINQ with SQL Server Tag: 407138
 - 9
 - Visual Basic/Visual Studio 2008 Embedded SQL What is the easiest (as most like simple embedded SQL) to declare and open/then process a cursor in Visual Basic/Visual Studio 2008? I wish it were as simple as it was in MF Cobol or C and its flavors where your could just use EXEC SQL .......... END EXEC. Tag: LINQ with SQL Server Tag: 407136
 - 10
 - simple FTP app? I would like to create a simple FTP application, a program to take files from: \\server\share take all *.jpg files and move them to an outside ftp server for example: ftp.add.ress.here\data\ and then I would like to actually put files into a dated folder...for example: 20080311 and if the folder does not exist, create it, this would be based on the current date. so for example if I run this on 03/10/2008 i would like it to create a folder based on the date plus one day 20080311 any ideas? Tag: LINQ with SQL Server Tag: 407134
 - 11
 - Long latency when creating a new FileStream... Using VS2005, VB.NET, I have a multi-threaded application. In one of my threads I need to read a file as a binary stream. I am able to accomplish this using the following code: 1 Dim BinaryFile As FileStream = New FileStream(<some file name>, FileMode.Open, FileAccess.Read, FileShare.Read) 2 Dim BinRead As BinaryReader = Nothing 3 Me.BinRead = New BinaryReader(BinaryFile) 4 Me.BinRead.BaseStream.Seek(0, SeekOrigin.Begin) 5 Me.BinBytes = Me.BinRead.ReadBytes(<number of bytes to read>) The code above works for me save one issue: on the first execution, line 1 takes a really long time (4-7 seconds) to execute and don't have any idea why. Anyone have an idea what could be causing this latency and how to avoid it? Thanks for your attention to this... Tag: LINQ with SQL Server Tag: 407130
 - 12
 - flash botton asp All, I try to flash button whenever status is true ( that means to trigger button flash) in asp web application. Anyone knows how? Thanks in advance, Martin Tag: LINQ with SQL Server Tag: 407125
 - 13
 - Arraylist I have a tmpValues as New Arraylist When Iget to this code: If tmpValues.Contains("..") Then MessageBox.Show("This is not a number") exit sub End If When I put a watch on the tmpvalues and open it up I see the Items (0) System.windows.form.label then all the properties of the label including the .text fields which has the ..3 in it. Why don't it go into the messagebox statement ("This is not a number")? Can anyone help ASAP Thanks Tag: LINQ with SQL Server Tag: 407120
 - 14
 - Max Cursor error using Oracle Hello, Does anyone have a good solution to close cursors when using Oracle 9 with VB.NET. I have tried disposing of the command object, the data adapter and increasing the OPEN_CURSORS variable to a higher number still nothing consistently works. When too many cursors are opened, I receive the max cursor error. Any suggestions would be greatly appreciated! Thanks, Scott We are currently using .NET 1.1 and Oracle 9. Tag: LINQ with SQL Server Tag: 407118
 - 15
 - Late Binding Problem - Need Help Hi, I have this block of old code: Private Sub txtBoxes_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) _ Handles txtQL12.DragDrop, txtQL11.DragDrop, txtQL10.DragDrop, txtQL09.DragDrop, _ txtQL08.DragDrop, txtQL07.DragDrop, txtQL06.DragDrop, txtQL05.DragDrop, _ txtQL04.DragDrop, txtQL03.DragDrop, txtQL02.DragDrop, txtQL01.DragDrop, _ txtV01.DragDrop, txtV02.DragDrop, txtV03.DragDrop, txtV04.DragDrop, _ txtV05.DragDrop, txtV06.DragDrop, txtV07.DragDrop, txtV08.DragDrop, _ txtV09.DragDrop, txtV10.DragDrop, txtV11.DragDrop, txtV12.DragDrop, _ txtV13.DragDrop, txtV14.DragDrop, txtV15.DragDrop, txtV16.DragDrop, _ txtV17.DragDrop, txtV18.DragDrop, txtV19.DragDrop, txtV20.DragDrop, _ txtQuoteValidFrom.DragDrop sender.Text += e.Data.GetData(DataFormats.Text).ToString End Sub I am converting my application so that it runs with Option Strict on and the compiler complains about the late binding being used here (sender.text), can anyone recommend a neat way of handling this without having to write an individual event procedure for each of these text boxes that will avoid the late binding issue. I have pondered it for a while and can't think of a way of doing it that will not hit the same late binding issue. Thanks for your help. Siv Martley, Near Worcester, UK. Tag: LINQ with SQL Server Tag: 407105
 - 16
 - Background Worker Cross Thread UI problem I am using the BackgroundWorker in VB2005. I understand the problems of updating a form from a thread, and this can normally be overcome by doing the updating on the ProgressChanged Event. As I understand it, this event will operate on the thread that invoked the original RunWorkerAsync (which may not be the UI thread). I have a thread, which calls another thread and it is in this thread that I need to update the form. I have read much about call backs and delegates but this seems to refer to life before the BackGroundWorker was introduced (whch I thought did away with all this). What is the best way for me to update the form in the above circumstances? -Jerry Tag: LINQ with SQL Server Tag: 407104
 - 17
 - Generate and send outlook appointments/meeting requests Hi Guys, I have a vb.net ASP.NET based application, the want the user to have an option to send himself a reminder via the application. All seems good butqhen the mail is received bythe outlook user, it is not in a proper request format and the user does not have the option to "accept" etc.. What he gets is a simple text message as below: Start: 3/10/2008 22:58:00 End: 3/10/2008 22:58:00 Location: Phone/Email Details: CUSTOMER: - () --------------------------------------------------------------- does this work? at all? let's see.... PHONE: MOBILE: EMAIL: I have all the properties for the reminder and the following code: Public Sub SendOutlookAppointment() Try Dim oApp As Outlook.Application = New Outlook.Application ' Create a new AppointmentItem. Dim oAppt As Outlook.AppointmentItem = oApp.CreateItem(Outlook.OlItemType.olAppointmentItem) 'oAppt.Display(true) 'Modal ' Set some common properties. oAppt.Subject = "Subject...." oAppt.Body = "CUSTOMER: " & CurrentCust.cust_id & " - " & CurrentCust.cust_fname & " " & CurrentCust.cust_lname & " (" & CurrentCust.cust_company & ")" oAppt.Location = "Phone/Email" oAppt.Start = Convert.ToDateTime(calRemind.SelectedDate) oAppt.End = Convert.ToDateTime(calRemind.SelectedDate) oAppt.ReminderSet = True oAppt.ReminderMinutesBeforeStart = 15 oAppt.BusyStatus = Outlook.OlBusyStatus.olBusy ' olBusy oAppt.IsOnlineMeeting = False ' Display. 'oAppt.Display(true) 'get rep info Dim rRep As Rep = RepDB.GetRep(ddlRepRemind.SelectedItem.Value) 'create the mail message Dim mail As New Mail.MailMessage() 'set the addresses mail.From = New Mail.MailAddress("Reminders@solarpathusa.com") mail.To.Add(rRep.rep_email) 'MsgBox(oAppt.Subject.ToString) 'mail.Subject = oAppt.Subject.ToString mail.Body = "Start: " & oAppt.Start & vbCrLf & _ "End: " & oAppt.End & vbCrLf & _ "Location: " & oAppt.Location & vbCrLf & _ "Details: " & vbCrLf & oAppt.Body & ControlChars.Lf & "MSPBot Ver. " & sVer 'send the message Dim smtp As New Mail.SmtpClient(sSMTPServer) smtp.Credentials = New System.Net.NetworkCredential(sSMTPUser, sSMTPPass) smtp.Send(mail) oAppt = Nothing Catch ex As Exception ErrorLogger.HandleEx(ex) End Try End Sub I want to use regular sendmail to send the reminder since I may not have outlook on the server the application is running on. Any ideas? Thanks! Tag: LINQ with SQL Server Tag: 407094
 - 18
 - Set Output window as default? When ever I run a project the windows that open at the bottom always default to autos and command window... I REALLY want the default to be autos and output, is there anyway to set it like this? It use to be like that in past versions.. but in recent versions it's defaultint to command... and it I set it to output before i run the project it switches right back to command... and is annoying as heck... how can I change the default window that shows? Thanks! I have VS2008 now but this happened since VS2005... VS2003 didn't do this for me.... Tag: LINQ with SQL Server Tag: 407081
 - 19
 - Post-build event I have a solution that contains a bunch of VB.Net 2005 projects. After I build the solution I want to run a batch file if any of the projects created new output files. I know how to set up an individual project to execute a post-build event if the project created new output files, but how do I do the same thing at the solution level, taking into account whether or not *any* of the projects created new output files? TIA - Bob Tag: LINQ with SQL Server Tag: 407079
 - 20
 - www.dotnetvideos.net releases 10 New Videos on Data Tutorials Hi all, www.dotnetvideos.net released 10 new videos on the following categories. every registered user of this site still gets a FREE subscription to asp.netPRO magazine. chek it out!! An Overview of Editing and Deleting Data in the DataList (7 Videos) at http://www.dotnetvideos.net/OverviewofEditingDeletinginDList/tabid/127/Default.aspx Performing Batch Updates (3 Videos) at http://www.dotnetvideos.net/PerformingBatchUpdates/tabid/128/Default.aspx ---venkat Tag: LINQ with SQL Server Tag: 407072
 - 21
 - How to change system clock on a remote computer? What I want to do is: 1, Get time from nist 2, Sync my system time with nist time 3, Sync all computers in the local network with my system. I did 1 and 2, but no ideas how to implement 3, can anyone give me some suggestions? Thanks. Quinn Tag: LINQ with SQL Server Tag: 407066
 - 22
 - the return of VB? hey I just wanted to send a quick shout out-- I saw in the MSDN magazine the other day.. that said that VB Is more popular than C#.. I wanted to see if anyone had more information about this? I also had to say a quick thanks to everyone; VB 2008 _ROCKS_ compared to VB 2005.. And the VB family is again finally competitive with MS Access in developing small quick apps. Just had to say thanks to the whole team for helping to get this done! -Aaron Kempf Tag: LINQ with SQL Server Tag: 407065
 - 23
 - where is the real VB group? hey I went to Microsoft.Public.VB today and google says You cannot post messages because this group is only available as an archive. I'd like to know where the real VB newsgroup is? I surely don't really write VB.net for the most of the stuff i do.. I do use Vb 2005 for some things and Vb 2008 for some things.. But I mainly write VB in Outlook, Access, Excel, Word and Visio.. I just don't know where I can go to ask questions. Thanks -Aaron Tag: LINQ with SQL Server Tag: 407063
 - 24
 - ICollection(Of T) interface - Contains() method Hi. I have the class below that implements the ICollection(Of Object). My problem is that I can't seem to build an efficient Contains() method. My Contins() method logic requires an exception in order to identify that an item doesn't exist. Is there a better way to program this so I don't have to catch an exception? Thanks. Public MustInherit Class AbstractCol Implements ICollection(Of Object) Protected _Collection as Collection Public Function Contains(ByVal item as Object) Boolean Implements System.Collection.Generic.ICollection(Of Object).Contains Try If Not _Col.Items(item) Is Nothing Then Return True ' you would think the above Is Nothing check would prevent an exception but it doesn't Catch ' This happens if the item doesn't exist. Return False End Try End Sub End Class Tag: LINQ with SQL Server Tag: 407062
 - 25
 - Deserialize Soap Formatted object from string I serialized an object perfectly fine to SOAP and have it stored in a database as a string (sql server 2005 in a XML data type field) now I am pulling that value back and want to de-serialize it using the soap formatter's deserialize method... but it takes a stream.. .what is the best way to take this value and deserialize it back? How do I create the stream to deserialize it? I have it as a text string in the program right now holding the SOAP XML. Thanks! Tag: LINQ with SQL Server Tag: 407051
- Next
 - 1
 - RichTextBox.RTF not updating properly? Please help!! Hello, I have a little form that people can fill out to generate CD labels from an RTF template. The template basically contains variables that are replaced by the text typed into the form. I also have a "Preview" tab which will show a RichTextBoxcontaining the output of the label generator (ie. the template, with the variables replaced). I am able to load the template into a RichTextBox without problems. This gives me a RichTextBox containing a CD label with words like %MIDDLE-LEFT% and the other variables. Then I have the code below, which replaces the text with whatever is in the user-edited textboxes (eg. txtMiddleLeft.Text): [code] txt_Preview.Rtf = templateRTFText // this works fine tmpVar = Replace(templateRTFText, "%MIDDLE-LEFT%", txtMiddleLeft.Text, , , CompareMethod.Text) // this works fine txt_Preview.Rtf = "" // this works fine! txt_Preview.Rtf = tmpVar // this does not work! [/code] This does not work. The variable tmpVar ends up with the correct, updated data (I checked by copying it to the clipboard and pasting it into a new RTF file- the variables were replaced). But the RichTextBox still contains the template text. If I copy txt_Preview.Rtf to the clipboard, it still contains the template data. No errors are generated when I run the last line. Can someone please help me! How should I be accomplishing this? Note that I am not using PrintPreviewDialog because I need this to appear inside an existing tab, and I also have not been able to get PrintPreviewDialog to work properly (I have limited time for this project). Thank you. Tag: LINQ with SQL Server Tag: 407050
 - 2
 - Custom Serialization - Soap Format Hi, I'm learing Custom Serialization. I've came across a situation where i need help from you expert people. I've created "class A" and "class B" with implementation of ISerializable. I've added a List<Class B> into "Class A". While serializing the List object I casted it into an Class B[] array and it got serialized successfully. Now, I've problem retrieving data, i mean : while Deserializing Serialized data into the object; I'm getting Class B[] array object count but each object is null. for e.g. Class A.Class B.Add(new class B()); Class A.Class B.Add(new class B()); Class A.Class B.Add(new class B()); after serialization when i tried to deserialize it: Class A.Class B.Count = 3 Class A.Class B[0] is null Class A.Class B[1] is null Class A.Class B[2] is null thought class B as implemented ISerializable; it is not getting deserialized. While debugging i found that when u call Serializing method on Class A object (Class A.Serialize()); class B object also get serialized. but when u call Class A.DeSerialize(); somehow Class B doesnt Deserialized. if anyone know what i'm missing here; it would be great help. Thanks, Tag: LINQ with SQL Server Tag: 407049
 - 3
 - Reporting Engines Hey All, Does anyone know of any good reporting engines for .NET? We're currently evaluating Telerik, Reporting Services and Crystal Reports. We need to be able to have multiple input/output formats, drilldown capabilities and it needs to be easy for us and our users to create reports. Any input that anyone has would be appreciated. tia Todd Tag: LINQ with SQL Server Tag: 407044
 - 4
 - How to access MySettings from a DLL? Hi, I have a vb.net solution created in Studio 2008 running on .Net 2.0. The solution contains 2 projects, a main Windows app and a business logic project that compiles to a separate DLL. In the main app I have used MyProject.Settings to setup connection strings etc... but I can't access these config keys from the business logic project (DLL). Does anyone know how to get my business logic project to 'see' the MyProject.Settings keys from the main application? -- Rich http://www.badangling.com ...talking pollocks since 1996 Tag: LINQ with SQL Server Tag: 407043
 - 5
 - CodeDom and Addressof Hi everyone! Is there a way to generate the Addressof keyword in vb (or '&' in c#) using codedom? I haven't been able to figure it out. Thanks! -Zach Tag: LINQ with SQL Server Tag: 407041
 - 6
 - Slightly OT ? regarding posting to this group... In the last week or so I have seen a few comments about "top posters" as being some sort of 2nd class citizens. This is the first I had heard this in the over a year I have been using this site. I have gone back and looked at all the guidelines, and there is no mention of top vs bottom posting. Also, since the the reply dialog opens with a 'top post' style, I would of thought that would be the 'recommended' way to reply, but I am willing to play by the rules, if in fact that is what people want and not just the ramblings of a few zanny people. Comments? -- Terry Tag: LINQ with SQL Server Tag: 407035
 - 7
 - VS2008 IDE question When I open a form (already exists) in the IDE, why is it marked 'dirty' before I have touched it? In fact, if I open an existing solution, the solution, project, and any form that was open in the IDE the last time I closed the solution are all marked dirty. Is this a bug, 'cause if its not...it should be! -- Terry Tag: LINQ with SQL Server Tag: 407031
 - 8
 - Reference VB6 to VB.NET DLL Hello All, Does anybody know how to reference a VB6 project to a VB.NET DLL. Kind regards, JJ Tag: LINQ with SQL Server Tag: 407027
 - 9
 - Reference to COM Object Error on Another Computer I have added some code to a VB8 program which requires reference to the Word object model, "Microsoft Word 11.0 Object Library" The spell checking function works fine on my computer but a friend attempting to use the program on his gets the error "Could not load file or assembly 'Interop.Word, Version=8.3.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified." We both have Office 2003 installed and the file MSWord.olb to which this reference points is of the same size and date. However I have office installed on my D partition in a folder I named, not in the default C:\ ProgramFiles..... as my friend does. So how is this situation handled? Ed Tag: LINQ with SQL Server Tag: 407026
 - 10
 - OLESelfRegister missing in FileVersionInfo Hello, I am trying to detect OLESelfRegister in file version info (to detect if library requires registration), but to my surprise FileVersionInfo ignores this flag :( Dim Info As FileVersionInfo = FileVersionInfo.GetVersionInfo(m_File) will return all version information, however not OLESelfRegister. Any idea why this is ignored? And more important, anyone knows how to detect it??? Thanks, Martin Tag: LINQ with SQL Server Tag: 407025
 - 11
 - Create a new task scheduler using ITaskService in Vista I want to create a new task scheduler using ITaskService in Vista, Microsoft provides a C code, now i know how to show the task scheduler, but do not know how to create a task, can anyone convert some codes to VB.NET? thank you. *****************************************************************************/ #include "stdafx.h" #include <windows.h> #include <stdio.h> #include <stdlib.h> #include <comdef.h> #include <comutil.h> //Include Task header files - Included in Windows Vista Beta-2 SDK from MSDN #include <taskschd.h> #include <conio.h> #include <iostream> #include <time.h> using namespace std; #define CLEANUP \ pRootFolder->Release();\ pTask->Release();\ CoUninitialize(); HRESULT CreateMyTask(LPCWSTR, wstring); void __cdecl wmain(int argc, wchar_t** argv) { wstring wstrExecutablePath; WCHAR taskName[20]; HRESULT result; if( argc < 2 ) { printf("\nUsage: LaunchApp yourapp.exe" ); return; } // Pick random number for task name srand((unsigned int) time(NULL)); wsprintf((LPWSTR)taskName, L"Launch %d", rand()); wstrExecutablePath = argv[1]; result = CreateMyTask(taskName, wstrExecutablePath); printf("\nReturn status:%d\n", result); } HRESULT CreateMyTask(LPCWSTR wszTaskName, wstring wstrExecutablePath) { // ------------------------------------------------------ // Initialize COM. TASK_STATE taskState; int i; HRESULT hr = CoInitializeEx(NULL, COINIT_MULTITHREADED); if( FAILED(hr) ) { printf("\nCoInitializeEx failed: %x", hr ); return 1; } // Set general COM security levels. hr = CoInitializeSecurity( NULL, -1, NULL, NULL, RPC_C_AUTHN_LEVEL_PKT_PRIVACY, RPC_C_IMP_LEVEL_IMPERSONATE, NULL, 0, NULL); if( FAILED(hr) ) { printf("\nCoInitializeSecurity failed: %x", hr ); CoUninitialize(); return 1; } // ------------------------------------------------------ // Create an instance of the Task Service. ITaskService *pService = NULL; hr = CoCreateInstance( CLSID_TaskScheduler, NULL, CLSCTX_INPROC_SERVER, IID_ITaskService, (void**)&pService ); if (FAILED(hr)) { printf("Failed to CoCreate an instance of the TaskService class: %x", hr); CoUninitialize(); return 1; } // Connect to the task service. hr = pService->Connect(_variant_t(), _variant_t(), _variant_t(), _variant_t()); if( FAILED(hr) ) { printf("ITaskService::Connect failed: %x", hr ); pService->Release(); CoUninitialize(); return 1; } // ------------------------------------------------------ // Get the pointer to the root task folder. This folder will hold the // new task that is registered. ITaskFolder *pRootFolder = NULL; hr = pService->GetFolder( _bstr_t( L"\\") , &pRootFolder ); if( FAILED(hr) ) { printf("Cannot get Root Folder pointer: %x", hr ); pService->Release(); CoUninitialize(); return 1; } // Check if the same task already exists. If the same task exists, remove it. hr = pRootFolder->DeleteTask( _bstr_t( wszTaskName), 0 ); // Create the task builder object to create the task. ITaskDefinition *pTask = NULL; hr = pService->NewTask( 0, &pTask ); pService->Release(); // COM clean up. Pointer is no longer used. if (FAILED(hr)) { printf("Failed to CoCreate an instance of the TaskService class: %x", hr); pRootFolder->Release(); CoUninitialize(); return 1; } // ------------------------------------------------------ // Get the trigger collection to insert the registration trigger. ITriggerCollection *pTriggerCollection = NULL; hr = pTask->get_Triggers( &pTriggerCollection ); if( FAILED(hr) ) { printf("\nCannot get trigger collection: %x", hr ); CLEANUP return 1; } // Add the registration trigger to the task. ITrigger *pTrigger = NULL; hr = pTriggerCollection->Create( TASK_TRIGGER_REGISTRATION, &pTrigger ); pTriggerCollection->Release(); // COM clean up. Pointer is no longer used. if( FAILED(hr) ) { printf("\nCannot add registration trigger to the Task %x", hr ); CLEANUP return 1; } pTrigger->Release(); // ------------------------------------------------------ // Add an Action to the task. IExecAction *pExecAction = NULL; IActionCollection *pActionCollection = NULL; // Get the task action collection pointer. hr = pTask->get_Actions( &pActionCollection ); if( FAILED(hr) ) { printf("\nCannot get Task collection pointer: %x", hr ); CLEANUP return 1; } // Create the action, specifying that it is an executable action. IAction *pAction = NULL; hr = pActionCollection->Create( TASK_ACTION_EXEC, &pAction ); pActionCollection->Release(); // COM clean up. Pointer is no longer used. if( FAILED(hr) ) { printf("\npActionCollection->Create failed: %x", hr ); CLEANUP return 1; } hr = pAction->QueryInterface( IID_IExecAction, (void**) &pExecAction ); pAction->Release(); if( FAILED(hr) ) { printf("\npAction->QueryInterface failed: %x", hr ); CLEANUP return 1; } // Set the path of the executable to the user supplied executable. hr = pExecAction->put_Path( _bstr_t( wstrExecutablePath.c_str() ) ); if( FAILED(hr) ) { printf("\nCannot set path of executable: %x", hr ); pExecAction->Release(); CLEANUP return 1; } hr = pExecAction->put_Arguments( _bstr_t( L"" ) ); if( FAILED(hr) ) { printf("\nCannot set arguments of executable: %x", hr ); pExecAction->Release(); CLEANUP return 1; } // ------------------------------------------------------ // Save the task in the root folder. IRegisteredTask *pRegisteredTask = NULL; hr = pRootFolder->RegisterTaskDefinition( _bstr_t( wszTaskName ), pTask, TASK_CREATE, _variant_t(_bstr_t( L"S-1-5-32-545")),//Well Known SID for \\Builtin\Users group _variant_t(), TASK_LOGON_GROUP, _variant_t(L""), &pRegisteredTask); if( FAILED(hr) ) { printf("\nError saving the Task : %x", hr ); CLEANUP return 1; } printf("\n Success! Task successfully registered. " ); for (i=0; i<100; i++)//give 10 seconds for the task to start { pRegisteredTask->get_State(&taskState); if (taskState == TASK_STATE_RUNNING) { printf("\nTask is running\n"); break; } Sleep(100); } if (i>= 100) printf("Task didn't start\n"); //Delete the task when done hr = pRootFolder->DeleteTask( _bstr_t( wszTaskName ), NULL); if( FAILED(hr) ) { printf("\nError deleting the Task : %x", hr ); CLEANUP return 1; } printf("\n Success! Task successfully deleted. " ); // Clean up. CLEANUP CoUninitialize(); return 0; } Tag: LINQ with SQL Server Tag: 407024
 - 12
 - 23 www,ec231-silkonroad.cn sell Burse & Handbag 1).LV Bag 2).Gucci just do business with us,send website for free! We are wholesale each kind of Shoes, Jeans, T-shirts, Sunglasses,Handbags, Wallets, Sandals, Watches,Cap, Belt... from China. In the process of fast development, ( $B!y(B www.ec231- silkonroad.cn $B!y(B) are looking forward to cooperation with inner and abroad business partners.We will work hard to meet the interests of our customers to boost our advantage. We are sure we will be one of your best ideal cooperation partners. ------------------------------------------------------- $B!y(B Good News $B!y(B Now just our business money above $200,Our company will send a website for free to customer. Abuot details please contact us: chinasilkroad@hotmail.com best regards! ----------------------------------------------------- $B!y(B www.ec231-silkonroad.cn $B!y(B Reproductions of Oil Paintings on Wholesale Basis Enjoy the beauty of handmade oil painting and hang the perfect work of the art in your oil paintings gallery, home or office . You are at the right place now. * 100% handmade oil paintings on canvas * Custom oil paintings made according to your pictures and requests * Skilled artists with 10-20 years full time working experience * More than 3,000 optional motives and 40,000's storage * Over 80 different classical and modern frames for you to choose * Shipping your order within 48 hours if the oil paintings are in storage * Special supervision team to control quality * Excellent sales team will follow your every message in time * Worldwide shipping available ------------------------------------------------------- We export our brand shoes all over world because of our competitive price, good quality products and good service. All our products are guaranteed to be a minimum of AAA+ quality. Our price and good service are often appreciated by our customers. So we can get repeat order to sustain our development. Your support of our business is very thankful. We deliver all our orders promptly via EMS/UPS/DHL/FEDEX/TNT. A typical delivery time is around 7 days from dispatch in China to arriving at your door. We ship worldwide and guarantee delivery. Payment we prefer Western Union Bank-of-China ,please click this site: www.ec231- silkonroad.cn Our products are popular all over the world with high quality, low price, timely delivery and best service. We will update the latest style and stocks frequently. You are welcome to visit our website to learn more information of our shoes and search the items you are interested in. We respect all our clients and we'd like to share with them on mutual benefit. We want to strengthen friendship between us. If you are interested in our products or service please contact us without delay. We are waiting to serve you. You are welcome to visit our website: www.ec231-silkonroad.cn Tag: LINQ with SQL Server Tag: 407011
 - 13
 - What is UShort? (and how can I not use it?) I imported a project from someone and they are using UShort. I am getting a compiler error saying "Type 'UShot' is not defined". Since this is a VS 2008 project and I am on VS 2008, I am assuming this is a new datatype that I don't have access to. What can I substitute for it (and still be safe?). I tried changing it to sort and uint16 but not having much luck with error messages. Thanx, -- Anil Gupte www.keeninc.net www.icinema.com Tag: LINQ with SQL Server Tag: 407010
 - 14
 - Generating a dataview from a datatable Hi I have a strongly typed dataset generated by vs 2008. I am trying to fill in one of the datatables in the dataset and then cerate a dataview from the datatable. I have used the below code but it does not work. Public ds As MyDS Public dv As DataView Public daMyTbl As MyDSTableAdapters.MyTblTableAdapter ds.MyTbl.Clear() daMyTbl.Fill(ds.MyTbl) dv = New DataView(ds.MyTbl) For starters it givbes 'Object reference not set to an instance of an object.' error on ds.MyTbl.Clear() line. What am I doing wrong? Many Thanks Regards Tag: LINQ with SQL Server Tag: 407004
 - 15
 - VB.NET Remoting Programming Challenge I have created a very simple and short (70 lines) demo to demonstrate how to send data between instances of the same applications running on the same box. Here is a link to a .zip file that contains the whole project. http://mysite.verizon.net/johnheitmuller/SameBoxChat.zip I have gotten this to work by using the WM_COPYDATA message and calling the SendMessage() function in User32.dll. This satisfies my immediate nee, but I would be really interested to see if anybody knowledgeable about .NET Remoting could rewrite this simple demo using Remoting. My thought is that the technique of invoking User32.dll may not work with future OS versions. Thanks, John Tag: LINQ with SQL Server Tag: 406998
 - 16
 - Mixinf fonts in a TextBox? I have a multiline textbox control where I would like to load up with something like the following: This is Line 1 <- this line is NOT bold This is Line 2 <- this line is bold This is Line 3 <- this line is NOT bold I have attempted to use C# code like the following: string part1 = "This is Line 1" + Environment.NewLine; string part2 = "This is Line 2" + Environment.NewLine; string part3 = "This is Line 3" + Environment.NewLine; textbox.Text = part1; textbox.Font = new Font(textbox.Font, textbox.Font.Style | FontStyle.Bold); textbox.AppendText(part2); textbox.Font = new Font(textbox.Font, textbox.Font.Style | ! FontStyle.Bold); textbox.AppendText(part3); But the compiler complains that the ! operator cannot appear where it is. I know there has to be some simple way to do this, but I just haven't been able to find it yet. Can anyone help? TIA, Tag: LINQ with SQL Server Tag: 406982
 - 17
 - Dlookup function Hi Is there a dlookup function in vb.net like in access which returns a column value from a table for a given criteria? If not, is there a sample I can look at? Thanks Regards Tag: LINQ with SQL Server Tag: 406976
 - 18
 - Determine if a Date is BETWEEN a date range. Hi. In my VB.NET application I need to identify whether or not a user-input date falls in between certain date ranges. For example, If I know my date range is 4/1/2008 - 5/1/2008, and a user inputs 4/3/2008, I would need a boolean TRUE indicating that the input date falls between date ranges. I know I could do greater than/less than comparisons, but I want to check if there's a simpler way to accomplish this. Thank you. Tag: LINQ with SQL Server Tag: 406974
 - 19
 - What is the equivalent VB syntax for this c# code? private const int RF_TESTMESSAGE = 0xA123; [DllImport("user32.dll", CharSet=CharSet.Auto, SetLastError=true)] public static extern int SendMessage(IntPtr hwnd, [MarshalAs(UnmanagedType.U4)] int Msg, uint wParam, ulong lParam); I'm trying to send a Windows message from a VB.NET 2005 app. I found this example in C# that works fine, but I cannot figure out the VB sysntax. Thanks, John Tag: LINQ with SQL Server Tag: 406966
 - 20
 - Programming MSAgent am unable to trigger IdleStart Hello, I have almost got a VB 2008 Express program working using MSAgent's Merlin character. The character pops up and says a few words and then enters the idle state. I can click a button on the form named btnQuit to exit the program and that subroutine works. But I want to use the IdleStart event to cause the program to terminate gracefully by itself if unattended. However, my program never fires the IdleStart subroutine. Here's the coding. Can someone tell me how to correct this program so that it will trigger the IdleStart subroutine? Public Class Form1 Public Merlin As AgentObjects.IAgentCtlCharacter Public ctlAgent As New AgentObjects.Agent Public Const DATAPATH = "C:\Windows\Msagent\Chars\Merlin.acs" Private Sub frmMerlinForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ctlAgent.Connected = True ctlAgent.Characters.Load("Merlin", DATAPATH) Merlin = ctlAgent.Characters("Merlin") Merlin.Show() Merlin.Speak("Hello World") End Sub Private Sub Agent_IdleStart(ByVal Merlin As Object, ByVal e As AxAgentObjects._AgentEvents_IdleStartEvent) Handles Agent.IdleStart Merlin.Speak("Good Bye!") End End Sub Private Sub btnQuit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnQuit.Click End End Sub End Class Tag: LINQ with SQL Server Tag: 406965
 - 21
 - Having trouble populating listboxes I am having some issues with Listboxes Here is my code: Dim DSContent As New DataSet DSContent = L3GContent.GlobalDataSet URLListBox.BeginUpdate() For Each dr As DataRow In DSContent.Tables("ContentSites").Rows URLListBox.Items.Add(dr("URL")) Next URLListBox.EndUpdate() This populates the listbox and displays the URL as items. However, how do I put in ValueMembers versus DisplayMembers separately? I tried using Databindings, but I need more control than what it can offer (for example adding additional items not in the dataset). Any help is appreciated. Thanx, -- Anil Gupte www.keeninc.net www.icinema.com Tag: LINQ with SQL Server Tag: 406959
 - 22
 - How to refrence the inbox of an additional mailbox in Outlook? I have this code to get to the default Outlook inbox but I would like to get to the inbox of an additional added mailbox. Can this be done? Here is the code I'm using below: Dim objSession As MAPI.Session Dim objInbox As MAPI.Folder Dim objMessages As MAPI.Messages Dim objMessage As MAPI.Message Dim objEmbeddedMessage As MAPI.Message Dim objNewMail As MAPI.Message If cboFileType.SelectedIndex <> -1 Then ListBox1.Items.Clear() 'create session and logon objSession = CreateObject("MAPI.Session") 'Use this for non exchange outlook - objSession.Logon("Outlook") objSession.Logon("Default Outlook Profile") 'works on Halliburton COE ' objSession.Logon() 'reference the messages in the inbox objInbox = objSession.Inbox objMessages = objInbox.Messages -- Bill Bray Tag: LINQ with SQL Server Tag: 406958
 - 23
 - Calculating age from DOB Hi How can I calculate age from a given DOB? Thanks Regards Tag: LINQ with SQL Server Tag: 406956
 - 24
 - google adsense website for sale <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> Dear friends, Earn from google adsense. A complete ready made google adsense website package for sale @ Rs. 1000 only. 100 Content Rich Adsense Web Sites containing more than 16000 web pages for Rs. 1000/only. <A href="http://www.googlead.xtreemhost.com/">click here </A>for sample website </BODY> </HTML> Tag: LINQ with SQL Server Tag: 406951
 - 25
 - getting table adapter return values from stored procedures? The question is simply stated on the last line of this post, reading it first might save time. I am exploring the possibility of using typed datasets and table adapters as the basis for a data access layer. Using stored procedures as the table adapter's communication vehicle to the database. I have gotten a demo form/dal/sp/table working for dataset retrieval, single value retrieval, and delete/insert/update operations. In the delete/insert/update area, I have a serious reservation about going "production". It has to do with how to reference the return value from the stored procedure, so I can use it to generate a status message to the form's user. From this site I picked up one way to get the return value from the stored procedure: blogs.msdn.com/vsdata/archive/2006/08/21/711310.aspx A helper function is added to the generated dal code, like this: Partial Public Class QueriesTableAdapter Public Function GetReturnValue(ByVal commandIndex As Integer) As Object Return Me.CommandCollection(commandIndex).Parameters(0).Value End Function End Class And gets the ReturnValue from the stored procedure, as found here in the generated table adapter code: Me._commandCollection(3) = New Global.System.Data.SqlClient.SqlCommand CType(Me._commandCollection(3),Global.System.Data.SqlClient.SqlCommand).Connection = New Global.System.Data.SqlClient.SqlConnection(Global.AdminSQLBind.My.MySettings.Default.AdminConnectionString) CType(Me._commandCollection(3),Global.System.Data.SqlClient.SqlCommand).CommandText = "dbo.UpdateAdminActivity" CType(Me._commandCollection(3),Global.System.Data.SqlClient.SqlCommand).CommandType = Global.System.Data.CommandType.StoredProcedure CType(Me._commandCollection(3),Global.System.Data.SqlClient.SqlCommand).Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@RETURN_VALUE", Global.System.Data.SqlDbType.Int, 4, Global.System.Data.ParameterDirection.ReturnValue, 10, 0, Nothing, Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", "")) My problem is: I cannot imagine using the offset value "(3)" above to get to the correct parameter (@RETURN_VALUE) value. Especially, since there could be (n) parameters in the generated table adapter code. Here is the code in the WinForm that calls the above table adapter/stored procedure and gets the return value: intReturn = ta.UpdateAdminActivity(ActivityID, _ Trim(txtActivityDescription.Text), _ Trim(txtActivityName.Text), _ Trim(txtDirectIndirect.Text), _ Trim(cboInactive.Text), _ CType(Trim(txtInactiveDate.Text), Global.System.Nullable(Of Date)), _ CType(Trim(txtEffectiveDate.Text), Global.System.Nullable(Of Date)), _ Trim(txtComment.Text), _ Trim(txtCode.Text), _ AuditLog, _ guid, _ NewGuid) intReturn = CInt(ta.GetReturnValue(3)) Question: Is there a "named value" syntax alternative to the "(3)" in the statement above? Thanks in advance, Dean S Tag: LINQ with SQL Server Tag: 406949

I just read few notes on LINQ.
I am really very impressed the way it works and do queries from SQL Server.

I want to know is the LINQ only does the SELECT statment or does it also
handles UPDATES and DELETIONS.
I am very curious about this, so please provide me some knowledge.

Thanks Steven.

Top

Re: LINQ with SQL Server by Cor

Cor
Wed Mar 12 00:46:11 CDT 2008

Steven,

SubmitChanges

http://msdn2.microsoft.com/en-us/library/system.data.linq.datacontext.submitchanges.aspx

Cor

Top

Re: LINQ with SQL Server by Steven

Steven
Wed Mar 12 08:59:42 CDT 2008

Cool.

Thanks Cor

"Cor Ligthert[MVP]" <notmyfirstname@planet.nl> wrote in message
news:BCDAD235-B702-485F-857B-B1EDE878A33E@microsoft.com...
>
> Steven,
>
> SubmitChanges
>
> http://msdn2.microsoft.com/en-us/library/system.data.linq.datacontext.submitchanges.aspx
>
> Cor

Top