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

Add some AI to your combo box lookups

15 Dec 2010 by hector [.j.] rivas

Helping the combo box autocomplete function with a frequency count.

artificial-intelligence

adding rows dynamically to an html table using JQuery in Asp.Net C#

31 Jul 2014 by Member 10924493

im having checkboxlist in my webpage and i created an html table in .aspx page now i want to add rows when an item in checkboxlist is checked. Help Me,Thank you

adding rows dynamically to an html table using JQuery in Asp.Net C#

31 Jul 2014 by Sibeesh Venu

You can try the append method in jquery . See the example here$("#dynamicTable").append("AgencyUserNameID"); employees = [ { "Agency":...

Adding, Updating and Deleting in the grid box - NOT THE NORMAL WAY!

27 May 2013 by cluelessentity

I am making an admin main page for my website.It contains a drop down box that should retrieve the name of all the tables in the db.When a table is selected, the contents of it should be displayed in the grid box.Once the contents are displayed a user can update/edit/add/delete using the...

ADO.Net - How to Check existence of a table in Oracle

18 Sep 2013 by Member 10454592

I got a piece of code to check the existence of a table from . This is applicable for [^]. The revised code for OleDB is below:public bool CheckTableExist(OleDbConnection conn, string tblName){ bool b = false; string[] restrictions = new string[] { null, null, tblName }; ...

ADO.Net - How to Check existence of a table in Oracle

18 Sep 2013 by hypermellow

You can usually find this in Oracle by checking the user_tables object.Something like this should do it:SELECT COUNT(table_name) FROM user_tables WHERE table_name='tlbNameToCheckFor'

Alingment Problem on Table in diffrent Browsers RSS

7 Mar 2013 by Venki Desai

Hi All,This is my sample design ***** SOME NONSENSE HERE...

Alingment Problem on Table in diffrent Browsers RSS

8 Mar 2013 by Venki Desai

***** SOME NONSENSE HERE ***** ...

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

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

ASP Repeater Control and Export to Excel

11 Oct 2013 by ASP.NET Community

ASP Repeater ControlThe Repeater control is used to display a repeated list of items that are bound to the control. The Repeater control may

Asp.net MVC . How to display name instead of ID in view page?

6 Feb 2017 by Francesco Bigi

Hello People!I have in issue with my Views.Explain: I have a db with several tables, related with primary and secondary keys.Tables: ArticleCategorySubCategoryWhat I am trying to do is, show a list of products with different category.But instead of a the name it shows me the...

Asp.net MVC . How to display name instead of ID in view page?

4 Feb 2017 by Ehsan Sajjad

If the Model class which you have shown above is the Entity Model class which is mapped to your database, which is quite clear from your code, you would need to create a ViewModel class and use that in your view, so create a ViewModel first: public class ArticleViewModel { ...

Asp.net MVC . How to display name instead of ID in view page?

6 Feb 2017 by Francesco Bigi

Hello @Ehsan Sajjad,thanks for your help.I Arrived to solve like this:var lstArt = new List(); using (var ctx = new WebShopEntities1()) { lstArt = ctx.Article.Select(a => new ArticleModels() { ...

ASP.NET Web Component for editing SQL tables

29 Nov 2012 by RovenetBill

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

assign a value in a table from another table

8 Apr 2013 by Member 9611735

Hey everyone.I am developing a application in c# where you insert values from textboxes to two different MYSQL tables. In table 1 I have a employeeid which is auto incremented when a new record is created. In table 2 I have a field of the same name and I want to assign it the corresponding...

assign a value in a table from another table

9 Apr 2013 by ZurdoDev

I believe in MySQL LAST_INSERT_ID() will give you the last ID. So, if you had 2 insert statements, after the first one which inserts into table1 store LAST_INSERT_ID() into a variable and then use that variable to insert into table 2.

Authorization of user from access data base in C#

12 Jun 2011 by kami124

HiHere is the problem I am creating desktop application in C# for this I need authentication from data base where I have user name and I want to check that wether this user exist in access data base or no if the user exist there return the user id from data base.

Authorization of user from access data base in C#

12 Jun 2011 by Om Prakash Pant

check the examples in following thread:http://social.msdn.microsoft.com/Forums/en/winformsdatacontrols/thread/21f08279-d1ac-4567-8eeb-bcd48e666564[^]

Authorization of user from access data base in C#

12 Jun 2011 by Kim Togo

Start out with SQL Tutorial[^]. And depend on how you build up the table that holds the user info. SELECT statement can vary.One example can be:SELECT id FROM useraccess WHERE login='kim' AND SHA1(password)=SHA1('mypass')It will give 1 result, if login and password macth...

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!

Auto table (re)creation on insert events at case of ef-code-first

24 Apr 2017 by SlavaUtesinov

Implementation of "insert" repository with dynamic database table (re)creation, if it not exists. It is possible to specify which migrations will be used for that otherwise will be used default creation logic. Usage example - dynamic logging and archivation or manual table creation for some purposes

Backup and Restore data of Sql database based on primary Key records in vb.net

15 Nov 2015 by JatinKhimani

I want to implement Backup and Restore functionality for the user where they can take Backup of Certain data from the certain table and then they can restore it. I am working in desktop application in vb.net. Give you a scenario I have One Company Table in that Company id is primary Key ...

SQL-Server-2008R2

BAM Tables

13 Jun 2014 by VIGNESH SUKUMAR

Business Activity Monitoring Tables

Between The Rows I Want Overtime Calculate .........

6 Apr 2014 by akhil.krish

this query give intime and outtime but i want total time and late time aslo....select distinct CE.USERID, CONVERT(Date,Localtimestamp) as LocalTime,(select min(TIMESTAMPS) from access_event_logs As MINCEwhere CAST(MINCE.TIMESTAMPS as DATE)=CAST(CE.TIMESTAMPS As DATE) AND...

SQL-Server-2012

broadcasting(Radio) database table design

18 Feb 2014 by Abdullah Jallad

Hello,I Have Basically a Program table and an ADs Table i need to buled a table that is going to be used as the Playlist (it is for a broadcasting)that my program going to run an algorathem and buled the playlist for the programs First and then i will have an ADs free time (or time...

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

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# - using htmlagilitypack to move HTML table data to a binding list

29 Jan 2017 by Ken-in-California

I am pulling data from a website where it is organized in a table. The first two rows look like this (I deleted some style info): ...

C# - using htmlagilitypack to move HTML table data to a binding list

29 Jan 2017 by Ken-in-California

It turned out that the website was returning some escape characters that were showing up as additional rows, so I was able to handle that by rewriting my conditionals.Thanks for taking the time to respond to my question Richard, it helped.

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

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# html parser for tables

3 Oct 2013 by niko_tells

hi, i want to get data from an html file into a Dictionary. The html file contains several tables. But every table contains just 2 colloumns. I have tried already the html-aglility-pack parser but i cant find any useful documentary about tables. Here is a part of the html...

c# html parser for tables

3 Oct 2013 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Refer- create a dictionary or list from string(HTML tag included) in C#[^]. One example is there.Quote:You should use the HTML Agility Pack.For example: (Tested)var doc = new HtmlDocument();doc.LoadHtml(s);var dict = doc.DocumentNode.Descendants("tr") .ToDictionary( ...

c# using HtmlAgilityPack to get data from HTML table

7 Oct 2015 by Member 10918596

c# using HtmlAgilityPack to get data from HTML table

C#. looping table row in iTextSharp

6 Dec 2012 by melvintcs

recently i dealing with iTextSharp, and im new to this.i learned how to create the table from this tutorial:http://www.mikesdotnetting.com/Article/86/iTextSharp-Introducing-Tables[^]and i also learn how to create the report by using pdf template. now i created the pdf file as...

C#. looping table row in iTextSharp

8 Dec 2012 by Menon Santosh

you can use following code to loop in tableTextControl tx = form1.TextControl1; int TblID =101;string cText="Hello";for (int i = 1; i

can i add a value in textbox2 automatically when the adjacent textbox1 is entered a specific value?

24 Mar 2011 by execobra

I have a table pr-generator which has a subform of the same name. These both access data frm tables indents and indent details respectively. There is a textbox item_code in the sub form.Now I want to add item_description next to item_code. Also I have a separate table for storing both...

can i add a value in textbox2 automatically when the adjacent textbox1 is entered a specific value?

24 Mar 2011 by Henry Minute

You need to write a query against your item_code/item_description table to retrieve the description for any item_code that is passed to it. Queries like this are called Parameterized QueriesYou can read about them:here[^]andhere[^]and in lots of other places, if you can come up with...

Can i restore my deleted rows (by Delete query) in a sqlserver table ?

16 Mar 2013 by sr_24

Can i restore my deleted rows (by Delete query) in a sqlserver table ????pls help ..thanks in advance

Can i restore my deleted rows (by Delete query) in a sqlserver table ?

16 Mar 2013 by Prasad Khandekar

Hello,Rows deleted can not be recovered after COMMIT operation. If COMMIT is already performed then only way I know to recover data is via database restore provided you have taken a backup before performing this operation.Regards,

Can i restore my deleted rows (by Delete query) in a sqlserver table ?

13 Feb 2014 by Bryce Bates

You might be able to restore your deleted rows. If your database was in a full or bulk-logged recovery model you could use SQL Server point in time recovery. I suggest reading this post: http://stackoverflow.com/questions/3540729/how-to-recover-deleted-rows-from-sql-server-table

CascadingDropDown in Ajax With ASP.net

11 Oct 2013 by ASP.NET Community

Step1: Create a table in database:- create table test( state1 varchar(50),city varchar(50) ) Step2:- In the .aspx Page:-

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

Column width problem using javascript create dom table (IE)

16 Dec 2010 by AleXX Zero

Hi, I have to create a table using javascript. Firefox displays the expected result but for IE, the column width is screwed .I have to use the col tag to set width because sometimes the first row maybe merged. All I need is to create a table that strictly displays according to the inputted...

Column width problem using javascript create dom table (IE)

31 Dec 2010 by AnupKumarYadav

Try Changing lightgray To gray in style.borderTop = "1px solid gray"; style.borderLeft="1px solid gray";

Common SELECT Statements (SQL Server)

11 Oct 2013 by ASP.NET Community

Followings are some examples of using SELECT statement. My table name tblTest. Followings are columns. (TestID, TestName, TestDate, TestCity )1)

Connect Data from Database to table in asp.net

23 Jul 2014 by Peter Leow

You can use the GridView control to render a table on your webpage, refer : GridView[^]

Connect Data from Database to table in asp.net

23 Jul 2014 by mukesh.netdev

You can use any DataBound Control and bind your database table to that DataBound control.for example use a GridView control..Thanks..

Convert jpeg to table

5 Apr 2017 by Member 13036251

I'm trying to take an image of a dataset in jpeg format and convert it to a table in excel. Anyone know how to do this? Doesnt need to be done programatically. For instance, I want to turn this image into a table. Link What I have tried: Insert from Object in Word and Convert Text to Table...

Convert jpeg to table

5 Apr 2017 by OriginalGriff

Why? To be honest, you are making life deliberately difficult for yourself, and involving processes that will do very little more than introduce errors. A jpeg image contains no text - plus it's a "lossy" compression format - so if you convert a dataset to a jpeg, you then need to use OCR to...

Convert jpeg to table

5 Apr 2017 by Patrice T

Quote: For instance, I want to turn this image into a table. My best advice: do it manually. Your picture is very low quality and any OCR will likely to fail. The fact that the text is languages names makes it even more difficult because those names are not in dictionary for most of them. With...

Convert rows to columns in SQL server

27 May 2013 by kk2014

Hi All,i have requirement like to Convert rows to columns in SQL server.i have retrieved data like below:MatchId SelectionName Odds322 Home Win 1.33322 Draw 5.00322 Away Win 9.00322 Under 2.5 2.40322 Over 2.5 1.53and want to convert like below:MatchId Home Win ...

SQL-Server-2008

Convert rows to columns in SQL server

27 May 2013 by Arun Vasu

query for make columns into rows in ms sql server[^]use this.. If you have any query Please let me know.. i will help you..

SQL-Server-2008

Convert rows to columns in SQL server

27 May 2013 by Aarti Meswania

Select MatchId,[Home Win],[Draw],[Away Win],[Under 2.5],[Over 2.5]From TableName PIVOT( SUM(Odds) For SelectionName in ([Home Win],[Draw],[Away Win],[Under 2.5],[Over 2.5])) as pvttblHappy Coding!:)

SQL-Server-2008

Convert rows to columns in SQL server

27 May 2013 by kk2014

Hello,i got my result from below query.select * from (select MatchId,SelectionName,Odds From #tmpMatchOdds) As P Pivot ( Sum([odds]) For SelectionName In ([Home Win],[Draw],[Away Win],[Under 2.5],[Over 2.5]) )As pvThanks for reply.

SQL-Server-2008

Copy data from different tables into one in SQL server

21 May 2017 by Faran Saleem

Hello, I have 5 different tables let's say table1,table2,table3,table4,table5. The tables have a few common columns like referenceNumber, CNIC Number, Product etc. At my webpage there is a textbox where user can enter CNIC Number and they can perform searches. What i want is whenever a search...

Copy data from different tables into one in SQL server

21 May 2017 by Kornfeld Eliyahu Peter

Learn about JOINs in SQL[^] and use INSERT INTO ... SELECT ...[^]

Copy MS SQL database tables to MySQL database

1 Aug 2013 by Mobile.Instinct

Hello,I am quite new to web development and databases on server support. Basically, I am using a sample project that I found online for creating accounts, logging in etc. The project uses a database that stores all this information on an MS SQL server (as far as I know) and uses the...

Copy MS SQL database tables to MySQL database

1 Aug 2013 by Kuthuparakkal

Try MySQL migration Tool Kit:http://downloads.mysql.com/archives.php?p=mysql-migration-toolkit[^]Also validate why to move frpm the article below:http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html[^]Check your connection string:

Copy tables between servers with smo - different collation

18 Jan 2012 by Morten Lossius

Copy tables between servers with smo - different collation

Country,City, ZipCode Table structure

1 Oct 2011 by laxi300

Hi,I Need help with Country , City , State, ZipCode Table structure.I m Using MS SQL 2008 Management Studio & Visual Studio.NET 2010 Desired Functionality for my Windows Application.When customer select Country so the next ComboBox will automatically load the relevant cities and...

Country,City, ZipCode Table structure

1 Oct 2011 by P.Salini

Good One with screen shotscheck it oncehttp://www.vbdotnetheaven.com/UploadFile/rohatash/8072/[^]Simple Way to Implement Country/State/City Dropdown List in ASP.NET (VB)[^]see this link it may help you.All the Best.

Create 5 Dynamic tables on page load

13 Apr 2012 by SidduHussain

hiBelow is the code I use to build an HTML table on the fly (using JSON data received from the server).At first, I was just happy to make this happen (display the table), I guess now I need to work on efficiency. I want to know how to go to a static "Loading" display.Suggestions for...

Create job to export Stored Procedure daily

27 Nov 2012 by Aadhar Joshi

Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.

SQL-Server-2008

SQL-Server-2005

create sql table entries with date as columns per date

11 Dec 2015 by craft_trone

Hi all,How can i manage to do this, it would require to show my sql entries to be per date in a column, so it means that every entry date would become a column and be a report.SELECT remittance_no, remit_date, messenger, item, item_value, rate.product, rate.product_valueFROM...

create sql table entries with date as columns per date

15 Dec 2015 by CHill60

As Tomas Takac says, you need to know about PIVOT. As well as the link he has provided there are several articles here on CodeProject.Here is an example of how your sample data could be pivotedselect remittance_no, messenger, item, item_value, product , isnull([2015-12-04],0) as...

Creating a C++ RichText edtor to support tables and columns like MS Word

12 Mar 2013 by idbruce

Hello EveryoneI want to create a rich text editor that supports tables similar to MS Word. I really don't like trying to recreate the wheel, but MS Word does not support the accuracy that I desire. As close as I can establish, MS Word only supports accuracy to 1/10 of a point for font...

Creating a C++ RichText edtor to support tables and columns like MS Word

12 Mar 2013 by Maximilien

curious, why do you need that accuracy ? And more importantly, VC6 !!!! IMO, you will not go far with that version of Visual Studio; and AFAIK, the richtext editor will not give you that precision and the final print rendering will need to be done by you (but I'm no expert on that).Also,...

Creating a flexible table using div tag? Is it possible?

12 Aug 2012 by neeraz upadhyay

I am creating a table using div tag, but as i increases the fields of columns the code breaks down to next line, and for this I have to fix the div size again and again..:( is there any possible way to create a table using divs like table tag.

Creating a flexible table using div tag? Is it possible?

12 Aug 2012 by Raje_

Refer this link:DIV TABLE[^]All the best.

Creating a Transaction (Enterprise Libraries)

11 Oct 2013 by ASP.NET Community

Following is an example of creating a transaction when require to save on many tables at once. I used Microsoft Enterprise Libraries. I assume one to

Creating HTML Tables with JavaScript/DOM Methods

6 Oct 2015 by Gerd Wagner

The proper way of creating an HTML table with JavaScript and inserting it into the HTML body element is using the DOM methods insertRow and insertCell.

cross browser compatabilty - need help

30 Mar 2012 by moses12345

hi guys please help me figure this out .im designing a simple header to a page work on, and the result i get on IE 9,8 firefox is different check this out : SWS - SMS Winning...

cross browser compatabilty - need help

30 Mar 2012 by Sergey Alexandrovich Kryukov

I have no idea which of your border, alignment and similar attributes create the loss in cross-browser compatibility. I can tell you why: I never use them. Using such attributes is really a bad thing. I don't even know who develop Web sites using them. Probably none of real Web...

Custom DataGridView for Data Management

8 Dec 2016 by haisol

Custom DataGridView for managing data

Data Analyzer: HTML Table to Chart

14 Feb 2013 by Niral Soni

A few lines of code to create dynamic charts based on the HTML table contents with filter option

Data Auditing Tool (Audit Trigger Generator)

28 Sep 2012 by J.Jash

Data Auditing Trigger Generator

reporting-services

Data Insertion an matching

21 Mar 2014 by mayank.bhuvnesh

Hi,I am sending a request with sender, multiple numbers and ID say Sender is same for each request sender, number, ID A, 9999, 1A, 8888, 2A, 7777, 3 For this request when I get a msgID against each number. The response contains only the msgID and the ID I have send in the request say...

SQL-Server-2005

SQL-server-2000

Data Insertion an matching

21 Mar 2014 by Christian Graus

'dis' is not a word. nor is 'den', unless you mean where wolves live. We don't mind typos, or poor grammar, we want to help and not be grammar Nazis. But you should at least try to speak the language you're using :-)The SQL merge[^] keyword lets you pass a set in to an insert operation...

SQL-Server-2005

SQL-server-2000

database table drag and drop to a form columns and update ?

24 Jul 2011 by shd35

is it possible to write a code that takes a database table and show it on a form and the user can drag and drop columns to it that updates the database

database table drag and drop to a form columns and update ?

24 Jul 2011 by OriginalGriff

Yes.But you would have to code it all yourself - there is no control that does that AFAIK.

Datatable Reload Without Postback

18 Oct 2015 by haticeb

Hello, I have a comment grdiview. When a new comment added , gridivew should be reload but without postback with jquery. It is not possible with gridview because it is server side control. How can I achieve this without using gridview. I can use classic table but I don't know how to do it....

Datatable Reload Without Postback

18 Oct 2015 by Palash Mondal_

You can use jQuery Datatables for this: https://www.datatables.net/[^]and initialize it like:$(document).ready(function(){ $('#myTable').DataTable();});and then you can make ajax call and get the array data to reload it on client side...

Datatable Reload Without Postback

19 Oct 2015 by haticeb

Thanks but I am not good on jquery. Can you take a link for example project? I could not find for me.

delete 2 entries from 2 tables IF

20 Oct 2013 by Member 8597245

I am running a gameserver, i have 2 entries i am trying to delete.The game logs player user id's in 2 seperate tables:1) player_login2) character_datacharacter_data has lastlogin and playeruid information i want a query that deletes the entry from player_login and character_data if...

delete 2 entries from 2 tables IF

22 Oct 2013 by W∴ Balboos, GHB

CREATE TRIGGER .... AFTER DELETE on ... etcSo now you only need handle one table and have its trigger handle the other.

Delete data from multiple tables

11 Jul 2011 by 204.sharma

How can we delete data from multiple tables using a single query.Thanks in advance.

SQL-Server-2005

Delete data from multiple tables

11 Jul 2011 by Prerak Patel

http://social....

SQL-Server-2005

Delete data from multiple tables

11 Jul 2011 by OriginalGriff

The best way if to use Cascaded Deletes[^], so that the database will always handle it for you.Alternatively, I would suggest that using transactions might be a better alternative, possibly inside a stored procedure.

SQL-Server-2005

Delete data from multiple tables

13 Jul 2011 by Shameel

If the tables are related (i.e., they have a common key), you can use ON DELETE CASCADE clause in the foreign key specification. Deleting rows from a master table will result in the deletion of all related child rows from the dependant tables.If the tables are not related, you must use...

SQL-Server-2005

different view of table dimentions in browsers

6 Nov 2012 by Sarah MQ

my question is about the difference occurs in table dimensions in IE and google chrome browsers:my html code :

different view of table dimentions in browsers

7 Nov 2012 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

I checked the website http://line25.com/wp-content/uploads/2010/snowboard-design-code/demo/index.html[^] and found that the div "features" has width "940px". So no matter what content goes inside it and what width it has inside that div (like the ul tag inside this div has width "2820px"),...

different view of table dimentions in browsers

7 Nov 2012 by StackQ

U should use % value instead pixel.Then it will automatically work.

Display message when there is no data

20 Jul 2016 by super_user

I have webmethod and jquery for display chart in pop up for this .. so when i click on search button when there is data then working fine but when there is no data i want to display message "NO Data" in label .. and also pop must not display when there is no data how i do this ..What I have...

Display message when there is no data

21 Jul 2016 by F-ES Sitecore

success: function (result) { var myData = JSON.parse(data.d); if (myData.length == 0) { // do something to show a message return; } strarr = result.d; var myarr = strarr; Drewchart(myarr); // here you could pass in myData and drop the...

Doubts in showing scanned part in tables dynamically

28 Oct 2013 by Rachel Jia

Hi Sriram,This is Windy from Dynamsoft. Thanks for using our Dynamic Web TWAIN SDK. To retrieve images from server side, you can use HTTPDownload method.To display images in 3*3 matrix, you can use SetViewMode method.Learn more about the methods[^]You may try the features with...

Drop down list with results

20 Jul 2011 by Member 8099339

Hi,I was wondering if it was possible to have a drop down list where you select one of the options and it loads the form that is designated to that option, and appears directly below the drop down menu on the same page so the client can fill it out and submit it?I have four forms that I...