15,917,328 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by mudgilsks (Top 39 by date)
mudgilsks
20-Jul-18 0:37am
View
thanks, duplicate solution has been removed.
mudgilsks
5-Jan-15 0:19am
View
thanks andreas for your guidance.
mudgilsks
19-Dec-14 3:26am
View
which version of sql server you have use.
mudgilsks
18-Dec-14 23:39pm
View
Improve you Question
add create table script and alter view script that you want to alter.
after that i will check the error
mudgilsks
18-Dec-14 8:38am
View
what is BISA1.EMPLOYEE_DETAILS_VIEW
use EMPLOYEE_DETAILS_VIEW only
mudgilsks
15-Dec-14 1:41am
View
hi,
right, use for loop for each row of the grid view.
after that if you face problem,you can mail your page on:mudgilsks@gmail.com
after checking i will resend back to you.
mudgilsks
11-Dec-14 0:24am
View
Dear Thrilok ,
same issue was also with our Database Server.In starting we think it issue related to machine.We lock a issue compalian to the concern vander but no issue was their with machine.After that we lock issue complain to the Micro-soft Sql Server,they check the server,analysis the problem and in last was that sql server using the full CPU memory.they set the Limit for Sql Sqrver CPU utilization.after that our problem sol.
Try to find out How to set Limit For Sql Server.
mudgilsks
11-Dec-14 0:13am
View
improve question,it is not clear where you stuck.
as i understand your problem is related to AutoPostBack of controls set value to "False"
mudgilsks
10-Dec-14 23:55pm
View
Improve question,it is not clear ,where u stuck
mudgilsks
10-Dec-14 1:28am
View
please Improve your question
mudgilsks
9-Dec-14 2:40am
View
when you adding value consider '' as 0
take value in variable ,check if they '' when 0 then add values
mudgilsks
9-Dec-14 1:35am
View
if your table is dynamic then you first take query output in temp table after that use it as normal like this
SET @SQL = 'SELECT ' + @PAIDSTATUS + ' = PAIDSTATUS into ##temp FROM '+ @DATABASES +'.DBO.sometablename WHERE ROLLNO=''' + @ROLLNO +''''
PRINT (@PAIDSTATUS)
EXEC (@SQL)
seelct @PAIDSTATUS = PAIDSTATUS from ##temp
mudgilsks
8-Dec-14 23:52pm
View
where you stuck.
mudgilsks
8-Dec-14 23:48pm
View
is able to get the concern popup
id
mudgilsks
8-Dec-14 7:23am
View
< a
href="userdetails.aspx" class="">
<img src="imagePath" alt=" style="border:0px solid red; vertical-align:middle" />
mudgilsks
8-Dec-14 7:22am
View
Deleted
"
<img src="imagePath" alt=" style="border:0px solid red; vertical-align:middle" />
"
mudgilsks
8-Dec-14 7:13am
View
sir if your problem sol then give rating to solution
mudgilsks
8-Dec-14 6:41am
View
try this
<script type="text/javascript" src="http://www.google.com/jsapi?key=YOURKEY"></script>
<script type="text/javascript">
function geoTest() {
if (google.loader.ClientLocation) {
var latitude = google.loader.ClientLocation.latitude;
var longitude = google.loader.ClientLocation.longitude;
var city = google.loader.ClientLocation.address.city;
var country = google.loader.ClientLocation.address.country;
var country_code = google.loader.ClientLocation.address.country_code;
var region = google.loader.ClientLocation.address.region;
var text = 'Your Location<br /><br />Latitude: ' + latitude + '<br />Longitude: ' + longitude + '<br />City: ' + city + '<br />Country: ' + country + '<br />Country Code: ' + country_code + '<br />Region: ' + region;
} else {
var text = 'Google was not able to detect your location';
}
document.write(text);
}
geoTest();
</script>
more details:
http://www.adammcfarland.com/2009/11/19/simple-ip-geolocation-using-javascript-and-the-google-ajax-search-api/
mudgilsks
8-Dec-14 6:36am
View
try this
<script type="text/javascript" src="http://www.google.com/jsapi?key=YOURKEY"></script>
<script type="text/javascript">
function geoTest() {
if (google.loader.ClientLocation) {
var latitude = google.loader.ClientLocation.latitude;
var longitude = google.loader.ClientLocation.longitude;
var city = google.loader.ClientLocation.address.city;
var country = google.loader.ClientLocation.address.country;
var country_code = google.loader.ClientLocation.address.country_code;
var region = google.loader.ClientLocation.address.region;
var text = 'Your Location<br /><br />Latitude: ' + latitude + '<br />Longitude: ' + longitude + '<br />City: ' + city + '<br />Country: ' + country + '<br />Country Code: ' + country_code + '<br />Region: ' + region;
} else {
var text = 'Google was not able to detect your location';
}
document.write(text);
}
geoTest();
</script>
more details:
http://www.adammcfarland.com/2009/11/19/simple-ip-geolocation-using-javascript-and-the-google-ajax-search-api/
mudgilsks
8-Dec-14 6:17am
View
kindly see the below example
function ValidateAmount(Id, amount) {
var k
var grdId = document.getElementById("rep1__ctl1_grvStudentDetails").id
var ParamenterAmount = document.getElementById("rep1__ctl1_Hiddenamount").value
var amount =0
var gvDrv = document.getElementById(grdId);
for (i = 1; i < gvDrv.rows.length-1; i++) {
var cell = gvDrv.rows[i].cells;
amount =amount+ parseInt(cell[1].all[0].value);
}
if (amount > parseInt(ParamenterAmount)) { return false }
return true
}
mudgilsks
8-Dec-14 6:15am
View
server side
mudgilsks
8-Dec-14 6:09am
View
use for loop for grids each textboxs by pass the id of each textbox
take values in a variable with checking value <>''
mudgilsks
8-Dec-14 5:47am
View
you have to give the path of folder on server in which you upload file.
mudgilsks
8-Dec-14 3:29am
View
adding textbox value --right
next what is the role of checkbox and dropdown --Not Clear.
mudgilsks
7-Dec-14 23:46pm
View
can you explain the actual flow,what you want in code.
mudgilsks
7-Dec-14 3:32am
View
Hi,
Check firewall setting to check is port open or not.
Installed antivirus may block sending of mail.
mudgilsks
7-Dec-14 2:38am
View
Deleted
Hi,
can u give full requirements you may send it on my email-
mudgilsks@gmail.com
mudgilsks
6-Dec-14 8:36am
View
When you store data to a VARCHAR(100) column, the values are physically stored in the same way. But when you store it to a VARCHAR(MAX) column, behind the screen the data is handled as a TEXT value. So there is some additional processing needed when dealing with a VARCHAR(MAX) value.
see the below
1. You can create an index on the fixed length column but can not create on the nvarchar(max) column. If you are using the column in where clause in your queries the you should always use fixed length column instead of nvarchar(max). This should be enough to use the nvarchar fixed lengthcolumn. I will specify others as well. However, index key length allowed is 900 bytes. Thus any nvarchar column which will exceed this value will cause issue and will be failed.
2. Memory grant could be a big issue where the server is already memroy starved.As expected row size is more the optimizer will
estimates more memory grant and this value will be much higher than actual required and this would be a waste of a resource as precisous as memory.
If you have couple of queries which are using nvarchar(amx) column and sorting is needed then server might have memroy related issues.
This could be a big perf issue.
3. You can not create the indexes online when the table or index has the nvarchar(max) column.
alter index all on nvarcharmax
rebuild with (online=on)
mudgilsks
6-Dec-14 8:25am
View
hi,
Problem is that when you use execute the below query
select * , ROW_NUMBER() over (order by AlbumName) as 'RowNumber' into #OrderedOrders from dbo.CountryAlbums where SubCategoryName = 'Rockabilly'
it returns 2 record with sr no 1 and 2 because you have only 2 row contains SubCategoryName name as Rockabilly and in 2nd query you have give RowNumber between 5 and 10 ,so only RowNumber between 1 and 2 will come.
try this
mudgilsks
6-Dec-14 6:06am
View
modify this code according to your reqirment
mudgilsks
6-Dec-14 4:52am
View
can u explain with code
mudgilsks
6-Dec-14 2:45am
View
what exectly your requirment???????
mudgilsks
5-Dec-14 22:01pm
View
Hi das,
Before 2 year we aslo use Sql2005 with Windows server 2003,after that we upgrarded to Sal2008r2 and Windows server 2008 R2.
Now we need move to Sql2012 and Windows server 2012.
So my opinion to you use Sql2012 And Windows 2012
mudgilsks
5-Dec-14 8:15am
View
What exactly are you asking? This is not clear.
mudgilsks
5-Dec-14 5:41am
View
Dim grvStudentDetails As GridView = DirectCast(FindControl("grvStudentDetails"), GridView)
Dim dtCostCenterviewState As New DataTable()
Dim drCostCenter As DataRow = Nothing
dtCostCenterviewState.Columns.Add(New DataColumn("RowNumber", GetType(String)))
dtCostCenterviewState.Columns.Add(New DataColumn("gl_id", GetType(String)))
dtCostCenterviewState.Columns.Add(New DataColumn("cost_center_desc", GetType(String)))
Dim drCurrentRow As DataRow = Nothing
Dim drCostCenterCurrentRow As DataRow = Nothing
'If dtCurrentTable.Rows.Count > 0 Then
Dim i As Integer = 1
Dim grdCostcenter As GridView = DirectCast(FindControl("grdCostcenter"), GridView)
'Dim j As Integer = 1
For Each rowCostCenter As GridViewRow In grdCostcenter.Rows
Dim cost_center_desc As Label = DirectCast(rowCostCenter.FindControl("cost_center_desc"), Label)
drCostCenterCurrentRow = dtCostCenterviewState.NewRow()
drCostCenterCurrentRow("RowNumber") = 1
drCostCenterCurrentRow("gl_id") = 1
drCostCenterCurrentRow("cost_centre_id") = cost_center_desc.Text
'j = j + 1
dtCostCenterviewState.Rows.Add(drCostCenterCurrentRow)
Next
'' ViewState("CurrentCostCenterTable") = dtCostCenterviewState
Session["GridData"] =dtCostCenterviewState '' ViewState("CurrentCostCenterTable")
Response.Redirect("ReciveChallan.aspx");
dim dt as datatable= Session["GridData"]
Try this
mudgilsks
5-Dec-14 5:16am
View
Deleted
hi,
As I understand your problem you want to insert
selected user with selected Modules
insert into Assign_Modules(empl_ID,Module_ID)
Select empl_ID,Module_ID from employees,Modules where Module_ID in (selected_Module_ID ) and empl_ID in (selected_empl_ID)
mudgilsks
5-Dec-14 5:03am
View
Deleted
Hi,
As I understand your problem
kindly remove ReadOnly="true" Property
Use like below
<itemtemplate>
<asp:TextBox ID="challanNo" runat="server"
value='<%#Container.DataItem("challanNo") %>'>
Try this.
mudgilsks
5-Dec-14 1:51am
View
Use DESC in order by clause or Use ROW NUMBER BY PARTITION Feature
mudgilsks
5-Dec-14 1:16am
View
Problem is that I am not able to get Reporting Server Credential.
My VB.NET application also uses the same DB server that is defined in web.config file.
Me.ReportViewer1.ServerReport.ReportServerCredentials = New ReportServerCredentials(reportserverUserName, reportserverPassword, domainname)
Problem in getting reportserverUserName, reportserverPassword and domainname
Thanks RyanDev
Show More