Comments by Shanalal Kasim

Shanalal Kasim 20-Jan-20 5:53am View

Refer https://www.c-sharpcorner.com/article/how-to-add-net-project-into-azure-devops-git-repo-for/

Shanalal Kasim 22-May-15 5:34am View

Are you using code first approach

Shanalal Kasim 13-Feb-15 7:05am View

can you share your code

Shanalal Kasim 14-Jun-14 11:44am View

I want to select ID =5

Shanalal Kasim 2-Jun-14 2:13am View

The question is not clear

Shanalal Kasim 29-May-14 6:09am View

Thanks

Shanalal Kasim 29-May-14 4:55am View

Nice

Shanalal Kasim 28-May-14 6:38am View

Please give me the rating

Shanalal Kasim 4-Mar-14 7:00am View

Please give me that solution I am stuck with this error

Shanalal Kasim 4-Mar-14 6:54am View

I think something is missing in your comment

Shanalal Kasim 4-Mar-14 6:38am View

In web.config there is no information add for Microsoft.Office.Interop.Word

Shanalal Kasim 4-Mar-14 6:13am View

Thanks for your reply. I check on that folder I found 'Microsoft.Office.Interop.Word'

Shanalal Kasim 10-Jan-14 0:00am View

can you answer this question: http://www.codeproject.com/Questions/708827/How-to-set-dynamically-created-tablelayout-cell-he

Shanalal Kasim 3-Jan-14 4:43am View

Thanks... Its working

Shanalal Kasim 6-Dec-13 2:07am View

Please provide your table structure and sample data?

Shanalal Kasim 25-Oct-13 8:42am View

Yes i want to move my TFS from one server to another server. the servers are in same domain

Shanalal Kasim 25-Oct-13 8:38am View

Yes, i want to move TFS (version 2010) from one machine to another.

Shanalal Kasim 18-Jul-13 7:42am View

No. In first time we are executing all script from our side so there no problem. while releasing new version that contain script file related to that release that will executed by client. so we need to simplify the step.

Shanalal Kasim 18-Jul-13 6:59am View

+5

Shanalal Kasim 18-Jul-13 6:56am View

Thanks for your comments. Actually i need, how to execute bulk script file in client side.
My idea is creating a exe that contain all script file, running that in client side.
please provide any suggestion for achieving this

Shanalal Kasim 20-Jun-13 5:57am View

+5

Shanalal Kasim 29-May-13 5:58am View

Please tell me bio-metric Machine name

Shanalal Kasim 22-May-13 4:27am View

Are using dynamic sql in your current project?

Shanalal Kasim 17-Apr-13 7:24am View

Your giving id format is fixed ?.
Thant means your giving first 14 number(from left) am i right?

Shanalal Kasim 12-Apr-13 20:44pm View

Thanks

Shanalal Kasim 12-Apr-13 9:03am View

What happened?

Shanalal Kasim 12-Apr-13 5:16am View

Thanks brother

Shanalal Kasim 12-Apr-13 5:13am View

check improved solution

Shanalal Kasim 12-Apr-13 4:59am View

Deleted

Please tell me your sql server version?

Shanalal Kasim 12-Apr-13 3:17am View

+5

Shanalal Kasim 12-Apr-13 2:56am View

This is only a reference. You need more details Please improve your question with table structure and your select query

Shanalal Kasim 12-Apr-13 2:26am View

+5

Shanalal Kasim 12-Apr-13 2:11am View

You speaking about Team developer(centura programming language) ?

Shanalal Kasim 12-Apr-13 1:55am View

Please vote

Shanalal Kasim 11-Apr-13 7:52am View

Please vote

Shanalal Kasim 10-Apr-13 6:27am View

Thanks. Please vote.

Shanalal Kasim 10-Apr-13 1:59am View

Provide table structure

Shanalal Kasim 27-Mar-13 8:08am View

+5

Shanalal Kasim 27-Mar-13 8:08am View

+5

Shanalal Kasim 27-Mar-13 7:46am View

please mark this as answer.
In sp you can use like
select * from [dbo].[String_Tokenizer] (parameter)
Or
declare table variable like Declare @Tmp table ( Data nvarchar(100) )
then
insert into @Tmp select * from [dbo].[String_Tokenizer](parameter)

Other wise please explain your scenario

Shanalal Kasim 27-Mar-13 7:45am View

Deleted

please mark this as answer.
In sp you can use like select * from [dbo].[String_Tokenizer] (parameter)
Or
declare table variable like Declare @Tmp table ( Data nvarchar(100) )
then
insert into @Tmp select * from [dbo].[String_Tokenizer](parameter)

Shanalal Kasim 27-Mar-13 7:44am View

Deleted

please mark this as answer. In sp you can use like select * from [dbo].[String_Tokenizer] Or declare table variable like Declare @Tmp table ( Data nvarchar(100) ) then insert into @Tmp select * from [dbo].[String_Tokenizer](parameter)

Shanalal Kasim 27-Mar-13 7:44am View

Deleted

please mark this as answer.
In sp you can use like select * from [dbo].[String_Tokenizer]
Or
declare table variable like Declare @Tmp table
(
Data nvarchar(100)
)
then
insert into @Tmp select * from [dbo].[String_Tokenizer](parameter)

Shanalal Kasim 27-Mar-13 5:45am View

gvprabu: Thanks for improving my answer

Shanalal Kasim 27-Mar-13 5:43am View

Deleted

Thanks

Shanalal Kasim 27-Mar-13 2:09am View

this solution help, then please mark it as answer

Shanalal Kasim 27-Mar-13 1:47am View

Thanks

Shanalal Kasim 27-Mar-13 1:46am View

_Maxxx_ : I think the logic is
select col2 if col2 is null then select col1 from t1 then
select col1 from t2 where t2.col2 = t1.selected value

sql is

select case when ISNULL( a.col2,-1) =-1 then a.col1
else a.col2 end ,
( select col1 from t2 where col2 = case when ISNULL( a.col2,-1) =-1 then a.col1
else a.col2 end )

from t1 a

Shanalal Kasim 27-Mar-13 0:21am View

provide error text

Shanalal Kasim 26-Mar-13 7:49am View

Thanks

Shanalal Kasim 26-Mar-13 7:49am View

Thanks

Shanalal Kasim 26-Mar-13 0:32am View

+5

Shanalal Kasim 21-Mar-13 4:31am View

Thanks

Shanalal Kasim 11-Mar-13 5:53am View

Provide more details

Shanalal Kasim 7-Mar-13 1:58am View

What is your problem ??????

Shanalal Kasim 7-Mar-13 0:33am View

Please provide table structure with sample data

Shanalal Kasim 5-Mar-13 5:21am View

k

Shanalal Kasim 5-Mar-13 5:16am View

Val1 VAl2 Val3 Val4 Val5 - these columns are fixed?

Shanalal Kasim 5-Mar-13 4:06am View

question is not clear?

Shanalal Kasim 26-Feb-13 7:23am View

We can't handle that case so show a message in update like this "Selected record deleted by another user"

Shanalal Kasim 26-Feb-13 7:19am View

In order to use the MIN function on a bit column, you need to convert to something that the MIN function does work with. In this case we can convert to int

select Min(convert(int,bit_column_name)) from TableName

Shanalal Kasim 26-Feb-13 7:06am View

Deleted

Please share your sql server version

Shanalal Kasim 21-Feb-13 4:27am View

+5

Shanalal Kasim 20-Feb-13 1:49am View

Provide your table structure with sample data

Shanalal Kasim 20-Feb-13 1:46am View

What is you question?

Shanalal Kasim 19-Nov-12 0:23am View

provide your exact query with where condition

Shanalal Kasim 18-Nov-12 5:14am View

Provide more details

Shanalal Kasim 18-Nov-12 5:01am View

This is logical mistake. You are not add login condition in "Presentation Logic", You are all wise redirecting to "Home.aspx"

Shanalal Kasim 14-Nov-12 5:43am View

Do you check this link http://forums.devarticles.com/general-sql-development-47/for-loop-cursor-151552.html for looping Cursors

Shanalal Kasim 14-Nov-12 5:29am View

Give rating

Shanalal Kasim 14-Nov-12 5:29am View

This solution was helped for solving your issue, then mark it as answer.

Shanalal Kasim 14-Nov-12 5:28am View

Refer: http://forums.devarticles.com/general-sql-development-47/for-loop-cursor-151552.html

Shanalal Kasim 14-Nov-12 5:23am View

Change ->BY icode DESC to BY icode ASC

Shanalal Kasim 14-Nov-12 5:12am View

Try my new solution, tell me its working or not?

Shanalal Kasim 14-Nov-12 5:11am View

Try my new solution

Shanalal Kasim 14-Nov-12 5:09am View

Please check my solution

Shanalal Kasim 14-Nov-12 4:25am View

Then you can use single update statement.
Can you explain the serial number generating method?

Shanalal Kasim 14-Nov-12 4:21am View

Thanks

Shanalal Kasim 14-Nov-12 4:19am View

Provide more details for 'serialnum'.
The first 3 records serialnum is 1, 4&5 record serialnum is 2 please explain how to calculate this serialnum?

Shanalal Kasim 14-Nov-12 3:44am View

This question is duplicate of http://www.codeproject.com/Questions/493238/Ipluswantplustoplusupdateplustableplususingplusloo

Shanalal Kasim 14-Nov-12 3:41am View

My 5

Shanalal Kasim 14-Nov-12 3:36am View

Refer: http://forums.devarticles.com/general-sql-development-47/for-loop-cursor-151552.html

Shanalal Kasim 14-Nov-12 0:18am View

RefNumber is Student Table column?
Which table count your taking?

Shanalal Kasim 13-Nov-12 9:55am View

Thanks

Shanalal Kasim 13-Nov-12 9:34am View

Thanks

Shanalal Kasim 13-Nov-12 9:34am View

Thanks

Shanalal Kasim 13-Nov-12 4:55am View

The question is not clear. provide more details.

Shanalal Kasim 13-Nov-12 4:52am View

so you want, every day index start with zero?

Shanalal Kasim 12-Nov-12 4:28am View

Provide more details about what you are trying to achieve.

Shanalal Kasim 12-Nov-12 4:23am View

Deleted

yes.
Please rate this answer

Shanalal Kasim 12-Nov-12 3:37am View

If it helped you to solve your problem , mark it as answer

Shanalal Kasim 12-Nov-12 3:37am View

Deleted

If it helped you to solve your problem , mark it as answer

Shanalal Kasim 12-Nov-12 1:57am View

Deleted

Text box only support Normal text(normal string).
Word data is in Rich Text Format(rtf)so use Rich text box control.

Shanalal Kasim 12-Nov-12 1:22am View

Provide more details

Shanalal Kasim 11-Nov-12 3:22am View

Provide error details

Shanalal Kasim 11-Nov-12 1:43am View

Thanks

Shanalal Kasim 10-Nov-12 12:59pm View

Provide more details about your problem

Shanalal Kasim 10-Nov-12 12:48pm View

provide error details

Shanalal Kasim 10-Nov-12 9:28am View

please give rating(vote)

Shanalal Kasim 10-Nov-12 8:56am View

Welcome

Shanalal Kasim 10-Nov-12 6:48am View

hi Nour ,
can you provide more details

Shanalal Kasim 10-Nov-12 5:07am View

welcome

Shanalal Kasim 10-Nov-12 3:01am View

k.Please mark this solution as answer

Shanalal Kasim 10-Nov-12 2:56am View

Provide your table structure

Shanalal Kasim 10-Nov-12 2:52am View

Welcome

Shanalal Kasim 10-Nov-12 2:51am View

" And if B have added 2 person on his left and right B will get commission but A will get commission until C's Left and Right members are added. "

A get commision after B & C added Left and Right members, it correct?

Shanalal Kasim 10-Nov-12 2:46am View

If it helped you to solve your problem , mark it as answer

Shanalal Kasim 10-Nov-12 1:43am View

Your issue is solved?

Shanalal Kasim 10-Nov-12 1:31am View

check my solution

Shanalal Kasim 10-Nov-12 1:17am View

Suppose your sponcorid id 'P4UPMA00075341' , then it will change to 'P4UPMA00075342'

Tell me the sponcorid format(i think 8 position from Right is number ).

Shanalal Kasim 10-Nov-12 1:04am View

Your question is not clear.

Shanalal Kasim 9-Nov-12 1:11am View

Welcome

Shanalal Kasim 9-Nov-12 1:07am View

welcome

Shanalal Kasim 9-Nov-12 0:05am View

Please refer this demo url
http://demos.telerik.com/aspnet-ajax/window/examples/radwindowandmdi/defaultcs.aspx

Shanalal Kasim 8-Nov-12 10:14am View

In default page list all menus, clicking on menu the page load inside default page(Using Telerik control). suppose user clicking on page1.aspx menu then that page will loading inside default.aspx (The browser url is Myapplication/Default.aspx this url is not changing, user clicking next menu then that page will load inside default page).
my issue is while user type any direct url(Except Myapplication/Default.aspx or Myapplication/Login.aspx) then that url will be redirect to Myapplication/Default.aspx

Shanalal Kasim 8-Nov-12 10:01am View

user can access that page through Default page not directly

Shanalal Kasim 8-Nov-12 9:23am View

the user accessing direct url(Myapplication/page1.aspx) after successful login so authorization is not work

Shanalal Kasim 8-Nov-12 8:38am View

change this line-> CONVERT(VARCHAR(23), LEFT(Dt_Tm, 11) + ' ' + SUBSTRING(Dt_Tm,13,2) + RIGHT(Dt_Tm,2),120),
to-> convert(varchar,LEFT(Dt_Tm, 11) + ' ' + SUBSTRING(Dt_Tm, 13, 2) + ':' + RIGHT(Dt_Tm, 2) + ':00')

Shanalal Kasim 8-Nov-12 8:11am View

please provide full code with table structure

Shanalal Kasim 8-Nov-12 8:03am View

please try this sql

select convert(date,LEFT(Dt_Tm, 11) + ' ' + SUBSTRING(Dt_Tm, 13, 2) + ':' + RIGHT(Dt_Tm, 2) + ':00') from yourtable

In my end this sql is working and return 2012-10-10

Shanalal Kasim 8-Nov-12 6:58am View

If it helped you to solve your problem , mark it as answer

Shanalal Kasim 8-Nov-12 6:57am View

If it helped you to solve your problem , mark it as answer

Shanalal Kasim 8-Nov-12 6:57am View

If it helped you to solve your problem , mark it as answer

Shanalal Kasim 5-Nov-12 3:21am View

Deleted

Sorry.
Please try improved solution

Shanalal Kasim 3-Nov-12 0:29am View

If it helped you to solve your problem , mark it as answer

Shanalal Kasim 2-Nov-12 5:22am View

please provide a sample table record

Shanalal Kasim 2-Nov-12 0:41am View

please provide full error details

Shanalal Kasim 1-Nov-12 2:31am View

Provide error details

Shanalal Kasim 30-Oct-12 3:02am View

U have not executed query,
1. Execute query
2. fetch the result
3. Bind it to grid

Shanalal Kasim 29-Oct-12 14:26pm View

Deleted

Refer below link
http://www.codeproject.com/Articles/15962/SQL-Server-database-versioning-with-Subversion-SVN
http://www.red-gate.com/products/sql-development/sql-source-control/

Shanalal Kasim 29-Oct-12 8:11am View

what?

Shanalal Kasim 29-Oct-12 5:24am View

Use different prefix for online & offline bill numbers

Shanalal Kasim 29-Oct-12 5:14am View

first check stored procedure using Execute stored procedure option

Shanalal Kasim 19-Oct-12 3:13am View

You can use a single stored procedure for Master & detail table insertion

Comments by Shanalal Kasim (Top 134 by date)