6,934 Topics
![]() | |
I'm trying to set up performance dashboard in SQL Server Management Studio Express. I'm currently running SQL Server 2005 SP3 ('product level') and also have installed the Performance Dashboard add-on. A couple of forums I've seen said that I could access the reporting feature by updating the Management Studio Express … | |
I am trying to pull data from a table to fill a drop down list. Now, i got the fill part working, but am having an issue passing a variable value to my form post action. Code: $query ="SELECT UniqueIdentifier, LastName, FirstName FROM BrokerMain ORDER BY LastName"; $result = @mssql_query($query); … | |
This code is acting weird like if I put the row "friendname" it wont show up at all. [CODE] <? $gar = mysql_query( "SELECT * FROM friends WHERE username='".$row['username']."'") or die(mysql_error()); //gets requests while ($reqs = mysql_fetch_array($gar)) { echo ' '; echo $row['friendname']; echo ' '; } ?> [/CODE] | |
Hi All, I need to use the results of this query as an array to exclude files from a tree. The file and folder names that I enter into $exclude work fine but I can not seem to add the results from the query to the array. Below is the … | |
Hi, Im trying to retrieve some particular datas from SQL column into RichTextBox in WindowsForm. Im Getting only whole SQL column from SQL Table. If u know the answer, Kindly post. Thanks in advance | |
I have created a csharp script that connects to my sqlexpress database. It works perfectly in my test environmnet. When I upload the web application to discount asp.net I cannot connect to the database using the hookUp command. The web.config file is working, I can connect to the database and … | |
Hi. I want to ask about this code. I'm trying to upload csv file and import into sql. but this code doesnt working.[CODE]protected void LinkButton1_Click(object sender, EventArgs e) { Response.Redirect("login.aspx"); } protected void Button4_Click(object sender, EventArgs e) { string filePath = FileUpload1.PostedFile.FileName; string filename = Path.GetFileName(filePath); string ext = Path.GetExtension(filename); … ![]() | |
[B]hello..! required a help i want to store a date in sql server field...i set the field type is datetime..bt i jus want to save only Month and year ...kindly help me in it..! i m working with vb6 i set the date formate [/B] [COLOR="Green"]myDate = Format(cmbMonth1.Value, "MMMM-yy")[/COLOR] [B]bt … | |
Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column … | |
I want to set up a connection to a Microsoft SQL Server 2005 express on my PC. [code=java] try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection( "jdbc:mysql://localhost/db1","xxxx","yyyy"); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT nume FROM tabel1"); while (rs.next()) { String s = rs.getString("name"); textArea.append(s); } } // Catches any … | |
Hello, first post =D Seemingly simple question, but I can't seem to find the solution. [CODE] (above were other SQL statements I had been fooling with) SQL = "SHOW TABLES;" Try conn.Open() da = New MySqlDataAdapter(SQL, conn) Dim cb As MySqlCommandBuilder = New MySqlCommandBuilder(da) da.Fill(ds, "products") dgvMain.DataSource = ds dgvMain.DataMember … | |
im using a search form to serach my sql database to return on the requiered infromation but it seems to retive all the info, what i wnat the serach to do is if some1 types in say nokia and n97 for it to return just the results for nokia n97 … | |
I know this might have came up, but i have a login code and once logged in it would show u your information that u entered in the sql database just for that one person that logged in. Here is my problem when i login it shows another users information, … | |
ok i'm want to populate dropdown with fields from a table in database(sql). Please help!!! | |
Dear Friends, I want to know that how can we compare two hebrew string in MySQL database? I tried and search a lot on net but still could not found the answer. My website is dealing with Hebrew(main) and English as well. So please let me know How can I … | |
Could anyone help and advise me on how to create a new sql database and then connect it to my html webpage. I would like to have a search window on my webpage with text search by Languages, Country or Services so as when a customer enters for example "french" … | |
I have created a very basic database in 'MySQL Workbench' just as a test.. This is the SQL it produced - [CODE]CREATE TABLE IF NOT EXISTS `CustomerOrder` ( `OrderID` INT NOT NULL AUTO_INCREMENT , `OrderDate` VARCHAR(45) NOT NULL , `ProductName` VARCHAR(70) NOT NULL , `ProductCost` VARCHAR(45) NOT NULL , PRIMARY … | |
I seem to be having difficulties when using the following query: [CODE]$query = mysql_query("SELECT * FROM `products` WHERE `name` RLIKE '%$s1%' OR `name` RLIKE '%$s2%' OR `name` RLIKE '%$s3%' OR `name` RLIKE '%$s4%' OR `description` RLIKE '%$s1%' OR `description` RLIKE '%$s2%' OR `description` RLIKE '%$s3%' OR `description` RLIKE '%$s4%' OR … | |
So I have a small database for managing stationery orders (internally with my company - I order from the stationery dept). In the orders forms i have a subform with the list of items being ordered. I have the Item_ID, description, UnitsOrdered,UnitPrice, TotalPrice. What a code that will lookup the … | |
How can I create a blank space in sql server with null?:) | |
Okay.. Currently i already had this code for my registration form [CODE] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.Sql; using System.Data.SqlClient; namespace Thesis { public partial class Registration : Form { Form formParent = null; public Registration(Form par) { … | |
HI Can anyone tell me that how to configure php.ini For $_FILES['name']['type'] I am trying to upload a flv video and it is uploading successfully but it is not showing me the type. But if i upload a .mp4 extension file it is giving me the type also and can … ![]() | |
how can be store image itself in sql server and retrive it ? plz not it's path [COLOR="Red"][B][I]Thanks[/I][/B][/COLOR] :) | |
Hey guys! Im working on a login form that connects to an SQL 2008 database. i have created records in the table for users who can login. i however want a code snippet that matches the username and password entered with the records in the database. i have a rough … | |
[ATTACH]17851[/ATTACH] Hi, Format my PC and installed SQL Server 2008. Setup hangs as shown in attached image. Installing on Win 7 64 bit OS. To install SQL Server SP1 is left to do due to this. FYI, the top text reads: Running post-Windows Installer configuration timing actions the bottom text … | |
Hi All, Can anybody share PHP code to generate excel file by querying MySQL database. Thanks in advance.. | |
I add connections in server explorors. Then, I use AdventureWorks Person.Contact to set up a query by searching peter and mary ,but how to add it on form 1 ? and I type part of their names and by the way how to link a "VB label of text" or … | |
Database: motion_world table: accounts columns: id | username | password | register_date | account_level When i go into HeidiSQL -> Query and write: [CODE]SELECT account_level FROM accounts WHERE username='Sha11e'[/CODE] it returns: administrator But if I, in a PHP file, write: [CODE] mysql_connect("localhost","root",""); mysql_select_db("motion_world"); $hi = mysql_query("SELECT account_level FROM accounts WHERE … | |
Dear Experts I have loaded a picture in PICTUREBOX1 by this command Me.PictureBox1.Image = Drawing.Image.FromFile("D:\C2007\BITMAPS\pict.jpg") How to store this picture SQL server 2005 table1's IMAGE column? I do not want to store image path in table. I want to store picture in image column in any format. Reason: If I … | |
I am currently working a registration project and here is my code.. [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.Sql; using System.Data.SqlClient; namespace Thesis { public partial class Registration : Form { Form formParent = null; public Registration(Form par) { … | |
Im sure this has been posted a billion times, but ive followed steps on other threads and still no look. What im wanting to do is to be able to delete a record from a form that is echoed..get me? Heres the steps: - Post update news, insterts it into … | |
I am developing an application that based on when a user has last entered a payroll, my program tells them the next available Sunday that is available to them based on 1. The date that the last time payroll was entered 2. If payroll ran = "yes" or "no" I … | |
There's a query where I want to get the: - Username of the user attached to the current opportunity record - Sales Stage associated with each opportunity record - Dollar amount associated with opportunity record I want to: - Take the current SELECT IF STATEMENT result, and collapse it based … | |
I have problem to delete data in database.I add delete button to delete unnessary data. but when i try to delete those data in database i found a problem because of forign keys.how can i delete those data in tables with related data in other tables.please someone help me.Thanks | |
Hi, I have managed to create a connection via SQL Compact server to a local SDF database. I am able to query the data and retrieve the information. The only problem is trying to delete a record. When I run the code no error's are produced but the record is … | |
Hi all, In my C# application I have a SQL database with a table called Customers. In this table I have several columns like Name, Street, ZipCode and City. I already managed to get data in and out the database with the use of datasets, tableadaptors and bindingsources and get … | |
i have an free web host on aspspider.com and i have made an page with asp.net and a sql database under root\Database\db1.mdf. the code on my page is in c#. i have an code for db acces but it doesent work [CODE] string connectString = @"Data Source=~\root\Database ;Initial Catalog=DB1"; System.Data.SqlClient.SqlConnection … | |
Hi! I have a question regarding the SQL Select and "try...catch". The problem is that my SQL Select statement could sometimes return empty sets. For this reason I'm using "try...catch" statement. However, it doesn't work - the error message is generated for the empty set. So, how could I solve … | |
hi am new in php, i have values like A,B,C,D in database all in one box. i made a dropdown for its search A B C D , i want if somebody select A or B and search it fetch the whole row from database. or in other words i … | |
Howdy, I want to make a sql that goes to oracle. the sql should be "Select "cusip", "price structure" from tableA" (basically the columns are wrapped in double quotes. I used this synatax in C#: string mysql = "select "+'"'+"cusip,"+'"' + '"'+ "Price structure\"" from tableA" and I am getting … | |
Hello all, Greetings! I have just found this site, as i was searching for how to read any file in binary mode, like when you open a word file in hex editor it will show the "D0 CF 11 E0 A1 B1 1A E1" as the first eight bytes. I … | |
How to connect to a WAMP server database (located in default MySQL database location in WAMP) using C# 2010? I tried... SqlConnection conn = new SqlConnection("Data Source = C:\\wamp\\bin\\mysql5.1.36\\data\\testdatabase; User ID=; Password=;"); SqlDataAdapter da = new SqlDataAdapter("SELECT * from transactions", conn); DataSet ds = new DataSet(); da.Fill(ds, "Transactions"); DataGridView1.DataSource = … | |
Hi everyone, i got very good help from daniweb with regards to my project; online project allocation system in drawing up my erd but now i need serious help with the asp coding as that is what stands between me and my first class and time. I would need help … | |
This is my code: Add_click [code] dbcmd = New SqlCommand("INSERT INTO dms(name, dept) VALUES (@name, @dept)", connection) 'Add Database Parameters dbcmd.Parameters.Add("@name", SqlDbType.VarChar).Value = name.Text dbcmd.Parameters.Add("@dept", SqlDbType.VarChar).Value = dept.Text [/code] But I want to add the data in gridview [code] Dim record_series As String = DirectCast(GridView1.FindControl("Record_Series_Number"), Label).Text Dim doc_name As String … | |
hello all i am new to C# i want to enter a datetime value in table but when i give datetime datatype in insert statement it is not displaying any error while executing but when i see the inserted value in my table it shows 1900/01/01 i want to enter … | |
I am using VS2010 and SQL Server 2005. I have a query to search between dates. Depending on which date I select on the datetimepicker I get no results or limited results, but mostly not all the dates between the two dates I specify. For example, if i select 10/9/2010 … | |
i have a project in c# code with 3 leyer; and all of database code are in data leyer, which method is better? 1- send sql string statementto data base for select or update? 2 - using stored procedure? in databases with larg scale wich is better? pleas help me?! | |
hiiii all, Can anyone please help me regarding this .... i have table with 2 cloumns in a database "details" Name Age john 26 Mary 18 Nancy 20 i want to get only the Age in an array. I tired in this way: db=MySQLdb.connect(user="root",passwd="my",db="mydb") cursor=db.cursor()# prepare a cursor object using … | |
I'm rather new to this and really need some help. I know I'm close but I just can't get this to work. My omonth table has only 2 fields, id and month. I want a drop down to lists the months and I want the selected value to become a … | |
Hi, I'm trying to query a database to pull out all results from the database where the location and server responsible are selected from a form on a previous page which are then posted over. I can manage to post the selections from the form, but when it attempts to … |
The End.