6,934 Topics
 | |
| | hi there, I asked this question before also. i have two date times in a table in the MS SQL server database, when i write the query as below. the Sstart Date and the Due Date is displayed as 12/11/2010 12:00:00 AM it shows correct in the MS SQL business … |
| | Hiii I am developing one window application in c#.net with sql server 2005 as database. now, i have Some questions: How To Use OpenFileDialog control in C# window application. and how to give the validation for it. How To copy this file On The Other Folder also store the path … |
| | [B]SELECT staff.StaffNo, semester.SemesterID, teach.SubjectID, teach.Sub2, teach.Sub3, teach.Sub4, teach.Sub5, teach.Sub6, teach.TeachLoad, (IIf(IsNull( teach.SubjectID),0,1) + IIf(IsNull(teach.Sub2),0,1) + IIf(IsNull(teach.Sub3),0,1) + IIf(IsNull(teach.Sub4),0,1) + IIf(IsNull(teach.Sub5),0,1) + IIf(IsNull(teach.Sub6),0,1)) * 3 As teach.TeachLoad, FROM (subject INNER JOIN (staff INNER JOIN teach ON staff.StaffNo = teach.StaffNo) ON subject.SubjectID = teach.SubjectID) INNER JOIN semester ON staff.StaffNo = semester.Staff[/B] i …  |
| | I've searched the net high and wide for the answer, and yet came up with nothing. Right now, in out web.config file, we have our database connectivity stored in 2 different ways. We have our connection string, and we have it broken up into parts in our application settings. Crystal … |
| | hello... I created a website having a database. I realised that I need to set a database username and password. I tried to include it in the connection string but I'm having the below error: Login failed for user ''. The user is not associated with a trusted SQL Server … |
| | I have a property active to indicate status of an employee. Along with all the details, i extract the details from an employee table into a dataset, but however i am not able to get the value present in active as i get an invalid cast exception. This is the … |
| | Hi all, I would like to seek for some help from you on how to create a connection to a sql server database from an asp.net application using VB codes. I appreciate if you could provide me the relevant information about that with some sample codes. Thank you. |
| | I need some help with something which in theory shouldnt be complicated but really has me stumped! I'm not sure whether the answer to this lies in the php code or in the SQL statement. I am doing a bonus comparison so I am extracting 2 columns from the table: … |
| | I recently installed MS SQL Server 2008 Developer Edition (on my home PC with Win7 Ultimate 64-bit). I have been trying to get it set up for use, but am having some issue. I keep getting an error when trying to connect to the server. On the "Connect to Server" … |
 | Hi. so i'm using ms access 2007 as a database, i have here a table of TRANSACT IP which has the following columns of Transact_ID, IP_ID, Date, Time, Average, Min, Max. i have to produce a report in which i have to query from this table with the follwing format: … |
 | I'm a very new developer (if you could even call me that), and I'm killing myself here. Essentially here's what I'm trying to do. A user scans a series of documents which are sent through a program that places a .tif or .pdf of each document into a folder on … |
| | I have two tables Banks(Bank_id, Bank) FX (ID, Bk_id, currency, trans, value) Banks and FX are innerjoined on Banks.Bank_id=FX.Bk_id. in the original table in database: [CODE]Code: ID Bank Transaction type Currency Value 1 X Buy EUR 1 2 X Sell EUR 2 3 X Buy USD 3 4 X Sell … |
| | I have two forms and I am running a sql query to provide a set of variables in my first form that I need to pass to my second form. Here is the code that I have: [code] Imports System.Data.SqlClient Public Class Main Dim instForm2 As New Exceptions Public payrollstartdate … |
| | Hi there, How can I use the “EncryptByPassphrase” for a table in ms sql server 2008 r2??? or if i can get a good tutorial appriciate a lot thanxxxx  |
| | Hi, I have a question in MS SQ L enter prise edition. I have writtend an application in Visual studio 2008 standard edition and I am connecting to ms sql sever enterprise edition 2008 r2. When I depoy the application I created and install inanother computer some components relating to … |
| | guys How do you Create Database in MS Access Using Oledb in vb.net? |
| | hello guys... I have been trying hard to connect to SQL Server using MFC but could not do that. No proper examples I could found. I know this can be done using ADO (ActiveX Data Object with COM) but have been unable to do that. Please can anyone of you …  |
 | I have two separate pages. One page I'm using some UPDATE queries and the second page uses an INSERT query. Neither are updating my database. I can read the database from php, but not update it. Is my syntax correct? I know I can make it more efficiant, but I …  |
| | Hello! I am very pleased to join Daniweb. I found it very interesting and helpful and immediately joined the community in the hope of getting some help regarding my final year project. Well coming to the point, m designing an Attendance Management System(AMS) for my college. I have created accounts …  |
| | I am new to SQL and databases in general. My problem is that I am trying to create a table that will store information about users in each row based on the date of that activity. So I need to create a table with 365 columns representing with one representing … |
| | Hi! Can someone tell me on how could I display the data from my SQL to a ListView? I only have one column to display. Thank you very much and God Bless! :) |
| | how can I select one or more columns from a table by column-index and NOT by columnname? I got the columnIndices of table by using this query SELECT name, colid FROM sys.syscolumns WHERE (id = (SELECT id FROM sys.sysobjects WHERE (name = 'table_name'))) |
| | Hi, In my current project we have been inserting quite a few records into the data base, we dint chk abt implementing locks, my client doesnt want any duplicate records for a column in a table, there is no primary key constraint on any of the column for the table …  |
| | I need a timer that will change the text of a combobox which is binded to a database. My Application which is based on hospital management wherein a doctor has to visit rooms within 6 hours. If 6 hours elapse the combo should show "need......" and if not something "......" …  |
| | Hi there, I am creating reports in SQL server business intelligent studio and when I deploy it to the report server the report is shown in only on a half a page. How can I make the report height and the width for the report thanksssss |
| | Hi all, DANIWEB saved me a few months ago, and I'm hoping the community can save me again :) I've found myself in the position of needing to extract a very small portion of data from a vast SQL database. I've got the specific table in question, and have isolated … |
| | How do I change the path for of the restore location in management studio. Whenever I go restore a DB it always prompts me to the damn C drive. Where do I go to change the path? |
 | Hello all. I've had many problems solved for me by daniweb users without ever even joining. Now, though, I've run into a problem that I can't seem to solve. It feels like a very stupid problem that will probably have an easy answer, but alas I have not found it … |
| | I need the syntax of queries in visual basic 6 to edit the database in ms access.please help me.The name of database is patient details and it has fields as name,id,height,weight,bmi,email,phone etc. if the id is already matching i need to update the details and if its not matching i …  |
| | Hi, I am a beginner, and would like to do something like: I have a mysql table with date column. I would like to select all the rows from table, and print them out in tables. One table per month. E.g. January: ... ... ... February: ... ... ... etc. …  |
| | Hi I want to generate sequence number in C# window application I have got one link on Google, but I it is not helpful. I want that on click to add button an order sequence number should generate and stored in SQL Database i have written this code but it …  |
| | Hi I dont have a huge wealth of experince with SQL statements and im struggling; i have two tables table one holds employee data table two holds payent histroy for employee so essentially a 1 to many relationship I would like to list all of the job titles(for which there … |
 | Hi I need to migrate an application from MS Access to SQL Server (2005), and i'm using the code bellow, but i'm getting an error when the compiler reaches the AddNew instruction. It gives me "Run-time error '3027': Can't update. Database or object is read-only". [code] Dim DBTesteSQL As Database … |
| | I am trying to use a search script i found online and i am having a problem with the query. I am trying do a query from multi tables. I have 12 tables, all have the same fields: name, phone etc. each table is a different category of items: appliances, … |
| | Hi all, i wonder is it possible to display my images from database into table with 4 rows and 4 column? How can i do that? [CODE] $dbConn = mysqli_connect(DBSERVER, DBUSER, DBPASS, DBNAME) or die(mysqli_connect_error()); $sql = "select * from products"; $result = mysqli_query($dbConn, $sql) or die(mysqli_error($dbConn)); echo "<table border … |
| | does anyone has a sample code or it it possible to fix error in this code I appreciate any advice the error i get : There was an error parsing the query. [ Token line number = 1,Token line offset = 13,Token in error = user ] cmd.ExecuteNonQuery() [code] Imports … |
| | i am writing a program and i need to increment a table row. How would i increment a table row on the click of a button? |
| | this is the way that i used to fill dataset in the formloader (); [CODE] String Query; DataSet ds; SqlDataAdapter myadapter; SqlCommand mycommand; connInterface conn = new connInterface();//connection class private void Form1_Load(object sender, EventArgs e) { cmbEmpID.DataBindings.Clear(); Query = "select * from dbo.bind_tab b"; mycommand = new SqlCommand(Query, conn.createconnection()); myadapter … |
| | Hi, Need help in creating backup/restore on database using SQL Server 2005 with VB6.0 code when the database is on the network. Please Help. frexyang |
| | Hello friends [CODE]String sql = "SELECT * FROM work.cs_book WHERE bookname = ? AND author = ? AND category = ?";[/CODE] I have writtern above query and where i can search for a book based on bookname author and category. I am using preparedStatements to execute query. However something is …  |
| | Hi there, I have two tables. The first one holds information about cities: Locations: [code] locID | locationID | locationName | countryCode | 1 | 2922239 | Berlin | de | 2 | 291074 | Paris | fr | 3 | 295522 | Orlando | us | 3 | 292345 … |
| | hi everyone. i have problem with SQL UPDATE command, with Add and Save Record, Delete Record and Search record, it works well, I have this code: for SAVE Command button squery = "": squery = "SELECT * FROM tblEmp WHERE EmpID=" & txtEmpID.Text & "" Call ExecuteCommand With rs .Open … |
| | Dear All, I have a java application which link to db on another computer on the local lan. The problem I have install jdk_1.6_21 without any problem. Then I have paste mysql-connector-java-5.1.14-bin.jar in /usr/java/jdk1.6.0_21/jre/lib/ext. When I compile my program has no problem when I try to run I get this … |
| | Hello everyone, before i ask this question i would like to say first that im a beginner in asp c#. I would like toask for a tutorial on making a download button for binary datas. My file upload is already working fine. I just need a download button so i … |
| | Hello everyone, I have bound a datagridview with a table, And put a checkbox on each row .And an Insert button at the bottom. On clicking the button ,the Checked rows are to be inserted in the table. When I do that it gives an error as 'Can not Insert … |
 | Hi friends, after a long time. i am developing a small tool by using VB.Net. I want to display data in comboboxes from a table which is in an access database. I using SQL query. Its a simple problem , I think the problem is in my COMMAND. I want … |
| | Hello, I am Using VB 6.0 . Please Help me to get the codes to Create Backup and Restore in SQL server 7.0. I request Some one to help me at the earliest. Rajesh |
| | Hi I am trying to write a function in which I customize my select statement. But it is not working as i desire... It is as [CODE] declare @column_name nvarchar(10) set @column_name = 'original' select @column_name from data [/CODE] Here original is the name of one of the columns. I … |
| | I Have a Just Simple Question. But It Made me Confuse. I have a DataTable Which has bind to textBoxes and Other Items. therfore when I made a change through txtBox or Other Items it reflect to dataTable. what I have to do is Saving updated Datatable to Sql Table. … |
| | I have a help desk system in which I specified some default sort settings and what not. I've recently added drop down boxes to this, in hopes that a user can change the view settings for themselves. The assigned to: works fine, but I'm not sure how the person prior … |
The End.