2,570 Topics
 | |
| | Hi, I'm writing a VB.net application that runs off a SQL database. If the application can not connect to the database or the connection has not been set up I'm giving the user the option to create the database on the SQL server instance of their choice I then create … |
 | Hello there, I need help to create simple rank system 1st thing I need is how to number the players in my database from 1 to ...... so if I create multipage in each page there is the actual rank for them 2nd : I need to create change indecator … |
 | I am writing a program for a company and would like to limit how many users can use this program at one time. IE if they have a 3 user licence when the 4th user tries to log in it wont let them. I have no idea how to accomplish …  |
 | if i have table in database(sql server) and has 1500 records and i run 2 applications(at same time) that will retrieve 500 records each so how can i do this app1 will retrieve first 500 records app2 will retrieve next 500 records means no over lap SET Transaction Isolation Level … |
| | Hi Thgin i seek is to create a connection (android) to the latest postgresql 9.2 database. Theat is running on a distant server. Can i Do it? Is postgre 9.2 JDBC driver fro andoid out? & little bit distant question. If the prevous is doable. How i an write tet …  |
 | Hi all, I have a table called tblCPI that holds approximately 160,000 records that have to do with Canadian CPI. I have created a process that did the initial data load into it and now I need help figuring out how to update it according to date values. For instance, … |
| | i have three db tables products product_id- Name 1 | hairoil 2 | lotion 3 | cream Countries country_id- Name 1 | UAE 2 | France 3 | UK Now i wanna that when select multiple countries for one product from Html form, then in third db table should insert … |
| | Hi, An event proxy is responsible for reading in the input file (see details below) and forwarding events (updates and queries) to either a query client or an update client. All events (i.e. including updates, queries, and system failures etc) are specified in an event file which is called Input.txt … |
| | How can I avoid negative numbers from being inserted in my database table? i have a code that works but will not prompt until the value itself in the table is below 0. $nega = mysql_query ("SELECT * from `bgl` where product_code = '$product_code' and stock > 0"); $row = … |
| | i have a login page within asp.net 3.5 (c#) website, and sql server 2008 at backend, i wrote a store procedure to save password in hashed form using SHA1 algo during registration , now during login i want to compare etered passowrd with the one save in db, so i … |
| | I need help!! What I want is when I add a new teacher, it will search the tblteacher_info. If there is already a record of that teacher, it will just update his/her record. If there is no record of that teacher, it will add his/her info in the tblteacher_info. I … |
| | Hello, I'm building an application with asp.net. And I need to send emails to selected customers. What is the best way to send email ? Is it by using System.Net Class or to send it by using MS Sql Server ? Thank you Paul |
| | i want to hash my password to SHA1 algo, in asp.net code and then want to compare it with hashed password in sql 2008 db, for login so how to hash it in asp.net code ? |
 | Hello Everyone, ASP.NET (C#) I have problem in retrieving the images from Table created in SQL Server Management Studio. Actually I had uploaded the images into folder in the Application Server on Visual Studio and the path of the images is given in the Table Attribute. Thus I have table …  |
| | I am working on a VS2010 Winform (not ASP web form). I have a copy of the local database on my computer. In this application, I have 3 forms in my application that need to connect to the same database, but different tables. Right now I am defining my connection …  |
| | Hi so I'm making a site for sneakers. A person can sign up and say they like Nikes, Vans, Reeboks, etc. I then have it where you can make a group for people who like certain sneakers as well. So the group can say they like Nikes, Vans, Reeboks, etc. … |
 | Ok let say i have the following xml file <Users> <User> <Name>David</Name> <Attempts> <Place>Paris</Paris <Date>3/29/2012</Date> <Duration>50 seconds</Duration> <Distance>100</Distance> </Attempts> <Attempts> <Place>New York</Paris <Date>7/28/2012</Date> <Duration>30 seconds</Duration> <Distance>100</Distance> </Attempts> <Attempts> <Place>Paris</Paris <Date>8/19/2012</Date> <Duration>70 seconds</Duration> <Distance>60</Distance> </Attempts> <Attempts> <Place>New York</Paris <Date>9/29/2012</Date> <Duration>60 seconds</Duration> <Distance>200</Distance> </Attempts> </User> <User> <Name>Lenny</Name> <Attempts> <Place>Paris</Paris <Date>9/29/2012</Date> <Duration>51 seconds</Duration> … |
| | ok so , i have a sql query puzzles . say that i have a table "PERSON" with the data look sumthing like this: PERSON Name ID ----------------------- John 12123 Kimberly 33311 Leo 87892 And i have a table score that look sumthing like this: SCORE ID MARKS ------------------------ 12123 …  |
| | Hi, I am writing a little app that will have a rich text box that users will be able to write SQL statements and save them to SQL Server table. I would like to validate the SQL statement before saving the string. Because another process picks up the string and …  |
 | $plugins = $Server->Get('plugins'); echo "<br /><br /><b>Plugins</b><br> "; foreach($plugins as $plugin) { echo $plugin."<br>"; } That snippet above spits out a long list of plugins from a server. How can I store each plugin listed into SQL so that its stored as '$plugin[0]<br/>$plugin[1]<br/>$plugin[2]<br/>' and so on so that when I … |
| | Hi all, ive got a big question about conducting mysql_queries.. i have a schedule program that needs to sort through and pick the records that apply.. the date will change, and used a php date() formatted to mysql date and pick out the ones records that are active vers inactive. … |
| | I'm learning as I go here, but I'm stuck at the moment. I am trying to dynamically create a datagridview and populate it from a database using SQL. I have created my columns, but I don't know how to assign the data coming out of my sql query to its … |
| | In my program, I have a section to insert information about a customer into an Access database. I get the error below at the .ExecuteNonQuery. Message: System.Data.OleDb.OleDbException (0x80004005): Field 'Customer.Business_Phone' cannot be a zero-length string. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& … |
| | Hi all, Anyone know how to create a data base gives the name of the same parameterized? Example in a store procedure, named 'x', which has a parameter, this will do since the create dabase @variable create procedure creadatabase @db_name varchar (10) as create database @db_name go But this variable …  |
| | I have created a cube in visual studio, when i want to deploy it i get the following error: Error : The project could not be deployed to the 'USER-PC\SQLEXPRESSR2' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service … |
 | Hello i have a database table | col1 | col2 | col3 | col4 | col5 | | val | val | val | val | val | | val | val | val | val | val | | val | val | val | val | val | … |
 | Hello, i got this error when i click my button save. Error: .Net SqlClient Data Provider: Conversion failed when converting datetime from character string. please help me... this is my save button code: Private Sub btnSimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim check As Integer Dim … |
| | Hi all, In the program I'm working on, I am making a form that submits data to an Access 2007 database. I can connect to the database fine and run a select query, but when I try an insert query I get an error: "statement contains the following unknown field …  |
 | Hello I am using Apache derby embedded database: I have been using a system to display records from the database described in "DisplayInstructorAvailableNowJTable.java". it allows the result set to create a model from a prepared statement. I have only uncovered the tip of the iceberg concerning JTABLE. I am not … |
| | Hi, I have a problem on getting data from XML file. I am honestly have 0 knowledge on this. Here is the XML data content, i opened the XML file using notepad then pasted here. <?xml version="1.0" encoding="utf-8"?> <?mso-infoPathSolution name="urn:schemas-microsoft-com:office:infopath:Test-Form:-myXSD-2012-09-02T13-13-23" solutionVersion="1.0.0.55" productVersion="14.0.0.0" PIVersion="1.0.0.0" href="http://share.test.com/it/Test%20Form/Forms/template.xsn"?> <?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.3"?> <my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:pc="http://schemas.microsoft.com/office/infopath/2007/PartnerControls" … |
The End.