Create a damn HTML table, as I have already said! :rolleyes: What are you asking? How to create an html table? How to put it in the body of an email? Or is it that you just want someone to do the work for you? only two letters away from being an asset

For what it's worth here is some code I use. Dim MyMessage As New MailMessage MyMessage.To = "" MyMessage.From = "" MyMessage.Subject = "" MyMessage.BodyFormat = MailFormat.Text MyMessage.Body = "Attached is a file" ''// ADD ATTACHMENT If File.Exists(Rpt) Then MyMessage.Attachments.Add(New System.Web.Mail.MailAttachment(Rpt)) Dim Smtp As SmtpMail Smtp.SmtpServer = "" Smtp.Send(MyMessage) Hope that is helpful. Jason W.

What is the line of code that the compiler baulks at? Do you want to know more? Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

Dim myScript As String = "window.open('datafilter.aspx<pre>?Parameter=MyParameter')</pre> </code> You can pass them as a normal page. </x-turndown>

i think you have to make a dataview. *HyVong*

I'm not positive but I would think you would have to create a Custom Validator[^] to do something like that.

In your case, that will surely work. Just to let you know, you can enable or disable validators based on your logic in code.

That's the way to do it. Since there is no such this as a control array in .NET, you have to iterate through the Page's Controls collection, comparing the type of each control to the one your looking for, then you can set a variable to that control, get its Name property and check if its the one you want. The only problem I have with what you wrote is that the type is completely dependent on the string. A better way would be something like this: if( c.GetType() == typeof(DropDownList) ) This way, if the namespace string changes in future versions of the .NET Framework, you won't have to go back and rewrite your code with the new name. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

What do you mean by DataSet in a textbox? Am confused. If you want to see one item in the dataset, you will need to pass it to the function you are calling so that, the function returns just the item you requested for a specific row or a concatenated string etc. Actually, you are talking about an entire off-line database to be shown in a Textbox. Is it logical? Or if you are really mean to put DataSet in a textbox, I can see it as DataSet.GetXML() which gives entire dataset including schema in your textbox. Bhaskara

Thanks that worked. Santana

sivilian wrote: I do not think there is a way to put textboxes into an array Yes, there is. The controls collection is essentially an array of Control objects which is the base class of all the controls, including TextBox. So, it is not that much different to having an array of TextBoxes. I'm a C# developer, so I can't show you exactly in VB.NET, so I'll give you a C# example that assumes there are 6 TextBoxes: TextBox[] myTextBoxes = new TextBox[6]; int i = 0; foreach(Control ctrl in container.Controls) { TextBox tb = ctrl as TextBox; if (tb == null) continue; myTextBoxes[i] = tb; i++; } At the end of the myTextBoxes contains the 6 text boxes, which can be looped over as normal. "You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar The Second EuroCPian Event will be in Brussels on the 4th of September Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

What number value? Are your talking about some kind of serial number representing a date? Like how many seconds from a base date, like Jan 1, 1970? RageInTheMachine9532

I'm not sure why you want to pull the entire months of tables data. I suspect that the data set will take some time to fill. You could try a paramtized query. Only fill the dataset withthe requested row. The difference is you would add "Where RecID = ? ". Your form would then have a text box for the user to enter an ID and a button to retrieve the data. Is this something that you could use?

mariscal wrote: datedap.InsertCommand.CommandText = "Insert into datetbl (startdate,enddate) values (" & startdate & "," & enddate & ")" Stringing together an SQL statement like this is a bad idea. Instead, use a stored procedure that can validate what your putting into the table. This will also give you the ability to use SQLParameter objects that can properly convert the date to an SQL compatible DBDate and back again. RageInTheMachine9532