Comments by Bala Selvanayagam (Top 200 by date)

Hi, I am not sure about how the java side works.

In Microsoft .net side, "Controller" is responsible for calling the methods (not the html layer) and it will pass the result to the view (HTML) and the view will render the data.

In other words, the so called "method callings" are separated and put under controller and from controller the result (object) is passed to the view

How far you have progressed on this, are you able to populate the data into the SignalR server Hub ? where are you suck please

Thanks & I did not know

Where getdate() between FromDate and ToDate ?

Lopezd ; are you saying that you have done a windows client (not an HTML web) to pass the connectivity details (database name,userid ...) and then trying to present the data retrieved to the web ? Where does the windows comes and where does the HTML web comes into play ?

sorry, am bit lost here

On a separate note, thanks for sharing the Book Review : Knockout.js Succinctly

Can you post your code so that we can look into what is going wrong ?

It is very difficult to help you without knowing what you have done so far.

Are you able to post me the code in your controller and the view please?

Glad

I would suggest the same as Simon_Whale

I would suggest MVC.

Silverlight/Webforms are great tools but becoming slightly old fashioned.

Learning MVC is not difficult and you will be able to figure it out as you have a requirement & knows web development. Personally learning MVC will add value to your career progress

Are you saying that you are editing three songs at the same time in the view and click of a button, save those into the database ?

The general practise is that you will list all songs and select the one you want to edit (edit one at a time)..What made you to set the number of songs to be edited at the same time as 3 ? why not 5 or 10 ?

I am not sure about your question, are you saying that you would like to get the count of a linq query result ? please clarify with detail

not clear what you are exactly trying to do ?

the link you have provided looks normal and can not see anything scrollable only in the middle unless am missing something ?

can you please post the code behind the toggle_visibility function ?

Your question is not clear.

On what basics / logic you are assigning the roll_no ? for example 8 3 khemraj I B,
khemraj got roll_no 3 and what is the logic you used to derive this ?

I am not sure about the nav tag

have a look at http://www.quackit.com/css/codes/css_floating_menu.cfm

5ed

One of the potential area is audit trail

Say you have a table employee and you want to keep track of the changes done to the table including the value before and value after and the date time modified


If you are going to do with SP, then you have to pass the before and after values into the stored procedure with the time stamp and manually execute. The challenge with this approach could be you have to write more code to capture the before and after values and pass it into the stored procedure with in a transaction and also if you are updating the table from different many routines then you will have to call the stored procedure each time explicitly

But if trigger, you can easily have the before and after values and automatically executed from which ever the module you update the underlining database table.

It actually depends on what technology in c# you want to learn and what is the current level of your expertism in c#

Check it out and if the account is still free you could sign up again on the same name.

If not call the Hotmail support line and explain to them and you may be able to get it back but not sure

Jenitshah,

The method to access the database using "DSN" is quiet old method and not been used any more in the industry.

putting the connection string in the app.config file and using it to connect to the database is a commonly used method. please see the similar post http://www.codeproject.com/Questions/254402/How-To-Store-and-retrive-ConnectionString-from-app if you need further info


if you still have issue let me know

Hi Manish,

Understand, yes this will work on the network environment - means will work on the Local Area Network (LAN) but may not be on the (Wide Area Network) WAN. Do not define the connection string in many places with in your program and this is a bad practice.

Try and keep the connection string in a single place so that you can edit easily.

I would recommand you to do your first form and create a installer (when you double click) it installs and then try out from two workstations pointing to the same SQL database. This will give you an understanding of how the architecture is going to be

Which controller and the action method you are in now and which are (controller and action method) you want to invoke ?

Hi,

I have two images

img/crm.jpg & img/cal.png (Both images are in a folder called img)

On the click, I have to change the image. if the image was "crm.jpg" when you clicked then it needs to be changed to "img/cal.png" and vice-versa.

In your if condition "element.src" will be the image you have clicked on and the condition is checking whether the image name you have clicked contains "crm". If true, this means you have clicked crm.jpg and then within the if clause loading the other image

Hope it make sense ?

Impressed with you answer 5ed!

Can i add the followings

1. Bootstrap - UI framework
2. Web API - Light weight and can be accessed from most of the devices including mobile
3. Jquery / JqueryUI

There are many more but feel these are the essential bits on the web development

SamKulk

I have put an alert inside the getLocation function and when I click on the button the alert pops up and the else part is executed for me.

Not sure whether this is a browser specific issue and what browser you are using ? did you try different browsers ? please let me know

You have not mentioned whether you do .net windows development / .net web development / web designer

The latest technology you got to learn is based on what you are already doing. can you please let us know what is your current role and what do you do ?

Pleasure

Please see my answer below

My pleasure

You could use a database trigger ?

yes, you can

5ed

Hi Arunraju

You have to narrow where the issue is ? (SQL SERVER/WEB SERVER)

Since you are able to recreate the issue in your development environment, could you have a break point on the SQL server execution where it throws the error

1. Get the SQL statement, directly execute on the database server and see how long it takes to execute

2.Run it through the IIS web server, you know how long it took in the SQL server already and now you can calculate how long it takes in the web server.

If the SQL server is taking longer, then it could be an indexing issue (have you migrated all your indexes into the new server ?) and also you are saying that the database before was a single one and now multiples...How does it work

If the delay is in the IIS server, check the server configuration

Bala

Have a look at

http://www.mrexcel.com/forum/excel-questions/213186-lock-cell-macro.html

Also, you can google on this and you will have many suggestions/ solutions

You mean locking an EXCEL spread sheet cell using JavaScript ?

As far as i know, you can not use JavaScript to manage EXCEL. You may have to look into some EXCEL VBA/MAcros, if am not mistaken

It could be a firewall blocking the client calls on the server ? also there is an option in SQL server to grant access to remote call, may be this is not ticked

Try doing a simple ODBC connection (from the control panel) of your workstation and see that works first to eliminate where the issue is ?

It could be a permission issue.

I remember similar issues when working with COM somes time back and we grant permission on ht object so that the IIS call can instantiate.

I do not remember how to grant permission as it was some times back i worked on COM.

May be do a google ?

As far as i know, there is no such standard font and it is up to you to decide which font you wanted to use

The code should work,

What do you mean by "NOT WORKING"?

You have to give more back ground information such as what happens when you click on the button, what is the eroror message you are getting in the screen and the URL on the address basr ?

Could you please be more clearer and specific on your questions ?

I am not sure what exactly you are after ?

Could you post me the view side coding as well (there should be a form attribute where you capture the data and post to the controller)?

The certification is from Microsoft.

Microsoft has their authorised exam centers across the countries to conduct the exams on their bahalf and you may have to check whether the exam cerntre you are talking about is in the authorised exam list by microsoft


Once you pass the exam in one of the authorised exam center, they will give you a printed copy of your results and later you may get a proper certificate from microsoft, if you wish

5ed

Another option could be ?

DECLARE @temp VARCHAR(30)

SELECT @temp= name
FROM Table_Name
WHERE Id=<<Some value>>

My Pleasure

Hope you have got it working ?

Please see my comments under "UPDATE 2" in the solution section above

You are looking at the wrong configuration file

There are two configuration file one for WEB API routing and one for MVC routing. the one you were looking at is MVC routing


look at the correct WEB API routing configuration which is under App_Start/WebApiConfig.cs

We can help you, if you have tried something out and stuck

I would suggest to get <nobr>visual studio installed and do a googling for a similar tutorial and try it out yourself first. If you are still stuck, we can help you out on this

you are most wellcome

Could you directly login to the SQL EXPRESS and check the database exists for the given username and password. you could download a free management console for SQL Express, if you do not have one


looks like the database you are trying to access does not exist under the given credential

It all depends how you have architecture your application. My understanding is that your web form (my assumption) is directly talking to your database using ADO ? alternatively, you could separate data access layer on a different server. To be honest, unless you explain how is your current architecture is, it is difficult for me to go on....


The performance depends on

1.The database table normalization and whether you use TSQL /Stored procedure

2.The database is properly indexed & optimized ?

3.You have used minimum run time logic in your web form ?

4.Are you doing many round trips to the server ?

5.Your current experience with 30 users, what is your current server specification and how does the server perform now. This could be a bench mark for you to estimate 300. You needs to know how many users out of 300 is going to use the system at the same time ? Based on these you could size the server (how many CPU/CORE, Mormoy and IO )

6. Also you could think about using multiple IIS server, this means you could use two IIS server and part of the use base is routed through one server and the rest is through the other (the URLs could be different for them - load balance) but evenually talking to the same server

you mean "Bit Operation" ?

NoSQL - Some of them a faster on write operation and slower on read operation and vice versa. Also NoSQL is not very good when it comes to complex query (reporting)

Do you have a sample code to show how you are connecting using Javascipt ?

You can do this.

What do you mean you are getting a server response ? I presume you have a service which gives you the data ? what type of service you have and what format data is presented ?

you needs to provide more info

You could use ASP.net(web forms) for payroll development and there are pros & cons. You may not be able to have rich UI features as windows environment unless you use some javascript frame works. Also the web forms needs to be post back most of the time and this may or may not be ideal for you.


If i were you, I will look into the reasons why the application should be web/ windows based

If it is going to be web then will use MVC based single page application with javascript frame works like Angular / knockout for rich user experience.

The performance of the web application is depends on your hosting environment and your optimisation of coding

Apologies for the delay in answering the questions.

I will make sure this is done promptly next time without any excuses.

BTW, I have not got my last month salary from you yet and is there any possible reason on this please ? Also, Can i have a day off next Monday as i needs to see my Doctor

not enough detail provided

Could you tell us what you have done and where you are stuck (you may have to post part of your code base) and without these information, would not be able to do much

glad

sagar, similar question

http://stackoverflow.com/questions/15281278/in-angularuis-nggrid-edit-on-focus-cell-selection-example-does-not-edit-o

this should give an answer how to edit ?

sagar, I am not an expert on AngularJs but trying to build a prototype for our next project which is due to start soon.

My understanding is that when you bind the data on the client side with angular javascript it may not be very hard to make it editable as its a data binding ?

Please have a look at the URL http://harouny.wordpress.com/2013/02/03/using-angularjs-to-consume-webapi-service-in-mvc4-project/ which gives and idea.

WCF service out put should be in JSON format

May be you can pass a parameter/ argument from the view to the controller and within the controller check the parameter and redirect to different pages

Do we need a foreign key actually defined in order to do a join ?

you mean to convert the comma separated values such as 1,236,895,623 into single values in C# ?

not very clear what you are after ?

When you say username, are you referring to the username of the server under which the web server is running ?

do not want to be rude but there is a possibility you could be fired or the company may give up software development and start trading something else soon

God bless you and the company

There are so many free CMS in the market like joomla,drupal and etc. Why do you want to build a new one, if i may ask ? Always i customize the joomla/ drupal to my requirement rather than building a one and it worked

I am using Macromedia Dreamweaver 8 as an editor.

Is the second database is is in the same SQL server instance or in a different computer ?

What do you mean by all files in a control ?

Do you want to display files in a directory in a control inside vb.net ?

So,whats is stopping you from getting the value of act?

Hope you have the database hosted in one of the ISP and you are trying to connect from your local windows application from your PC ?

It could be some times the ISPs would not allow connectivity from out side domain and will let you to connect from only their own domain space. could this be the reason why you are getting the "not exists any port for access my database" message ?

I read your other post, you may fall into legal issues if you do this without the knowledge of the user - data protection act ?

It depends on many factors like the database ( hope its SQL server) version, band width you have between your server and remote database, your exact requirement, your expertism and etc

you could try replication ?

What did you try so far ?

Can help, if you have tried out something and stuck.

Thanks - SA

very much useful, thanks again

Thanks ridoy and will have a look

Thanks, was not straight forward for the window based environment.

I have switched to crystal report which is relatively easier to export taking the time constraint into account - this resolves the issue for the time being

Thanks Adam,

Apologies, if i have upset you in any means. I was struggling on this for last 4-5 hours without luck and hence my comment would have been short.

I have tried your suggestion and the method ServerReport.Render() does not accept null as the out put paramters,

would be thankful, if you could dig into for me

Looks this is for web based and am looking for windows.

I have already tried this without much sucess

what is in DBHelper?

Are you using style sheet ?

if so, please post the releveant section.

Could be your computer is low spec ?

Ok
Do you have the style sheet in a separate file or in the same file as in your HTML. if in a separate file, make sure your path is right.

if still no luck post your style sheet entries and will look into and revert later today

looks like you are missing the styleaheet (*.css) where the classes are defined like "wrapper"," "header" and etc
please clarify

My pleasure

Hope its a SQL serer database and what version of SQL servr ?

Have you thought about updatable database views ?

Thanks but its not the case

The windows RDP works on both LAN/WAN.

Are you saying that you do not want to user this but to develop a new applicaiton similar to this using c# ?

This may not work, please read my requirement careully

The challenge is, the web site is a third party web site and into which, we needs to input the release details(do not worry about what is release but records like students name, address & age) o about 200 records every day and takes 4 hours of a single staff causing delays.

We do not have any control over the web site / database ( its on java server pages) but have a login user name and password to input the data

The challenge is, the web site is a third party web site and into which, we needs to input the release details(do not worry about what is release but records like students name, address & age) o about 200 records every day and takes 4 hours of a single staff causing delays.

We do not have any control over the web site / database ( its on java server pages) but have a login user name and password to input the data

thanks ryanb31

http://msdn.microsoft.com/en-us/magazine/cc337896.aspx

looks usefull through poweshell but not sute untill proven

I am mainly looking to send key strokes (TAB to navigate between controls) and paste the text box values


looks promising http://stackoverflow.com/questions/7610558/how-to-automate-firefox-with-powershell

You can not have cross-database foreign key but can use triggers instead.

Basically, you needs to check the data validation on insertion using trigger and raise an error, if needed

Check the regional settings on both workstations and if am right, the pc displays error will have a different regional settings and date time format ?

Check and let me know pl

It should work for multiple lines and please check.

There is a usefull tip for performance boast when SqlDataAdapter update is to
set updatebatchsize=0 just above the update line and in your case


private void button3_Click(object sender, EventArgs e)
{
try
{
adpt.updatebatchsize=0
adpt.Update(ds);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

You may have to look at the extensions available for your requirement on both Joomla & wordpress and then decide which one to go for ?

where is your code ? post your code so that we can try and help you ?

How long it takes to run the query and get the results in query analyser ?

My understanding is that it does not work in the VB6 environment but works when directly executed on the SQl server ?

I suggest SQL agent not trigger.

You said you should be able to execute at time intervals like 10am ,10:30am, 11:00am... and etc.


If you are going to do by trigger then there has to be an INSERT/UPDATE/DELTE on the database at those times, in other words someone should be monitoring the time and trigger in manually which is not recommanded

In other hand, SQL agent can act like a scheduler and execute you commands at regular interval in its own as configured without manual intervention, in other words automatic

considering the above, i would recommand the automatic way - SQL Agent ?

Do you have a unique primary key on "ClassAdmin"

What you are trying to do and what is the error message you are getting ?

thats good

Thanks VJ

I think you are slightly confused with the way the c# .net frame work communicates with the server.

1.In your c# .NET client you have to open a SQL connection to the server with the credentials and when you open the connection the client establishes the connectivity to the server database

2.Now, for you to send the data, you will use something called SQL query / Stored Procedure as explained below in the solution 1. In the SQL query you will specifiy which text box data goes into which column of the database and you will sort of flush the query through the database connection so that the query will reach the database with the right value to the right column.

let me know, if you need any samples on this ? if this is one you are after ?

Are you saying that you have installed only the sql server management studio ?

Managament studio is just a tool to connect to the database and you should have the database instance installed for the management studio to pick it up ?

I think the order by clause for the row_number() should be DESC ?

what version of SQL server you are using ?

Are you saying that you have used "masked" text box for the password field and unable to retrive the value typed at run time ?

I would have throught the Text property of the masked text box will do ?

I would have thought, if you want to write into the SQL database in the server then
you may have to open a connection from the client to the database and use an insert SQL statement and not sure why you want to use "ClientStream"..Can you please go into more detail and tell us what you are trying to achieve please ?

Did a copy from your code and pasted in visual stuidio and it seems to be working ( lists nodes from "A" to "Z" each with subnode "?")

Can you please refine you question with the exact error message and at what point it happens ?

What specific version in SQL 2005 ? express / standard / enterprise ?

SQL Scheduled Job may be the asnwer for your question.

Having said that you are saysing its not shown. Can you please go into more detail and tell us what version of SQL server you are using ?

I am not sure whether the OP wants to do this at database level / in the presentation layer, my solution is based on the assumtpion at database level

The OP wants to merge the DataTable2 into Datatable1 and there are only three rows are to be merged in the first case.

Accepted the answer :)

Accepted the answer :)

5ed!

Thanks Naerling

Thanks Vladislav

The link you have provided is not working (not approved yet...).

I can think about a reason why its null, the way you are executing the stored procedure does not look right.

Execute the stored procedure as follows and it should work

exec SampleP1

Hi Please look at the solution updated under the heading "UPDATE 2 (After the comments)" and should work for you.

let me know the outcome

No probs

Thanks Mehdi, will try during the week end

5ed

Thanks Amir,

My solution is based on your suggestion anyway

Thanks Costica

What is your function input and outpur paramters and explain with some sample data

Are you able to post your code, if it is not in pages please?

:)
Its my pleasure

Thanks,

I have updated my solution under the heading UPDATE -1 (Solution 1), please let me know whether this helps you

So you have a primary key column called "ID" (Text Data type) in addition to the WPID column which needs updating in sequncial order.

My question to you is, you are saying you may have to insert new rows at times and when you insert new rows what will be the value for the "ID" column ? i know the value for WPID is the next number in the sequential order but what is the value for the "ID" column ?


Should be able to give you a solution once i get the answer to this question

May be use UNION not UNION ALL,

UNION ALL result set will have duplicate values, if you have the same Nom,Lien_Nom in more than one table but UNION will bring only the distinct

great 5ed

5ed

most probably there is no matching records in both tables for your join.

look at the link http://www.tizag.com/mysqlTutorial/mysqljoins.php which might give you an idea where you are going wrong in your query

what is your table structure ?

This does not work for me when i tried.

Am i missing something ?

You needs to give us more details, Its not possible to help you with the limited information you have given.

You needs to go into detail and say what you are trying to achieve and what you have done so far and what is the exact problem.

Without these, its not practical to help you

5ed

5ed

I understand Chuck,
:)

This has happened to me few times and know the feeling of working hard to give a solution and finally get downvoted and you would not know the reason & person.

some guys accidenlty downvote thinking that they are upvoting specially, if the are new to CP. Lower the downvote points its an accident.

Higher the downvote points, some one has done it purposely but if a genuine guy, should have reason for the downvote.

I do not normally downvote but if it has to then i give my little reason and its not me in this case :)

I strongly feel, if some one else's solution is better than my one then its better - i learn something every day and mine is a very tiny tiny contribution.

5ed and bookmaked too, nice one.

Chuck,

I personally prefer your solution, I truely do not know why the OP has accepted my solution and it could be that your solution was not posted (time delay) when the OP looked at / some other valid reason from OP's point of view which we do not know?

my5 for your solution

Albert,

Your commments makes sense and I personally prefer Chuck's solution, I truely do not know why the OP has accepted my solution and it could be that Chuck's solution was not posted (time delay) when the OP looked at / some other valid reason from OP's point of view which we do not know?



I really do not know & hope this is a constructive discussion.

May be ask the OP ?

vishnu

If you have a question, please use the "Have a question or comment" right below my solution and i will be notified by an email immediately but please do not post your questions as an another solution

CreatedDateTime is one of my column in the table employees with a sample date of "14 Jun 1990 12:47 AM" with time part.

the two CAST operations and FLOOR will remote the time part and make it for example "14 June 1990" which can be compared with your input date

Hope this helps

vishnu

If you have a question, please use the "Have a question or comment" right below my solution and i will be notified by an email immediately but please do not post your questions as an another solution

CreatedDateTime is one of my column in the table employees with a sample date of "14 Jun 1990 12:47 AM" with time part.

the two CAST operations and FLOOR will remote the time part and make it for example "14 June 1990" which can be compared with your input date

Hope this helps

Can you please post your connection string for me and also hope that the host is running on linux platform ?

also,please check

The default port number for the MySql Server is 3306 and you may have to make sure that this port is not blocked in your firewall

Out of interest, why do you want to update the primary key column and keep it as a continious number series ?

If does not needs to be.

updating the primary key column may defeat the idea the relational database when it comes to many table connected to your table. Are you going to update other tables too ?

well said

good to hear

If you could start at some thing and come back to us when you are stuck then its easier for us to help

Home work ?

Just posted an answer, please have a look and let me know wehther helps

What you are trying to achieve by (flag & mask) ? in the update statement

What happens when you directly run

SELECT * FROM procedures, applications WHERE procedures.Nom = applications.Nom

on the mySQL ? also what is the mySQL version you are using ?

Nice to hear :)

You have mentioned that when you do the join operation the query does not work / does not bring any results ?

If so, where it the query combining four tables ? and what do you mean by does not work ? any error messages / it does not bring any data ?

5ed

My 5 for the suggestions

My 5 for the suggestions

I have answered your question and please check

web / windows / wpf ?

We can help you, if you have tried something and struck,

Please let us know what you have done so far and where you are stuck ?

What menon suggested whould work.

1. How did you install the font in the first place ?


if you have installed the font correctly then the following link should help you how to change the input language

http://www.conversationexchange.com/resources/keyboard-language.php>/a>

I am not very clear about your requirement, i know you have pur some example for the first solution but, can you define what you want to do with examples likw what are the input values and what do you expect as an output please ?

Ganu

Just my thoughts

Probably your where clause should be otherway round

between CONVERT(varchar, DATEADD(MONTH, -6, TimeRecorded)) and CONVERT(varchar, GETDATE())

the lower value should be first in the between & and operator; also consider what will happen if you have the time element in the TimeRecorded data column

Thanks Espen,

yes my main worry is partially connected scenario. Thanks for the suggestion and i will dig into and see

Thanks BobJanova

Thanks BobJanova,

Sorry, i was not very specefic and have updated my question under the heading of "UPDATE 1" and hope it makes more sense now.

Please let me know what do you think the best way forward please

lol thriller movie....i am still laughing :)

it depends on the User interface, how do you have books and the categiries implemented in the UI? and what do you have done so far ?

Please let us know how far you have proceeded on this and the place where you are stuck with the error message you are getting.

This way its much easier to assist you please

thanks Amir

thanks amir

I agree with Amir and the excel charts with little bit of VBA should help

nice links 5ed

Its hard to figure out what exactly you need by looking at the lengthy datasets, explain in simple terms and clearly what you need

do you have the datagridview placed in a tab controller ? Could you explain a bit wehther the datag grid view is data bound or not and also at what point this happens ?

Provide more info...Without details, its hard to help you

My pleasure

May be your stored procedure takes more time to complete the execution and the client is timingout.

You will have to look ways to optimise, can help you if you could post your stroed procedure

Great, perfect solution my5

My pleasure