Comments by jinesh sam

jinesh sam 17-Nov-16 13:00pm View

some business logic... i need to validate the output from excel and API

jinesh sam 4-Oct-16 4:58am View

Thanks John:) For finding index i have separate method

jinesh sam 29-Sep-16 16:17pm View

@John, One Doubt, If < is Inside pre="C#" tag why we need to go for lt; Previously i didn't face any such issues. while positing questions

jinesh sam 29-Sep-16 12:55pm View

please suggest some tips to starts. Which method will be efficient ?

jinesh sam 6-Sep-16 5:28am View

Thanks Maciej :)

jinesh sam 5-Sep-16 16:19pm View

Updated the class definition. Please have a look

jinesh sam 5-Sep-16 16:01pm View

Since YearlyAmts is a list i can't directly use the year and NetAmount property. I updated the question with class structure. please have a look

jinesh sam 5-Sep-16 15:32pm View

using xpath expression "starts-with"

jinesh sam 7-Aug-16 8:45am View

yes its separate thread

jinesh sam 3-Aug-16 6:30am View

I refer this link.. but it was not useful for me. My XML structure is not generic

jinesh sam 3-Aug-16 5:10am View

Timer method works for me. Thanks :)

jinesh sam 2-Aug-16 13:39pm View

100% I agree..I modified my code accordingly. Thanks :)

jinesh sam 2-Aug-16 11:28am View

Thanks sheet.Cells[2, 2] works :) My question was which one is the best way to update the excel. Any suggestions on that?

jinesh sam 28-Jul-16 3:50am View

Excel.Cells(2,2) is not a valid statement. its throwing error. please help

jinesh sam 7-May-16 5:50am View

Thanks Bill :) In my case number of values in each List of Doubles will be same

jinesh sam 6-May-16 7:48am View

Thanks for posting the answer.
Getting error says: ValueCollection' does not contain a definition for 'Aggregate' dictionary
one more problem here, my list contain 25 entries and it may grow as well so how can i hard cord the index

jinesh sam 6-May-16 6:49am View

Super.. Thanks karthik :)

jinesh sam 6-May-16 1:12am View

I got answer... Can u please convert my solution to Lambda expression

jinesh sam 5-May-16 14:56pm View

I need to pick only one row based on the row index positions.

jinesh sam 5-May-16 6:12am View

Thanks for posting the answer. but my requirement is slightly different. No need to of double[] array

jinesh sam 5-May-16 6:09am View

i need to fetch only particular row by row index (rowPosition).
dictionary looks like
AE, .2535
GH, .568

jinesh sam 21-Apr-16 11:18am View

Sorry bos. its working fine. i was referring 0th index of the list value is updated on 1st. Thanks for your time

jinesh sam 21-Apr-16 11:13am View

there is nothing special in property normal get;set; i have shared my class structure as well.
tell me another work around to update a list

jinesh sam 21-Apr-16 11:11am View

it tried this as well
lsttaxbucket.Where(b => b.Year == year).SelectMany(t => t.taxbucketsub).Select(y => y.buckets.interest = 12);

jinesh sam 21-Apr-16 11:08am View

Before it was zero after the line executed also it remain same

jinesh sam 21-Apr-16 10:56am View

i am debugging.. cursor came to the inner section item.buckets.interest. even though its not updating that's my concern. i would like to know whether the syntax is correct or not.

jinesh sam 8-Apr-16 18:09pm View

Thanks :) Let me have a look on the Finzer's code

jinesh sam 8-Apr-16 17:36pm View

I am not getting any error message.. but i am not aware how to identify particular property is List, for example in plan object 3rd property is List client. in this case i need to again loop through the client object and have a check

jinesh sam 20-Mar-16 13:00pm View

You're welcome! :)

jinesh sam 17-Mar-16 12:58pm View

Yes its work for me. Thanks

jinesh sam 17-Mar-16 12:58pm View

Sascha its works for me..thanks a lot.

jinesh sam 17-Mar-16 7:04am View

It's already there

jinesh sam 17-Mar-16 6:50am View

portfolioID is an array. If its a single int it will work

jinesh sam 13-Mar-16 0:41am View

Thanks a lot Matt for your time and guidance.

jinesh sam 10-Mar-16 19:44pm View

Yes calculation part is harder..the code which i given is just a prototype. In real the returing object (linear growth) consists of around 15 properties and that too again array of objects each contain seprate logic such as contribution,distribution,liabilities goals etc.

jinesh sam 25-Feb-16 12:59pm View

Thanks Bill:) for your suggestions and broader approach

jinesh sam 25-Feb-16 12:30pm View

Yes its works. Initially that piece of code was not with me..since my linq approach fails i wrote that one.

jinesh sam 25-Feb-16 11:06am View

Its working... thanks: a lot :)

jinesh sam 25-Feb-16 10:50am View

getting an error " does not contain a definition for 'SelectMany' ". what might be the reason

jinesh sam 25-Feb-16 10:25am View

Thanks for prompt response. but my requirement is little different. PlanAccount is attached to Portfolio and Portfolio with Asset.

i need to query an Asset object

jinesh sam 29-Jan-16 1:26am View

Thanks Anil:) System.Web.Extension reference has to be added and System.Web.Script.Serialization namespace

jinesh sam 28-Jan-16 5:11am View

I tried to de-serialize using the code below
List<Plans> P = JsonConvert.DeserializeObject<List>(Restresponse);
but its showing error. please help

jinesh sam 28-Jan-16 3:50am View

Error:
Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List`1[CallingAService.Plans]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.

jinesh sam 28-Jan-16 3:49am View

Thanks :)
you means something like this.
List<Plans> P = JsonConvert.DeserializeObject<List<plans>>(Restresponse);
I am getting error. can you please help

jinesh sam 24-Nov-15 20:15pm View

Thanks phil:)

jinesh sam 24-Nov-15 20:11pm View

Thanks Manas :)

jinesh sam 10-Nov-15 2:02am View

Dude... can you pls identify why my code breaks.

jinesh sam 9-Nov-15 8:33am View

Thanks Dude :) Need to google about "//"

jinesh sam 9-Nov-15 7:39am View

But even it dosen't reach till office. can u please reply with exact path.
in real time i need to use loop

jinesh sam 29-Sep-15 14:32pm View

Run time error. I am using VS 2013
Error i am getting is: "Object reference not set to an instance of object"

jinesh sam 26-Sep-15 14:49pm View

in my code i am using FaType = (string)item.Element("AlternateFALIST")?.Element("AlternateFA")?.Element("FaType") ?? "" but its throwing error. Let me try with Extension Methods.
Thanks for your support :)

jinesh sam 21-Aug-15 15:16pm View

Update the Question with Expected Answer

jinesh sam 21-Aug-15 15:00pm View

Yes philippe.

jinesh sam 21-Aug-15 15:00pm View

@Andy Code not working as expected

jinesh sam 5-Aug-15 2:31am View

Thanks..Its very informative

jinesh sam 2-Aug-15 10:30am View

Thanks for your support...:)

jinesh sam 2-Aug-15 10:29am View

Thanks...Its helps me:)

jinesh sam 27-Jul-15 15:21pm View

.ToList().Any(i => !i);
This helps for me
again thanks for helping

jinesh sam 27-Jul-15 14:49pm View

@Maciej Thanks:) Actually i don't need to get the output as true,true,false.
if every thing is true. Its need to return single true or any false it should return false.How can i modify further

jinesh sam 26-Jul-15 14:27pm View

now i am getting return value as true. but the problem is when i pass "jin" it should return false because 3rd info node does not contain name starting with "jin"

jinesh sam 26-Jul-15 14:21pm View

return value received is false. if i pass "ji" it should be pass
let me try with ur suggestion

jinesh sam 24-Jul-15 2:52am View

Thanks its works fine :)

jinesh sam 23-Jul-15 14:55pm View

Here the cusip is under PositionSummary not under PositionDetail
So the where condition will work?

jinesh sam 23-Jul-15 6:50am View

@Matt Its not working with namespaces.

jinesh sam 18-Jul-15 4:41am View

Thanks :)

jinesh sam 18-Jul-15 3:10am View

Thanks this helps for me. What about null check is there any other option

jinesh sam 18-Jul-15 1:28am View

if i remove the namespace everything works fine

jinesh sam 18-Jul-15 1:18am View

I am not getting the result. What about other namespaces. Shall I add that to the namemanager.

jinesh sam 18-Jul-15 0:57am View

@Matt Thanks Its works fine

jinesh sam 18-Jul-15 0:38am View

Thanks:) I missed .Value
even if i use .value result is not expected.
This helps me .OrderBy(item => (float?)item.Element("ClosingMarketValue"))

jinesh sam 17-Jul-15 15:34pm View

if you are free please help on this question
http://www.codeproject.com/Questions/1010662/not-able-to-find-elements-with-Descendants-key-wor

jinesh sam 17-Jul-15 5:32am View

Thanks Mika :-) Its works fine. float? is new to me. need to google

jinesh sam 3-Jul-15 6:31am View

please use this link http://sqlfiddle.com/#!2/5e351f

jinesh sam 2-Jul-15 8:42am View

Num_Acct_type 0 stands for cash and 1 stands for margin
I need to get the account which have both
cash and margin
and CDE_MSDW_SEC should be same to for both key acct

jinesh sam 2-Jul-15 7:58am View

Hi dear,
i am using DB2 i think 'NOLOCK' keyword is not avaiable

jinesh sam 2-Jul-15 6:08am View

I have updated the question. please go through

jinesh sam 14-May-15 22:02pm View

@Mani Thanks for your answers:) considering the performance which approach will be best Select or LINQ. Can you please consider the query no 4 since it has joined two tables.Please

jinesh sam 14-May-15 7:34am View

Thanks CHill :)

jinesh sam 14-May-15 6:58am View

No worries

jinesh sam 14-May-15 6:55am View

I am asking for a single query which will do two things.

jinesh sam 14-May-15 6:54am View

@CHill60 Is there any possibilty to incoprate this code to my linq query.
so that i can avoid two lines of code.

jinesh sam 14-May-15 6:48am View

@Maciej Here you are not enclosing single qutoes. My requirement was that

jinesh sam 12-May-15 2:39am View

@Sascha Lefèvre Thanks for your suggestions.I have go through the links which you suggest. I understood the concept of paging and write a stored procedure but little confused how to use in front end. can you please send some pseudo code how to implement.For example if suppose i have 1050 records. it should run 11 loops ie 10*100+ 50

jinesh sam 11-May-15 21:52pm View

@Sascha Lefèvre, Regarding calculations: I need to get input from the sql query. From the input values i need to calculate some values using formulas and need to validate against DB2. So its a little complex. Thats the reason i am planning to do in batches. I think i cannot use CTE because all my calculations are on front end. Actually in real time i has a millions of records to process.

jinesh sam 11-May-15 21:41pm View

@Maciej Los Calculations is little complex.Thats the reason, i am planning to do in batches.All calculations are on front end not on server side. I think CTE is for server side

jinesh sam 11-May-15 21:36pm View

@PIEBALDconsult I am Using SQL Server 2008. I accept your point i will use datareader

jinesh sam 19-Apr-15 13:58pm View

Hi Sinisa... Its works fine. Thanks:)

jinesh sam 18-Apr-15 10:45am View

I can do something like this. But i need the index no. i some cases i need to reverse the loop

DataRow[] result = dt.Select("Breakpoint >= 30000");
foreach (DataRow row in result)
{
Console.WriteLine("{0}, {1}", row[0], row[1]);
}

jinesh sam 14-Apr-15 11:59am View

Thanks Praveen.. I got solution from Peter

jinesh sam 14-Apr-15 3:15am View

To include integers
Match match = Regex.Match(str, @"\d+.\d+|\d+");

jinesh sam 13-Apr-15 8:36am View

Thanks.. Its works fine :) One more doubt. If suppose the value is integer debug point not entering the while loop.How should i change the regex expression to accept both integer and decimal.

jinesh sam 13-Apr-15 6:56am View

Thanks:)

jinesh sam 13-Apr-15 5:31am View

Hi Samit,
Can you give any valid reason for your selection.

jinesh sam 8-Apr-15 10:28am View

Can you please help me on this Question
http://www.codeproject.com/Questions/894889/How-to-merge-cells-in-SheetData-How-to-Delete-One?arn=0

jinesh sam 8-Apr-15 9:57am View

Sorry for late reply. Lots of thanks for your detailed explanation

jinesh sam 6-Apr-15 9:31am View

I need to access only public varaibles

jinesh sam 31-Mar-15 6:23am View

I tried with the first one. but showing some error.i have updated the question. please have a look

jinesh sam 31-Mar-15 6:02am View

I am using IBM® Data Studio Version 4.1.0.0

jinesh sam 19-Mar-15 9:30am View

its a spelling mistake in VARCHAR2.
Now i am able to concatentate
Thanks :)

jinesh sam 19-Mar-15 8:48am View

for the first one i am getting an error

THE DATA TYPE, LENGTH, OR VALUE OF ARGUMENT 1 OF CONCAT IS INVALID. SQLCODE=-171, SQLSTATE=42815, DRIVER=4.16.53

for the second also same error
and for the 3rd
ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: CCSID ) . FOR. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.16.53

jinesh sam 19-Mar-15 8:45am View

its DateTime.

jinesh sam 19-Mar-15 8:23am View

string date = dt.Rows[i]["KEY_TMS"].ToString();

but its displays with am pm

i cannot use like this its showing an error
string date = dt.Rows[i]["KEY_TMS"].ToString("yyyy-MM-dd hh:mm:ss.ffffff");

jinesh sam 19-Mar-15 8:18am View

let me check

jinesh sam 19-Mar-15 8:04am View

Thanks for your support
I made changes as per your suggestion but millisecond portion is not working
i have updated the question please look into it

jinesh sam 19-Feb-15 23:51pm View

@Ramza Thanks...

jinesh sam 18-Feb-15 9:51am View

As per your suggestion. I have updated the question. Please look

jinesh sam 18-Feb-15 7:06am View

Rajeesh...as i said earlier i am able to display date in required format.but the problem is while i try to make changes in that column.Please refer "pikoh" comments.in there i have placed code for popluating grid view

jinesh sam 18-Feb-15 7:00am View

S i want to display date in dd/mm/yyyy format.

jinesh sam 18-Feb-15 6:55am View

Hi @Rajeesh...Actually where should i place this code. I am getting error while i am editing date column. i am able to display date in dd/MM/yyyy format but the problem is when i try to make a change in date.

jinesh sam 18-Feb-15 6:52am View

dataGridView1.DataSource = dc.dsreturn_family("Select ID,FullName,Mobile,DOB,Gender,Status from Family where Hno=" + hnumber).Tables[0];
dataGridView1.AutoResizeColumns();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.DefaultCellStyle.Font = new Font("Maiandra GD", 12);
dataGridView1.DefaultCellStyle.ForeColor = Color.Black;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns["DOB"].ValueType = typeof(DateTime);
dataGridView1.Columns["DOB"].DefaultCellStyle.Format = "dd/MM/yyyy";
This is the code i am using to populate gridviw

jinesh sam 18-Feb-15 6:49am View

Before binding there will be no columns so i am getting an error "object reference not set to an instance of object"

jinesh sam 18-Feb-15 6:43am View

@Animesh Datta... Can you explain little more?

jinesh sam 18-Feb-15 6:41am View

yes you are correct... i need to edit date column which is of dd/MM/yyyy format

jinesh sam 18-Feb-15 6:39am View

Hi @Pikoh...Actually where should i place this code. I am getting error while i am editing date column. i am able to display date in dd/MM/yyyy format but the problem is when i try to make a change in date.

jinesh sam 4-Jan-15 15:06pm View

My question is how to make changes with DB. My datagridview is bounded with dataset. But there is no oledbadapter defined in the form. so i am not able to use adapter.Update(dataTable) method

jinesh sam 4-Jan-15 5:40am View

Provide the code where you stuck

jinesh sam 4-Jan-15 5:14am View

Thanks....

jinesh sam 4-Jan-15 3:16am View

@Damith Thanks... Can you please help me to create List<OleDbParameter>

jinesh sam 4-Jan-15 3:13am View

@George Thanks for ur response. My question was different. I need to accept the parameter list in the function. in the function i am using <bold>cmd = new OleDbCommand(strqry, conn); so my parameter collection is lost

jinesh sam 29-Dec-14 6:25am View

itemData bound method is related to web applications and i am dealing with desktop applications.

jinesh sam 29-Dec-14 3:45am View

@sergey "Edit time" means suppose when the user begins to change some value of the cell.In the intial stage it is like a text column. when the user enter into the cell the cell type has to change like dropdownlist so as to select the item from the list.

jinesh sam 9-Nov-14 14:52pm View

In textbox_enter event i made KeyPreview = false then its work. thanks for your solution :)

jinesh sam 9-Nov-14 14:16pm View

where to declare currentLabelLocation

jinesh sam 9-Nov-14 14:00pm View

Code works... but the problem is when i use arrow keys inside a textbox the label moves how to prevent this

jinesh sam 9-Nov-14 6:15am View

i try like this but no result
if (ppdResult == DialogResult.OK)
{
MessageBox.Show("hai");//this code block not executing
pdoc.Print();//this code block not executing
}

jinesh sam 8-Nov-14 11:38am View

"The following code example shows the Click event-handling method for a button on the form." I need a button click event for the preview dialog Box

jinesh sam 5-Nov-14 15:46pm View

Me to getting the same Error 14 Non-invocable member 'System.Drawing.Printing.PrinterSettings.PaperSizes' cannot be used like a method.

jinesh sam 5-Nov-14 13:45pm View

:)

jinesh sam 5-Nov-14 2:08am View

I am getting this error<br/>
System.ComponentModel.TypeConverter' does not contain a definition for 'ConvertToFont' and no extension method 'ConvertToFont' accepting a first argument of type 'System.ComponentModel.TypeConverter

jinesh sam 5-Nov-14 1:29am View

string file means the entire xml or "[Font: Name=Tahoma, Size=19.75, Units=3, GdiCharSet=1, GdiVerticalFont=False]"

jinesh sam 30-Oct-14 7:20am View

@ashish1985s
s i will post the code

jinesh sam 25-Oct-14 1:46am View

thanks i get the result "C:\\Program Files\\CAS\\CASdb.accdb"
but it taking to much time. is there any other method or atleast to stop the search when the required file is found

jinesh sam 17-Oct-14 0:24am View

Thanks sir for your valuable comments..

jinesh sam 15-Oct-14 10:07am View

Did you mean like this..
Graphics gs = Graphics.FromImage(panel1.BackgroundImage);
Image img = Image.FromFile(Application.StartupPath + "\\chq2.jpg");
Point loc = new Point(10, 10);
gs.DrawImage(img, 100, 100, (float)(panel1.Width), (float)(panel1.Height));

jinesh sam 15-Oct-14 10:06am View

can please show a small demo

jinesh sam 15-Oct-14 1:45am View

Sir why i am using picture box is to identify where the string has to be placed. My plan is to print the cheque so i placed a blank cheque copy on the picture box.The date,amount position has to customize according to the user need. so i place two text box to change the cordinates values.
as per your suggestion i placed the code in the paint event of the picture box and the leave event of the textbox i call Invalidate method and its work fine
but now the problem is its not clearing the previous drawn string

jinesh sam 14-Oct-14 3:27am View

your assumption was correct. since i made a call pdoc.Print() after ppd.ShowDialog() so when the user cancel the preview its showing the print dialog again. As per your suggestion i remove the pdoc.Print() then its works fine. now the cancel button and close button performing the default action without any code. so thaks a lot

jinesh sam 14-Oct-14 3:16am View

i remove the else block then its working as i expected
Thanks...

jinesh sam 14-Oct-14 3:11am View

i am getting an error
System.Windows.Forms.PrintDialog' does not contain a definition for 'close' and no extension method 'close' accepting a first argument of type 'System.Windows.Forms.PrintDialog' could be found (are you missing a using directive or an assembly reference?

jinesh sam 2-Oct-14 13:01pm View

Thanks.. its works fine...

jinesh sam 2-Oct-14 10:41am View

i am binding with the help of this function

private void BindData_House()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select * from House where HouseId=" + hno;
FormView1.DataSource = da.GetDataCommon(cmd);
FormView1.DataBind();
}
its works in readonly mode

jinesh sam 1-Oct-14 3:30am View

its work fine. but one problem occurred in the design part. i am using master page and content page to display the data.
my content page named as gallery.aspx
and in that there is one div named as <div id="gallery">
when i populate the div with repeator the content flows out of the footer(designed in master page)
when i hard corded the div tag there is no problem
any idea ?!!

jinesh sam 1-Oct-14 2:08am View

Thanks i will go trough the link and revert back if any problem arise

jinesh sam 30-Sep-14 5:08am View

Since i don't know which tool to use i asked for the help. if any one suggest some tools or tips i will google about more

jinesh sam 25-Sep-14 11:16am View

Thanks its works.. Cheers...

jinesh sam 25-Sep-14 10:54am View

if i didn't include the date parameter

i get the error

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@dateto".

jinesh sam 25-Sep-14 10:52am View

its normal "datetime"

jinesh sam 25-Sep-14 10:49am View

Select dbo.fnKudishikaAmt('St.George Malankara Catholic Church',29,default)

i used this code to execute sql function in the back end

jinesh sam 19-Sep-14 15:36pm View

thanks dear.. its works fine as i expected..

jinesh sam 14-Sep-14 15:44pm View

Deleted

thanks for your advice...

i am getting output of the webservice in xml format as follows

<newdataset> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:isdataset="true" msdata:maindatatable="Customers" msdata:usecurrentlocale="true"> <xs:complextype> <xs:choice minoccurs="0" maxoccurs="unbounded"> <xs:element name="Customers"> <xs:complextype> <xs:sequence> <xs:element name="CustomerID" type="xs:string" minoccurs="0"> <xs:element name="CompanyName" type="xs:string" minoccurs="0"> <xs:element name="ContactName" type="xs:string" minoccurs="0"> <xs:element name="ContactTitle" type="xs:string" minoccurs="0"> <xs:element name="Address" type="xs:string" minoccurs="0"> <xs:element name="City" type="xs:string" minoccurs="0"> <xs:element name="Region" type="xs:string" minoccurs="0"> <xs:element name="PostalCode" type="xs:string" minoccurs="0"> <xs:element name="Country" type="xs:string" minoccurs="0"> <xs:element name="Phone" type="xs:string" minoccurs="0"> <xs:element name="Fax" type="xs:string" minoccurs="0"> <customers> <customerid>LAZYK <companyname>Lazy K Kountry Store <contactname>John Steel <contacttitle>Marketing Manager

12 Orchestra Terrace

<city>Walla Walla <region>WA <PostalCode>99362</PostalCode> <country>USA <Phone>(509) 555-7969</Phone> <fax>(509) 555-6221 <customers> <customerid>WOLZA <companyname>Wolski Zajazd <contactname>Zbyszek Piestrzeniewicz <contacttitle>Owner

ul. Filtrowa 68

<city>Warszawa <PostalCode>01-012</PostalCode> <country>Poland <Phone>(26) 642-7012</Phone> <fax>(26) 642-7012

jinesh sam 27-Aug-14 6:12am View

Cheers.. Now its work fine...
Thanks for your time and effort..

jinesh sam 27-Aug-14 5:52am View

again problem last row ie 7th record missing
dear my requirement is no 'Contra' From HeadName column and other condition is BanCode <>'Cash'

jinesh sam 27-Aug-14 5:41am View

Thanks Dear for your help.

Sorry your code doesn't full fill my requirement. please help

It will remove only 5th row. i need to remove 2nd row also

Comments by jinesh sam (Top 153 by date)