We have a request tracking system where system automatically takes the action like closing, abandon, escalate the request after certain duration. How to automate the actions?

Hi, I'm trying to use filestreaming (SQL 2008) with Visual Studio 2008 to load a file into a folder. I have a window that allows the user to select the file he wants to load into a SQL Server table called Available_files and then my code l ...

how can i use classes on the program i am making? any help please? [code] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text ...

Hello Quick App Maker Studio L - Free IDE for develop Cross-Platforms Gui databases applications. Quick App Maker Studio is new multi-platform IDE for creating applications for JVM. Gui designer suport drag and drop object into Forms ...

I'm new to this so here goes. I have a table that has latitude and longitude degree coordinates and I'm trying to do an SQL UPDATE in the third column and convert the latitude and longitude coordinates into MGRS in the MGRS column. I ha ...

Hi, I'm currently doing an ExecuteCommand within Linq to SQL and one is working but the other is not. This one does not work. dc.ExecuteCommand("Update {0} Set {1} = {2} Where {3} = {4}", cha.Change_Table, cha.Change_Field, ...

I have a Windows Form where 225 buttons are added at the run time, also I have the database which have two columns (first column is the SeatNumber with the datatype nchar(4) and the other column is IsBooked with the datatype bit). The SeatN ...

Hi everyone I have a problem when I try to get my database done in Sql server management 2008 into visual studio 2008 with Sql authentication. With Windows authentication it works just fine, but not in mixed mode. I have right-clicked an ...

Is it possible to get information about whether a child table has reference to a parent table through a certain record? For example, tblParent has a record whose primary key value is 5. I want to know whether tblChild_A, tblChild_B and tblC ...

Hi I'm using SQL Server 2008 R2 Express. In my application I support backup of database. This works perfect except from the fact that it always saves the file to computer that SQL Server is installed and not on the PC the application run ...

Hi I'm using c#. I have create a stored procedure in my SQL Server 2005 db for deleting clients. The reason I used a stored procedure is because in order to delete a client I have to delete several other records from different tables tha ...

Hi, I'm learning ASP.NET and C#. I've been trying to figure out how to have an asp.net page with 2 text boxes e.g. Name & Address which connect to a SQL database. I would like to have a button on the page which saves the text entered ...

Hi I have a question when doing a winform application which I want to install on another PC. If I have a connectionstring like this "Data source=.\SQL" and the other PC have default setting SQLEXPRESS (mine is sql express ed ...

I am doing this way but can't get insert's [code] SELECT REPLACE (REPLACE ([text], CHAR(13), ' '), CHAR(10), ' ') AS QUERY FROM sys.dm_exec_cached_plans AS p CROSS APPLY sys.dm_exec_sql_text (p.plan_handle) WHERE p.objtype = 'Adhoc ...

Hi, I have problem with grouping in RDLC report. the sql query is: select headstruct, struct,name,surname rate from someTable; which return data with the following structure: headstruct1,struct1,name1,surname1,0.1 headstruct1,struc ...