341 Topics
| |
Hi, My Crystal Report is using VB.NET and Sql server 2005. The report can be displayed but everytime it will prompt me to key in the Username n Password.. is there anyway to automatically pass the login information to reports? thanks =) | |
So, I have made a table called `supplies_table` and inside the table is `id`, `name`, and `files`. And I also made an upload button where it can upload a pdf BLOB file into the `files` column. Yes, it can upload a pdf file in the `files` column but the problem … | |
**There are 2 tables as orders$ and 'order items$'** orders$ Table have 4 columns as order_id, customer_id, status, order_date 'order items&' Table have 4 columns as order_id, item_id, product_id, quantity I want to modify the SQL statement to show an average number of products each customer had on their orders. … | |
Hi all. i have a trouble of my testing project. could anyone can guide me to solve the problem. million thanks~~ newbie of programming. error : System.Data.SqlClient.SqlException: 'Incorrect syntax near 'card'.' string connectionstring = ConfigurationManager.ConnectionStrings["library2ConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionstring); con.Open(); string sql = "Select librarycardid, password" + "from library … | |
Where is the SQL Server Database Trigger Wizard or Dialog Box? This question is about SQL Server In the past, I have created a stored procedure that was run on a timely basis by (if I remember correctly) a database trigger. As I recall, there was a wizard (dialog box … | |
I have learning this from youtube,php quiz using ajax. I am facing problem when click on next button after last question it is not redirecting on final page. Please help me to fix this. I think responseText not working. Question.php page to where i display question <script type="text/javascript"> var questionno="1"; … | |
Find product who hasn't had any sales in first three months of the year? | |
![Screenshot_(2).png](https://static.daniweb.com/attachments/4/c0a0afbf51cd49a05979817aec55aae8.png) ![Screenshot_(1).png](https://static.daniweb.com/attachments/4/64076d813428db9ea62993455ba6feb8.png) | |
I want connect microsoft sql server database using servername,username,password,port number and service name to asp.net api 2019. This code segment I'm using SqlConnection con = new SqlConnection(@"server=10.d.13.2q0; database=sdssdsd; Integrated Security=False; User ID=lmgdgdfdfddgs; Password=sdsdsdsds"); please help me. what is the correct code | |
Like the title says, I'm trying to coloring an empty cell in bounded datagridview. I've got this code to coloring a cell with specitic value and is working well. This code is in the DatagridviewCellFormattingEventargs. If e.ColumnIndex = 5 AndAlso e.Value <= Date.Now.ToShortDateString Then e.CellStyle.ForeColor = Color.DarkGreen e.CellStyle.Font = New … | |
I have a project where I need users to be able to save their work, then at a later date select the session/data from their previous work and continue. I have completed all of the coding (and it works) to save the current session under their userid, and populates a … | |
Hi All, I am having an issues with an SQL query and I can't quite work out how to resolve it. I have searched Google for the answer but can't seem to find the solution there either. Basically I have a database andin one of the tables it has a … | |
I'm utilizing phpMyAdmin to deal with my information bases, I have 2 tasks that utilization 2 diverse data set the first uses 'root'@'localhost' and the second is 'root'@'127.0.0.1' I don't have the foggiest idea how I wound up utilizing 2 distinctive worker however it was working fine until I attempted … | |
please provide me sql query for below output sum query please help me ![93852217_246197733117734_2443195689677619200_n.jpg](/attachments/large/4/5009c5b4125b294842ffd7cf1d839caa.jpg) | |
Hello guys, i've the following table in database : IdCity int CityName nvarchar(20) it has the data like this in it : IdCity CityName 1 Абакан 2 Азов 3 Александров 4 Алексин 5 Альметьевск 6 Анапа when i try to run the following view SELECT IdCity, CityName FROM dbo.City WHERE … | |
Hi all :) Currently now I used MS SQL Server Management Studio 2008. I have an existing table with data already store on that table. Table Name : Application Column : Categories (nvarchar(1), null) Sequence (nvarchar(1), null) Detail (nvarchar(150), null) I would like to ask how to add primary key … | |
All Time Show Null value Please help me what is the wrong in my code declare @mxdbvlu int declare @dbvlunm int set @mxdbvlu= (select max(Database_name) from TBL_FY_SELECT_1) if @mxdbvlu = null set @dbvlunm=1000 else set @dbvlunm=sum(@mxdbvlu+1) select @dbvlunm,@mxdbvlu | |
in sql server there is a group problem statement: DENSE_RANK() OVER (ORDER BY TABLUONGNV3.HOVATEN) AS STT How to write in sql access issues in groups? I'm not writing well: (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT SELECT (Select Count (*) FROM [TABLUONGNV3] … | |
My data SQL Server is reported this error, How does this error fix you ? SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x5555aaaa). It occurred during a read of page (1:210768) in database ID 7 at offset 0x00000066ea0000 in file 'G:\Database\MyData.mdf'. Additional … | |
Show error when I login to the SQL server management. First, I change the server name. Second restart the server/1st stop services the start services. Then I check the server name SELECT @@servername AS 'ServerName' using this line the show new change server name. Then I closed the window of … | |
TITLE: Connect to Server ------------------------------ Cannot connect to (LocalDb)\MSSQLLocalDB. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote … | |
Please, why I got this error(SQL Error: ORA-00907: missing right parenthesis ) whats wrong in my code? CREATE TABLE DomeniuAB(ID_DOMAB NUMBER(10) constraint ID_DOMAB_PK PRIMARY KEY , DENUMIRE VARCHAR2(20) NOT NULL, DETALII VARCHAR2(20) NOT NULL, ISBNAB_CarteAB VARCHAR2(15), CONSTRAINT ISBNAB_FK FOREIGN KEY (ISBNAB_CarteAB) REFERENCES CarteAB(ISBNAB), CNPAB_AutorAB NUMBER(10), CONSTRAINT CNPAB_FK FOREING KEY (CNPAB_AutorAB) … | |
Hi there here is a stupid question. I have created an update statement that updates a table that has null user id using a name as the identifier: [CODE] UPDATE dembel SET userid = 8908 WHERE [Name] = 'o'reily' [/CODE] However the the name already contains an apostrophe which causes … | |
Hi, I need help to create a relational database for shop.The database should contain a column for barcode in order to register items and also to read details of items using barcode scanner.Besides this database will contain tables for performing all operations for shopping store items what are those operations … | |
I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset | |
I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset | |
can we able to count how many number of resultset is returned by a stored procedure? i have a sp which will result in multipe resultset. more then 6.sometime 4 sometime 6 based on the parameters. so i need to count how many resultsets are returned by the sp | |
I want to calculate the total conditional in the month but remove the records that are not the same month and not the same year, the condition that eliminates the view on the sql access because the result is true or false in the excel file http://www.mediafire.com/file/kq2mr2v6px1uxan/exercise.rar DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]),[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000))) … | |
Sir I have this data ![Untitledg_jygukg.png](/attachments/large/4/e33bd064d12c1ff9b76646dc9376d4de.png) Group by hours Or First value of every hour Please help | |
A long shot I know but a colleague has left, leaving behind a couple of access databases that query each other and a sql database, unfortunately one of the databases querys now takes a long time to run to the point that the excel report calling the query timeouts. is … |
The End.