hi thanks for your rep. so how can use datareder to get data from table any examples? waiting for your kind rep.

ok it's done now there is inbult function for this in crystal report ToWord()

from the forum guidelines: 6. Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you. 8. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job. :| Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Not this way. First Execute Comm = New SqlClient.SqlCommand("InsertNewPlot", LetsGo.AndGetConnection) Comm.CommandType = CommandType.StoredProcedure Comm.Parameters.Add("@Village", SqlDbType.NVarChar).Value = ComboBox1.SelectedItem.ToString Comm.Parameters.Add("@District", SqlDbType.NVarChar).Value = ComboBox2.SelectedItem.ToString to Insert Plot where InsertNewPlot is the first SP to insert plot then something like this Dim iPlotID as integer For I As Integer = 0 To AddName.Count Comm = New SqlClient.SqlCommand("InsertNewCustomerDetails", LetsGo.AndGetConnection) Comm.CommandType = CommandType.StoredProcedure Comm.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = AddName(I) Comm.Parameters.Add("@PlotId", SqlDbType.NVarChar).Value = iPlotID Dim da As SqlDataAdapter = New SqlDataAdapter(Comm) da.Fill(ds) iPlotID = ds.Tables(0).Rows(0)("PLOTID") Next

Let me try to rephrase this for you using sentence structure: "I am working with a windows app with sql database and vb. I have created 4 tables: singlecustomer jointcustomer address plotdetails I have created relationships with all 4 tables: singlecustomer related to plotdetails and address jointcustomer related to plotdetails and address I have created the database diagram and it shows all of the relationships. When I drag and drop a sql adapter to configure it, the database relationships don't look right in the query builder. In query builder when I add tables the first time, it shows a relationship. When I cancel it and add tables a second time in a different order, it shows a different relationship" Now, that's what your question looks like with proper sentence structure...however, it still doesn't make a lot of sense.

hello sir yes it's done now thanks for your kind help thanks again

hello sir thanks for your prompt response currently i have one small assignment to create web project with one page so it should display author table from pubs database into datagrid thats all so what i have done drag and drop sql data adapter on the web page and went through wizard to complite but at the end of wizard it shows generated error for update, delete and cancle so i dont know what to do with this and when i try to run the project it shows loging error but if i right click on sql data adapter and select priview data it shows all the data waiting for your kind help have a nice time

Mark Nischalke wrote: Explain Might be if somebody initializes it with "" .. or using some existing variable which is having value as character... (Not in this code ;) ):rose: Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution. My Latest Articles-->** Microsoft Bing MAP using Javascript CLR objects in SQL Server 2005 Uncommon C# Keywords/xml>

riced wrote: Then you don't have to do anything if more images are added or some removed. Good point. I really should practice VB.Net more, if I want to play over here. :) Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

I will not ask a third time. Add to the context menu for which app? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Visdta Home Premium has some known issues for VS Installation. But anyway, you can use the following link and I hope it helps you: http://blogs.iis.net/brian-murphy-booth/archive/2007/03/09/how-to-setup-asp-net-v1-1-visual-studio-net-2003-projects-on-iis7-vista.aspx Either you love IT or leave IT...

yes sure.. 2morrow . Just signed off.. Enjoy Christmas !!! cheers :beer:, Abhijit

Hello sir Thanks for your rep. so it means all the HTML I have to store in database for each page, but the main thing is that in question it says "content management system should be built to allow for the editing of the content of this page." so when user want to edit it what user going to see HTML or web page on screen? i am confuse with this that what if user dont know html or any thing to do with programming how user is going to edit it ? I think i am going to much deep in it but this exe. could be far more easier but I am not getting there and I have allready created one page (home page) and it's looks very nice but it's not doing any thing untill I make it usable, and I forgot to add remaining pare of question which is as bellow :confused::confused::confused: No tier-pages need producing, only the home page. The client log-on box needs to be actual form elements, but needn’t do anything when submitted. waiting for your kind rep. have a nice day

hello sir thanks for your rep. i have tried that but still it's not working here is the code i am using and i am not sure that is it the right <body background="homepage_notext.bmp" > <div height="1158" width="777"> </div> </body> but under height and width it shows red line waiting for your kind rep.

Hello sir thanks for your rep. yes it works but still i am not getting all the lists for widgets like it shows box of widgets but it's not showing what's in there in each box so I have tried this and it shows how many widgets are there in each box but not name of that widgets i am getting there but still need to do some thing little to get there so this is what i have done For J As Integer = 0 To colBoxesOfWidgets.Count - 1 ListBox1.Items.Add(DirectCast(colBoxesOfWidgets(J), _ BoxOfWidgets).colWidgets.Add(J)) Next so i think i need to get class widget to get name and length for each widgets but i am lost :confused: waiting for your kind rep. have a nice day

You're welcome :)

Hi Phil first of all thank you very much for your mail and rep. yes it works fine and now it's shows "empty database" if database is empty else it shows inkID so great i didn't know about the has rows but now i learn thanks again :) have a nice day :rose:

Hello sir First of all thanks for your kind rep. as you said i have tried but still same problem so i dont know what to do now this is what i have done Private Sub LoadImages() dsImage.Clear() Try conImage = GetDBConnection() daImage.Fill(dsImage.Images) Me.ImagesBindingSource.ResetCurrentItem() Catch ex As Exception MsgBox(ex.Message) End Try conImage.Close() conImage.Dispose() Me.ImagesBindingSource.ResetBindings(True) Call PoChng() End Sub and i have also try to put this bold and underline code in several different place but it's not doing any thing :confused: so could you please tell me what to do now waiting for your kind rep. have a nice day