Forgot your password?
Sign in with
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Python questions
View Java questions
All Message Boards...
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Design and Architecture
Internet of Things
C / C++ / MFC
ATL / WTL / STL
Objective-C and Swift
Hardware & Devices
Hosting and Servers
.NET (Core and Framework)
Site Bugs / Suggestions
Spam and Abuse Watch
The Insider Newsletter
The Daily Build Newsletter
Most Valuable Professionals
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
What is 'CodeProject'?
Ask a Question
Bugs and Suggestions
Article Help Forum
Comments by Member 10690878 (Top 35 by date)
Thanks for your reply, but the code showing error message Incorrect syntax near '.'.
Hi @Duncan Edwards Jones yes the both tables contain column called UID so what i am looking is from the statement is to check into UserInfo if the user has Y value then show the ads otherwise dont show
yes the both tables contain column called UID so what i am looking is from the statement is to check into UserInfo if the user has Y value then show the ads otherwise dont show
I do as you mention like :
SqlCommand cmd = new SqlCommand(sqlstatment, cn);
cmd.CommandType = CommandType.Text;
cmd.CommandText = sqlstatment;
but i get error message: Severity Code Description Project File Line
A local or parameter named 'cmd' cannot be declared in this scope because that name is used in an enclosing local scope to define a local or parameter
Hi @KrunalRohit but i have already added this one into code you can check it again after each string sqlstatment
Hi @F-ES Sitecore
Thanks for your reply and explanation, but i need to help me with full code as the rest i dont know how to complete it.
Hi no i need some one to help me by complete the rest of the code
Hi @AnvilRanger Thanks for your reply, the post has been updated and include all my references please can you check it
Hi @Andy Lanng many thanks for your edit my post in fact in know that i should include it into my first post but i was working from my mobile and i couldnt find edit post button so that way i add as an comment, anyway sorry of that :-).
here is my refernces so i dont know where is my mistake
(Edit AL: now added to question)
Hi @Member 11193337 thanks for your reply, and i will be more thanks for you if you complete the trigger as those tree line of codes its easy to create it but i need some one to help me in the rest of the trigger. As i need some one to help me to create this trigger as the i am looking for
Dear I did not ask to change the date, i wish if you can re-read the post i want the stored procedure to check the endVipDate for those people whose have the value "YES" into column VIP then if the endVipDate is matching today date then change the value into VIP column to to NO or Null
I may not understand what you mean excatly , but if i dont add anything then all the text written in one Textbox will be in on line.
@Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) but did there are any others way to save the text as user inserted i mean with newline !!!
Hi please could you make it as answer :-) as it fixed and what you said is correct
hi @jgakenhe many thanks for your advice, but i am not so prof with c# i will be thanks if you explain to me in details with code how i can do that, many people told me that i need to rebind the gotovieworder_click but i dont know how.
there is only this Listview and there is only those controls inside it, i agree with you the listview will repeat many times for same control as much as you have into table into database. But i am showing only one record for the same userid which is under session value. so could you explain more of how i can fix it.
So but the controls are already into the listview so how i can fix it??!!
thanks @sameeakhtar786, i do it but i get this error message at line: smtp.Send(fromAddress, toAddress, subject, body); the error message is: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at
Hi @sameeakhtar786 many thanks for your reply, i have copy and paste your code and i change to my email setting but i would like to ask you i have already delete the previose code of the email part from my code but how i can call the method of your code
Hi @Kornfeld Eliyahu Peter thank you for your comment, yeah thats right i have forget = sign but still the problem is, what its happen that the LinkButton is out side the ListView so for that it cant get the UID value as i think
Hi @amin khoshzahmat thanks for your comment i hav added but the problem still as it is :-(
Hi @DamithSL i have did as you mention above and its working fine, and i have tried to do it with BizCateDDL but it inserting "Your Business Field" as its writting in postback of BizCatDDL: if (!IsPostBack)
DataTable BizCateDT = new DataTable();
using (SqlConnection con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["BeravaConnectionString"].ConnectionString))
// Create the SelectCommand.
SqlCommand BizCateCmd = new SqlCommand("SELECT BizCate FROM BizCate", con2);
SqlDataAdapter adaptar = new SqlDataAdapter();
adaptar.SelectCommand = BizCateCmd;
BizCateDDL.DataSource = BizCateDT;
BizCateDDL.DataTextField = "BizCate";
BizCateDDL.Items.Insert(0, new ListItem("Your Business Field", ""));
Hi thanks for your kind reply, i get this error at this line: adaptar.Fill(StateDT);
Hi Nirav Prabtani. Thanks for your reply but i am looking for filtering from code behind not sorting i may make mistake in my post title.
Hi @Hard_Rockz thanks for your reply but what about the 2nd part of my post about how i can change the header names of other columns from code behind
in fact i respect your opinion and thanks for your reply but i have post the code and try my best to explain the problem the UsrNme is the session that collect the username when user login to his account. Anyway i hope some other member can fix
I have make another screen record with breakpoint so i wish if you can watch it and help me to find the error as i couldn't: https://www.youtube.com/watch?v=O7jIb_yW1WQ&feature=youtu.be
Hi thanks for your reply , i have do it but to be honest i coudnt catch the problem so for that i post here , even i have post the same post in other fourms and the members coudnt fix it. So i wish if i can find someone can fix this code to work as it should be
Hi i have make the update that you give it to me and it show this message also next to first line of your update: Object reference not set to an instance of an object.
Hi, i have record my screen for you so i hope that will help to get the full picture of what is happening, please check the link: https://www.youtube.com/watch?v=X0WbBw4_fuA&feature=youtu.be
i dont know how in fact, and as i told you this is a primary key its not allowed to user to change it, i also delete the part of query in the update statment and its same nothing change still the message appear
Hi @Hard_Rockz thanks for your reply but the UID is using a session and this column canot be updated, so how i can fix that
Last Updated 1 Jan 1900
All Rights Reserved.