|
Guys im having a problem with this statement..
ALTER TABLE tblSample
ADD SampleField nvarchar (30) NOT NULL
CONSTRAINT SampleField PRIMARY KEY
im just trying to set my newly added column and at the same time setting it as a primary key.. but it wont work..
Is there any other way?
or can it set an existing non primary column to a primary one.. if it can then how.. thanks..
|
|
|
|
|
This should work. What error are you getting?
BTW, you should really ask this question in the SQL forum. It has nothing to do with VB.
-- modified at 8:16 Friday 12th October, 2007
Paul Marfleet
|
|
|
|
|
it will not work because in sql u can not add column with Null having a primary key. it will work in access after removing nvarchar->char
-- modified at 4:34 Saturday 13th October, 2007
|
|
|
|
|
I'm not sure why you replied to my message instead of the original poster. Anyway, it's pretty obvious from the query syntax that the database being used is SQL Server not Access.
Paul Marfleet
|
|
|
|
|
|
Or just delete the question... that works too. 
---
single minded; short sighted; long gone;
|
|
|
|
|
What was the deleted question?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi friends..
I have 3 tables in my dataset..I need to bind them to a single data grid.All the tables in the dataset have varying fields..How could i do this..Someone help in this regard as early as possible..
Regards,
Balaguru
|
|
|
|
|
hi
Use joins, and Add relations, if you are going to update the data later. you have to use DAl(Data Access Layer)
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
|
|
|
|
|
hii
In the datagridview ,i am showing the properties of a control like this using datatable
BackColor BorderStyle Enabled Color top left <br />
Color [White] FixedSingle True Color [Black] 355 205 [Font: Name=Microsoft Sans Serif, Size=8.25, Units=3, GdiCharSet=0, GdiVerticalFont=False] 455 225 True False TextBox1
using this code
drTextBox.Item("Name") = ctr.Name<br />
drTextBox.Item("BackColor") = ctr.BackColor.ToString<br />
drTextBox.Item("BorderStyle") = ctr.BorderStyle by setting previously at runtime . at this time it is storing in datatable .now i want to retrieve the same and show in propertygrid
and i am assigning to class .it contains properties get and set of textbox and i am assigning propertygrid.selectedobject = new ctextbox .
when i click on the control it has to show the properties by taking from datatable and assign to ctextbox(get, set) and show it in propertygrid .
I am getting the typecast error. how to typecast these things
i am taking it in a temporary variable and this variable i am assigning to ctextbox property get and set
tBackcolor = Color.FromName(drCurrentRow.Item("BackColor"))
MessageBox.Show(tBackcolor.ToString())
how to solve and show in the propertygrid
DVSriram
|
|
|
|
|
Do NOT email me. Keep everything in the forums. Your lucky I saw the email at all, because I took down my filters for a few hours to diagnose a different problem.
I gave you articles on serializing contorls to an XML file AND how a forms designer is REALLY done before. A lot 'o good that did.
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
