|
How to save changes to a particular record using Binding Source, TableAdapter and DataSet ?
I have a form which I have bound to a table using a Binding Source, TableAdapter and a Dataset. I need when I move through the records, the changes which I have made should be updated in the database.
I am new in VB.Net 2005 and your suggestions will help me a lot.
Sekhar.
Sekhar 
|
|
|
|
|
I just answered this yesterday -> click[^]
|
|
|
|
|
Please I need help. I am using VB6 and crystal report 9. I have a program where I did not store my images in the database. I only store the path of the image in the database. My problem now is displaying the image dynamically in crystal report during run time.
-- modified at 2:58 Friday 12th October, 2007
|
|
|
|
|
hello
i m using vb.net 2005 and crystal report 9 the problem is that when i pass the parameters to my report the crystal report viewer that is on another does not show the report my code is below
Dim reportdocument As New ReportDocument
Dim strRptPath As String
strRptPath = "d:\Attendance System\Attendance Reports\TodayAbsRpt.rpt"
reportdocument.Load(strRptPath)
Dim todayval As Long
Dim paramfields As New ParameterFields
Dim paramfield As New ParameterField
Dim paramdisval As New ParameterDiscreteValue
todayval = Me.DTPsdate.Text.Substring(6, 4) & Mid(Me.DTPsdate.Text, 4, 2) & Me.DTPsdate.Text.Substring(0, 2)
paramfield.ParameterFieldName = "DpttNm"
paramdisval.Value = Me.cmbDptt.Text
paramfield.CurrentValues.Add(paramdisval)
paramfields.Add(paramfield)
paramfield = New ParameterField
paramfield.ParameterFieldName = "pDate"
paramdisval.Value = todayval
paramfield.CurrentValues.Add(paramdisval)
paramfields.Add(paramfield)
Dim frm As New FrmRpt(reportdocument)
frm.CrystalReportViewer1.ParameterFieldInfo = paramfields
frm.CrystalReportViewer1.ReportSource = reportdocument
frm.Show()
please help me out ,ur help is highly appreciated
|
|
|
|
|
search in msdn with the title= "Setting Parameters Manually in Code" and "Creating a Report with Parameters"
may be you get some one good for you
-- modified at 8:04 Friday 12th October, 2007
|
|
|
|
|
I have created an application in vb .NET using ODBC (MS-Access and SQL Server2000). this is a MDA Application. when i am running this Exe thru the network it is showing following error-
[Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]
Error in SQL Connection
I Want to solve this problem thru code in 'VB .NET'. I do not want to do this manually as we do from "Control Panel->adminstrative tool->MS .NET Framework2.0 Configuration" How can i solve this problem. Please help me.
my mail ID is kkb_mda@yahoo.co.in
Thanks and Regards
Kishore
-- modified at 2:23 Friday 12th October, 2007
Kishore
-- modified at 3:10 Saturday 13th October, 2007
|
|
|
|
|
Hi kkb_2001
if you are not Running your exe from the Network or Network share, thats what you will get.your .NET should have permission running in that context. Here is link to help you read about .NET Access Security.
http://www.codeproject.com/dotnet/UB_CAS_NET.asp[^]
hope it helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi
yet again me...
Thanks all for your patience.
I'm building a wav builder software for my firm. I have completed the program at 95% and only one bug remains.
The program has variable sampleRate, bits/second,frequency,duration.
My algorithm for building the sine wave works, but calculating how many samples would it take for a provided duration (ms) is buggy...
It goes something like this
dblFrequency = Frequency
dblWaveTime = 1 / dblFrequency
dblSampleTime = 1 / CDbl(lngSampleRate)
dblDataSlice = (2 * PI) / (dblWaveTime / dblSampleTime)
If intBits = 8 Then
lngLimit = 127
lngSamples = CDbl(lngSampleRate) * duration / 1000
Else
lngLimit = 32767
lngSamples =cdbl(lngsamplerate) * duration * 2 / 1000 'because it is 16 bit, 2 bytes is written, thus * 2
End If
This algorithm creates problems...
I have an array() as byte, in which the results are filled... They are calculated as math.sine...
But the problem is here in the upper code...
so, for example the duration is 323 ms, i need to calculate how many samples does it take for the duration.
Any help is greatly appreciated.
Thank you!
|
|
|
|
|
The calculation is really simple, you just multiply the time with the number of samples per time unit. Example:
time = 0.323 ' duration in seconds<br />
frequency = 44100 ' samples per second (44.1 kHz)<br />
bytes = 2 ' sample size (16 bit mono)<br />
<br />
samples = frequency * time<br />
size = samples * bytes
(That is pseudo code, of course. You have to apply appropriate type conversions.)
---
single minded; short sighted; long gone;
|
|
|
|
|
I have a situation where i need to create a Crystalreport with a subreport.
I don't know is possible on vb.net.?
the situation is :
Have 3 tables : Students Finance Score
Each student have sone registration on table1 and some registration on table2.
(the tables are related)
I want to display on the report :
Name of student1
All the registration for this student on Finance
All the registration for this student on Score
-------
Name of Student2
All the registration for this student on Finance
All the registration for this student on Score
----------
....... for all the students
i think to do this with report-subreport?
Any idea ?
|
|
|
|
|
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Public SubReport As ReportDocument
SubReport = New ReportDocument
SubReport = Report.OpenSubreport(SubReportName)
SubReport.SetDataSource(datasource)
Now use this SubReport object to solve the problem
|
|
|
|
|
I have swann webcam Mac IP cam network camera.......its connected to the RJ-45 connector....I want to capture images after every 10 sec. from this and save it in to sql database..............can you guys help me out
you can have a look abt my cam on this link
http://www.swann.com.au/webfiles/download/445SW-C-IPC_Manual_ENG_v2.pdf
Thanx in advance
|
|
|
|
|
You will use DirectShow to connect to the camera. Plenty of examples on the web, and even articles on this site.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
It' an IP webcam. It doesn't look like there's any possibility to connect it to the machine directly.
|
|
|
|
|
You're first move should be to find out if the manufacturer has an SDK for the webcam. If so, then it'll come with documentation on using the SDK to talk to the cam and get images.
If there isn't one, you've options are very limited. You're either going to have to setup the cam to automatically post the image to an FTP server or you've going to have to download a webpage from the camera that's got the image in it, parse the page and get the URL of the image, then download that image using the HttpWebRequest/Response classes.
|
|
|
|
|
Try Video.ocx, it may solve your problem, do a search on google write just video.ocx and you will find the website.
Be a part of solution, rather then be a part of problem
|
|
|
|
|
Video.OCX only works with Video For Windows compatible cameras. Unless he's got VFW drivers for an IP-based camera (highly doubtful!), it won't work with this camera.
|
|
|
|
|
I was following the example in code project
"Calling a DLL C++ function from a VC++ application" posted by Hans Dietrich
I am using Visual Studio 2005 for this example. It works fine.
Now I want the same application to run on different machines which DOES NOT have Visual Studio 2005 installed on them.
I copied all the dll files and vb application's .EXE files on all machine2 but its not working. It gives me an error saying the dll's are not synchronized properly.
What exactly is the procedure of making an application run independently on all machines.
Can someone PLEASE HELP ME in solving this problem.
Thanks
Jyothi
|
|
|
|
|
jyothim wrote: It gives me an error saying the dll's are not synchronized properly.
This isn't the error message. It would help if you posted the EXACT error being shown.
Because you're using a VB.NET app, any machine running this app MUST have the .NET Framework 2.0 installed on it.
|
|
|
|
|
Thank you very much it solved my problem
Jyothi
|
|
|
|
|
hi everyone.
I am quite new to vb.net 2005 and I have been trying to connect my database programmatically to my sql server database. I have moved from one error to the next and I have followed the steps highlighted in the msdn walk through on crystal reports. Every time I run my code, I am getting an error message that states that the load report event has failed. and the object reference has not been set to an instance of the object.
I have tried this several times and I don't know what to do. If anyone can help me I would be most greatful. The code I have been trying to use is as follows.
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Public Class Form1
Private Sub ConfigureCrystalReports()
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo()
myConnectionInfo.DatabaseName = "Northwind"
myConnectionInfo.UserID = "user"
myConnectionInfo.Password = "bob123"
myConnectionInfo.ServerName = "chiko-shumba"
Dim reportPath As String = Application.StartupPath & "\" & "NorthwindCustomers.rpt"
myCrystalReportViewer.ReportSource = reportPath
SetDBLogonForReport(myConnectionInfo)
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
ConfigureCrystalReports()
End Sub
Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo)
Dim myTableLogOnInfos As TableLogOnInfos = myCrystalReportViewer.LogOnInfo
For Each myTableLogOnInfo As TableLogOnInfo In myTableLogOnInfos
myTableLogOnInfo.ConnectionInfo = myConnectionInfo
Next
End Sub
Private Sub myCrystalReportViewer_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles myCrystalReportViewer.Load
End Sub
End Class
|
|
|
|
|
Hi there,
I just want to ask if is it possible to put calculations in a datagridview? in such a way that the column2 = column1 * 30%...
if it is possible, can you help on how to work on it?
I'm realy new in vb.net eh..
thanks in advance!
ange(",)8
|
|
|
|
|
Nope. You cannot put expressions in the DGV. Putting them into a strongly typed dataset/datatable on the other hand, yes. Then you bind the DGV to that dataset/datatable.
|
|
|
|
|
Thank you sir for replying..
the DGV is already binded with the dataset/datatable.
What shall I do now?
|
|
|
|
|
You don't have a choice. You either rework your strongly typed dataset or you add support code for going through each record in the table and doing the calculation and putting the result in a column in the table.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
