tag:blogger.com,1999:blog-7805972021499203804.post4664517862327795052..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: SQL Server - Create Identity Column or Auto Increment ColumnSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-7805972021499203804.post-77555885206109052592014-03-05T05:53:49.484-08:002014-03-05T05:53:49.484-08:00please sir help meplease sir help meAnonymoushttps://www.blogger.com/profile/14315467528982997922noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-12408475910975429832014-03-05T05:51:53.451-08:002014-03-05T05:51:53.451-08:00i create table in sql but when i insert into table...i create table in sql but when i insert into table values error comes how can i do<br />and i have no c# codeAnonymoushttps://www.blogger.com/profile/14315467528982997922noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-20236747497356971632014-03-05T05:49:48.371-08:002014-03-05T05:49:48.371-08:00sir, i don't understad how can i dosir, i don't understad how can i doAnonymoushttps://www.blogger.com/profile/14315467528982997922noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-57248088479603205592013-11-28T22:36:10.947-08:002013-11-28T22:36:10.947-08:00How to skip this column while inserting into table...How to skip this column while inserting into table, since we are using auto increment. plz provide solution for asp.net.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-41848338957652499522013-07-15T09:10:20.976-07:002013-07-15T09:10:20.976-07:00H.
I want a query which display data like below
I...H.<br />I want a query which display data like below<br /><br />Id EmpNo Name<br />1 Emp-2013-2014-0001 ABC<br />2 Emp-2013-2014-0002 XYZ<br />.................................................after 2013<br />10 Emp-2014-2015-0001.........PQR .... .again starts from one.<br />11 Emp-2014-2015-0002.........DEF....<br /><br />plz help me thx in Vinod Kamblehttps://www.blogger.com/profile/01572618692605271688noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-42038008994564946692013-05-13T05:14:17.495-07:002013-05-13T05:14:17.495-07:00sir i want increment the emp id automatic generato...sir i want increment the emp id automatic generator in web page<br />kalyanhttps://www.blogger.com/profile/13872125291849911626noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-24409390805306638992013-03-05T08:46:31.281-08:002013-03-05T08:46:31.281-08:00Hi suresh,
I have one requirement that , user ses...Hi suresh,<br /> I have one requirement that , user session should be logged off when user clicks on browser or browser tab. Please provide me any inputs/ solution approach for this problem as soon as possible.<br />Thanks in advance.satyahttps://www.blogger.com/profile/16705767625232595592noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-87088016223391715602012-09-16T01:50:39.597-07:002012-09-16T01:50:39.597-07:00This is helpful for me
thank you................This is helpful for me<br /><br />thank you................Anonymoushttps://www.blogger.com/profile/07227253858903205723noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-16683427529574746472012-05-17T01:36:26.694-07:002012-05-17T01:36:26.694-07:00@Pallavi....
if you set the this identity column a...@Pallavi....<br />if you set the this identity column automatically generate serial numbers if we insert record. If you want custom auto incremented column check this post <br /><a href="http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html" rel="nofollow">http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html</a>Suresh Dasarihttps://www.blogger.com/profile/01337689983379917267noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-11879961975750337152012-05-17T01:33:22.020-07:002012-05-17T01:33:22.020-07:00@yeswanth
check this post http://www.aspdotnet-su...@yeswanth <br />check this post <a href="http://www.aspdotnet-suresh.com/2011/12/search-records-in-gridview-and.html" rel="nofollow">http://www.aspdotnet-suresh.com/2011/12/search-records-in-gridview-and.html</a>Suresh Dasarihttps://www.blogger.com/profile/01337689983379917267noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-89008116408481839192012-05-17T01:25:17.864-07:002012-05-17T01:25:17.864-07:00How can i auto increment a column(like sl no.) in ...How can i auto increment a column(like sl no.) in reports.<br />Please help.<br />Thank youPallavihttps://www.blogger.com/profile/07679906399123440064noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-56922627349091007142012-04-30T07:36:13.488-07:002012-04-30T07:36:13.488-07:00sir iam a great fan of you and your website.. sir ...sir iam a great fan of you and your website.. sir i need sql server table for UserDetails which you used in filtering gridview parameters.. it would be helpful if u post this for meyeswanthnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-1327195935456592072012-04-16T06:58:39.782-07:002012-04-16T06:58:39.782-07:00but in the similar way if i want one record forex...but in the similar way if i want one record forexample.. from user ids...1 ,2,3,4,5,6... i delete userid 4... how can i reorder the ids to become the same as 1,2,3,4,5... user id 5 will become 4 and user id 6 will become 5... wats the procedure to adjust the primary ids automatically with the deletion of record...sohaibhttps://www.blogger.com/profile/08576720855760776262noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-62739744864686174042012-04-08T08:10:04.904-07:002012-04-08T08:10:04.904-07:00@ Comment 2...
To set 08U13001,08U13002 type id...@ Comment 2...<br />To set 08U13001,08U13002 type id's check this post here i explained clearly <a href="http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html" rel="nofollow">http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html</a>Suresh Dasarihttps://www.blogger.com/profile/01337689983379917267noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-386135230077537052012-03-04T04:33:55.619-08:002012-03-04T04:33:55.619-08:00sir i m agetting error like this while entering da...sir i m agetting error like this while entering data from asp.net page. "an explicit value for the identity column in table "xyz" can only be specified when a column list is used and IDENTITY_INSERT is ON" give me suggestion as soon as possible..plzDineshhttps://www.blogger.com/profile/03758128122599753188noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-3324969546753107592012-03-03T02:11:25.499-08:002012-03-03T02:11:25.499-08:00How to access distributed database in asp.net?How to access distributed database in asp.net?suresh guptahttps://www.blogger.com/profile/01822778929803707522noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-66386233474857869082012-02-21T09:24:26.123-08:002012-02-21T09:24:26.123-08:00super website sir... what a talent...super website sir... what a talent...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-63101012360260124182012-02-21T01:22:04.373-08:002012-02-21T01:22:04.373-08:00To set 08U13001,08U13002 type id's it's no...To set 08U13001,08U13002 type id's it's not possible with identity column because we can set identity column with integer datatype only. integer datatype column won't allow us to use characters.Suresh Dasarihttps://www.blogger.com/profile/01337689983379917267noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-79529551018488112222012-02-20T23:15:51.062-08:002012-02-20T23:15:51.062-08:00Sir
I WANT TO INCREMENT CUSTOMER OR EMPLOYEE ID ...Sir<br /><br /> I WANT TO INCREMENT CUSTOMER OR EMPLOYEE ID TO INCREMENT LIKE THIS<br /><br />08U13001<br />08U13002<br /><br />CAN I USE IDENTITY PROPERTY OF SQL<br /><br />THANK YOUAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-82737976072642338782012-02-17T05:04:54.097-08:002012-02-17T05:04:54.097-08:00Amazing....
I ever seen this kind of website.Amazing....<br />I ever seen this kind of website.Anonymousnoreply@blogger.com