Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
4,138 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 83
Page Size: 10 · 25 · 50

Tag filtered by:  MySQL [x]
Question 13 May 2013   license: CPOL
I have installed MySql in a system and granted permission to all the IP. How to access that mysql database which is installed in another system
MySQL
Question 13 May 2013   license: CPOL
Sir i have three table in mysql database when we insert a record then only one table save record and another table does not have any record. my asp code and database table is given below...........asp.net.... protected void btn_save(object sender, EventArgs e) { ...
ASP.NETMySQL
Question 13 May 2013   license: CPOL
Good Day,PROBLEM # 1I tried populating my crystalreport programatically using code below.Imports MySql.Data.MySqlClientDIM obj_masterfile As New rpt_masterfilepublic sub populate_data()Dim da As New MySqlDataAdapter da = New MySqlDataAdapter("select * from...
ADO.NETVBMySQLVB.NETCrystalReports
Answer 13 May 2013   license: CPOL
Problem 1The data is not refreshed because the report still use the old datasource which was not refreshed. You should be able to get it by doing select again at the report refresh event.Private Sub CRViewer_ReportRefresh(ByVal source As Object, ByVal e As...
ADO.NETVBMySQLVB.NETCrystalReports
Answer 13 May 2013   license: CPOL
You're not explaining the problem and how you expect this stuff to work at all.You need admin priv's because you're writing to HKEY_LOCAL_MACHINE. Normal users cannot do that and there is no way around it.
VBMySQLVB.NETODBC
Question 13 May 2013   license: CPOL
Hi I would like to know the best code for Add, Edit & Delete DSN using MySQL ODBC & VB.NET.So far this is my code, the problem is that i need to run the system as admin.Imports Microsoft.Win32Public Class frmmysqlDSN Inherits System.Windows.Forms.Form#Region " Windows...
VBMySQLVB.NETODBC
Answer 11 May 2013   license: CPOL
object name is wrong in these two linesmycom.Parameters.AddWithValue("@MONTH", MONTH); mycom.Parameters.Add("@contenttype", MySqlDbType.VarChar).Value = contenttype;rectify it tomycom1.Parameters.AddWithValue("@MONTH", MONTH); mycom1.Parameters.Add("@contenttype",...
C#ASP.NETMySQL
Answer 10 May 2013   license: CPOL
The object name is wrong:...MySqlCommand mycom1 = new MySqlCommand(insquery1, exclecon);mycom1.Parameters.AddWithValue("@MONTH", MONTH);mycom1.Parameters.Add("@contenttype", MySqlDbType.VarChar).Value = contenttype;...This is why it is a really bad practice to use such variable...
C#ASP.NETMySQL
Question 10 May 2013   license: CPOL
how to insert record in two table that are related.when i insert record then record saved in 1st table but not save in 2nd table MySqlConnection exclecon = new MySqlConnection("Server=Localhost;DataBase=password1;user=root;password=nectar"); string insquery = "INSERT...
C#ASP.NETMySQL
Question 10 May 2013   license: CPOL
I have 2 tables and want to know if since a user last login there was an update on a table.I am using a table for dataentry and another to keep the time stamp of all the user last loginHow can I check if the time stamp of each row in dataentry is more recent or not since the last...
MySQL
Article 10 May 2013   license: CPOL
Geocaching Archive Maintenance Interface
JavascriptHTMLMySQLPythonAzureCloud
Question 9 May 2013   license: CPOL
Hi all, I have created a small web application using php and mysql for fetching data in mysql i have used stored procedure before hosting the application all worked fine but after hosting mysql stored procedure not fetching any data not showing any error and the query executing succesfull...
PHPMySQL
Answer 9 May 2013   license: CPOL
Hi,Another option is to use cloud Database , some DaaS(database-as-a-service) providers are Xeround, ClearDB, Amazon,etc.Sample Vb.Net Connection string:Public MySQLConnectionString As String = "Server=instance04868.db.xeround.com; " & _ "Port=6632;"...
VBMySQLVB.NET
Question 9 May 2013   license: CPOL
Please help me I have to make a C# web application that creates a CV and display it and then you can edit it and do a search organization and i want to read the submitted data in the database into a beautiful html page so when the user press submit after filling his CV it displays a beautiful...
C#ASP.NETHTMLMySQL
Answer 8 May 2013   license: CPOL
Read the following ("transaction support") on how to do transaction : http://zetcode.com/db/mysqlcsharptutorial/[^]
C#ADO.NETMySQL
Question 8 May 2013   license: CPOL
i need to apply transaction on multiple database tables on a click event of single button.What i m doing is below,but not working,plz tell m what wrong i m doing?//code con.Open(); MySqlTransaction tr = con.BeginTransaction(); try { ...
C#ADO.NETMySQL
Answer 8 May 2013   license: CPOL
Try giving same Alias Names. See this:insert into a(aa,b,c,d) SELECT @curRank :=IF(@prevVal= exammarks.Test1, @curRank, @studentN) AS aa,@percentile := IF(@prevVal=exammarks.Test1 , @percentile,(@totalS - @studentN + 1)/(@totalS)*100) as b,@studentN := @studentN + 1 as...
C#MySQLCrystalReports
Question 8 May 2013   license: CPOL
insert into a(aa,b,c,d) SELECT @curRank :=IF(@prevVal= exammarks.Test1, @curRank, @studentN) AS rank,@percentile := IF(@prevVal=exammarks.Test1 , @percentile,(@totalS - @studentN + 1)/(@totalS)*100) as percent,@studentN := @studentN + 1 as studentN,@prevVal:=exammarks.Test1 as...
C#MySQLCrystalReports
Answer 8 May 2013   license: CPOL
Given that you have added an example I believe the first query should execute faster, all things being equal. You should place indexed fields left most.You could also try using MySql's tools to evaluate speed of execution (I haven't used MySql for a long time so don't recall what tools are...
SQLMySQL
Question 8 May 2013   license: CPOL
Hello! I want to ask you, what SQL query will be execute faster, when i specify table fields that i wish to select or when i write only LEFT JOIN, without cpecify it?
SQLMySQL
Answer 8 May 2013   license: CPOL
In while loop while( $data=mysql_fetch_array($result)){ echo $data[0].$data[1].$data[2].$data[3]}what it does? It just looping through the $result.So it give you the result as row1 row2 .....But when you echo it with out the while loop it prints the first row .And echo it again it...
PHPMySQL
Answer 8 May 2013   license: CPOL
Here is a solution that might help.You can make a common generalized getSearchDateRange function it will return you an array having search start date and end date and use these values in your query.In this way you can use this search range function anywhere you want to use.You can get...
PHPMySQLfunction
Article 8 May 2013   license: CPOL
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).
JavascriptSQLHTMLArchitectDevPHPIntermediateMySQLjQueryGoogle-Maps, +
Answer 8 May 2013   license: CPOL
Fixed, just implemented some PHP into it:$qString = $gConnection->prepare("UPDATE `accounts` SET ".$key." = ? WHERE `Username` = ?");
PHPMySQL
Catalog 7 May 2013   license: Commercial
dbForge Data Compare for MySQL is a tool to compare and synchronize data of MySQL databases. You can quickly analyze data differences in a well-designed user interface and synchronize comparison results in a convenient wizard with additional options.
SQL2000SQL2005SQL-CESQLSQL-ServerDBASQL-ServerMySQLOracleSQL2008
Answer 7 May 2013   license: CPOL
hi,This solution code.$sql4="select count(*) as Under_warrenty from machine_details where warranty_renewal_date >='$current_date'";$result4 = mysql_query($sql4) or die('Query failed: ' . mysql_error());if ($result4) { while ($row4 = mysql_fetch_assoc($result4)) { ...
PHPMySQL
Answer 7 May 2013   license: CPOL
echo sql query and check it by execute that in MySQLCheck Date format passed from PHP it should be yyyy-MM-ddand in first query you are using >= then in second query you should use
PHPMySQL
Question 7 May 2013   license: CPOL
hi,I am facing an unusual problem when comparing two dates.Pleas have a look.Database tableWarranty_renewal_date (Date type= DATE)2010-02-122010-02-122013-06-11My code in php$sql4="select count(*) as Under_warrenty from machine_details where warranty_renewal_date...
PHPMySQL
Answer 7 May 2013   license: CPOL
$_post is not mandatory it is rather optional thing.This is due to a setting in your php ini.Using Register Globals.There are various way to on off it.Making it on is not the best practice.By using this means $fname to access the value you will be meshed up while handling larger code...
PHPMySQL
Catalog 7 May 2013   license: Shareware
dbForge Schema Compare for MySQL is a tool to compare and synchronize structures of MySQL databases. This product is designed to help you analyze database structure differences and propagate the changes to a required MySQL Server.
WinXPVistaWindowsDevWindowsMySQLWin7Win2008-R2Schemacomparison
Question 7 May 2013   license: CPOL
Dearsi just want to asks about mysql_fetch_array( ) function how does it works ?i know that it retrieves an array my question will be more clarify in the below example .
PHPMySQL
Question 7 May 2013   license: CPOL
Dears ,I am a beginner in PHP , i like it so much ,i try everyday to know a new thing about it .I have a question and I hope to find an answer .lets first have a look on the below simple code .first page : first.php
PHPMySQL
Question 7 May 2013   license: CPOL
I have done a little bit of coding and withdrawed this problem: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 '? = ? WHERE `Username` = ?' at line 1I don't understand whats wrong with this...
PHPMySQL
Catalog 7 May 2013   license: Shareware
dbForge Query Builder is a tool for quick creation of any MySQL queries without code and extended management of query results. It automates routine tasks and provides essential features to analyze and use the retrieved data to your advantage.
MySQL
Answer 6 May 2013   license: CPOL
Before writing the query you have to design your database. Once you created the tables then you may ask for help on querying their values.
PHPMySQL
Question 6 May 2013   license: CPOL
I want to transfer SqlDatabase 2005 64 bit to MySql 32 bit Database...Please help....Thank You!!!
SQL-ServerMySQL
Question 6 May 2013   license: CPOL
Hi all, I have to create a small application like time sheet i.e. daily employees should save what are the tasks done on a particular date and a approver will approve that task if he satisfied with that. Now what i need is if a approver selects from and to date and click display datagrid...
PHPMySQL
Answer 5 May 2013   license: CPOL
you need a web Spider to move contents from one site to another
JavaPHPAjaxMySQLHTML5/CSS
Answer 5 May 2013   license: CPOL
Decide if it should be Java or PHP or something else, read about Web scraping using one of these technologies. See also:http://en.wikipedia.org/wiki/Web_scraping[^].[EDIT]More exactly, learn to send HTTP request and receive HTTP response. Please...
JavaPHPAjaxMySQLHTML5/CSS
Question 5 May 2013   license: CPOL
I am creating a academic/community website . One of my site requirement is to obtain the result from the official site . I will be creating a result module on my site which will have students reg number as input and on submission it will show the result obtained from the official website .I...
JavaPHPAjaxMySQLHTML5/CSS
Article 3 May 2013   license: CPOL
This article discusses the making of a search engine.
Windows.NETWin32PHPIntermediateAdvancedVBMySQLVB.NET
Answer 3 May 2013   license: CPOL
just add in oncreate the following codeStrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder() .detectDiskReads().detectDiskWrites().detectNetwork() // StrictMode is most commonly used to catch accidental disk or network access on the application's main thread ...
MobileMySQLAndroidconnection
Question 3 May 2013   license: CPOL
I have a table called vw_results which holds the result profile for a particular student: idNum |courseUnit | marks | Gpp | grade| id | semseterID | sessionName 06/021 | 2 | 47 | 8 | B+ | 1 | 1 | 2010/11 06/021 | 3 | 56 | 7 ...
PHPMySQL
Answer 3 May 2013   license: CPOL
My personal preference for using the database result sets is to copy all rows into an array (pay attention to scope!). I can then close the connection and do whatever I wish to the array. roughly, after executing the SQL query:$rows = NULL;$i = 0;while($r =...
PHPMySQL
Question 2 May 2013   license: CPOL
how to store an QR Code image into mysql database with php? The code to generate an QR Code image is:&addtext=Data &txtcolor=111133&fgdcolor=111133&bgdcolor=BBBBBB&qrsize=200&t=p&e=m">
PHPMySQLimage
Answer 2 May 2013   license: CPOL
I think it should be echo $db = mysqli_select_db($dbSelect) or die('Database Not Selected');you connected to the database using mysqli_connect so try selecting using mysqli_select_db too. and better still specify the database your and connecting to in the mysqli_select_db if you have...
PHPMySQL
Question 2 May 2013   license: CPOL
$name = $_GET['txtName']; $email = $_GET['txtEmail']; $phone = $_GET['txtPhone']; $message = $_GET['txtMessage']; $host = 'localhost'; $user = 'root'; $password = '07E41A0516'; $dbSelect = 'gcmas'; echo $dbc = mysqli_connect($host, $user, $password) or die('Error connecting...
PHPMySQL
Technical Blog 2 May 2013   license: CPOL
[toc] Introduction Note to pedantic guys: yes Access is not a database engine, only the graphical front-end to Jet/ACE, but we’ll stand with this simplification. The sample application (Excel + VBA) and the SQL source code are available in this … Continue reading →
VBSQLWindowsCEOArchitectDBADevCOMCOM+ADO, +
Tip/Trick 2 May 2013   license: CPOL
How to avoid the Cursor in Stored Procedures
SQLWindowsDBAIntermediateMySQL
Question 1 May 2013   license: CPOL
I want to store the image into the mysql database from C# in windows application.I already do that but after store it's shows into datagridview and i want to fill again the picturebox from the image on using doubleclick event.It makes the file in debug folder and when i double click on same data...
C#MySQL
Page 1 of 83
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid