Comments by udusat13 (Top 177 by date)

Hi, all

Ples help me to solve this problem , I am new to jquery & unable to solve this problem

I tried noconflicts but problem is unsolved.

Please give me hint with my example.

Thanks for reply,

js File in master page is used for Slideout window which , i have to show on every page , while
js file in content page is for datetime control, & its only for single page.

& please expln me how to to use noconflict().

Thanks For reply.

This is the only code i am using.

Above mentioned Javascript file and class="timepicker" for textbox(timepicker textbox).

The table was poorly indexed.

Now Its working fine.

Thanks for suggestion.

thanks for links and reply.

Thanks For your reply,
I have indexed the table.

Not Hacked.But Someone trying to hacked.& Our Other PHP websites hacked.

Thanks for your comment and reply.

thanks for reply

<connectionstrings>

<add name="expodatabaseConnectionString" connectionstring="Data Source=PC-UDAY;Initial Catalog=expogroupdb20jan;Integrated Security=True" providername="System.Data.SqlClient">



My project is workin fine when i run the project.

But when i create setup file and installed on my pc ,its not working.

Thanks for Your reply.
But Its not working for me.

How to store datagridview entries entered during powerloss and which format( like Excel,word,sql) ?

And

Should i use Microsoft.Win32.SystemEvents or FormClosing event ?

Thanks for your reply.but please explain.

Thanks for your reply

Thanks For Solution.

Thanks for links.

Thanks For replying me.
Now I got idea and actual difference between these 2 and other 2 joins.
And decided to use inner join.

Thanks For replying me.
Now I got idea and actual difference between these 2 and other 2 joins.

Thanks
for Your link,
I have created robot file.

Thanks
for Your link,
I have created robot file.

thanks but i am confused,
because i am new to sql server

Thanks for solution.

but it gives error like

The multi-part identifier "emailinfo.email" could not be bound.
The multi-part identifier "keywords.keyword" could not be bound.

Thanks for replying me,
but your above query retrives all the emails from emailinfo table.
i have added yahoo keyword in keywordinfo table,but still it retrieveing email that contains yahoo keyword.

Please help me.

Thanks for replying me.
I have already indexed email column from emailinfo table and keyword column from keyword info table.

Please check the query is right or not?
Thanks again.

thanks.........
now its working

Thanks for reply me.

Please tell me how to set permission.
I am new to asp.net

Thanks.
yes.because i ahve uploaded image with php code successfully.
But FileUpload.saveAs() giving that error.

Thanks for your solution.

Thanks.....

Thanks ,

I have tried like following
<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="http://www.indiatvnews.com/rssfeed/sports_cricket_news.php"
XPath="/item[fn:contains(/description/InnerText(),'IPL')]">

but it gives exception
System.Xml.XPath.XPathException: 'rss/channel/item[fn:contains(/description/InnerText(),'IPL')]' has an invalid token.

please help me.

Thanks again

Thanks,

But according to you,i haven't found any special node for IPL in that xml.
Please tell me, if i missing something.

Please check my code,

i am reading xml like following

XDocument doc = XDocument.Load("http://news.google.com/news?pz=1&cf=i&ned=us&hl=en&topic=e&output=rss");

now from this xml i have to fetch image src value, to display those all image.

these are dynamic news section.
Please help me.

Thanks for ur solution.

Thanks....

Thanks...
I ll check....

Thanks.

img.src = '<%= System.Configuration.ConfigurationSettings.AppSettings["SitePath"].ToString()%>

above line shows null reference
i have created Keepalive.aspx page..

thanks for reply.
But how to get command argument using ajax or jquery.

Finally i have used file upload control.
Thanks for help.....

Thanks.

But i want to join ado.net datatable and mysql database table.

Thanks.

Yes but i want to join ado.net datatable and sql database table.

I am reading excel and storing it in datatable.
ex
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties=Excel 5.0";
ExcelConnection = new OleDbConnection(ConnectionString);

//Reading from excel
string ExcelQuery = " Select contact_name,contact_name2,company,website,website1,contact_number,fax,telphone,mobile,product," +
"country,designation,designation2,address,email,email1,email2,email3,inquiry_status,interested_in,reason,category,date from [Sheet1$] EXCEL " +
ds = new DataSet();
da = new OleDbDataAdapter(ExcelQuery, ExcelConnection);
da.Fill(ds, "TEMP");
DataTable tblWithExcel = ds.Tables["TEMP"];

and now i want to join this(tblWithExcel) with my database inquiry table.

Please help me.

Thanks for link.
But sir file upload control upload the file on server side.
I need the control for only reading excel data.

Is it necessary to upload excel file for reading and inserting?

Thanks.but

Its not working.
It not showing any results.

when i use date query without dynamic and using variable as datetime then it working for me.

But when i convert it into nvarchar and use it in dynamic sql statement.
then it not showing results.

SELECT * FROM companyinfo company WHERE COMPANY.date > 01/25/2012 ORDER BY COMPANY.date DESC
above query with date as nvarchar displays all the results from table,the rows less than date and greater than also.

But when i use same query with @m_fromdate as datetime then it working fine for me

Thanks For replying me.

Your solution is helpful for me for other stored procedures also...

Thanks Again.

Thanks.

suppose there are keywords like webmaster,webcom,master etc in keyword column in keywordinfo table .
And i want to retrive all the email from emailinfo table which not containing these keywords from keywordinfo table.

its same like simple like query.

eg
select email from emailinfo where email not like '%webmaster%'

but here i wants to skip all the emails based on keywords from that table(keywordinfo).

I am searchin for query like,

select email from emailinfo where email not like '%' (select keyword from keywordinfo) '%'

This is my javascript code

<script type="text/javascript">


function addLoadEvent(func) {
var oldonload = window.onload;
if (typeof window.onload != 'function') {
window.onload = func;
} else {
window.onload = function() {
if (oldonload) {
oldonload();
}
func();
}
}
}

function pageLoad() {
//PageMethods.DoLongJob("Start", SucceededStartCallback, FailedStartCallback);
InitDialogs();
Loading(false);

}


function UpdateImg(ctrl, imgsrc) {
var img = document.getElementById(ctrl);
img.src = imgsrc;
}



// sets up all of the YUI dialog boxes
function InitDialogs() {

DialogBox_Loading = new YAHOO.widget.Panel("waitBox", { fixedcenter: true, modal: true, visible: true, width: "230px", close: false, draggable: true });
DialogBox_Loading.setHeader("Loading, please wait...");
DialogBox_Loading.setBody('<div style="text-align:center;"><img src="tt_spinner.gif" id="Image1" /></div>');
DialogBox_Loading.render(document.body);
}

function Loading(b) {
if (b == true ) {

DialogBox_Loading.show();

}
else {
DialogBox_Loading.hide();
}
}

addLoadEvent(function() {
pageLoad();
})

</script>

and i am calling it from showButton

I am showing wait image for longRunning process.
and i am refering this code from u r site.

http://www.codeproject.com/KB/aspnet/WaitImageBoxWhilePagePost.aspx

and i am calling the ur javascript on button event.
without updatepanel its working fine but when i put this in update panel then it remains blocked.

Thanks for replying me.
But if i post this code on page load event of perticuler page it shows reminder only when page will be refreshed or page load.

I want display even if page is not refreshed and automatically.

Thanks.
Its very nice example

Thanks....

Thankss...........

its working in certain condition.means if selected value is 1 then it searches 5,11,2 also because of event_ids like "," + ddlEvents.selectedValue

11,21,31,,41 also ends up with 1 which also satisfy like value,% this condition,
Please give me other solution
Thanks....

its working in certain condition.means if selected value is 1 then it searches 5,11,2 because of
event_ids like "," + ddlEvents.selectedValue

Thanks...
I ll try tommorrow
Thanks .................

Thanks...
I ll try tommorrow
Thanks .................

Thanks
But its workin if @ @value=3 and database field contains only 3 . When fields contains 4,3 or 3,4 or 3,5,6. its not working.

Thanks...
But its working if selected id is 2 and events ids from database that begin with 2 like (2,4,5) not working when for (4,2,5) or (5,7,2)

yes Finally I got solution..
Thankss For giving me idea.

ListViewDataItem item = (ListViewDataItem)e.Item;

DataRowView drvItemIds = (DataRowView)item.DataItem;
string strItemIds = drvItemIds["event_ids"].ToString();

I wrote above code.

strItemIds string contains "1,2,4"

Now I am passing these values in following query.

string strQueryRecentCampaign = "SELECT event_name from crm_event where event_id IN ("+strItemIds+") ";

but it gives error because strItemIds is string.
How to pass like IN (1,2,4)

Thanks Sir.Please show me an example.

Thanks again

Hi expert,
Thanksss for solution. But sir i am not using stored procedure.
I want query in asp.net

Thankssss .

I want the javascipt validation code on update button.I took one following update button in EditTemplate
<asp:LinkButton ID="LinkButton2" runat="server" Text="Update" CommandName="Update" />

var eventStatus=document.getElementById("<%=txtEditEventName.ClientID%>").value;

this line giving me error that txtEditEventName name does not exists.

I am not finding controls within EditTemplate in javascript.

I add javascript code in EditTemplate but still it giving same problem.

I used condition
if (listvwEventResult.EditIndex > -1)


Now its working.

Thanks..............

I write following code on ItemBoundEvent.

but it throw exception object null reference.datatable working fine.
but when i control reach at point
listEditCountry.DataSource = dt; it throws exception.



ListViewDataItem item = (ListViewDataItem)e.Item;

DropDownList listEditCountry = (DropDownList)e.Item.FindControl("lstEditCountry");


try
{
string queryStrUserType = "SELECT country_id,country_name FROM crm_countries";

ClassDtBaseConnect clsDtResult = new ClassDtBaseConnect();
DataTable dt = clsDtResult.GetDataTable(queryStrUserType);



listEditCountry.DataSource = dt; //this line throw exception object null reference. datatable dt working fine.
listEditCountry.DataValueField = "country_id";
listEditCountry.DataTextField = "country_name";




listEditCountry.DataBind();

Thanks for code..
But i am n using listview not gridview.

So which event is necessary?
Please help me?

Thanksss For Linkss.....

Thankssssssssssss....

Ok......

But there will be atlist 24 conditions (4*3*2).

Thankssssssssssssss...

check following code

protected void Page_Load(object sender, EventArgs e)
{
DropDownList ComboBox = new DropDownList();
ComboBox.ID = "ComboBox";
ComboBox.AutoPostBack = true;

ComboBox.Items.Add(new ListItem("Year: 2010", "2010"));
ComboBox.Items.Add(new ListItem("Year: 2011", "2011"));
ComboBox.Items.Add(new ListItem("Year: 2012", "2012"));
ComboBox.Items.Add(new ListItem("Year: 2013", "2013"));
ComboBox.Items.Add(new ListItem("Year: 2014", "2014"));

ComboBox.SelectedIndexChanged += new EventHandler(Dynamic_Method);

this.form1.Controls.Add(ComboBox);
}
protected void ddlFilter_SelectedIndexChanged(object sender, EventArgs e)
{
Response.Write(Request.Form["ComboBox"]);
}
private void Dynamic_Method(object sender, EventArgs e)
{
//Response.Write(((DropDownList)sender).SelectedIndex.ToString());
//Response.Write(Request.Form["ComboBox"]);
DropDownList ComboBox = (DropDownList)sender;
string sSTR = "";
sSTR = "</br>Selected Index: " + ComboBox.SelectedIndex.ToString();
sSTR += "</br>Selected Item: " + ComboBox.SelectedItem.Text.ToString();
sSTR += "</br>Selected Value: " + ComboBox.SelectedItem.Value.ToString();

Label lbl = new Label();
lbl.Text = sSTR;
this.form1.Controls.Add(lbl);
}

Thanks.....

Actually my question is regarding how to write select query which cover all 4 criteria...
Sometimes user can select country, sometimes country and date,some times country and status and date.

How to manage these condition in one query?

Thanks.....

Actually my question is how to write select query which cover all 4 criteria...
Sometimes user can select country, sometimes country and date,some times country and status and date.

How to manage these condition in one query?

Thanksssss.....

thankssss this code is working fine for me.......

Thankssssss.....

Thanks for suggestion........

But for this code can i use (!IsPostBack) or i have directly insert it into page load....

Tyhankssssssssss......

Thanks For links....

Thankssssss For links.....

Thanksssssssssssssss...

Thankssss....

Thankssss fro replying for me...........

Thankss.................

Its Working for me...............

Thanksssss For u r suggestion.

But Sir is it possible without triggers.
Is there any function like identity() present in sql server

Thanksssssssssss....

This Code is working nice for me

Thanksssss...

Thankssssssss.

Its working for me.

Thanks for replying me,

I have modified my code like following

myString = new String("*&^%$#@") //list of special char.
if(myString.indexOf(eventName) != -1){
alert("Special char not allowed");
return false;
}

and its working only if first letter is special char,

Please guied me .

Thankssssss..

To avoid server round trips, i am using client side scripting.

Thanksssssssss for replying

what is type of category column in TblEvent.It is text or catgoryId.
I am getting confused and i am very week in database.


Thanks again

Thankssssssss for your valuable suggestion

Thankssssssss for your valuable suggestion

Ok.....

Thankssss..

Thankssssssssss..

cellpadding working in all browser but cellspacing not working in mozilla

Thanksssss.....
for http://www.motive.co.nz/glossary/linking.php

thanksssssssssss

Ok

Thankssssss..

But now using above code,from home page its not working,
and path showing ~/event/new_event.aspx

my home page is in root folder and other folder are in root also with pages.

Thanks for ur code.
Its working for me............

Thanksss,

Using table is better approch or div?
Please tell me,because my design side is week.

<div id="MainDiv">

<div id="DivTopHeader" style=" position:relative; z-index:2;">
//For Header and Menu bar
</div>

<div id="middle">

<div id="left">
Here I have to place all controls

</div>
<div id="right">For search and images</div>
</div>



</div>

Thankssssssssssssss.

Thankss...

its nice advice

Thankssssssssssssss..

I always keep this in mind..........

Thanks..

document keyword was missing in my javascript.

Thanks............

Thanksssssssssssss..........

Thanksssssssssssssssss.

Thanks .......

Hi expert i have added code
Please give mi suggestion

my form code is following

<form name="frmquicksearch" method="post" action="search.aspx">
<table border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td width="25"> <div align="right">Search:</div></td>
<td width="110"> <div align="center">
<input type="text" class="fieldtext2" name="data">
</div></td>
<td width="25"> <div align="center">
<input type="button" name="Submit2" value="Go" önclick="return Validate1();">
</div></td>
</tr>
</table>
</form>

and javascript code is,

function Validate1()
{

if (frmquicksearch.data.value=="" )
{
alert("Please Enter Search Keyword");
frmsearch.data.focus();
return false
}
else
return false;
}


and above code is working for Google chrome but not in

Mozilla browser

No sir/madam its not working.
Exception is gone but its showing blank string.

Ok

thnksssss.
i have added the property code in code behind page.


and
<%# Eval("Categeory")%>
above line is added in listview.

then i start to tracing using breakpont but
<%# Eval("Categeory")%>

this line throw exception.

for simple
<%# Eval("categeory1")%><%,%> <%# Eval("categeory1")%><%,%> <%# Eval("categeory1")%>
working for me.but then it is problem to find substring.

thanksssssssssss for ur valuable time.

But still it giving same exception as above

Thanksssssssssssssssssss But Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. this exception was thrown;

please help me.

Thanksssssssssssssssssss

But
Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.



this exception was thrown;
please help me.

Thanksssssssss.

Thnks sir....


Yes I know about gridview but my Situation demands this.

Please help me.

Thanks..........

Thankssssssssssssssss............

Thanksssssssss.

Thanksssssssssssssss.

Thanks.........

For ur valuable suggestion.

Reagrding to This,
"Why don't you write insert code in Button_Click of subscribe.aspx and then redirect to other page."

will it fast my application?

Thanksssssssssss

thanksssssssssssssssssss

Thanks ................

thanks expert.

Giving me result according to by result

Thanks For reply.

But
why there are 2 methods please help me.

Thanks again

Thanks For reply
me

I am trying now

Thanks....
i got idea.

Thanks ..

dataset.Rows.Count is working for me

but
what is equivalent to Recordset.PageSize,Recordset.AbsolutePag in asp.net

for dataset object.

thanks again

Thanks sir..


I know RecordSet is not in Asp.Net.

But i have convert it into asp.net for Dataset for existing code to run.

please help me

Thanks..............

Its working...

Thanks........
But sir i am not using .net control.I have to show result in table control.because my results are dynamic.

Thanks..

In MY C:\WINDOWS\system32 folder, i have found odbcad32.exe this file.
Now what i can do?
Now which manager i have to use or i have reinstall odbc for 32 bit.

Please guied me.

Thanks.

yes..
I have install odbc.and odbc wizard successfully connect and create odbc.

Thanks ..

But still it giving sAME ERROR.

Thanks.

But I have already visit this site.
How to remove the error. I odbc created without error.

But error in connection string.

Thanks.................

Thanks..
But i have use setter getter.

After Successfull login i have set login id.then close the login form.when i try to access that variable again.it shows null value.

Thanks Sir/Madam,

I have edited code like this

{
try
{

string path = txtUploadFlNm.Text;

string[] readText = File.ReadAllLines(path);

if (readText[0] == "email")
{

List<string> badEmail = new List<string>();
List<string> goodEmail = new List<string>();

for (int i = 1; i < readText.Length; i++)
{
if (validEmail(readText[i])) // check valid
{
goodEmail.Add(readText[i]);
}
else
{
badEmail.Add(readText[i]);
}
}

string guid = Guid.NewGuid().ToString().Replace("-", "");
string dataID;
string today = DateTime.Now.ToLongTimeString();
int m = 1;

T_XML_TRANSACTIONDETAILS.Append("<master>");
for (int i = 0; i < goodEmail.Count; i++)
{
m = m + 1;
dataID = guid + "-" + today + m.ToString();

T_XML_TRANSACTIONDETAILS.Append("<TRANSACTION>");
T_XML_TRANSACTIONDETAILS.Append("<maxid>" + SecurityElement.Escape(dataID) + "");

T_XML_TRANSACTIONDETAILS.Append("<email>" + SecurityElement.Escape(goodEmail[i]) + "");

T_XML_TRANSACTIONDETAILS.Append("</TRANSACTION>");
}
T_XML_TRANSACTIONDETAILS.Append("");

progressBar1.Show();
backgroundWorkerText.RunWorkerAsync();

//string duplicateemails = Convert.ToString(ds1.Tables["rowsinserted"].Rows[0][0]);

//DialogResult result;

//if (badEmail.Count == 0)
//{

// MessageBox.Show("Total Companies: " + readText.Length.ToString() + "\nDuplicates :" + duplicateemails + "", "", MessageBoxButtons.OKCancel);

//}
//else
//{

// int id = CustomMessageBox.ShowBox("Total Companies: " + readText.Length.ToString() + "\nDuplicates :" + duplicateemails + "\nBad Emails: " + badEmail.Count.ToString() + "\nclick view to save/view bad Email", "Expogroup");

// if (id == 2)
// {
// badEmailInTextFile(badEmail);
// }
//}

MessageBox.Show("Donnne");
}
else
{
MessageBox.Show("Please enter email at the top of text file", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception)
{ }


}


and

On backgroundWorkerText_DoWork

I have added database code

But First Its working properly .second time not.

Please any one give me solution

Thanks
But how to put database code in background worker.
Please guied me sir.
I am new to c sharp.

Thankssssssssssssssss.

Thanks sir.

But
if(cmbSelectFileType.Text == "Text") //this line throws following exception.
Cross-thread operation not valid: Control 'cmbSelectFileType' accessed from a thread other than the thread it was created on.

Please help me
thanks

Thanks Sir,
According to article I have modified code like following

public TestForm()
{
InitializeComponent();
backgroundWorker1.WorkerReportsProgress = true;
}

private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{

// backgroundWorker1.ReportProgress();
uploadUsingText();
}
}

private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
progressBar1.Value = e.ProgressPercentage;
}

private void button1_Click(object sender, EventArgs e)
{
backgroundWorker1.RunWorkerAsync();
}

but progress bar value remained same

I am getting confused regarding backgroundworker.

on my button click i am calling following long running method

if (checkValidRowsEmails() == true && validation())
{
addDataUsingXml1();
}



please help me

thankssssssssssssssssssssssssssssss
its working for me

Thanks for watching my sp.
Regarding ur suggestion i have modified code like this


ALTER PROCEDURE [dbo].[SearchCatalogOrUrlInformation]

@username int,
@urlorcatalog varchar(100)
AS

BEGIN

SET NOCOUNT ON;


DECLARE
@M_username int,
@M_urlorcatalog varchar(100)

SET @M_username=@username
SET @M_urlorcatalog=@urlorcatalog

-------------------------------------------------
-- Limit list of just the users / URL Catalogs --
-------------------------------------------------

SELECT
c.dataID
, c.userid
, c.companyname
, c.urlorcatalog
, c.dataentrytype
, c.[Date]
INTO #Company
FROM companyinfo c
WHERE
COMPANY.userid=@M_username AND
COMPANY.urlorcatalog LIKE '%'+ @M_urlorcatalog + '%'


SELECT
COMPANY.urlorcatalog AS 'Source'
, COMPANY.companyname AS 'Companies'
, CATEGORY.categoryname AS 'Category'
, REGION.regionname AS 'Region'
, usr.name AS 'User'
, count(email.email) AS 'Collection'
, COMPANY.dataentrytype as 'Type'
, COMPANY.date AS 'Date'
FROM #Company COMPANY
INNER JOIN dbo.emailinfo email ON COMPANY.dataID = email.DataID
INNER JOIN dbo.userinfo usr ON COMPANY.userid = usr.ID
LEFT OUTER JOIN dbo.category CATEGORY ON COMPANY.category=CATEGORY.ID
LEFT OUTER JOIN dbo.regioninfo REGION ON COMPANY.region=REGION.ID
GROUP BY
COMPANY.urlorcatalog
, COMPANY.companyname
, CATEGORY.categoryname
, REGION.regionname
, COMPANY.dataentrytype
, COMPANY.date
,usr.name

ORDER BY COMPANY.date DESC

DROP TABLE #Company

but it generate error message like
Incorrect syntax near '#Company'.
near this line
DROP TABLE #Company

http://www.codeproject.com/KB/database/sql-tuning-tutorial-1.aspx

i have read this for execution plan but i am getting confused how to implement it

please view my sp once and check any mistake

thanks.............

Please give me solution if possible.
and my datagridview is not dynamic

or progressbar is also acceptable.

Invalidate() method for what?
on which control?

Thanks suggestion for naming convention

allPanelControl enabled true false working properly for me.

but picturePanelControl must visible before the code stated. but it not working properly.
It get visible just before method finished.Even though setting visible true before allPanelControl enabled false.

Actually I am using panel.All the control are in panel1 and picturebox is in panel2.

and my changed code is

if (validation())
{
// panel2.Visible = true;
panel1.Enabled = false;

// pictureBox1.Visible = true;
uploadUsingText();
panel1.Enabled = true;
panel2.Visible = false;

}
but
it not working
properly

and i am using net3.5 version

Thanks sir.
its working

please sir give me example

thanks sir.
please tell me in details and i want count also

Thanks

Yes its working for me

how i can insert identity column
Give me specific example

I am confuse.please give me solution

yes its working for me

its working for me

its working for me

Thanks its really working

please give me example of stringbuilder fro binding

Thank u sir,
Its really working for me.
Thanksssssssssssssssssssssssssssssssssssssssssss!

please help me sir i am getting confused

But please tell me what mainForm.Children

in foreach (Form child in mainForm.Children)
thanks.