|
yup, three tables in a single database...how can i make those tables connected in my project?
How can i make a query for that if i will going to search another subjects? The students who enroll in that subject should view in the database...
|
|
|
|
|
What you're asking is simple SQL. I suggest picking up a book on it and going through it.
You don't "connect" the tables. You use JOIN clauses in your SQL statements, with properly keyed tables, to get the data out of multiple, related, tables.
There's a bunch of different ways of doing it, but exactly how is determined by your table structure.
|
|
|
|
|
after i finished my application and saved it then i set new project setup (for deployment ) then i found that every form that i have made didn't open and the following msg appeared :
One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes.
what should i have to do now
plz help??
|
|
|
|
|
Hi,
when you add an event wire through the keyboard, Visual will propose
default method name, which you can accept with TAB key; if you do, it also
creates the event handler containing a single throw statement. You are then
supposed to replace the throw by your actual code; if you forget to do so,
Designer may not like it.
BTW: if you never noticed, try it on a new project and form. Inside the
constructor of the form, type "this.Load+=" now wait a while, accept with
TAB, wait a while, accept with TAB. The Load handler skeleton will be inserted.
Remedy: close the project in Visual. Open the source file with a simple
editor (Notepad) and disable those throw statements. Reopen project in Visual.
|
|
|
|
|
plz explain more or show me any article or upload project and send it to me cz i need it badly
|
|
|
|
|
Hi,
I will not write an article on this.
Read my previous reply again, use Notepad/Wordpad and search your file(s)
for methods such as (name may vary):
void Form1_GotFocus(object sender, EventArgs e) {
throw new Exception("The method or operation is not implemented.");
}
|
|
|
|
|
There is no article on this. From what it sounds like, you really have to go back to your development machine and test this app some more before you try and deploy it. That message means you either didn't supply code for a method you were supposed to implement, or you're calling code that isn't complete either.
|
|
|
|
|
The 'errors listed below' are what we need to see. does your app run OK ? If so, then the problem is that you have some code that is being run by the designer and is blowing up, but works fine in the app when running by itself. This is a serious flaw in VS2005, and the way around it is to move your code around so that the designer can run it, or to add checks in your code to tell if it's being run in the designer and change what code runs, accordingly.
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 )
|
|
|
|
|
How could I get the Instance Handle from another Process ID?
Maybe the Process has no any windows, so I can't use the GetWindowLong API.
And I know nothing about the Module Name of the third Process, so I can't use the GetModuleHandle API,too.
So,how could I get the Instance Handle from another Process ID?Or how could I get the Module Name of the third Process,that I can use the GetModuleHandle API for it?
|
|
|
|
|
Please don't cross post. You have already asked this in the Visual C++ forum.
|
|
|
|
|
Because I want to get some way with it either in VB or in VC
|
|
|
|
|
There's not some magic VB only API. It's going to be the same in both cases. It is bad form to post in multiple locations, so please stop it.
|
|
|
|
|
i create two datasource object from data source configuration wizard which have name itemSummary(contain table master) & dsTeamList(contains table individual).
i also create two report named MasterInventoryReport.rdlc (which use itemSummary_master as datasource) and GroupPersonalInfo.rdlc(which use dsTeamList_individual as datasource).
i used reportViewer for display report.
at design time if i select MasterInventoryReport.rdlc report as a reportsource for Reportviewer then it automatically create masterBindingSource as bindingsource
and if i select GroupPersonalInfo.rdlc report as a reportsource for Reportviewer then it automatically create IndividualBindingSource as binding source.
i use following code to generate report.
Imports System.Data.OleDb<br />
Imports Microsoft.Reporting.WinForms<br />
<br />
Public Class frmReportViewer<br />
Dim ReportSource As String = Reflection.Assembly.GetExecutingAssembly().GetName().Name.ToString()<br />
<br />
Public Sub MasterInventoryReport(ByVal team As String)<br />
Dim str As String<br />
Dim dsItemSummary As New DataSet<br />
Dim oleadapter As OleDbDataAdapter<br />
<br />
ReportViewer1.LocalReport.ReportEmbeddedResource = ReportSource & ".MasterInventoryReport.rdlc"<br />
str = "select * from master where team='" & team & "'"<br />
GlobalModule.myconnectionopen()<br />
oleadapter = New OleDbDataAdapter(str, GlobalModule.conn)<br />
oleadapter.Fill(dsItemSummary, "master")<br />
GlobalModule.myconnectionclose()<br />
<br />
masterBindingSource.DataSource = dsItemSummary<br />
masterBindingSource.DataMember = "master"<br />
Me.ReportViewer1.RefreshReport()<br />
Me.Show()<br />
<br />
End Sub<br />
<br />
<br />
Public Sub GroupPersonalInfo(ByVal team As String)<br />
Dim str As String<br />
Dim DsTeamList As New DataSet<br />
Dim oleadapter As OleDbDataAdapter<br />
<br />
ReportViewer1.LocalReport.ReportEmbeddedResource = ReportSource & ".GroupPersonalInfo.rdlc"<br />
str = "select * from Individual where team='" & team & "'"<br />
GlobalModule.myconnectionopen()<br />
oleadapter = New OleDbDataAdapter(str, GlobalModule.conn)<br />
oleadapter.Fill(DsTeamList, "individual")<br />
GlobalModule.myconnectionclose()<br />
<br />
individualBindingSource.DataSource = DsTeamList<br />
individualBindingSource.DataMember = "individual"<br />
Me.ReportViewer1.RefreshReport()<br />
Me.Show()<br />
End Sub<br />
<br />
<br />
End Class<br />
above code is works well if we print single report at a time.
my problem is that i can not generate both report at a time.
Mean at design time if i set reportsource of Reportviewer to MasterInventoryReport.rdlc then this report is generated properly(i use code specified in MasterInventoryReport procedure) but other report(GroupPersonalInfo.rdlc) give error "A data source instance has not been supplied for the data source dsTeamlist_individual (i use code specified in GroupPersonalInfo procedure)
and at design time if i set reportsource of reportviewer to GroupPersonalinfo.rdlc then this report is generated properly but other report (MasterInventoryReport.rdlc )give error "A data source instance has not been supplied for the data source itemsummary_master
i don't know where i m wrong
any help will be appriciated
thanks in advance
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Rupesh,
Have you got this working?
Paul
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi to all,
In one function of my classFile I return the Datas through return function to my VB code. I can get the Datasource for DataGrid in VB code, but i cant get it for TextBox. I tried DataBindings also. I have to fill my WebForm TextBoxes with those got Dats. Can anyone help me out ? How to fill TextBox for an datasource.. ?
|
|
|
|
|
Hi,
I am Using Ax media Player in my window application in .net 2003,
I have added reference , now i want to play a video file,
how to go abt it.... i mean i any one send me the code as how to play a video file using Ax media player .........
Thanks in advance
byeeeeeeeeeeeeeee
with thanks and regards,
kaushik pulpa
|
|
|
|
|
What is the Ax media player ? Is it the windows media player control ? Have you tried to google for articles on it ?
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 )
|
|
|
|
|
hello everybody...
i am beginner in this field...
i need some help please...
I've done a project which use crystal report to print a report...
my problem:
- in a form there is a textbox which i make it as a color options..
- when user choose a color the text box will change according what he/she chosen..
- the color will be save as one of the data in a database (SQL Server 2000)..
- but i save it as a code (there is a column called colorcode in my database)..
reason: i don't know how to save color in database
- then i use crystal report to print the form which has a color
- but in the column "colorcode", its only show the code but not color
example: -8355585 (blue color)
- please help me with any idea, how can i print a color instead of a code..
thank you very much for your help
|
|
|
|
|
It doesn't know what that number means. You'll have to save the string name of the color in the database too and add that column to your report if you want to do this.
|
|
|
|
|
thank you very much for your reply Dave..
but i'm very sorry, i do not understand...
how can the report will be printed with color if i add string type of column?
won't the report will show a text rather than the color code or a color itself?
will u explain a little bit..please..
and if i am wrong please correct me..
thanks..
|
|
|
|
|
zed83 wrote: how can the report will be printed with color if i add string type of column?
No, you have to store the color value twice. Once as the value you currently have and once as the name of the color. Then you can add either or both of those columns to the report.
|
|
|
|
|
hello,
Is it possible to create an windows taskbar item with for example a button on it.
Or a way to inject a button in the start menu for example under the run button.
thanks!
|
|
|
|
|
Possibly, but this would probably require writing an Explorer Shell Extension to do it. This is not going to be easy, and help with something like this is going to be sparse to be sure.
Or, I've misunderstood what you're talking about. What do you mean by a "Windows Media Player taskbar item"???
-- modified at 20:48 Wednesday 11th July, 2007
|
|
|
|
|
you need to look into something called a deskband, but almost all of the source code and help is in C#.
Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"
|
|
|
|
|
Hi,
I've got some code that allows me to click a button to browse to a zip file, and populate a DataGridView with all of the file names contained within the zip.
What I now want to do is go a stage further, and allow the user to drag a zip file into the DataGridView, and perform the same routine.
For reference, the functionality to perform the unzip is provided via DotNetZipLib.zip
The code that I've been trying to get to work is:
Imports ionic.utils.zip<br />
<br />
Private Sub DataGridView1_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView1.DragDrop<br />
<br />
Dim strFilePathAndName As String<br />
<br />
strFilePathAndName = DirectCast(e.Data.GetData(Windows.Forms.DataFormats.FileDrop), String)<br />
<br />
Dim zip As ZipFile<br />
zip = ZipFile.Read(strFilePathAndName)<br />
<br />
Dim tblZipFilesTable As DataTable = New DataTable("CompressedFiles")<br />
Dim ds As DataSet = New DataSet("ZipFile")<br />
<br />
ds.Tables.Add(tblZipFilesTable)<br />
<br />
tblZipFilesTable.Columns.Add("File name", GetType(String))<br />
tblZipFilesTable.Columns.Add("Columns in table", GetType(Integer))<br />
<br />
Dim tblRow As DataRow<br />
<br />
For Each file As ZipEntry In zip<br />
<br />
tblRow = tblZipFilesTable.NewRow<br />
<br />
tblRow.Item("File name") = file.FileName.ToString<br />
<br />
tblZipFilesTable.Rows.Add(tblRow)<br />
<br />
Next<br />
<br />
Me.DataGridView1.DataSource = ds<br />
Me.DataGridView1.DataMember = "CompressedFiles"<br />
<br />
With Me.DataGridView1<br />
<br />
.Columns(0).Width = 210<br />
.Columns(1).Width = 120<br />
<br />
End With<br />
<br />
Me.DataGridView1.Refresh()<br />
<br />
End Sub<br />
<br />
Private Sub DataGridView1_DragEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView1.DragEnter<br />
<br />
If e.Data.GetDataPresent(Windows.Forms.DataFormats.FileDrop) Then<br />
e.Effect = DragDropEffects.Copy<br />
Else<br />
e.Effect = DragDropEffects.None<br />
End If<br />
<br />
End Sub
But it doesn't do anything. When I set a breakpoint within the first few lines of "Sub DataGridView1_DragDrop", I find that it doesn't even go in here.
|
|
|
|