|
|
Noone is going to do your homework for you. If you have difficulties knowing where to begin, I would suggest speaking to your teacher/lecturer/tutor to find out further information.
Give it a go, then if you get stuck with a specific problem in your code, post the code and ask for assistance.
|
|
|
|
|
Hi everyone,
I copy/paste one datagridview from one form to another (different solutions) using two instances of VS 2005.
The target form has the datagridview with all settings, including the DataSet and tableAdapter used by the original form. The datagridview also has all old settings. Everything is fine, it works as expected, with one drawback: every time I make any change in the target form surface, VS tells me that the dataset and the tableadapter are not defined and no longer loads the form in design mode giving errors mention that the dataset and the tableadapter are not defined.
To be able to view the form surface in Design Mode, I have to edit the form.Designer.vb file and replace the references to the dataset and tableadapter as follows to Global:
replace Me.DataSetSyncLog = New MainTabForm.DataSetSyncLog
to Me.DataSetSyncLog = New Global.MainTabForm.DataSetSyncLog
and
replace Me.TAdapter_Log = New MainTabForm.DataSetSyncLogTableAdapters.TAdapter_Log
to Me.TAdapter_Log = New Global.MainTabForm.DataSetSyncLogTableAdapters.TAdapter_Log
Anywhere in the code if I do Me.TAdapter_Log = New MaintabFor.
the Intellisence does not show the table adapter. But it is in the form.
Any ideas on how can I fix it?
Thanks,
Paulo
|
|
|
|
|
I've never tried this, but it sounds like a quirk. Unless the dataset itself (like the .XSD, etc) was copied, how would project 2 know the def. of the dataset, tables, tas, etc?
Probably have to copy over the dataset, which I would argue against. Copying and pasting duplicated code is a bad idea.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Hi Jon,
Thanks for your answer.
Actually the dataset and data source I created in project 2 with the same names as in the project 1 before I copied the datagridview to project 2.
Internally in the project 1 the datagrid was bound to the datasource and it was pasted with all properties set correctly, the columns collection with all settings and etc.
The tableadapter was inserted into the surface of project 2 by VS after I pasted the datagridview, with the same name.
It is strange, ist'n?
Thanks,
Paulo
|
|
|
|
|
I guess if I was going to be really lazy. I'd create a new solution and copy all the source files from project 1 to project 2 (that way nothing is being reduplicated manually or being copied from open instances of VS); personally, this sounds whack. Add in all the existing source files. Change Form1 to whatever you want it to look like. Quick and dirty copied app w/ same functionality your looking for.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
I am developing an application in vb.net2008,Sql Server 2005
But there is a problem while running my application on Customer Machine. It throws some security related issues Access Denied or so on....
And also my application does not run in Windows Vista.
I am changing in my app.manifest file like this ........
<?xml version="1.0" encoding="utf-8" ?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity version="1.0.0.0"
processorArchitecture="X86"
name="Sample"
type="win32" />
<description>Sample Manifest Test Application</description>
<trustInfo xmlns="urn:schemas-microsoft-com:asm.v3">
<security>
<requestedPrivileges>
<!-- <requestedExecutionLevel level="requireAdministrator" /> -->
<requestedExecutionLevel level="asInvoker" uiAccess="false" />
<requestedExecutionLevel level="requireAdministrator" uiAccess="false" />
<!-- <requestedExecutionLevel level="highestAvailable" /> -->
</requestedPrivileges>
</security>
</trustInfo>
</assembly>
So, What can I do for This , Please help me.
Report post as abusive
<div class="ForumSig">Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)</div>
|
|
|
|
|
I am developing an application in vb.net2008,Sql Server 2005
But there is a problem while running my application on Customer Machine. It throws some security related issues Access Denied or so on....
And also my application does not run in Windows Vista.
I am changing in my app.manifest file like this ........
<br />
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestversion="1.0"><br />
<assemblyidentity version="1.0.0.0"><br />
processorArchitecture="X86"<br />
name="Sample"<br />
type="win32" /><br />
<description>Sample Manifest Test Application</description><br />
<trustinfo xmlns="urn:schemas-microsoft-com:asm.v3"><br />
<security><br />
<requestedprivileges><br />
<!-- <requestedExecutionLevel level="requireAdministrator" /> --><br />
<requestedexecutionlevel level="asInvoker" uiaccess="false" /><br />
<requestedexecutionlevel level="requireAdministrator" uiaccess="false" /><br />
<!-- <requestedExecutionLevel level="highestAvailable" /> --><br />
</requestedprivileges><br />
</security><br />
</trustinfo><br />
</assemblyidentity></assembly>
So, What can I do for This , Please help me.
Report post as abusive
Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)
|
|
|
|
|
I am developing an application in vb.net2008,Sql Server 2005
But there is a problem while running my application on Customer Machine. It throws some security related issues Access Denied or so on....
And also my application does not run in Windows Vista.
I am changing in my app.manifest file like this ........
<
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestversion="1.0">
<assemblyidentity version="1.0.0.0">
processorArchitecture="X86"
name="Sample"
type="win32" />
<description>Sample Manifest Test Application</description>
<trustinfo xmlns="urn:schemas-microsoft-com:asm.v3">
<security>
<requestedprivileges>
<!-- <requestedExecutionLevel level="requireAdministrator" /> -->
<requestedexecutionlevel level="asInvoker" uiaccess="false" />
<requestedexecutionlevel level="requireAdministrator" uiaccess="false" />
<!-- <requestedExecutionLevel level="highestAvailable" /> -->
</requestedprivileges>
</security>
</trustinfo>
</assemblyidentity></assembly> >
So, What can I do for This , Please help me.
Report post as abusive
Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)
|
|
|
|
|
I am developing an application in vb.net2008,Sql Server 2005
But there is a problem while running my application on Customer Machine. It throws some security related issues Access Denied or so on....
And also my application does not run in Windows Vista.
I am changing in my app.manifest file like this ........
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestversion="1.0">
<assemblyidentity version="1.0.0.0">
processorArchitecture="X86"
name="Sample"
type="win32" />
<description>Sample Manifest Test Application</description>
<trustinfo xmlns="urn:schemas-microsoft-com:asm.v3">
<security>
<requestedprivileges>
<!-- <requestedExecutionLevel level="requireAdministrator" /> -->
<requestedexecutionlevel level="asInvoker" uiaccess="false" />
<requestedexecutionlevel level="requireAdministrator" uiaccess="false" />
<!-- <requestedExecutionLevel level="highestAvailable" /> -->
</requestedprivileges>
</security>
</trustinfo>
</assemblyidentity></assembly>
So, What can I do for This , Please help me.
Report post as abusive
Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)
|
|
|
|
|
I am developing an application in vb.net2008,Sql Server 2005
But there is a problem while running my application on Customer Machine. It throws some security related issues Access Denied or so on....
And also my application does not run in Windows Vista.
I am changing in my app.manifest file like this ........
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestversion="1.0">
<assemblyidentity version="1.0.0.0">
processorArchitecture="X86"
name="Sample"
type="win32" />
<description>Sample Manifest Test Application
<trustinfo xmlns="urn:schemas-microsoft-com:asm.v3"> <security>
<requestedprivileges>
<requestedexecutionlevel level="asInvoker" uiaccess="false">
<requestedexecutionlevel level="requireAdministrator" uiaccess="false">
So, What can I do for This , Please help me.
Report post as abusive
Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)
|
|
|
|
|
Tool, stop posting 5 times the same crap, it's annoying. And no, you tool.
|
|
|
|
|
pdnet wrote: Report post as abusive
I have already. All of them. Now get lost.
जय हिंद
|
|
|
|
|
I have a list of several people by username and email that I will not help ever. PDNET is right at the top =P
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Where is my name on the list?
जय हिंद
|
|
|
|
|
I guess that only senior devs' make it on the list
I are troll
|
|
|
|
|
Better question would be how do these people become senior devs'?
जय हिंद
|
|
|
|
|
lol, you haven't made the list............but there is always hope.
My personal list (probably shouldn't post it, but wtf):
pdnet
ccdnf
vereshindia
ghumman63
mr.wonderful
I wrote down the member #s as well incase they changed their name (might be hard to tell initially, but their stupidity will probably give them away again).
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Hi all...
I am creating a simple database application program. I used VB.Net (VS2005) as frontend and SQL Server 2005 as backend. Now each time I run insert,delete or update query, it runs fine and shows changed made in application but it does not make permanently changes in database.
Suggest me what should I do to make permanent changes in database.
Thanks.
Gagan
|
|
|
|
|
How are you doing this? Post some code.
Are you updating the database? Unless you do this, you will see the changes in dataset but not in DB.
जय हिंद
|
|
|
|
|
code is :
imports system.data.sqlclient
try
dim str as string="update tblLogin set Uname='" & txtName.text & "',Passwd='" & txtPasswd.text & "'"
dim cmd as new sqlCommand(str,con) 'Con is declared as public sqlConnection
connectToDatabase.Connect() 'It is a method used to open connection if it is closed.
cmd.ExecuteNonQuery()
msgbox("Sucess")
catch ex as exception
msgbox("Error is : " & ex.message)
end try
'end code
Now the above code shows message "Sucess",it means query run sucessfully but it does not change actual data in database.
Suggest me what should I do now.
Thanks for quick reply.
Gagan
|
|
|
|
|
1. Check the returned value of ExecuteNonQuery statement.
2. Check the connection string if that is pointing to correct database and you are checking the same.
जय हिंद
|
|
|
|
|
The returned value of cmd.ExecuteNonQuery is 1.
I have also checked database connection string and test connection with database.Everything is ok but query is not making permanent changes in database.
What should I do now.
Thanks.
Gagan
|
|
|
|
|
David and d@nish both have good suggestions.
Here's one for ya. If the query looks ok and there isn't an obvious error - run profiler.
Open up SQL profiler and examine what's being sent to SQL server. Profiler doesn't lie and quickly will 'highlight' what the problem is. If the query is making it to the server - ensure it's hitting the right database (if the connect isn't making it, then it's a connection problem of some kind probably).
If it is making it, copy and paste the SQL statement being sent into a query window in SQL Management Studio and try to execute it. If there are errors fix them in the query window and re-execute to verify. Since your problem is that it's not updating the database, add a select statement at the end to verify the records are being updated. If correct, then update your source in VB. Also check your where clause and make sure your updating the right records. If there is transaction logic, it'll be shown (although possibly split on multiple lines in profiler).
IMO: Profiler is one of the best benchmarking and diagnostic tools for SQL.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Ok Jon but from where I can run Sql profiler to check my query???
Thanks.
Gagan
|
|
|
|