1,694 Topics
 | |
 | Hi, I let say I use this code to retrieve date from database SELECT Table.Date FROM Table The format is 01/09/2013 (dd/mm/yyyy) How will i format this to get 09-Jan-2013 output then print this format to crystal report? I'm using dataset to connect data to crytal report I just noticed … |
 | Hi, I have these methods in my user class which check whether a username already exists and if not, inserts it into the database: //This function checks to see if the username entered already exists Private function check_user_exists() { $stmt = $this->_db->prepare('SELECT * FROM client_login WHERE Username = ?'); $stmt->execute(array($this->_username)); …  |
| | Hi I am really new to c#(I used to do vb.net) and I need some help with a problem. I am wondering what the equivalent of a datalist or detailsview in asp.net is in a c# winforms application and how to use it. I have data in a database and …  |
| | I have two tables, table_1, and table_2. I am trying to query both tables, I want every column that is in table_1, and only one column from table_2. Each table has an AccountID column, so they can relate to eachother. I am trying to get a query result that gives …  |
 | Hi, I'm having trouble to filter a Customer Set by the date of his first buy(First Activity). I've tried this two ways: 1. Returns all customers, even with FirstActivity Null SELECT { [Measures].[Valor Item], [Measures].[First Activity] } ON 0, { Filter( { [CLIENTE].[Cliente].[Cliente].Members }, ( [Measures].[First Activity], [Time].[Year].&[2012-01-01T00:00:00] ).Count > … |
| | hello! I got this error when I tried to connect to my db in sql server. > Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 8945dcd8080cc91' or one of its dependencies. The system cannot find the file specified. … |
| | Hi I have an insert statement in my VB code that updates about 20 fields in sql. I pass through todays date and a set of values. This occurs on a button click event. My problem is if the button is clicked more than once the data is duplicated in …  |
| | I am working with sql server using ADO provider. My code uses recordsets and commands to run quries and I fail to understand a basic issue - connections. In my code, they set a connection string (which is being built in the code, not taken from other ADO element) to …  |
 | Hello people, I am new to crystal report. Normally, I would insert columns in the crystal report viewer and then look at the records at the Main Report Viewer. All the rows/records in that particular columns of that table will be shown. And then I found out about this SQL … |
 | hi people.. I was wondering if u experts could help me with this. I have attached a screenshot of my form. This is an invoice system.. I have customers table for customer profiles.. I have Products table I have manufactures table I want to save all invoices so that these …  |
 | Hello im braking my head with a problem, im using netbeans building a web application using java, jsp that handel a database with hebrew fields. String cityTable = "CREATE TABLE IF NOT EXISTS hebrew_test.table (" +"id int(11) NOT NULL AUTO_INCREMENT," +"en varchar(30) NOT NULL," +"he varchar(30) COLLATE utf8_bin NOT NULL," … |
| | Hi Guys....i am facing a small issue with an SQL statement here. Will you be able to help me out? I wanted to grab the page title, page author's name which is in the users table, the no of comments, and the page publish date. "SELECT * FROM pages INNER … |
| | I don't quite understand how to make a Procedure as most of my processing takes place in my scripts. I have a set of 3 Queries that are almost identical that I would like to combine them to return a result set. The queries are: SELECT Date, Location, Sum(SubTotal) FROM …  |
| | # how to validate sql statement 1. hi, is there anyone who can help me in my problem? sql = "SELECT UserID, Status FROM tbl_User WHERE UserID = '" & strUserID & "' and Password = '" & strUserPW & "' " i want to validate my sql statement using … |
| | Hello Daniweb Univere, I am looking for a good program to use to store several dozen text documents, make them searchable, and ideally, allow me to link to specific lines of the document. I imagine there are programs like this, I have just been unable to find them. Any suggestions … |
| | Hi, I have done my vb.net application and ready for deployment, my database is located somewhere in my drive c:, i used this code to get connection string from app.config Public Sub main() constr = System.Configuration.ConfigurationManager.ConnectionStrings("WindowsApplication7.My.MySettings.nameConnectionString").ToString Con = New SqlConnection(constr) Try Con.Open() 'MsgBox("Server Connection is Open ! ") 'frmMain.Connection.Text = …  |
| | I have a table with these columns: stockNumber, storageID, lastPutDate, qtyOnHand Each stockNumber can have multiple storageID's but only one lastPutDate and qtyOnHand for each storageID. Here is an example of what the rows might look like: stockNumber storageID lastPutDate qtyOnHand ----------- --------- ----------- --------- 100505 R010101 2012-10-18 150.00 100505 … |
 | Hi, This has been troubling me for the last hour and I cant think of a way around it. My SQL table looks like this: **Name, Cost** Matt, $5.00 Carl, $4.50 Tom, $6.00 Tom, $7.50 I need to make a query so that it puts anything with the same **Name** … |
| | How can I specify the Server of my database when I make my project executable I have this module I call everytime i modify my database Public Sub main() constr = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:"database file".mdf;" & _ "Integrated Security=True;Connect Timeout=30;User Instance=True" Con = New SqlConnection(constr) Try Con.Open() 'MsgBox("Server Connection is Open … |
 | Hi Does anyone here can show me how to make an application that is like an odbc wizard that could register a sql server type connection? I have found one on the net through searching but it does not accept the UID and password of the sql server. I also … |
| | |
 | i have tblScrutiny , COLUMNS: teamid name userid now confusion is that every team has many members, so how how would i mention them, like e.g i mention 1 member in teamid =1 , then in next row the teamid changes (identity=ON) , so how to mention 2nd member ? |
 | hi i have a table in which m storing some data like in the following: table => uploads string_file and file_name and m trying to select the string_file. the data for this column is like in the following; ab323892,416a75f4, e732ced3 and blah blah. and following is the query that m … |
| | hi i have deattach the database from the SSMS. and a new database i have created in visual studio 2010. and i want to attach it to the SSMS. but my attach process is failed. any body is there to help me to attach the database into SSMS... |
| | Hi I have the two queries below, they run far too slow around the 20 second mark , I have around 18,000 rows on the videos table and 2,000 on the other. Any thoughts? Thanks $query="SELECT videos.VIDEOID, videos.title, (select video_thumb_chosen.thumb from video_thumb_chosen where video_thumb_chosen.videoid = videos.VIDEOID group by video_thumb_chosen.thumb order … |
 | I have a sproc that pulls six years of records for a report. The person who set it up years ago set it up using statically defined years which ended in 2009. I am rewriting this sproc to pull the current year and five years previous. In the process of …  |
| | I am building a new website and migrating all users off a CMS (ExpressionEngine) that uses MYSql. I have all of the users imported into a MS SQL staging table (except passwords). I am trying to create members in asp.net membership by looping through the users in the staging table. … |
| | hi i have a table like this for attendence: table name attendence. id std_rolNum std_fname date std_bkfast std_lunch std_dinner i want to make search on the base of `date`, `std_rolnum`, `std_lunch`, `std_bkfast` and `std_dinner`. so that if on the same date if student have already taken breakfast, lunch or dinner … |
| | hi m getting the following exception: `System.Data.SqlClient.SqlException: Incorrect syntax near '4'.` the following is what i was trying: public void hostel_cpacity(ManageHostelRoomsBE hmr) { string str; string conString = System.Configuration.ConfigurationManager.ConnectionStrings["Hosteluog"].ConnectionString; SqlConnection con = new SqlConnection(conString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); DataTable dt = new DataTable(); DataTable dt1 … |
| | i am working on a POS as a school project. im having a problem in getting the stocks, which is a record in my database. this is what i need to do, i need to populate the combobox with drug names with suggests. when i choose a certain drug, its … |
The End.