9,022 Topics
Hi all, I have a single table with both parent and child nodes, and each has an order number in it. I am trying to write a single query to output them in order, its for a navigation list with categories and sub-categories. I could manage it in code rather …
Hi, I have an insert statement that i need to refine...basically I need to trim the first couple of letters of whats trapped inthe field. so e.g. Z:\aaa\1.jpg needs to become aaa\1.jpg Im tried this but its not working [CODE]sImagelink = mid(request.form("Imagelink"),4,len(request.form("Imagelink")))[/CODE] any ideas?
Hi All, I have to convert Excel data to MSAcess .MDB file using VB.NET. VB.NET Code read the Excel fi;le and write ti to .MDB file. For the same I have below code, but I am stuck at the writing it to .MDB file which I have already created with …
I am trying to search a database using a user defined string from a text box. I am getting an error message with the "objectadaptor.Fill" Here is the code: [code] Imports System.Data.OleDb Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Partial Class Search Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal …
I have this code now for inserting new ID into database: [U]IDs are all primary key.[/U] [CODE] MaxID = 0; string GetMaxID = "SELECT MAX(IDPerson) AS IDPerson FROM Persons"; SqlCommand cmd = new SqlCommand(GetMaxID, sqlConn); sqlConn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { MaxID = reader.GetInt32(0); } MaxID++; reader.Close(); sqlConn.Close();[/CODE] …
i live in Vietnam, so My English is so bad, but i hope you know what i mean. I want to setup a server that use : Apache, PHP, and Ms SQL server persional edition 2000. But i only can connect Apache 2.0 and PHP 5.x it run ok But …
Hi I need a help in SQL,There is table called sales.Its contains the day,sales quantity.If I write sql like below [CODE]select day,Sales_quantity from Sales.[/CODE] Then result should be Day SalesQuantity Monday 20 Monday 302 Monday 50 Tuseday 30 etc.. The problem is I want to get result like below Day …
Hi all... So, I am needing to sum all billable hours within a table... the problem is that it is returning rouded decimals instead... like .5 always comes back as 1 ... Here is my procedure: [CODE] Public Shared Function GetBillableTimeForTicket(ByVal SupportTicketID As Integer) As Decimal Dim conn As New …
So I have a radiobuttonlist that returns a list based on a sql query. The app displays the results from the column named "printer". I am also selecting the column_name "default_printer" Basically what I want is for the selected index of the radiobuttonlist to be where "Default_Printer" = "1". I'm …
Dear Friends, When i enter a new record in SQL Database from my C# application, the record stores in the database at random locations, but i want to make sure that every record must be enter at the end of the Table. Actually i have to get the Last Balance …
Hi, this is giving me a major headache and my boss wants the project wrapped up asap : / I have two views pulling data from several tables. The end result is this: CustomerTotals CustomerID numeric(18,0), ProductID numeric(18,0), Delivered numeric(5,0), Ordered numeric(5,0) SupplierTotals SupplierID numeric(18,0), ProductID numeric(18,0), Delivered numeric(5,0), Ordered …
Hi, I am doing a project where i am creating a website with a SQL server 2005 DB in the backend. I am doing it using visual studio.net and coding in C#, ASP.NET & CSS. As a person registers on the website, the info goes to the DB but i …
Good Day all i have the Following Query [CODE] DECLARE @CurrentTime DATETIME SET @CurrentTime = CURRENT_TIMESTAMP select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description], convert(varchar,datepart(hour,tb.starttime))+':'+convert(varchar,datepart(minute,tb.starttime)) [Start Time], convert(varchar,datepart(hour,tb.endtime))+':'+convert(varchar,datepart(minute,tb.endtime)) [End Time], tu.name [Requested by] from tbl_booking tb inner join tbl_resource tr on tb.resources = tr.id inner join tbl_user tu on tu.id = …
I am trying to write a bulk import routine so that i will be able to import text files or csv files to SQL i have tried this and it's giving me the following error message. P: is the drive where the file is in currently. [CODE] USE [XYZABQ] GO …
Hello, Is it possible to insert the data from dbgrid component into an SQL SERVER database table. The data that is in the grid is imported from Excel worksheet. It may look silly but I need to insert that data into a table. Any help is appreciated, thank you
Hi, I have a VB.Net system that connect to SQL Server through ODBC. When I try to raiseerror from an IF...ELSE statement, it does not triggered the exception handling. I have done some raise error testing at my side. Below is my finding: 1. RaiseError did not triggered exception: [code] …
Dear all, I’m stuck on a problem which I’m hoping someone might be able to help with in an SQL script. I have a table with RAW Timesheet data which includes entries for Absences. When someone enters a timesheet on a particular date for a two week holiday, if I …
Hey all, I made a project that will save the some personal knowledges of the members of our robotics group. So, I used database in my project, sqlserver management st... It works as well as I desired. But I have a problem now, I need to develop its setup project. …
I have multiple external databases that i want to connect to, from a stored procedure. What server the database is located on is dynamic (a record in a table). All of the external databases are LinkedServers, but also here i need to be able to define what server dynamicly. It …
Good Day All am restoring a Database Programatically in Sql. Now if the backup is located in the remote machine i use a Share [QUOTE]\\Vuyiswa\MyShare\[/QUOTE] but i will get the Following Error [QUOTE] Exception caught in: ExecuteStoredProc: The file "\\Vuyiswa\Databases\\REmoteTest33.mdf" is on a network path that is not supported for …
I have a SSIS import file that imports a flat file that is in cvs format. I've been running into a problem where the input file that is retrieved from a third party has bad rows in it. These rows cause the import process to fail and it doesn't fully …
I have following tables table1 nr_key1 nr_dad1 table2 nr_key2 value (repeated ~n times with same nr_key2 and different value) in table2 nr_key1 = nr_key2 After I have iterated through nr_key1 I want to use recursion to select nr_key1 = nr_dad1 and iterate again table2 with the new nr_key1. This should …
is there a way to caputre the values in a datagrid and bind them to a sql table? I have a datagrid bound to a sql query with some editable cells and I wanted to know if the updates could be sent back to the sql table. is there a …
Hi All, Can anybody give me a solution how to solve or write a query for this scenario? there is table called ITT1 with the columns FATHER, CHILD_NUM, CODE, CODE_QTY a 1 b 1 b 1 c 1.5 c 1 d 2 d 1 e 1 There are 3 columns …
Hello all! Looking for some help with this, I've been using a book to make an sql database to store names, and was hoping to use a button to randomly select any of the names in the database to be allocated to one of two machines. Also there is a …
I have some tables that i have created in SQL Server and i want to write a stored Procedure that will insert data on to one of my tables AND also be able to update say if i select record [CODE] CREATE PROCEDURE Sp_cust_SaveCustomer --ALTER PROCEDURE cust_SaveCustomer (@id int, @ …
Hii... I'm having 2 .aspx page 1) Detected Vulnerabilities Report 2) Missing Patches Summary Report When I'm clicking on Detected Vulnerabilities Report it is executing fine and after when Im clicking on Missing Patches Summary Report it is also executing fine. For both of this report Im passing 2 parameters, …
or even make the searching faster when retreiving data. please kindly help me. thnx.
Hi I wonder how I do to remove usersid from 1915 to 1945 for example in MS Sql? [code=sql]Delete from [dbo].[user] where user ID = 1915 to userID 1945[/code] When i add that i get this message: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword …
Hi All, I guess, at least according to my welcoming pm, I should introduce myself. I am very new to web development, I have used access and have been very active on an access forum since June. I am now trying to branch out from Access into other things, and …
Simply put, I need a better query. I have a table that contains 85000 rows, each row has a TITLE and an ABSTRACT (they are academic papers). What I need is to do a realistic SMART search in my query. Right now I'm doing[code]SELECT * FROM PsPapers WHERE Title LIKE …
Hello everyone! So as my first post, I would like to say I am in no way unfamiliar with Visual Basic or programming in general, but this Database integration is giving me quite a problem! lol So basically I have a VB 2008 Project with a single form that displays …
I really need help from you guys... my Insert statement doesn't work in C# but the Update statement was just fine. Possible to guide me on the delete statement as well? Here is my code: [CODE] string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Inetpub\\wwwroot\\H1N1\\TTH H1N1\\TTH H1N1\\bin\\Debug\\H1N1.mdb"; OleDbConnection conn = new OleDbConnection(ConnectionString); OleDbCommand …
hello every one I made setup for an application containing database built by sql server express edition I made the connection string dynamically taken from Application.StartupPath but when trying to install it on a different PC , i got the following exception.. an error has occured while establishing a connection …
Whenever I create a new database from a C# program and create tables for that database, the tables always show up under the creator's default database instead of being listed under the newly created database. This observation is from Microsoft SQL Server Management Studio Express. Is there some setting in …
Hello i wish to retrieve rows from a table based on a particular column which contains null values in sql2000 server I try ed a lot but its not working please help me.
One of the UPDATE queries I am trying to run is not quite working the way I want it to. I know this query is the culprit, but can't quite figure out how to fix it! Here's the story: ------------------------------------------------------- I have 3 tables: let's call them tblUsers, tblDueVisits and …
I need to write a query for the given crystal report. The database tables and the report is attached.Please see to it.
1. How to retrieve stored file our of the database? have stored (for example) a pdf file into database, as a data type of varbinary(MAX) - binary data. How can I get this file back, like it was before? Important things I have stored for the particular file are: - …
I have a gridview which is bound to dataset initially. Then i edit the gridview data by clicking the edit button. after editing when i click the update button, value should be updated on gridview itself. Later when i click submit button all updated records should be updated to sql …
Read a post that had a similar scenario and wonder how it was solved. environment VB6, sql server 5.0, windows 2003 server, xp sp2 clients Randomly getting data populated with first record information. original post was from looney064 on 6/24/08 Just joined so if this is out of format please …
Hello, I want to create database on SQL Server using Javascript and HTML. User will input following data. Server Name, Database name, File Sizes. When I will click "Submit" button database should be created on Selected server with entered name. I am using Client side HTML and Javascript. we need …
The reason is that : 1. I wish to run multiple databases on a single server. To do this securely each login must be granted db_owner on the database so we can use "deny view any database" to hide the other databases from view. (login can see all databases they …
please, I want a sql query that will return the no of fields in a database as an integer example i have table student columns are regno surname othername I want my result to be 3 what do i do??
hello i m using a library management software for which i need sql server while installing ms sql 2005 at one point installer gives me this message and throw me out. the message is " To continue, you must provide a strong sa password. To review strong password requirements, click …
m using visual studio 2005 and sql server 2005. i want to create a backup of the sql server which m doin using the following code.. [CODE] if (saveBackupDialog.ShowDialog() == DialogResult.OK) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = @"backup database dbname to disk =@loc with init,stats=10"; cmd.Parameters.Add("@loc", SqlDbType.VarChar); cmd.Parameters["@loc"].Value …
I created 2 tables 1 st table as csat csat_code csat_ou_cod csat_csaeid cus name CSA00001 ADM00001 6825 CUS08349 CSA00002 ADM00001 6826 CUS08347 CSA00003 ADM00001 6832 CUS08351 CSA02547 ADM00001 6824 CUS04150 table2 as csat_survey surveycode csat_code qns id ans id SUR00001 CSA02547 1 3 SUR00002 CSA02547 4 7 now i want …
Can anyone help me with why my insert statement won't work? I have tried countless tutorials online, but I cannot figure out what I am doing wrong. Can anyone point me int the right direction here? Here is my form: form: [code] <%@ Page Language="C#" AutoEventWireup="true" CodeFile="form.aspx.cs" Inherits="_form" %> <%@ …
I need some help I have managed to get this far (as below), from thatI can put a AAA_NUMBER and be able to get that record details and thats the 1st step that I wanted the 2nd step that I want is say if the DOCID is not available I …
here i have to search the database according to serial no and show the information of that serial no the problem here everything is fine and [CODE] Dim a As String Dim b As Boolean Dim dr As SqlDataReader Dim ConnStr As String ConnStr = ConfigurationManager.ConnectionStrings("gate").ConnectionString() Dim conn As New …
The End.