15,895,084 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 abdussalam143 (Top 37 by date)
abdussalam143
23-May-16 10:24am
View
please check it now i have update it
abdussalam143
23-May-16 2:49am
View
No Still finding a solution.
abdussalam143
23-May-16 2:49am
View
my question is if i pass value in cursor query it work fine but if i pick value from query then it keep executing query for infinite time..
abdussalam143
23-May-16 2:47am
View
it is running fine outside of procedure..
abdussalam143
28-Oct-14 3:36am
View
are you using asp.net of is it on windows form
abdussalam143
10-Oct-14 4:09am
View
it is hosted on dedicated server with different domain name i have control on IIS.
abdussalam143
2-Apr-14 7:00am
View
thanks for your help buddy
abdussalam143
2-Apr-14 1:46am
View
i use this to connect
Data Source=ABDUSSALAM;Initial Catalog=edustarsDBwithFeesPayments;User ID=sa; Password=123123;
ABDUSSALAM is my server name
Failed to connect to server Data Source=ABDUSSALAM;Initial Catalog=edustarsDBwithFeesPayments;User ID=sa; Password=123123;
abdussalam143
1-Apr-14 9:25am
View
i also tried these two
string conn = "Data Source=192.168.0.14; Initial Catalog=edustarsDBwithFeesPayments;User ID=sa; password=123123;"
and
string conn = "Data Source=192.168.0.14,1433; Initial Catalog=edustarsDBwithFeesPayments;User ID=sa; password=123123;"
abdussalam143
14-Mar-14 8:27am
View
i think dataset is empty or try it like
gvtraining.DataSource = ds[0];
abdussalam143
14-Mar-14 8:25am
View
do you have any code that you have tried
abdussalam143
13-Mar-14 2:37am
View
did you try some thing.
abdussalam143
12-Mar-14 7:26am
View
i need date and time both coz some time time also come in the parameter coz it is search proc for event log
abdussalam143
12-Mar-14 7:26am
View
if i convert it in varchar or nvarchar it reacts like string not date time.
abdussalam143
12-Mar-14 5:39am
View
protected void Application_BeginRequest(object sender, EventArgs e)
{
System.Globalization.CultureInfo newCulture = (System.Globalization.CultureInfo)System.Threading.Thread.CurrentThread.CurrentCulture.Clone();
newCulture.DateTimeFormat.ShortDatePattern = "dd-MMM-yyyy";
newCulture.DateTimeFormat.DateSeparator = "-";
System.Threading.Thread.CurrentThread.CurrentCulture = newCulture;
}
i use this code to set date format
abdussalam143
12-Mar-14 5:36am
View
both values declare as datetime
abdussalam143
12-Mar-14 5:27am
View
how could i make this changes in shard hosting.
abdussalam143
6-Mar-14 7:00am
View
are you getting some error or code runs smoothly
abdussalam143
27-Dec-13 8:28am
View
i thing you change your file name after creating it. please delete it and create new file with different name place same code in it.
abdussalam143
27-Dec-13 8:26am
View
if you try some thing then please put your code here.
abdussalam143
7-Nov-13 0:56am
View
Dharmenrda Kumar Singh Nice work you save my lot of time
abdussalam143
12-Sep-13 8:30am
View
agreed
abdussalam143
12-Sep-13 8:18am
View
yes you are right NULL is also non integer value but the main reason is conversion failed
abdussalam143
31-May-13 9:06am
View
as i consider you want to display all records of paymentDetail with client and address detail am i right
or
please add some discribtion some sort of record you want to get like blow
clientId | addressid | paymentid
1 | 12 | 101
2 | 13 | 103
1 | 12 | 102
abdussalam143
31-May-13 8:57am
View
we can not make project for you please ask if you have any error in it
abdussalam143
31-May-13 4:08am
View
the solution you marked is paging not sorting
abdussalam143
16-May-13 5:15am
View
if i am in this condition then i use datalistview instead of grid view.
abdussalam143
16-May-13 5:10am
View
can you provide some code its difficult to under stand with this short description.
abdussalam143
16-May-13 5:03am
View
If I am Help full for any one its a big pleasure.
abdussalam143
10-May-13 8:09am
View
First Create this Procedure
CREATE PROC [SubscriberT_Insert]
@msgCode AS INT OUTPUT,
@email AS VARCHAR(MAX)
AS
DECLARE @isPresent INT
SET @isPresent = (
SELECT COUNT(*)
FROM SubscriberT
WHERE email = @email
)
IF (@isPresent <= 0 )
BEGIN
INSERT INTO SubscriberT
(
email
)
VALUES
(
@email
)
SET @msgCode = 1
END
ELSE
BEGIN
SET @msgCode = -1
END
Then Call it from Your Code and here is the Code
Private Function AddData(email As String) As Integer
Dim msgCode As Integer = 0
Try
Dim cmd As New SqlCommand("SubscriberT_Insert")
cmd.Parameters.AddWithValue("@msgCode", msgCode).Direction = ParameterDirection.Output
cmd.Parameters.AddWithValue("@email", email)
cmd.CommandType = CommandType.StoredProcedure
Using con As New SqlConnection("Connection Will go Here")
con.Open()
cmd.ExecuteScalar()
msgCode = Convert.ToInt32(cmd.Parameters[0].Value.ToString());
End Using
Catch ex As Exception
msgCode = -99
End Try
Return msgCode
End Function
this Function Will Return Inger Number
"1 = Record Added Successfully"
"-1 = Record Already Exist"
"-99 = Some Error Occurred"
abdussalam143
30-Apr-13 8:13am
View
what do you mean by index? Identity column ? or some thing else
abdussalam143
30-Apr-13 8:06am
View
Please Add more Description
abdussalam143
30-Apr-13 0:18am
View
actually this is client requirement. he ask to do this and put an example of www.deviantart.com
abdussalam143
27-Apr-13 4:02am
View
Marks As Answer if it Help You for others help
abdussalam143
26-Apr-13 3:33am
View
Please Give More Description What You Want To Do.
abdussalam143
25-Apr-13 9:04am
View
this is for web forms not for win forms you did not mention it in question before wait i will update it
abdussalam143
23-Apr-13 6:36am
View
Iwant to do it on C# asp.Net WebForms not on "Python" sorry did not mention in question but i have update it now
Show More