Comments by Sumon562 (Top 161 by date)

it is not working. Please give me a better solution.

I have tried this but get no result

use this code in my function CalculateValue()? Please help

Thank you Mr. Abhinaw Kuma. Where I use thi code.Please help me

Thanks it works nice

Thanks a lot Mr. Maciej Los

I have to show One field in select statement that is Internal Transfer or external Transfer depend on TraType.

after typing the id company dropdownlist will be refreshed. then have to type password.
Actually first type id then company dropdownlist loaded but drodown item select after password typing.

It arises the following error
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'T00006' to data type int.

It shows the following error
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'RENT00003' to data type int.

It shows conversion error

Thank you Me. King Fisher for your kind response.Can you please tell me how can I do it in c#.

Actually this occurs in publish site. when I debug in my pc then it is ok.

yes you are right. But how can drag each element through a report formula.

Thanks a lot. I am really regretful to you.

I run it in SQL query analyzer. I am using SQL Server 2008. If has anyway please suggest

Hi Mr. Kornfeld Eliyahu Peter is it possible to get control id in another way. Please give me example. Thank u for your response.

Its really interesting. Thank u again.

I am very regretful to you. Can u please describe what return false does?

Thanks for your advice. It works well.

I will be very grateful if get a solution.

Here I have to use another stored procedure and add this to the dataset.

in google crome it open new window.

Still it does not work

It shows the following error :
Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1002: ; expected

Thanks a lot Mr. ChauhanAjay. But it does not work

I am new. I dont realize typo

Actually alias name is production

<script type="text/javascript">
$(document).ready(function () {
$(".btPOPUP").live("click", function () {
$("POPUPPanel").hide();
var v = $(this).val();
if (v == "Add Defect Type") {
$(".POPUPHeaderText").html("Create New Defect Type");
$("#POPUPIFrame").attr("src", "Smt_CreateDefectType.aspx");
}
if (v == "Add Defect Category") {
$(".POPUPHeaderText").html("Create New Defect Category");
$("#POPUPIFrame").attr("src", "Smt_CreateDefectCategory.aspx");
}
$(".POPUPPanel").toggle("slow");
return false;
});
$(".POPUPClose").click(function () {
$(".POPUPPanel").toggle("slow");
});
});

</script>

I have asked you rdlc report. This link show how to do it in crystal report

The actual error are :
The maximum report processing jobs limit configured by your system administrator has been reached

Thank you Mr. Animesh Datta. I have found MaxNumOfRecords and by default it's Value data is -1 that u advised me.

I found SOftware not Crystal Decisions

Thanks for your kind reply. I get HKEY_LOCAL_MACHINE/SOftware but could not find Crystal Decisions

I have used master page. But I use this javascript method in content page. your above mentioned function does not work. Content page does not have <form> tag.

you give answer if we throw easy question. But can not give any idea about a complex question.

I tried many times. If possible help me.

I am new in SQL Server Reporting Service. Please tell me which class I have to install

Can anyone help me please

I have done a report using Business Intelligence Development Studio. I can run this. But my requirement is to run it when I click a button.

I want to divide the report into four different rpt. Is it possible?

paper size is legal

Thanks for your suggestion. Please can you help me how can I use iTextSharp

It does not work. I have to prevent scroling.

Thanks for your kind response. Here 28:45 means 28 hours 45 minute.

I have used Trigger but it does not work

I have done but it does not work. Please give a better solution.

NO I have not written any javascript code

TextBox is the last Control

This does not work

Remove at does not get

yes, you are absolutely right

Thanks Mr. obhijitghosh for your kind response. This query arises an error. The error is in the line of
'Select @NetPayable2 = sum(cast(S.NetPayable as decimal)) as NetPayable, @OTAmount2 = sum (cast(S.OTAmount'
Incorrect syntex near the keyword as.

I have numeric value

Now it shows the following error :
Msg 207, Level 16, State 1, Line 4
Invalid column name 'Todays Approval'.

I checked and use quick watch. It's ok but the result is wrong

If I get the structure and data simultaneously from Copy method then why should I use clone.
Isn't it a wast of time, or it consume time when compile?

Thank you very much

local application

Thanks for your kind response

Actually I use the store procedure in C# code and in the else portion of the store procedure will show a message. How can I do that

I expect an answer.

Thanks

Thanks brother

Thank you for your response. Can you help me how can I call it in C# code. We use a method to connect database. I provide you the method :

public void DBConnection(string strDBName)
{
try
{
if (IDisconnection != null)
{
if (IDisconnection.State == System.Data.ConnectionState.Open)
{
IDisconnection.Close();
}
IDisconnection = null;
IDisconnection = new SqlConnection();
}
else
{

IDisconnection = new SqlConnection();
}
strConnectionString = "Data Source=localhost;Initial Catalog=" + strDBName + ";User ID=sa;Password=sa1234";
IDisconnection.ConnectionString = strConnectionString;
IDisconnection.Open();
mblnTransactionStart = false;
}

catch (System.Data.SqlClient.SqlException e1)
{
throw (e1);
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
}
}

Thank you for your kind response. I have modified the procedure. But now it tells that error near second 'begin'

string strTest= Requested.QueryString["Query"].toString()

min and max dues not work

Its an Exception.

Thank you Mr. OriginalGriff

When I will debug what this line "string abc=Session["Value"].ToString();" shows !!! Please describe..

in the Management Studio "New Query" which is on the top left corner. When we click to New Query then open a new window and we write different query there. Did you mean that?

Can't you understand me?

You mean in the Management Studio "New Query" Where we click to write SQL queries, Am I right?

I have tried but not all control

Thank You. I am posting another question. Please help

No i can not. Please help me

Thank you very much. Your code is ok. Can you help me how can I get a map of place by searching a specific place. Such as I have a text box and I write here "Dhaka" and it shows Dhaka city's map.

Thank you for your valuable answer. Actually I want to make a method that will connect database which database I need

Suppose I have a database name is Inventory, 2nd one is HR, 3rd one is Accounts.....
and many other

I want to use only one method to do it. Is it possible? If possible how can I do that?

Thank you

Thank you Mr.AYDIN EBRAHIMI HOMAY . And Can I join Between two Views.

Can you please explain some of the ways? I will be gratful to you

Thank you Mr. _Maxxx_. If I want to retrieve only one row then is it possible?

Can you help me please How can I find Visual Studio code editor. I can not find out Go to definition and Find all references.

Thank you Mr. Oshtri Deka.

mark means Bookmark!!! Am I right

First I checked if the value of textbox is " " then
string str = Server.HtmlDecode(txtRemark.Text);
else
str = txtRemark.Text;
In the space I wrote ampersandnbsp;

Yes, I have solved the problem.

In the database there is no data and it is not null

yes

Thank you. It works well

I have posted the markup of GridView below :
<asp:GridView ID="grdEdit" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
CellPadding="3" Font-Names="Arial"
Font-Size="Small" GridLines="Vertical" HorizontalAlign="Center">
<rowstyle backcolor="#EEEEEE" forecolor="Black">
<footerstyle backcolor="#CCCCCC" forecolor="Black">
<columns>
<asp:TemplateField>
<HeaderTemplate>
<asp:Button ID="btnEdit" Text="Edit" runat="server" onclick="btnEdit_Click" />
</HeaderTemplate>
<itemtemplate>
<asp:CheckBox ID="chkCheck" runat="server" />

<HeaderStyle HorizontalAlign="Center" Width="55px" />
<itemstyle horizontalalign="Center" width="55px">

<asp:BoundField DataField="SheduleDate" HeaderText="Shedule Dates"
SortExpression="SheduleDate" DataFormatString="{0:dd-MMM-yyyy}" >
<HeaderStyle HorizontalAlign="Center" />
<itemstyle horizontalalign="Center">

<asp:BoundField DataField="Remarks" HeaderText="Remarks"
SortExpression="Remarks" >
<HeaderStyle HorizontalAlign="Center" />
<itemstyle horizontalalign="Center">

<asp:BoundField DataField="MPDCode" HeaderText="Maintenance Shedule Code"
SortExpression="MPDCode" >
<HeaderStyle HorizontalAlign="Center" />
<itemstyle horizontalalign="Center">



<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<alternatingrowstyle backcolor="#DCDCDC">

The value in first column of last row is a date "06/03/2013" But as your code It shows no value.
GridViewRow row = grdEdit.Rows[grdEdit.Rows.Count - 1];
string val = row.Cells[0].Text;

I don't have a footer

I have written the following codes :
GridViewRow row = grdEdit.Rows[grdEdit.Rows.Count - 1];
string val = row.Cells[0].Text;
dtpMaintenceEnd.Text = val.ToString();
But it brings empty value;

I am waiting for your answer.

Thank you Mr. Tadit Dash for your kind response. Actually I do not use any control in the gridview. I just want last Row;s first column's data. I think you can help me now.

A use normal gridview of asp .net c#

It arises error like DataGridRow could not be found

wow!!! I am really happy. Thanks

Thank you for your kind response. Can you explain me why should We convert IQuerable /IEnumerable result to the generic List<> type.

Now is it possible to solve the same problem using view state? I wish I will get your help.
I have tested above solution of you and these works well.

wow Thank you.

Hi Ms. Swayam Mishra can you solve this using cookies and application state. I feel grateful if you provide solution by the two ways : Cookies and application state. God bless you.

I did it using session. You can help me how to use Application state and cookies. Thank you

Thank you for your response. Actually I don't want to use query string. Give me another solution please

No it does not work.

I have used response.redirect

It can not fulfill my requirement

Actually I am new in programming. I do not know the use of UTF-8 and do not know its functionality. Can you describe me. Thank you advance.

Yes I need Bengali script. Now how can I utilize this that you mentioned.

I tried but it does not work

Thank you Mr. Bernhard Hiller. Is it all? If so I am really happy

Thank you

Thank you Mr. siddharthrainit

actually My question was about composite key. If I have multiple columns in my primary key then Are they contain duplicate value. I know that primary key does not allow any duplicate key. I will be regretful if you explain.

Thanks for realizing

Thank you Mr. _Amy. It works nicely

Thank you Mr._Amy. I have tried but it does not work.

Web Application

Hi, have anyone to help me?

Thank you Mr.Maciej Los
I have used sql server 2008

Is this portion of method is right?

Thanks Mr. Mohammed Hameed. I have mentioned the whole method. Please now describe what
if (ddlAction.SelectedValue == "")
{
return;
}
this portion of method means

Thanks Aarti Meswania. The three formula that you mentioned how it create and how can I use these formula. Can you explain please?

Thank you Mr. Aarti Meswania

I want to prevent data duplication without using distinct. Can you explain what is better for me?

Thank you. But I do not declare theTable2.Column1 column as foreign key. both columns are primary key.

Hi patel_vijay . I have explained the question

I want to join two table with a common field and same datatype and both the field is primary key. I want to join the two table with the above mentioned field

Can't I get a proper answer??

I want to work with the control that is in another page. How can I do this?

Thank you Mr.Zoltán Zörgő for your kind response

Thank you Mr. Karthik Harve

Thank you Mr.Prasad Khandekar for your kind response. If you explain details it will be better for me.

I m sorry. I have solved the problem. Thank u for ur help.

I created datatable but the problem is that when at the second time loops go to catch. I m very worry.

Thank you. Please give the answer that I posted here before this question. I will be very regretful if I get it.

I have posted a question before this. Please answer that

Its an stupid answer Mr. Sandeep Mewara. I must have looked web. But it seems to me difficult.
So I send a question.

Yes but it does,t work

I have tried but it doesn't work

Thank you

Thanks

Thanks

Thank you very much Mr. Sumit_Kumar_Sinha

Thank you for your decision.
I have run your store procedure but It does not work
Please check it and let me know a solution.

You can show a way programatically not using procedure
thanks Mr. Maciej Los

Thank you for your solution. But I don't want to use store procedure. I want to use sql query
Help me pls.

I will be grateful if answer me with example.
Thanks