Visual Basic

Re: VS 2005 does not recognize the Table Adapters in code

24-Mar-09 6:14

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

paulogomes24-Mar-09 6:26

paulogomes

24-Mar-09 6:26

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

Re: VS 2005 does not recognize the Table Adapters in code

Jon_Boy24-Mar-09 8:20

24-Mar-09 8:20

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

pdnet24-Mar-09 4:07

24-Mar-09 4:07

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="asInvoker" uiAccess="false" />
<requestedExecutionLevel level="requireAdministrator" uiAccess="false" />

</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>

pdnet24-Mar-09 4:06

24-Mar-09 4:06

<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)

pdnet24-Mar-09 4:06

24-Mar-09 4:06

<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)

pdnet24-Mar-09 4:05

24-Mar-09 4:05

<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)

pdnet24-Mar-09 4:04

24-Mar-09 4:04

Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)

EliottA24-Mar-09 4:08

EliottA

24-Mar-09 4:08

Tool, stop posting 5 times the same crap, it's annoying. And no, you tool.

Check out the CodeProject forum Guidelines[^]

dan!sh 24-Mar-09 4:13

24-Mar-09 4:13

pdnet wrote:
Report post as abusive

I have already. All of them. Now get lost.

जय हिंद

Jon_Boy24-Mar-09 4:25

24-Mar-09 4:25

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

dan!sh 24-Mar-09 4:29

24-Mar-09 4:29

Where is my name on the list?

जय हिंद

Eddy Vluggen24-Mar-09 4:48

Eddy Vluggen

24-Mar-09 4:48

I guess that only senior devs' make it on the list Smile | :)

I are troll Smile | :)

dan!sh 24-Mar-09 4:52

24-Mar-09 4:52

Better question would be how do these people become senior devs'?

जय हिंद

Jon_Boy24-Mar-09 6:18

SQL query is not making permanent changes in database.

24-Mar-09 6:18

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

Gagan.2024-Mar-09 3:11

Re: SQL query is not making permanent changes in database.

24-Mar-09 3:11

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

dan!sh 24-Mar-09 3:15

Re: SQL query is not making permanent changes in database.

24-Mar-09 3:15

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.

जय हिंद

Gagan.2024-Mar-09 3:22

Re: SQL query is not making permanent changes in database.

24-Mar-09 3:22

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

dan!sh 24-Mar-09 3:37

Re: SQL query is not making permanent changes in database.

24-Mar-09 3:37

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.

जय हिंद

Gagan.2024-Mar-09 3:42

Re: SQL query is not making permanent changes in database.

24-Mar-09 3:42

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

Jon_Boy24-Mar-09 3:50

Re: SQL query is not making permanent changes in database.

24-Mar-09 3:50

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

Gagan.2024-Mar-09 3:57

Re: SQL query is not making permanent changes in database.

24-Mar-09 3:57

Ok Jon but from where I can run Sql profiler to check my query???

Thanks.

Gagan

dan!sh 24-Mar-09 4:18

Re: SQL query is not making permanent changes in database.

24-Mar-09 4:18

On your computer. Cant you even find a software installed on your machine and run it?

जय हिंद

Jon_Boy24-Mar-09 4:33