Comments by Arul R Ece (Top 81 by date)

need to find cout of rows .that contains "0" values.

in above example 5 values there.contain 2 zero values.so result is '2'.

it is free or cost

If it is help for you means accept this as answer

Hey ,
This is just example foramt pa....

Hi,

If any Error came or not,

Hi any one reply for this,

I want some text constant and other thinks like name ,empid will change accoring to DB dynamically.

Hi Ashis,

The above query gives error,please check and update

fetch the value from data base for particular country .using two data set ,one for states and another one for cities.

U want to know about Cursor in SQL ?

Can u please use datetime as data type for AGE

Can u please post ur query.
Because the above given query working fine

Hi....

Please try this.

select top 1 [name]+' #'+[product]+' #'+CONVERT(varchar,[amount],0)+'@'+
case when isnull([sales ID],'')='' then 'Null'
else convert(varchar,[sales ID])
end
from sales

Can't understand your Question.please explain in detail

Select the Bar Diagram-> Right click->change chart type-> select any type

change the chart type.............

If u use select distinct Fullname City Email Mobile OrderID from tblname .

It will check all the colums.if any matching 2 rows ,it will display one row.otherwise display all the rows.

one record means ,which condition basis u want

Which column is common for both table..

Hi..

The value of TransactionDate is from same table r another table

Ok.....Thanks ..

If it is help u means , accept this as answer

U put the value in notepad n save in server.
Then mentioned server path in above mentioned place

You can use "BULK INSERT "

select [monthname],[YES],[No]
from
(select * from mon )source pivot
(count(attend) for attend in ([Yes],[No]))pt

order by monthname

Hello ..i Got result like u want

If it is correct means ,accept solution

Ya Thanks for ur reply.

Ya Thanks for ur reply.

Can U pls confirm the data type for PUR_QTY , SAL_QTY

Prosan...

My question is can we use sdtored procedure in crystal report.

like table

U which data type used for dates

I develop a task allocation application.
so degn like that way

Ranjith..

I have already added the mentioned Name Spaces

Hi Friend...

Alreay i go through the above mentioned link.

I can able to create chat report.but not showning in correct data.
i Dont know how to set

K Thanks friend...

I will try and let u know i have any issues

Ya .. i used above mentioned....

But same error.

Till get same error

Hi Friend,...
I am getting the below error.
The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>). Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>). Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [HttpException (0x80004005): The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).] System.Web.UI.ControlCollection.Add(Control child) +8680983 AjaxControlToolkit.ScriptObjectBuilder.RegisterCssReferences(Control control) in C:\Users\wahlind\Desktop\Code\ControlToolkit\AjaxControlToolkit\ExtenderBase\ScriptObjectBuilder.cs:249 AjaxControlToolkit.ExtenderControlBase.OnPreRender(EventArgs e) in C:\Users\wahlind\Desktop\Code\ControlToolkit\AjaxControlToolkit\ExtenderBase\ExtenderControlBase.cs:352 System.Web.UI.Control.PreRenderRecursiveInternal() +80 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

I am getting the below error.
The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).

Can u Please tell the error message

Thanks friend

It is example for report between two dates

SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand("taskreport", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@calledFor", "ByStatus");
cmd.Parameters.AddWithValue("@assignedto", "NULL");
cmd.Parameters.AddWithValue("@status", status);
cmd.Parameters.AddWithValue("@startime", strdate);
cmd.Parameters.AddWithValue("@endtime", enddate);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
gridreport.DataSource = ds;
gridreport.DataBind();

In my office this url restricted..


only code project n C # corner allowed

Hi sharma..
i am not able to open the above link.
Please post the answer

When excel inside any folder not able to read.

Hi I am using same think like in abbove mentioned page.
but dropdown control can't be found.

When i use that link..
Can't find the control(dropuser)

Hi ..

I am not able to get the answer

I want to load user name for Header Assign To from data base .

Ya..thanks ..
Now working fine ..

Thanks sandeep

Hi Sandeep ...

I tried with above code .but no result.

Thankn u praveen..nice

ya ... s pa... for ordinary page .it is working fine...

When i add that page into master page it is not working

i am not able to get

Hi ..
i am not able to get

hi priya

protected void btnSave_Click(object sender, EventArgs e) { Insert(); }
private bool Insert() {
string strcon = "Data Source=USER-PC\\SQLEXPRESS;Initial Catalog=Course;User ID=sa;Password=sql2008";
SqlConnection mycon = new SqlConnection(strcon);
mycon.Open();


string strquery = "insert into studentDetails([name],qualification,age,mobileno) values('" + txtName.Text.ToString().Trim() + "','" + txtQual.Text.ToString().Trim() + "','" + txtAge.Text.ToString().Trim() + "','" + txtMobile.Text.Trim() + "')";

SqlCommand cmd = new SqlCommand(strquery, mycon);

string message="success";

if (message="success")
{
cconsole.writeline("Record added successfully")
}

else
{
cconsole.writeline(" Please check")
}

try like this way.may be it will help for u

sari pa

oh good ..
what was the problem

hi priya ..did u got the answer

s i know pa ..i just check

when i try this
('arul','be','25','97893832801')
i got error

i am also try ,when i enter 11 digit mobile no.that nentioned error came.
so may be that place error.

Hi priya
can u pls tell size of mobile no which u enter in coding part.

because in DB u create only 10.if u enter more than 10 digit

"String or binary data would be truncated."

Eror will come.pls check

what is the data type for age n mobile no

Ya sorry friend....It is for asp.net .....

When i run my .net application , i want to view in full view.i.e) maximize view

Hi bala....
when i use the first query only 3 rows were affected.

Hi Anil.
When i click the ADD button.
the text box value should to Label.

Hi patil,

Thanks for your info.
but i am not able to get that answer

For example i enter the value in txetx box.it should pass to lable.
Please look into it

k salini ..,
i need in C #

how we export the grid data in Excel