First I tried getting a SQL query into an array, and then mail it. Made the data incomprehendable. So someone told me to use CSS to build a table format, filling it with the array. A LOT of hard work (since I had to learn css all the way from "what is a css".
Then I was told "Array? why use array when DATATABLES are soooo much easier"
So here we go again. "What is a datatable, and how does it work"
<body>
<%
Dim EMailFrom As String= "?"
Dim EMailTo As String="?"
Dim EMailSubject As String="?"
Dim EMailBody As String="?"
[Code]...
I have a problem, when I am trying to use DataTable.Select to get column values.. Actually it is working file in C# which I have converted using Converters.I am using .NET 1.1 / VS 2003...
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> DataRow[] drs = dtResults.Select("ISSD" + i + " =" + issd+" AND BiPad ="+bipa</div>
input string was not in correct format..
Line 175: While i <= 8
Line 176:
Line 177: Dim drs As DataRow() = dtResults.[Select]("ISSD" + i + " =" + issd + " AND BiPad=" + bipad)
[code]....
When I am trying to use DataTable.Select to get column values.. Actually it is working file in C# which I have converted using Converters.[code]...
View 1 RepliesI guess I just cant seem understand this correctly
Dim StatusClosed As String = Form11.Closed_Code.Text ' usually = S or ClosedSale or Closed Sale
Dim SubjId As String = Form10.add_Num_txt.Text ' usually = StreetName or Street Name or SN[code]....
If SubjId is StreetNumber or SN its ok , if its Street Number with the space I get error
If I place a ' around {3} in my afilter line then it works if the SubjId is Street Number but not StreetNumber or SN
var queryString = string.Format("filename={0}&filestream={1}&append={2)", fileName, Convert.ToBase64String(b, 0, bytesRead).ToString(), 1);
above line of code giving error 'Input string was not in a correct format.'
I have a function that is getting passed a String and a DataRow.The String is a custom formatter. The idea is to do this
String.Format(passed_in_String, DataRow("ColumnINeed"))
The reason this is being done is at this point we have no idea what the column contains.However, if the formatter is "{0:MM/dd/yyyy}" and the DataRow("ColumnINeed") is an integer containing 42, String.Format is returning: MM/dd/yyyy In this situation I need it to throw an exception instead of returning nonsense.Is there anyway to make String.Format throw an exception if the object does not match what the format string is expecting?
In member register page, I added email address validation but it only check the email address format, such as .com, .net, .org.If user inputs fake account such as aaabbb01010@gmail.com, how to verify it and return an error?
View 2 RepliesAn unhandled exception of type 'System.InvalidOperationException' occurred in system.windows.forms.dllerror in line: dbAdp.Update(dbDset) in btnSave_Click, (elseif editflag = true) blockdescription: Update unable to find TableMapping['Table'] or DataTable 'Table'I was also wondering if I could simply use the ExecuteNonQuery for the delete statement, but since I've placed my data in a datarow, I'm not sure if i can actually use it. Any thoughts on this? Btw, this is my first time using a datarow, and I've recently been studying how to use ADO.net.
dr = dbDset.Tables(0).Rows(CurIndex)
dr.Delete()
dbAdp.Update(dbDset.Tables("addresses"))
[code].....
So I need a format string to pass to String.Format that would "move" the decimal point.I can't perform any math operations before doing the String.Format, so it has to work right off the bat.Basically I'm emulating a formatting string from a proprietary server. In it if I say:
"MR2"
for the value:
12345
The result is:
123.45
I'm close with this, but it's not spot on:
String.Format("{0:#0.##}", 12345)
an extra, but not necessary... there is also MR2Z, which moves the decimal 2 left, but if the value is 0 "" is returned.
however, i'm copying this directly from the book in its example format and still getting an error.
FormatException was unhandled
Input String was not in correct format
Public Class Form1
[Code].....
I have a mail format with me which looks like this Date (today)
[Code]...
I want to save all my emails into a PDF format. The file must contains which look similar to the Outlook Reading Pane into Outlook 2010.
Is there a programming way to to this (cause hundreds of emails) ?
I need to take a string formatted like '010711' (DDMMYY) and put it into format '01-Jul-11'. Ive thought about doing something like string.toArray and then having some conditionals that format from there but am looking for an easier way.
View 5 Repliescurrently i m working on some exercise program. i need to send a mail,here is my code
mail.IsBodyHtml = True
For Each Item In ListView1.Items
Dim Value As String
[Code].....
Value is the item in the listviewbox i tried plenty of methods,but the output is like tis [ProductsUnit Price Quantity Discount Total dwa 22 22 5 459.8 ]
i pulling tis data from a listviewbox.. anyone know how to make it attach the full listviewbox?
I am developing a application in which i use to connect to any mail server and get the unread mails from that,right now i am listing the them in listview and when i click any item in list it displays the message body in browser control.My problem is that the displayed msg is in stream format,i wanted to display in correct format like in yahoo,gmail,hotmail.
View 1 RepliesI am using VB.Net 2008 Express on Windows XP, and am trying to format some text in an e-mail body.
The code that I want to use is:
Dim intDaysLate As Integer
intDaysLate = 120
With objExpediteMailItem
[code]....
This code correctly formats the normal text string, �Days Late.�, but does not replace intDaysLate with 120. is it not possible for HTML to interpret the variable?If it is not, how do I format the variable in the same way I have formatted the text string?
I have a TextBox, and I want to force the user to type an email format in this field like ([URL]) ? I don't want to use FilteredTextBoxExtender or the RegularExpressionValidator. I want to do it manualy.
View 3 RepliesI ave a contact form (VS 2010 / VB / .net4), and when the client fills out the form, I get an email -- which I like, but ....
For instance, here's an e-mail I got:
[code]...
But I'm expecting a lot of more emails than I had originally anticipated. Does anybody have any suggestions on what I can do? Is it possible to upload the responses into an Excel file, or something?
I want to format the Timespan to have format like this 49 hr 34 mn 20 sec
I used the String format below :
String.Format("{0:00}:{1:00}:{2:00}", theTimeSpan.TotalHours, theTimeSpan.Minutes, theTimeSpan.Seconds)
It formats the Timespan to this format 49:34:20. How can I add hr mn sec to the String.Format above? or there's another easy way?
I have a large data.DataTable and some formatting rules to apply.For example, the LASTNAME column has a value of "Jones" but my formatting rule requires it be 10 characters padded with spaces on the right and uppercase only. Like: "JONES "My initial thought is to loop through each row and generate a string. But, I wonder if I could accomplish this more efficiently with a DataView, LINQ or something else.
View 1 RepliesActually I want to use a DateTime column and only display the time in 12 hour format.[code]...
View 2 Repliesi am trying to insert date in dd/mm/yy format in sql table from a textbox but everytime the default date 01/01/00 goes in table.
View 19 Replies[Code]...
what sould i fill in the part after ---addressof--- i dont now what to fill after
Friends I want to try my hands on encryption/decryption. What I want is to export the dataTable content in encrypted format to a file. And when needed import back.
I am able to do the export import as XML file, but how to encrypt the data? Regards Pranabjyoti (If a post answers your query mark the post as answer)
I have a datatable that is queried from SQL Server database, and it has a numeric column and I want to format it to "###,##0" format for readability reason. I tried:[code].....
View 2 RepliesI have an SQL Database which has some end dates. I have used this little statement to make sure that the dates come out of the database in the right format
Execute("Set dateformat dmy")
And I use the below statement to enter the data in to a datatable and, with the above command, when I go to look at the data in datatable visualiser the dates seem to be in the correct dd/MM/yyyy format
"SELECT CID, expdate FROM Traineecerts WHERE iscurrent = 1"
Now when i try d1 = row("expdate") the format changes to the american MM/dd/yyyy format
Please note d1 refers to a variable with the type of date. Even if I format the dates after using d1 = format(row("expdate"),"dd/MM/yyyy") they don't change unless I make d1 a string. Is this normal?
I am using String.Format("{0:C2}", -1234)to format numbers.is always formats the amount to a positive number, while I want it to become $*-*1234
View 4 RepliesFirst off a great piece of code [URL] you saved me soooo much time. I am a somewhat newbee to VB2010 and was wondering how would i go about setting lets say setting column(4) to a date format so that i can get it to sort in the correct order.
View 8 RepliesHow can I call my TextBox ID = "txtFromAddress" data to a table that I am trying to send? Right now it is just showing the text '& txtFromAddress' on the table on the email that I send.
[Code]...