SqlServerBeginner's Q&A profile

• .NET Development how can I pass parameters from a class to a datagridview (in two layers) This is for a filter

  'This is part of my class Public Sub Find_Customers( ByVal name As String , ByVal data As System.Windows.Forms.DataGridView) Dim StrSQL As String Dim mvarNameCust As String Dim da As OleDb.OleDbDataAdapter cnMat.Open() mvarNameCust = name StrSQL = "select * from Customers " & "where Name like '" & mvarNameCust & "%'" da = New OleDb.OleDbDataAdapter(StrSQL, cnMat) Dim ds As DataSet = New DataSet() *****Dim dt as DataTable = New DataTable() ******da.fill(dt) da.Fill(ds) data.DataSource = ds ******data.DataSource = dt End Sub   'This is part of my windows.form.datagridview Private Sub txtCustomers_TextChanged( ByVal ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. No ID3DX10Line?

  I do not see any documentation for a D3D 10 version of ID3DXLine. Granted the DX9 ID3DXLine interface is a complete joke -- both in performance and quality, at least there is a way to get a few stylized lines in the 3D view. While games don't use stylized wireframe, this is a cornerstone for profession graphics packages (e.g., modelling and drafting). Current hardware supports accurately rendered, deterministic zbuffered, accelerated lines with widths up to 5 pixels wide. Common screen space dash patterns are sufficient for 90% of all display purposes. There are also several hidden line algorithms that only function correctly if the wide lines are rendered with correctly depth buffered Bressenham step patterns. Until Direct3D provides acce ...Show All

• Windows Forms Detect if Ctrl is pressed when a ColumnHeader is clicked

  Hello, Is it possible to detect if Ctrl is pressed when a ColumnHeader is clicked in ColumnHeaderMouseClick Or do I have to do it with KeyDown & KeyUp... Thanks for the help, Kenny In case anyone would like to know how to use "My" in C#... http://community.bartdesmet.net/blogs/bart/archive/2006/03/14/3824.aspx ...Show All

• .NET Development How can I convert this c# code into a regular expression?

  I'm trying to create a "path validation method" to check if a string can be used as a valid path in my program. The path must contain an indication character at the beginning of it which can be either minus, tilde or a dot. In case of a minus character than it must be followed by a number. In case of tilde or a dot than it must be followed by any valid step format. A valid step format is either a s tring enclosed by a sharp brackets , a number or a combination of a string enclosed by a sharp brackets followed by a number without white spaces between the brackets and the number. After the initial step we can have a dot separator to indicate that we have additional steps that must follow the normal step format without the starting indicatio ...Show All

• Visual Studio Team System TFS Trial CALs

  How many users can access the TFS using the TFS trial version Adam, Thanks for all your help. Hans, We tried to use the key from the trial version on our Workgroup version. It did not accept the trial version key. I take that to mean that you cannot upgrade the workgroup version to the trial version. You will probably need to unistall the workgroup version and install the trial version. Thanks again for your help. LouS ...Show All

• SQL Server How to upgrade one of a multi-instance SQL2K5 DEVELOPER versions to Standard version with SP1 applied?

  hello we want to evaluate TS foundation server but it says it won't support developer edition sql, only sql2k5 stanard. But now we have DEVELOPER version on our development sql server, DEVDATA1, i.e. instances DEVDATA1\DEV, and DEVDATA1\QA are both installed on the same sql server box with both SP1 applied. How can we update DEVDATA1\QA to Standard version while still have SP1 applied we just install Standard CD and then apply SP1 again Because this instance is our QA version, before we do something silly, if any of you did that before, any advice would be really helpful. thanks in advance. YOu will have to do the updates on every instance in the sequence you already mentioned. HTH, Jens K. S ...Show All

• Visual Studio Cannot Debug JavaScript in VS.Net

  I was able to debug Javascript with vs.net 2005 and 2003, however since I have upgraded to IE 7 the javascript debugging is not the same. I used to just have to use the debugger; javascript command and it would send the Client Side HTML file to the debugger and I could debug the code that was at the client. However now it does not do it that way, it triggers the debugger and it switches over the ASPX file. The major problem stems when I use the aspx function RegisterClientScriptBlock. That code is complied from the code behind page it is not in the aspx file so I cannot see the Javascript that I need to debug. Environment VS.Net 2003, IE 7 ASP.Net i found a solution to this issue here: ms-h ...Show All

• Smart Device Development Information needed regarding the file system

  hi, I want information related to file renaming.Suppose On device, i have images named suppose xyz. Now if i rename this file to ABC. How can i get programmatically tht the file name has been changed. Actually, my appln is related to uploading of the images to the server. So i use MD5 hashed code for the file, so if the uploading breaks, next i check the file with the server already uploaded files and start uploading from where it stopped. hashing takes alot of time, so depending on the filename uploading is continued next time. the problem i m facing is, if in case user changes the filename and later when i check for already uploaded files, i cant get the file that is renamed as already uploaded. How to get the information whether its nam ...Show All

• SQL Server Dynamically setting maximum server date dimension

  Hello everyone. I have what should hopefully be a simple problem. I have a fairly complicated cube created in SSAS 2005. One of my dimensions is a Server Time dimension. I have this linked to my fact table with a Regular relationship. Now, I would ideally like to be able to set the CalendarEndDate property in the Source property group of my dimension dynamically, based on the most recent date in the fact table. I will never need to see information for a future date using this dimension. Any ideas would be greatly appreciated. Thank you. Alex Levin Principal Consultant Fifth Marker Consulting, LLC alex.levin@fifthmarker.com I have a cube which is being used by analysts who are using Excel p ...Show All

• SQL Server Errors using the uninstall tool - 'vs_uninst_betas'

  Hi Folks getting the following error message when using the tool and can get past it. i can email the error dialog to you if required, i just cant post it. the setup has encountered an unexpected error in data store. The action is RestoreSetupParams. The error is: Failed to read property installl ds Hi Mike I think a reformat may be in order! Thanks for all the help. By the way, would you know of a good article/thread on how to preform sql 2005 express back ups by any chance thanks again for all the help nick ...Show All

• Visual C++ DELAYLOAD in C++/CLI

  I have C++/CLI library which is linked to unmanaged library FGCamera.lib. I want to use FGCamera.lib as delay-loaded Dll. In the Linker Properties, Input, I have FGCamera.lib in the Additional Dependencies. Now I add FGCamera.dll to Delay Loaded Dlls. Result of linking: LINK : warning LNK4199: /DELAYLOAD:FGCamera.dll ignored; no imports found from FGCamera.dll C++/CLI Dll is called from C# exe client. Delay loading is not working. How can I fix this I made the same test with unmanaged MFC project linked to this library, and got this message: LINK : fatal error LNK1194: cannot delay-load 'FGCamera.dll' due to import of data symbol '__imp__FGResolutionStr'; link without /DELAYLOAD:FGCamera.dll Cannot und ...Show All

• Smart Device Development pressing button from code

  hi, i have a handler to catch a keypress, where sender is still Button class, look at th code. private void but_keypress_evvnet(object sender, KeyPressEventArgs e) { if (e.KeyChar == '\n') (sender as Button).SimulateClick(); } in the code is nonexists method Simulate click. i want to press this button from code, how can i do that thak you, paul this has been discussed numerous times in these forums, including several recent postings. you'll need to sendmessage. search for it. ...Show All

• Software Development for Windows Vista Compile workflow in memory and store assembly in database

  I compile the workflow in memory and store compiled assembly in database, I fetch assembly from database and use it to create workflow instance. However it occur some exception when I deserialize byte[] to an Assembly. I store compiled asse mbly by the following code WorkflowCompiler compiler = new WorkflowCompiler(); WorkflowCompilerParameters parameters = new WorkflowCompilerParameters(); parameters.ReferencedAssemblies.Add(typeof(Test.Activities.DocumentApprovalActivity).Assembly.Location); parameters.GenerateInMemory = true; parameters.OutputAssembly = Guid.NewGuid().ToString + ".dll"; WorkflowCompilerResults results = compiler.Compile(parameters, strArr); using (MemoryStream memoryStream = new MemoryStream()) { BinaryFormatter bina ...Show All

• Windows Forms Manupulation with DataGrid

  I am new in Windows form but working from last 5 years in web forms, when I start working on windows datagrid its quit different from web form datagrid, could you let me know any project which uses the proper way to manuplulate the datagrid like Add, Edit and delete recored in a grid as well as search, sort and group data. many thanks in advance may be, yes, I want to know how to update the data in a grid as well as Add, delete, sort and search, i was search the net for a project which illustrate this ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. RANDOM LETTERS FROM A TO G

  Hi, I'm looking for a letters generator from a to g. Or a numbers generator. 1 to 9. I have a scoring system for a horseshoe game I created in excel 2007 beta. I need the letters in column d3 to d13 to update once a round is completed. Which happens ok. But once a team is eliminated. I dont want a letter assined to the cell. If anyone could take a look will understand my issue. I will email you the workbook if you think you can help me out with this. I don't no vba yet but am trying to understand it. my email is trobert672@comcast.net Random random = new Random(); // to generate random number: int number = random.Next(1, 10); // min is inclusive, max is exclusive // to generate random character from ...Show All