andyfraser's Q&A profile

• SQL Server Recovery of dropped data that was never back up

  Hi I am trying to recover a set of tables with data that was dropped. This data was not backed up. Please advice, is there any way this data can be recovered. With SQL, the way to go back in time is to restore backups. You really can't recover dropped tables without any backups. Depending on how valuable and critical the information is (which begs the obvious question of why it wasn't backed up if it was valuable), you may be able to do some forensic data mining on the files themselves. The data is not actually overwritten, just marked as free mujch as the filesystem does. So as long as the space has not been reused, there may still be information out there. SQL has no utilities for this, however. ...Show All

• Visual Studio Express Editions How to get Table Name from Dataset

  Hi, I'm using a stored procedure to populate the dataset I want the tables name from the dataset I'm using this code private void button1_Click( object sender, EventArgs e) { SqlCommand cmd = new SqlCommand ( "GetGroupBusinessRules" ,con); cmd.CommandType = CommandType .StoredProcedure; SqlDataAdapter da = new SqlDataAdapter (cmd); con.Open(); DataSet ds = new DataSet (); da.Fill(ds); con.Close(); //string a = ds.Tables[0].TableName.ToString(); //MessageBox.Show(a); GetTableNames(ds); } private void GetTableNames( DataSet dataSet) { // Print each table's TableName. foreach ( DataTable table in dataSet.Tables) { MessageBox .Show(table.TableName. ...Show All

• Windows Forms DataGridView/DataSet problems

  Hi, In my application, I have a main form which opens another form (I will call this the child form). The child form is a sort of browser to allow me to look at the contents of a SQL database (there are many different databases in my application). I have set up my DataSet as a public static on my main form. When the child form is opened, it accesses this DataSet by accessing the class of the parent form and populates the DataGridView. When the child form is closed, I clear the DataSet by doing this: dSet1.Clear(); dSet1.Dispose(); When I breakpoint the code, it looks good. The DataSet variable shows clear. If I use my ListBox to browse to another table and open the child form again, I have a bizzare problem. All the columns ...Show All

• Visual Studio attach to a process automatically at startup (without UI)

  Hello, i have an app, which starts up some proccesses. Is it possible to debug into a process a startup without attaching it in the UI before Peter Hi, Not exactly sure what your scenario is but here are a few options. Hopefully one of them is what you are looking for. 1. If you want to debug some startup code for a process you are not launching e.g. service etc. In that case see the blog http://blogs.msdn.com/greggm/archive/2005/02/21/377663.aspx . 2. You just want to attach to a already running process without going through the Tools -> Attach to process UI. You can open the EXE as a project/solution and in the project properties specify that you want to do an Attach. When you hit F5, it wi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. joran's video tutorials dont work plz help

  ok so the videos start out ok but as they progress the speech and video don't match up which makes it very difficult!  plz help and tell me how to fix because i heard these are the best video tutorials out there. (dont tell me to find diff. tutorials ive done learnxna.com and i hate the text tutorials cause they make no sense.) (in case you dont kno wat tutorials im talking about there found here  www.xnatutorial.com   thx) Microsoft doesn't make or support these tutorials, though maybe Joran will see this post and reply. Otherwise make sure you are using the latest version of media player etc. This is either a media player or a video file problem not a XNA problem. ...Show All

• .NET Development Disconnected DataReader?

  Hello. I am using a DataReader to query a large database (millions of rows) and perform some upkeep on each row. Our DBA complains my app keeps a connection open and locks the database for a long time, and wants me to save the data internally, close the connection, then issue UPDATE commands. I am reluctant to do this, as the query could potentially return megabytes of data and I only want to access each row in sequence. What is the SQL-Server-friendly .Net way to step through a large query and potentially perform an update on each row Without knowing what is is that you are doing that requires you to update millions of rows by processing them one-by-one in sequence, it is difficult to provide an answer. ...Show All

• Visual Studio 2008 (Pre-release) Automation & ToggleButton

  I have an custom ToogleButton and I want to have an Invoke interface " IInvokeProvider" How I can implement this interface into my control. I use System.Windows.Controls. Thanks If I understand your question correctly, I believe it would look something like: public class CustomButton : ToggleButton, IInvokeProvider { void IInvokeProvider.Invoke() { OnClick(); } } Hope that helps, Kent ...Show All

• Audio and Video Development xml, java reference books

  I'm currently programming discs in iHD but could do with a bit more of a understanding of java and xml could anyone recommend any good books to use as a reference I've seen the javascript and xml bibles and they seem to cover most things, but is there anything else somebody has that they think is better I cannot speak to why Andy would make the statement, "there isn't anything like it in HDi", but AJAX books are going to cut right to the meat of javascript and how it interacts with the DOM as well as the whole concept of doing script tasks asynchronously. This is especially helpful to someone new to javascript and web application programming who wants to build interactive applications in HDi. ...Show All

• Visual Basic Sliding panel

  I've been toying with the idea of having a panel with buttons and such on it slide in from the top of the form when the user invokes a menu command. I've tried me.pnlsort.location.Y and such, in several configurations, and none of them seem to work. Does anyone have any suggestions on how to do this Public Class Form1 Dim WithEvents T As New Timer Dim P As New Panel Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Me .Controls.Add(P) P.BackColor = Color.Yellow P.SetBounds(50, -100, 200, 100) P.Top = P.Height * -1 T.Interval = 10 T.Start() End Sub Private Sub t_tick( ByVal sender As Object , ByVal e ...Show All

• Visual Studio Express Editions FormName.Show()

  I'm trying to just use a simple Show() function to open a form. It should work, but doesn't. ok this is wierd. Why do you have a timer on CSSBuilderTest form, on its form_load event, and then in the timer it closes it The problem seems to be in the CSSBuilderTest form, in the global variables. This one is the problem: Public ClassID As String = ClassIDSymbol & ID_Class.Text It can't get the values since everything is null/nothing and uninitialized. You need to set the values on say, form_load event. So: Public ClassID As String .. .. Private Sub CSSBuilderTest_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Timer1.Start() 'Take th ...Show All

• Smart Device Development app behaves differently in debug mode from release mode

  something seems weird to me. My app works fine while running in debug mode. how ever when i disconnect my PPC from the craddle and run the app, the program is not work well. basically i emulate a terminal. i requested data (very big) from a controller. in debug mode it works just fine. but with the app running by itself, i got incomplete incoming data. how why basically this how i did to received the data: somewhere is my complexe code there a event to trigger the ReadReceivedData(). At his turn this function triggers the PrintToTerminalDelegate() and passing the incoming data as a string. do you see any which cause tha app to fail in release mode public delegate void CDDelegate(string data); private void ...Show All

• SQL Server DSO on AS2005

  Right now I am just working with DSO 8.5 and AS2005 in VB .NET (framework 2.0). I am trying to create an MDX statement called [Year to Date Amount] but when I do that, something puts brackets around Date to make it [Year to [Date] Amount] which will cause an MDX script error when processing it. Someone mentioned this was a known issue and is going to be in SP2 but I was wondering if anyone knows where/if there is a hotfix for this Yes, I will be switching to AMO asap but I wanted to make sure what I have works with AS2005 right now (or will work with a simple patch). Thank you. This very much could be a known problem. But please go ahead and file it using feedback site: http://connect.microso ...Show All

• SQL Server ODBC Driver (for SQL Server 2005) unable to retrive CRecorset's fields values

  I am using MFC ODBC classes in my VC++ application for database accesss (on a SQL Server 2005 Database). After opening a Recordset I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE ) method of the CRecordset object to obtain field values. The above method works fine with ODBC drivers for Jet but when I use ODBC for SQL Server it throws the following exception. State:S1002,Native:0,Origin:[Microsoft][ ODBC SQL Server Driver] Invalid Descriptor Index I don't understand why the Microsoft SQL Server ODBC Driver is throwing this exception. Please help me! Michael. I solved my problem. My situdation is: I use MFC wizard to generate the ...Show All

• SQL Server except

  i have a table name table1 with composite pks on (A,B,C) And non keyfields (D,E,F) on table 2 I have also composite pks on (A,B,C) is it possible to have select * from table 1 except select a,b,c from table2 i want to compare on pks only or do i need to select a, b,c , d,e,f from table1 except select a,b,c from table 2 join select * from table1 as table3 on table1.a=table3.a and table1.b=table3.b and table1.c=table3.c thanks If you want to get the non-key columns also then you can just use NOT EXISTS like: select a, b, c, d, e, f from table1 as t1 where not exists(select * from table2 as t2 where t2.a = t1.a and t2.b = t1.b and t2.c = t1.c) ...Show All

• Windows Forms about aligning one column in datagridview

  Hi, I'm using datagridview ctrl and i need to align a particular column to left(int datatype).Is it possible. Regards venp Just set the alignment for the column's defaultcell style. dataGridView1.Columns["price"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight ; ...Show All