6,934 Topics
 | |
| | Hello everyone, I am using [CODE]ExecuteNonQuery()[/CODE] to execute a SQL command that inserts data into a SQL Server 2005 Database. I want to return the number of rows affected. I've read that this method returns the value, but I can't figure out how to access it. Help is very much …  |
| | Hi. I'm having a problem on deleting a record using a function on SQL. DELETE FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG' This query shows and error saying: Cannot group on fields selected with '*'. I tried adding a specific field, like this: DELETE ServiceID FROM tblServices GROUP BY ServiceID … |
| | Okay, I created an application that used SQL. It works perfect on the computer that I compiled it on, but, when I release the application it shows an error like: "Cannot open this application, missing components" ... Also, on the computer I compiled it on, it shows the database file …  |
| | In my form I have 5 text boxes where the user will be updating roughly 21 tables in the DB. Do I have to keep building a new sql connection for each event? Or is there a way for me to only have to write the connection code once? Basically … |
| | Hello all. The Java Date and time classes are difficult. I think I have to use java.sql.Date which is a sub class of Date but is not a date unless the time is normalized to zero. so I've heard. I would like to work with my studentDOB first by collecting … |
 | afternoon all hope someone can help, i want to populate a report and print it directly without the user hitting the print button. i have this working in a diffrent project but for some reason it wont work in this one. i get the error missing parameter, on the last … |
| | |
| | i wanna enter a value passed by javascript function to the database. is there a way to do that? thanks. var eng = 0; var nothome = 0; var nointerest = 0; var callback = 0; var booked = 0; function myFunction(i,txt, elemid){ var plural; if (i != 1) plural … |
| | I was asked to create a report similar to a gridview in asp.net for a windows form application. I don't really have much knowledge about reporting, especially not in VS 2010 unless its a gridview or something similar since it will suffice and noticed that you could create a report … |
| | good day guys! anyone can help me about this.. i need to create a login form with database (users.mdf) im newbie in c# .net i manage to create a connection my problem is the code behind the Login_Button thanks God bless |
 | hi I want to fetch data from sql and use them to make a new data I really like to store the records in variables and maybe do some operations on some of them , but the main point is to update three tables in ways that are not the … |
| | Hi Guys, Can you please let me know if there is a sql command to list PK , Child and Parent of an identical table in oracle? Lets say I have a table called City , how can I get those information using SQL? Thanks |
| | hi i get an error saying cannot login to the ms sql server, i did all the things restarted the server, and changed the authentication mode to mixed mode nothing doesen't work, i created an another login with mixed mode authenitication the same error saying login falied to user sa … |
| | hi there, i was doing some changes to the ms sql reporting server and after some time i get an error saying "the request failed or the service did not respond in a timely fashion. consult the event log or other applicable error log for details" i restarted the server … |
| | i have these two tables connected to each other [B]tblOrder[/B] ID - int (P.K.) DateTime - datetime TotalPrice - money StaffID - int OrderTypeID - int ReservationID - int (F.K.) [COLOR="Green"]can be null[/COLOR] Paid - bit [B]tblReservation[/B] ID - int (P.K.) DateTimeReservation - datetime NumberOfPeople - int DateTimeOfEvent - datetime … |
| | guys i'm usiung mysql Server version 5.1.36 and i wanted to use this stuff ' , ),{ in my input , but its always coming out an SQL Error for me when i use String Type also still got the error , i used text Type got SQL errors, i …  |
| | Hi guys, Can you please let me know how I can assign the result of a simple SQL query into a string? Let's say I have a query like: [CODE] string cmd = "Select FName From Emp Where EmpID = 20"); OracleCommand oc = new OracleCommand(cmd, oraConnection); [/CODE] As you … |
| | Hi, I am new to SQL and just trying to self teach myself... I have written the below script and I am recieving an error. If anyone could help this would be much appreciated... [CODE]SELECT (CASE WHEN SL_PL_NL_DETAIL.DET_NOMINALCR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALDR ELSE SL_PL_NL_DETAIL.DET_NOMINALDR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALCR END)][/CODE]  |
| | Hi How can i create a new sql database at runtime Can any one help me |
| | hi i have some problem with my sql code that the code : [CODE] SELECT * FROM MenUsers,WomenUsers [/CODE] MenUsers(Table) and WomenUsers(Table) whats the problem with this code? thanks.... |
| | Hi, I am fetching data from the database.but I want to fetch it in proper format on PHP page. Suppose i insert some data like. 1)chair 2)bed 3)sofa n when i fetch it comes like that 1)chair2)bed3)sofa But i want to do in proper format. 1)chair 2)bed 3)sofa Need suggestion? |
| | Hello Everybody! My problem is connected to the SQL Server Enterprise Managager. I worked with it for a day testing a database attaching/detaching it and after I closed the Manager the following problem occured. The local database seems to be dissapeared. However, the applications through the network reach it because … |
| | I cannot figure out why my update statement will not work? I figure it has to be something small that Im missing. [CODE] private void button2_Click(object sender, EventArgs e) { string strconn = "SERVER=15.5.7.9;User=sa;password=JFK3G785!340b;Database=addressstagingtable"; SqlConnection conn = new SqlConnection(strconn); conn.Open(); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; …  |
| | This is my code to save values in MS access...but when i click on save it shows "INSERT INTO STATEMENT error" Plz som1 help!!!! [CODE]Private Sub save_Click() 'Text4.Text = cmbCustID.Text 'Text3.Text = cmbLocation1.Text 'Text5.Text = cboSize1.Text Dim temp As Integer 'On Error GoTo eror blnerror = False myValidation If blnerror …  |
| | So, I'm a tech writer, not a database guy, but I've been asked to develop documentation for my company's databases. This means I have some questions. It seems obvious to me that there must be some SQL documentation tools out there, but I have no idea what is used for … |
| | my table structre like this ID nAME 1 Mumbai,Pune,Chennai i want output of name like this Name Mumbai Pune Chennai pl help m 'new to sql Thanks in Advance |
| | Hi all, This is ridiculous they teach so much at uni except what you need to know to program :-/ haha. This is actually gonna be a 2 part question but I'll do it one at a time. So I'm developing a small program for a company, this company has … |
| | I would like to develop a database system using ms sql server 2005 express or 2008 express edition where the data may store in other than english language into tables. so i did it using mysql database but not working in 2005 express edition. Is there any solution? |
| | ProductID | id | TaxDescription| 2009001 | 1 | Excise 2009001 | 2 | Edu Cess on Exc 2009001 | 3 | S.HS.EduCess-Ex 2009002 | 1 | Excise 2009002 | 2 | Edu Cess on Exc 2009003 | 1 | Excise 2009003 | 2 | Edu Cess on Exc 2009003 … |
| | eu preciso de puchar somente um valor de uma tabela do sql, que eu estarei usando este valor para definir os usuários as roles, irá funcionar assim, o usuario loga, então é criada uma conexção no banco de dados e nesta conexão ele verifica em qual role este usuario esta … |
| | Hello, I can't figure out what is wrong with this code. I poseted here in the PHP forum because I believe that is where my problem lies. I have a customError script that extracts the last 5 errors from the database and compares them with the current error that is … |
| | Hello, I have not used Sql server. I have microsoft sql server 2008 installed. but when i click management studio, it says evaluation period expired. I can download sql server 2008 r2 developer from my university site. Should i go ahead and download sql server 2008 r2 developer and uninstall … |
| | Hi, I got a crystal report with:- main report subreport(Item_A) subreport(Item_B) There is a limit for the subreport to show only 5 record, if there is more then 5 records it should go to a new page. I have been trying to do this for 1 week, i tried so … |
| | HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in … |
| | following is my code [CODE] namespace Test1 { public partial class Form1 : Form { string emp_code = ""; public Form1() { InitializeComponent(); } private void Uploadbutton_Click(object sender, EventArgs e) { openFileDialog1.ShowDialog(); filenametextBox.Text = openFileDialog1.FileName; }//Uploadbutton_Click private void save_to_DBbutton_Click(object sender, EventArgs e) { SqlTransaction transaction = null; SqlConnection connection_string = … |
| | Hello friends. :(I have a problem but i don't know how to implement a solution. The problem is that the HDD's from two Windows Servers got corrupted [COLOR="red"](1.- Site Server, 2.- File Server)[/COLOR] and all the files PDF's and the main site(ASP) were unaccesible for a while, now i recovered …  |
 | hi guys i've stored images in sql server. how do i retrieve the images and displaying them on the same page that sends the request. i kinda figured how to retrieve the images using the [CODE]file.outpustream [/CODE]. just need to know o i display the image using an image tag. |
| | I am trying to connect to SQL SERVER 2008 from vb.net but failed with Error 40. If I try to connecton to server\sqlexpress, error 26 is raised. step by step guide or tip would be helpful.  |
| | I feel guilty about posting again but I need help again and I have tried other sources of help e.g google and asking someone who is familiar with vb.net but still can't find the solution to it. It must be another simple fix but I cant find any reference to … |
| | I return 30 tables or so from sql in a stored procedure. In the stored procedure I select these tables via... [CODE]select * from myTable1 select * from myTable2 select * from myTable3[/CODE] etc. These tables lose their sql table name when returned in a dataset and have default names … |
| | Looking for an answer about how I can use relations in my DB, when a link is clicked. I have the main navigation in the top of the page, the table is called:"SUBJECTS", primary key is ID. I also have a local navigation in the left side of the page. … |
| | How to fill a combobox with a data stored in a table in sql server?.... Can we use stored procedure to do so? I tryed this code but it keeps giving an error message: "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll" What does that mean???? My code: Private … |
| | Hi Everyone, I have integrated a Google Map on my website, which is working in good order. The maps data such as location lat/lng is coming from database. At present all the location markers are appearing on the map. I have a php page which draws out all the sql … |
| | Hello everyone! I have field in database table that is image type. I have to create model for this table (mvc3) and I don't know which data type to use. Any hints?? |
| | Hi, I'm a bit new to SQL and this is my question... Do I need to filter user input that has no connection with SQL database, e.g. $x=$_GET['pageno']; if ($x == 'help4') { print "This is help page no4."; <some mysql queries goes here> } |
| | This is old college assignment am doing to sharpen my sql skills, its cat test centre and this funtion is checking if the mechanic is available on certain date which is input from user in the anonymous block. the problem i m having durning testing is that the function result … |
| | Hi, new to AJAX, trying to figure out how to do a very specific thing: I want to have a textarea update a database column and then pull down the info from that column and display it, without refreshing. I'm using JQuery and AJAX and PHP and SQL to do … |
| | hi..im doing a C# windows form application in visual studio 2008 and for the database im using SQL EXPRESS 2005..i need to create a crystal report. my question is when i start creating a new crystal report, using wizard, i get 1 window where i have to choose Data: i … |
| | SELECT DISTINCT City FROM Persons this query is for finding distinct(different) value. how to find duplicate values which are not find by Distinct query.i.e repetitive(duplicate) values. |
| | I am getting the value of a datetime picker and add it in the database but it is throwing an exception saying : [COLOR="Red"]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime. The statement has been terminated.[/COLOR] This is my SQL Statement … |
The End.