341 Topics

Member Avatar for
Member Avatar for potatochips

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 =)

Member Avatar for lauryfriese
0
12K
Member Avatar for aibreansiyue

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 …

Member Avatar for gce517
0
128
Member Avatar for mhzone21

**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. …

Member Avatar for pritaeas
0
29
Member Avatar for BB2020

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 …

Member Avatar for pritaeas
0
51
Member Avatar for complete

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 …

Member Avatar for rproffitt
0
28
Member Avatar for Rishabh_8

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"; …

0
83
Member Avatar for Asire
Member Avatar for jwenting
0
85
Member Avatar for tanpuia

![Screenshot_(2).png](https://static.daniweb.com/attachments/4/c0a0afbf51cd49a05979817aec55aae8.png) ![Screenshot_(1).png](https://static.daniweb.com/attachments/4/64076d813428db9ea62993455ba6feb8.png)

Member Avatar for Dani
0
53
Member Avatar for Udara_1

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

Member Avatar for rproffitt
0
117
Member Avatar for Luc001

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 …

Member Avatar for M.Lingo
0
342
Member Avatar for Greg_11

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 …

Member Avatar for JeanMilburn
1
341
Member Avatar for sols4comp

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 …

Member Avatar for pritaeas
0
110
Member Avatar for yjz07763

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 …

Member Avatar for rproffitt
0
21
Member Avatar for nishita_1

please provide me sql query for below output sum query please help me ![93852217_246197733117734_2443195689677619200_n.jpg](/attachments/large/4/5009c5b4125b294842ffd7cf1d839caa.jpg)

Member Avatar for Santanu.Das
0
315
Member Avatar for mohamedrani

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 …

Member Avatar for andrevanzuydam
0
981
Member Avatar for nimz143

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 …

Member Avatar for Purvi_1
0
302
Member Avatar for JModak

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

Member Avatar for john_111
0
4K
Member Avatar for dongtrien

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] …

0
269
Member Avatar for dongtrien

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 …

0
205
Member Avatar for JModak

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 …

Member Avatar for sanjay.vaniya
0
5K
Member Avatar for sanjay.vaniya

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 …

Member Avatar for rproffitt
0
381
Member Avatar for Tanase

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) …

Member Avatar for JamesCherrill
0
2K
Member Avatar for Ziggynet

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 …

Member Avatar for Sherin Mathew
0
418
Member Avatar for Programming_2

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 …

Member Avatar for rproffitt
0
415
Member Avatar for Menzk

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

0
330
Member Avatar for Menzk

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

0
291
Member Avatar for Menzk

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

0
288
Member Avatar for dongtrien

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))) …

0
331
Member Avatar for phphp

Sir I have this data ![Untitledg_jygukg.png](/attachments/large/4/e33bd064d12c1ff9b76646dc9376d4de.png) Group by hours Or First value of every hour Please help

Member Avatar for AndrisP
0
284
Member Avatar for Magic8Computing

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 …

Member Avatar for rproffitt
0
383

The End.