how do i get crystal report to work on machine that doesn't have vb.net installed on it. I use the crystal report that comes with vb.net net, but it only works on my machine that has vb.net installed on it. can anyone help me or tell me what must i do to get it running on other machine with are without installation, ie. if i was to run just the exe file on that machine. what must i do, please help.
Nab
Man you are harsh...I am sorry for saying that..but could you help me, i need help..thats why i asked. any suggestions on how to get it done?
Nab
Hey, I am working on this project that requires me to save a picture/jpeg to a folder from a scanner. I have download many twain software to help in the process, but with these software i am unable to complied my program and use it else where because these twain dll are not free, they all needs registration code..i am using vintasoft twain. here are my questions? 1. does anyone know where i could get twain dll library that allows me to save a jpeg image from a scanner and at the same time its free so i can complied it in my project? 2.Is there a better or easier way of doing this: that is saving an image from a scanner to a file? 3. Does anyone have the vintasoft activation code i could use? I have found a vb.net sample code that doesn't use any twain dll, but the problem is that it was done in C# and not vb. If any one know how to convert it to vb, please send your email address so i can send it to you to be converted. I have tried online conversion programs..but didn't convert it properly. Please help.. thanks.
Nab
thanks, would you suggest that i write a utility program to do so? one that copies all table to the backup database...and at the same time be able to access the information from server level or standalone at anytime..
Nab
Hey everyone, I am working on this project, mostly database driven. this is what it is about:- The user interface is install on three computer in different location while the database is kept on another computer in a seperate location, which means all three computers has to connected to this sql server to enter and retrive data. That means if the server goes down.. neither of these location will be able to continue there work. What i am thinking about now, is to install sql server on all three machine so that data is stored at each location and at the end of each day all the data from the three location would be uploaded or Synchronized to the main database. Problem.. how do i get all three database to Synchronize with the main database? Do i have to hard code this to happen or is there a feature that does this in sql 2000... your help would be highly appreciated... thanks.
Nab
Hey everyone, I am working on this project, mostly database driven. this is what it is about:- The user interface is install on three computer in different location while the database is kept on another computer in a seperate location, which means all three computers has to connected to this sql server to enter and retrive data. That means if the server goes down.. neither of these location will be able to continue there work. What i am thinking about now, is to install sql server on all three machine so that data is stored at each location and at the end of each day all the data from the three location would be uploaded or Synchronized to the main database. Problem.. how do i get all three database to Synchronize with the main database? Do i have to hard code this to happen or is there a feature that does this in sql 2000... your help would be highly appreciated... thanks.
Nab
just use a datetimepicker
Nab
Ok..this is the exact query i am using.... Function testUpdate(ByVal appId As Integer, ByVal fname As String, ByVal lname As String) As Integer Dim connectionString As String = "server='(local)'; trusted_connection=true; database='TESTDBfhms'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim queryString As String = "UPDATE [R_Application] SET [Fname]=@Fname, [Lname]=@Lname WHERE ([R_Application]."& _ "[AppId] = @AppId)" Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.CommandText = queryString dbCommand.Connection = dbConnection Dim dbParam_appId As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_appId.ParameterName = "@AppId" dbParam_appId.Value = appId dbParam_appId.DbType = System.Data.DbType.Int32 dbCommand.Parameters.Add(dbParam_appId) Dim dbParam_fname As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_fname.ParameterName = "@Fname" dbParam_fname.Value = fname dbParam_fname.DbType = System.Data.DbType.[String] dbCommand.Parameters.Add(dbParam_fname) Dim dbParam_lname As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_lname.ParameterName = "@Lname" dbParam_lname.Value = lname dbParam_lname.DbType = System.Data.DbType.[String] dbCommand.Parameters.Add(dbParam_lname) Dim rowsAffected As Integer = 0 dbConnection.Open Try rowsAffected = dbCommand.ExecuteNonQuery Finally dbConnection.Close End Try Return rowsAffected End Function
Nab
yes same query..what wrong with it?... just do one and send it to me..let me try it
Nab
first you need to import this mail class Imports System.Web.Mail Dim mail As New MailMessage mail.To = anyone@someDomain mail.From = user@yourDomain mail.Subject = "message subject comes here" mail.Body = "body of the message.. could be from a textbox" SmtpMail.SmtpServer = "MailServerName" 'your real server name goes here SmtpMail.Send(mail) ' this section is what sends the mail... this is perfectly fine....i have use it.. the from email account..must exist on the exchange mail server account.. so if you have an account on that server.. use it for the from section or just create a temp account to be used for this purpose.. hope this helps..
Nab
if you need those / for date purposes..its easier to declare a date object to collect the information and asign the input to that variable.. after the variable or object gets the input as string..u format it to represent what u want... example: dim TD as Date TD = textbox1.text msgbox(TD.tostring("dd/MM/yyyy") i just use a message box to display the result..but the same applies were ever u use it..
Nab
its generated by webmatrix.. but its just not updating a field that is already in the table which has a string value...don't know why.. Dim queryString As String = "UPDATE [R_Application] SET [Fname]=@Fname, [Mname]=@Mname, [Lname]=@Lname WHERE (" & _ "[R_Application].[AppId] = @AppId)" if the field was null then it works..but if some value exist..it doesn't update...
Nab
use the key down event handler as below Private Sub txtTendered_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txtTendered.KeyDown If e.KeyCode = Keys.delete Then do something here elseif e.keycode = keys.enter then do something else end if end sub hope this helps
Nab
can anyone help me to write a sample update query to update some text and interger fields in my database..i am using sql server 2000... please send me a sample one that works.. so i can test it and modify it to use in my project...thanks.. having problem writing mine..
Nab
its and update query.. and it giving me problem updating.. example.. in my project.. say i have three fields in the table..firstname, lastname, and middle name.. first name and lastname is monditary so information will always be in the table for first and last name.. and middle name might not have informaiton... i use webmatrix to create my query and then place it in a class in my project then called it where it is needed.. problem: when i try to run an update.. if i try to update a record.. say John Brown is the person's name..if i try to change it to say..mary brown..its not updating..but if i try to change it to John James Brown..note this time, i only updated the middle name because before it didn't have one.. in this case it updates.. so i am wondering whats up with my query.. could u write me a simple update query and let me see if i can use it to test my project..becuase the generated ones not helping me.. thanks..
Nab
hey everyone, i am writing an application in vb.net i use web matrix to generate my querys, when i run an update query and use it it only update information that is not yet in the database that is.. if the field is empty then it will update it...but if there is information in the field..how do i up date it using a sql update statement
Nab
can anyone tell me how to refresh crystal report...after designing it and run it..i realise that if i make any changes to it ...it doesn't show on it the next time i run it..it remains the same.. how do i make the update show?
Nab
I am having a problem designing my report. My report is suppose to print a list of cards from a table base on a batch code supply to the system. ie. in the table, there is say. 6 columns ...batchcode... permitcode.. firstname...lastname...issuedDate...expiredDate when i run the program, i want the user to supply the batch code to list the applicants that comes with that batch code.... at the top of the query sheet i want the batch code at the top..since everyone would come under that code.. So basically, i need help in doing dynamic crystal reporting.. how do i set this up so when i run the program i can print a list of all applicants that have that batch code... can any send me a tutorial explaining how i go about accomplishing this...need help... thanks in advance...
Nab
if i could i would...but this is a custom in house system for doing company business...which meams only data specify by the company i can use..but thanks anyway..
Nab
Ok thanks..i am going to try it now.. will let you know if i got through...on more thing..have u seen my post on Twain problem...I need help with finding a Twain software which is free or any other suggestions as to how to capture images from a scanner or a digital camera and save that picture to a file as well as a database..
Nab