|
What does CSng mean and what does it do?
Ty
|
|
|
|
|
converts to single data type
chatura
|
|
|
|
|
Hi all,
1-I need to use custom paper size using crystal report in vb.net, how can I ?
2-Is there any way to create custom paper size and include it in printer paper size collection using printer properties at windows level ?
Thanks in advance
|
|
|
|
|
The first step is to see if your printer driver can support custom paper size settings - the PrinterSettings.PaperSizes property lists all the paper sizes supported by a printer and if this collection includes a paper size with .Kind = PaperKind.Custom then it can.
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
Hello,
Its supporting for custom kind . please let me know the details. and also let me know how to assign "CrystalObject" (object of .rpt) to "PrintDocument" object. Thanks
|
|
|
|
|
Yes , I found the way to add custom paper size in the printer collection of paper sizes.
Start -> Settings -> Printers and Faxes -> right click in the window -> Server Settings -> Create form ,give width & height and save the form with new name. now you have custom paper size in collection of printer.
Be sure,while creating form that you have selected the required printer driver.
Enjoy the Solution......
|
|
|
|
|
|
Hello
Lately I have a problem when I try to run a project with debugging (shortcut F5). I get the following message, for ANY project:
---------------------------
Microsoft Development Environment
---------------------------
Error while trying to run project: Unable to start debugging.
Unable to start program 'C:\Documents and Settings\urim\My Documents\Visual Studio Projects\WindowsApplication8\WindowsApplication8\bin\WindowsApplication8.exe'.
No such interface supported
If I run without debug (CTRL+F5), it works fine.
What is the problem ? Can anyone please help?
Thanks ahead.
Uri.
|
|
|
|
|
Might I suggest digging into Microsoft's Knowledge Base, here[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
when i try to show a form which is on hide "me.hide" it have error.. i dont want to use the "me.close" casue if i use that whole the system will exit...i dunno y.. any way to show the hide form??
|
|
|
|
|
|
JOY
Hai,
I am working on a student database project in Vb.net. I have established a connection betwen Ms-Access table & my form through DATASET. Now i am able to save & retrive the records.
what i want is to store the photograph of students.
if i am not wrong, we can use imagelist so that the photos can be displayed.but how to connect it from the access table .
My second question is to know how to store & retrive the photos.so that whenever i move to a particular student's record ,his photo should appear.Can u pl help me with an example for a clear understanding
if photos cannot be stored in a databae then what could be an alternative to this. pl exlain briefly if so.
Arun 
|
|
|
|
|
In the past I would usually store the image NAME (ie. in a "Image_PathFileName" field. This way when I run through my recordsets I can retrieve the image by pulling the Image_PathFileName value and plugging it into my code.....
-Kay
|
|
|
|
|
|
You can use as folllowing
1- get the path using Open file dialogue in text box as I taken in txtCompanyLogo.text
2-
Dim arr() As Byte
If Trim(txtCompanyLogo.Text) <> "" Then
FileOpen(1, txtCompanyLogo.Text, OpenMode.Binary, OpenAccess.Read, OpenShare.Shared)
'Resize array so that it can accomodate the file
ReDim arr(FileLen(txtCompanyLogo.Text) - 1)
FileGet(1, arr)
FileClose(1)
'/////// Ds is DataSet & CompanyInfo is TableName & CompanyLogo is Field Name for Binary Data ////////////
ds.Tables("CompanyInfo").Rows(0).Item("CompanyLogo") = arr
End If
Enjoy Solution
|
|
|
|
|
Hello,
I used to display binary image in VB 6.0 using the following code:
<br />
<br />
dim byteImage() as byte<br />
' assuming byteImage() has value display the image using PICTUREBOX object<br />
picturebox1.image.hpal = byteImage<br />
This procedure seems to be not supported by VB.net, anybody has an know/idea on how will I do this in VB6.0?
|
|
|
|
|
I'm sorry about that last line:
This procedure seems to be not supported by VB.net, anybody has an know/idea on how will I do this in VB6.0?
This procedure seems to be not supported by VB.net, anybody has an know/idea on how will I do this in VB.NET?
|
|
|
|
|
check this
http://www.vbdotnetheaven.com/UploadFile/mahesh/BLOBinAdoDotNet04232005065613AM/BLOBinAdoDotNet.aspx?ArticleID=61566715-97c5-47cd-a8d4-d254cb8309cd
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
|
I'm sorry about that last line:<br />
<br />
This procedure seems to be not supported by VB.net, anybody has an know/idea on how will I do this in VB6.0?<br />
<br />
This procedure seems to be not supported by VB.net, anybody has an know/idea on how will I do this in VB.NET?
i thing he searched in vb.net
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
i am getting above error while trying to do following.. i tried hard but dont know what went wrong,
=========
'##############
'check for existance of userID in database
Function CheckUserName(ByVal userID As String) As DataSet
objConn = New SqlConnection(dbPath)
cmd = New SqlCommand("select username from userPersonalDetails where username='" & Replace(txtUserName.Text, "'", "''") & "'", objConn)
Dim dataAdapter As SqlDataAdapter = New SqlDataAdapter
dataAdapter.SelectCommand = cmd
Dim dataSet As DataSet = New DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function
'check for existance of users email address in database
Function CheckEmail(ByVal email As String) As DataSet
objConn = New SqlConnection(dbPath)
cmd = New SqlCommand("select emailaddress from userPersonalDetails where emailaddress='" & Replace(txtEmail.Text, "'", "''") & "'", objConn)
Dim dataAdapter As SqlDataAdapter = New SqlDataAdapter
dataAdapter.SelectCommand = cmd
Dim dataSet As DataSet = New DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
If Page.IsValid Then
Dim userDS As New DataSet
userDS = CheckUserName(txtUserName.Text)
Dim emailDS As New DataSet
emailDS = CheckEmail(txtEmail.Text)
If userDS.Tables(0).Rows.Count = 1 Then
'userid exists so display a message
lblMsg.Text = "That UserID Exists. Please Pick Another"
ElseIf emailDS.Tables(0).Rows.Count = 1 Then
'email address exists so display a message
lblMsg.Text = "Someone has registered with that Email address."
Else
cmd = New SqlCommand("insert into userPersonalDetails values('" & Replace(txtUserName.Text, "'", "''") & _
"','" & Replace(txtPassword.Text, "'", "''") & _
"','" & Replace(txtEmail.Text, "'", "''") & _
"','" & Replace(txtFullName.Text, "'", "''") & _
"','" & Replace(txtMobPhone.Text, "'", "''") & _
"','" & Replace(txtHomePhone.Text, "'", "''") & _
"','" & Replace(txtWorkPhone.Text, "'", "''") & "',0);", objConn)
objConn.Open()
cmd.ExecuteNonQuery()
'Response.Write(cmd.CommandText)
objConn.Close()
end if
end if
end sub
many many thanks in forward
robin
|
|
|
|
|
What line does the error show up on?!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
please disregard this post in my aspx page the label was not created but in my vb it was declared so it was complaining about lblmsg sorry thanks for your help.
|
|
|
|
|
A few suggestions, in no particular order.
1) If you asre getting an exception in code, you have done the right thing by showing us the code, however you have not indicated where, in this code, the exception is being raised.
That said, the good ol' "Object reference not set to an instance of an object" exception is the most cut-and-dry there is. It means that somewhere you have tried to access a property or method of an object without first instantiating the object.
A quick scan shows: objConn.Open() is called, but that object has not (as far as I can tell) been instantiated.
2) You should not be creating your SQL Queries in this way - read about Sql Injection attacks[^] for more info. Also note that using ADO.NET parameters would remove the need to keep calling that Replace(textfield,"'","''") hack.
3) Using separate queries for looking up a username and an email address is unnecessary network overhead. Using a dataset to retrieve just one value is unnecessary local overhead. A better way would be a) Use one query to determine if username OR email exists in the db and simply return a boolean(or single value indicating problem if you require) b) Use the command's ExecuteScalar[^] method to return a single value, rather than a dataset, which should be used when you really do need a disconnected table on the client.
-- modified at 8:36 Tuesday 14th March, 2006
|
|
|
|
|
Hi!
Can you please explain me what do you mean by objConn.open hasn't been instanciated.
on the top of the page i had
'declaring global db connections
Dim query As String
Dim configurationAppSettings As System.Configuration.AppSettingsReader = New System.Configuration.AppSettingsReader
Dim dbPath As String = CType(configurationAppSettings.GetValue("sqlConnection1.ConnectionString", GetType(System.String)), String)
Dim dr As SqlDataReader
Dim objConn As SqlConnection
Dim cmd As SqlCommand
which wasn't there in my code. please correct me if i am wrong in anyway and i really appreciate for giving me valuable suggestions.
thanks once again.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
