Comments by Rajesh Pandya (Top 39 by date)

Have you get any error when enter username and password? You have just mentioned "server not accepting" without knowing error nobody can help you.

Have a look at following URL, may be it will help
URL: https://dba.stackexchange.com/questions/90033/how-do-i-drop-all-constraints-from-all-tables

Add try catch in while loop code so if an error comes try-catch block will handle the error and loop will not break and it will continue to process next record

Can you please explain your question in detail and also give detail regarding where you struck.

May be following link will helpful to you:
https://silviomoreto.github.io/bootstrap-select/examples/
https://codepen.io/Rio517/pen/NPLbpP

Is any error you get? Please explain your question in detail.

You have given only table structure. What query you have tried? What error you have get? Please specify that.

'BB' is your table name? If yes then that table is not exists in database and because of that it gives error "Invalid object name 'BB'".
If you have given alias as 'BB' then you need to specify table name and then alias name.

Store the coalesce function value in variable and check if value is blank or null then assign the default value in the variable.

Instead of storing image in database store image path in the database and use the path to show the image as per your requirement. Check the following link:
https://stackoverflow.com/questions/19529896/how-to-upload-image-and-save-path-to-database

Is there any specific reason you want to store actual image in database instead of store reference to the image?

If you store store images in database it make database big.

You could store them as a BLOB. Following link may be helpful for you:
http://forum.codecall.net/topic/40286-tutorial-storing-images-in-mysql-with-php/

What is your table structure? How many columns in the table?

You can use above logic just remove the for loop and use if condition like below:
if(tablerowcount = 5)
{ sTableData = 'specify data you want show'; }
else if(tablerowcount = 20)
{ sTableData = 'specify data you want show';
sTableData = sTableData + 'specify data you want show';
}
Like above add as many condition as required for create div based on row count.

May be following link will be helpful:
https://www.codeproject.com/Articles/390952/Stunning-popup-window-control-using-jQuery

On button click you want to show the form for data entry?

Share the query in which you have used join

I use native code for that.

currently my sample table have only one row.

Yes it won't impact the data..but for parse the json it need to remove the escaping character

I have checked outout in postman and in ios device.

In IOS and Android

You cannot directly connect/communication with the client machine hardware using web application. But here's some approach you can try: Use ActiveX component or Create a Windows Service(WCF, WebAPI etc..).

It communication something like: Web Application <---> ActiveX component/Windows Service <---->Hardware

Use two separate button for do this. On add new button click use javascript function and in javascript function call another button click and do the code behinde stuff in that click event and also use updatepanel with that. If you need sample code then feel free to ask me

Instead of "#<%=grdorders.ClientID%>" use static id and then try. May be it works.

you can use below code for refresh the updatepanel

UpdatePanel1.Update()
where "UpdatePanel1" is you updatepanel id.

Thanks

Check if any API or web service it available for that.

Please try following. Hope it will work for you.
CREATE TABLE [dbo].[Pit_Output](
[League_ID] [nvarchar](7) NOT NULL,
[Team_ID] [nvarchar](7) NOT NULL,
[Season] [nvarchar](4) NOT NULL,
[Session] [nvarchar](1) NOT NULL,
[Player_ID] [int] NOT NULL,
[Player] [nvarchar](64) NULL,
[W] [int] NOT NULL, [L] [int] NULL,
[ERA] [float] NULL, [G] [int] NULL,
[GS] [int] NULL,
[CG] [int] NULL,
[Sho] [int] NULL,
[Sv] [int] NULL,
[BS] [int] NULL,
[IP] [float] NULL,
[TBF] [int] NULL,
[H] [int] NULL,
[R] [int] NULL,
[ER] [int] NULL,
[HR] [int] NULL,
[BB] [int] NULL,
[IBB] [int] NULL,
[HBP] [int] NULL,
[WP] [int] NULL,
[BK] [int] NULL,
[SO] [int] NULL,
[SF] [int] NULL,
[SH] [int] NULL,
[upsize_ts] [timestamp] NULL,
CONSTRAINT PK_Pit_Output PRIMARY KEY(League_ID, Team_ID)
)
------------------------------------------------------------------------
CREATE TABLE [dbo].[Teams](
[Team_ID] [nvarchar](7) NOT NULL,
[Team City] [nvarchar](64) NULL,
[Team Name] [nvarchar](64) NULL,
[League_ID] [nvarchar](7) NOT NULL,
[Franchise ID] [nvarchar](7) NULL,
[Short] [nvarchar](8) NULL,
CONSTRAINT [PK_Teams_1] foreign key(League_ID, Team_ID) references Pit_Output(League_ID, Team_ID)
)

Can you please paste here you sample code using which you are trying to create both table.

You can create foreign key using composite primary key. Only thing is that you need to use same column combination which you use to define composite primary key.

Welcome. It's depend on the requirement whether you use single column primary key or composite primary key. For insure unique value in your column you can use unique key constraint for your column in which you want to store unique value.

You need online database connection string to connect your website with your database. For get the online database connection string you need to login into your hosting control panel and you get it from there or else contact you hosting support and ask for the online database connection string.

In your "Team" table column "Team_Id" is primary key? If no, then first set the primary key for "Team_ID" column in Team table and then try again.

Can you please post here your sample code in which you are getting above issue.