6,934 Topics
 | |
| | [HTML][/HTML] [CODE][color=#0000ff]using[/color][color=#000000] System;[/color] [color=#0000ff]using[/color][color=#000000] System.Collections;[/color] [color=#0000ff]using[/color][color=#000000] System.ComponentModel;[/color] [color=#0000ff]using[/color][color=#000000] System.Data;[/color] [color=#0000ff]using[/color][color=#000000] System.Data.OleDb;[/color] [color=#0000ff]using[/color][color=#000000] System.Drawing;[/color] [color=#0000ff]using[/color][color=#000000] System.Web;[/color] [color=#0000ff]using[/color][color=#000000] System.Web.SessionState;[/color] [color=#0000ff]using[/color][color=#000000] System.Web.UI;[/color] [color=#0000ff]using[/color][color=#000000] System.Web.UI.WebControls;[/color] [color=#0000ff]using[/color][color=#000000] System.Web.UI.HtmlControls;[/color] [color=#0000ff]namespace[/color][color=#000000] lms[/color] { [color=#808080]///[/color][color=#808080]<summary> [/color][color=#808080]///[/color][color=#008000] Summary description for inc_search_books. [/color][color=#808080]///[/color][color=#808080]</summary> [/color][color=#0000ff]public[/color] [color=#0000ff]class[/color] inc_search_books : System.Web.UI.Page { [color=#0000ff]protected[/color] System.Web.UI.WebControls.TextBox Q; [color=#0000ff]protected[/color] System.Web.UI.WebControls.Button Button1; [color=#0000ff]protected[/color] System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1; [color=#0000ff]protected[/color] System.Web.UI.WebControls.Label … |
| | Hello, I'm trying to write a sql statement that would update a record only if a particular row column is empty; else, insert a new record. Is this doable? Currently, I have this update statement: [CODE]//query for additional cars 1 $mysql_query=("UPDATE additional_cars SET clientID='$edit_clientID', registeredstate='$edit_registeredstate', dhtmlgoodies_category='$dhtmlgoodies_categoryupdate', dhtmlgoodies_subcategory='$dhtmlgoodies_subcategoryupdate',caryear='$edit_caryear', servicearea='$lastservice', currentmileage='$edit_currentmileage', todays_date='$date2', … |
| | Hello people :) i'm trying to insert query result into 2 dimensional array i have tried the following way.. [CODE] $query=mysql_query("..."); while($row=mysql_fetch_array($query)){ for($i=0;$i<=$index;$i++){ if(isset($myarray[$i]['array1'])|| isset($myarray[$i]['array2'])){ array_unshift($myarray[$i]['array1'],$row['study_period']); array_unshift($myarray[$i]['array2'],$row['test']); }//endif }//endfor }//endwhile [/CODE] But, it failed i also tried.. [CODE] $query=mysql_query("..."); while($row=mysql_fetch_array($query)){ $myarray=array( array("array1"=>$row['study_period'],"array2"=>$row['test']) ); }//endwhile [/CODE] it failed too since it … |
| | Hello all, I'm trying to build a forum site. The code below works fine but I dont know how to catch it from the address bar. I'm having trouble finding tutorials to help me with this. viewtopics.php [CODE] echo "<tr bgcolor='#6698FF' ><td><a href='viewcomments.php?id=".$rows['topic']."'> ".$rows['topic']."</a></td><td>".$rows['username']."</td><td>".$rows['timestamp']."</td></tr>"; [/CODE] Address Bar [CODE] http://localhost/testsite/viewcomments.php?id=Cowboys%20Dancehall [/CODE] … |
| | So i have this problem with a database. Under a section Date of Birth there are about 110000 entries. There are some that just have the year, for example 1978, I'm wondering if there is a way where it can automatically put in /00/00 after the 1978? so it would … |
 | If my application was designed to generate a "schedule" or list of dates, and I wanted to store those dates in a SQL server as an array, what SQL data type would I pick? [COLOR="Red"]ntext [/COLOR]seems excessive, and I don't think [COLOR="red"]date [/COLOR]would work...any suggestions? |
 | Hi Expert I am working with a project in c# vs.net 2005 and sql express as backend. I have successfully completed the works.i want to connect my application and sql express on lan. I have successfully connected the data base one day before but because of some problem i have … |
| | I have a PHP shopping cart system and it's using MS SQL for the backend. Currently it's using the mssql driver. Now I want to move it to Windows Azure and I'm required to change the driver to sqlsrv 2 in order for it to work there. Can anybody tell … |
 | Imagine my surprise when I logged onto Daniweb and saw a scrolling advert for IBMs Informix database. I've been using Informix for years and it is an incredibly elegant bit of code, and the object extensions you can use are totally unique. I'd always thought of Informix as a secret …  |
| | help please.. how can i store the selected value from my database to a variable in my c# form... (eg. variable=select idnum from tblename)<--- i know i cant do that.. how can i pass its value?? im talking about a specific value from the database. lets say i log in … |
| | Dear All, I am writing a web application based on C#. What I would like to achieve is the following: an application that uses a single, global SQL connection. Which can be opened or closed when querying the db. I think it would be nice to avoid instantiating an SqlConnection … |
| | What is Wrong in this code [CODE]Select * from Studentinfo Inner Join Admission On Studentinfo.Studentid= admission.studentid where Studentid= '1'[/CODE] Please Help as soon as Possible |
 | hi guys, i'm hoping some one will be able to help. i basically want to create website where people can upload pictures and then other people can view them and leave comments iv created the website of how i want it but i dont know how to create the database … |
| | I am new to using sql .i have two table expense statement and revenue statement such as revenue statement accountname debit A 100 B 200 expense statemnt accountname credit X 300 Y 400 is there anyway i can join these two table like this, if so can someome tell me …  |
| | Hi all, I am having some difficulty in finding how to make a Table Valued Function (TVF) work in C# and T-SQL. I have managed to get a Scalar Valued Function (SVF) working perfectly however I have not been able to find any adequate documentation on how to implement a … |
| | a browse and submit button when pick the image and submit , the image name goes to my SQL table and the image it self that the customer pick it copied to my "upload" folder :( my problem is that i only see the image name , so my issue … |
 | [code]"insert into invoice(sno,entrydate,invoicedate,companyname,party,station,purchase,avail,sale) " + values("+Integer.getInteger(head.getSerial().getText())+",to_date('"+head.getEntryDate().getText()+ "','dd/mm/yyyy')"+",to_date('"+head.getInvoicedate().getText()+ "','dd/mm/yyyy')"+",'"+head.getCompany().getSelectedItem()+"'"+"'"+head.getParty().getSelectedItem()+"','"+head.getStation().getSelectedItem()+"',"+Integer.getInteger(head.getPurchase().getText())+",1,"+Integer.getInteger(head.getSale().getText())+")"); [/code] SNO NOT NULL NUMBER(38) ENTRYDATE DATE INVOICEDATE DATE COMPANYNAME VARCHAR2(50) PARTY VARCHAR2(50) STATION VARCHAR2(50) PURCHASE NUMBER(10,2) AVAIL NUMBER(1) SALE NUMBER(10,2) Whats wrong in this query.... I am getting sqlException ....  |
 | hi guys a)I'm working on this project in asp.net and sql server.I would like to host the site im my local iis server for testing purposes b4 i publish.when i import the site to iis it poses some 404 complaining about the web.config file. what i'm i not doing ryt. … |
| | Ok I am stumped. I am inserting the data fine into the table and database so i know its not the config.php nor opendb.php. I used a code like this before and it work, i've only altered the $sql, the td's, and the $rows[]. Table name is hotspots (all lower …  |
| | Hi I am developing an application that has two parts 1) client machine 2) server i.e. (internet web data). i want to access the table on the server (internet) how i can use the connection string. how i can connect to client to server can anybody help me. |
| | I have a query which generates a soccer standings table and although it works fine there I am trying to implement a couple of variations on it but everything I have tried has failed. I have searched and asked many times and for both problems and it seems as though … |
| | Hi Friends i have some problem in update my dynamic text box value for particular id alone, i want to update only the 2 column fields into my database, i have used the below code. i am not able update the fields into my DB. Please help me to solve … |
| | I am not sure I am under the write forum but here is my problem: I have a pretty simple program written that works just have a lot of repeated code and am not sure how to condense it in this situation. The program reads in table names from the … |
| | hello all i have problem : [CODE] string sssql = "SELECT *FROM BooksCatalog WHERE BookID = '" + TB[2].Text + "'"; ds =DBC.Read(sssql); // class that read from sql foreach (DataRow row in ds.Tables[0].Rows) { row["BorrowState"] = "good"; // that not write that in my database here its the problem …  |
| | Hi All, This is the first time I'm using Java to connect to my online MySQL database that is hosted by a separate web host. Following is the code in use: (I've removed the server url, username and pass for obvious reasons. They all work when I use them in … |
 | I have in sql database in table price ,path who leads to images on a Web Server, hava i show image in web page with sql query ? |
| | Hi Guys, I am having few issues testing a software for which I have to develop a front end GUI. Basically, the previous person failed to document on how to run the system and left all the pleasure for me :D Anyhow, the system basically is a web crawler and … |
| | Hello, Could someone help me with this question that I need to complete within 4 days? I have a problem with the insert statment on the code below. This code is working fine by inserting the ststement, but the problem is that the DATE is not being inserted into the … |
| | Hi All, I downloaded the example with SQL db for filtering from the adres below [url]http://www.eggheadcafe.com/tutorials/aspnet/c67c4daa-83c2-4baa-aea4-2c8855527acb/aspnet-gridview-filtering-with-dropdownlist.aspx[/url] And when I tried to run it from VS2008, I got this error "The connection name 'NorthwindConnectionString' was not found in the applications configuration or the connection string is empty" I already downloaded msi … |
| | friends i am new in vb.net -i have a webbased proj. What i need is to connect the vb.net app to an sql server via internet. My projects run fine in a standalone pc. what conn. String should i use to finish my proj? tnx for your concern. |
| | Hi, I am a new in stored procedure and I now do the following function: [CODE] ALTER PROCEDURE dbo.ViewFaultyTbl @id int AS SET NOCOUNT ON; DECLARE @indicator int SELECT @indicator=Indicator FROM FautyScanTbl if @indicator=0 BEGIN SELECT * FROM FautyScanTbl WHERE ID=@id END ELSE BEGIN END [/CODE] Indicator is a column … |
| | Hi experts, I am developing a Windows base application in Visual Studio 2005 C# as front end and SQL Express Edition [that comes with VS .NET 2005] as backend. I have a lan containing three PCS, one as Server and another two as Clients. I want to keep the database … |
 | Hi Some background: I'm trying to create a Server/Client Sync scenario for my application using Sync Services for ADO.NET specifically the LocalCache custom tool which sets the whole thing up for me. My server DB has 5 Tables, all of which are being synchronized to the client application, which now … |
| | using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Shapes; using Business; Guys, I want to populate the DataGridview with a dataset I have created but I am having problem and I would be thankful if … |
| | Hello, I need to maintain this asp.net web application. I have 1 month of experience in asp.net C#. This portion of the web application using technology LINQ to SQL and Ajax. This seems to be a simple change, but could not get it to work so far. I need to … |
| | see this is the code that is written in c# in visual studio 2005........In visual studio w can connect sql(not mysql) with c# and can even see the sql table visually......... can we do that similarly in java in netbeans7.0..... how can i connect sql with java.......do i need to … |
| | I am in desperate need of some guidance here. Any suggestions or ideas would be very much appreciated! Is it possible to have a relationship based on two columns? For example: The table "Parents" has columns: ParentID (PK) The table "Children" has columns: ChildID (PK) ParentID The table "Addresses" has … |
 | Hey guys, As you can see below I am trying to add row of data to a table called tblOut. When i execute the code, it works without a single error message but the problem is I dont see any new record when i preview my table data. Can anyone … |
| | Hello Friends, I have an ASP.NET application and SQL Server as its DB. When the database was small everything was fine, as now the DB contains huge amount of data. It seems it skip out some calculation. The details- Application: It calculates the commission of particular agent (like affiliate) for … |
| | hi i have 100 records in my datatable .Here i want to insert these records into SQL without looping . thanks |
| | I have uninstalled sql server 2005 but failed to uninstall SQl Server 2005 Management Studio Express. To install Sql Server 2008 Management Studio I need to uninstall Sql Server 2005 Studio otherwise I can't proceed further! Can anybody suggest an easy and clean way to uninstall SQl Server 2005 Management … |
| | Hi, I have some difficulty with my 'select' In my select/menu, I display all the options come from a table (table_db_email) in my database In this table ([B]tb_code_prmtn11_email[/B]) I have two field : [B]fld_email_id fld_name_email[/B] It works here is a code [CODE]<select name="email_adress_menu" id="email_adress_menu" class="valid" onchange="submit()"> <?php echo "<option selected=\"selected\" … |
 | Hi im new to sql server 2005 and i have a big problem. i want to delete a record having the same name and surname Here is my table named Students StudID FirstName LastName 1 Erwin Lopez 2 Archie Lopez 3 Lobanz Lopez 4 Erwin Lopez 5 Chie Lopez 6 …  |
| | I am getting this error when i try to connect to the server... Hot to rectify it... "This version of Microsoft SQL server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)  |
| | Still working to figure this stuff out :) My question is, is it possible to set a combination of columns with a unique constraint? For example: [CODE] ColumnA | ColumnB ----------------- Value1 | Value2 <- OK Value1 | Value1 <- OK Value2 | Value1 <- OK Value2 | Value2 <- … |
| | Hi friends am trying to develop a software that can store biometric input like a finger print to my Sql server using c# how can i do this. thank you in advance |
| | Hi I am php coder and new to asp. I am trying to build a simple login page using asp and the db connection works fine. When the user submit the form and at the sql query section i am getting the following error "Microsoft OLE DB Provider for ODBC … |
 | Hello Group, I'm running with MS XP Professional, version 2002, service pack 3. Many of you may well have already heard that there are some problems being encountered by some users with trying to install the update for SQL S/Pack 3. KB970892. As I do a lot of traveling with … |
| | Hi Everyone, I'm having a hard time on using Transaction then after that I need to use sqldataadapter. When I tried the code below I'm having an error "[COLOR="Red"]ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The …  |
| | hi all, please help me on this... Is there a way to get the SQl View's String Command used to create said View? For Example, I have a View named tryView, now I want to get the string command used to create tryView like this one... [QUOTE] CREATE VIEW tryView … |
The End.