16,022,418 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 .NET 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 Ccsnow (Top 19 by date)
Ccsnow
9-Jun-14 2:32am
View
Thank you for your answers,i wrote macro but it didnt work.
i custumized menu(http://i.hizliresim.com/mlbvzy.png), i want to that if i click iwanttocliktenhttpxxxcom button, i want to go to http://www.abc.com.
Thx.
Ccsnow
9-Jun-14 2:32am
View
Thank you for your answers,i wrote macro but it didnt work.
i custumized menu(http://i.hizliresim.com/mlbvzy.png), i want to that if i click iwanttocliktenhttpxxxcom button, i want to go to http://www.abc.com.
Thx.
Ccsnow
4-May-13 2:35am
View
Yes Thank u
Ccsnow
4-May-13 1:55am
View
Thank you... combo[0].remove(index)correct
Ccsnow
3-May-13 13:37pm
View
i didnt correct writing...
var combo = document.getElementsByName("abc");
combo[0].childNodes[3].style.display="None";
but my problem goes on
Ccsnow
20-Feb-13 2:11am
View
but how? example pls :)
Ccsnow
18-Feb-13 14:52pm
View
Hi ahmet, firstly sorry for my bad english :)
THEN,i dont give error message. i exec my sp i saw this http://b1302.hizliresim.com/16/l/k83w2.png but i dont want to this view ,,,, i want to view this http://c1302.hizliresim.com/16/l/k7wvr.png . it's different. this view so necessary for me.
Ccsnow
21-Jul-11 4:09am
View
paramdizi4 value = 0 if student ıd havent in ogrenci table(student table)
paramdizi5 value =1 always
Ccsnow
21-Jul-11 3:04am
View
i always take a massage " Kayit mevcut " i dont understand it?
Ccsnow
21-Jul-11 2:59am
View
USE [SduBelgeler]
GO
/****** Object: StoredProcedure [dbo].[BelgeKayit] Script Date: 07/21/2011 09:53:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[BelgeKayit]
(
@OgrenciNo int,
@BelgeId int,
@BelgeBaslik nvarchar(30),
@BelgeAciklama nvarchar(250),
@Durum int output,
@Sonuc int output
)
as
declare @OgrenciKayitKontrol int
declare @BelgeKayitKontrol int
Set @OgrenciKayitKontrol=(select count(0) from Ogrenci where Ogrenci.OgrenciNo=@OgrenciNo)
Set @BelgeKayitKontrol=(select count(0) from OgrenciBelge where OgrenciBelge.OgrenciNo=@OgrenciNo and OgrenciBelge.BelgeId=@BelgeId)
insert into OgrenciBelge(OgrenciNo,BelgeId,BelgeBaslik,BelgeAciklama) values(@OgrenciNo,@BelgeId,@BelgeBaslik,@BelgeAciklama)
if(@OgrenciKayitKontrol=1)
begin
set @Durum=0
end
else
begin
set @Durum=1
end
return @Durum
if(@BelgeKayitKontrol=1)
begin
set @Sonuc=0
end
else
begin
set @Sonuc=1
end
return @Sonuc
ı always get @Sonuc result = 1 but ı dont understand it?
my VS2008 CODE İS
if (TxtOgrenciNo.Text == "" )
{
LabelDurum.Text = "Öğrenci Numarası boş bırakılamaz";
}
else
{
Baglanti baglan = new Baglanti();
SqlParameter[] paramdizi = new SqlParameter[6]
{
new SqlParameter("@OgrenciNo",SqlDbType.Int),
new SqlParameter("@BelgeId",SqlDbType.Int) ,
new SqlParameter("@BelgeBaslik",SqlDbType.NVarChar),
new SqlParameter("@BelgeAciklama",SqlDbType.NVarChar) ,
new SqlParameter("@Durum",SqlDbType.Int) ,
new SqlParameter("@Sonuc",SqlDbType.Int) ,
};
paramdizi[0].Value = TxtOgrenciNo.Text;
paramdizi[1].Value = DrpBelgeTuru.SelectedValue;
paramdizi[2].Value = TxtDosyaBaslik.Text;
paramdizi[3].Value = TxtAciklama.Text;
paramdizi[4].Direction = ParameterDirection.Output;
paramdizi[5].Direction = ParameterDirection.Output;
SqlDataReader dr = baglan.ExecuteReader("BelgeKayit", CommandType.StoredProcedure, paramdizi);
List<belgegoster> belgeler = new List<belgegoster>();
while (dr.Read())
{
BelgeGoster belge = new BelgeGoster(dr.GetInt32(0), dr.GetInt32(1), dr.GetString(2), dr.GetString(3));
belgeler.Add(belge);
}
GridViewBelgeler.DataSource = belgeler;
GridViewBelgeler.DataBind();
if (paramdizi[4].Value.ToString() == "0")
{
LabelDurum.Text = " Kayıt eklendi ";
}
else
{
LabelDurum.Text = " Böyle bir öğrenci numarası bulunmamaktadır. ";
}
if (paramdizi[5].Value.ToString() == "0")
{
LabelDurum.Text = " mevzut yok ";
}
else
{
LabelDurum.Text = " Kayit mevcut ";
}
}
help pls
Ccsnow
21-Jul-11 2:58am
View
USE [SduBelgeler]
GO
/****** Object: StoredProcedure [dbo].[BelgeKayit] Script Date: 07/21/2011 09:53:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[BelgeKayit]
(
@OgrenciNo int,
@BelgeId int,
@BelgeBaslik nvarchar(30),
@BelgeAciklama nvarchar(250),
@Durum int output,
@Sonuc int output
)
as
declare @OgrenciKayitKontrol int
declare @BelgeKayitKontrol int
Set @OgrenciKayitKontrol=(select count(0) from Ogrenci where Ogrenci.OgrenciNo=@OgrenciNo)
Set @BelgeKayitKontrol=(select count(0) from OgrenciBelge where OgrenciBelge.OgrenciNo=@OgrenciNo and OgrenciBelge.BelgeId=@BelgeId)
insert into OgrenciBelge(OgrenciNo,BelgeId,BelgeBaslik,BelgeAciklama) values(@OgrenciNo,@BelgeId,@BelgeBaslik,@BelgeAciklama)
if(@OgrenciKayitKontrol=1)
begin
set @Durum=0
end
else
begin
set @Durum=1
end
return @Durum
if(@BelgeKayitKontrol=1)
begin
set @Sonuc=0
end
else
begin
set @Sonuc=1
end
return @Sonuc
ı always get @Sonuc result = 1 but ı dont understand it?
my VS2008 CODE İS
if (TxtOgrenciNo.Text == "" )
{
LabelDurum.Text = "Öğrenci Numarası boş bırakılamaz";
}
else
{
Baglanti baglan = new Baglanti();
SqlParameter[] paramdizi = new SqlParameter[6]
{
new SqlParameter("@OgrenciNo",SqlDbType.Int),
new SqlParameter("@BelgeId",SqlDbType.Int) ,
new SqlParameter("@BelgeBaslik",SqlDbType.NVarChar),
new SqlParameter("@BelgeAciklama",SqlDbType.NVarChar) ,
new SqlParameter("@Durum",SqlDbType.Int) ,
new SqlParameter("@Sonuc",SqlDbType.Int) ,
};
paramdizi[0].Value = TxtOgrenciNo.Text;
paramdizi[1].Value = DrpBelgeTuru.SelectedValue;
paramdizi[2].Value = TxtDosyaBaslik.Text;
paramdizi[3].Value = TxtAciklama.Text;
paramdizi[4].Direction = ParameterDirection.Output;
paramdizi[5].Direction = ParameterDirection.Output;
SqlDataReader dr = baglan.ExecuteReader("BelgeKayit", CommandType.StoredProcedure, paramdizi);
List<belgegoster> belgeler = new List<belgegoster>();
while (dr.Read())
{
BelgeGoster belge = new BelgeGoster(dr.GetInt32(0), dr.GetInt32(1), dr.GetString(2), dr.GetString(3));
belgeler.Add(belge);
}
GridViewBelgeler.DataSource = belgeler;
GridViewBelgeler.DataBind();
if (paramdizi[4].Value.ToString() == "0")
{
LabelDurum.Text = " Kayıt eklendi ";
}
else
{
LabelDurum.Text = " Böyle bir öğrenci numarası bulunmamaktadır. ";
}
if (paramdizi[5].Value.ToString() == "0")
{
LabelDurum.Text = " mevzut yok ";
}
else
{
LabelDurum.Text = " Kayit mevcut ";
}
}
help pls
Ccsnow
15-Jun-11 5:46am
View
ALTER proc [dbo].[RolDuzenle]
(
@UserId uniqueidentifier,
@RolId uniqueidentifier,
@Result int output
)
as
Declare @RecordControl int
Set @RecordControl=(select count(*) from dbo.aspnet_UsersInRoles where UserId=@UserId and RoleId=@RolId)
begin
set @Result=0
end
else
begin
update dbo.aspnet_UsersInRoles set RoleId=@RolId where UserId=@UserId
if(@RecordControl=0)
set @Result=1
end
return @Result
i take error massage
Incorrect syntax near the keyword 'else'.Your sp is faied my friend ı understand but ı dont do that.
thanks for your attention but ı thınk ıt's a big problem
Ccsnow
15-Jun-11 3:50am
View
ı dont understand pls give a example for me
Ccsnow
14-Jun-11 4:36am
View
what is my problem? how can ı do for my problem?
Ccsnow
13-Jun-11 12:40pm
View
thx u but my problem is going my friend
Ccsnow
13-Jun-11 8:11am
View
i want
if ı wrıte false role ıd
LabelDurum.Text = "No roleId";
i write true
LabelDurum.Text = "role ıd updated";
Ccsnow
13-Jun-11 7:24am
View
thank you from Turkey
Ccsnow
12-Jun-11 16:35pm
View
<pre lang="msil">Personel KonuBaslik Tablom
PersonelForumId int P.key
PersonelForumUrl nvarchar(50)
PersonelForumKonuBaslik nvarchar(256)
PersonelForumKonuIcerik nvarchar(500)
PersonelForumBaslatan nvarchar(50)
PersonelForumSonYazanSaat datetime
Include Personel KonuBaslik
90 Resimlerim/dosya.gif HUlya hoca hakknda iyi birisi bence hamit 2011-06-12 17:58:18.000
91 Resimlerim/dosya.gif recai hoca hakknda nasl birisi sizce ahmet 2011-06-12 21:08:05.000
PersonelForumCevapTablom
PersonelForumId F.KEY int
PersonelForumCevapId P.KEY int
PersonelForumCevapUrl nvarchar(50)
PersonelForumCevapYanit nvarchar(500)
PersonelForumSonCevapYazan nvarchar(50)
Tarih datetime
Include PersonelForumCevapTablom
90 30 Resimlerim/yorum.gif yorum1 merve 2011-06-12 17:59:00.000
90 31 Resimlerim/yorum.gif yorum2 merve 2011-06-12 18:22:10.000
90 32 Resimlerim/yorum.gif yorum3 merve 2011-06-12 18:22:14.000
90 37 Resimlerim/yorum.gif ..... merve 2011-06-12 18:22:44.000
91 43 Resimlerim/yorum.gif iyiii a hmet 2011-06-12 21:08:12.000
ı have 2 titles but if i wanna to add title ı can do that.Number of title is not static.
My stored procedure is
ALTER proc [dbo].[ForumSon]
AS
SELECT A.PersonelForumId ,PersonelForumUrl,PersonelForumKonuBaslik,PersonelForumBaslatan,B.PersonelForumSonCevapYazan,B.Tarih from PersonelForumKonuBaslik as A inner join PersonelForumCevap as B on B.PersonelForumId=A.PersonelForumId order by B.Tarih desc
F.Id URL Title starter lastwriter date
91 Resimlerim/dosya.gif recai hoca hakkında ahmet ahmet 2011-06-12 21:08:12.000
90 Resimlerim/dosya.gif Hulya hoca hakkında hamit merve 2011-06-12 18:23:33.000
90 Resimlerim/dosya.gif Hulya hoca hakkında hamit merve 2011-06-12 18:23:29.000
i wanna to show this;
F.Id URL Title starter lastwriter date
91 Resimlerim/dosya.gif recai hoca hakkında ahmet ahmet 2011-06-12 21:08:12.000
90 Resimlerim/dosya.gif Hulya hoca hakkında hamit merve 2011-06-12 18:23:33.000
My STORED PROCEDURE IS
ALTER proc [dbo].[ForumSon]
AS
SELECT A.PersonelForumId ,PersonelForumUrl,PersonelForumKonuBaslik,PersonelForumBaslatan,B.PersonelForumSonCevapYazan,B.Tarih from PersonelForumKonuBaslik as A inner join PersonelForumCevap as B on B.PersonelForumId=A.PersonelForumId order by B.Tarih desc</pre>
Ccsnow
12-Jun-11 12:27pm
View
Hey, thx for all of them. perfect thx for your helping my friend
thx from Turkey :))) ok my friend
Show More