Comments by Member 12693375

Member 12693375 20-Jul-17 6:43am View

Wrong Answer Sir u can check it practically
string input1 = "8,16,9,18,19";
string output1 = input1.Substring(input1.IndexOf(',') + 2);

It gives me output like this: "6,9,18,19";

Member 12693375 12-Apr-17 2:13am View

I m making a test.asmx web service for uploading the image to folder And using the code
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public void Update_Profile1(HttpPostedFileBase filepost, string User_Id)
{
if (filepost != null)
{
string fileName = Path.GetFileName(filepost.FileName);
filepost.SaveAs(Server.MapPath("~/Images/") + User_Id + fileName);
}
}

Member 12693375 12-Apr-17 0:40am View

i already granted to my folder then what next?

Member 12693375 12-Apr-17 0:39am View

Thanks for your answer.but not happy and request to you please do not copy paste the code from somewhere to here,if u do not know the answer.

Member 12693375 5-Apr-17 6:45am View

Any Solution?????

Member 12693375 5-Apr-17 6:05am View

select d.* from(select Date,Credit,Debit, sum(Credit)-sum(Debit) as Balance from(

Select convert(varchar(10),date ,103) as Date, ISNULL(SUM(CAST(Runs as int)),0) as Credit ,
0 as Debit From UserMobile Where UserMobile .REtailer ='9888569493' And month ='October' And year =2016
Group By UserMobile.date

Union All

Select convert(varchar(10),date ,103) as Date, 0 as Credit ,ISNULL(SUM(CAST(Runs as int)),0) as debit
From DisptachOrder Where UserName =9888569493
Group By date)as c group by Date ,Credit,Debit) as d

Member 12693375 5-Apr-17 5:58am View

Inner Join but i hv two tables A and B
IN A i have 3 columns : mobileno,creditpoints,date
IN B i have 3 columns : mobileno,debitpoints,date

so i want the output like
Date Mobileno Credit Debit Balance
-- 9888xxx 10000 0 10000
-- 9888xxx 0 500 9500
-- 9888xxx 0 300 9200

And date is differnt.

Member 12693375 5-Apr-17 5:52am View

i used join but no exact result.can u make a query for this problem.plz help

Member 12693375 5-Apr-17 4:54am View

Thanks for the reply.but i have two tables so how is possible to get the running total after credit-debit.

Member 12693375 19-Sep-16 7:19am View

Nobody is here to resolve the issue

Member 12693375 19-Sep-16 5:57am View

can anybody help me out on this issue?

Member 12693375 19-Sep-16 5:22am View

thanks.but when i am executing my query it was successfully executed.

Comments by Member 12693375 (Top 12 by date)