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)
Is there a tool available that only displays 2d chemical structures especially mol files?
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.
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.
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.
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.
This isn't as easy as you'd expect it to be. At first, you might be tempted to go with a regular expression, breaking each line on .!? but this won't really work because it's common to have sentences that include abbreviations, which end in the period. So, you're going to want to look at using a Natural Language Processor (NLP) to accomplish this. Now, this is a large area and isn't one that you can really answer in a forum. I'm afraid, if you have a requirement to do this, then you're going to have to research which NLP will best fit you.
I have a asmx-webservice. When I try to access it by using the URL directly, I get an error "Requested Format Unrecognized" (I hope the translation is correct; I have a Dutch version). When I try to make a service reference, I get the following error: There was an error downloading 'http://bliep.hulppeldepup.nl/bliep.asmx/_vti_bin/ListData.svc/$metadata'.
The request failed with HTTP status 405: Method Not Allowed.
After some googling, I got to this page https://support.microsoft.com/en-us/kb/330221/nl that tells me that I have to adjust settingsin the firewall to remove unknown headers. Unfortunately it doesn't tell me how, and I can't find the answer anywhere.
The strange thing is, that on the same site I have another asmx webservice that I access through AJAX, without problems. Now I want to do the same thing with a Windows Forms application, and problems arrise.
How can I make my asmx webservice available for my program?
Yeah, but it's a Web Service that runs on top of the ASP.NET framework. The .NET Framework is much lower in the stack and your question is about functionality at the ASP.NET level, not the .NET Framework.
The answer to this is, try them out. Measure their performance for the use cases you have in mind. Your question is far too simplistic to make a reasonable judgement because performance could vary wildly for different use cases. Apart from anything else, you'll need to take into account features such as scaling out the application, how load balancing affects your app, does different parts introduce bottlenecks, as well as defining what acceptable performance is.
In addition to what Ryan said. Web services are generally used to have a multi-tier architecture where web services work typically on the middle tier.
Consider a scenario, where we have a database and a website that fetches data from this database.
Now, you have a requirement that you need a mobile app, that will use data from the same database.
DB---> Mobile Application
You will be re-writing the entire logic to fetch data from DB in your mobile app
To save yourself from such problems. Multi-tier architecture is the solution
DB--->Web Service--->Mobile App
DB--->Web Service--->any other client who can consume your web service
By using this strategy you just have to write you Data Access Layer in web service only. Your clients will have to consume this service and get he data from it.
There are a lot of scenarios where web services help a lot, integrating disparate systems using web services is another example. Google the use of web services and I am sure you will get a lot of stuff related to it.
I just want to seek help, regarding my program. i want to do this in my program. the scenario is this, i have two datagridview in the main form there is a datagridview1 whenever i click the details in the datagridview1 in the datagridview2 will show the selected value of there employment history.
I already do that, my only problem is retrieving the information then view it on a datagridview. like what i said when i click datagridview1 the details of employment history is will show in datagridview2. something like that.
..a mouse-click event is triggered. Open the form with the designer, select your datagridview, press F4 to bring up properties. That properties-list can also show events by toggeling one of the buttons at the top. Find the Cell-click event, and double-click it. That generates the handler and hooks it up when the form is created.
In that event, you load the data for the second datagridview, in a similar way as the first datagridview. Since you probably want details, you'll need to use some details from the "e"-variable from the CellClick-event - it shows in which row and which column was clicked, allowing you to fetch the value and to reuse it in the query for the second datagridview.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]