Comments by ythisbug (Top 200 by date)

ok thank you..but error is not using caching rite..now i solved this ..thank you...
in my database time format saved in "2013-11-15" and while fetching i was getting value as "15-11-2013"..so that was the issue..
thanks again

I mentioned in last line

OK THANK YOU

no.not working only

thank you

ok thank u

in this no update delete.am binding data to dat dropdownlist i.e cmbEPS

no

thank you.but i want to fetch records from database..how can i do that..?

k.but that link.but i want to display from sql .

thanks for your artical..

ok thank you

for example i told request..
actually am selecting itemid and two dates to get total count withing 30 days

null value is not there ..0 values are there so i dont want to display 0 values..

sorry that is not view that is function am using in my sp

am joining all tables to get tat total quantity from different different tables quantity..as am Getting Quantity

Qty is not colum..am getting as Qty

thank you..but am using view inside sp..so how can i use dat Qty to filter with where condition

thank you.but this query counting all.nt like within one month i mean in 30 days hw many request i gt

k can u give me any examples?

ok.i updated query

thank you. but machinery is value nt column field..

ALTER PROCEDURE [dbo].[usp_RptVacantPropertyByUnits]
@PropertyID int=null,
@DateFrom datetime=null,
@DateTo datetime=null
AS BEGIN
if @PropertyID is null
Begin
SELECT tblContractDetails.*,tblContractHeader.*,tblAssetRegister.*
FROM
tblContractDetails
INNER JOIN
tblContractHeader ON tblContractDetails.cdeDID = tblContractHeader.chDID AND
tblContractDetails.cdeDocType = tblContractHeader.chDocType

left outer join tblAssetRegister on tblContractHeader.chPropertyID=tblAssetRegister.asID
WHERE (@DateFrom IS NULL OR
tblContractHeader.chDocumentDateTime >= @DateFrom) AND (@DateTo IS NULL OR
tblContractHeader.chDocumentDateTime <= @DateTo)

AND tblContractHeader.chIsDelete=0 and tblAssetRegister.asDocType='PRE1' and tblAssetRegister.asID is null
ORDER BY tblContractHeader.chDocumentDateTime




End else if @PropertyID is not null
Begin
SELECT tblContractDetails.*,tblContractHeader.*,tblAssetRegister.*
FROM
tblContractHeader
INNER JOIN
tblContractDetails ON tblContractHeader.chDID = tblContractDetails.cdeDID AND tblContractHeader.chDocType = tblContractDetails.cdeDocType
left outer join tblAssetRegister on tblContractHeader.chPropertyID=tblAssetRegister.asID

WHERE


tblContractHeader.chIsDelete=0 and tblAssetRegister.asID is null and tblContractHeader.chPropertyID in(select asID from tblAssetRegister where asID=@PropertyID and tblAssetRegister.asDocType='PRE1')
ORDER BY tblContractHeader.chDocumentDateTime

End
END


this is my query but am not getting records.. can any one suggest me wats the issue..
thank you

that ok but how to get unmatched records..inleft outer join will get all records rite..i want non repeated records in second table. i.e tblSales.

ya thats da issue

which i pasted query for that am getting records but am getting all records..bt not for perticualr id..
in my report format am selecting company name(party name) and two date fields start and end..within that ddate i want to fetch records..

thanks griff

ya i tried.i want to join three tables to get some details related to perticular id.i mean cmcompanyid

i want some fields not all.

i want some fields not all.thank u

thank you..but in second page am not using and html code i mean textbox or dropdown list..so how can i use here/...

thank you.i modified question.

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (((LinkButton)GridView1.Rows[0].Cells[0].Controls[0]).Text == "Insert")
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO tblTimeSheet(tsProject,tsStartDate,tsEndDate,tsMonday,tsTuesday,tsWednesday,tsThursday,tsFriday,tsSaturday) VALUES(@Project,@StartDate,@EndDate,@Monday,@Tuesday,@Wednesday,@Thursday,@Friday,@Saturday)";
cmd.Parameters.Add("@Project", SqlDbType.VarChar).Value = ((DropDownList)GridView1.Rows[0].Cells[2].Controls[0]).SelectedItem.Text;


//cmd.Parameters.Add("@Project", SqlDbType.VarChar).Value = ((DropDownList)GridView1.Rows[0].Cells[2].FindControl("ddlProject"));
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = ((TextBox)GridView1.Rows[0].Cells[3].Controls[0]).Text;
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = ((TextBox)GridView1.Rows[0].Cells[4].Controls[0]).Text;
cmd.Parameters.Add("@Monday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[5].Controls[0]).Text;
cmd.Parameters.Add("@Tuesday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[6].Controls[0]).Text;
cmd.Parameters.Add("@Wednesday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[7].Controls[0]).Text;
cmd.Parameters.Add("@Thursday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[8].Controls[0]).Text;
cmd.Parameters.Add("@Friday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[9].Controls[0]).Text;
cmd.Parameters.Add("@Saturday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[10].Controls[0]).Text;



cmd.Connection = con;

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}


else
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE tblTimeSheet SET tsProject=@Project,tsStartDate=@StartDate,tsEndDate=@EndDate,tsMonday=@Monday,tsTuesday=@Tuesday,tsWednesday=@Wednesday,tsThursday=@Thursday,tsFriday=@Friday,tsSaturday=@Saturday WHERE tsID=@ID";


cmd.Parameters.Add("@Project", SqlDbType.VarChar).Value = ((DropDownList)GridView1.Rows[0].Cells[2].Controls[0]).Text;
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = ((TextBox)GridView1.Rows[0].Cells[3].Controls[0]).Text;
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = ((TextBox)GridView1.Rows[0].Cells[4].Controls[0]).Text;
cmd.Parameters.Add("@Monday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[5].Controls[0]).Text;
cmd.Parameters.Add("@Tuesday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[6].Controls[0]).Text;
cmd.Parameters.Add("@Wednesday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[7].Controls[0]).Text;
cmd.Parameters.Add("@Thursday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[8].Controls[0]).Text;
cmd.Parameters.Add("@Friday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[9].Controls[0]).Text;
cmd.Parameters.Add("@Saturday", SqlDbType.Decimal).Value = ((TextBox)GridView1.Rows[0].Cells[10].Controls[0]).Text;

cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text);
cmd.Connection = con;

con.Open();

cmd.ExecuteNonQuery();

con.Close();



}



GridView1.EditIndex = -1;

BindData();

thank you..
am getting error..
literal does not contain a defination for selecteditem or no extension method..??

i tried ur code.but no output only..

i tried this code bt am getting 3 rows
here is my code..

in gridview row created event

headerCell = new TableCell();
headerCell.Text = (dt.AddDays(1 - (int)dt.DayOfWeek)).ToShortDateString();
// headerCell.Text = dt.AddDays(0).DayOfWeek.ToString();
HeaderGridRow.Cells.Add(headerCell);


headerCell = new TableCell();
headerCell.Text = (dt.AddDays(2 - (int)dt.DayOfWeek)).ToShortDateString();
HeaderGridRow.Cells.Add(headerCell);


headerCell = new TableCell();
headerCell.Text = (dt.AddDays(3 - (int)dt.DayOfWeek)).ToShortDateString();
HeaderGridRow.Cells.Add(headerCell);


headerCell = new TableCell();
headerCell.Text = (dt.AddDays(4 - (int)dt.DayOfWeek)).ToShortDateString();
HeaderGridRow.Cells.Add(headerCell);



headerCell = new TableCell();
headerCell.Text = (dt.AddDays(5 - (int)dt.DayOfWeek)).ToShortDateString();
HeaderGridRow.Cells.Add(headerCell);


headerCell = new TableCell();
headerCell.Text = (dt.AddDays(6 - (int)dt.DayOfWeek)).ToShortDateString();
HeaderGridRow.Cells.Add(headerCell);


GridView1.Controls[0].Controls.AddAt(0, HeaderGridRow);
can any one suggest me wat is the error..
am getting 3 rows ..i mean its adding 3 rows for same date in header
like
12/10/2012...........12/15/2012
12/10/2012...........12/15/2012
12/10/2012...........12/15/2012

Porblem is in header i want to set date in grid..like i want to add 6 days from monday to satturday..tat date i want to disply it in grid header..

thank you.but am not able to use lblMonday in code..so m not sure that wethr we can use grid header like label to bind days of week..

thank you..but this i used before..it will disply same dates in all labels..i want to dispay mondy date in mondays label..

thanks you so much..have a nice day.

thanks krunal..bt i need c# code..

and enumeration yielded no results...

if i use like tat query while selecting rowcommand am gettin error there is no row at the position 0..

yes your rite thank you

thanks its working but while selecting row command to edit its comming error "there is no row at the position 0"....

while executing am giving value as 66 tat id is related in all three tables..

thanks for ur reply ..i modified question

this sp will retrieve records from related to ID..while saving records in tblQuestionnaire adding tblDocumentMasters dmID and in QuestionnaireSub adding qsTPRID as tblQuestionnaires quesTPRID..so am not retrieving records while executing..

ok thanks for ur suggestion

thanks.again wat u want me to clear?means i dont want to show in table .i want to display records without table.like line by line like tree view

how to do tat .can u suggest me

ok thank u

ok thank u

am using dynamic in my project.thanks

see my solution

@Srinath
simple idea is add column to perticular table and save field as columnTablename in that field add ur table name.and bind to dropdown as columntable name field and click export then u can get details..try this solution to export to excel.

here am getting error cannot find table 0.

thanks and how can i display message if perticular Name not found in datagrid?

thanks sathish

sqlcommand.Parameters.Add(new SqlParameter("@UserID", Session["uid"].ToString()));

this line for Session ..

for Session am getting error used like a DotMan.Session is a namespace but used like a variable

i just want to increment using compute(max)

no its not working?i tried tat code

ya same i did before only..

how to use compute method in this answer??

deren its not adding wat to do..?

now working small changes have to do row[0]

no its not incrementing know..newly added row adding as 1 only

ok thanks i will try

sorry not dataset ..datatable dtBidtree

in .net side

while editing am calling delete function den am inserting data.am using sp to insert data via for loop..and with the help of dataset dtBidtree

thanks sderen. can u suggest me more about this answer..i think in your post i will get answer.

ya :) for that only i din knew how to ask so thout reader will suggest me..thank you

again wat have to modify graus...??

i updated my question.thank u

thank you i updated

thanks sandeep..this all i tried before.:) thanks again

thanks sandeep..but i tried more than three sample project for saving image in database..bt its not working.or just give me link simple and easy

and again i tried another example
http://www.redmondpie.com/inserting-in-and-retrieving-image-from-sql-server-database-using-c/

for this am getting error same as above..Instance failure

ya same .

aday that spelling mistake.its ythisbug

thanks sandeep..but in other forms save and retrieving data to datagrid working fine..for this form only error..

no while running project am egging this imagefromdatabase error instance failure and while saving instance failure

error is the samne.am retrieving table data in gridview so i set table name

i removed parameter now working but..i want report from within two textbox..for that any idea..

ya thanks

thanks

am getting error for this line..
invalid index...


crParameterFieldDefinition = crParameterFieldDefinitions["tblPurchase"];

thanks i want c# code..this vb know

no shemeer.not solved.thanks for ur reply

ok thank u kiran

ya dsEmployee is null..better solution for this?

thanks .not der can u suggest me.acually am using datagrid..

DataTable dtEmployee = dsEmployee.Tables["tblTicketing"].Copy();

this line am getting error

DataTable dtEmployee = dsEmployee.Tables["tblTicketing"].Copy();

in this line am getting error..
is dat code is correct?

ya ur rite..thanks SA

ok thanks

ok which component should i select..and which reference should i add???

ya sandeep tat class already there in my code..but dont know y that error coming.

any solution for this??

ya ur rite am reffering sandeep.

type or namespace name 'PageOffsetList could not found (are u missing directive or an assembly reference"?

http://stackoverflow.com/questions/2825771/how-can-we-do-paging-in-datagridview-in-winform
am trying this artical for gridpaging

thanks..tat already i declared but also comng error

ya i tried thanks

//dateTimePicker1.CustomFormat = "MM,dd,yyyy";
ya i tried like this

thanks but this format is displaying like "july 29.2012 Monday "

can u show us code how u tried for print?tat we can help u?

thanks..i mean to say i want to add one more table to join in that query tblCategorySub with subcID is column name..if any doubt..reply

thanks prasad

ok thanks..in my table btID is pmkey.

your rite its assigning already used nodeid once again..can u suggest me again wat have to do

thanks i will check

that answer for web apllication

actually i din know. tat was in asp.net so i tagged as asp.net

thanks for ur effort .am doing project in asp.net as winform application
for example
File->New->Project->VisualC#->Windows Forms Application

ok so wat u have to do is..in page load
If(!IsPostBack)
{
BindGrid();
//this will display records from database to grid
}

then in save click button after your save query
BindGrid();
just try this..hope it will work 100%

thank u

thanks for ur reply

thanks..already i coded.but i want to write function inside tat usercontrol which i created to show data from database

how to write a function inside usercontrol to show data from database..
??

ya so any solution.thanks

tat vb rite..and how to convert vb to c#..in google it will available rite..thanks

ya in winform application only i want to display total in grid.

oh ..just click new ->project->Visual C#->Windows Form application..just c u will find.
thanks

thanks dude..modify ur asnwer i will accept..thanks again

thanks ryan if i use "\" am getting error "unrecognised escape sequence"..

sry i dint understand wat u said

ALTER PROCEDURE [dbo].[usp_GetTPR1Details]
@DID varchar(10),
@DocType varchar(4)
AS BEGIN
Select * from tblStockDetails,tblStockHeader,tblTender,tblBidTree
where btDID=@DID and btDocType=@DocType and sdDID=@DID and sdDocType=@DocType and tndDID=@DID and tndDocType=@DocType

like this i tried

thanks griff..bt also not getting values

am using 3 tier.

ok.so web site is c# code and windows form application is vb code rite??that s the difference.and we can converty c# code to vb code rite?

i used class files and stored procedures ajax,etc..can u tel me breifly wat code can i give u that u will get to know?

k thanks abhinav

thanks zoltan..but i don knw how to save many nodes in single query..i gues by loop we can??

objTPRPL1 is PL class..and changing in a batch..

this is InsertBidTree in Dal class
public void InsertBidTree(TenderPreparationPL objTPRPL1)
{

SqlCommand cmd = new SqlCommand();
SqlConnection con = new SqlConnection("Data Source=accerlap2;Initial Catalog=Tendering2;User ID=sa;Password=p@ssword;");
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_InsertBidTree1";
cmd.Connection = con;

SqlParameter paraDID = new SqlParameter("@DID", SqlDbType.VarChar, 20);
SqlParameter paraDocType = new SqlParameter("@DocType", SqlDbType.VarChar, 4);
SqlParameter paraNodeID = new SqlParameter("@NodeID", SqlDbType.Int);
SqlParameter paraParentNodeID = new SqlParameter("@ParentNodeID", SqlDbType.Int);
SqlParameter paraName = new SqlParameter("@Name", SqlDbType.VarChar, 50);
SqlParameter paraType = new SqlParameter("@Type", SqlDbType.VarChar, 50);
SqlParameter paraDetals = new SqlParameter("@Details", SqlDbType.VarChar, 1000);

paraDID.Direction = ParameterDirection.Output;

paraDocType.Value = objTPRPL1.btDocType;
paraNodeID.Value = objTPRPL1.btNodeID;
paraParentNodeID.Value = objTPRPL1.btParentNodeID;
paraName.Value = objTPRPL1.btName;
paraType.Value = objTPRPL1.btType;
paraDetals.Value = objTPRPL1.btDetails;

cmd.Parameters.Add(paraDID);
cmd.Parameters.Add(paraDocType);
cmd.Parameters.Add(paraNodeID);
cmd.Parameters.Add(paraParentNodeID);
cmd.Parameters.Add(paraName);
cmd.Parameters.Add(paraType);
cmd.Parameters.Add(paraDetals);

cmd.ExecuteNonQuery();

objTPRPL1.btDID = paraDID.Value.ToString();


con.Close();


}

i posted another question.please check

am using tree nodes so if i add more than three nodes tat name should be added can u suggest me how to do this?

now am getting error for @Name..actually i don know how to place in loop if there more than 3 records for same name..can u suggest me?

no dear

but also same error for ParentNodeID

ya ur rite.bt i modified after posting artical

thanks but error is da same..

thanks joshi

or suggest me the way u think..thanks

no dont have server..i want to publish web application ..are you asking where you could upload your site to?(yes am asking)

thanks can u explain me,.wat is TestID,TestValue ?

int val;
(Int32.TryParse(bjDFPropTemp.dfFieldValue, out val) && val > 0)

where to declare this..thanks

as u said i tried like this

else if ((objDFPropTemp.dfFieldType == "money") || (objDFPropTemp.dfFieldType == "decimal"))
{
if (objDFPropTemp.dfFieldValue != null)
{
//txt.Text = ((decimal)objDFPropTemp.dfFieldValue).ToString();
txt.Text = objDFPropTemp.dfFieldValue.ToString();
}
}
else
txt.Text = (string)objDFPropTemp.dfFieldValue;
}

//but again in another line am getting error .error is same cast is not valid

if (objDFPropTemp.dfFieldType == "int")
{


// if ((objDFPropTemp.dfFieldValue != null) && ((int)objDFPropTemp.dfFieldValue > 0))
if((objDFPropTemp.dfFieldValue != null) && ((int)objDFPropTemp.dfFieldValue > 0))//this line am getting error now
{
if (objDFPropTemp.dfControlValue.Contains("["))
{
DataSet ds = new DataSet();
string varSubField = string.Empty;
string varField = string.Empty;

varSubField = objDFPropTemp.dfControlValue.Substring(objDFPropTemp.dfControlValue.IndexOf("[") + 1, objDFPropTemp.dfControlValue.IndexOf("]") - objDFPropTemp.dfControlValue.IndexOf("[") - 1);
varField = objDFPropTemp.dfControlValue.Substring(0, objDFPropTemp.dfControlValue.IndexOf("["));
string controlTable = objDFPropTemp.dfControlTable;
int id = (int)objDFPropTemp.dfFieldValue;
SISTextBoxPopupBLL sISTextBoxPopupBLL = new SISTextBoxPopupBLL();
ds = sISTextBoxPopupBLL.GetTextBoxDataByID(id, controlTable);

if (ds != null)
{
if (ds.Tables[0].Rows.Count == 1)
{
string fieldText = ds.Tables[0].Rows[0][varField].ToString();
int fieldValue = Convert.ToInt32(ds.Tables[0].Rows[0][varSubField]);
txt.Text = fieldText.ToString();//((int)(objDFPropTemp.dfFieldValue)).ToString();
txt.Attributes.Add("ID", fieldValue.ToString());
}
}
}
else
{
txt.Text = ((int)(objDFPropTemp.dfFieldValue)).ToString();

}

}
}
else if (objDFPropTemp.dfFieldType == "datetime")
{
if (objDFPropTemp.dfFieldValue != null)
{
txt.Text = ((DateTime)objDFPropTemp.dfFieldValue).ToShortDateString();
}
}
else if (objDFPropTemp.dfFieldType == "bit")
{
if (objDFPropTemp.dfFieldValue != null)
{

txt.Text = ((bool)(objDFPropTemp.dfFieldValue)).ToString();
}
}
else if ((objDFPropTemp.dfFieldType == "money") || (objDFPropTemp.dfFieldType == "decimal"))
{
if (objDFPropTemp.dfFieldValue != null)
{
//txt.Text = ((decimal)objDFPropTemp.dfFieldValue).ToString();
txt.Text = objDFPropTemp.dfFieldV

DynaControlsPL objDFPropTemp = (DynaControlsPL)gListDynamicControls[i];

and dfFiedlValue is column name from dynamicform..am using dynamic in my class

am calling class
DynaControlsPL objDFPropTemp = (DynaControlsPL)gListDynamicControls[i];

thanks
but if i do as u say i will get error for other line

if ((objDFPropTemp.dfFieldValue != null) && ((int)objDFPropTemp.dfFieldValue > 0))
for this line also same error i will get

thanks zoltan
in my project am saving additional tab records to one table and grid records to another table so am getting error??is it??

thanks sandeep

once again thanks richard

and wat about if i create project in asp.net?like file-> new-> Project..in this i can create shortcut login page in desktop?

thanks richard

yes tat i can create login shortcut file in my desktop,..

thanks rushi i will try.thanks again

created web application...website..for that we can do like window application??

thanks sandeep

thanks u sandeep.i will try

thanks.
i put breakpoint in lbl1,lbl2,lbl3 value coming null..
and in grdTotal1,grdTotal2,grdTotal3 getting value.

thanks for ur reply..
lbl1.Text = grdTotal1.ToString("c");
am getting error in this line..

thanks sandeep i will try..

lblTotalCash.Text = pSum.Value.ToString();

THIS LINE AM GETTING ERROR

here total contains??column name??

no its not working

i tried but its not happening

u mean to say in delete button click also have to call dat bind dropdown?

ok thanks dude i will

hi i put breakpoint and checked in layoutPosition its showing as undefined..
so can u tel me where have to change?

thanks

thanks for ur suggestion

thanks for ur suggestion

ok thank u

ya thanks mika