6,934 Topics
 | |
| | How do I go about do something where like every 12 hours, the webpage will add 5 to a row in Mysql? Do i have to use like unix commands or something? :0  |
| | HI, guyz Wordrin if sum one could help! at the moment got code which allow user to input and display in result. but mean time wana allow user to delete current input data by providing delete button next to displayd data.......... plz could some one tell me how to,what commend … |
| | This is the error when i try to execute my code "Procedure or function 'Get Customer data' expects parameter '@Name', which was not supplied." [CODE]objCommand.CommandType = CommandType.StoredProcedure objCommand.CommandText = "GetCustomerData" Dim ObjParam1 As New SqlParameter("@Name", SqlDbType.VarChar, 2000) ObjParam1.Value = ID.ToString() Dim da As New SqlDataAdapter(objCommand) Dim dt As New DataTable … |
| | hi i need an vb.net program for access database, in an sql query for append (single column) .txt file into existing .mdb table , i used this code but is not working [CODE] Pth2 = My.Application.Info.DirectoryPath STTConn2.ConnectionString = "Provider=Microsoft.jet.oledb.4.0; Data Source=" & Pth2 & "\LugatWordsOk.mdb; User Id=admin; Password=;" STTSql2 = … |
| | Hi i have a problem, i make a form with one button and i want to make in c# (windows Aplication) the follows: when i click in button i need to connect in my SQL Server. How can i do that??:?: |
 | I can't figure out what I'm doing wrong here. I want to allow the user to name the database on their own. Can you use parameters in a situation where the command is simple like: [CODE=SQL]CREATE DATABASE @DatabaseName[/CODE] I've been trying forever and it just keeps creating a database called … |
| | Where should I keep connection object to database like ISession or SQLConnection? What's the best solution and why ? Is it Application, Session or Items ? |
| | hi, I am a SQL Guy, I like reading SQL Server books, Please suggest me some books which teaches advanced topics in SQL Server not just teaching the known things. |
| | I search through the web and I only found out how to concatenate. I have a checkedlistbox that is a list of Authors, it is included in my ADD BOOK form. Take note that a book can have many author so I need checkboxlist. Instead of having this in my … |
 | Hello I'm having trouble solving the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( )' at line 1 I have a php script which I've written in PHP6 which creates … |
| | hi.... i've created one ssrs report it works good im my system.. i.e http://localhost/reportserver$sqlexpress but how should i execute in different system... if i enter the system name then it is showing page cannot be displayed.. i.e http://sys1/reportserver$sqlexspress (page cannot be found) please help me.. |
| | hi, how do i get latest transaction from sql database. All the records is saved in sql database and i use different application to grab the data from sql base on transaction. I use SELECT statement but i don't know how to make it unique variable/ID. 1st user might have … |
| | hi.... as u all know about ssrs reports... now i'm using the crystal reports and i want to go through ssrs reports can anyone answer the following question. 1)what is the need of ssrs... 2)and why we should use ssrs.., 3)what are the advantages 4)what are the disadvantages 5)how it … |
| | hi... to all the following code is to deploy the reports programatically... i've one problem .. by using the filestream it takes more time to load the reports.. hence burden on server.. is there any option or any solution to make less burden on server.... one more thing the records … |
| | GOOD DAY! I am working with a project and i need to have a back up database feature. how can i do this? I've read a lot of forums and they suggest to use SQLDMO but when i test their codes its either generating error or does not create the …  |
| | hi... to all i've created ssrs reports local following is my code.. public void source(string tbname,string Rptname) { ReportViewer1.Visible = true; string myQuery = "select * from " + tbname; SqlConnection myConnection = new SqlConnection(ConnectionString); SqlCommand myCommand = new SqlCommand(myQuery, myConnection); myCommand.Connection.Open(); SqlDataAdapter da = new SqlDataAdapter(myCommand); DataSet dt = … |
| | Hello, I have a lot of excel sheets which columns are slightly different, i want to import all of these sheets (one at a time) into ONE SQL TABLE. I'll give an example : Say ive written the required program and called it Excel2sql converter. So Excel2sql takes an excel … |
| | Hello friends! I am creating a report, Abstract of Bid/Canvass, which will show all the supplier who bids. This also show what item is awarded to a certain supplier through showing the item row number and ranging it like 1-5. I've already created stored procedure that will show the range(s) … |
| | hye fren...i'm using asp.net and sql express 2005 right now.....my problem is how i want to select 2 table from the database because i'm using a gridview......?anyone?thanks in advance..... |
| | Hello I had a question about MS-SQL. I am trying to write a query which will select a group of values from several tables (prodId, Amount, BreakLevel, TotQuantity, Price) There are several amounts associated with different break levels. i.e. a break level of 15 might get an amount of .10, …  |
| | According to Codd's Tweleve rules which are considered as a basics of the relational database system, which one of the following three systems: Oracle, DB2 and SQL server is most applied and relational than the others? Please give me your opinion and why.  |
| | I have this simple script: [PHP]<?php // MySQL Connection mysql_connect($sql['host'],$sql['user'],$sql['pass']) or die("Unable to connect to SQL server"); mysql_select_db($sql['data']) or die("Unable to find DB"); // Getting rows $select = "SELECT * FROM table WHERE uid = '". $_POST['uid'] ."'"; $data = mysql_db_query($sql['data'], $select) or die("Select Failed!"); // Query results $row = … |
| | I have a file uploader in a web page which allows to upload excel files only, hwat I want to do is in the code , to open the excel file and get the values in the excel file which Is in different cells to the mdf file in visual … |
| | I am a bit (well, actually a lot) confused with how exactly I should use the Dispose() method on SqlConnection object in C#. First let me tell you what I have learned so far (I've been reading a LOT on the subject for the past 24 hours, and I'm still …  |
| | I have a query that has two counts in an if statement. I need the query to return all values even if they are null once equated by count. I have tried the NZ function to no effect. Any help would be greatly appreciated. [CODE]SELECT REPRESENTATIVE.Country_id, IIf([CONTESTANT.Team_id] Is Null,COUNT(*),COUNT(*)-1) AS … |
| | I have created a Java program which scans a given folder and creates a .txt with a list of names of all the files in that folder. I want to create a table on MYSQL server on a website and fill it with the names of the files given in … |
| | In my ASP.NET project i have 3 web forms. Login.aspx, Signup.aspx and Default.aspx. I'm using Custom Membership Provider for the login and signup controls. When a user logs in a sessions is called. How can I save all the session variables and values into MS SQL and that particular user's … |
| | Ahm. after my problem about editing and stuff. here's now another problem. i'm updating multiple data on my database i patterned the codes in my previous post and after i've done editing here's what happened: [COLOR="Green"]mysql error You have an error in your SQL syntax; check the manual that corresponds … |
| | I have created a login system based in PHP and MySQL, where upon registration, users enter the information required in the form. However, there is another page where they can review their information once they have logged in. I am new to PHP but I would like to know the … |
| | Hi all, I have ben tring to write some code that will help protect my forms \ data input I have wrote the following for anyone to use \ comment \ edit and improve. Im new to php and have read alot about securing data input from sql injection. If … |
| | hye friends..... i need your help.....does anyone know how to select 2 databases simultaneously?i want to select certain data from database 1 and database 2.please help me for this....thanks in advance....  |
| | |
| | Hello everyone, I have a little bit problem here.I have installed PHP version 4.4.1 and it's working well. I want to connect PHP with MySQl . I have also installed MySQL and it installed successfully. Inorder to configure PHP to work with Mysql, I did the following changes in the … |
| | Not sure if this actually qualifies for this forum so please by all means move this topic to the appropriate place if it isn't. I'm writing a C# Windows Application (not a web app) and it uses either an SQL or Access database to store its data for multiple network …  |
| | i created a program in c# with database sql server 2005.it worked in windows xp.but i don't know how to install my software in windows 7 .i coudn't install sql server2005 or sql servr 2005 64 bit in windows 7. help me plz ..very urgent  |
| | Hi, could some help me . as i want to know how to delete last record. currenlty the code im using its based on two different pages, one for update/display record and second for deleting record. but sum reason this code not working for me . add.php <?php include("connect2.php"); $authorname … |
| | please guide me to connect java project to sql.Code snippets are welcome.  |
| | We are writing a program in JAVA that thru a series of questions helps the user build a computer. This is being done with Radio buttons. We are wanting to know if it is possible to store the selections as objects in the database. So that is the user wants …  |
| | Hi Friends I have a challenging task in SQL (Oracle). Let me know if you have any answer. I have 2 tables. 1. Dept 2. Employee Dept [B]Dept_No Dept_Name[/B] 10 Admin 20 Data Warehousing 30 HR Employee [B]Employee_No Employee_Name [/B]Dept_No[/B] E01 Sangeetha 10 E02 Michael 10 E07 Immanuel 20 E11 …  |
| | Hi i want my formatted output should be in a straight line : 1 2 3 4 5 6. Is this possible in PL/SQL ? declare n number:=0; begin loop n:=n+1; dbms_output.put_line( n ); exit when n>=6; end loop; end; / Output : 1 2 3 4 5 6 PL/SQL … |
| | hi i am using oracle 9i and now a days i am learning sql. due to some problems i have to change my system and i will install oracle 9i in my new system, but problem is that after installing i need all that old tables that i have created … |
| | Hi guys! I have a JTable updated from MySQL. I can successfully insert a row in JTable using SQL statement "insert into...". However, when I execute a delete statement, then JTable is not updated. Please, help me to find an error. [CODE] public void actionPerformed(java.awt.event.ActionEvent evt) { SystClasses.FilterClass.tableModel.initDB("85.254.219.164", "employee_record", "liana", … |
| | Hi All I am getting above error when I am trying to build the project.Could anyone help me out ? Error: 'NCCDAL.clsDataAccessLayer.fncreateCmdObj(string, System.Data.SqlClient.SqlParameter[], System.Data.SqlClient.SqlTransaction)': not all code paths return a value' Code: public static SqlCommand fncreateCmdObj(string spName ,SqlParameter[] commandParameters,SqlTransaction transaction) { SqlCommand command ; try { command = new SqlCommand(); … |
| | The joke: An SQL query walks into a bar and sees two table, walks up to them and says "Can I join you?" The riddle: Halloween == Christmas - Why? |
| | I have the following data in a field in my SQL table. I want to break up the data in this field so I can use it in reporting: Sample records: Record 1: Player: (265613) Miss Linlde M Simonds, Promo Adjusted -> 10.00, Beg. Bal -> 0.00, End Bal -> … |
| | HI Friends i want to do the connective in C# window application with sql server and in that even i want that if client put information in text box's and click on submit the information should go in sql server db and then again if he is putting same information … |
| | G'day guys, My boss has just asked me to develop a small CRM system. Now, writing a simple SQL Insert is not something im a stranger to, however for some reason i cannot seem to get this working. I've included all necessary libraries, and tested the actual sql statement in … |
 | So I have a basic database of books set up. I am trying to use PHP to query the db and send back the results. I can sort of get it to work, but not working how I would like. The issue is that the search term that queries the …  |
| | Hello everyone, i'm new here but i've been having a problem lately with a sql query inside the code i'm writing, and i don't know what else to do. I've been trying to retrieve data from a table, and i want to use a variable for the "where" field in … |
| | Hi all, Fairly new at SQL, and running into the following problem. I am trying to create a query to count the number of unique fields in a column and display, but can't seem to get it right. For example, each day there are x number of entries from y … |
The End.