Comments by Atlapure Ambrish (Top 76 by date)

What error you are seeing?

where is your loop??
Also, you are assigning 0 to value, instead it should be assigned to numbers item in loop and then parse.

The new property you add to partial class should be available automatically, because the new partial class is nothing but your entity :).

Not clear, maybe you want to use 'Improve question link to add more details on what you are looking for. With your explanation above, can't you just use where clause with IN and mention the index values you want to select data for?

This should work, I have checked it and is working for me. What is the datatype of date_time column?

no problem, it's my pleasure!

I am sure you have referred these articles, but still wanted to point those out..
http://gsferreira.com/archive/2015/02/how-to-encrypt-in-nodejs-and-decrypt-in-c-sharp/

https://social.msdn.microsoft.com/Forums/en-US/47800a60-4461-4f8e-a8d1-751fa62c7884/aes-encrypt-in-javascript-and-decrypt-in-c?forum=csharpgeneral

I hope your problem is resolved..

yes correct, if you are deploying your application on other machine and keeping database on your machine, then you have use shared path for database on other machine.

I am not sure, What you are trying to do in the trigger on Table2.

Also, if you write a trigger on Table1, you don't need to loop through the rows, you have t1_id (FK) in table2, so, you will be able to easily delete all the rows using this FK after you get ID in the trigger from deleted table.

DELETE FROM TABLE2
WHERE t1_ID = ID

If it is the machine your working on then you don't need the shared path, you should just use normal path e.g.: c:\abc.mdb

Can you try opening the mdb file in access and save as .accdb and try to connect?

The connection string is absolutely fine (just check if you are able to access the network path), what problem are you facing now?

For every month and day there is different code? As you mentioned X is Oct and B is day 11, these will change for other month and day??

Oops its my bad.. Thanks for making me realize.. I somehow overlooked it.

Where you have mentioned this in your original query? before down voting you should share such details. isn't it??

you can still use "case" statement.

below is an example..

CREATE TABLE OrderDetail
( OrderID INT
, ProductID INT
, Qty INT
, OrderDate DATETIME
, ShipDate DATETIME
, STATUS AS CASE
WHEN shipdate is NULL AND orderdate < DATEADD( dd, -7, GETDATE()) THEN 'Late'
WHEN shipdate is NOT NULL THEN 'Shipped'
ELSE 'Ordered'
end
)

insert into OrderDetail
values(1, 12, 123, '10/05/2017', NULL)

What was the problem with solution I had provided?

what do you mean by link? have you added any hyperlink in your code? I don't see any. Please provide more details.

The way date.subtract is designed, it is giving you correct result, but it seems you want to include the starting day as well. In this case you just need to add 1 to the result returned by date.Subtract method.

no problem, use username instead of role in the if statement as I have already mentioned in my solution.

c$ is the drive name on the machine where the database is kept

How you are binding data to your list boxes?

What problem/error you are getting while removing the item from list?

I think SelectVoiceByHints is throwing that error. Cant you debug and see which line is throwing the exception??

Can you remove sum(0.000) from both queries and check if it is not throwing that error after tweaking the query as required.

Add more details on what you are trying to achieve..

Please ask specific question. From your explanation it is not clear what you want to achieve. If you have json you can convert it to a complex type i.e. Class using a standard library and use specific properties of the class to insert in different tables.

Yep, definitely, I don't see any reason for this to not to work.

The ideal approach for such scenario should be:

Use SqlCommand.ExecuteScalar() and cast it to an int, something like below:

cmd.CommandText = "SELECT COUNT(*) FROM table_name";
Int32 count = (Int32) cmd.ExecuteScalar();

you may use Convert.Int32 for casting.

Thanks

Can elaborate more on what exactly your are trying to do??

Have you tried this https://stackoverflow.com/questions/3594143/dynamically-set-hyperlink-controls-navigateurl-property-inline

I have used frm1 and frm3 in example, so, the code in frm1 should go to form1.cs and frm3 should go to form2.cs if you have classes. Otherwise refer it as example, it shows how you can access it another form.

My brother, I would leave defensive coding part to the author :)

Ideally, the databases are designed that way.. :)

I do not see your code like the one below. The con.Dispose will close the connection and release associated resources.

Dim con As New SqlClientConnection( . . .)

Try
' DB Operations (create, read, update, delete) here
con.open()

Catch SqlClientException (ex)

' Deal with exception
Finally
' Code here will always run, whether or not the try code succeeded
' or if you wound up in a catch block. You can safely call .close()
' or (as shown below) .dispose() because if the connection is already
' closed/disposed, the call doesn't do anything.


' Dispose is what you want - it will not only close the
' connection, but it will release the .NET reference to
' the remote resource, freeing up that resource (the database
' in this case) to serve other clients.

con.Dispose()

End Try

Can you elaborate more on the error and on which line you are getting it? It is not clear from your description.

Sure, accept the solution once you try and it works for you, so that it will be helpful to others as well.

Have looked at this? it might be helpful to you.. https://stackoverflow.com/questions/9219557/creating-text-file-without-using-bcp-in-sql

Please accept the solution :)

have you tried this.

DateTime dateValue;
DateTime.TryParse("5/01/2008", out dateValue)

int a = Sadapter.Insert(txtSErNo.Text, txtSfname.Text, txtSLname.Text, txtSadd.Text, txtScity.Text,txtSstate.Text,
txtSpin.Text, dateValue,
DrpGender.SelectedItem.ToString(), txtSMoNo.Text, txtSeid.Text, txtSUname.Text, txtSpass.Text);

Got it, I think you are trying to use the TryParse in Insert method, instead do it before insert and then use dateValue variable in Insert method. like this..

DateTime dateValue;
DateTime.TryParse("5/01/2008", out dateValue)

Sadapter.Insert(txtSErNo.Text, txtSfname.Text, txtSLname.Text, txtSadd.Text, txtScity.Text,txtSstate.Text,
txtSpin.Text, dateValue,
DrpGender.SelectedItem.ToString(), txtSMoNo.Text, txtSeid.Text, txtSUname.Text, txtSpass.Text);

I am not understanding.. can you elaborate more. It would be helpful to see your code with TryParse you are trying.

Convert the values selected in dropdown lists to date format string first and then use it in TryParse e.g.:

DateTime dateValue;
DateTime.TryParse("5/01/2008", out dateValue)

please refer the article I have provided in my solution.

Have you tried this.. the MSDN says...

https://msdn.microsoft.com/en-us/library/bb629303.aspx

Can you show me the code what exactly you tried?

The LEFT join is made for that. In Thomas' solution he has already suggested to use LEFT join, this should solve your problem. What is the issue?

Yeah, its not a problem but definitely a improvement!

Another problem I see in the code is use of unnecessary variable "decimal TotalSum = sum;", instead of defining a new variable, you can use 'sum' variable.

Try an online tool like this one to tweak your XSL quickly and see the result immediately. http://www.utilities-online.info/xsltransformation/#.WXWBh4SGPcs

It is up to your requirements, but it is possible to have 100 fields in one table. In fact if you use multiple tables say e.g. 4 tables with 25 columns each with foreign key reference, while fetching data from all these 4 tables will be a performance hit (as you would use joins). If you use single table you can simply fetch all the data at once and use it based with your logical grouping in front-end.

No problem, I am glad that it was helpful to you!

Can you try CTRL+ALT+E?

for more details refer https://blogs.msdn.microsoft.com/zainnab/2010/12/01/the-exceptions-dialog/

Here's an article it is not for asp.net but explains the steps..

http://blog.scottlogic.com/2015/03/09/OAUTH2-Authentication-with-ADFS-3.0.html

Keeping the whole datatable in viewstate is going to be very heavy and has to sent along the request/response. Also, you would like to pay attention to cast.

You can use two different datatables. One to work with dynamic grid, which will be created every time and bound to this grid so it does not show any data. When you hit Add/Insert button just copy the data from this datatable to the datatable which is bound to other other grid using built-in method.

d.value in above query is your date column in datatable you are using.

Its my pleasure!

The question was to move focus to another control on pressing enter key and this is the easy and quick solution.

That needs to be checked :), may be you can try it out after applying this solution for any one functionality?

Can you try this? I have not verified it, but it seems this is similar to your problem statement. https://forums.asp.net/t/1605429.aspx?SQL+Join+Tables+on+Column+Name+and+Row+Field+Value

And what is the issue??

Have checked if the folder/file is read-only on server? if it is, just remove the read-only flag from folder/file properties and see if it works.

You welcome!

Please don't down vote the answer, if you don't understand do ask questions.

If File.Exists("C:\j\WindowsApplication1.exe")
{
My.Computer.FileSystem.RenameFile("C:\j\WindowsApplication1.exe",
String.Format("{0}.exe", Path.GetRandomFileName().Replace(".", String.Empty)))
}

Also make your code defensive by using TryParse instead of Parse, with TryParse you would be making sure the textbox value is a number (also you would not get exception), if it is not then handle it properly and show required message to end user.

As you are already storing accessibility information in database, I am not sure why you need to store it in web.config again. I think you can simply get the role and accessibility information for logged in user and check for authorization.

For example, if you are using asp login control then, do something like this..
<asp:Login ID = "Login1" runat = "server" OnAuthenticate= "ValidateUser">

ValidateUser method is going to fetch data from DB and then you can handle the authorization.

Just read the value of controls/fields and append while preparing URL. For example on client side, find the control and fetch its 'value' and append. Same applies for server side code as well. In my example in the solution, you just need to replace actual values for place holders {TableIdValue} and {TableSeatIdValue}.

Are you using onload event to open the popup?

For CSRF refer below URLs..
https://software-security.sans.org/developer-how-to/developer-guide-csrf
https://stackoverflow.com/questions/29939566/preventing-cross-site-request-forgery-csrf-attacks-in-asp-net-web-forms

As you are thinking to generate a token and store it on server to validate later on, I think you can do that. The approach should be generate a GUID (or this could be any value of you choice, would be more beneficial if you could make it configurable) and then encrypt it before storing on server using some algorithm and then add this to a hidden field on your form. Encrypting would add an extra validation level.