Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About

Tag: single

ASP.Net MVC / C#

Using View Model to pass Multiple Models in Single View in MVC

- 22.06.19 | 22.11.19 - ErcanOPAK comment on Using View Model to pass Multiple Models in Single View in MVC

In MVC we cannot pass multiple models from a controller to the single view. There are a few solution for that problem. But in this article we will use View Model. Here is the solution:

Continue Reading ..
MySQL / PHP

How do you connect to multiple MySQL databases on a single webpage?

- 05.05.19 | 14.04.20 - ErcanOPAK comment on How do you connect to multiple MySQL databases on a single webpage?

You can make multiple calls to mysql_connect(), but if the parameters are the same you need to pass true for the ‘$new_link‘ (fourth) parameter, otherwise the same connection is reused.

Continue Reading ..
SQL

How to concatenate text from multiple rows into a single text string in SQL server?

- 19.04.19 | 22.11.19 - ErcanOPAK comment on How to concatenate text from multiple rows into a single text string in SQL server?

STUFF((SELECT ‘, ‘+ Column1 FROM Table1 FOR XML PATH(”)),1,1,”) AS ConcatenatedColumn StudentName ————- Mary John Sam Alaina Edward Result: Mary, John, Sam, Alaina, Edward

Continue Reading ..
SQL

Replace duplicate spaces with a single space in SQL

- 11.06.18 | 14.04.20 - ErcanOPAK comment on Replace duplicate spaces with a single space in SQL

SELECT REPLACE(REPLACE(REPLACE(‘ With this query you select single spaces’,’ ‘,'<>’),’><‘,”),'<>’,’ ‘) OUTPUT: With this query you select single spaces

Continue Reading ..
May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Apr    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (333)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (222)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (191)
  • Find numbers with more than two decimal places in SQL (191)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (190)
  • Confirm before process with ASPxButton in Devexpress (189)
  • How to make some specific word(s) Bold or Underline in ReportViewer (189)
  • Devexpress ASPxGridview Column Grouping in Code (177)
  • Add Constraint to SQL Table to ensure email contains @ (174)
  • Tense Changes When Using Reported Speech (167)

Recent Posts

  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#
  • How to lock the ciritical code part in C#
  • How to make theater mode the default for Youtube
  • How to turn off YouTube annotations and cards
  • How to hide Youtube chat windows permanently
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server

Recent Posts

  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (333)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (222)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (191)
  • Find numbers with more than two decimal places in SQL (191)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (190)

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

powered by XBlog Plus WordPress Theme