Comments by abdussalam143 (Top 37 by date)

it is hosted on dedicated server with different domain name i have control on IIS.

thanks for your help buddy

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;

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;"

i think dataset is empty or try it like
gvtraining.DataSource = ds[0];

do you have any code that you have tried

did you try some thing.

i need date and time both coz some time time also come in the parameter coz it is search proc for event log

if i convert it in varchar or nvarchar it reacts like string not date time.

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

both values declare as datetime

how could i make this changes in shard hosting.

are you getting some error or code runs smoothly

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.

if you try some thing then please put your code here.

Dharmenrda Kumar Singh Nice work you save my lot of time

agreed

yes you are right NULL is also non integer value but the main reason is conversion failed

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

we can not make project for you please ask if you have any error in it

the solution you marked is paging not sorting

if i am in this condition then i use datalistview instead of grid view.

can you provide some code its difficult to under stand with this short description.

If I am Help full for any one its a big pleasure.

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"

what do you mean by index? Identity column ? or some thing else

Please Add more Description

actually this is client requirement. he ask to do this and put an example of www.deviantart.com

Marks As Answer if it Help You for others help

Please Give More Description What You Want To Do.

this is for web forms not for win forms you did not mention it in question before wait i will update it

Iwant to do it on C# asp.Net WebForms not on "Python" sorry did not mention in question but i have update it now