Comments by Shruthi.BT (Top 47 by date)

no.. there are no errors..

no that is there in master page and in all pages master page is called.

Actually this is not opening Excel manually n closing... i am opening the excel with a third party tool so the excel is viewed or accesed by third party tool... so if i try to delte the excel maually also it is not possible n also the process i cannot manually end in Server.. if i try to delete the excel maually it shows w3wp.exe some error... how can i stop that and if i stop that process will that effect my application or any other projects in Server..???

Hey Hi.... this works in my loocal system but in Server it does not.. that is we use Windows Server 2008 and it is 64 bit.. but the Server does not have MS Office so it does not support the Interop that is the namespace...

Microsoft.Office.Interop.Excel;

How can i solve this... any other way i can close the process?? when i gave response.write it showed this error...

System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154. at GetFiles.StartExcel()

how can we solve this....?? ANY IDEA ... plz Help!1

Actually i am just trying to open an excel and close just to check if that works.. then code to delete i have written.. but when delete line is exccecuted it throws that excel is used by another process cannot delete.. the other process is that the file is being viewed or opened using third party tool .. so i need to kill that excel process i guess... but how can i do that progrmatically?? and also if i kill process will it effect other projects??

nooo... while i was pasting coding it has become like that onclick... but in my code its normal onclick itself....

yes.. it is finding the checkbox and yes.. i am using master pages... any help for this issue please.. !!

thank u .. Prasad Khandekar .. the solution worked...

hi... but that dropdown is binding dynamically ... so i will not have any value.. there will be only text... will this line
$('#tbl_ddlcolumnname').val(editColDR).

work.. ? without any value for the dropdown texts? please help!!

hey thanks a ton!! u really made my work easier... thank u so much!!

for adding i am using a hidden field concept.. trying that.. if it does not work.. will give out more details of td and all.. for now.. i got naother doubt with this...

var id = $('#tblrownew0 tr:last').attr('id')
var id = $('#tblrownew0 tr:last')[0].id

for this line what if i do not know the tablename and i get that name dynamically in a variable like for ex:
var tablename = "tblrownew0";

then how can i use tablename in this line...
var id = $('#tblrownew0 tr:last').attr('id')
var id = $('#tblrownew0 tr:last')[0].id

Please help!!

i tried like this

var id = $('tablename tr:last').attr('id')

it is showing undefined...

also like this is used and checked...

var id = $('#tablename tr:last').attr('id')

again undefined in alert.., please please help!!

thank u thanks a lot!! it worked!! but i have another question... i am actually inserting the values of the table in database and since the user has the facility to delete the records or rows from table ... so i am not able to get the values based on id how can i retrieve the row values without the id means to insert in db... please help!!

hi... i cannot use the concept of hide show as i am not going to get the checkbox id... as it is dynamically generated so for a list of checkboxes id will be say rad0 then the next set of checkbox will have id rad1.... so since the id and no. of checkbox i will not know i cannot use the visible hide concept....

so i have another div which needs to open next to the checkbox which is checked assuming [] as checkbox.. what i need is as follows...

i need like this...

[]1
[checked]2 []red
[]3 []blue
[]4 []green
[]5 []yellow
[]6
[]7
[]8

the colors div should open next to [](checkbox that is checked) so if i check the checkbox 3 for example then that div should open as:

[]1
[]2
[checked]3 []red
[]4 []blue
[]5 []green
[]6 []yellow
[]7
[]8

how can i make the div to display next to the checkbox that is checked .. and that colors is a single div...

Please help!!

but this line not working shows error.... as

'object' does not contain a definition for 'Delete'
is there any other way to delete...?

thank u .. Mantu Singh .... this worked using index... if in case there is a row.. which is blank for ex...

ds.Tables[0].Rows[0][0].ToString() == ""

then i need to delete that.. row. how can that be done.. as i want the null values from dataset to be removed from the dattaset...

please help!!

but... i need a text box.. means it is not 1-10 only that for ex i told.. but it should not take numbers like 123456789 also.. can we restrict that.. ?

hi... kshitij_CodeMaster this worked... but it is allowing any number means like 147852369 or anything in numbers... is there any way i can restrict number to like from 1- 10 as this textbox is for rating score.. so it should be within specific range... thanks...

thanks.. for reply... i tried it without the common id so was not able to merge... but the solution i tried to combine the tables and used a single table... thank you...

the values for one datatable i am getting from Excel sheet and the other datatable values i am getting from database so.. i am not able to merge them like any other normal table with unique ids so how do i merge the datatables... is there any way i can merge them without any blank spaces... please help...

i tried appending new row and column values as u suggested but one problem is that the id .... actually inside gridview i am binding 2 dropdownlist and the dropdownlist id is very important as i am adding new row that id is taking what i give in id of appending new row... but i want it the way like for ex: my first row in grid view has 2 drop down and first dropdown has id as
"ctl00_ContentPlaceHolder1_griddetails_ctl02_ddlcolumnname"
...
but in new row i want the id of the drop down as
..
"ctl00_ContentPlaceHolder1_griddetails_ctl03_ddlcolumnname"

means the id no should increment like how it gets incremented if we do from codebehind adding new row... how this can be done...??

yes... i have tried pasting in js in different places in the sense.. i have changed the position of js... and tried and also the js code i modified and called the handler by using a ajax jquery ... still there is some problem... the success function is not showing...

remaining code i have pasted in next comment as all was not pasted in the first one...

}
public decimal Longitude
{
get { return _longitude; }
set { this._longitude = value; }
}
#endregion
}
public class Geocode
{
private const string _googleUri = "http://maps.google.com/maps/geo?q=";
private const string _googleKey = "AIzaSyB4UgLW37a1jhxnnz5J27KPNaHIDmapSYk";
private const string _outputType = "csv"; // Available options: csv, xml, kml, json
private static Uri GetGeocodeUri(string address)
{
address = HttpUtility.UrlEncode(address);
return new Uri(String.Format("{0}{1}&output={2}&key={3}", _googleUri, address, _outputType, _googleKey));
}
public static Coordinate GetCoordinates(string address)
{
WebClient client = new WebClient();
Uri uri = GetGeocodeUri(address);
/* The first number is the status code,
* the second is the accuracy,
* the third is the latitude,
* the fourth one is the longitude.
*/
string[] geocodeInfo = client.DownloadString(uri).Split(',');
return new Coordinate(Convert.ToDecimal(geocodeInfo[2]), Convert.ToDecimal(geocodeInfo[3]));
}
}

public bool IsReusable
{
get
{
return false;
}
}
}
}

Handler code:

<pre>using System;
using System.Collections;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Web.Script.Serialization;
using System.Collections.ObjectModel;
using ClassLib_BLL;
using System.IO;
using System.Web.UI;
using System.Net;
using System.Collections.Generic;

namespace QlixooWeb.handler
{
///

/// Summary description for $codebehindclassname$
///

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

public class UserUploadsDTO
{
private int _res;
public int res { get { return _res; } set { _res = value; } }
}

public class newExifDetails : IHttpHandler
{
public static readonly UserUploadsBLL oUserUploadsBll = new UserUploadsBLL();
string[] splitQueryStr, arId, arLocation;
public string Id1, Location1;

public void ProcessRequest(HttpContext context)
{
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
Collection<useruploadsdto> collection = new Collection<useruploadsdto>();
UserUploadsDTO dto;
string RId = context.Request.QueryString["Id"].ToString();
string RLocation = context.Request.QueryString["Location"].ToString();
//string json = new StreamReader(context.Request.InputStream).ReadToEnd();//Location = Bangalore%2C+Karnataka%2C+India%3AChittur%2C+Kerala%2C+India %3A & Id=4%2C94
//splitQueryStr = json.Split('&');
//Location1 = splitQueryStr[0];
//Id1 = splitQueryStr[1];
//string Location = RLocation.Substring(Location1.IndexOf('=', 0) + 1);
string Location = RLocation;
//Location = Location.Replace("%2C+", ",");
//Location = Location.Replace("%3A", ":");
//Location = Location.Replace("+", " ");
Location = Location.TrimEnd(':');
arLocation = Location.Split(':');
string Id = RId;
//string Id = RId.Substring(Id1.IndexOf('=', 0) + 1);
//Id = Id.Replace("%2C", ",");
arId = Id.Split(',');
int res = 0;
for (int i = 0; i < arId.Length; i++)
{
int UpId = Convert.ToInt32(arId[i]);
Coordinate coordinate = Geocode.GetCoordinates(arLocation[i]);
decimal latitude = coordinate.Latitude;
decimal longitude = coordinate.Longitude;
res = oUserUploadsBll.TaggingImages(latitude, longitude, UpId);
}
if (res > 0)
{
dto = new UserUploadsDTO();
dto.res = res;
collection.Add(dto);
}
//context.Response.Redirect("~/UserUploads.aspx");
//context.Response.Write(res);
else
context.Response.Write("false");
JavaScriptSerializer serializer = new JavaScriptSerializer();
string jsonString = serializer.Serialize(collection);
context.Response.Write(jsonString);

}
public interface ISpatialCoordinate
{
decimal Latitude { get; set; }
decimal Longitude { get; set; }
}
///

/// Coordiate structure. Holds Latitude and Longitude.
///

public struct Coordinate : ISpatialCoordinate
{
private decimal _latitude;
private decimal _longitude;
public Coordinate(decimal latitude, decimal longitude)
{
_latitude = latitude;
_longitude = longitude;
}
#region ISpatialCoordinate Members
public decimal Latitude
{
get { return _latitude; }

its updated... please try to help.. but the code behind has nothing to do with the js problem it is with json and handler.. so shall i post handler page... code behind??

for this button onclick there is no .cs coding.. it has only js ... then alerts if i put they are working correctly till the $.getJSON(url,function(json) but after this any alert i put its not working... what might be wrong??

the length of the values in hidden field.... but no problem there ... the entire function is itself not called on onclick.... what might be wrong??

ya... used... a different js for it it workks sometimes sometimes it does not... link of it is...

http://areaaperta.com/nicescroll/

this worked!!!.. i just used the height or width .... thank a lot...!! thank YOU!!!

thank u for the options will check them out.... thanks again....

Hey thank u so much for the link .... but the Array.insert i found from this link...

http://msdn.microsoft.com/en-us/library/bb383995.aspx

So, I used it... but if i try the Splice and the push methods also it is not working... so that error is there in Google Console if i use the Array.insert . Is there any reason for this error which states as


Object function Array() { [native code] } has no method 'insert'

Thank You in advance.

Thank u for the links..!

yes can u pls provide some converters as i found one of them in dotnet fusion but it could not convert if conditions of VB.net... if u provide converters links that would be really helpful...!

ok I will try that..

The Server that is used is Windows Server 2008. Still the recording i am not able to read, but the audio file is saved in that specified location with 44 bytes irrespective of how much time i record. It is not working means file is saved but i am not able to read or hear recording! Then as per the previous post i have tried the link that was provided and that i have downloaded required dll but still it shows error as

The type or namespace name 'Microphone' could not be found (are you missing a using directive or an assembly reference?)

even after adding the refrence which is specified in link which is

using Microsoft.Xna.Framework.Audio;

I have added in bin first then added from add refrence but still that was not resolved.. so I reposted the question ...

Thank U in advance!

Thank U! will check if that is the problem..

sorry i meant will check this link and try!

yes!! i have this save btn code.. its working in local system fine.. when i upload page on Server its saving and while i read that recording.. i am not able to hear any recording.. or sound.. I wanted to know.. why is this problem in SErver but local working 100% fine.. Please reply!!

thank u all it worked!!

int Ratings = Convert.ToInt32(ds.Tables[0].Rows[0]["StarCount"].ToString());
int People = Convert.ToInt32(ds.Tables[0].Rows[0]["PeopleCount"].ToString());
float f1 = (float)Ratings;

float r1 = f1 / People;
Result = Convert.ToString(r1);
// Result = Result.Substring(0, 3);

// double result = (double)r1;
//float Toatl = Ratings / People;
Result = Result.ToString();
//Result = Int32.TryParse(Result, out number);
if (Int32.TryParse(Result, out number))
{
//Then value is integer
}
Result = Result.Substring(0, 3);
TotalPPl = People.ToString();

is the code used for rating so here Result=Result.Substring(0,3)
i want to include inside if condition where if Result is 10 it should not
go to Result=Result.Substring(0, 3);

so, i used above condition but out number showing error so can u please tell how to include if condition in above code...

thanks in advance!