Click here to Skip to main content

Submit your article

Table

table

Great Reads

Data Auditing Tool (Audit Trigger Generator)

by J.Jash

Data Auditing Trigger Generator

How to click/select Row in ASP.NET GridView or HTML Table

by Technoses

The above code will slow down the browser and the browser can hang when Rows in Grid will be 10000 or above.Please view the below suggestion:CS Codeprotected void grvGroups_RowDataBound(object sender, GridViewRowEventArgs e){ if (e.Row.RowType == DataControlRowType.DataRow) { ...

How to update a row with another row if column values are null in SQL

by ManojKumar19

Update row column with another row column in same table SQL only if it is null.

ASP.NET Web Component for editing SQL tables

by RovenetBill

ASP.NET c# component for editing SQL tables with plug-in column format adapter architecture.

Latest Articles

How to Sort Two-Dimensional Array in C# by Selected Column Index in Selected Column Sort Order

by Perić Željko

Sorting Multi-Dimensional Arrays in C# with QuickSort Sort Extensions

Monitoring Real-time Database Changes in SQL Server in C#

by Telegram:@ArastoAhmadi

Tutorial to monitor database changes without using tools and by using a simpler trick

Search MySQL Like Google Using Match and Full-Text Search

by Arctype SQL

How to use full text search and the match keyword to find a string in every table in a MySQL database

Auto generate columns for bootstrap table grid in MVC

by Bart-Jan Brouwer

Use bootstrap tables with minimal coding on .Net Core 2.0!

All Articles

Table

How to Sort Two-Dimensional Array in C# by Selected Column Index in Selected Column Sort Order

12 Mar 2024 by Perić Željko

Sorting Multi-Dimensional Arrays in C# with QuickSort Sort Extensions

I had url http://website.aspx make a control center page in aspx from there button click go to that url make card of that mainpage.aspx in controlcenter.aspx

29 Jan 2024 by Mayank Kushwaha 2022

public partial class ControlCenter : System.Web.UI.Page { GetData GetConn = new GetData(); //protected PlaceHolder cardContainer; protected Panel cardContainer; protected void Page_Load(object sender, EventArgs...

Remove buttons after being clicked

24 Jan 2023 by Rebecca2002

hello I have a table with users order information. my admin has 2 buttons in that table they can click one gives the user a high discount and the other one gives them a low discount. only problem I'm having is that the buttons don't delete...

Am I heading in the right direction with a tree hierarchical table?

17 Jan 2023 by Mohamed Elanssary

Hello bro, Your code appears to be using the Vue.js framework to create a tree hierarchical table. You are using axios to make a GET request to retrieve data from a JSON file, and then using the map() method to iterate over the data and add a...

Am I heading in the right direction with a tree hierarchical table?

16 Jan 2023 by Petr Barabáš

I'm trying to create a tree hierarchical table in Vue.js. I don't have any side task, I am a beginner in Vue.js and wanted to deepen my knowledge. But I would like to know if I am doing it right. I don't know if I should solve my problem by...

How I can display my selected image in table instead of image name in javascript

28 Nov 2022 by robi mack

I am adding values (Product name, Price, Quantity, and image). If I click on add button then the table is showing all the values. But I want to display an image instead of an image name in the table. Here is the code of this. Can anyone tell me...

How to get updated data from express backend to client

4 Oct 2022 by JackF007

Hello, I'm having an issue with my Front-end/ back-end "communication". Basically I am developing a software that take some data from local folders (through express readDir method), then from this data I filtered, created arrays and return a...

Monitoring Real-time Database Changes in SQL Server in C#

8 Sep 2022 by Telegram:@ArastoAhmadi

Tutorial to monitor database changes without using tools and by using a simpler trick

Checkboxes clickable but not indipendent

6 Jul 2022 by JackF007

I have created a table with some data in each column and with a checkbox in the last column (for each row). The checkbox it is made with CSS and a bit of JS. I notice that even if I was able to display all the data properly(checkboxes included)...

Checkboxes clickable but not indipendent

6 Jul 2022 by Chris Copeland

This is probably because you're giving all of the elements the same id. The HTML - The id attribute[^] is supposed to be unique on a web-page, so having a with a for attribute for an id that isn't unique is going to behave...

Using map() callback function to populate a table

22 Jun 2022 by JackF007

Hello guys, I'm trying consistently to use a map() method in order to populate the rows of a table in Javascript. I setup the table for the HTML part in the index file and now I want to get the table populated with the data coming from an array...

Using map() callback function to populate a table

22 Jun 2022 by Richard Deeming

Quote: .map(callbackFn(dati)) You are not passing the callbackFn function as the callback to the map function. Instead, you are calling the callbackFn once, passing in the (undefined) variable dati as the parameter. You are then passing the...

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

15 May 2022 by Peta2010

Hi I am trying to run my search form and getting this error on result page Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /Applications/XAMPP/xamppfiles/htdocs/m/results.php on line 84No search results found...please search againMy code for...

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

15 May 2022 by Member 15636942

How to fix Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in D:\wamp64\www\liveSearch\livesearch.php on line 12 hello I have the same issue with my code and here is my code please help !

Remove duplicates from datatable

8 May 2022 by Member 11109279

I have a csv file which contains several columns of data, one of which is datetime and the rest are various values. There are multiple rows for which the datetime is the same and only one of the rest of the columns is different. I need to be...

Remove duplicates from datatable

8 May 2022 by Maciej Los

Your requirement is not quite clear. I'd suggest to use pandas.DataFrame[^] with methods: - read_csv[^] - drop_duplicates[^]. For example: #dataframe creation df = pd.DataFrame({ 'brand': ['Yum Yum', 'Yum Yum', 'Indomie', 'Indomie',...

Remove duplicates from datatable

29 Apr 2022 by Richard MacCutchan

You can manipulate Excel data with pandas or A Guide to Excel Spreadsheets in Python With openpyxl – Real Python[^].

Linq table relationship

12 Oct 2021 by adolphe5

How can I do aggregation on related tables?

Search MySQL Like Google Using Match and Full-Text Search

1 Apr 2021 by Arctype SQL

How to use full text search and the match keyword to find a string in every table in a MySQL database

I want to add export excel button to my table but I faile

5 Mar 2021 by Member 14574143

hi i am trying to add export excel button to my table here is my code:

C# how do I use array of a struct?

4 Mar 2021 by Thomas Dilley

This is my class assignment, which I do not understand. I have 100% in this class so far 4th week in and have a 3.8 GPA right now. This topic is confusing to me. I understand structs for the most part. What I don't understand is the context: ...

C# how do I use array of a struct?

4 Mar 2021 by OriginalGriff

Using an array of struct items is exactly the same as using an array of class items, with a few exceptions. You declare it the same way: myStruct[] array = new myStruct[10]; But because all struct items are value types rather than reference...

C# how do I use array of a struct?

4 Mar 2021 by Richard MacCutchan

Structure types - C# reference | Microsoft Docs[^]. Arrays - C# Programming Guide | Microsoft Docs[^]. So once you have defined your struct and its members you can create the individual instances of it. And each instance you create needs to be...

How do you drag to select multiple table cells on mobile? Asp.net

3 Feb 2021 by OneSpiked

I know this has been asked in different ways but I cannot find a solution to this. How do I drag to select multiple cells in a table on a mobile device? What I mean is something like this: JSFiddle link, but on a mobile device. Here is the...

How do you drag to select multiple table cells on mobile? Asp.net

3 Feb 2021 by raddevus

Probably have to work with touchstart, touchmove, touchend touchstart Event[^]

How to create a table out of a nested JSON using tabulator

9 Dec 2020 by Ammar9191

I'm still new to Javascript and HTML, I'm trying to create a table to display reports extracted from firebase RT Database. I'm Getting the following Error: Uncaught TypeError: this.options.data.slice is not a function at...

How to create a table out of a nested JSON using tabulator

9 Dec 2020 by BabyYoda

According to the documentation the data option should be an array, not a json string, Tabulator[^]. Try the example in the documentation and it will likely work.

Sql server table questions

8 Dec 2020 by Member 15010041

How/Where can I figure out the answers to these set of questions below in SQL Server?: -Is the data in this table modified in any way? -What is the data refresh frequency of this table? -Do they keep historical data for each month this gets...

SQL-Server-2016

Sql server table questions

8 Dec 2020 by CHill60

In response to your comments.. Quote: -Is the data in this table modified in any way? You would need to know if there is any audit of data changes on the table. It might be a "temporal[^]" table for example or there may be asssociated Triggers...

SQL-Server-2016

Sql server table questions

8 Dec 2020 by OriginalGriff

The questions depend on the table design they are discussing - and we have no access to that - and the code that is running against them - and we have no access to that either. Even if we did, while we are more than willing to help those that...

SQL-Server-2016

Sql server table questions

8 Dec 2020 by Richard MacCutchan

As a new DBA you probably need to find some good training materials: sql server learning - Google Search[^].

SQL-Server-2016

How to store the formatted paragraph text in SQL server table

31 Oct 2020 by OriginalGriff

You are using HTML formatting - so just keep the whole HTML as a string, and save that to an SQL column as a parameter, just like any other string. When you pull it back, it's still HTML so it's still formatted ready for web display.

How to store the formatted paragraph text in SQL server table

31 Oct 2020 by Virendra S from Bangalore, Karnataka

user will enter his profile summary in a webform. text will be formatted with bold, string, underline stuffs. hw to store this type data in sql server table. sample text: What is Lorem Ipsum? Lorem Ipsum is simply dummy text...

How to add top padding in table?

21 Oct 2020 by Member 14911464

Use set margins. pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); pdfDoc.SetMargins(20f, 20f, 20f, 20f); You can change the padding size according to your need.

How to add top padding in table?

21 Oct 2020 by Member 11266633

I have table with 6 cells. I make property table.KeepTogether = true;. How add padding to top of table?var table = new PdfPTable(6); table.SplitLate = true; table.SplitRows = true; table.DefaultCell.Padding = 2; // Not work ...

Restrict field selection based on criteria in ms access

12 Oct 2020 by muneermohd9690

i have an employee table which has a field named department.i want the users to receive a message that no more employees can be assigned to this department because a certain limit has reached.the users will be using forms in ms access to insert...

Restrict field selection based on criteria in ms access

12 Oct 2020 by muneermohd9690

thanks i have received a solution for this which is as below.i have created a global module which contains the below function to calculate the current number of employees Option Compare Database Option Explicit Global hrcount As Integer Global...

How to set select option from table cell value

28 Jul 2020 by Paramu1973

Thank Richard, I found the following codes gave me the solutions for Dynamic Select Options. Code ...

How to set select option from table cell value

28 Jul 2020 by Paramu1973

It's my first project. I have 2-tables like table1, table2 contains 2-columns with data's. Now I wish to set to my table2 Select ID="counts" Option value & text from table1 cell values... like one,two,three,four,five,six Is it possible? Thank for...

How to set select option from table cell value

27 Jul 2020 by Richard MacCutchan

you have still not explained your problem. however, maybe this is what you need to look at: HTML select tag[^].

How do I get the table object so I can insert or delete it?

26 Jul 2020 by aazam rafiee zade

Hello Suppose there is a database and a table with 4 records The database closes and I close the program When I open the program, I establish a connection to the database Now how do I get the table object so I can insert or delete it? ...

How do I get the table object so I can insert or delete it?

26 Jul 2020 by Sandeep Mewara

Table1 tbl= db.Table(); Return datatype of db.Table() is not of type Table1 You need to assign it to correct datatype or to var and then accordingly use it.

Whats the simpliest way to create this pivot table?

2 May 2020 by MadMyche

Probably the most important thing to include with your question is to be specific with the environment information. I also have data stored out in the cloud. It happens that I happen to be working with MS SQL Server which actually has native...

Whats the simpliest way to create this pivot table?

2 May 2020 by Member 14819668

Hello all! I'm a newbie here, and 've been looking through the forum but I'm so lost ill be needing a bit of help. I'd like to know where should I start reading/learning in order to do the following: I have a hosted SQL table with sales info...

How do I change permanently another <td> bg color on click

20 Feb 2020 by MichaelConsta

yes you are right, i have tried the code you have provided and i thank you sir, i have added the highlight table cell "onclick" and i have added the code for maximum reach you have provided as well, this is the code now, how it look like, it just...

How do I change permanently another <td> bg color on click

20 Feb 2020 by MichaelConsta

hello there my good people .. i am new in programming and i need some help please .. so i am trying to make a table of 90 numbers that i can check only six digits of them, you know, like the lottery table, and i have really did something very...

How do I change permanently another <td> bg color on click

20 Feb 2020 by TheRealSteveJudge

You can achieve this by adding some javascript between the head tags. var counter = 0; document.addEventListener('click', function mark (e) { if(counter === 6){ alert("Maximum reached."); return; ...

How to have menu "filling up" next column as it expands vertically

13 Jan 2020 by Carina Rosborg Thornval

Please forgive my simplistic description, I am still in the process of familiarizing myself with coding. I am working on a page where I currently have a menu of 12 projects. On hover a project is underlined and on click a project expands vertically displaying a description. I have used a table...

How to have menu "filling up" next column as it expands vertically

13 Jan 2020 by W∴ Balboos, GHB

A strategy (from someone who also uses tables with no regrets. - You need to consider how many rows you wish to allow before changing columns. - Detect the number of rows you need to display in your menu. - If the threshold is exceeded then you take advantage of built-in conditionals in your...

How do you overflow-x and y HTML tables using CSS or bootstrap 4?

2 Jan 2020 by Member 12744455

I have a basic html table with 10 columns. I am trying to add a horizontal scroll bar and vertical scroll bar on overflow of the table and am having a really tough time. What is happening now is the th and td content are overflowing with the cell and the thead th and tbody td are misaligned. ...

How do you overflow-x and y HTML tables using CSS or bootstrap 4?

2 Jan 2020 by Harsh.Shah.ifour

Hi Remove table-layout:fixed from thead,tbody tr {...}. because of this your horizontal scrollbar is not showing. After removing it, you will get horizontal scroll bar in your table. But you'll get two scrollbar because you have added overflow:auto to the both table as well as tbody. so remove...

returning Last Insert ID from mysql query with c#

11 Oct 2019 by Pazout

SELECT LAST_INSERT_ID();

returning Last Insert ID from mysql query with c#

11 Oct 2019 by Member 10441019

I have table employee(empID, fName, lName)position(positionID, positionName)empPosition(empID, positionID, dateChanged, INDEX(empID), INDEX(positionID))I am doing this code cmd.CommandText = "INSERT INTO employee (empID, fName, lName)" + "...

Error on query below conversion faild when converting 5/1 to int

12 Feb 2019 by ahmed_sa

problem error on query below conversion fails when converting 5/1 to int DataSample SpecialCode expr1 EXPR2 000151/1 000151 1 000151/2 000151 2 000151/3 000151 3 006495/1 006495 1 006495/2 006495 2 data above not have...

Error on query below conversion faild when converting 5/1 to int

12 Feb 2019 by OriginalGriff

If I extract your code to check, and use your sample data: DECLARE @SpecialCode NVARCHAR(MAX); SET @SpecialCode = '000151/1' SELECT CAST(CAST(LEFT(@SpecialCode, CHARINDEX('/', @SpecialCode + '/') - 1) AS nvarchar) AS int) AS expr1, CAST(CAST(substring(@SpecialCode, CHARINDEX('/', @SpecialCode)+1...

How to update temp table from another table?

30 Oct 2018 by CHill60

You are getting the error on the line UPDATE @Statement SET INTAKEM = A.INTAKEM, INTAKEY = A.INTAKEY FROM [dbo].[AD_StudentRecord] A WHERE @Statement.SID = A.SID If you want to update a table (actual table, table variable or temporary table) with values from one or more other tables, then you...

stored-procedure

How to update temp table from another table?

29 Oct 2018 by Maideen Abdul Kader

Hi I have in issue in update @temp table column from another table column value. Once run Stored procedure, below is error " Msg 137, Level 16, State 1, Procedure usp_Report_Statement, Line 43 [Batch Start Line 7] Must declare the scalar variable "@Statement". Pls advice me Thank you in...

stored-procedure

C# - LEFT OUTER JOIN using lambda expression throws “object reference not set to an instance of an object”

20 Oct 2018 by OriginalGriff

This is one of the most common problems we get asked, and it's also the one we are least equipped to answer, but you are most equipped to answer yourself. Let me just explain what the error means: You have tried to use a variable, property, or a method return value but it contains null - which...

C# - LEFT OUTER JOIN using lambda expression throws “object reference not set to an instance of an object”

20 Oct 2018 by Member 13974276

I have two tables as shown below Table 1 - LR ID___________Name 1 A 2 B 3 C Table 2 - Mapper ID___________LRID 1 1 2 1 3 2 The Mapper table refers LR table. I am trying to get the data from LR table wherever the IDs...

How do I make my datagridview update faster

10 Aug 2018 by Gerry Schmitz

1) Use a "data source" instead of updating the grid directly or 2) Use an array of text boxes / labels (or some other "light weights") or 3) Condense all "columns" (in a row) to a single "status row / line / text"; obvious elements do not each need a "column" (and header).

How do I make my datagridview update faster

10 Aug 2018 by Jasonwc

Hi All I have a program that regularly updates a few data grid views with new data that is received via TCP. The problem I am having is that the screen refresh is quite slow. Bellow is a stripped back version of my code. This example takes 1.1s to update the screen each time the loop in...

Repeating data from database?

2 Aug 2018 by Member 13933133

Hi, I would like to tell you about the problem I have to see if someone can help me. I have created a table in a database with the following columns: Table: unionexercise_id_fk tag_id_fk 1 1 1 2 2 1 2 3 What I pretend with my...

Repeating data from database?

2 Aug 2018 by Jochen Arndt

What you are looking for is the SQL DISTINCT keyword which returns only distinct (different) values. Also your SQL command is much too complicated (contains redundant information). As far as I understand, you want to query the single table 'union' for a single field. Then the general syntax...

What are the laboratory equipment table fields in SQL server

21 Jun 2018 by OriginalGriff

That isn't a question we can answer: there are no "standard laboratory equipment" fields for any database. You have been set a task, and it's your job to work out what information you need to store - we can't help with that because we have no idea what information you have available about your...

How to create a table in excel from datatable in C#

17 May 2018 by Richard MacCutchan

See Microsoft.Office.Interop.Excel namespace ()[^].

How to create a table in excel from datatable in C#

17 May 2018 by Member 13721474

I have to create the table in excel from the existing datatable and need to create a pivot table for the given column in the tale . What I have tried: I have the datatable and I don't know how to proceed

String or binary data would be truncated. The statement has been terminated

16 May 2018 by Member 13828533

The script runs daily between 2am and 6am along with several others. I used a timeframe to start with a smaller dataset and slowly increased it until i found the exact day the error occured. Extracted the last "good day" and first bad day, did a MAX Len comparison in Excel and surprise - there...

String or binary data would be truncated. The statement has been terminated

16 May 2018 by Member 13828533

I tried the suggestions found elsewhere on here....the table as it was created has a varchar length of 255 in SQL SMS. The coding which was apparently working before (stopped updating last month) used a "Cast"command to convert via varchar. I tried changing these lines in the code to 255 and it...

String or binary data would be truncated. The statement has been terminated

15 May 2018 by OriginalGriff

Start by looking very closely at your data - bd, tt, and sp - and see exactly what they contain. Check their datatype: I'd expect a lat or long to be either a float (for DDD.dddd format) or a string (for DDD MM SS + compass and similar formats). For strings, look to see if there are any "odd...

How do I make the horizontal borders collapse in 2 adjoining tables

7 May 2018 by User 7429338

You can't collapse the border of two tables like that unfortunately, but it would be an option to hide the bottom border of your first table: CSS: .table0 { border-bottom:0px; } HTML: Cell A1

How do I make the horizontal borders collapse in 2 adjoining tables

7 May 2018 by Member 13798280

Can someone please tell me how I can make the adjacent horizontal borders of the 2 adjoining tables collapse so that they conform to the rest of the table borders? Thank you. /* http://meyerweb.com/eric/tools/css/reset/ v2.0 | 20110126 License: none (public domain)...

Migrate some SQL server tables to new database

29 Apr 2018 by Wendelius

A simple way would be to use INSERT INTO...SELECT FROM query to copy the relevant data from database A to database B. After a successful copy, just delete the source rows. In order to avoid identity problems use SET IDENTITY_INSERT (Transact-SQL) | Microsoft Docs[^] Also you probably need to...

Migrate some SQL server tables to new database

29 Apr 2018 by Christopher Fernandes

I have a database named CommonApps in SQL Server 2008 EXPRESS Advanced. Currently, two apps store their data in this DB. I did this because I did not want to create 2 profiles for all users for accessing these 2 apps. Now it has become hectic to troubleshoot any issues as both apps go offline in...

How to return multi tables in postgres without refcursor?

24 Apr 2018 by Wendelius

As far as I know PostGres does not support multiple result sets without cursors like SQL Server does. Basically you could join the result sets for example using UNION ALL operation but that would require that the structure and the data types of both results sets are the same. Based on your...

How to return multi tables in postgres without refcursor?

24 Apr 2018 by souviksardar

I have one procedure in sql server like this::::: CREATE PROC SP_FetchData() as begin select FirstName, LastName from TBl_Users; select TaskId,CreatedBy from TBl_Log; END; I want execute the same query in postgres function without using refcursor. how can I do it? What I have tried: CREATE...

Sql query show on single line

29 Mar 2018 by Member 13751304

Trying to show on single row Currently looks like MS18-03-W10 NULL 5526 MS18-03-W10 24249 NULL Would like MS18-03-W10 24249 5526 What I have tried: Select Distinct p.name ,Case When i.installed = '1' then count (c.name) End ,Case When i.installed = '0' then count (c.name) End From...

Sql query show on single line

29 Mar 2018 by Wendelius

As mentioned in previous solution, using windowing functions is one possibility and another could be just summing up the values on an outer query. Something like SELECT sub1.Name, SUM(sub1.Installed), SUM(sub1.NotInstalled) FROM (SELECT p.name, CASE WHEN i.installed...

Sql query show on single line

29 Mar 2018 by Santosh kumar Pithani

Select Distinct p.name ,SUM(Case When i.installed = '1' then 1 End) OVER(PARTITION BY p.name ORDER BY p.name) AS [Installed] ,SUM(Case When i.installed = '0' then 1 End) OVER(PARTITION BY p.name ORDER BY p.name) AS [Not Installed] From...

Sql query show on single line

29 Mar 2018 by Member 13751304

Close but not quit what I am looking for I need to have on one row Bulletin Name Installed Not Installed MS18-03-W10 17952 563 MS18-03-MR7 18563 2056

Sql query show on single line

28 Mar 2018 by #realJSOP

Try this: SELECT p.name, SUM(CASE WHEN i.installed = '1' THEN 1 ELSE 0 END) AS counter FROM vRM_Software_Bulletin_Item_ExactType AS p LEFT JOIN vPMWindows_ComplianceReportsDrilldown AS i ON i.SoftwareBulletin = p.Guid LEFT JOIN vcomputer AS c ON c.guid = i._ResourceGuid WHERE...

Php button not working.

15 Mar 2018 by Jochen Arndt

In employees.php you have the form "add_employee" with action employees.php and a submit button named "add". If that button is pressed, employees.php is called with $_POST['add'] set. That should work because employees.php includes employee_process.php which checks the parameter. You have also...

Php button not working.

15 Mar 2018 by NexGen39

I have two PHP files; employees.php, and profile.php. For employees.php a table is displayed with a delete button beside each record, and for profile.php there is a save button at the bottom. The problem is the same for both files, the button doesn't work. Both the delete button and the save...

I want to pass id of product from previous page to next page?

14 Mar 2018 by W∴ Balboos, GHB

You're using php - so look into $_SESSION. One helpful hint: creating a session must be the ABSOLUTELY first thing on a page, PHP 5 Sessions[^] There are other ways to do this (forms, AJAX, part of a URL target), but this is a "pure" answer to your question.

I want to pass id of product from previous page to next page?

14 Mar 2018 by Member 13700746

There is two table one for product deatils and second for product images.. product detail is inserted in table and it redirect to another page for insertion of that product image.. i want to pass product id from one page to another page for insertion of that product image How to pass product...

How can I add PHP code to allow users to add favorite names?

7 Feb 2018 by Member 13637584

So i have a table named: BabyNames I have attributes: BoyNames, GirlNames, UserID and Favourites - i have added the last two in so I can add a favorite option On my php script, there is script in which allows user to select a letter and it displays the baby names related I also want them to...

How to select top 1 vaue in mysql

29 Jan 2018 by Member 9983063

Hello Guys, I want to know how to select top 1 value in MySQL order by Desc please see my code am getting error and I cannot get values please help me thanks What I have tried:

How to select top 1 vaue in mysql

29 Jan 2018 by CPallini

If you need just a single row, why don't you use LIMIT 1 in your query? By the way, your query looks correct, however you failed to report here the exact error message as well the table structure.

Extract text from span class from a table

29 Jan 2018 by JayyMehta

Hi, I have this website, where I want the details of the product to be extracted in my excel sheet. I coded by my own... But I am getting an error in the line: If objdiv4.className = "Section" Then So here's the full code: What I have tried: Sub onmyown() Dim ie As InternetExplorer Dim doc...

How to: from MS access create a ODBC table link to datatable inside a DOT NET APP

21 Dec 2017 by DataMig

How To: From MS Access create a ODBC Table Link to DataTable inside a DOT NET APP So the DOT NET APP is like a poor mans SQL Server (or Data Server) The Data is in memory and does not need to be persisted or saved Pointers in the right direction would help Many Thanks In Advance m ...

How to: from MS access create a ODBC table link to datatable inside a DOT NET APP

21 Dec 2017 by Dave Kreskowiak

You have to create a provider one of the database drivers installed on the system, such as OLEDB, ODBC, or whatever. THIS IS FAR FROM A TRIVIAL TASK!! The documentation on this subject is very sparse. You can find the start of it here[^]. More on a few samples (NONE OF WHICH ARE VB.NET OR C#!)...

How to add vertical lines in HTML table through CSS in wordpress?

11 Dec 2017 by Member 13558709

I'm using Genesis theme on latest Wordpress. Vertical lines seem to be missing from my HTML tables.Even though it looks modern, it sometimes causes confusion. I don’t require vertical lines at starting and ending of the column. I require it only in between the column. But if it not possible,...

How to add vertical lines in HTML table through CSS in wordpress?

11 Dec 2017 by Member 13558709

Kastriotcunaku, thanks for your code and it works fine. Here is the compressed version of the CSS code, if anyone want to use: th:not(:last-child), td:not(:last-child) { border-right: 1px solid #eeeeef; }

How to add vertical lines in HTML table through CSS in wordpress?

11 Dec 2017 by kastriotcunaku

Go to Appearance > Customize and add some custom CSS: th, td { border-right: 1px solid #eeeeef; } th:last-child, td:last-child { border-right: none; } Now it should show borders between columns.

How do I create an A3 size attendance sheet?

31 Oct 2017 by lionkings

I work in an office where we have to design a month's attendance register using excel sheet by marking days and holidays and typing employee names. I need to design an A3 size document or a picturebox using vb.net to simplify this process. I don't need to work with data as the sheet will be...

How do I create an A3 size attendance sheet?

31 Oct 2017 by OriginalGriff

We can't give you the "full details" - it's a whole app, and would need more than we can provide in a little textbox like this! But printing is relatively simple: use the PrintDocument Class (System.Drawing.Printing)[^] and you have full control over what happens. In the PrintPage event...

Getting null value from database

20 Oct 2017 by Member 9983063

Hello Guys, I am facing an issue that is I get value null from DB I have values in my DB but in my form when I select so I get null please help me how can I do it What I have tried: con_string.ConnectionString = @"Provider = Microsoft.ACE.OLEDB.12.0;Data Source...

Getting null value from database

20 Oct 2017 by PIEBALDconsult

Just off the top of my head; something like this might serve you better. con_string.ConnectionString = @"Provider = Microsoft.ACE.OLEDB.12.0;Data Source =|DataDirectory|\Restaurant.accdb;Persist Security Info=False"; con_string.Open(); System.Data.IDbCommand cmd = con_string.CreateCommand()...

My form getting freeze and close on onload

20 Oct 2017 by Member 9983063

Hello, Guys, I am facing another issue that is my form getting freeze and close on onload please check my code and suggest me the solution Thanks in advance What I have tried: con_string.ConnectionString = @"Provider = Microsoft.ACE.OLEDB.12.0;Data Source...

My form getting freeze and close on onload

20 Oct 2017 by Patrice T

Already 92 questions and you still don't the basics of debugging da2 = new OleDbDataAdapter(@"SELECT column2," + "Sum(MediumVal) As [Dine In] " + "Sum(LargeVal) As [Deliery], " + "Sum(RoyalVal) As [Take Away], " + "From ( " + "SELECT " + "column2 As [column2]" + ",Switch(column3 like 'DineIn%',...

Auto generate columns for bootstrap table grid in MVC

12 Sep 2017 by Bart-Jan Brouwer

Use bootstrap tables with minimal coding on .Net Core 2.0!