Comments by Prasad Avunoori

Prasad Avunoori 19-May-17 5:21am View

If someone face the same type of issue.

Prasad Avunoori 19-May-16 10:24am View

Thank you @F-ES Sitecore.

But, This is didn't work.

Prasad Avunoori 31-Dec-15 1:51am View

Just google it online. You will get plenty of online books.

Prasad Avunoori 31-Dec-15 1:47am View

What is the datatype of the column in the database?

Prasad Avunoori 30-Dec-15 8:59am View

Does use who runs this application has admin rights?

Prasad Avunoori 30-Dec-15 8:48am View

Hi Prasad,

Please elaborate your question.

Prasad Avunoori 30-Dec-15 8:43am View

Please improve your question.

Prasad Avunoori 30-Dec-15 8:39am View

Why it's not possible?

Prasad Avunoori 29-Dec-15 8:59am View

Why do you want synchronize two databases?
Point both windows and web application to the same database.

Prasad Avunoori 29-Dec-15 8:56am View

Use DateTime class.

Prasad Avunoori 24-Dec-15 6:08am View

File deletion on IIS host server requires permission. Do the identity impersonation to user who has admin permissions.

Prasad Avunoori 24-Dec-15 6:01am View

You have generate the OTP and store it in the Database. When user enters his OTP check it against the value stored in Database.

Prasad Avunoori 23-Dec-15 5:03am View

Try gridview

Prasad Avunoori 23-Dec-15 5:01am View

What have you tried? One of the ways to generate OTP is to use Random Class in C#.

Prasad Avunoori 22-Dec-15 9:58am View

Please provide further details regarding this.

Prasad Avunoori 22-Dec-15 9:53am View

DataSet and DataReader bother are types. We can pass any type of data from Controller to View find the Stack overflow solution below.

Prasad Avunoori 29-May-15 9:46am View

Hi,
check your SQL Update statement. I think you missed to write WHEREcondition.

Prasad Avunoori 14-Apr-15 3:11am View

Thanks, John.

This could help me. But, I need to find a way for data validation....

Prasad Avunoori 25-Mar-15 1:11am View

Is there any solution???

Prasad Avunoori 23-Mar-15 9:11am View

Help please...

Prasad Avunoori 20-Mar-15 0:56am View

It's there in my reference.Adding a class with @class in not correct in aspx view engine.

Prasad Avunoori 20-Mar-15 0:27am View

I didn't get any error. But, when i see the source of the html other class is render as class="text-box single-line"

Prasad Avunoori 20-Mar-15 0:12am View

That didn't work for @Class not recognized by aspx view engine.

Prasad Avunoori 20-Mar-15 0:03am View

Hi,

Thanks for the quick response.
But, i need this in html helper some what below.
<%: Html.TextBoxFor(m => m.Code, new { @class = "marb15_I",@Title="Enter Code" })%>

Prasad Avunoori 12-Mar-15 8:07am View

Problem is with - hyphen

Prasad Avunoori 11-Mar-15 8:06am View

Thanks, Manchanx

Prasad Avunoori 11-Mar-15 7:13am View

If i remove the .(dot) in the sheet name and import then it's working fine.

Prasad Avunoori 25-Feb-15 6:17am View

That didn't work..

Prasad Avunoori 25-Feb-15 6:09am View

In above e.g. Student: is my keyword.

Prasad Avunoori 14-Oct-14 1:16am View

Yes, Better you save the path itself.

Prasad Avunoori 1-Oct-14 7:49am View

I didn't get you yet.

Prasad Avunoori 25-Sep-14 4:29am View

Got any errror/

Prasad Avunoori 24-Sep-14 10:28am View

Share your code along with where you sttuck.

Prasad Avunoori 24-Sep-14 10:27am View

What are you trying to do? Elaborate more.

Prasad Avunoori 24-Sep-14 5:12am View

What is this SubSonic namespace? Don't specify domain specific information in question title.

Prasad Avunoori 24-Sep-14 5:04am View

Yous Anchor.

Prasad Avunoori 19-Sep-14 3:20am View

Does your Application have login facility?

Prasad Avunoori 18-Sep-14 23:16pm View

Thank you, Sinisa.

I did iteration and achieved it.

Prasad Avunoori 18-Sep-14 2:38am View

Cann't i achieve it without iteration?

Prasad Avunoori 18-Sep-14 1:52am View

I am sorry for the typo that was DataTable only . I just updated the Question.

Prasad Avunoori 17-Sep-14 1:24am View

Please share your code.

Prasad Avunoori 17-Sep-14 1:05am View

Why don't you use sessions?

Prasad Avunoori 17-Sep-14 0:21am View

What is the type of data?
You may use Sessions,query string

Prasad Avunoori 17-Sep-14 0:05am View

Make that function as static, so that you can access it as below without creating object.
Form1.funcname();

Prasad Avunoori 16-Sep-14 5:29am View

Try this.

<span id="spanCommentMessage<%#Eval('Rownumber')%>" class="Sucmsg" style="display: none"
runat="server">

Prasad Avunoori 16-Sep-14 5:22am View

Check your connections, whether both(local/server) are connected to the same database server.

Prasad Avunoori 16-Sep-14 4:59am View

????????????

Prasad Avunoori 16-Sep-14 1:44am View

Put a break point and see what value cellValue[1, h] has. I think white space is padded to that more than 50 chars.

Prasad Avunoori 16-Sep-14 1:16am View

Check the length of col1,col2 and col3. May be you are passing more than that value.

Prasad Avunoori 15-Sep-14 5:57am View

????????????????????

Prasad Avunoori 15-Sep-14 5:48am View

I didn't get you. Can please post your table name along with their columns and relation?

Prasad Avunoori 15-Sep-14 3:10am View

If you use this.Control again you need to look for those 8 Text boxes names which is cumbersome.

In future if he wants to apply validation to few more controls he can just drag them to this Group Control.

Prasad Avunoori 15-Sep-14 2:27am View

How many button you have? What are the functionality of each?

Prasad Avunoori 15-Sep-14 1:27am View

Find my solution below.

Prasad Avunoori 15-Sep-14 1:18am View

The Erro message clearly says that "Number of query values and destination fields are not the same". How many columns are there in table "TW100NEL" ?

Prasad Avunoori 12-Sep-14 2:27am View

Can you please post your code?

Prasad Avunoori 12-Sep-14 1:36am View

Are all pages related to Admin panel kept in Same folder of your project?

Prasad Avunoori 12-Sep-14 1:30am View

In your presentation layer do like this:

string tmp,transid;
skbll.Insert_tmpStock_Card(scbel, prodcode,tmp,transid);

Don't call the method twice.

Prasad Avunoori 12-Sep-14 0:55am View

View my updated solution.

Prasad Avunoori 12-Sep-14 0:46am View

Hi Navya,

I have posted two ways one with out params and two with Key value pair in my solution below.

Prasad Avunoori 10-Sep-14 6:09am View

What is the problem with above code?

Prasad Avunoori 10-Sep-14 5:53am View

No Problem that will be useful for you.

Prasad Avunoori 10-Sep-14 2:14am View

Use exception handling and capture the specific exception then show that message to user.

Prasad Avunoori 10-Sep-14 2:11am View

How much time it would take for Back up and Restore?

Prasad Avunoori 10-Sep-14 1:17am View

You had given hyperlink to SName only, how can you expect it for all columns?

Prasad Avunoori 9-Sep-14 7:10am View

Why don't you do that stuff at database level?

Prasad Avunoori 9-Sep-14 7:07am View

??????

Prasad Avunoori 9-Sep-14 7:03am View

Replace you if condition with following code.
if(string.IsNullOrEmpty(str))
{
// Your code.

}

Prasad Avunoori 9-Sep-14 6:20am View

What do you mean? Control is not going inside if (str.Equals(null))?

Prasad Avunoori 9-Sep-14 6:16am View

But lines of code matters.

Prasad Avunoori 9-Sep-14 6:15am View

Hello Black Rose. We don't have columns in Dataset. Datatable of Dataset only can have columns. How would you expect columns in Dataset????????????

Prasad Avunoori 9-Sep-14 6:15am View

Hello Black Rose. We don't have columns in Dataset. Datatable of Dataset only can have columns. How would you expect columns in Dataset????????????

Prasad Avunoori 9-Sep-14 6:11am View

Find my solotion below.

Prasad Avunoori 9-Sep-14 5:58am View

You may use ISNULL of SQL server.

Prasad Avunoori 9-Sep-14 5:56am View

Just point out your issue. What have you tried?

Prasad Avunoori 8-Sep-14 4:28am View

Take new Console application and try the above code.

Prasad Avunoori 8-Sep-14 3:55am View

????????????????????????????

Prasad Avunoori 8-Sep-14 3:16am View

Wrong in for (int i = 0; i < gvLeaveTypes.Columns.Count - 2; i++)

Make it as below.

for (int i = 0; i < gvLeaveTypes.Columns.Count - 1; i++)

Prasad Avunoori 27-Aug-14 1:16am View

Hi, Make sure you don't have any script in the requested URL.

e.g. <script>alert('Oops!')</script>

Prasad Avunoori 27-Aug-14 1:10am View

I think you are supposed to convert from v in context.Timesheets
where v.projectid = 5
select v; to a list
like below.

(from v in context.Timesheets
where v.projectid = 5
select v).ToList();

Prasad Avunoori 27-Aug-14 1:06am View

What is the use of adding 2 to 5 every time?

Prasad Avunoori 27-Aug-14 0:58am View

What do you mean by this v.projectid = Convert.ToInt32(5 + 2);? Why are you mentioning 5+2?

Prasad Avunoori 27-Aug-14 0:56am View

Your question didn't make any sense to me. Please elaborate it.

Prasad Avunoori 27-Aug-14 0:46am View

Which template are you using? Delete that "Acccount" Folder from your project.

Prasad Avunoori 25-Aug-14 6:27am View

What do you want?

Prasad Avunoori 21-Aug-14 23:34pm View

What do you want to compare? Databases?

Prasad Avunoori 20-Aug-14 3:15am View

Not clear again.

Prasad Avunoori 18-Aug-14 7:13am View

I think you are trying to convert a Non-integer value to integer. Put a break point and review your code.

Prasad Avunoori 18-Aug-14 7:11am View

LvTypeId has Non Integer value it seems.

Prasad Avunoori 18-Aug-14 7:07am View

Can you please elaborate more?

Prasad Avunoori 18-Aug-14 7:03am View

Hi Miss786,

If your requirement is to trigger emails only, I suggest sending mails from backend only.
You may create a a database trigger on that table and create/send emails.

follow this link . http://www.codeproject.com/Articles/29060/SQL-SERVER-Configure-Database-Mail-Send-Email

Prasad Avunoori 18-Aug-14 5:33am View

Hi Abhishek,
Post your solution. This could be helpful for other members too.

Prasad Avunoori 18-Aug-14 5:27am View

<asp:Image ID="Image1" runat="server" ImageUrl='<% #Eval("ImagePath")%>' /> <a runat="server" href='<% #Eval("ImagePath")%>'>Click here

Prasad Avunoori 18-Aug-14 3:16am View

I didn't understand your problem.

Prasad Avunoori 18-Aug-14 3:02am View

Put break points then f10 or f11.

Prasad Avunoori 18-Aug-14 3:00am View

First of all move this inline query to a stored procedure for better performance, readability and non-vulnerable to sql injections.

Prasad Avunoori 18-Aug-14 2:57am View

Are you getting any error?

Prasad Avunoori 18-Aug-14 2:56am View

What was the error?

Prasad Avunoori 14-Aug-14 7:49am View

Hi Gopal,

Why do you want to display 1 lack records at a time in gridview? No one can view that many records at a time. Probably they can view 50 to 100 records at a time. You are supposed to use paging concept.

Prasad Avunoori 14-Aug-14 7:04am View

It doesn't make any sense.....

Prasad Avunoori 5-Aug-14 0:09am View

I too.

Prasad Avunoori 4-Aug-14 23:59pm View

Is it role based application or Open to all? Mean All users of your domain can access? Which version of IIS you are using ?

Prasad Avunoori 4-Aug-14 8:06am View

So, All string looks like Jan 2014, Feb 2014, Mar 2014, Apr 2014....?

Prasad Avunoori 4-Aug-14 7:32am View

I think Threading concept could help you.

Prasad Avunoori 4-Aug-14 7:30am View

Did you setup default page in IIS or Visual Studio/Developer?

Prasad Avunoori 4-Aug-14 7:25am View

Blindly pasting the error doesn't help you any more.

Prasad Avunoori 4-Aug-14 7:23am View

Is it in IIS or Visual studio? You didn't set up any start page it seems.

Prasad Avunoori 4-Aug-14 6:37am View

Deleted

compilation debug="false"

Prasad Avunoori 4-Aug-14 6:35am View

1. Give reference to iTextSharp
2. Give Reference to Raj namespace.

Prasad Avunoori 4-Aug-14 6:29am View

Yes, you can. Without it also you may update using join.

Prasad Avunoori 4-Aug-14 6:25am View

select UserNo,User_Date,AdviceDate
CONVERT (datetime,UserDate,103) as User_Sanction_Date1,
CONVERT (datetime,AdviceDate,103) as AdviceDate1
INTO #table_temp1
from table_temp

Prasad Avunoori 4-Aug-14 6:25am View

Deleted

select UserNo,User_Date,AdviceDate
CONVERT (datetime,UserDate,103) as User_Sanction_Date1,
CONVERT (datetime,AdviceDate,103) as AdviceDate1
INTO #table_temp1
from table_temp

Prasad Avunoori 4-Aug-14 6:20am View

I am asking you to share/post two records from each table. In which table you want update?

Prasad Avunoori 4-Aug-14 6:17am View

What is the access modifier of changerate class?

Prasad Avunoori 4-Aug-14 6:11am View

Do you want to update the sql tables datatype?
Please two different records from database with varchar and datetime each.

Prasad Avunoori 4-Aug-14 6:08am View

Is the class changerate declared as public?

Prasad Avunoori 4-Aug-14 5:56am View

Then make sure you have given reference to Raj dll, then rebuild it.

Prasad Avunoori 4-Aug-14 5:50am View

Do you have a class changerate in Raj namespace?

Prasad Avunoori 31-Jul-14 0:30am View

When you are switching from site1 to site2, activate the session in site2. This must be repeated whenever there's a transition.

Prasad Avunoori 24-Jul-14 23:56pm View

Should it be case sensitive?

Prasad Avunoori 17-Jul-14 8:05am View

Find my solution below. Adapt it to your requirement.

Prasad Avunoori 17-Jul-14 7:01am View

Does it contain 4 fields exactly?

Prasad Avunoori 17-Jul-14 0:01am View

You are most welcome!

Prasad Avunoori 16-Jul-14 4:48am View

You are supposed to use one more Replace() method.

SearchTextBox.Text.Replace("%", "[%]").Replace("'","''")

Prasad Avunoori 16-Jul-14 3:28am View

View my updated solution. It should work.

Prasad Avunoori 16-Jul-14 1:27am View

If both hosted server and client system on same LAN, you can.

Prasad Avunoori 15-Jul-14 23:08pm View

Was the reference to AjaxControlToolkit added?
Was it connected to the same database as in local?
What is the version of IIS?

Prasad Avunoori 15-Jul-14 0:52am View

Then, Solution1 is suitable for you.

Prasad Avunoori 15-Jul-14 0:51am View

This looks good!

Prasad Avunoori 11-Jul-14 3:22am View

You dont have permission to that perhaps.

Prasad Avunoori 11-Jul-14 2:44am View

How many records would be inserted at once?

Prasad Avunoori 10-Jul-14 23:57pm View

What is the datatype of StartDate and EndDate in c#?

Prasad Avunoori 9-Jul-14 23:52pm View

If there is no relation, there is no use of joining.

Prasad Avunoori 9-Jul-14 23:43pm View

Usually the while loop terminates when it reaches list.count().
What do you want then? Can you please post your while loop?

Prasad Avunoori 9-Jul-14 23:37pm View

Can you please post your two tables column names and expected result set?

Prasad Avunoori 9-Jul-14 5:56am View

No, Vani. It also didn't work for me.

Because it filters the stored procedures which have /*.

Prasad Avunoori 9-Jul-14 3:13am View

Thank you. But, i don't want to search commented text.

Prasad Avunoori 4-Jul-14 7:46am View

ID Vendor_Name Asset_Type
37 Futuresoft Motherboard
37 Futuresoft SMPS
38 Future India HDD
38 Future India joystick
38 Future India Laptop Screen
39 Tech_M Baterry
39 Tech_M Laptop Screen
39 Tech_M Mouse
46 dgd Battery
46 dgd RAM
46 dgd joystick
46 dgd Mouse
46 dgd Processor
47 Religare HDD
48 ryy Battery
48 ryy HDD
48 ryy joystick

Make sure your table look like some what above.

Prasad Avunoori 4-Jul-14 7:45am View

Then solution1 should work for you.

Why did you allow your table's columns to allow multiple values in one cell?

Prasad Avunoori 4-Jul-14 6:55am View

post total code.

Prasad Avunoori 4-Jul-14 6:54am View

Try this.

string qry = "SELECT DISTINCT Vendor_Name FROM [VandorDetail] WHERE Asset_Type like '%"+s1+"%'";

Prasad Avunoori 4-Jul-14 5:31am View

First of all your database design doesn't follow normalization rules.
Make it normalized.

Prasad Avunoori 4-Jul-14 3:38am View

You should validate his credentials before updating the Question and answer.

Prasad Avunoori 4-Jul-14 2:35am View

Yes, You are right. '*' should be avoided in stored procedures for scalable applications.

Prasad Avunoori 4-Jul-14 2:29am View

Navya,

Refer my updated solution.

Prasad Avunoori 4-Jul-14 0:55am View

What is the datatype of CertficateDatetime?

Prasad Avunoori 3-Jul-14 23:40pm View

Before accessing/Edit the file you want to know whether the file is open or not, right?

Prasad Avunoori 3-Jul-14 3:14am View

Can you please post your server.mappath()code?

Prasad Avunoori 2-Jul-14 23:41pm View

Where you want to update the value in client side or Code behind?

Prasad Avunoori 2-Jul-14 0:40am View

That should work. What is the actual and expected behavior?

Prasad Avunoori 1-Jul-14 23:31pm View

Is that HiddenField exist in any other control, e.g. in Gridview or ListView?

Prasad Avunoori 1-Jul-14 23:15pm View

Put that image in hyper link then pass the query string to another page.

Prasad Avunoori 1-Jul-14 6:32am View

How the data look like in your first txt file?

Prasad Avunoori 30-Jun-14 7:15am View

What do you mean? Please explain.

Prasad Avunoori 30-Jun-14 6:17am View

Who created that .mdf?

Prasad Avunoori 30-Jun-14 6:13am View

Are you running one .exe from another exe?

Prasad Avunoori 30-Jun-14 1:19am View

Hi, I worked on Telerik reporting services. Easy deployment and integration with .Net platform. I don't have idea about Infragistic.

Prasad Avunoori 27-Jun-14 7:58am View

Just pass the ProductIds to the server, build another stored procedure to do the work (price*Quantity) bind it in another Popup's gridview.

Prasad Avunoori 27-Jun-14 5:54am View

You may user Generic List<> for that.

Prasad Avunoori 27-Jun-14 5:39am View

Android is not my area of expertise. Follow what Mushaan posted in Solution1.

Prasad Avunoori 27-Jun-14 5:19am View

Why don't you put a break point and see what's happening over there?

Prasad Avunoori 27-Jun-14 4:58am View

What is your problem?

Prasad Avunoori 27-Jun-14 3:36am View

Get all the questions in Grid. Upon clicking on any question redirect to a new page along with that specific questionId, QuestionDesc. There you need to have 4 textboxes , 4 file brows controls one for each option. Then store those values in the database as per your tables structure. Make sure you just store the path of the images only not the image(BLOBS) in the database.

Prasad Avunoori 27-Jun-14 3:18am View

After registration you will send an email with some uniqueId. If the user enters that uniqueId in your app again then the User's email address is valid and you may register that user.

Prasad Avunoori 27-Jun-14 3:15am View

You may use Datalist for that.

Prasad Avunoori 27-Jun-14 3:03am View

Can you please share your database table's structure?

Prasad Avunoori 27-Jun-14 3:00am View

Is it Garment.mdg or Garment.mdf?

Prasad Avunoori 27-Jun-14 2:47am View

Good!

Prasad Avunoori 27-Jun-14 2:07am View

Do you want MySql Script?

Prasad Avunoori 27-Jun-14 1:11am View

Why don't you use div?

Prasad Avunoori 26-Jun-14 23:05pm View

Hi, Unfortunately i am not a VB.Net Coder. C# Code i posted above worked fine for me. I posted VB code after converting the C# to VB from an online converter.

Prasad Avunoori 26-Jun-14 7:59am View

But, Solution1 by OriginalGriff was better as it used less code than me.

Prasad Avunoori 26-Jun-14 7:02am View

I think you are not understood my point.

Prasad Avunoori 26-Jun-14 6:31am View

public void MyMethod()
{

///Code
}

It's defined in aspx.cs file.

Prasad Avunoori 26-Jun-14 6:13am View

It's an ASP.net application. I want to call a method once only when the Esc is pressed.

Prasad Avunoori 26-Jun-14 5:56am View

You already did that. What do you want?

Prasad Avunoori 26-Jun-14 5:40am View

Disadvantage is:

SQL injection is possible as soon there is dynamic SQL which is handled carelessly, be that SQL statements sent from the client, dynamic SQL generated in T-SQL stored procedures, or SQL batches executed from CLR stored procedures

Prasad Avunoori 26-Jun-14 2:39am View

It doesn't make any sense!

Prasad Avunoori 26-Jun-14 0:32am View

Do you have 3 solutions? or 1 solution with 3 projects?

Prasad Avunoori 25-Jun-14 23:17pm View

Executing scripts like above is not a good practice.

Prasad Avunoori 25-Jun-14 8:08am View

No, We can not provide you at it free of cost.

Prasad Avunoori 25-Jun-14 8:03am View

Is this problem intermittent?

Prasad Avunoori 25-Jun-14 5:17am View

Please elaborate more.

Prasad Avunoori 25-Jun-14 3:25am View

That's may be permission issue.

Prasad Avunoori 25-Jun-14 2:56am View

But, It worked for me.Just run above code in your PC and let me know.

Prasad Avunoori 24-Jun-14 6:10am View

Did you add the jquery reference at master page?

Prasad Avunoori 24-Jun-14 6:07am View

What is your question? We didn't find any question from your post.

Prasad Avunoori 24-Jun-14 4:59am View

Are parent and child records exist in same csv file? Can you please share the field details of it?

Prasad Avunoori 23-Jun-14 23:11pm View

How many records returned when you run SELECT [Site_ID], [Date_Rep], [Activity], [Product], [Number], [Time]
FROM [Letters]
WHERE Site_ID >=@Site AND Date_Rep <=@Date ORDER BY Date_Rep in sql server?

Prasad Avunoori 23-Jun-14 6:13am View

Put try, catch block and debug it.

Prasad Avunoori 23-Jun-14 6:10am View

The error itself says that "ConnectionProvider" not existing in m_SessionFactory.

Prasad Avunoori 20-Jun-14 7:53am View

Please have a look at my v3 of my solution.

Prasad Avunoori 20-Jun-14 5:20am View

Can you please post your source and code?

Prasad Avunoori 20-Jun-14 5:13am View

Are you gonna replicate SSMS?

Prasad Avunoori 20-Jun-14 5:10am View

View my updated solution.

Prasad Avunoori 20-Jun-14 3:27am View

Do you want both timers should fire only once?

Prasad Avunoori 20-Jun-14 3:22am View

What is the error message you got?

Prasad Avunoori 20-Jun-14 2:31am View

"ReceiptFileName" in your ItemTemplate should contain the full path of the file, does it contain?

Prasad Avunoori 20-Jun-14 1:49am View

Why don't you kill the long sleeping process by running any sql job?

Prasad Avunoori 19-Jun-14 23:36pm View

As the same way you did in webforms.

Comments by Prasad Avunoori (Top 200 by date)