write some part of execution plan

1)Select cost 0%
2)Merge Join(inner join) cost 0%
3)Nested Loop(inner join) cost 11%
4)Sort 1%
5)Hash Match(inner join) 13%
6)Clustered index publicity cost...

thanks sknake,

I am attaching the execution plan

Hi evrybody,

My sql SP takes around two to three minutes which is quite long time to execute
the SP select data from three tables publicity(29000 row) publicitysubject(29000 row) & lookuptable(50...

Hey

One new problem is occured i am able to generate HTML page with text or string but in html there is a Cover image which ia also different for each book & stored in sql database as image type
...

Thanks GeekByChoiCe

Your Reply is really helpful

Here is the solution

private void CreateHTML(int SelectedRow)
{

Thanks GeekByChoiCe for ur reply

i am newbie to programming what did you mean by adding html in resources please explain how to do



thanks again bro

My problem is that i want to develop a project in which there is front end (window form) in vb .net in which there are diffrent field for book entry name,author,image etc. all this data is stored in...

i had developed window project on visual studio 2005 & made serup & installed om xp it worked perfectly fine but when i try to install it on window server 2008 it will nor work. please help.

Hi

i am using .net 2.0 & a window application which is connected to sql server
there is checkbox in the application. i want to bind the checkbox with database field which is bit type 1 or 0...

thanks for ur help
but let me explain the situation more
in my window form there is three tabPages. the first tab page is for filter in which we provide condition to filter data on diff. conditions...

Hi

i am using .net 2.0 & a window application which is connected to sql server
there is checkbox in the application. i want to bind the checkbox with database field which is bit type 1 or 0...

Thanks RamyMahrous it is working now

thanks alot

Hi till now i am used window application in which there is no problem in connection using following code


Dim cnn As SqlConnection
cnn = New SqlConnection("data...

Good u can share at

http://www.codeproject.com

Some more links

Best Practices in .NET

http://www.dotnetspider.com/tutorials/BestPractices.aspx

Rules for Better Window Application
...

Hi this is useful links for new .NET developer or any body who is new to .NeT

These link contain most of FAQ of window form

http://www.syncfusion.com/faq/windowsforms/default.aspx

...

I have solved the problem & if any body need that so iam posting code below

I declare a global variable tab & assign its value tab=1 on form's load event & on tabcontrol selectedindexchanged event...

thanks for reply i am understanding ur suggetion. But my project is completed in all respect & this is the shortcoming tell by my boss not allow user to click tabcontrol(its not my idea) I know what...

I only entered in the programming job since last 2 month. I am working in Publighing house. they have no IT department Or IT staff. They want to develop their data entry program in vb.net & SQL...

I am able to show specific tab page on button click. but i did not want user to change tabpage by clicking on tabcontrol but by clicking button only


I tried one solution but it is not full proof...

Hi all i am a newbie in development
I have a window application in vb.net in VS 2003 there is a tabcontrol which has three tab pages.
i want that user was not able to change tabpages by clicking...