Sumit Bhatnagar's Q&A profile

• Windows Forms Select item from dropdown list issue

  Hi I have the following code all the inserts into the database table work apart from the dropdown list. The data entered for Title is always "select a title" if I remove this line of code "DropDownList1.Items.Insert(0,"Select a Title");" then the data inserted is always the first title displayed in the dropdown box no matter which title is selected. Does anyone know what I am doing wrong thanks for any help Sammy. private void Page_Load(object sender, System.EventArgs e) { sqlDataAdapter1.Fill(dataSet1); DropDownList1.DataSource = dataSet1; DropDownList1.DataTextField = "title"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0,"Select a Title"); } private void ...Show All

• Software Development for Windows Vista Writing Resource Managers for System.Transactions to MTS/DTC and XA

  We are trying to write a durable resource manager that works with System.Transactions. I need to use mts/dtc talking to xa where the actual database is on a remote system. I have read all of "Implementing a Resource Manager" and everything else I could find but could not figure out how to couple the .NET resource manager with xa. We have working distributed transaction code for OLEDB and ODBC using mts/dtc and xa. I really need sample code and/or hints about writing such a resource manager like this. Yes, that would be correct. As a middleware layer I want to write a Resource Manager for the Systems.Transactons namespace that will use 1Pipe/2Pipe connection to an XA enabled Resource Manager. I read "Implementi ...Show All

• Visual Basic VB.NET 2005 RC - Datagrid issue

  I have an application which uses a datagrid to display a property listing.   The list will contain around a quarter of a million records so I need the user to have a simple way to search. I have built a search routine which allows the user to type some text in to a toolstrip bar and then performs a search through the dataset.   The issue I have is when the routine finds a match, I need it to highlight the row on the datagrid.   This is where I have the problem; I cannot see how to achieve this.   I have tried searching everywhere (Google/Experts Exchange etc) and have seen some pretty ridiculous solutions such as mimicking a user clicking on the mouse. I also found what I thought were useful ideas such as : &n ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to only draw visible meshes? Performance problems.

  Ok, I have a simple mesh loaded that contains 24 faces. I have a loop that draws 144 of these boxes on-screen like so: for (int i = -(mapwidth / 2); i < (mapwidth/2); i++) { for (int j = -(mapheight/2); j < (mapheight/2); j++) { modelPosition = new Vector3((i * 10.0f)+5.0f, 0.0f, (j * 10.0f)); DrawModel(myModel); } } I noticed that if I have only one model in view (the camera is zoomed way in) or I show the entire grid of objects the time elapsed between frames does not change. The time elapsed between frames does change if I increase or decrease the number of objects drawn though. This leads me to believe that the framework is drawing every object whether or not it is visible. ...Show All

• .NET Development Excel and ODBC

  So I'm using ODBC to connect to an Excel spreadsheet. I use an Adapter with the simple SELECT * FROM [Sheetname$] to fill a DataTable. The problem is the DataTable doesn't fill correctly. I went ahead and just attached the DataTable to a DataGridView and noticed there were missing values. Specifically where values above them were different. Ex. Value in [4][4] = "1/1/2002". Therefore it expects every value in [x][4] to be a date. Entire columns of data are missing I'm guessing because they didn't match the first data type encountered in that column. Is there a work around for this No, I don't want to use COM. They do not want to have Microsoft Office installed simply to use this application. This is why I'm using OD ...Show All

• Visual Basic Stupid question....How do I instantiate a form from another form?

  I'm very new to vb.net. Just wondering how I can start up another form from another form's button. Thanks, and sorry for the newbie quiestion. try maybe... 'declare this globally: public class Form Dim boxdeimagen As New Form3 ... ...rest of code here ... then at this part: If OpenFileDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then if Me.boxdeimagen is nothing then Me.boxdeimagen = new Form3() end if Dim cyclo As Boolean If cyclo = False Then boxdeimagen.MdiParent = Me boxdeimagen.Show() boxdeimagen.PictureBox1.Image = Bitmap.FromFile(OpenFileDialog1.FileName) boxdeimagen.PictureBox1 ...Show All

• Visual C# Displaying extended ASCII-characters from a Foxpro table with OLE DB

  Hi, I made a C# 2.0 Windows application based on a Foxpro-table (Foxpro for Windows 2.6) and used the Visual Foxpro 9 OLE DB driver. When retreiving the data by an ADO.NET datareader, the extended ASCII-codes are not displaying on the right way on the forms of the application. For example N, A or O are displaying as - or +. It happens with ASCII-code's 128 or higher. Does anybody know a solution for this problem With regards, Jan ...Show All

• Visual Studio proxygen - using an external type as a base type and generics

  Hi, This is a VSTA question, so this seems the closest forum for it. I'm trying to pass a class MyObjectList: List<MyObject>{} from the host to an Add-In, but (as it states in the documentation) proxygen doesn't support generics. So, changing by base type to ArrayList, proxygen then complains that using an external type as a base type won't work. Great. What is the suggested method for passing a list of some sort from the host to the addin Is there a way to use Add-Ins without requiring a proxy so as to retain all the flexibility of .net code and still have an Embedded IDE that can debug those add-ins in a seamless non-destructive way Many thanks, Alec Alec, System ...Show All

• Visual Basic I'm making a conversion program...

  For those of you who know me, I've finally settled on an idea for a program. It converts (for starters) from anything that ends with meters (you know, centimeter, millimeter, kilometer) into anything else that ends with the word meters. You get the idea. I'm useing combo boxes, and I need to assign values to the names in the box, so they can be multiplied. Like, the selection (this is exactly what it looks like) "centimeter(cm)" needs to be assigned the value 0.01. How do I do that, and make it so that when one thing from one box is selected, and one thing from another box is selected, and a button is clicked, they get multiplied together Thanks. try this: Private Sub Form1_Load ( ByVa ...Show All

• SQL Server Insert into a View (Error Msg 4405)

  I have a view of two underlying tables, each with its own "identity" primary key, that are joined as a 1 to many. The view itself excludes the foreign key and identity columns of both tables. I have tried to INSERT INTO this view, and I receive a "Msg 4405, view is not updatable because the modification affects multiple base tables." Well yes, I know it affects multiple base tables, but I figured that this is one of the reasons why "views" are used - to simplify the insertion of data into multiple base tables. What am I doing wrong More precisely, the tables look like this: TableA ---------- TableAID (bigint, PK, identity) Name (nvarchar) TableB ---------- TableBID (bigint, PK, identity) TableAID ...Show All

• SQL Server Can we automate and schedule Analysis Services Databases Back up and Restore Actions?

  Hi, all here, Would please anyone here give me any advice about wether or not we can automate and schedule the Analysis Services databases backup and restore actions Thanks a lot in advance for any guidance and help for that. With best regards, You just have to create a XMLA backup command, somethink like this: <Backup xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine "> <Object> <DatabaseID>MyDBId</DatabaseID> </Object> <File>c:\MyDB.abf</File> <AllowOverwrite>true</AllowOverwrite> </Backup> Then create a new SQL Server Agent job of type "SQL Server Analysis Services Command" and schedule it as needed. See: ...Show All

• SQL Server SQL Recovery Mode

  Hi, How to make all MSSQL DBs run in Simple log form by default other than FULL so when we srhink DBs the logs will go bybye. :-) Thanks No need for a script. Just change the recovery model of your model database to simple . Every database you create will have the settings you specify for your model database. ...Show All

• Visual Studio Express Editions Need help

  Dear Gentlemen: I am a begginer in vb express 2005 and have the following problem: I am tring to make a programm for chefs, they have to write down the ingredients for a recepy but if for any reason they do not state the name of an ingredient a message should be displayed "you forgot to write the name of the ingredient", the instruction given is: Private Sub i1_TextChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles i1.LostFocus If i1.Text = "" Then MsgBox( "Olvido anotar el ingrediente." ) i1.Focus() End If End Sub Where i1 is the name of a text box wich will contain the ingredient 1 name (potato, tomatoe or whatever) When I run the ...Show All

• Visual C++ STL Thread Safety

  So, I looked for STL thread safety, and there are only two hits:  One in Visual C++ Express Edition , and the other in Visual C# Language . Where's the best place to discuss MSVC 2005's STL thread safety -MM This is probably a better location. C# knows nothing about the Standard C++ Library. The current C++ Standard Library - like the rest of the current C++ Standard - knows nothing about threads and thread-safety - it assumes a single threaded world. This may change in the next revision of the C++ Standard but for now if you are using the C++ Standard Library in a multithreaded environment then you, the programmer, are responsible for handling all threading issues. ...Show All

• Visual C# try / catch question

  Is it a good pratice to do the following void foo() { try{ ..... } catch(FileNotFoundException ex) { throw new FileNotFoundException(); } } void foo2() { try { foo(); } catch(FileNotFoundException ex) { .... } } generally wherever the exception is going to be thrown in, foo method in this case, will be thrown in that and not passed back to the caller, unless perhaps there is an exception thrown BUT you did not handle it. I just did a quick test, similar to the above and it confirmed that if Foo() caused an exception that we can handle, it will only be thrown in there and not raised/thrown back up to the caller.   general note: Throwing exceptions maybe expensive but be sure to catch the ...Show All