|
Hi plz who can help me, i am trying to use datagridview rows as cheched and the make updated the checked columns in to Emptable
itryed as flows:
For i As Integer = 0 To DataGridView1.Rows.Count - 1
While DataGridView1.Rows(0).Cells("Select").Value = True
sql = "update tbl_EmpDetails set Approval='" & x &"' where eid='"& DataGridView1.Rows(i).Cells(1).Value &"'"
cmd = New SqlClient.SqlCommand(sql, conn)
cmd.ExecuteNonQuery()
End While
Next
|
|
|
|
|
You mistakenly wrote a 0 in the following line where an i should be instead:
While DataGridView1.Rows(i).Cells("Select").Value = True
Also, you should use SqlParameters[^] instead of concatenating your SQL-statements:
- to avoid the risk of SQL-injection
- make your code better readable
- avoid errors due to quotes in strings.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
Hi,
For macro distribution, I want to write a vb.net application that installs all addons the user needs into MS Office and deploys a few shortcuts.
One of the addons needs a .bas module to be injected into the Outlook VBA. If the module already exists, it needs to be updated from the .bas file.
After injecting the .bas file, I need to import ribbon customization files to the ribbon in a new e-mail and in an opened e-mail (read view).
At this moment, my code hooks into the running Outlook instance or - if not existing - fires up a new instance of Outlook. But then I'm stuck.
Is there a way to do this? How do I do this? I've referenced to Outlook 2013 in early binding -
Imports MSOutlook = Microsoft.Office.Interop.Outlook - but afterwards, I want to convert it to late binding to be usable on Outlook 2010 as well.
Thanks in advance!
|
|
|
|
|
Hello!
I'm looking for a tool to display 2d chemical structures in my .Net application. I found some open source projects to handle this written Java. But I'm not happy with it, because the browser security permissions often blocks the applets. Then I found also Ketcher written in JavaScript, unfortunately I got an javascript error to display only the structure in a webbrowser control. When I run the html page in FireFox or Internetexploere it runs, the error appears only by using the webbrowser control.
Is there a tool available that only displays 2d chemical structures especially mol files?
I look forward to any tips and informations.
Kind regards
Christoph
I'm a novice from Germany.
|
|
|
|
|
|
Sorry, I'm looking for a solution with the .Net framework. So I tought this category is not totaly wrong  Which forum fits better to my concern?
Kind regards
Christoph
I'm a novice from Germany.
|
|
|
|
|
Hi,
I am facing one issue with Entity Framework Model. I make changes to database and after this I updated production server's copy with my updates with Published Version. But I am getting en error from Entity Framework. So how to update Entity Framework's model as per my database change on production server with Asp.net Published Version site.
Thanks in advance.
|
|
|
|
|
Not enough information. You never said what the error was nor which mode of Entity Framework you're using.
In general, with Entity Framework, if you update the database you must also update the code to use that version of the database.
|
|
|
|
|
After initial deployment of website, in next revision I added few columns in my database and updated edmx file and it is working fine with my local source. When I published website and uploaded code to web server It is showing an error like "ColumnName" is not found in data collection etc..
|
|
|
|
|
I assume you're using Database First. You have to manually make the changes to the database yourself, same as you did with your local copy of the database.
Database First is used when a DBA has control over the database design and you have to write code against it. Normally, you wouldn't have access to the database schema in this situation. DBA's would be making these changes for you.
|
|
|
|
|
True, I already executed database script and all table level changes are executed on the server database. Still I am facing issue with published version of the website.
|
|
|
|
|
The only thing I can say is that you're missing some change to the database or the changes you made are not exactly the same as you made in the development version of the database.
The only mode of Entity Framework that supports migrations is Code First where database changes are assumed to be made by the code only, no manual changes. The database is changed to match the model.
Database First assumes the database is changed manually and you have to update the model from the database.
|
|
|
|
|
that there is a member here who can make me an app to my website 
|
|
|
|
|
Nope. This site does not take orders for custom written software. Try Freelancer.com. Beware though, you're going to pay to have it done and you get the level of expertise you pay for.
|
|
|
|
|
I have a quick query on ELMAH https://code.google.com/p/elmah/[^] It supports by configuration either to choose SQL Server or SQLite. I would like to know if there is a way to choose both (SQLServer and SQLite) to do the logging.
Can some one shed some light on the same?
|
|
|
|
|
Nevermind
modified 11-Jun-15 13:44pm.
|
|
|
|
|
|
Message Closed
modified 11-Jun-15 13:43pm.
|
|
|
|
|
Good Luck! You're going to find that this doesn't hold true for all managed assemblies.
|
|
|
|
|
how to learn angularjs suggest some sites
|
|
|
|
|
|
As Angular is a web based technology, I'm not sure why you thought it appropriate to post here in the .NET forum. Saying that, if you want to learn Angular.js, then I would heartily recommend that you take out a Pluralsight[^] subscription. They have excellent videos that will help you learn.
|
|
|
|
|
thanks for your suggestion
|
|
|
|
|
Also have a look at the AnuglarJS[^] web site. They have some good start tutorials
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
i am new in .Net field want to make a program in which user type text and that text will be split in into Sentences.how to make this in MVC plz guide me. i am using Visual Studio ultimate 2013?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
