Comments by tranesyasd (Top 45 by date)

i tried to use my grid using findcontrol method the same error appear

the datatable return value the problem is when i use the grid in the method it be null i donot know why?

can any one answer me please ?

thank you very much

thank you very much

come from the difference between the DatTime.Now and the lastReply
if the datetime.now is 17-06-2015 09:00:00 and the lastReply is 15-06-2015 08:00:00
the result be like this (2d 1h)

thank you very much
but if i need to get the last reply like this (1d 10h) of (1h 15m) instead of the date itself (15-6-2015)

SELECT distinct dbo.Documents.DocName, COUNT(*) over () AS [numOfReplies],max(dbo.Replies,replyDate) as [lastreply]
FROM dbo.Documents INNER JOIN
dbo.Replies ON dbo.Documents.DocumentID = dbo.Replies.DocumentID INNER JOIN
dbo.Users ON dbo.Documents.SendTo = dbo.Users.UserID
WHERE (dbo.Users.UserID = 1)
GROUP BY dbo.Documents.DocumentID

thank you very much
it is working

if you have example or demo to create my own control please tell me
thank you

please tell me how can i do that ?
thank you

tokeninput is a plugin control i added it but how can call the function above in this control ?

like the control in this link :

http://loopj.com/jquery-tokeninput/

i did that :)

i added this code in c# :
DataTable tvp = new DataTable();
tvp = dtexcel;


using (cn)
{
SqlCommand cmd = new SqlCommand("dbo.InsertMyDataTable", cn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter tvparam = cmd.Parameters.AddWithValue("@dt", tvp);
tvparam.SqlDbType = SqlDbType.Structured;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
and work correctly without any duplicate
thank you very much zoltan zorgo

it's working
thank you very much

Must declare the scalar variable "@dt"

i create stored procedure like this :

CREATE TYPE dbo.dtExcel -- you can be more speciifc here
AS TABLE
(
nameCustomer NVARCHAR(50),
nameItem NVARCHAR(50)
-- etc etc. The columns you have in your data table.
);
GO

CREATE PROCEDURE dbo.InsertMyDataTable
@dt AS dbo.dtExcel READONLY
AS
BEGIN
SET NOCOUNT ON;

insert into Customers (nameCustomer)
select DISTINCT nameCustomer from @dt where NOT EXISTS (select nameCustomer from Customers where Customers.nameCustomer=@dt.nameCustomer)
END
GO

but there is error
can you help me?

how can i use it without duplicate the data

how can i use sqlbulkcopy without duplicate the data.
if the data is exist don't insert it just insert the new values as i did in my sql statement
thank you

i have datatable (dt) filled from excel sheet, i need to insert the values in this datatable in database in table (Customers) without duplicate the data so i used this sql statement in my c# code but when i run the project there is error (invalid object named dt) so how i can i use it in this statement

i did this but when i change the style of font in texteditor the font tag appear.
the font style should change without tags

i use this script
<script>

document.getElementById("asd").addEventListener("ended", function () { alert("all done") }, true);

</script>

this script give me a message after the video finished but i want to prevent the user to watch the video again when he watched it he can't watch it again

how can i do it ?

this php code :


$client = new soapclient($wsdlUrl);

$params = array('memberId' => 'W1100045',
'thirdName' => 'Ali');

$result = $client->GetMembers($params);

$echoText = '';


if (is_null($result->GetMembersResult))
{

echo "no result";
}

else
{
echo $result->GetMembersResult;
}
?>



$client = new soapclient($wsdlUrl);

$params = array('memberId' =?--> 'W1100045',
'thirdName' => 'Ali');

$result = $client->GetMembers($params);

$echoText = '';


if (is_null($result->GetMembersResult))
{

echo "no result";
}

else
{
echo $result->GetMembersResult;
}
?>

and when i run the php code this error appear
Catchable fatal error: Object of class stdClass could not be converted to string in /home/appszone/public_html/wsd.php on line 17

how can i solve it?

I made these steps but still my web service run on the localhost how can i host it to run the web service from another machine.

and i have the custID and ProID
but the problem i have multiple proID how can i insert the mutiple proID with one custID in CUST_PRO table

da.SelectCommand = new SqlCommand("SELECT * FROM products", cn);
dt.Clear();
da.Fill(dt);

combobox1.DataSource = dt;
combobox1.ValueMember = "proID";
combobox1.DisplayMember = "proName";

yes
and i don't know what is the problem

thank you sir for cooperation.
but your links the both speak about web application and my application is desktop.
and these articles speak about remote database and my application will run on stand-alone machine so i need the database and the application run on stand-alone machine without any networks.

i need this necessary

i used prerequisties to add the framework and sql express
but how to add the database files with my application in setup project

i will run my application at single machine.
So please tell me how can i attach my database files and framework in one setup file

you mean i install the sql server express and attach my database.
if i want a database attached directly when i install the application its possible or not
thanks

i used this :
da.SelectCommand = new SqlCommand("SELECT DATEDIFF(day,GETDATE(),enddate) AS dateend FROM Person", cn);

and its worked and give me the dates right.
thank you very much manognya kota.

i do this :
SELECT DATEDIFF(day,DATETIME.now,[enddate])
FROM person;

but datetime.now not recognized .

thank you for your cooperation.
Please can you tell me how can i use this? can you give me example ?

it worked
thank you very much sir