|
Which formula you are trying to add?
Ejaz
|
|
|
|
|
i have a table and i have a column called area and another called height i want 2 * them together in a column i got called volume ?
|
|
|
|
|
At a guess you are coming from an access environment where you can have calculated or virtual columns.
These do not exist in SQL Server. You have 2 options
1 do the calculation in the select query when you retrieve the data
2 create a view of the table with the calculation in the view.
|
|
|
|
|
hi
I am writing a word document and it is my first time i need to know
1- how can i draw a vertical line from top to bottom on every page.
also after drawing line i have to write on both sides of it ( Sr. No appears on left side of line and text appears on right side)
2- how can i specify the heading information for every page ( i need to show an image and some text on every page as heading).
Salman Sheikh
|
|
|
|
|
Hello
I am using reporting tool in which master db's dateformat is 'yyyy-MM-dd'. In the programming level after getting the date from the user as 'dd-mm-yyyy' I need to change to the "yyyy-MM-dd".
I will appreciate if u can do it yesterday!
Ahamed Azeem
Software Programmer
Saudi Postal Technologies – Riyadh
|
|
|
|
|
which language and version do u use?
phatkin
|
|
|
|
|
vb.net 2005
Ahamed Azeem
Software Programmer
Saudi Postal Technologies – Riyadh
|
|
|
|
|
If you are updating the record through SQL command then use format(date,"yyyy-mm-dd").
Hope this will help.
Ejaz
|
|
|
|
|
if your program is in visual basic .net then following statement may solve your problem
date.ParseExact(DateStringFromUser,"dd/mm/yy" ,new system.Globalization.DateTimeFormatInfo).ToString("mm/dd/yyyy")
Salman Sheikh
|
|
|
|
|
Hi sheikh,
Thank you for your response.
While I debug the application, it is showing "String was not recognized as a
valid DateTime"
Please advise me
Ahamed Azeem
Software Programmer
Saudi Postal Technologies – Riyadh
|
|
|
|
|
date.ParseExact(DateStringFromUser,"dd/mm/yy" ,new system.Globalization.DateTimeFormatInfo).ToString("mm/dd/yyyy")
here date from user is the string user enters and the next argument is the format of the string entered by user
i.e if user enters
"03/08/2007" then the format is "dd/MM/yyyy"
and the argument in ToString method is the format you require to use
Salman Sheikh
|
|
|
|
|
Hello Friends,
I want to write a prg., which will have a Rich Text Box. User can enter & format text. Can be saved in a RFT file. I know all that stuff. My point is, user will open a rtf file, select customers to send the letter to. I got to merge the letter and the addressed of the customers and the user can print Page wise. Can I save it in a new rtf or doc file? I want similar output as we do in Word.
Is this kind of application possible! If I let this application make from some one, how much should it cost (Just to make my work easy, want to know)?
I want to make it, how do I make it. Any guidlines, reference, help is highly appreciative.
Thanks
Terry
|
|
|
|
|
Hi
In my application i am downloading mail from server for that purpose
i am using indy socket liabery and pop3 protocol.while downloading mail
if the mail body contain html tag (if it contain html table) then while
saving mail body to database it saves mail with all html code like
<doc type:="" w3...=""><htm> like that it uses all html tag i want to
save only text not the tag how can i do this.Currently i am doing as
If (xMsg.MessageParts(x).ContentType = "text/html") Then<br />
body = CType(xMsg.MessageParts.Items(x), Indy.Sockets.Text).Body.GetText()<br />
End if
if the mail contain html table and i checked with
type=xMsg.MessageParts(x).ContentType then is type variable
shows text/plain format and if i checked with
Dim s As String = xMsg.ContentType then it shows correct
"text/html" format. I i want to avoid html tag from body then how can i
do this.
Thanks.
Rahul
|
|
|
|
|
Hi,
I have been receiving this error to a program im developing and I cant figure out what it is.
Can anyone help me its urgent.
I have added a new sheet on an xlt file and add it to the code which is:
Public Sub Survey_1(ByVal report As String)
Dim stored_func() As String = { _
"[Production charts - Survey_1 - Export prices]", _
"[Production charts - Survey_1 - Export Price increase]", _
"[Production charts - Survey_1 - Export Price decrease]", _ <-- this one
"[Production charts - Survey_1 - Price increase by product]", _
"[Production charts - Survey_1 - Price increase by location]", _
"[Production charts - Survey_1 - Capacity]", _
"[Production charts - Survey_1 - Capacity expansion]"}
CreateReport(stored_func, report)
End Sub
Im getting the error on this side of the code:
Dim db1 As New DbTier
db1.DbSource = GetSetting("Server", "Data Source", "CSR", "")
db1.OpenConnection()
Dim i As Integer
Dim wb As Workbook = mvarExcel.Workbooks.Open(mvarTemplate)
Dim ws As Worksheet
Dim rg As Excel.Range
Dim drd As OleDb.OleDbDataReader
For i = LBound(stored_func) To UBound(stored_func)
ws = wb.Worksheets(i + 1)
rg = ws.Range("DATA" & i + 1) < ---- bug here
rg.ClearContents()
If i = 0 Then ws.Range("csr_title").Value = mvarCsrDetails(CsrIndex.Title)
drd = GetDataReader(db1, stored_func(i), mvarCsrDetails(CsrIndex.ID))
Dim r As Integer = 0
Dim c As Integer
While (drd.Read())
r += 1
For c = 0 To drd.FieldCount - 1
rg.Cells(r, c + 1) = drd(c)
RaiseEvent OnAfterEachProcess(stored_func(i))
Next c
End While
Call AdjustRange(ws, "COL1S" & i + 1, False)
Call AdjustRange(ws, "COL2S" & i + 1, True)
drd.Close()
Next
drd = Nothing
db1.CloseConnection()
db1 = Nothing
RaiseEvent OnAfterProcessDone("Saving " & report & ".")
Dim fleOutput As String = mvarOutputPath & UCase(mvarCsrDetails(CsrIndex.Title)) & " " & report & ".xls"
If File.Exists(fleOutput) Then File.Delete(fleOutput)
wb.SaveAs(fleOutput)
wb.Close(False)
the error says:
system.runtime.interopservices.COMException' occured in server2.2.exe
additional information: Exception from HRESULT: 0x800A03EC
|
|
|
|
|
dienadel wrote: its urgent
That is not nice around here. It'll just piss people off.
As far as the error is concerned, Exception from HRESULT: 0x800A03EC, those are notorious for not being very descriptive. Check that you don't have old processes running from previous debug sessions, and also make sure the parameters are called correctly. MSDN can be of more help...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hello,
anybody with help on how to get the ip addresses or names of computers on an LAN.I tried using the directory services but doesnt work and the netview thing also kinda doesnt work, anybody with help?Thanks
phatkin
|
|
|
|
|
You can use the winshock control.
btn_click
Text1.Text = Winsock1.LocalIP
end sub
|
|
|
|
|
thanks nepalpawn am trying that out but i hope it supports other computers too on the network thanks soo much
am happy
phatkin
|
|
|
|
|
is the winsock a com control that i will add?
phatkin
|
|
|
|
|
Yes that is com control(.ocx).
|
|
|
|
|
hello frnd,
what u use vb.Net or VB 6.0 ???
regards,
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
i use vb.net 2005.Thanks
phatkin
|
|
|
|
|
it's easy then
just call shell("ipconfig" > "C:\ip.txt")
it will create the text file at location C:\ip.txt
it contains the ip and other things too.
read it and get information
and to get the computer name
just use
my.computer.name
regards,
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Thanks to ya'all.Thanks so much.
this is a real post
am happpy
phatkin
|
|
|
|
|
the code doesnt work it says "file not found"
any help?is it some text formatting tn i need to do?
phatkin
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
