Comments by sachi Dash

sachi Dash 4-Apr-16 5:00am View

Anyway I have already used an paid account.

sachi Dash 4-Apr-16 4:59am View

:D Actually I am a beginner in this work.

sachi Dash 22-Sep-15 2:58am View

Thanks a lot.

sachi Dash 22-Sep-15 2:57am View

Thanks everyone the code should be
string tableNamePlusDot = item + @"\.";

sachi Dash 26-May-15 9:19am View

Thanks a lot for reply.

If I select Top 10000 data then it works. For the following query it works fine:
"SELECT TOP 10000 T0.url AS '[Q1].[Site]' FROM user_url T0 "

But If I select all data like: "SELECT T0.url AS '[Q1].[Site]' FROM user_url T0 ". It does not works. It shows a error list like that:

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
at System.Text.StringBuilder.Append(String value)
at System.IO.StringWriter.Write(String value)
at Newtonsoft.Json.JsonTextWriter.WriteEnd(JsonToken token)
at Newtonsoft.Json.JsonWriter.AutoCompleteClose(JsonContainerType type)
at Newtonsoft.Json.JsonWriter.InternalWriteEnd(JsonContainerType container)
at Newtonsoft.Json.JsonWriter.WriteEndObject()
at Newtonsoft.Json.JsonWriter.WriteEnd(JsonContainerType type)
at Newtonsoft.Json.JsonWriter.WriteEnd()
at Newtonsoft.Json.JsonWriter.AutoCompleteAll()
at Newtonsoft.Json.JsonWriter.Close()
at Newtonsoft.Json.JsonTextWriter.Close()
at Newtonsoft.Json.JsonWriter.Dispose(Boolean disposing)
at Newtonsoft.Json.JsonWriter.System.IDisposable.Dispose()
at Newtonsoft.Json.JsonConvert.SerializeObjectInternal(Object value, Type type, JsonSerializer jsonSerializer)
at Newtonsoft.Json.JsonConvert.SerializeObject(Object value, Type type, JsonSerializerSettings settings)
at Newtonsoft.Json.JsonConvert.SerializeObject(Object value)
at Service.CreateReport(String reportname, String datasourceid, String parameter) in d:\BI-FERRET\App_Code\Service.cs:line 133

sachi Dash 26-May-15 9:02am View

Deleted

Thanks a lot for reply.

If I select Top 10000 data then it works. For the following query it works fine:
"SELECT TOP 10000 T0.url AS '[Q1].[Site]' FROM user_url T0 "

But If I select all data like: "SELECT T0.url AS '[Q1].[Site]' FROM user_url T0 ". It does not works. It shows a error list like that:

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
at System.Text.StringBuilder.Append(String value)
at System.IO.StringWriter.Write(String value)
at Newtonsoft.Json.JsonTextWriter.WriteEnd(JsonToken token)
at Newtonsoft.Json.JsonWriter.AutoCompleteClose(JsonContainerType type)
at Newtonsoft.Json.JsonWriter.InternalWriteEnd(JsonContainerType container)
at Newtonsoft.Json.JsonWriter.WriteEndObject()
at Newtonsoft.Json.JsonWriter.WriteEnd(JsonContainerType type)
at Newtonsoft.Json.JsonWriter.WriteEnd()
at Newtonsoft.Json.JsonWriter.AutoCompleteAll()
at Newtonsoft.Json.JsonWriter.Close()
at Newtonsoft.Json.JsonTextWriter.Close()
at Newtonsoft.Json.JsonWriter.Dispose(Boolean disposing)
at Newtonsoft.Json.JsonWriter.System.IDisposable.Dispose()
at Newtonsoft.Json.JsonConvert.SerializeObjectInternal(Object value, Type type, JsonSerializer jsonSerializer)
at Newtonsoft.Json.JsonConvert.SerializeObject(Object value, Type type, JsonSerializerSettings settings)
at Newtonsoft.Json.JsonConvert.SerializeObject(Object value)
at Service.CreateReport(String reportname, String datasourceid, String parameter) in d:\BI-FERRET\App_Code\Service.cs:line 133

sachi Dash 26-May-15 8:28am View

Deleted

Thanks a lot for reply.

If I select Top 10000 data then it works. For the following query it works fine:
"SELECT TOP 10000 T0.url AS '[Q1].[Site]' FROM user_url T0 "

But If I select all data like: "SELECT T0.url AS '[Q1].[Site]' FROM user_url T0 ". It does not works. It shows a error list like that:

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
at System.Text.StringBuilder.Append(String value)
at System.IO.StringWriter.Write(String value)
at Newtonsoft.Json.JsonTextWriter.WriteEnd(JsonToken token)
at Newtonsoft.Json.JsonWriter.AutoCompleteClose(JsonContainerType type)
at Newtonsoft.Json.JsonWriter.InternalWriteEnd(JsonContainerType container)
at Newtonsoft.Json.JsonWriter.WriteEndObject()
at Newtonsoft.Json.JsonWriter.WriteEnd(JsonContainerType type)
at Newtonsoft.Json.JsonWriter.WriteEnd()
at Newtonsoft.Json.JsonWriter.AutoCompleteAll()
at Newtonsoft.Json.JsonWriter.Close()
at Newtonsoft.Json.JsonTextWriter.Close()
at Newtonsoft.Json.JsonWriter.Dispose(Boolean disposing)
at Newtonsoft.Json.JsonWriter.System.IDisposable.Dispose()
at Newtonsoft.Json.JsonConvert.SerializeObjectInternal(Object value, Type type, JsonSerializer jsonSerializer)
at Newtonsoft.Json.JsonConvert.SerializeObject(Object value, Type type, JsonSerializerSettings settings)
at Newtonsoft.Json.JsonConvert.SerializeObject(Object value)
at Service.CreateReport(String reportname, String datasourceid, String parameter) in d:\BI-FERRET\App_Code\Service.cs:line 133

sachi Dash 26-May-15 7:34am View

I can not handle large amount of data. My service can send around 100000 data. But it doesn't work when I send around million data. I want to get large number of data in that way.

sachi Dash 30-Apr-15 6:32am View

Sorry it doesn't show anything ! I used this code.
foreach (var m in matches)
{
MessageBox.Show(m.ToString());
}

sachi Dash 30-Apr-15 6:06am View

You got it. Then how can I separate value from matches?

sachi Dash 30-Apr-15 1:03am View

This is another question. Thanks for the reply.

sachi Dash 23-Apr-15 7:09am View

It is nothing just function within a function ! I need to find out the function with its closing parenthesis. Each function return a string. At the End of the work mainstring will will replace with the value and it will looke like: Daily consumption Report 02-04-2015" instead of Daily @f4(@f1(@f3(@f5(P1)))|@f1()) Report @f5(). So I need to get the function with exact closing brackets. If I want to get @f5 I need to get @f5(p1)then it will return a value. If I want get @f1 I need to get @f1(@f3(@f5(P1)))that will return a value. After getting the return value of @f1 The string will replace @f1(@f3(@f5(P1))) by this return value.

sachi Dash 31-Mar-15 4:09am View

Thanks a lot both of you ! Mr @Digimanus can you please tell me the details like how to create db for this script ? Is there any management studio for SQLite ?

sachi Dash 10-Mar-15 9:23am View

hello how are you? For the following
input:select rp_site.[user] as '[siteq1].[user_ip]'
wordToFind: rp_site.
here I get count=0; why ? please give me a solution. but rp_site. is here in input string. then why count get 0 instead of 1 ? please help me.

sachi Dash 19-Feb-15 4:11am View

Many Many Thanks !

sachi Dash 2-Feb-15 7:53am View

Almost correct. Only last line should be

string sub1 = sub.Substring(0, sub.indexOf(")")+1);

Thanks a lot !

sachi Dash 2-Feb-15 6:24am View

Sample input: @usertext(Enter Your Code, date, test, bla, bla,bla,......);
output:Enter Your Code

Always want to get the first portion inside the bracket.

sachi Dash 2-Feb-15 5:37am View

input is a string & we need to check this string is there @usertext or not. if there is @usertext then you will find a format with @usertext and we need to parse "Enter your Code".

input: string data= @usertext(Enter Your Code, date, test, bla, bla,bla,......);

output: Enter Your Code

sachi Dash 14-Dec-14 0:51am View

It doesn't work for me. Click event is not allowed here. Try to understand at first need to loading windows form then my event will call automatically that I need actually. If you write ProcessPDF()in geckoWebBrowser1_DocumentCompleted event then it is not wright. Because When geckoWebBrowser1_DocumentCompleted event is calling in that time Form Loading is completed.

sachi Dash 12-Dec-14 9:13am View

Actually I have used firstly Form_shown and was worked for default WebBrowser but it is not worked for geckoWebBrowser.

sachi Dash 12-Dec-14 9:03am View

giving error !

sachi Dash 12-Dec-14 8:59am View

Yes you are right now. I want to loading this webpage then I want to get DOM from this webpage. Try to help me.

sachi Dash 12-Dec-14 8:16am View

@Mr. Mahesh Patel .... I am not using web. I am using geckoWebBrowser.

sachi Dash 12-Dec-14 8:13am View

No it doesn't work. Please keep in mind at first need to load windows form then PDF_Click will occurred. When you are putting PDF.PerformClick(), this time windows form loading doesn't completed.

sachi Dash 12-Dec-14 8:04am View

No it is not right. See the question again. I have improved it.

sachi Dash 12-Dec-14 8:00am View

No It is wrong ! When I call PDF_Click(new object(),new EventArgs()), in that time windows form loading is not completed. I have improved my code. See the question agein.

sachi Dash 12-Dec-14 7:31am View

Where I need to put this code ? Please keep in mind at first need to load windows form then PDF_Click will occurred.

sachi Dash 25-Nov-14 0:12am View

I have updated my question. Please see the following table. This is a dynamic table. When I browse this page then It will take data from database then it will show in webpage. This webpage included a lot of javascript file. I need to run the webpage then I can only get the data from webpage. But WebClient only return all the resources of this page. Like html, css, and as well as included file name. But I need to return data for every column of table. Do you understand now?

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<title>BAT</title>

<link href="../Reports/NodeLogjamilah116201411584280NodeLog/NodeLogjamilah116201411584280NodeLog.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="../Reports/NodeLogjamilah116201411584280NodeLog/NodeLogjamilah116201411584280NodeLog.js"></script>
<script type="text/javascript" src="../../js/jquery-1.8.0.min.js"></script>
<script type="text/javascript" src="../../js/AllPageLoad.js"></script>

<script type="text/javascript">

jQuery(document).ready(function ($) {

AllPageLoad();

});
</script>

</head>

<body>
<div divtype="Tabs">

<div id="slidetabs" class="clean_rounded-horizontal">

<div class="st_tabs" divtype="Tab_Name">
<div style="overflow: hidden;" class="st_tabs_wrap">
<ul class="tab-links st_tabs_ul">
<li class="st_li_first st_li_active">Report1</li>

<li class="">Report2</li><li class="st_li_last">Report3</li></ul>
</div>
</div>

<div class="st_views" id="DynamicGrid" divtype="Tab_View">

<div style="position: absolute; left: 0px;" class="tab-1 st_view st_view_first st_view_active">
<div style="position: relative; height:400px;" class="tabcontent">

<table report_type="Horizontal Table" auto-aggregation="off" id="HorTable0" sort="asc" relativeid="HorTable1" top="50" bottom="" left="50" right=""><thead><tr><td>Node Name</td><td>Hit</td><td>Duration</td></tr></thead><tbody><tr><td att="@VAL([NodeLogQuery1].[NodeName])" data_type="undefined"></td><td att="@VAL([NodeLogQuery1].[Hit])" data_type="undefined"></td><td att="@VAL([NodeLogQuery1].[Duration])" data_type="undefined"></td></tr></tbody></table><table report_type="Horizontal Table" auto-aggregation="off" id="HorTable1" sort="asc" relativeid="HorTable0" top="" bottom="10" left="" right="50"><thead><tr><td>Node Name</td><td>Hit</td><td>Duration</td></tr></thead><tbody><tr><td att="@VAL([NodeLogQuery1].[NodeName])" data_type="undefined"></td><td att="@VAL([NodeLogQuery1].[Hit])" data_type="undefined"></td><td att="@VAL([NodeLogQuery1].[Duration])" data_type="undefined"></td></tr></tbody></table></div>

</div>

<div style="position: absolute; left: 2560px;" class="tab-2 st_view">
<div style="position: relative; height:400px;" class="tabcontent"><table report_type="Vertical Table" auto-aggregation="off" id="VerTable0" sort="asc" relativeid="tab-2 st_view st

sachi Dash 24-Nov-14 8:05am View

Is it works for external css ? I am using a lot of external css and a lot of javascript file. How can I access all of them ? I am also using high chart. What will be the result for high chart ? How can I read css?

sachi Dash 4-Nov-14 6:52am View

I am actually telling the space after last word. Do you understand now? help me if possible.

sachi Dash 18-Oct-14 2:20am View

worksheet1.Range[worksheet1.Cells[i + 1, j + 1], worksheet1.Cells[i+1,j+colSpan]].Merge();

Now I am using in this way... I am using Range instead of get_Range. ... Thanks a lot again !

sachi Dash 17-Oct-14 3:25am View

Thanks a lot. Actually I already see it. Can you please tell me what is A1 or B2 and what do you mean by C55 ?

sachi Dash 17-Oct-14 0:58am View

can you please give me some details with an example where this method is implemented ?

sachi Dash 25-Aug-14 4:55am View

yes I did it ....... but still it doesn't work !

sachi Dash 25-Aug-14 4:32am View

I have done it .... but it does not work !

sachi Dash 18-Aug-14 5:12am View

can you provide me a sample code for my given code ?

sachi Dash 9-Jul-14 3:22am View

I do not use any any asp.net page.... It is a html page. I mean extentension is .html and I use webbrowser desktop control.

sachi Dash 25-Jun-14 6:42am View

on first loading all the tabs and its content will load. I need to export the content of each tab in different sheet in a excel file

sachi Dash 18-Jun-14 3:27am View

I already use this code
dset.Tables.Add(newDT)

But I want to make sure for this reason I have given this post. Anyway thanks!

sachi Dash 17-Jun-14 2:27am View

Thanks a lot !

sachi Dash 26-May-14 4:32am View

I have found it already... but i can't integrate it with add and delete !

sachi Dash 22-May-14 6:18am View

Thanks a lot brother

sachi Dash 21-May-14 5:46am View

For the same case i also need uniqesummaryofTTS.abc and crUniquesummary.EndMarket

sachi Dash 21-May-14 5:45am View

hello if
input = "case when DateDiff (uniqesummaryofTTS.abc=0) OR 'apstps.bca=0' OR crUniquesummary.EndMarket=1"

Then it doesn't work.

sachi Dash 14-May-14 7:13am View

can you provide me the code?

sachi Dash 14-May-14 7:00am View

single click means a button click.

sachi Dash 6-May-14 7:15am View

It is not always EndMarket it can be BeginMarket<0, MiddleMarket<=0 etc. For everytime i want to get the portion brfore operator like MiddleMarket,BeginMarket etc.

sachi Dash 6-May-14 7:15am View

It is not always EndMarket it can be BeginMarket<0, MiddleMarket<=0 etc. For everytime i want to get the portion brfore operator like MiddleMarket,BeginMarket etc.

sachi Dash 2-May-14 2:56am View

If possible then give me an example code.

sachi Dash 30-Apr-14 7:26am View

It doesn't matter what kind of error it is ! I need to show this message what sql server shows after getting any wrong.

sachi Dash 28-Mar-14 5:09am View

no ......

sachi Dash 27-Mar-14 5:54am View

no... there is a problem ! thats why i write it through code.

sachi Dash 27-Mar-14 5:53am View

i need a dynamic way to represent column..... when i don't know the "columnname".

sachi Dash 9-Mar-14 0:40am View

I want to show some information using pivot table. I have a dataset. I have converted it, into Json string. Then i send it to my clint side. Now i want to show this information through pivot table. Can you help me?

sachi Dash 6-Mar-14 7:29am View

ok no problem. I used GIT.HUB, there is a plugin for pivot table. But then what should i will do?

sachi Dash 4-Mar-14 5:20am View

After clicking the project properties .... I get option like that

>Common Properties
>Startup Project
>Poject Dependencies
>Debug Source Files

>Configuration Properties
>Configuration

sachi Dash 4-Mar-14 3:56am View

but didn't find anything like that.. i am using visual studio 2008.

I find like >Common Properties
>Startup Project
>Poject Dependencies
>Debug Source Files

>Configuration Properties
>Configuration

sachi Dash 3-Mar-14 4:05am View

You are right. Thanks a lot, lot and lot ! How I can change its version to 3.5 ? I mean i am running this on less than version 3.5. Then how can i select 3.5 for this project from version 2.0 ?

This error is shown in webpage if i run this project. Can you help me after seen this problem.
Is it for version another.

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE> "C:\Windows\Microsoft.NET\Framework\v2.0.50727\csc.exe" /t:library /utf8output /R:"C:\Windows\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll" /R:"C:\Windows\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.WorkflowServices\3.5.0.0__31bf3856ad364e35\System.WorkflowServices.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Core\3.5.0.0__b77a5c561934e089\System.Core.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Data.DataSetExtensions\3.5.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll" /R:"C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Xml.Linq\3.5.0.0__b77a5c561934e089\System.Xml.Linq.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll" /R:"C:\Windows\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.ServiceModel.Web\3.5.0.0__31bf3856ad364e35\System.ServiceModel.Web.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Web.Extensions\3.5.0.0__31bf3856ad364e35\System.Web.Extensions.dll" /R:"C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll" /out:"C:\Users\suman.SSD-TECH\AppData\Local\Temp\Temporary ASP.NET Files\biportal-dev\947cac42\73de6232\App_Code.xl0pv-9w.dll" /D:DEBUG /debug+ /optimize- /w:4 /nowarn:1659;1699;1701 "C:\Users\suman.SSD-TECH\AppData\Local\Temp\Temporary ASP.NET Files\biportal-dev\947cac42\73de6232\App_Code.xl0pv-9w.0.cs" "C:\Users\suman.SSD-TECH\AppData\Local\Temp\Temporary ASP.NET Files\biportal-dev\947cac42\73de6232\App_Code.xl0pv-9w.1.cs" "C:\Users\suman.SSD-TECH\AppData\Local\Temp\Temporary ASP.NET Files\biportal-dev\947cac42\73de6232\App_Code.xl0pv-9w.2.cs" "C:\Users\suman.SSD-TECH\AppData\Local\Temp\Temporary ASP.NET Files\biportal-dev\947cac42\73de6232\App_Code.xl0pv-9w.3.cs" "C:\Users\suman.SSD-TECH\AppData\Local\Temp\Temporary ASP.NET Files\biportal-dev\947cac42\73de6232\App_Code.xl0pv-9w.4.cs" "C:\Users\suman.SSD-TECH\AppData\Local\Temp\Temporary ASP.NET Files\biportal-dev\947cac42\73de6232\App_Code.xl0pv-9w.5.cs"

sachi Dash 2-Mar-14 3:01am View

I have improved my question ...... please keep in mind that same code works in one project. But when I put it into SourceSafe some error shown. Probably it can not take any LING expression. But why? please help if possible.

sachi Dash 27-Feb-14 6:11am View

nice suggestion ... but it does not work !

ok you think like that.... then give me code for this one.

string str ="a.LastUpdate,a.AgreementID,a.AgreementID,b.CustomerID,a.AgreementID"

the output will be like: str="a.LastUpdate,a.AgreementID,b.CustomerID"

sachi Dash 20-Feb-14 3:31am View

yes, @variable word is always at the start of the string but i also need skip the parenthesis.... i need to get output id not (id). so please consider it.

sachi Dash 18-Feb-14 4:50am View

you didn't get my question. I mean if i want only "hello" from this string what code i should write. I want to split first portion from the string not other portion.

sachi Dash 18-Feb-14 4:33am View

can you help me please for another question.

if I want to split it till before the first comma?

sachi Dash 18-Feb-14 2:30am View

Thanks !!

sachi Dash 13-Feb-14 4:42am View

ReportID DatasrceOrder DataSourceID GlobalClassID DataName AggregationValue
Test_Report 2 Balance_Agreement Test_Report_Class CustomerID
Test_Report 1 Balance_Agreement Test_Report_Class Agreement ID
Test_Report 1 Balance_Query Test_Report_Class LastUpdate
Test_Report 1 Balance_Query Test_Report_Class Balance sum

Example of Query:

Select Balance_Agreement.CustomerID,
Balance_Agreement Agreement ID,
Balance_Agreement.LastUpdate,
sum(Balance_Query.Balance)

FROM Balance_Agreement,Balance_Agreement

I need to write a common function to form this kind of query.

sachi Dash 13-Feb-14 1:59am View

you know query has different part like
Select:
FROM:
WHERE:
GroupBy:

Every row tell me what is my select option, what table is used in from condition, Is there any where condition or not, is there any groupby condition or not.

sachi Dash 24-Nov-13 0:59am View

Yes, it is working now. I used LINQ.

sachi Dash 24-Nov-13 0:56am View

Thanks a lot Brother. Now it is working !!! :D

sachi Dash 20-Feb-13 0:40am View

Thanks Brother... :D

Comments by sachi Dash (Top 69 by date)