Comments by S. M. Ahasan Habib (Top 113 by date)

you are most welcome!

create proc GetBooks(@SId int)
as
begin
SELECT
L.LId
,L.SId
,S.SName
,L.BId
,B.BName
,L.Land_Time
FROM Lend_Details L
INNER JOIN Student_Details S ON S.SId = L.SId
INNER JOIN Book_Details B ON B.BId = L.BId
WHERE L.SId = @SId;
end

yes! just added some description and inner word which is little readable. Though the guy said he is new in sql so i think readability might help and he might not confuse with inner/left/right join.

Reason for my vote of 5 \n Nice tip!

You need to follow some steps to create mock object
step1> Download rahno mock dll from the above link (which i provide in solution section)
step2> Add that Rhino.Mocks.dll to your .net test project
step3> where you need to create mock object you use GenereteStub<t> method of MockRepository class. It will create mock object for you.
step4> Inject that mock object to your test class.

The article may help you
http://www.codeproject.com/Articles/686935/Unit-testing-with-Mock-objects-Rhino-Mocks

thanks!

thanks! i update my solution.

thanks

It might be user browser setting issue. So i suggest to request client to check his browser setting regarding popup display.

Reason for my vote of 5 \n Thanks for sharing!

thanks!

Please provide structured xml with sample 1 or 2 data. suppose <root><elements><element>1<element>2. It will help audience to understand your xml data structure and answer your question more easily. No need to show huge data as a part of question. Remember that in xml data/schema structure is important for programming. data is not important for solve problem. It is client asset.

dynamic sql context is different. If you check the following code
declare @sql nvarchar(max) = 'create table #MyTable(id int);insert #MyTable(id) values(1);select * from #MyTable;';
exec sp_executesql @SQL;

You will see that it is working and everytime it is created #MyTable temporary table. If its connection was same then it would throw exception like #MyTable is already exists. But in above case it is not throwing any exception(i am not droping that #MyTable).
Another finding is if you run the following code
declare @sql nvarchar(max) = 'create table #MyTable(id int);insert #MyTable(id) values(1);select * from #MyTable;';
exec sp_executesql @SQL;
select * from #MyTable;
then you will find a exception from the last line of the tsql code. "#MyTable not exists". That means dynamic sql execution context and current context are not same.

Yes it is possible but that type of huge triggers management might be difficult and create maintenance overhead. My suggestion is try to do it from your application logic/business logic layer with proper object oriented programming. It will help you to keep simple to your databases.

Reason for my vote of 5 \n Nicely explain!

asp.net is web development platform. c sharpt is a programming language. the full form of asp is Active Server Page. Before .net comes Asp was the microsoft web development platform. Now it is asp.net. You can create Page, HttpHandler, HttpModule etc are the part of the asp.net web platform. When you use/develop/create that items you need to use programming language. Besides web development, you can use c# for windows/wpf development also.

Reason for my vote of 5 \n Nicely explain

Reason for my vote of 5 \n thanks for your tips. If you describe what type of problem you solved with implementing this interface will be helpful.

I copy your markup and added it to my solution and found it is working as you expect(after enter email to the first textbox it will postback to the server). Only that thing is different from my code.
Your mark-up top line is
<%@ Page Language="C#" AutoEventWireup="True" Inherits="SubmitPage" Codebehind="SubmitPage.aspx.cs" %>
in my case it is
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %>
In my test project it is .NET framework 4.5 with visual studio 2012.
I request you to check the Inherits property to your markup top line. It must be same as your code behind class name (namespace.classname is actual format).
Another thing you can do
Just remove all code and add a single textbox there and check it is working or not. If works then add more control and check. Better you create another aspx page and do rnd there with that way. Hope you can solve the problem. Just be confident that code is fine(your code is working in my side).

Please show your mark-up code. Also need to know any client side validation logic exists which prevent form being post back to server.

Sorry for not clear. if you build that project, you will find exe(ex a.exe) file (suppose you create a console app). So then you go that file location(ex d:\projects\a.exe) and double click on that for executing. Let me know still you are confused.

Run sql server profiler and see what sql execute to the database. Peek that sql from profiler and open that to management studio. Analyze and test that sql. Hopefully you will identify your problem.

what type of error you found. Is it compile time or run time? Please write detail about errors. for example if it is compile time then what compiler says. if it is run time then what exception it throws and exception message etc.

Let me know if any issue you face.

Please write your mail address here. I will send my project.

I agree that auto increment number should be generated from database either auto identity or sequence number or auto generated guid. Otherwise concurrency issue might be there. Here just i implement the solution that ask for(based on datetime and new number sequence).

what type of error you are finding. Error detail information need to show here.

Reason for my vote of 5 \n Nice work!

thanks

i tried with this and it is working for me!
my database part:
--my table
create table MyTestTable(Id uniqueidentifier, Name varchar(50));
go
--my sp
create proc testsp
(
@id uniqueidentifier
,@Name varchar(50)
)
as
begin
insert into MyTestTable(Id, Name) values(@Id, @Name);
end
go

and my application code

string spName = "testsp";
var _ID = Guid.NewGuid();
SqlParameter[] spParams = new SqlParameter[2];
spParams[0] = new SqlParameter("Id", _ID);
spParams[1] = new SqlParameter("Name", "A");
var connString = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString;

using (var conn = new SqlConnection(connString))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = spName;
cmd.Parameters.AddRange(spParams);
cmd.ExecuteNonQuery();
}
}
I used raw ado.net and it is working for me. I do not know about your SqlHelper class and its method ExecuteDataset. If anyway you can not find any solution you use raw ado.net code in that area only just like i show it here.

web.config/app.config keys are case sensitive. Please check that. Other then that you should retrive config value with the above sample code.

Sorry no idea about Visual Foxpro.

you can change in powershell connection string and run it from your local. It will fetch data from remote database server based on your connection string and store it to your local pc. You just go the link above create a powsershell script (.ps1 extention) and dump that code to your file and update with your connection string. Then go to windows powershell tool, execute that see the result. As simple as that. I think you will impress with power shell power.

You should bind ddlCity in ddlState selected index changed event not page load event. Now from the save button click event you set break point to ddlState.SelectedValue and ddlCity.SelectedValue and see its value as the expected value found there or not.

Show you code where you handle selected index change event, where you handle page load event and save event. Need to see where you bind your ddlState dropdown. My guess is when you press save button at the moment ddlState dropdown may be rebind if you not use page.IsPostBack property.

If it is sqlserver expressed then you just first login it with management studio with windows authentication then you can active sa (system administrator) user and set its password or you can create another user(login,user) then set it to crystal report

No way you can access client file system. What it you can do is, then it will automatically saved download folder without asking client to give location.

Based on both record set what will be the final result set? Based on what criteria you want that? Please clarify that. Without that your question will be unclear to us.

Sorry! I have no example in my hand at the moment. How to use progress bar i find a url
http://www.dotnetperls.com/progressbar
Just remember that database stored procedure execution is time is no deterministic and when it will finish you did not know. So you can not set any perfect progress bar end result. You need to use trick here.

Seems you write the serverside method in the Masterpage. You must write it to Page codebehind. Event if you write that webmethod to the user control then it will not work. So you just create a page, then take ScriptMangager referenece to that page(either you do not take reference it from masterpage) then call webmethod which is written in that page code behind.

You set full permissions to Everyone(default user/group) at your directory and check it is working or not.

You need to show your 2 drop down's html markup and page_init/load event where you bind/populate your dropdown controls and how will you handle selectedIndexChanged event.

I guess you have multiple sql server instance installed in your pc. you can check it to go to windows services viewer and see how many sql server services found there. You can get specific instance from your code and management studio and then execute the query. The query will return database names from that particular instance. I guess you are facing the problem is create database is one instance and connect to other instance and search that database.

you execute SELECT * FROM sys.Databases query from your sql server management studio and see the results. If there you do not find your database name then let me know.

this is product number

which line of code you got this error? I need to address the actual statement where it throws.
Please visit the link. It will help you
http://stackoverflow.com/questions/2011214/problem-to-convert-byte-array-to-double

Thanks. If solution will help to solve your problem then you accept it as answer.

DGv_session object structure create little confusion to me. Instead of assign value to existing session grid view DGv_session. I suggest you create a new DataTable inside the loop and store that session if you need letter on and assign that to any gridview for display purpose.

yes you can use .cs files methods. please visit the link for example
http://unboxedsolutions.com/sean/archive/2005/11/05/787.aspx

no matter where database stored where c: or d: or other drive. Application just connect to its database and execute its query. Database files(MDF,LDF) is hidden from application. So no problem will raise for that.

You can store user specific data to your database and user wise fetch that data and set it to the textbox. If your datasource has non user specific data then you need to transform it to your business layer and display it to the page text box.

Please showup your code though we can clearly understand your problem.

You just start study on that then in web you can find so many code sample. You can start from the following link.
http://www.codeproject.com/Articles/17203/Using-jQuery-for-AJAX-in-ASP-NET

Please visit the link
http://stackoverflow.com/questions/2965837/insert-statement-conflicted-with-the-foreign-key-constraint

Actually it is data relation establishment problem(database issue, your application code is ok). You just execute sp from your sql server management studio with parameters which you passed from your web application and easily address/solve the problem. You can find the parameters value easily if you run sqlserver profiler and track the spcalling from web application.

Waiting for your feedback.

Actually i show up an example. You can change it and execute it with stored procedure the code like
string spName = "usp_InsertMyTable";
var cmd1 = new SqlCommand(spName , conn);
cmd1.CommandType = CommandType.StoredProcedure;
//Add paraters to the cmd1 command
cmd1.ExecuteNonQuery().

welcome

Plese show your code though we can understand your problem better.

http://www.codeproject.com/Articles/476967/WhatplusisplusViewData-2cplusViewBagplusandplusTem

Instead of button click event you can do it Form_Load event.

One very good link added to the solution. Please check and hope it will help you more.

you can execute "GRANT select ON myTB TO user2" query from your sqlserver management studio. After that your application can access that table. Again that type of permission query, better you can execute inside database(enterprize manager) context.

If you write business logic inside controller action then no body can protect you, in that case you can call action testing as functional testing, but it will violated of mvc design pattern principle. So functionality should be inside Model/Business component and Model test will be called functional testing. (again my personal opinion)

You just logged in user2 instead of user1 and execute that query.

Yes. You can check with
declare @dt datetime = '01-Jan-2013';
select (DateAdd(mm,-1,@dt))
You can use the filter like
select day(DateAdd(mm,-1,getdate())), month(DateAdd(mm,-1,getdate())), year(DateAdd(mm,-1,getdate()))

Please show your webmethod code and exception line where null reference exception raised. You can easily debug that code and identify that area.

Please use the following code and try once again.
System.Net.ServicePointManager.ServerCertificateValidationCallback = (s, certificate, chain, sslPolicyErrors) => true;

Please check your smtp server from where mail will send and check the ssl port you are using to send mail. It is better to take any Network guy who can understand the ssl port/configuration issue of smtp server. Though you are not past your code, I hope your code is ok.

wecome:)

Open sql server enterprise manager and add/select windows user and give permission for that user to appropriate database user, user objects like(table, view, stored procedure) with appropriated permission like create/read/delete/drop/execute etc.

Please upload your markup code. When you bind your grid with data source then do you conditionlly bind that like If Page.IsPostBack?

Please show the exception lines and message though i can address the problem.

If you not sure which version webservice used then go trial and error basis. First go with 1.1 version from your client config file, if not working then go 1.2 version.

you are most welcome.

one minor bug was there. tabIndex datatype was string. When use tabIndex + 1 it actually concate 2 strings. I update that with parseInt(tabIndex) + 1 and fix the issue. Just one thing remember that when you assign tabIndex you start from 1 and it should be cronological order. Like 1, 2, 3 etc. In your code i see 1,2,4. You just change that and rerun your code.

One thing i corrected that is (typeo) evt instead of event. Now try again. Just make sure that markup(html) attribute is you assigned. What type of error you found?First check it to firefox. Then go for other browser as well.

Pls check it again, I update the code and test it and found it is working.
BEGIN
DECLARE @CAMP VARCHAR(2)
DECLARE @TYPE VARCHAR(10)
SET @TYPE='sdfas';
SET @CAMP='asdfasd'
DECLARE @QRY NVARCHAR(300)
SET @QRY='SELECT * FROM [dbo].[Target] WHERE (1=1)';
IF(@CAMP<>'')
BEGIN
SET @QRY=@QRY+' AND FirstName='''+@CAMP + '''';
END
IF(@TYPE<>'')
BEGIN
SET @QRY=@QRY + ' AND LastName= '''+@TYPE + '''';
END
EXEC SP_ExecuteSql @QRY;
END

I provided solution for that problem too. Please visit that link which you mention above and make sure it will work for you.

provide links inside solution. Please read it again.

yes one typeo is there evt will be there instead of event. I update your question. Please read it again and execute it firebox now and see the result. I tested it in firefox and found that it is working.

update solution. You just read it again.

So if you want to solve it with all browsers then you use this statement instead of just return false.
event.preventDefault ? event.preventDefault() : event.returnValue = false;

FileNotFoundException raised when file not found to a specific location. So I guess your file_path value is wrong. You just debug the code and see the value of file_path and find out that the file physically exists in this location (file_path).

instead of return false you should use
event.preventDefault ? event.preventDefault() : event.returnValue = false;

I already update your method IsNumericKey now it will work. Please Re run your code.

That will not create any problem. Anything else you found?

you need to debug the code and address which line of code throw InvalidOperationException and capture exception details and post that.

Why web config file refresh/reloaded is needed? If anything add/modify/delete any data in web.config file the web.config file cache automatically expired with app pool recycled. Please review your problem before go for solution.

Then make sure datacontract class dll reference in your project. DataContract class dll need to refer to your project, otherwise it do not find that datacontract class.

What type of problem you face to crate instance of ArithmeticClient datacontract object? Any compilation error? Please post error details.

What is you question?

I never work with OpenOffice spereadsheet. But the way you luch ms excel same way you can lunch OpenOffice. Just you find out what the main executable file name and location, After getting that you send that path to the System.Process.Start methods as argument.

Just post your code. You may debug the code and find out the line/object where object reference null found. If you identify object which is throwing null reference exception, hope you can solve it by your own.

Reason for my vote of 5 \n Nice!

Reason for my vote of 5 \n Nice!

I checked it by assigning txtId.Text ="hi" from form load events and found it is working.

Then you need to assign that controls value with other events like OnInit,OnLoad,OnPreRender etc, not inside DayRender event.

thanks for your comment. Added exception handling and transaction block.

Instead of jScriptArray[i] = array[i]; you will use jScriptArray.push(array[i]); in your code and it will work.

Question not clear. What do you mean by api fun?

Reason for my vote of 5 \n Nice tips!

Reason for my vote of 5 \n Nice!

Reason for my vote of 5 \n Nice!

Reason for my vote of 5
Very helpful tips. Thanks for sharing.