2,935 Topics
| |
I have this code that works fine: [code=c] protected void ButtonImgTextToDB_Click(object sender, EventArgs e) { string ID = TextBoxStartPictID.Text; string Rubrik = TextBoxHeadLineStart.Text; string Text = TextBoxTextStart.Text; SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE StartImage SET Headline ='" + Rubrik + "', Text ='" + Text + … | |
Hi, I'm newbie in IIS and MSSQL using php. I got problem connecting to my host and selecting database. Could you please help me how to connect using php. Mar, | |
I have a table in SQL Server with the following structure: DateRated, Parameter, Rating, UserID Sample Data DateRated Parameter Rating UserID 10/01/2010 Flexibility Good User101 10/01/2010 Efficiency Average User101 10/01/2010 Value For Money Below Average User101 I want to create a query that will make it like this: DateRated Flexibility … | |
Have you ever forgot or lost your SQL Server sa password? Did you hava any ideals to reset your lost sa password? Or choosed to reinstall MS SQL Server on your PC again? I once forgot my SQL sa password and I reinstalled SQL Server at last, because I failed … | |
I've been asked to create a new front end to our reports that were built using reporting services (SSRS). the front end is dynamic and changes by report, and it will prompt for the parameters of the report. Help me someone!! I don't even know where to begin developing this … | |
I have the following sql query: ET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE YourProcedure AS insert into msbtotal.dbo.newclients SELECT tcms_members.dbo.memberdata.* FROM tcms_members.dbo.memberdata left outer join msbtotal.dbo.memberdata on tcms_members.dbo.memberdata.id = msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id is null GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO What this does is … | |
This is my first SQL project. An Access database was converted to SQL Server 2005 Express using the DTS utility. The old AutoNumber fields were automatically converted to int identity not null fields. However, when attempting to INSERT a row, such as the following ASP code, [CODE]Conn.Execute("INSERT INTO tblAdmin3 (fldA3Username,fldA3TimeIn,fldA3Date) … | |
Hi, I'm new to VS 2008. And as a uni project, we had to create a doctor surgery databases as a group. However, when one of my group member sent me part of her work and when I tried to open it in my VS 2008, I failed to open … | |
Problem I have is that the following code works only if the user tabs out of the field, (or moves the cursor to another field in the same form), if the cursor is still at the end of the date text, none of the error traps catch, but I get … | |
This is a sql datatype problem Hello I am a junior programmer and new member of this forum I want to ask a question I have these two columns in sql 2000 server trx_date char(8) trx_time char(6) And now, I imported this database to sql 2008 and want to copy … | |
hello, I am facing a problem with the following code: select year(regdate) as [Year],month(regdate) as [Month], CONVERT(varchar(3),regdate,100)as inmonth, count(*) as incount, cast(sum(amt)as decimal(20,2))as insum, count(case when nbr <>' ' then amt else Null end) as incountpo, SUM(case when nbr <>' ' then (amt)else 0.00 end)as insumpo, --cast( (Insumpo / InSum … | |
OK SQL documentation sucks. I know that, I've known that for years, but it can be helpful and useful at times, so I use it. I thought I remembered correctly what "~" did, but looked it up anyway. I'm reading the usual @#$%, but getting the basic information (While thinking … | |
i have create a registration form in asp.net & sql server..It's working good.. i generate ID for user when they click "sign Up" button..(the ID will appear in drop down list at form-ID not saved yet into database).. the problem is when several user register at same time and click … | |
I have a SQL DTS job that runs nightly. What this is supposed to do is to copy from Database1 to Database2 and to overwrite anything that was in Database 2 previously. This was set up as an import/export job. The process runs nightly as it's supposed to but apparently … | |
Hi, my name is khalil and im hosting a online game which using mssql! in databases i got database called gamedb i have "account" as table in account table there is a column called GM so this column is my problem! when guy account got GM Column number 0 mean … | |
Hello Experts, I have following tables: Table_1: C_ID Inst_No Paid_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 13/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010 [/COLOR] Table_2: C_ID Inst_No Today_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 12/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010[/COLOR] Now, from the above two tables I want to display only … | |
Hi, Iam using ms sql server.Iam using a hospital management system .I need to find the last visit of the patient,only the last visit date,How can i do that?I think that it is as same as the latest published text,one of my friend told me,But how can i do that? … | |
i am trying to install developer edition 2000 on xp, but after clicking the autorun file nothing happens, though two processes appear in windows task manager, these are 1) sqlstp.exe 2) setupsql.exe but both are using '0%' cpu use and taking some memory. i tried so many things..really fade up. … | |
how to insert username and password into database with connection in c# please give me reply sir | |
I have kind of the same question as Rambomst, except I need the query string to populate the values for the IN statement this is the code I have but it's not working and I'm stuck and am in DIRE need of an answer: <% Dim rsAuto__print For i=1 to … | |
I am trying to make a query which will search for the ID's 5, 6 and 23(Those are just random numbers and could potentially be more). Rather than making a loop in my code to query each separate ID I was wondering if it was possible to query them all … | |
hey i need to know whether the below code is correct [CODE] string query = @"Select p.ID,p.Phase From Proposal as p, Negotiation as n,contract as c Where c.CID=con.CID and c.NID=n.NID and n.ID=p.ID and n.Phase=p.Phase (Select con.CID From Contract as con Where CStatus='Active')"; [/CODE] there is an error coming saying "Incorrect … | |
Here is my code. INSERT INTO employees (1.Last_Name,2.First_Name,3.Title,4.Title_of_Courtesy5.,BD,6.Hire_Date,7.Address,8.City,9.State,10.Zip,11.Country,12.Extension,13.Notes,14. Reports_to,15.Photo); VALUES (1, 'Smith', 'Janet', 'Sales Manager', 'Mrs.', '12-30-1974', '08/05/2000', '123 My Street', 'canton', 'OH', '44720', 'USA', '4632', 'MBA from Ashland University', 'Andrew Fuller', 'No Photo Available Yet'); Here is error message...Msg 102, Level 15, State 1, Line 2 Incorrect syntax near … | |
Hi Forum, I need a funtion to retrieve data from more then one Table. The tables are not related.Field names are the same in all tables. The table list I get from a view and i need to go through this list and pull out any records from the different … | |
I'm newbie in MSSQL, I would like to ask what web server should i use? Should i install IIS in my PC? I appreciate your suggestions... Thanks.. Mar.... | |
Hi, Consider, that I have 5 fields, In which first four fields has same value and fifth one has different value. If I retrieve these records from table it should shows first 4 fields only once and fifth fields should be appended. How can I achieve. Eg: field #1 field … | |
hi please i need help with the query using the values from the combo box and the result will show on the data grid sp [CODE] ALTER procedure [dbo].[sp_GetReservistInfo_ByDesignation] @Platoon varchar (50), @Company varchar (50), @Batallion varchar (50), @Brigade varchar (50), @Division varchar (50), @FirstName varchar(50), @MiddleName varchar(50), @LastName varchar(50), … | |
Hi All, I have a query that returns rows from a message table. Im basically trying to get the latest MESSAGE_TYPE for the user based on when the message was sent (MESSAGEDATE) At the moment I have a query that gets me almost what I want. It returns something like … | |
The End.