|
Good morning evrybody
i'm wondring if someone can help me and show me how to configure the command objet of ADO.net and its requete to insert image into my database.
mydatabase (pictures) has one column "picture" with image type of sql server 2005.
thank you
my mail : dalidali184@yahoo.fr
DAli
|
|
|
|
|
Google for one of the million or so examples of this. All you have to type into Google is "vb.net sql server 2005 store image".
|
|
|
|
|
Could I get a Function Address in a Remote Process?
And how could I do?
|
|
|
|
|
You don't. The address would be meaningless on any machine other than the one the function is actually running on. So the question because, why would you even need it?
|
|
|
|
|
Now I have to use a API to do something.
It need a address of function, which in the third process.
|
|
|
|
|
Billypon wrote: It need a address of function, which in the third process.
Which won't do you any good because an address cannot be called on a remote machine. You can only give an API function an address on the LOCAL machine to call. You cannot give it an address on a remote machine. There's simply no way to represent that.
Now, you have to have a proxy running on the machines. On the local machine, the address you give the API function will be a delegate on the local machine in a proxy. This proxy marshals the call to a remote component that calls the real method on the remote. The API function won't know anything about the remote machine.
|
|
|
|
|
No!
It means both of the two process are run in the local machine which i say
|
|
|
|
|
It STILL won't do you any good because each process runs in it's own address space! Think of it this way. Each process thinks it's the only one running under Windows and has access to up to 2 GB's of RAM. The address you get for the function doesn't apply because it sits in a different address space.
|
|
|
|
|
i just wanna ask again, about what i posted last night... I am making a module for data entry of grades. But before that, i need first to search for the subjects before entering the grades of the students.
In clicking the search button, it should search a particular subject, then the datagrid should display all the students who enrolled in that subject that i will going to search.
I made a three database in access: 1. database of the students, 2. database of the different subjects. and
3. database of the students and the subjects they enroll.
How can I connect those three database to each other. The display of the datagrid should change if i search another subject. But i can't do it.
I use the OleDbDataAdapter. In the data adapter configuration wizard, will i choose those 3 database in the query builder so that it will be connected? Is this correct???
|
|
|
|
|
Uhhh, any particular reason why these are three seperate databases instead of just one database with 3 tables and a couple of relationships?
|
|
|
|
|
Because i am making a computerized grading system. But before that, i should first make a data entry of grades of each student enrolled in every subject they had enrolled.
So I made a separate database of the file maintenance of the all the students who enrolled. Then another database for all the subject offer in this semester with each corresponding proffesor in each subject. Then another database for the subjects that each of the students take.
In my module, i will going to search any subject offer, then the datagrid should display all the students who enroll in that subject. The display of the datagrid should also change if i will going to search another subject.
How can i make a query for that??? And how can i connect those database??? Is my module correct???
|
|
|
|
|
Rharzkie wrote: Is my module correct???
Nope. To simplify this, you actually have three tables in a single database. Doing it in seperate databases uneccessarily complicates your database.
|
|
|
|
|
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)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
