Comments by FranzBe (Top 73 by date)

Have a look here: https://www.w3schools.com/sql/sql_orderby.asp

You are binding a DataTable to a ComboBox. The DataTable is a in-memory representation from something in the database. Now when you delete something in the database, the two are out of sync. As OriginalGriff pointed out: you need to update the DataTable you bound your control to. Make some loadData() routine, and call it upon Form_Load _and_ when you delete something.

By the way, this question is just a variant of that one: https://www.codeproject.com/Questions/5302621/How-do-I-do-a-system-that-user-can-login-and-add-b

I agree with Gerry Schmitz, what you wrote is not a good question. And your comment 'I want a solution' is not the right approach. If you are stuck at some point, I will try to help and get you over that (others will do as well and probably better than me) but I wont spent any time to give you a "solution" to that tiny "What I have tried" section you provided.

As a hint: When you use the "Reply" button to add your comment to my comment, I will get a notification. This way I would have looked earlier; You've got a perfect answer from CHill60 anyway.

What you show in the "What I have tried" section is merely a copy-paste of Sql Server Management Studio generated SELECT statements. That's not much. I have difficulties to see how the two tables are linked.
From my point of view it is not best practice to have blanks in column names and tables names; If you provide an underscore to TS_Station why not do so at Checkpoint_Movement as well (same for Return_CP_Name). This is inconsistent and will make your work harder.

In case your ID sits in textbox1, you might want to name it so:
sqlCmd.Parameters.AddWithValue("@licenseeID", textBoxLicenseeID.Text.ToString());

In the SQL Update command you would write
"UPDATE ... WHERE columnNameWithID = @licenseeID "

I would not recommend to have special chars in tablenames, you are likely to regret this at some point of time.

please see remark above

Hi Kevin, it is difficult so see what your problem is from the one line of code you are posting. I added some lines to the solution that are working on my system. In the getting started link I mentioned there are samples that show you how to connect to a SQL Server (in c# but that might still be helpful). You should use 'Improve Question' and post the relevant part of your code.

As you already have one stored procedure in place in database #1 you could set up a 'linked server' in database #1 that points to database #2. Having done this the stored procedure can access database #2 with the 4-dot notation select * from [linked-server-name].[db-name].[schema].[table]. Search for "linked server" or "sp_addlinkedserver".
As already noted: doing stuff in 2 databases that are somehow replicating on their own may lead to some nightmare.

ok, the snippet above is working, I tested that before posting it. I can't see your code so I have no idea what is going wrong on your side. If you add a new form to your solution and paste the code above into it (and add a button1 and a ComboBox2) you have a snippet that builds an sql command string having the tablename as variable dependent on the setting of a combobox. That was the original question. You can then copy and paste the required parts into your form that is not yet working. If you were a colleague next floor I would offer you a visit an have a look on your screen. This "I get an error here" without seeing the context unfortunately leads to nothing.

I just posted a snippet under solution 2, perhaps you can work your way on from this as starting point.

ok, one step back: the value that comes from your combobox does not match on of the expected entries for 'tablename' you are checking against. you need to ensure that the selection possible by the combobox is in line with the tablenames you have to provide. Try setting a breakpoint at the beginning of your button1_click event handler, inspect the .SelectedText property. Something is wrong there.

That means: the "str" variable is empty at the end of the if-else statement. You can add another "else" at the end, with the meaning "none of my expected combobox values where matched, something is wrong". Or even better: restructure your code as suggested by the solution below. Set a breakpoint at the start of the if-else statement and examine the content of "ComboBox2.SelectedText". In case you don't know a "Messagebox(ComboBox2.SelectedText)" will do.

Which Access Version are you using. "this doesn't work" means what? You got an exception? From 1st view your code doesn't look wrong (it would be better to have only the table-name in the if-statement as the rest of the sql command remains the same)

obviously you need to edit the itemtemplate to make room for the new column comming now from the database ...

It is not clear to me, what you intend to do. You are iterating through all rows of a table and then assigning a single label text property dependent on the value of the CardTypeRefId field. The label will always hold the text corresponding to the id value of the last row before the loop exits.

The callback from the FileSystemWatcher does not run in the UI thread, so you can't update a control when you are in the OnWatcherChanged() method. There are various ways to deal with this (search for 'InvokeRequired') in the sample above I start a new task that runs in the UI thread, TaskScheduler.FromCurrentSynchronizationContext() takes care that the correct thread is used.

There is no need to reload the whole form. You just need to update some data that is shown in the form. Make a private void ReloadStatistics() method, put the relevant code from the MainPage_Load event in it. Call the new method from MainPage_Load() as well as from _watcher_changed().

you may want to look here
http://www.codeproject.com/Articles/6847/Map-Network-Drive-API
or here
http://www.codeproject.com/Articles/662504/Extended-Windows-Service-Controller

1) "Insert Into" is not a query, so you should use cmd.ExecuteNonQuery() instead of the .ExecuteReader(). You are not reading anything from the database.

2) You should never use database user "sa" for your application. Create a user with the required permissions needed for your application and then use this user.

Unfortunatelly using Top1 or distinct is not solving but hiding the problem. You will need to check and analyze your subquerys one by one. I don't think remote assistance is possible without seeing the underlying data. Good luck!

You are passing an empty string to parameter 'Buffer' of the ReadCard() function. Are you sure who is allocation the memory for the string? The function of the unmanaged Dll? I would try to assign some space to the 'bufCard' variable before passing to the ReadCard() function.

You need to store your ProductId outside your application and have it loaded on startup. I case you are connected to a database you can use a sequence for that. Alternatives might be: some key in the registry or a program-setting.

ExecuteNonQuery() as the name implies executes a command, e.g. an update or delete command, that is NO query. What you need to do is ExecuteDataReader(). Try google "read data from sqldatareader", or as alternative "ado.net fill datatable"
When you look at your code: how do you think will intZero get its value?

Sounds like your dll is dependent on something that is missing in the 'other system'. I would try to monitor the start of your macro with process monitor or with dependency walker
https://docs.microsoft.com/en-us/sysinternals/downloads/procmon
http://www.dependencywalker.com/

You fill your datatable with the count of the students only, so there will only be one row with one column in it. The code after if (dt.Rows.Count > 0) makes therefore no sense. Try to exchange the 'count(*)' with '*', the 'sqlCmd' should be passed to the constructor of the SqlDataAdapter, in your code there is no connection between the two.

You should read something about DataReader or DataSet e.g. https://www.codeproject.com/Articles/420217/DataSet-vs-DataReader

The view interface makes the controller/presenter testable. That's the valuable part. I don't have the controller interface in my projects. I don't see what the controller interface might add to the story. So the creator of the controller know's the actual controllers type an there is a tight coupling at this point. So far I did not run into problems about this.

You are fetching the 'Device_id' value out of the textbox and into the 'id' variable (which will be of type string what perhaps is not what you want, 'int' as type might be better) but you don't pass the 'device_id' along with the sql query. You need to add an SqlParameter.
You might want to have a look here:
https://www.codeproject.com/Questions/844395/How-to-pass-parameters-to-Sql-Data-Adapter

Did you already check the 'Include actual execution plan' option and have a look at the results?

I would suggest you have a look at rdlc reports and report viewer:

https://www.codeproject.com/Articles/25222/Microsoft-Reporting-without-SQL-Server-Reporting-S#

I can't tell you from the little context you did show. I don't want to put more effort in the answer than you put into the question. From my point of view (which may be wrong) you have some error in your logic. e.g. take '(select distinct Bank_id from Setup_Bank where bank_name=@bank_name)' 1) the 'distinct' should not be needed here, you are searching for the id of a bank with a given name. There should be exactly one result. 2) If this query results in more than one row, something is wrong with your database-model, perhaps you need to enforce uniqueness with a unique constraint.

I can not look into your database, so I can not tell you. Check your subqueries one by one until you find the one that results in more than one value. I you find it, you need to change 'something'.

you need to check all your subquerys and ensure that they have a result of 1 value each. you are inserting one record in the transaction_employee table. this record contains one 'des_id', so the '(select distinct des_id From Setup_designation where des_name=@desig)' subquery must not result in more than 1 value (and the other subquerys must not either)

Add a breakpoint in the constructor of GetSentData(). If you don't have one than add it. Step into the 'new GetSendData()' call and see if you can narrow down the reason why the object is not created. I just created a mini-project from what you wrote and it works without problems. Just a remark: you don't need 'void Method();' on IInterface2 (you inherit it from IInterface1 already)

Just a comment: I voted your question up, because you provided the setup (table and data) to quickly play around with the topic asked for. Something I often miss in other questions I read.

If you use linqpad http://www.linqpad.net/ you can use the .Dump() method to easily visualize your data. You can copy and paste the snippet above and see that it works (and modify it). If you don't use linqpad, just comment out the .Dump() calls and use the debugger instead.

Try to compose the fileName with path before calling New FileStream and check if the contents of the variable points to your file.

Dim fileNameWithExtention As String = txtFoundationNo.Text + ".fpt"
Dim fileNameWithPath As String = System.IO.Path.Combine(lblPath.Text, fileNameWithExtention)

Dim fs As New IO.FileStream(fileNameWithPath, IO.FileMode.OpenOrCreate, IO.FileAccess.Write)

just search the codeproject articles for 'csv reader' or 'csv parser' and you will find some tools that do the job, e.g. this one: https://www.codeproject.com/Articles/9258/A-Fast-CSV-Reader

Instead of the datardr.Read() statement try a loop
While datardr.Read()
' process your record
End While

Hi Naga Sindhura have a look at 2.d) above. Hope that helps.
There is also a problem left with the ampersand in your data, you need to remove it to make it work. you may want to look here:
http://stackoverflow.com/questions/1744046/deserialize-xml-with-ampersand-using-xmlserializer

you may want to look here
https://www.codeproject.com/Articles/1110659/Formatters-and-Content-Negotiation-in-ASP-NET-Web

I also assume, like Dave already wrote, that you are getting a XML response from the api, if so the following code might help:

private HttpConfiguration ConfigureWebApi()
{
  var config = new HttpConfiguration();
  //other stuff
  var appXmlType = 
    config.Formatters.XmlFormatter
     .SupportedMediaTypes
     .FirstOrDefault(t => t.MediaType == "application/xml");
    config.Formatters.XmlFormatter
     .SupportedMediaTypes
     .Remove(appXmlType);
  return config;
}

You need to ensure that before calling SQL.conn.Open() there must be an assingment of the connection string to the SqlConnection object, something like this:
Private conn As SqlConnection
conn = New SqlConnection("yourConnectionString")

There is a detailed sample of how it can be done here
https://msdn.microsoft.com/en-us/library/ff963548.aspx
it is c# however

app.config is not expected to hold application data, you should use some .csv file for that; the app.config should only hold the 'configuration' related stuff. It would help understand your question if you post some sample data

for me that's the "normal" way to use it. the connection is your mayor object. so it comes first.

using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (var command = ... )
{
}
}

this assumes that you open and close the connection for every command.

in the block you posted, there are two cnn.Open() one after another.
the outer using block should be a "using connection" the inner using block than can be a "using command".
There is a blank missing after "delete from"

there are some intermediate language browsers that are able to convert the intermediate language back to c#. ILSpy is one of them http://ilspy.net/ it is open source. How far you will get with this approach is however unclear

When you need to make changes to your database structure, you could easily a) do a backup before you begin to apply you change, so you have a backup of the "before" state; and b) then after having done the change make a second backup the holds the "after" state.

You do not mention it, but you seem to work with MS SQL SERVER, so perhaps you might want to read something about backups of Transaction Logs; In a production environment you will have a complete backup say once a day and a backup of the transaction log perhaps performed every hour. So when there is a need to restore, you will restore the complete backup followed by a chain of restores of the various transactions logs. This way you will get the state of the database is has as the last restored transaction log was put to backup.

It's always a good idea to have the changes to be applied to the database ready to go in a prepared change-script. If you have this script you can always run it against a backup of a database that was taken before.

So in response to your "requirement" you expect to get the AngularJS equivalent of your code snippet?! well, you need to write an AngularJS controller that handles the service call part and you need an AngularJS view that does the UI part. In case you search for "AngularJS login example" you will find some tutorials that point you the way to go, e.g. this one
http://jasonwatmore.com/post/2015/03/10/AngularJS-User-Registration-and-Login-Example.aspx

you need to serialize the content of your control before trying to save.
you may want to have a look here:

http://www.codeproject.com/Articles/86503/Saving-the-state-serializing-a-Windows-Form

Good to hear; perhaps you should mark your question as solved, so that it gets the correct status in the question list;

What does your stored procedure return?

perhaps this
https://msdn.microsoft.com/en-us/library/hh534080.aspx
might help.

Thanks for clarifing. In your position I would try two things: have a look with wireshark to see who is fetching your request and replying to it; and I would take an "old" Win-7 vmware guest (or install one, it's not that painfull) that doesn't have the KB updates of the last year installed to verify your "some update did break it" suspect. Sorry for not beeing helpful and: good luck!

did you try analyzing with service trace? i.e. insert a system.diagnostics section in you app.config with a tracelistener and than opening the resulting file with
c:\Program Files\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools\SvcTraceViewer.exe

I don't understand your question. Your WCF solution will be composed of a service and a proxy/client part. You can setup you SQL Server so that the WCF-Service part that accesses the database sees only the tables required.
A starting point for this would be something like this:

IF NOT EXISTS (SELECT * FROM MASTER.DBO.SYSLOGINS WHERE LOGINNAME = N'yourwcfserviceuser')
BEGIN
CREATE LOGIN [yourwcfserviceuser] WITH PASSWORD=N'yourwcfservicepassword'
,DEFAULT_DATABASE=yourdatabase
,CHECK_EXPIRATION=OFF
,CHECK_POLICY=OFF
END

EXEC sp_grantdbaccess N'yourwcfserviceuser', N'yourwcfserviceuser'

SELECT 'GRANT SELECT ON '+ a.table_name + ' TO yourwcfserviceuser' FROM
(SELECT DISTINCT TABLE_NAME FROM information_schema.columns
WHERE TABLE_NAME LIKE 'yourtablesearchpattern%' ) a

I don't think SQL server roles will make too much sense as there will be only one user.

Between the WCF Client and the WCF Service part that's where the WCF authentication comes into play. Here you specify How the WCF Client may or may not access the WCF Service (or parts of it). This has nothing to do with SQL-Server security (and it is a big topic).

Besides the unclear question: think a moment about it: how happy would you be on your birthday being the recipient of a robot-generated greeting?! I would suggest canceling your early stage project and go buy some flowers instead :)

I would start this way:
1) Define a class "MyApplicationSettings"
2) put a property "FormBackgroundColor" there
3) define an event OnBackgroundColorChanged
4) raise this event in the setter part of the FormBackgroundColor Property
5) subscribe to this event in the OnLoad routine of each form
6) change the background color of the form in the corresponding event handler
7) use the SelectedIndexChanged event from your combobox to write the selected value to the FormBackgroundColor property

you should provide the code you have written so far and point out where the problem is you are struggeling with