Click here to Skip to main content
14,575,464 members

Comments by Avik Ghosh22 (Top 88 by date)

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