Comments by Avik Ghosh22

Avik Ghosh22 28-Jan-16 6:11am View

Thanks asif .your query works fine but when i am trying this from my table
got same problem.

CREATE TABLE [dbo].[sal](
[name] [varchar](50) NULL,
[sal] [decimal](18, 0) NULL,
[Id] [int] NULL,
[SrID] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'Avik', CAST(100 AS Decimal(18, 0)), 1, 0)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'ASD', CAST(200 AS Decimal(18, 0)), 2, 1)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'DSA', CAST(200 AS Decimal(18, 0)), 3, 2)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'QWE', CAST(400 AS Decimal(18, 0)), 4, 3)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'EFG', CAST(400 AS Decimal(18, 0)), 5, 1)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'PQR', CAST(500 AS Decimal(18, 0)), 6, 1)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'qqq', CAST(111 AS Decimal(18, 0)), 7, 3)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'rrr', CAST(222 AS Decimal(18, 0)), 8, 2)

Avik Ghosh22 28-Jan-16 5:59am View

It is a test table so I did not set any primary key .

Avik Ghosh22 28-Jan-16 5:58am View

CREATE TABLE [dbo].[sal](
[name] [varchar](50) NULL,
[sal] [decimal](18, 0) NULL,
[Id] [int] NULL,
[SrID] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'Avik', CAST(100 AS Decimal(18, 0)), 1, 0)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'ASD', CAST(200 AS Decimal(18, 0)), 2, 1)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'DSA', CAST(200 AS Decimal(18, 0)), 3, 2)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'QWE', CAST(400 AS Decimal(18, 0)), 4, 3)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'EFG', CAST(400 AS Decimal(18, 0)), 5, 1)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'PQR', CAST(500 AS Decimal(18, 0)), 6, 1)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'qqq', CAST(111 AS Decimal(18, 0)), 7, 3)
INSERT [dbo].[sal] ([name], [sal], [Id], [SrID]) VALUES (N'rrr', CAST(222 AS Decimal(18, 0)), 8, 2)

Avik Ghosh22 21-Jan-16 4:09am View

http://www.codeproject.com/Questions/1073223/which-one-is-better-aspx-cs-page-transaction-and-d

Avik Ghosh22 21-Jan-16 4:07am View

Thank u. I got my answer . :) (Y)

Avik Ghosh22 21-Jan-16 1:33am View

In an interview ,Interviewer asked me " where do u use transaction? at sp or code behind?" I told SP then he asked me why? why we don't use at code behind?

Avik Ghosh22 21-Jan-16 0:36am View

you can store data either cookies or session to send data from one page to other pages .

Avik Ghosh22 11-Feb-15 11:05am View

Please share your problem..

Avik Ghosh22 11-Feb-15 1:57am View

http://www.c-sharpcorner.com/uploadfile/mahesh/C-Sharp-datetimepicker-control/

Avik Ghosh22 11-Feb-15 1:19am View

Please pass parameters in query.
Please read :
http://www.w3schools.com/sql/sql_injection.asp

Avik Ghosh22 9-Feb-15 2:17am View

Deleted

http://stackoverflow.com/questions/6257459/how-to-refresh-asp-net-cache-when-data-is-updated-in-database

https://msdn.microsoft.com/en-us/library/e3w8402y(v=vs.140).aspx

https://msdn.microsoft.com/en-us/library/ms178604(v=vs.140).aspx

Avik Ghosh22 9-Feb-15 2:14am View

Deleted

You can use "Caching" to do this.

Avik Ghosh22 9-Feb-15 2:09am View

Deleted

WEB :
http://www.aspsnippets.com/Articles/Read-XML-File-and-bind-it-to-GridView-in-ASPNet.aspx

Windows :
http://www.codeproject.com/Tips/426762/XML-to-DataSet-or-GridView-and-back

Avik Ghosh22 4-Feb-15 23:36pm View

Deleted

please see :
http://www.devcurry.com/2010/12/auto-generate-row-number-in-aspnet.html

Avik Ghosh22 4-Feb-15 23:33pm View

use <%# Container.DataItemIndex + 1%> in aspx page or bind listview after delete operation.

Avik Ghosh22 31-Jan-15 10:42am View

good..

Avik Ghosh22 31-Jan-15 4:18am View

Use GetUTCDate() in sql server .
http://www.sanssql.com/2010/11/difference-between-getdate-and.html

Avik Ghosh22 31-Jan-15 3:26am View

http://www.aspsnippets.com/Articles/Export-GridView-with-Images-to-Word-Excel-and-PDF-Formats-in-ASP.Net.aspx

Avik Ghosh22 31-Jan-15 2:35am View

Deleted

Firstly convert doc to pdf -- >http://forums.asp.net/p/1346459/2782812.aspx or http://stackoverflow.com/questions/607669/how-do-i-convert-word-files-to-pdf-programmatically
After that---> http://www.codeproject.com/Tips/697733/Display-PDF-within-web-browser-using-MVC

Avik Ghosh22 31-Jan-15 2:29am View

http://www.aspsnippets.com/Articles/Display-Word-document-on-web-page-in-ASP.Net.aspx

Avik Ghosh22 31-Jan-15 1:27am View

5!

Avik Ghosh22 30-Jan-15 23:58pm View

ok ..

Avik Ghosh22 30-Jan-15 23:48pm View

Deleted

http://www.aspsnippets.com/Articles/Reload-Refresh-and-Redirect-Pages-using-Meta-Tags-in-ASP.Net.aspx

Avik Ghosh22 30-Jan-15 7:28am View

Thank u..

Avik Ghosh22 11-Jan-15 1:58am View

Done..Thank you,sir.. 5+..

Avik Ghosh22 13-Aug-14 5:57am View

ohh...

Avik Ghosh22 8-Aug-14 6:55am View

nice ... 5+.

Avik Ghosh22 23-Jul-14 8:08am View

welcome. :)

Avik Ghosh22 18-Jul-14 0:20am View

Please see those sites..
1) http://www.c-sharpcorner.com/UploadFile/raj1979/post-on-facebook-users-wall-using-Asp-Net-C-Sharp/

2)http://www.coderexception.com/CbuuBB33PQWXSixS/how-to-post-on-facebook-on-all-authorized-users-wall-using-graph-api-in-aspnet-mvc

Avik Ghosh22 19-Mar-13 8:56am View

reintall microsoft office...

Avik Ghosh22 10-Mar-13 7:26am View

hiii.... u know about transaction..

Avik Ghosh22 8-Mar-13 11:00am View

5!

Avik Ghosh22 8-Mar-13 1:34am View

welcome bro.... :)

Avik Ghosh22 8-Mar-13 1:33am View

when an user enter your website using login page catch user id/name(which is unique) into session ....

example
________

http://www.aspdotnet-suresh.com/2012/11/aspnet-session-state-example-in-c-vbnet.html

Avik Ghosh22 8-Mar-13 0:12am View

I gave an example just... i have no idea about VB ... in c# ,this is a process to change date format ...

Avik Ghosh22 6-Mar-13 0:51am View

good...5!

Avik Ghosh22 6-Mar-13 0:46am View

creat a subdirectory....

Avik Ghosh22 5-Mar-13 0:30am View

thank u bro...good link...5!

Avik Ghosh22 4-Mar-13 23:58pm View

a DataSet represents a set of DataTable objects. More often than not, it will just contain one table, but if you do a query with multiple SELECT statements, the DataSet will contain a table for each. Because this is an in-memory representation, you have to be careful about how much data you pull into a DataSet. You can "Fill" a DataSet using the Fill method of a DataAdapter.

a DataView is like a virtual subset of a DataTable.

according to me use data set...

Avik Ghosh22 3-Mar-13 10:44am View

Sandeep Mewara ... plz help me....

Avik Ghosh22 3-Mar-13 10:00am View

Experts ,,,,,,,, i need yr help...

Avik Ghosh22 3-Mar-13 9:59am View

bro..if this is your expected ans plz accept this ans ....

Avik Ghosh22 3-Mar-13 6:45am View

Experts help me plz..............

Avik Ghosh22 1-Mar-13 5:26am View

hay bro, I know that how to create a dynamic menu in asp.net.. I want to create dynamic menu using LINQ.....

Avik Ghosh22 26-Feb-13 0:46am View

nice.. 5!.

Avik Ghosh22 23-Feb-13 6:25am View

autopostback=FALSE;try this

Avik Ghosh22 19-Feb-13 2:31am View

http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx
http://asp.net-informations.com/dataset/howto-asp-dataset.htm

https://www.google.co.in/#hl=en&tbo=d&sclient=psy-ab&q=how+to+use+dataset+in+asp.net+with+c%23&oq=HOW+TO+USE+dataset+IN+ASP.NET&gs_l=hp.1.1.0l2j0i7i30j0i30.65022.68890.3.71284.11.11.0.0.0.2.332.2274.0j6j3j2.11.0.les%3B..0.0...1c.1.3.psy-ab.wZSVv7oBjbs&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&bvm=bv.42553238,d.bmk&fp=81d14d7c7e348b8c&biw=1280&bih=629

Avik Ghosh22 19-Feb-13 0:34am View

https://google-developers.appspot.com/chart/interactive/docs/gallery/piechart

Avik Ghosh22 18-Feb-13 7:31am View

http://forums.asp.net/t/1576062.aspx/1?Search+amp+Replace+XML+text+runtime

Avik Ghosh22 18-Feb-13 5:29am View

welcome bro...

Avik Ghosh22 17-Feb-13 1:59am View

other wise u can provide me ur code for check...

Avik Ghosh22 17-Feb-13 1:58am View

than use java script to hide column..

http://aspdotnetcodebook.blogspot.in/2008/03/how-to-hide-gridview-column-using.html
http://www.yiiframework.com/forum/index.php/topic/19707-showhide-gridview-columns-in-javascript/
http://dotnetspeaks.net/post/Hiding-Columns-in-GridView-without-losing-data.aspx
http://www.dotnettwitter.com/2011/03/adding-removing-gridview-columns-in.html
http://www.jqwidgets.com/show-hide-gridview-columns/

Avik Ghosh22 16-Feb-13 23:47pm View

use Button1.Enabled = false; in cs page... it works every where...

Avik Ghosh22 15-Feb-13 22:29pm View

Deleted

good ... 5!

Avik Ghosh22 14-Feb-13 13:19pm View

Marcus Kramer thank u sir....

Avik Ghosh22 14-Feb-13 12:55pm View

thank u sir...i know about sql injection ... earlier i had suffered a lot...

for a new comer its easy to understand so i give this solution..

thank u again for your advice .... and sorry for my poor English... :)

Avik Ghosh22 14-Feb-13 12:22pm View

ok....wait..

Avik Ghosh22 14-Feb-13 11:15am View

TextBox txtUsrname = (TextBox)gvDetails.FooterRow.FindControl("txtboxid");

Avik Ghosh22 14-Feb-13 11:13am View

bro check http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html this .... main problem in your gridview...it can not recognize the textbox ... ID_Order is this textbox id???? i am sorry for my poor English...

Avik Ghosh22 14-Feb-13 10:49am View

<pages enableEventValidation="true"/> error come when u don't use ispostback false in your page load part.... Object reference not set to an instance of an object means there are some error in your code ..... check your code with break point...

Avik Ghosh22 14-Feb-13 1:13am View

???????

Avik Ghosh22 13-Feb-13 0:48am View

http://dotnet.dzone.com/news/easy-url-rewriting-aspnet-40

Avik Ghosh22 12-Feb-13 12:05pm View

thanks ....

Avik Ghosh22 12-Feb-13 10:51am View

thanks to all...

Avik Ghosh22 12-Feb-13 6:25am View

sorry....

Avik Ghosh22 12-Feb-13 6:13am View

what r u write on Timer1_Tick??

Avik Ghosh22 12-Feb-13 6:13am View

http://www.codeproject.com/Answers/542646/Autoplusrefreshpluswithoutplususingplustimers#answer1

Avik Ghosh22 12-Feb-13 6:11am View

TO AVOID TIMER U CAN USE THIS CODE ON UR PAGELODE...

Avik Ghosh22 12-Feb-13 2:18am View

IN PAGELOAD IF(!ISPOSRBACK)
{
}
TRY THIS.

Avik Ghosh22 12-Feb-13 0:45am View

time tracking project???

Avik Ghosh22 11-Feb-13 11:02am View

thanks bro...

Avik Ghosh22 11-Feb-13 8:12am View

try this...tested code...

Avik Ghosh22 9-Feb-13 4:37am View

try this...

Dim rn As New Random

n =rn.Next(1, 4)

i have a little knowledge in vb.... bt try this code.. it may work....

Avik Ghosh22 8-Feb-13 8:36am View

http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html

Avik Ghosh22 8-Feb-13 3:23am View

protected void Button1_Click(object sender, EventArgs e)
{
//your insart transaction part//

Page.RegisterStartupScript("Key", "<script type='text/javascript'>window.onload = function(){alert('inserted suceesfully');return false;}</script>");
}

try this...

Avik Ghosh22 8-Feb-13 0:29am View

i have no antivirus and my computer's firewall always turn off....

Avik Ghosh22 7-Feb-13 8:13am View

use autopostback and ispostback properly..

Avik Ghosh22 7-Feb-13 7:50am View

not working ....

Avik Ghosh22 7-Feb-13 5:12am View

ok.

Avik Ghosh22 7-Feb-13 5:09am View

how do u solve this problem ....??

Avik Ghosh22 7-Feb-13 4:57am View

<asp:DropDownList ID="ddlAttributesDataType" runat="server" required>

"required" is required field validator in HTML5 .... try this...

Avik Ghosh22 7-Feb-13 4:48am View

dx.Tables[0].Columns.Add(tim1, typeof(string));
try this...

Avik Ghosh22 7-Feb-13 4:31am View

datatable dx = dk.Tables[0]; change to dataset....
dataset dx = dk.Tables[0];
dataset df=dc.Table[0];

Avik Ghosh22 7-Feb-13 2:35am View

thank u bro..

Avik Ghosh22 7-Feb-13 2:19am View

then try this...
http://jscolor.com/

i use this code many times ...

for source code
http://jscolor.com/download.php

Avik Ghosh22 7-Feb-13 2:08am View

there is no available source ... every body use either EF or LINQ ... bt i want to do this usng SqlConnection and SqlCommand ...

Avik Ghosh22 7-Feb-13 2:01am View

plz give me some example or link ..

Avik Ghosh22 7-Feb-13 1:56am View

r u satisfied with this code????

Comments by Avik Ghosh22 (Top 88 by date)