Comments by GDdixit (Top 86 by date)

hi , you have specified here that length of @firstname is =20. and for space it's one and for @lastname it's 7 ...

but if we use len function for finding their lenght individually than ...

SELECT LEN(@FirstName) CharSpaceUsed,
LEN(@LastName) VarCharSpaceUsed

it will gives length of @firstname is 9 and for @lastname is 7
and as you specified length above for @firstname is 20 . it's the bytes used by this variable ...


it must be 9+1+7=17

i have used ur code jquery code is called on selecting radio button item , anf also finding 'if' condition true in code but on page div is not hide or not showing , ... ?

actually its right , the upere line of source code is ...

<asp:RadioButtonList ID="RbtnPropertyType" ValidationGroup="View1" runat="server" RepeatDirection="Horizontal" AutoPostBack="false" >





i forget this to write ..

Yes i have seted it to true in my code ...

and this visiblity set false only in this div ...

and i now when i am checking the visiblity using if condition , it returns false .. although i have already set visible =true ... any idea why this happening

on debugging step by step it shows a message that "{InnerText = '((System.Web.UI.HtmlControls.HtmlContainerControl)(TransactionTypeDivForCommercial)).InnerText' threw an exception of type 'System.Web.HttpException'}"


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

dude problem is not in displaying or hiding the div .. problem occours when ..

i am checking the visibality of div in code behind .. it always shows visible= false ?

can you describe little more any example or link .... and whats wrong in my code .. i have already implemented this .. in a big area .. i i continue that code .. than it will be more batter ?

pls suggest something ... ?

i have tried this .. at last page when i click on login after putting username no data comes in view state . Can you provide me any sample project for this ...rply

please suggest something , i tired to do this...

Thank You so much bro

can any one give suggetion ?

no i am unable to under stand this ...
can u give any other example or solution..

ok , i will try this but the error is same yet ..

there is nothing at the link....

waht u saying bro my asp.net application working properly , and problem occour when i host an html site on local IIS .. it gives error as i told in problem , and there is no config in html , to which i will remove ............ ?

ok , now i have updated my question , suggest something pls bro ?

no unfortunatly i have not available , actually it's a old project , i have not original web site , is any way there to update this application ?

yes .. the last line u wrote here , is right . i trying to use trnasaction here :)

nothing happened good on doing as u told here .. u only add rerurn ....

thnx , explain nicely :)

thnx , something clear

can u explain in two lines what backward support ?

here it is says that web refrence can be used to create proxies for .NET 1.1 or 2.0 clients
i think tgis 1.1. and 2.0 is dot net framework ), if than i was used this web refrence in my 3.5 framework .. and it working fine .... ?

SO THAN WE CAN USE UNCLUSTERED INDEX ON THE COLUMN THAT ARE NOT FREQUENTLY CHANGED ?

YES DEAR , I DO THE SAME AS U TOLD HERE ...

BUT THE TIME TAKEN IS SAME IN BOTH CONDITION ...
IS IT RIGHT THAT I AM CHECKING THE ESTIMATED SUBTREE COST IN EXECUTION PLAN ?

oho i tried this also but it's not working

"AS" what is this bro ?

i have seen this before and also my passing parameter process is like this . but it's not working . see my php code dude ...

yes thank you dude ... it's work fine ;)

it's not understandabl to me , i am new in php ,
the link you give here , in this link he is using 'CALL' function .. but it give nothing in my case .. i tried

'CALL inserttbl()';

Can You tell me how can i get this control in my page bcoz it's not in my visual studio default controls .. ?

i want to create an interface where i can make an article in which i can set text style size image size style alignment etc according to me . how can i do this ... ?

something like as given below in ...."Add your solution here" panel

why not a question , ?

ok i have seeing this . this is already checked in property

where can i check this frnd ?

i have checked . it is selected as "sql server and windows authentication mode"

how i arreange them as ....

<course>
<chapter name="">
<module name="">
<page>p1</page>
<page>p2</page>

<module name="">
<page>p3</page>
<page>p4</page>



<chapter name="">
......

But my problem is that i have not xml file hardcopy . i am gnerating xml structure from datatable. and fetching data in datatable from database .

and than after fetching data i generate xml format for webservices . but its not satisfied the format as i want .. i hope u understand ... ... ?

what You want to scroll here ... according to your source , there is no too much data for scrolling .. only Label and a button ... more clear Your question.

Thnx

Thanx it's working

hey can You explain me a little what "filter: alpha(opacity = 50);" is will do ..
what is alpha and 50 ... give a explanation

i am using iis 7

hey dude , actually the process screens that he show in his article , is not showing in my
IIS .

Where can i find out properties in Default websites .. It's not showing properties there ..
Pls respond back dude.. .. ..

OK ...
These are foreign keys ...


Table is referenced by foreign key ..

mfapp403_500db.dbo.[targetinfoold]: FK__TargetInf__Cente__0777106D
mfapp403_500db.dbo.ClientCRTReportInfo: FK__ClientCRT__Cente__7EE1CA6C
mfapp403_500db.dbo.DayOpenDayCloseInfo: FK__DayOpenDa__Cente__1C1D2798
mfapp403_500db.dbo.SubgroupInfo: FK__SubgroupI__Cente__058EC7FB
mfapp403_500db.dbo.targetinfOld2: FK__TargetInf__Cente__41399DAE
mfapp403_500db.dbo.TempPaymentShceduleInfo: FK__TempPayme__Cente__297722B6


in this first one i.e. "mfapp403_500db.dbo.[targetinfoold]: FK__TargetInf__Cente__0777106D"

has the relationship with the table "targetinfoold" . and this table (targetinfoold) already deleted from my database ...
and now when tried to delete some data from my " centerinfo " .. it can not be possible ..

how to solve this ...i hope u understand ...

thnx dude ... ur solution working perfactly :)

NO my problem is not that ....

i want to select the next three dates of this date on behalf of any day (may be next three upcoming monday or sunday date which is greater than this dates(i.e. 2013-08-21 00:00:00.000)


as i mention at the end

Thank You so much bro ... ur idea work perfactly ... Thanks again bro :)

how to hide update progress controls for all other controls .. how will i do this .. tell me bro ?

i can't this this my requirement bcoz here on autopost back of drop down i select the items in next drop down list ...

so it can'nt be done ...
tell some other way bro . :)

ok .. i am opening a new question now

no ..its not giving the desire result ...

it work but not giving the desired result

actually the query result which is inside inner joining brackets

i.e. (SELECT CenterInfo.Center_Name, CenterInfo.Center_Code,
CenterInfo.Center_Id,CenterInfo.Center_Id_Format,
MAX(DayOpenDayCloseInfo.DayOPenCloseId)
FROM CenterInfo
INNER JOIN DayOpenDayCloseInfo
ON CenterInfo.Center_Id = DayOpenDayCloseInfo.Center_Id
WHERE (CenterInfo.Unit_Id = @UnitId) AND (CenterInfo.IsActive = 1)
AND (CenterInfo.company_u_id=@company_u_id)
GROUP BY CenterInfo.Center_Name, CenterInfo.Center_Code,
CenterInfo.Center_Id,CenterInfo.Center_Id_Format)
)

give a result set and a single row for each center_id

but when i join this with a table than i only want to select those results which which satisfy this condition ... (DayOpenDayCloseInfo.IsActive = 0)

there is multiple records in DayOpenDayCloseInfo for each center_id but i have to slect only those results which satisfy this condition e.i. (DayOpenDayCloseInfo.IsActive = 0) and "MAX(DayOpenDayCloseInfo.DayOPenCloseId) " for each center_id

how can i drop the temp table befire inserting data of that table .....?

for which table you say this ...for #MYTEMPTABLE ...
? pls explain ..

rply.........

whats the problem ...give some hint ..

i want to show in this manner .

clientId | addressid | paymentid
1 | 12 | 102
2 | 13 | 103


i.e. with max paymentid of that client ....

how to do this ?

actually i am unable to give detail at this time , but i can explain u this in detail what i want ...... ..

i have three tables .....
1. ClientDetailTable(clientId as primary key )
2. PaymentDetailTable (paymentId as primary key ) (clientId as foreign key )
3. AddressDetailTable (AddId as primary key) (clientId as foreign key)


now i want to select all clients record which exist in "ClientDetailTable" and their addresses from

"AddressDetailTable " . i have no problem in this (record for each client exist only once in both "AddressDetailTable " and "ClientDetailTable" ) , but when i am trying to join corressponds record from "PaymentDetailTable " i have arise a problem . Actually in "PaymentDetailTable " record exist more than once (paymentId is set identity(1,1)) now i want to select record from "PaymentDetailTable " which has maximum "paymentId " for that client ....
and in this way i want to join these three tables ....pls give suggestion bro......

i hope u understand the problem , waiting for response ......

no .. this is not going to be happy , problem is as maintain as before , now i think i have to work on all database manually ...sit

all thing is right ...working on other system ......

...
?

no there is no error in config file ..i checked it.. i also checked it on other iis .

actually it's an iis error ...but unable to solve it....

hey i have a one question

what i open sql server ..
than it shows some things..
server name= i know this.


and what mode i have to choose for accessing database at remote location (no user id password)

sql server authentication or windows authentication ..?

i think sql server authentication and i should leave username and pass blank ......am i right dude ? rply..

Thanks dude.....

ya ..thanks ...your suggestion is good....

ok ...i can make auto id as primary key..but my problem is that i want to make a column of type as told u above in my question and it must be unique...


for ex...
raju.232.01

last value increment automatically and first two take from column , r u understnding my problem , pls suggest something.......

i know this must be false, but if we use it to 'false' than there will be a security hole create in my project....actually i think that you know that this 'Enabe Event Validation ' is used for validating the server control..that the request come to server..is reallly come from the server control or its a fake request..this event validating this...so there will be a risk if i do this 'false'...so can u tell me whats the specific reason behind this error and any idea now how can i remove this error

int index;

index = Convert.ToInt32(e.CommandArgument);

GridViewRow row = gridview1.Rows[index];
label lbl=GridView1.rows[index].cells[0];
string VOrderId=lbl.Text;

and then ....
here i perform my delete operation with a simple procedure..

actually i understand the problem but can not finding solution...
i think problem is that value of row index is start from zero....

but when i using paging ....row index value seen to be start from negative(i think so)...so any help frnd...?

int index;

index = Convert.ToInt32(e.CommandArgument);

GridViewRow row = gridview1.Rows[index];
label lbl=GridView1.rows[index].cells[0];
string VOrderId=lbl.Text;

and then ....
here i perform my delete operation with a simple procedure..

actually i understand the problem but can not finding solution...
i think problem is that value of row index is start from zero....

but when i using paging ....row index value seen to be start from negative(i think so)...so any help frnds...?

it's ok...

you are top experts this month...

can you solve my problem...
(see solution 3)

hello mr.Sergey Alexandrovich Kryukov ..what you want to say that i am sending a fake answers...what you want to say ?first see the solution first ...than comment here. it's more good.ok

the code provided here is not working....
you are really funny...no idea ..why post such a bad comment here on my profile

ok i tried this code now ..


string s11 = FileUpload1.FileName.ToString();
string s2 = Server.MapPath("");
string s3 = s2 + "\\" + "ImagesUploaded" + "\\" + s11;
FileUpload1.SaveAs(s3);

Image2.ImageUrl = "~/ImagesUploaded/" + s11;

it will working on my page but when i implement this same code in my other
where i want to use this..it do nothing ,i am unable to understand problem...
can u suggest something?

ohoo...so thnx to you bro.."ProgramFox"..
this will reall help me in my project..thank you bro

tnx bro..i tried the code and run , i have a little problem

it give an error on "fileList"
and error is "file list is a variable and u used like a method"...?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;

public partial class MasterPage : System.Web.UI.MasterPage
{
protected void Page_Load(object sender, EventArgs e)
{




if (!Page.IsPostBack)
{
//Programmatically pick a random image from the ~/Images directory
Image1.ImageUrl = PickImageFromDirectory("~/Images/HeaderImages");
}
}



//Returns the virtual path to a randomly-selected image in the specified directory
private string PickImageFromDirectory(string directoryPath)
{
DirectoryInfo dirInfo = new DirectoryInfo(Server.MapPath(directoryPath));
FileInfo[] fileList = dirInfo.GetFiles();
int numberOfFiles = fileList.Length;

//Pick a random image from the list
Random rnd = new Random();
int randomFileIndex = rnd.Next(numberOfFiles);

string imageFileName =fileList(randomFileIndex).Name;
string fullImageFileName = Path.Combine(directoryPath, imageFileName);

return fullImageFileName;
}






}

if question is poor than give answer dude, not a such poor comment.okk

i have set a image on my master page in asp.net. now i want that its master page image change time to time, as u seen in many web sites, i want this....
as u say in your first case, and also tell ur second case..i can we do this?

bro, u r right, but i tried also by removing this "checked=false" but it not working...
actually my this code work well in vs2010 but when i use this code in my vs2008 , than there is problem accour, i select the checkbox but it cann't be selected..

hey bros ..give response...

hello bro , problem is not that which link you refer me...i am asking about check box as i told detailed in my question.....and your link give no idea bout this...?