Comments by deepakdynamite

deepakdynamite 1-Aug-17 2:43am View

Thanks for your reply. I'm familiar with Azure SDK. What I'm seeking is a way to read data in batches from Azure storage as it's not a good practice to read 100,000 rows in memory and then loop through it ...

deepakdynamite 3-Jul-15 6:23am View

I am not able to get desired output.. What I get is

Project name , State and count..

deepakdynamite 18-Jun-15 0:34am View

I used "," (Entire ",") as column delimiter and it works fine for now but there may be other consequences with other columns...

deepakdynamite 17-Jun-15 6:55am View

Thanks for you your solution. we are using c# code under script task to do this. It takes more time then expected as number of records\rows in file are more than 1 lacs and some times goes more than 1 million.

deepakdynamite 1-Jun-15 0:28am View

Thanks :)

deepakdynamite 1-Jun-15 0:26am View

It's periodically... I guess daily or weekly

deepakdynamite 3-Apr-15 4:55am View

We have around 30 clients... and we got more than 10 records... I can't give you exact number but Yes I know that it would be more than 10 and can got beyond 50.

deepakdynamite 31-Mar-15 5:21am View

thanks John, I havn't got your point completely.. Can you please elaborate ?

deepakdynamite 26-Feb-15 23:15pm View

Thanks alot ...

deepakdynamite 26-Feb-15 5:27am View

Thanks. It would be great if you can share how you got these statistical figures ??

deepakdynamite 26-Feb-15 0:47am View

Ahaaa !!! Thanks for your precious answer...

deepakdynamite 25-Feb-15 7:41am View

Its very easy to understand... Just type database normalization on Google and you will more than 1000 links with examples

deepakdynamite 25-Feb-15 7:24am View

Is it solved? if no then please write you complete query in question

deepakdynamite 11-Feb-15 23:01pm View

Right!!!!
Enjoy :)

deepakdynamite 10-Feb-15 22:34pm View

For Eg: ISNULL(mname,FName)
In this case if Fname is also null and you want to check it, you have to code like this:

ISNULL(mname,ISNULL(FName,'Deepak'))

Where as if you are using Coalesce, you can directly write as
COALESCE(MNAME,FNAME,'Deepak'). You can provide n number of columns.

There is one more point for which you need to execute following code and check the difference.

DECLARE @NAME varchar(3) = null

SELECT ISNULL(@Name,'Deepak')
Select COALESCE(@Name,'Deepak')

deepakdynamite 10-Feb-15 6:56am View

using COALESCE(mname, '') is better than IsNull.

deepakdynamite 28-Jan-15 6:12am View

Please check Answer which is accepted as Solution. Its a method that will come cost of Performance. And Somewhere I think my answer won't effect performance till that extend. And it's never late to do right things... That's the reason I posted my answer

deepakdynamite 28-Jan-15 5:47am View

Best of Luck !!!!

deepakdynamite 28-Jan-15 5:47am View

Deleted

Best of Luck !!!!

deepakdynamite 28-Jan-15 0:27am View

If you are developing it.. How would anyone know what you gonna use as back end... what kind of information you are storing... what's the logic you have implemented... Answer lies with you. Just sit and think for a while with a cup of tea.

deepakdynamite 27-Jan-15 6:07am View

Varchar(MAX) will work... Send your query here

deepakdynamite 27-Jan-15 6:03am View

Can you explain your requirements ??? When you don't know number of columns and names of columns, then how will you perform sorting on column???

deepakdynamite 26-Jan-15 7:28am View

Why don't you add this directly in GetProviderReport ??

deepakdynamite 22-Jan-15 23:11pm View

Can you describe bit more about your problem ???

deepakdynamite 22-Jan-15 4:58am View

Or Write Select top 1 in subquery

deepakdynamite 22-Jan-15 3:27am View

So you mean to say Certifications are of no use ???? and if this discussion is Off-Topic then why do we have "Certification" tag in "Tags" ?

deepakdynamite 22-Jan-15 3:27am View

Thanks for your suggestion. I am learning it to gain knowledge... Otherwise I would have asked for dumps rather than book :)

deepakdynamite 22-Jan-15 2:38am View

Deleted

So you mean to say Certifications are of no use ???? and if this discussion is Off-Topic then why do we have "Certification" tag in "Tags" ?

deepakdynamite 22-Jan-15 2:35am View

Thanks, I can do that at home... Anything which I can read in office as Video buffering is restricted in office.

deepakdynamite 22-Jan-15 2:00am View

Thanks alot

deepakdynamite 21-Jan-15 23:17pm View

Use HTML 5 FILE API... But make sure about browser version you are using.

http://html5demos.com/drag-anything

Or use jquery:

http://www.dropzonejs.com/

deepakdynamite 21-Jan-15 2:33am View

Can you post entire code starting from your update panel tag ?

deepakdynamite 19-Jan-15 3:31am View

use UpdatePanel.Refresh();

deepakdynamite 19-Jan-15 3:29am View

No it's not possible....

deepakdynamite 19-Jan-15 3:29am View

Deleted

No it's not possible....

deepakdynamite 19-Jan-15 3:21am View

Yes Exactly !!!!!
But Run SSIS PAckage to add macro using C# Code

deepakdynamite 16-Jan-15 7:05am View

use Inner join...

deepakdynamite 12-Jan-15 7:52am View

:D :D Can't stop laughing

deepakdynamite 11-Jan-15 23:40pm View

Depends on many factors... like Cost, Requirement and users as well

deepakdynamite 11-Jan-15 23:22pm View

use it like

Exists ( Select top 1 1 from account a ......)

Try this out :)

still I would suggest to use joins because if you look at SQL engine... It will fire inner query (query that resides inside Exists) each time.. where as Joins will be handled diffently...

deepakdynamite 9-Jan-15 7:27am View

@status is name of cursor... and this comparison won't work

deepakdynamite 9-Jan-15 7:26am View

You won't find it ... you need to add configuration... which will be converted into XML file after deployment. Please go through link provided and atlast yout will see XML file... where you can change values

deepakdynamite 9-Jan-15 7:17am View

This will be a performance hit...

deepakdynamite 9-Jan-15 7:08am View

Please elaborate with an example....

deepakdynamite 9-Jan-15 7:06am View

Why do you want to create it when its already there in windows ??? Any special purpose ?

deepakdynamite 5-Jan-15 8:00am View

More Info

deepakdynamite 4-Jan-15 23:51pm View

Probably error is coming in following code:

string model = aaa[i].Substring(0, 5); // LICT
string length = aaa[i].Substring(5, 4);
string style = aaa[i].Substring(9, 4);
string mat = aaa[i].Substring(13, 2);
string llength = aaa[i].Substring(15, 3);
string instru = aaa[i].Substring(18, 1);

For eg lets take one line of code : string instru = aaa[i].Substring(18, 1);
It looks like you are assuming that there would be some data on starting from 18th index but what aaa[i]'s length is less than 18

deepakdynamite 4-Jan-15 23:46pm View

IF @status!='normal'
Is this code correct in your procedure ???

Are you referring to Status field of your select statement or Cursor ???

Also please write code for

--log the data into another table

Probable we can solve your problem using CTE or Subqueries...

deepakdynamite 4-Jan-15 23:43pm View

Can you write down your complete query as well ??? Also in below condition what would be the value of txt6.text

else if (col1=txt1.text &&col2=txt2.text &&col3=txt3 && col4=txt4.text &&col5=txt5.text && col6="")

deepakdynamite 4-Jan-15 23:07pm View

Read through node.js and SIGNALR

deepakdynamite 4-Jan-15 23:07pm View

Can you show sample data format you are looking for ?

deepakdynamite 4-Jan-15 23:03pm View

Can you post your Trigger code over here with brief description... ????

deepakdynamite 1-Jan-15 23:57pm View

Well if you are using .net 3.5 then you will find crystal reports in .net itself... If you are using higer version then I would prefer to go with SSIS.

deepakdynamite 26-Dec-14 6:50am View

There are many ways to generate offline ID's which will not be repeated in nature... like yyyymmddhhmmss.

deepakdynamite 26-Dec-14 6:30am View

Use Threading.... and Divide your information into logical groups ... for eg:
Employee details can be divided into Personal Details, Contact information, Qualifications etc.

Write different function to insert each of this information and call it in using async thread call in c#....

deepakdynamite 26-Dec-14 6:28am View

There must be combinations of some columns which must be unique in nature and values in those columns can be used to check if record is already inserted in database or not....

deepakdynamite 26-Dec-14 6:16am View

I think you forgot to mention your problem in Question.

deepakdynamite 26-Dec-14 6:09am View

SSRS and Crystal reports are best.

deepakdynamite 26-Dec-14 5:49am View

Please elaborate your question...

deepakdynamite 30-Jan-14 23:32pm View

Hi Marc,

My server and client both belong to close network i.e. If code is executed on server, Server will have access to all shared printers same as client. My application won't be available on world wide web. we are developing it for an organization where employees will use this application.

deepakdynamite 30-Jan-14 7:17am View

Thanks for response.
First thing, I will not fetch list of Printers.. as per requirement I will hard code name of shared printers in Dropdown.

I won't be using window.print() as i know we cannot manipulate anything in that control through application. Instead I want c# code which actually prints document. And atlast i want to print a web page but requirement is to intergrate Window.print functionality within Web application i.e. setting number of copies

deepakdynamite 11-Oct-13 5:13am View

Its a procedure which is used to send Email. and that cannot be called from function

deepakdynamite 20-Aug-13 6:43am View

You won't be able to alter your procedure because of insufficient rights and that is what you are facing right now. Better to work on getting alter rights on Database

deepakdynamite 16-Aug-13 22:57pm View

Thanks for your comment... Can this be done with WCF as well ?

deepakdynamite 4-Jul-13 3:23am View

Thanks alot for your efforts but I am working with asp.net i.e Web application whereas this looks like windows application. Right ?

deepakdynamite 5-Jun-13 0:05am View

Thanks Aarti... You saved my hours... Thanks Alot

deepakdynamite 13-May-13 3:02am View

Any idea if this can be done in single statement ?

deepakdynamite 1-Apr-13 9:26am View

Thanks for your response. I used same thing but it this case "Microsoft.Office.Interop.Excel", we must have Office installed on server which is again a problem for me.

deepakdynamite 29-Mar-13 9:09am View

Thanks Alot.... Your Question itself solved my problem..

The reason of failure was as under :

I was connected through remote machine and server didn't have excel file on path. Conclusion is path provided should be of server file directory

deepakdynamite 29-Mar-13 4:11am View

sql server is installed on another server. and i am connected using management studio.
My machine is 34 bit OS

deepakdynamite 22-Mar-13 10:07am View

Thanks alot for such a wonderful justification

deepakdynamite 5-Feb-13 3:31am View

yes Declaration is made first and then update query is written

deepakdynamite 30-Jan-13 8:38am View

Thanks for your Help. For your information, I am using this under one procedure so i guess execution of whole procedure lies under one transaction. And all variable declarations are done on top of Procedure and after that data is inserted into it and then updated.

Any other that can help ?

deepakdynamite 24-Dec-12 1:51am View

I don't see any question

deepakdynamite 19-Dec-12 7:46am View

Deleted

This won't work when i will have data like 1:3 and 0:13

deepakdynamite 18-Dec-12 6:43am View

Please elaborate your question.

deepakdynamite 18-Dec-12 6:40am View

Yes that can be done but shape is some like [\] square divided by back slash... your suggestion won't work in this case

deepakdynamite 9-Nov-12 4:02am View

Please send exact error message

deepakdynamite 5-Nov-12 23:52pm View

Well!!! Looking at your code.. I will say you are using Session without any reason on 3rd line. And further it looks like a mess. Please elaborate your question

deepakdynamite 5-Oct-12 0:42am View

Try with casting your variable with .toString() for Eg. st1.Tostring()

deepakdynamite 22-Aug-12 6:02am View

Appreciated !!! any other alternative ? as i don't know the limit

deepakdynamite 27-Jul-12 7:42am View

Deleted

Thanks :)

http://dbperf.wordpress.com/tag/mysql-data-transfer-through-ssis/

deepakdynamite 14-Jul-12 2:36am View

Thanks for your response but i want to convert Pdf to word and link redirects to conversion of Word to PDf and 2nd link doesn't have any solution

deepakdynamite 14-Jul-12 2:17am View

Which algorithm is are using for encoding and decoding ?

deepakdynamite 8-Jun-12 6:13am View

I copied file from server to my machine and opened up with correct data and formatting. Even i opened it up on server as well

deepakdynamite 28-Apr-12 1:24am View

Thanks for your help but this is a workaround for what i want to do. I directly want to convert context of div tag into PDF.

deepakdynamite 30-Jan-12 23:46pm View

its in client requirement and i have to implement this.. Question is how to do this not why. i know its a bad practice but still i have to implement this...

deepakdynamite 29-Nov-11 1:44am View

Installer was created before 5 months and was tested on Windows XP, Windows server 2003, Windows 7, Windows 2008 r2 and was tested numerous times. Even its working fine in market.Numerous clients have installer it and is working completlz fine. and i am aware of pre-requisites. I dont know how it happened in recently created installer

deepakdynamite 29-Nov-11 1:23am View

Yes that right that its just a pre-requisite. but my confusion is "How this installer was working fine till now and how suddently this came into picture even though i havent changed any thing in installer except of latest release of my code"

deepakdynamite 28-Nov-11 8:54am View

Nice one

deepakdynamite 25-Nov-11 5:27am View

This will work. :)

deepakdynamite 23-Nov-11 0:16am View

Yes finally I kept
<uc2:Categories ID="Categories1" runat="server" height="100%"/> into a div and resized it using jquery.

deepakdynamite 21-Nov-11 1:48am View

yes it will

deepakdynamite 21-Nov-11 1:47am View

Which Company's hardware you are using for this ?

deepakdynamite 18-Nov-11 1:41am View

nice one

deepakdynamite 18-Nov-11 1:39am View

Hello,

That is what i am saying that you have to create an installer and when installation starts you need to create a custom action which is noting but a win application which will do all the things you said in Question. And but obviouly you need to write code in custom action to do all things. Another alternative is use "Advanced Installer (advancedinstaller.com)" tool. This will do all the things in minutes if you know how to use it

deepakdynamite 18-Nov-11 0:02am View

Is it a Web application or Windows application ?

deepakdynamite 17-Nov-11 1:33am View

Fire my query on your query. Inshort use your query as result and write my query on it.

Like "Select t.abc from (Select .... from ... ) as t"

deepakdynamite 16-Nov-11 7:32am View

Thanks for responding. I agree with you till some extent. If i consider this as solution then question is how it is working on other PC having same OS and same IE version ? I am trying to solve this from almost last 1 month but still no luck

deepakdynamite 16-Nov-11 5:09am View

Welcome :)

deepakdynamite 16-Nov-11 5:04am View

This will tell you how to call custom action on installation then you have to create custom action so that it will ask for password

deepakdynamite 16-Nov-11 4:29am View

I am also using this. But trust me its not 100% reliable

deepakdynamite 15-Nov-11 8:30am View

Nice one

deepakdynamite 14-Nov-11 0:29am View

What do you want to update ? Is it fieldname or table name ?

deepakdynamite 12-Nov-11 3:02am View

Nice one

deepakdynamite 11-Nov-11 5:52am View

Deleted

http://www.aspose.com/community/forums/thread/341597.aspx

deepakdynamite 5-Nov-11 3:50am View

Please refer to this link:

http://www.codeproject.com/KB/database/sql_in_csharp.aspx

deepakdynamite 5-Nov-11 0:15am View

Then make it simple.... Either you delete the current record and create a new record with new ID and same data as deleted record.... or try to directly update it ..

deepakdynamite 3-Nov-11 2:18am View

Dude I want to embedded Audio files in pdf using c# not by javascript. I am not coding in Javascript or something else.

Comments by deepakdynamite (Top 109 by date)