Comments by ClimerChinna (Top 143 by date)

thanks for the answer,
but it was not working same error repeated.
textbox1.text.focus is not working I have tried textbox1.focus()

or else
check below syntax in your web.config

<system.web>
<pages>
<controls>
<add tagprefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI">

add the above code to add tagprefix in .aspx page of your page and try again

could you post your code so that I can check where it was going wrong

yes sinisa is right

post gridview code completly its not completed here

post your code so that we can try to resolve the problem

you are asking about close button but you are not posting code upto that element

y its not working for you, its working fine here,, you just post complete aspx code,not in the comment edit the question and place there and tel me then i'll check

where did you added the button code in your page in body part?

s

use below button it will work
<asp:ImageButton ID="ImgExit" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Exit.png" AlternateText="Exit" OnClientClick="window.close()" />

why did you use <link href="javascript:window.close()">Close Window />

it wont work rather use below code in body part

Close Window

ok i got it

where is exit button

where is exit button code

send me i'll try

its working fine here

The code which you have tried is correct as per logic, but your code is having small syntax errors like { missing, etc...

change your button click event like below

private void button1_Click(object sender, EventArgs e)
{
BirthdayParty partyOn = new BirthdayParty();

MessageBox.Show( partyOn.getMessage("Shadid")+"\n"+partyOn.getPresents(8)+"\n"+partyOn.getParty( true));
}

have you tried solution1

Post the code which you have tried so that we can try to find what's the problem is

check the above code in solution3 try with that and tel me whether it worked or not

i could not understand your problem, sum of digits from 2 textboxes means
1) you want to add the numbers then calculate sum of digits
2) You want to concatenate both numbers then calculate sum of digits

tell me what you wanted to do

me tooo...

yeah i know... but it was of very useful

welcome , happy coding

send me those tables details and tel us which details you want to display

no i must display it on a label only,iam not allowed to display using javascript

in that case, when i display the success message on label it wont be displayed when i use response.redirect

which error

this method must like this why did you changed, use as it is man

private string radPopupCloseScript(string ActionName)
{
String script = @"var oArg = new Object();
oArg.actionName = '" + ActionName + @"';
var oWnd = GetRadWindow();
oWnd.close(oArg);";
return script;
}

no need of script tag as we are using script manager

this method must like this why did you changed, use as it is man

private string radPopupCloseScript(string ActionName)
{
String script = @"var oArg = new Object();
oArg.actionName = '" + ActionName + @"';
var oWnd = GetRadWindow();
oWnd.close(oArg);";
return script;
}

send me aspx page code also

use scriptmanager not radscript manager

protected void IssueCancel_Click(object sender, EventArgs e)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "closed", radPopupCloseScript("closed"), true);
}

i have asked to post the modified code not previous code again

could you post your code once again so that i can correct it

below is select query
Sqlstr = "select sum(sal_bonus) as bonusamt from salary_master where sal_deleted = 0 "+
" and year(sal_bonusdate) = " + lngPreviousYear + " and comp_id = " + strCompanyid +
" and emp_code = '" + Txt_Employee.Text+ "' and sal_type = '" + vpcn.cSalary_2Half + "' ";

the below is stored procedure for your code you need to pass parameters to it.

CREATE Procedure GetBonus
@lngPreviousyear int,
@CompanyId int,
@empCode varchar(50),
@SalType varchar(50),
@Bonussal money output
AS
BEGIN
select @Bonussal=sum(sal_bonus) from salary_master where sal_deleted=0 and year(sal_bonusdate)=@lngPreviousyear
and comp_id=@CompanyId and emp_code=@empCode and sal_type=@SalType
END

have you added the code as it is, its working here try to trace the code as it is

what is vpcn, is it a table, if so what are the fields in vpcn table and alary_master table send them so that i can write the query

do one thing copy your code with below code as it is it will work, accept solution if it works

public string UpdateUserID(string updateID)
{
UpdatedBy = System.Web.HttpContext.Current.Request.LogonUserIdentity.Name.Substring(12);

string sql = "select * from Cwipuser.CWIP_Variances ";
SqlCommand cmd = new SqlCommand(sql, MyCon);
MyCon.Open();
SqlDataReader rdr = cmd.ExecuteReader();

while (rdr.Read())
{
if (!rdr.IsDBNull(1))
{
updateID = rdr.GetString(1);
}
updateID = UpdatedBy;
}
MyCon.Close();
return updateID;
}

ofcourse this data is available in your database but the output of your select query is returning only updateid so only one index will be there

then you need to give index number 0 only


you just use below code in the place of your while loop code,you will get the result

while (rdr.Read())
{
if (!rdr.IsDBNull(0))
{
updateID = rdr.GetString(0);
}
updateID = UpdatedBy;
}

but in your select query you are returning only update_Userid right? then how will you get ID

you are giving the fields from your code with out explaining about them for us,how could we know what is what , and how could we wrtie query for you with out knowing any of your fields,, try to ask question clearly

you need query or procedure

what is id and updateid here you are returning only updateuserid from the select query right then how will you get id

i think the result is having only one value, check it by debugging

welcome

heyyy,i have changed solution1 again,check it

heyyy,i have changed solution1 again,please check it

check solution1

look at solution1

r u having any data in tbluser table

Remove Validation group for both validator and button

like below

<asp:CustomValidator ID="CustomValidator1" runat="server" ErrorMessage="ename,ename1 must match"
OnServerValidate="CustomValidator1_ServerValidate" ValidateEmptyText="true">


<asp:Button ID="btnsubmit" runat="server" Text="Submit"/>

check it now

welcome, happy coding

did you get what you required or not??

protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{

CustomValidator cv = (CustomValidator)source;
GridViewRow gvr = (GridViewRow)cv.NamingContainer;
CheckBox chk = (CheckBox)gvr.FindControl("CheckBox1");
TextBox txt1 = (TextBox)gvr.FindControl("TextBox1");
TextBox txt2 = (TextBox)gvr.FindControl("TextBox6");
string serials = txt2.Text;
string[] sl = serials.Split(',');
if (chk.Checked == true)
{
if (sl.Length == Convert.ToInt16(txt1.Text))
{
args.IsValid = true;
}
else
{
args.IsValid = false;
}
}
else
args.isvalid=false;
}

check with below code

what output did you get

check solution2

post your code which you have tried, so that we can help you

look at solution2

Thanks a lot,but i want to know how to save this file in required path

hi have you got the answer

could you tell me onething json format means how do you want your output whether on xml file or on a control or anything else

thats not a problem, as a fresher these confusions will be common, try to ask your question clearly so that you can find answer more quickly,in the start itself if u have ask me about json format may be i try to get that only

displaying o/p in json format ,i too dont have idea,i need check that then i wil tel u

tell me onething whether you got alert message or not on button click

for username problem change webservice to below method


[WebMethod]
public string Inserttblval(int CountryId, string UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection(your connectionstring);
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([CountryId],[UserName],[IsActive]) VALUES ({0},'{1}',{2})", CountryId,UserName, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
}

what, r u getting alert message showing number of records inserted or not

can you tell me what's the error you are geting now clearly

here one thing you need to understand is for integers no need of (''),but for string you need to use single quotes,thats the error for username not accepting string,ok try to look at the above method you can understand easily....

for username problem change webservice to below method


[WebMethod]
public string Inserttblval(int CountryId, string UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection(your connectionstring);
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([CountryId],[UserName],[IsActive]) VALUES ({0},'{1}',{2})", CountryId,UserName, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
}

sorry for late reply,I have Left for lunch

no need of button code it will execute, we have written it in javascript function

have u added aspx code also same like above

check solution once again i have modified it

remove <pre>

look at solution3 and follow as it is dont change any thing

ok i will send you complete code step by step just follow that

in which line you are getting error input string not in correct format error

send me the method which you have written in webservice so that i can check ,what could I do with the error

use the method name which you have created in webservice in place of InsertWebService
try to solve small errors

use below line
return ws.InsertWebservice(countryid,username,isactive)

add this webmethod to cs page

using System.Web.Services;
[WebMethod]
public static string GetValues(int countryid,string username,int isactive)
{
WebService ws = new WebService();
return ws.inserttblval(username, countryid, isactive);
}


add below Javascript method to aspx page in head part:

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js"></script>
<script type="text/javascript">

$(function () {
$("[id*=btnSubmit]").click(function () {
var obj = {};
obj.countryid = $.trim($("[id*=TextBox2]").val());
obj.username= $.trim($("[id*=TextBox1]").val());
obj.isactive= $.trim($("[id*=TextBox3]").val());
$.ajax({
type: "POST",
url: "execnonqueryex.aspx/GetValues",
data: JSON.stringify(obj),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (r) {
alert(r.d);
document.getElementById('lblmsg').value = r.d;
}
});
return false;
});
});
</script>

all buttons are having same id??

why it was not working for you its working fine here
i have used below code in rowdatabound event check that once
if (e.Row.DataItem != null)
{
Button btnsubmit = (Button)e.Row.FindControl("btnsubmit");
btnsubmit.Attributes.Add("onclick", "return gviewValidate(" + e.Row.RowIndex.ToString() + ")");
}

from which event you are adding this event to the button

all the three at a time as a string means,its not possible

with out knowing how to write json method why are you trying to use json.

where is your json funtion from where you are getting these values UserName,CountryId,IsActive

replave your button click event with below code

protected void Button1_Click(object sender, EventArgs e)
{
WebService ws = new WebService();
Label1.Text = ws.Inserttblval(int.Parse(TextBox1.Text),TextBox2.Text,int.Parse(TextBox3.Text));
}

post complete code of your page

lblmsg.Text=ws.Insertempdet(countryId, username, isactive);

have you given the values for username,countryid,isactive

this is not the function where we have worked up to now right, check remaining code in your page

have you got the solution???

first you need to create webmethod in webservice like below

[WebMethod]
public string Insertempdet(int CountryId, string UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection(your connectionstring);
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}',{2})", UserName, CountryId, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
}



create an object for webservice in your page CS Code

WebService ws = new WebService();


then call the webmethod in respective event like below return value i was displaying in label


lblmsg.Text=ws.Insertempdet(countryId, username, isactive);

first you need to create webmethod in webservice like below

[WebMethod]
public string Insertempdet(int CountryId, string UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection(your connectionstring);
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}',{2})", UserName, CountryId, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
}



create an object for webservice in your page CS Code

WebService ws = new WebService();


then call the webmethod in respective event like below return value i was displaying in label


lblmsg.Text=ws.Insertempdet(countryId, username, isactive);

post complete code of your page so that i can know whats the problem, i dont know why you are getting this error i have executed it but didn't get any error

have you selected start page for your website???

could you post code where you are calling above method

look at solution2

if isactive is int why did you give string in function parameters
there also you need to use int

string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}','{2}')", UserName, CountryId, IsActive);

use above statement it may help you

Then use like below

strQuery += " proj_name = 'not completed' and unit_description ='not completed' AND company_code ='not completed' AND status='not completed' ORDER BY Contract_num DESC";

what, have you executed it
if you got the answer then accept solution

could you post your code so that i can know what is the error is

check solution 3

strQuery += " proj_name and unit_description AND company_code AND status='not completed' ORDER BY Contract_num DESC";

what is the purpose of above line

CS Code:


protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
getdata();
}
}

public void getdata()
{
SqlConnection con = new SqlConnection(your ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("select * from tablename", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
getdata();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox t1, t2;
t1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName");
t2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtAge");
RadioButtonList rdb;
rdb = (RadioButtonList)GridView1.Rows[e.RowIndex].FindControl("RadioButtonList1");
SqlConnection con = new SqlConnection(your ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("Update tablename SET Name='" + t1.Text + "',Age=" + t2.Text + ",[Yes/No]=" + rdb.SelectedValue + " where Id=" + GridView1.DataKeys[e.RowIndex].Value + "", con);
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
getdata();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataRowView drview = e.Row.DataItem as DataRowView;
if (e.Row.RowState == DataControlRowState.Edit)
{
RadioButtonList rdb;
rdb = (RadioButtonList)e.Row.FindControl("RadioButtonList1");
int yesno = int.Parse(drview[2].ToString());
if (yesno == 1)
rdb.SelectedIndex = 0;
else
rdb.SelectedIndex = 1;

}
}

aspx code:


<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="id"
OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowDataBound="GridView1_RowDataBound">
<columns>
<asp:TemplateField HeaderText="Name">
<itemtemplate>
<%# Eval("Name") %>

<edititemtemplate>
<asp:TextBox ID="txtName" runat="server" Text='<%#Eval("Name") %>'>


<asp:TemplateField HeaderText="Age">
<itemtemplate>
<%# Eval("Age")%>

<edititemtemplate>
<asp:TextBox ID="txtAge" runat="server" Text='<%# Eval("Age") %>'>


<asp:TemplateField HeaderText="yes/No">
<itemtemplate>
<%# (Eval("Yes/No").ToString()) == "1" ? "Yes" : "No" %>

<edititemtemplate>
<asp:RadioButtonList ID="RadioButtonList1" runat="server">
<asp:ListItem Selected="False" Value="1">Yes
<asp:ListItem Selected="False" Value="0">No



<asp:CommandField ShowEditButton="true" />
<%--<asp:BoundField HeaderText="Name" DataField="Name" />
</columns> >

can you post your code for editing so that i can change them accordingly..

I couldn't understand your problem,could you explain it more clearly...

Welcome....happy coding

add below function to your CS file

protected void AdRotator1_AdCreated(object sender, AdCreatedEventArgs e)
{

}

could you send me selectedindex changed event code

if ContractNo is integer then

amicassaCon_repgen.Open();
SqlCommand get_no = new SqlCommand("DECLARE @GetNo int IF EXISTS(SELECT ContractNo FROM MC.tblContracts WHERE ContractNo="+company_code.SelectedValue+" and ContractPrjunitdesc='"+unit_desc.Text+"') BEGIN SET @GetNo=0 END ELSE BEGIN SET @GetNo=1 END SELECT @GetNo", amicassaCon_repgen);
SqlDataReader drno = get_no.ExecuteReader();
if (drno.Read())
{
if(drno[0].toString()!="0") \\contract not exists
{
//my codes for inserting data and displaying to the grid view
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Error: Already had a Contract!');", true);
}

}
drno.Close();

no actually GetNo is a binary value representing 0 or 1
"0" means Contract exists
"1" means Doesn't Exist

if ContractNo is varchar value then change below code
amicassaCon_repgen.Open();
SqlCommand get_no = new SqlCommand("DECLARE @GetNo int IF EXISTS(SELECT ContractNo FROM MC.tblContracts WHERE ContractNo='"+company_code.SelectedValue+"' and ContractPrjunitdesc='"+unit_desc.Text+"') BEGIN SET @GetNo=0 END ELSE BEGIN SET @GetNo=1 END SELECT @GetNo", amicassaCon_repgen);
SqlDataReader drno = get_no.ExecuteReader();
if (drno.Read())
{
if(drno[0].toString()!="0") \\contract not exists
{
//my codes for inserting data and displaying to the grid view
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Error: Already had a Contract!');", true);
}

}
drno.Close();

tell me whether ContractNo is integer or varchar value

use below code


amicassaCon_repgen.Open();
SqlCommand get_no = new SqlCommand("DECLARE @GetNo int IF EXISTS(SELECT ContractNo FROM MC.tblContracts WHERE ContractNo="+company_code.SelectedValue+' and ContractPrjunitdesc='"+unit_desc.Text+"') BEGIN SET @GetNo=0 END ELSE BEGIN SET @GetNo=1 END SELECT @GetNo", amicassaCon_repgen);
SqlDataReader drno = get_no.ExecuteReader();
if (drno.Read())
{
if(drno[0].toString()!="0") \\contract not exists
{
//my codes for inserting data and displaying to the grid view
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Error: Already had a Contract!');", true);
}

}
drno.Close();

copy above code as it is and use it in new webpage and try, please tell me if there are any errors, i have used above code in my project for popup window its working fine.

previous post is modified code of the question
current post is the code which i have executed in my project
thats why I have posted both of the answers.

then use below statement.
if(drno[0].toString()!="0")

sorry its not @DeptNo it is @GetNo

could you send me complete page of your page so that i can find out whats the error is

still there are errors?

have you tried solution 3

could you please tell me the same thing for RAD list view also

Sorry ,
its working fine now I have placed the code in wrong place that's why it didn't worked.
I am So sorry its my fault only.

Thanks for reply,
but its not working

ok Thankyou, i will work on it

Hi,
Thanks for your reply, i need to display a grid in the popup window is it possible with jquery.