BuntyGupta's Q&A profile
SQL Server CLR DDL Triggers with SqlTrigger Attribute?
Does anyone have an example of using the SqlTrigger attribute for a DDL trigger Cannot seem to locate one What do you want to do Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Visual C++ Button
How would you make a text box say something from clicking on a button I've tried text_box1 = (((text_box2 * 9)/5)+32); But it didn't work. Why What it is getting to you is the on click event method for clicking on the button. What were you expecting by double clicking on the button Thanks, Ayman Shoukry VC++ Team ...Show All
Windows Forms to mdpotter
I load 3 buttons and only the last one fire one event Public Class GO : Inherits Control Public Event GO As EventHandler Protected btnGO As Button Private Sub OnGO(ByVal sender As Object, ByVal cea As CommandEventArgs) RaiseEvent GO(sender, cea) End Sub For i As Int32 = 0 To _GO1.Length - 1 btnGO = New Button btnGO.CssClass = "btnGO" btnGO.Text = _GO1(i) btnGO.CommandName = ...Show All
Windows Forms Problems setting up data in the Application Data directory
I have an application that I have written in C# 2.0 that I would like to deploy using a Setup and Deployment Project. The application uses data stored in a SQL 2005 .mdf file that I install along with it. Currently, I have the .mdf file installing into the Program Files\Application directory, which works fine for an administrator. What I would like to do is install the data into the User's Application Data folder, or, if they select All Users, into the All Users Application Data Folder. The problems that I've run into so far are: How can I tell if the user checked the All Users box. What is the Condition that I need to use to say that that b ...Show All
Windows Forms Mouse Event Handler
Hello , I am facing a weird problem. I am using the MouseDown event handler to detect a mouse press on a particular button. This code works on one PC but does not work on the other. Both the PCs work on Windows XP OS. Is there anything I am missing Thank you very much in advance Venksys The sample code is elow: private void startButton_MouseDown( object sender, System.Windows.Forms.MouseEventArgs e) { Cursor.Current = Cursors.WaitCursor; string Channel_Text_Start; bool [] dataArray = new bool [1]; dataArray[0]= true ; try { reset_Indicator_high = new Task("DO_pin_17_high"); Channel_Text_Start="Dev1/port1/line7"; ...Show All
Visual C# copy list items to database
How do i copy list items to database. List < string > lines = new List < string >(); I have added a 100 lines to my list "lines" and now i want to copy this over to my SQL tabe which has only 2 columns. ID and Value. I want to copy all line items to "Value" column and "ID" column must be filled with autoincremented number. How do i do this I know there is copyto() method for lists. I wonder if i could copy this list to dataset and then update sql table through tableadapter. But if i use this method how do i fill autoincrement column If the column is set to autoincrement then you won't specify a value at ...Show All
.NET Development Hey problem with IIS
Hey, I am using Windows 2000 prof i am having problem with IIS its not loading the home page when i checked with the url http://localhost in the task manager->> process i can see the inetinfo.exe and asp_wb.exe running. But i an unable to run the IIS server can any one help me in solving this problem What do you mean that you are unable to use IIS Server If you place a file named test.htm in c:\inetpub\wwwroot\ with the following content: "<html> <h1>Test</h1> </html>", can you see http://localhost/test.htm Regards, ...Show All
SQL Server select null value into 0(zero)
Hi, can i know how to use a select statement to show the null value record to 0 my select statement is like this. select orderqty - deliveryqty as outstandqty from Ordertable where orderdate > dateadd(mm, -1, getdate()) so in some case the deliveryqty will be null value due to some reason. can i able to make the value to 0 so the orderqty can -0 to get a value for outstandqty regads terence chua Terence Chua wrote: select orderqty - deliveryqty as outstandqty from Ordertable where orderdate > dateadd(mm, -1, getdate()) Use coalesce or isnull something like: select orderqty - coalesce(d ...Show All
Visual C# Is it possible to implement Win32 interfaces in C#?
I would like to implement some of the interfaces in Active Script Debugger Interfaces. Would like to use C# for it's ease over C++. Yes you can. You would need to define the interface on the C# side. The name doesn't really matter but should match the Win32 name. The critical aspect is making sure to specify the correct GUID in the interface attributes and to ensure that you declare it properly as either IUnknown or IDispatch. Note however that there is a restriction on unmanaged COM interfaces. Inheritance doesn't work so if you are implementing an interface that inherits from a ...Show All
SQL Server Stored Procedure being saved in System Stored Procedures
We recently upgraded to SQL Server 2005. We had several stored procedures in the master database and, rather than completely rewriting a lot of code, we just recreated these stored procedures in the new master database. For some reason, some of these stored procedures are getting stored as "System Stored Procedures" rather than just as "Stored Procedures". Queries to sys.Objects and sys.Procedures shows that these procs are being saved with the is_ms_shipped field set to 1, even though they obviously were not shipped with the product. I can't update the sys.Objects or sys.Procedures views in 2005. What effect wi ...Show All
Visual Studio Team System From RUP to MSF???
Hey. I currently work as a Process Engineer at an oragnization where we have teams comprising from 5 to 10 people, from a Project Manager, System Architect, Analyst, Programmers, SQA Engineers and Release Manager. I think after hearing all these roles you have gotten an idea that we follow a rather formall process, in our current environment we have project sites at WSS which is connected with company's SharePoint Portal, and for project management we use Project Server, we have devised a bug tracking solution using SharePoint lists, for requirements management we follow Rationale's model, so this is rather a dis-conected environment, an ...Show All
Visual C# Matrix to Vector3
Does anyone know how to get the vector (x, y, z) data from a matrix (And also how to get the pitch/yaw/roll from it if someone knows that) Found the X Y Z thing.. still looking for a way to get the pitch / yaw / roll from a matrix :) public virtual Vector3 _GetVector3(Matrix _Matrix) { return _GetVector3(Vector3.Transform(Vector3.Empty, _Matrix)); } public virtual Vector3 _GetVector3(Vector4 _Vector4) &n ...Show All
Visual C++ where can i find Matrix manipulation library
Does anybody know where I can find Matrix manipulation library (such as Gauss-Jordan Elimination, LU decomposition, etc.) for programs by VC++.net (2003). Thank you very much! A search for "Matrix Library C++" on MSN Search shows plenty of hits: you should take a look at these and see if there is one that suits your needs. ...Show All
Visual C++ LNK2019 Error FLTK
Hello, Can anyone help me with this error I keep getting I've searched around this forum but didn't see any specific help. This is the code I'm trying to run. I've installed fltk correctly and am using Visual Studio .NET 2003 #include <FL/Fl.H> #include <FL/Fl_Window.H> #include <FL/Fl_Shared_Image.H> #include <FL/Fl_JPEG_Image.H> #include <FL/Fl_Box.H> int main() { fl_register_images(); // initialize image lib Fl_Window win(720,486); // make a window Fl_Box box(10,10,720-20,486-20); // widget that will contain image Fl_JPEG_Image jpg("yarrrr.jpg") ...Show All
Windows Forms Combo Box SelectedIndexChanged event Winforms
hello all, i am using a combo box on my windows form in vb.net. I have filled it from Table in Database like: Dim dSet As New DataSet obj = New DbCustomers dSet = obj.CustomerFillCompany If (dSet.Tables(0).Rows.Count > 0) Then cbocompanies.DataSource = dSet.Tables(0) cbocompanies.DisplayMember = "CompanyName" cbocompanies.ValueMember = "CompanyId" cbocompanies.SelectedIndex = 0 Else End If Now I want to call the SelectedIndexChanged event on this comobo box i.e( cbocompanies) and want to get the ID of the selectedText (which is auto generated in sql server datab ...Show All
