Arvind Agarwal - Skelta's Q&A profile
SQL Server How to insert a record in the middle of a DB
Well, how do you do it I've not seen any report on this... so could it be next to impossible Say you have 10 records, 1-10 and you want to insert a new record between record 4 and record 5 in a SQL database, just how do you code it And oh, each record uses the auto ID increment feature. Here's an idea: CREATE TABLE MyTable (id int identity(1,1), col1 varchar(16)) GO INSERT INTO MyTable SELECT 'value 01' INSERT INTO MyTable SELECT 'value 02' INSERT INTO MyTable SELECT 'value 03' INSERT INTO MyTable SELECT 'value 04' INSERT INTO MyTable SELECT 'value 05' INSERT INTO MyTable ...Show All
Visual Studio 2008 (Pre-release) Editing XAML - am I missing something ?
I have the latest release, AFAIK, and Cider is useless - I cannot type into the XAML editor, and using the drag and drop is a waste of time. Expression is a ton better ( read, it can be used ), but is missing the most basic features ( how about search, let alone search and replace, or auto indent of XML, or even being able to use TAB to indent a section of XAML ). I realise it's pre-release, but surely the code for those common features is trivial enough to be put in early and make the tool useful Or are they there and I'm just too dumb to find them Cider is a great tool but have some issues sometimes. But there is no problems ...Show All
Visual Studio Express Editions How we can use SQL query in DataSet Or DataTable
How we can use SQL query in DataSet Or DataTable I means to say can we use group by clause and other clause that we generally used with database table. Hi, Sunil You can use any valid select query to populate dataset or datatable, check this code Dim cn As New Odbc.OdbcConnection(ClsMain.ConneStr) cn.Open() Dim da As Odbc.OdbcDataAdapter Dim ds As New Data.DataSet Dim stmt As S tring stmt = "select Department, count(*) from Emp_Master group by Department" da = New Odbc.OdbcDataAdapter(stmt, cn) da.Fill(ds, "EmpDept" ) In this code i connect t ...Show All
Visual C++ Heap/Stack Overflow/Overrun Issues
I am running a simulation program in VC++ 6 that requires arrays (dynamic or otherwise) that will eventually have as many as 200,000 entries of type "double". The program works fine when I use small arrays (with a few hundred entries) but fails when I increase the array size to say several thousands. The error code is "Unhandled exception in sim.exe: 0xC00000FD: Stack Overflow". I guess the main question is, if possible at all, how do I increase the stack or heap size so that the program can accomodate arrays with 200,000 "double" entries Other advice most welcomed. Thanks in advance! ...Show All
Windows Forms The biggest thing I'd like is...
1) I/O for USB/Serial ...Show All
SQL Server Problem creating diagrams
I just upgraded an existing sql server 2000 installation with the RTM sql server 2005 (developer). I went to work on a database that I've been working on for a couple of weeks before the upgrade, and wanted to create a database diagram. However, when I click on the "Database Diagrams" tree node, I get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a ...Show All
Visual C# Link Form
I know some C# but I don't use it often enough to know this. I wanted to know the code that you put at the top of your form to link that form to another form, for instance in C++ you would type: #include "Form2.h"; But what would you type in C# Hi I think you can use Form2 frm2 = new Form2 (); Hope this helps ...Show All
Windows Forms DataGrid View - Ctl+0 to null out a combobox column
I have a DataGridView which has a DataGridViewComboBoxColumn column named "Assigned To" which allows users to assign tasks to a user of the system. The DataGridView is databound to a DataTable called "Tasks" and the "Assign To" dropdown is databound to a table called "Employees". The linkage between the two tables is employee_id. I would like the users to have the ability to un-assign a task. I am having problems setting the "Assigned To" value to null. I had two solutions to accomplish this: 1) Let the user hit "Ctrl+0" to null out the assign to value 2) Add a blank item i ...Show All
Visual C# What is the use of "STTBF".
Hi, Can any one tell the use of " STTBF ". What do you want todo, is STTBF a library, class, dll Normally STTBF stands for String Table stored in File it is just a file format. ...Show All
SQL Server How to retrieve the GUID value of a SQL NewID() identity column after an insert ?
Hello, In my table, i've a GUID column type. I insert a new record with NewID() function in Sql request. Is it possible to retreive the GUID column of this new record (without requerying the table) I'm using EVC, Sql Mobile 3.0 and OLE DB interface. Thanks in advance. no, you have to turn around and requery the database. another option if you are using CF2 is to create the GUID in your mobile app code and use it in your INSERT statement instead of NewID(). Then you know what it is without the extra database roundtrip. -Darren ...Show All
Visual Basic Printing from datagridview
I'm sure this has probably been asked before, but I can't find it. I’m using a DataGridView to display data from a SQL database and I would like to be able to print it. How do I do that My problem is grabbing the data. I simply don’t know how to get the data from the DataGridView. The best thing would be if I could grab and print the entire table but anyway to grab the data and print it in a readable way would be great. Thanks in advance Hi, You can get data from the DataGridView by iterating through the rows in the DataGridView.Rows collection. Code similar to the following should work: Dim line As String F ...Show All
Visual C++ why can't find the .h file!
I begin a Blank solution that named AllInOne.ADD a C++ Win32 project named Math Library and change the Application Settings to a static library. Next,Select a C++ Win32 Console application and name it Harness. MathLibrary project in Solution Explorer add a Generic C++ Class that named Arithmetic. In Solution Explorer, right-click the Harness project and choose Properties. Under Configuration Properties on the left, expand the C/C++ folder. Click General. Click next to Additional Include Directories on the left and type the relative path to the MathLibrary folder: ../MathLibrary Solution Explorer, right-cl ...Show All
Windows Live Developer Forums BlogID
Hi, can tell me anybody where I find BlogID of my blog at my MSNspace Thanks -jregent- If you look at the documentation at http://msdn.microsoft.com/library/en-us/msnspaces/MetaWeblogAPI_newPost_Method.asp frame=true it states that the blog ID should be the string "MyBlog" ...Show All
Visual C# a question
I'm going to try vc#2005, what's the most improvement between 2003 and 2005 Seems a stupid question,:-) Hi, There has been language changes in 2003-2005, unlike in 2002-2003 the changes only occured in the framework. But for me the most useful change must be the partial classes. It enables you to have a 2-file approach just like the old-C++. Also check out the Class Designer. kudos to microsoft for providing us such a wonderful tool... cheers, Paul June A. Domag ...Show All
Windows Forms Problem with treeView - Object not set an instance to an object...
I always have a problem when working with treeview. I have a treeview that looks like this: Root name - First node - First's node child1 - First's node child2 - Second node - Second's node child1 - Third node When I click on treeview this is code that is in treeView1_AfterSelect event private void treeView1_AfterSelect( object sender, System.Windows.Forms.TreeViewEventArgs e) { TreeNode tn = treeView1.SelectedNode; if (tn != treeView1.TopNode) { if (tn != treeView1.TopNode.Nodes[e.Node.Index]) { xml.ReadCodeContext(Convert.ToInt32(tn.Tag)); textBox1.Text = XmlContext.CodeText; ...Show All