Comments by shms_rony (Top 81 by date)

If the dropdown list of the column Selected on "ALL" and the Dropdownlist of the Second Column Selected value is 5 < Gridview display All Rows Of the Column 1 which have values 5 of the column 2

For "Blank " if the dropdownlist of the column selected value is "Blank >> display in Gridview all Data which are not equal 0

but also when I write Maria in label text and " select where name like '%'+label1.text+'%' , the same problem :/

Not working , only numbers or space in textbox show results of execution
may be there is something error in textbox , could you help me

how can I use your modified answer in my sql ?

class method
==================
public DataTable searchname(string value)
{
string query = String.Format("Select Name from Users Where Name Like '%{0}%'", value);

return search(query);
}


in code behind
=====================

protected void ButSrch_Click(object sender, EventArgs e)
{

GridView5.DataSource = classobject.searchname(Textsrch.Text);

GridView5.DataBind();


}

like what ??
after save data how to redirect to user data's page with it's ID

and db is object of class

It's Run Procedure Function that Run any Procedure

public int RunProcedure(string ProcedureName, SortedList ParaValues)
{
connect(CommandType.StoredProcedure, ProcedureName);
for (int x = 0; x < ParaValues.Count; x++)
cmd.Parameters.AddWithValue(ParaValues.GetKey(x).ToString(), ParaValues.GetByIndex(x).ToString());
return ExecuteUpdation();

}

How to save data in sessions and if you have another idea for this issue

total column is computed column

Formula --> (([a]+[b])+[c]))

ALTER PROCEDURE dbo.ManageLaborEval
(

@a int,
@b int,
@c int



)

AS


INSERT INTO Table1(a, b, c) VALUES (@a,@b,@c)




RETURN

please help me

Yesssssssssssss It's worked
Thank you very very much :)

That's good but it didn't work for me
the result is

//gridview1 // gridview2
pland countf

14/08/2013 0
18/08/2013

the result must be as following

pland countf

14/08/2013 2
18/08/2013 0

grid datatable get the last value

if you have x = 0 and save 1 in x
automatically 0 deleted

this happened in datatable
i want to save each value in one row in datatable

yes that is right :)
first code get all rows but the second code get first row only

but how can i get all rows in variable to use it in other statement ??

Thanks , it worked for me :)

ok thanks

Run Procedure Worked well and datetime inserted
What's problem?

I want automatic inserted values in the identity column

not working :(
I did the insertion using c# class

What do you say
You do not want to help anyone
I have a problem and you want to solve and I went to this site to answer me one of you
But you do not do you deal professionally
There are so many sites out and I put my question is answered with an open mind

If you look at the bottom you will find the solution in question is not that strange
And a person understand the question and answer it

I'm at the beginning of my work and I am having problems and I come to those who understand and help me to answer

Thank you

building update command

update table name set .... what ...

ok thanx but this is not my homework
iam learning
thank you for your help

your e-mail to send you my work and edit it

Can i contact you on your mail??

thanks very much for your useful answer

but i want you to write full update command and delete command because i tried but not sucessful

i have test tomorrow morning and i tired from thinking

thanks very much
i passed the selected table name in session and get table data
but i can't delete or update table

if you can write update command for any table of these

i use these functions but my gridview don't have datakeyname

i want to add delete button in gridview

sorry this answer didn't solve my problem :(

i don't understand this line

GetGlobalResourceObject("MyResource", "GlobalResourceString1");

i want to create form in my application (textbox and button to choose path in my pc) and button (save)

it is like back up for my project database

sorry ..iam not understand what do you mean

ok...when i send message successfully but it send from the e-mail that exist here NetworkCredential("my account in gmail", "my password");
i want to send from the email the i entered in textboxfrom

ok.. this is good but the error now is that the message sending from NetworkCredential mail to (msg.to)

i want to send from (textfrom "msg.From") to (msg.to)

the error is this code send from me to me and not define textbox that have from email(textfrom)

thanks

datalist images get from path in database

but i don't want to do it by converting to template field ..i convert direction of table to rtl but direction of columns of detailsview not reversed
what solution??

thanks

i saw your upddated solution
i define my columns as TemplateFields but i can't implement the reverse direction in TemplateFields

your link not helpful

i do it but nothing reverse
<div dir="rtl"> <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px"> </div>

how can i call it ??
i can't put onmouseover in my above code

any one help me

I HAVE another problem that one user updated when global.asax out bin folder and get message (debug, close program) and worked well
what can i do for this message

thank you for answer

but no user updated :(
first method updated one user only but your method updated 0 user

thank you for this perfect answer but i still have the problem
user (1) updated and user(2) not !!!

I HAVE UPLOADED PDF FILE (Contract) and i want to click button in user profile to save his contract edited with user name ..how can i add alabel to pdf file to get name in this label

i mean that i display date from field in gridview by wizard method ...not using select statment

iam using wizard method :(

i want to format date in column properties if this right

where can i do this statment ??

not work :(

i replaced ExecuteScalar with a ExecuteReader

check my code


SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
DateTime enddate = new DateTime();
enddate = (DateTime)dr["enddate"];
int id = Convert.ToInt32(dr["id"]);
if (DateTime.Compare(datenow, enddate) > 0)
{

string sql1 = "update users set type='Suspended Users' where users.id='" + id + "'";
SqlCommand cmd1 = new SqlCommand(sql1, con);
cmd1.ExecuteNonQuery();

question is clear ..what do you mean!!

what can i modify??

when i remove static word ..another error

"TimerCallback callbackDaily = new TimerCallback(Jobs.DailyJob);"

this is the error when i call procedure to this method

"An object reference is required for the non-static field, method, or property 'myScheduler.Jobs.con"

sorry can you write code

i normally writing code and work well but when i create procedure and call it ,,,give me error that this is static function

thank you

i have error

"must declare scalar variable @Iterator"

i don't find what iwant in google ...so i put my question here

i want to perform the statement using syntax of sql server 2005

hanx all

Ratnesh N Bharos

1-i have one problem of ths code
getdate() return date with time ..i want to format it as dd/M/yyyy

because currentdate inserted as this form dd/M/yyyy without hours
2-and how to call this procedure in class

thank you