Comments by shivani 2013 (Top 200 by date)

Thanks but i searched a lot..There is a option for predefined prerequisite but not for custom prerequisites.

Thanks for your reply but if i have 100s of PC.Its very time consuming process.

Thanks ....i forgot the basic thing

then how to iterate this....i want everytime new invoiceentity data

leading zeros are dynamic.there can be 2 , 3 , 4 depending upon user

thanks for reply.its dynamic .... for more clarification i have updated my question.

hey i achieved it trogh datatable..thanks for structure and will query you again ...if face issue...thanks

sp is returning result with two records..

updated code is



public List<invoice> GetData()
{
var connectionString = ConfigurationManager.ConnectionStrings["csTcube"].ConnectionString;
List<invoice> resultList = new List<invoice>();
SqlConnection dbConnection = null;
SqlDataReader reader = null;

try
{
dbConnection = new SqlConnection(connectionString);
// IDbCommand dbCommand = new SqlCommand();

SqlCommand dbCommand = new SqlCommand();
dbCommand.Connection = dbConnection;
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.CommandText = "TimeSummary_ForInvoice";

dbCommand.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = "2014-05-31"; // dtFrom.Value;
dbCommand.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = "2014-06-01";// dtTo.Value;
dbCommand.Parameters.Add("@Company", SqlDbType.Int).Value = 2;
dbCommand.Parameters.Add("@InvoiceStartNo",SqlDbType.Int).Value=1;

SqlDataAdapter adp = new SqlDataAdapter(dbCommand);
DataTable dt = new DataTable();

dbConnection.Open();
//
reader = dbCommand.ExecuteReader();

//adp.Fill(dt);
//if (dt.Rows.Count > 0)


//
while (reader.Read())
{
Invoice invoiceEntity = new Invoice();
invoiceEntity.Rowno=(int)reader["Rowno"];
invoiceEntity.ProjectName = (string)reader["ProjectName"];
invoiceEntity.EmployeeRoleTypeName = (string)reader["EmployeeRoleTypeName"];
invoiceEntity.WorkHours = (decimal)reader["WorkHours"];
invoiceEntity.InvoiceNo = (string)reader["@Invoice"];
invoiceEntity.CurrentDate=(DateTime)reader["CurrentDate"];

resultList.Add(invoiceEntity);
}
}
catch (SqlException exception)
{
// throw new MyExceptionClass(exception.Message, exception); //This is good to have!
}
finally
{
if (reader != null)
reader.Close();

dbConnection.Close();
}
//
return resultList.ToList();


}

I tried ur way but facing issue while(reader.read()) -- there is no data present and is skipping all code with in it..through sp i am returning table with multiple records.

its not working

I got cause..order of elements in xml and xsd are different but now issue is how to ignore the order

I just want to compare the schema structure of 2 xml.For that purpose I created xsd from one xml and then comparig that xsd (schema structure) with another xml...so that I can know whether both xml have same structure or not

Is there no one who can help me on this?

but same error

I have already done that

thanks for your reply .I have already looked this link but no help
if you do it over here .....it wld be really appreciable

its not working

no it won't tproperty can't be accessed

thanks a lot I learnt something new today...GOD bless you

thanks it worked, tried everything but not this neeways thanks once again

thanks for your effort but what i want is not serving my purpose

pls tell where to set compile to "any CPU" or X86.There is Build -> platform target .i have set it to X86

Thank you so much.very helpful.really appreciable....even got the way to ask the question and thanks for updating the question...never thought of derived tables to work on..

pls see to it .i have updated it ........

i have updated my question......do see

i have updated my question......do see

it doesn't worked thanks for ur effort

my scenario is :there are 2 students of V class having eng subject each getting respective marks 55 and 54.now when i list i should have one more column highest marks which will be shown in each row (here 55) .so in both rows it should show 55 marks of english subject with other detials(like student name,class.marks obtained) and same for maths subject of same student and the of different class student...i hope u got my scenario........

i Have 2 classes V and VI with respective 2 subjects english,maths and maths,science.now i want to list all students name with their respective marks opbtained,highest marks(respective class and subject),class,subject,gender and address.
i hope u got it

it is not fulfilling what i want.i want it in page load too

not working

i need to achieve through this only and one more thing .instance is i have two records for user A but when i need to show it on grid it is only displaying one record only thogh datatble having 2 records.pls tell how to achieve it

what is viewbag.and do ineed to add any reference to have viewstate??????????????

thanks.i got it.........

i have already done com.executenonquery for both
still i am not getting desired result

there is no problem in code.....i want to have option in web.config.i want to use only one connectoinstring at a time.if i use option of "test" it should fire only sqlconnection and if i use option of "test1" it should fire only oledb connection how can i achieve this
regards

I defined Transaction before the loop and commit in finally statement..i updated my question but again it is doing same and with error
"This SqlTransaction has completed; it is no longer usable.".

pls tell wat to modify here
regards

i have updated my question see to it

it is not serving my purpose........can you tell what mistake i did in this??????????

it has no affect ......it is again inserting first two rows and leaving third row....infact it should have not insert either of three

thanks.i have one more issue that i want when i click on particular item of i want its product cost should come in a given textbox .i am not able to achieve through ddlprd_selectedindexchange but same i can achieve on clicking button...y so ...how can i achieve through ddlprd_selectedindexchange ?
pls tell
regards

thanks i got it.......

in grid no data is filled..i need to fill the data through textboxes then how can i tale loop till grd.Rows.Count???????????

it is showing only current values in place of previous .....first row is only getting affected.....
pls tell
thanks

wat u wrote now i did initially same ...but got that same error........secondly i want to add items into grid depending upon products in dropdownlist so i delebrately did that so that my loop should start from 0 till dropdownlist count

i have updated my code.pls see to it...
regards

ok i am posting my code.
i acknowledge you for my help....

I need to add the data from textboxes to datagrid using datatable..........
in start, I entered data in respective textboxes and clicked "ädd" button .it entered into grid...now again i entered different data for respective textboxes...it should enter in to grid and should retain previous row data too.while doing this i am getting error told before

4

i am getting one error on dtDetails.Rows.Add(i + 1, grdDetails.Rows[i].Cells[1].Text, grdDetails.Rows[i].Cells[2].Text, grdDetails.Rows[i].Cells[3].Text, grdDetails.Rows[i].Cells[4].Text); when i click again add cart with another value
pls help
"Input array is longer than the number of columns in this table."

i dont want it to add in db...

sir it is done on a single table i want in multiple table

this is done only on a single table .......i am not able to achieve this in multiple tables.pls tell

if i want to affect more than one table........hw is it possible????????

i am sorry i couldnt write whole code,,sry for ur valuable time .pls see that

i am sorry i couldnt write whole code,,sry for ur valuable time .pls see that

i am sorry i couldnt write whole code,,sry for ur valuable time .pls see that

i passed state id through method.pls see that

thanks for this control but can't i use like this...m mean i what io am missing in this code....

i did what u said .i am getting an error after sending mail on
mailMessage.To.Add(email_to); that " The parameter 'addresses' cannot be an empty string.
Parameter name: addresses " and the message has been said to the persons to whom i send mail but without attachment.....pls resolve
regards

its in correct format

i have used foreach and an arraylist which it will take the addresses too whom to send..

not getting result..........
same msg

i have updated my ques...see to it
thanks

i made all changes what u did over here but nothing happened

thanks

thanks

i got my mistake............thanks for help.......i need to define a method in web form too..

is there no one who could help me out of this..........

thanks ............it works

i am getting all changes at design time but not on run time

why then why it has been given properties in grid view

no change

i created style sheet and wrote above code and linked it to the form source code but in headerstyle---->cssclass i wrote .GridHeaderRowClass bbut on run timne no change.have i missed something

for this i need to create style sheet or what.plz telll in detail.i m new to this

grid view

thanks

how to navigate from one form to another form(the value depending upon first form)
i want when the receipe name comes on the form from the database and there are 40 receipe names ...when they appear on the form...then clicking on the receipe name its all details(author,ingredients,instructions etc) come on another form e.g.

I have 40 receipes coming from database in form named receipe.aspx
and when i click on any one receipe ,its detals should come on another form....how can i achieve this

can u expain it more in detail

have u got what i want
??/

i want when the receipe name comes on the form from the database and there are 40 receipe names ...when they appear on the form...then clicking on the receipe name its all details(author,ingredients,instructions etc) come on another form

ok i explain it again

in DataBinder.Eval (Container.DataItem, "recipe_name")
error is Container does not exist

Have you understood my case...i mean what i want in this code can be done through sessions or can be done through any other means

nothing working out........

What should be written in parameters of eval as it is asking about eval(object container,string expression)?????

its not working

I got your point to some extent about making CurrentRating="0" but when i run i want user to select the star of his choice and then star get selected but no action is performed so help me out on this

thanks ..You really supported me on this .You are acknowledgeable

Could you pleaes tell how to add reference to ajaxtoolkit dll to my web application.

how to add the elements?

thanks

I am not getting answers thats why i came here
.it would be good if u help me for this

thanx

i want to say that filewatcher is used to monitor the files for a particular path we give ....here where i need to

I have only this data........

I am not getting what you are saying.I have made one database named Dorknozzle1 and in that there is a folder Programmability thereand in that there is stored procedure and in that ,"InserrtHelpdesk1" sp exists

stored procedure is in exist database

No, I have created this on Dorknozzle1 database

Sorry, I wrote wrong over here. I have written inserthelpdesk2 only in my code.I am getting same error.

Sorry, I wrote wrong over here. I have written inserthelpdesk2 only in my code.I am getting same error.

Thank you sir

Can u explain me one question with eg.
passing a value type variable into procedure as an argument.The procedure changes the variable,however when the procedure returns,the variable has not changed.What happened

I think its answer is that passing a value type into procedure creates a copy of the data.
Can u explain this with an e.g if this answer is correct

Thank you,the program has been run but I am not getting one thing that why compiler doesn't provide default one.........as i have read that default constructors are automatically called.

Thank you,I got it

Thank you,I got it

am i right

As u talked about taking sheets...what i got is i want to tell
in case of reference
1st sheet is just the label n1 and its actual value is stored in 2nd sheet (memory address)and when it is said n2=n1;it means n2 will access the value of n1 which is stored in 2nd sheet and the operations
n2.val+=1
n2.val+=2
will get access from 2nd sheet only

Why i need object obj;
int a=10;
obj=a;
I can simply write
int a=10;
console.writeLine(a);
i am getting same answer a=10;
then why to do this through object

Sir, I know the concept ogf polymorphism..how this is related ?

range means u can give value between -128 to 127 in case of sbyte
Code as follows:
sbyte a ;//8 bits
a=-128
binary form is 110000000(consisting of 8 bits)

Now, - is also given then one bit is reserved for it
then i am left with 7 bits only but binary form of 128 is of 8 bits...then how 8 bit can be placed .there are total 9 bits
so this dont satisfy the range

and binary form is

Thanx got it

Thank You for explaining.....I have a question in Turbo c we give the header file #include(graphics.h) and it is also console then why we cant use such namspaces for it though its not there in c# console

what will be the coding for it

sir file exists

sir i have visited this site already but not able to locate its exact implementaion in making web site

ah!then get an idea sir jeee
i mean there will be some logic for this

thanx
but why i got this error..i mean same thing written but now no error

Thanx i will keep it in mind

Thanx i will keep it in mind

thanx i got

thanx i got

Sir/Mam
on running project splash screen appears and them MDI parent form...wat shld I do so that after running splash screen i should get login page

rply sir

data is inserted, have seen in database but not for field resources its written "System.Data.DataRowView,System.Data.DataRowView"

i did
cmd.Parameters.Add(new SqlParameter("@Resources",listBox1.Items.Cast<object>().Aggregate((item1, item2) => item1 + "," + item2).ToString())); in place of
{
strC = strC + " ," + itm;

}
cmd.Parameters.Add(new SqlParameter("@Resources",strC);


insertion is successfully but in database in field resources data not fetched and written "System.Data.DataRowView,System.Data.DataRowView"

pls help

plz help

sir its desktop application .hw can i use </object>

what is listitem here

i just want that dropdownmenu should work as a menu

no.its not that what i need...........

No sir ,My question is not this....in combo box we have arrow in its design vertically(downwards) but i want to have combox whose arrow should be horizontallt(across)

thanx

there is no error but data is not fetched ,the way it fetched the data for single table

no ,its not wrking data is not displayed

Thanx for ur answer but i want that data should also get displayed of both the tables
i have updated my question

if i want to add another table in data set after i created crystal report .Can i modify crystal report and how...thanx in advance
regards

thanx

thanx

can u explain it more using code

can u explain it more using code

i hve updated question see it

i hve updated question see it nw

can u pls explain it little bit more with eg

can u pls explain it little bit more with eg

thanx

Sir its string only

Sir its dtring onlt

please rectify me if i am wrong anywhere

its string only

sir i am deleting it from database then how could i write the query
delete from Resources_Required where Resources='"+listBox1.SelectedItems[0].ToString()

achaa! isko kehte hai...ok
udhar toh query run ho gai there i need to specify
delete from PSM.dbo.Resources_Required where Resources="Team";(i have to specify the value which is present in field resources)

2008

getting an error"Failed to convert parameter value from a string to a Int16

can u tell how
m mean where is Sql Server Query Analyzer

warning
if (ro["Resources"] == listBox1.SelectedItem.ToString())
"Possible unintended reference comparison,to get a value comparison,cast the left hand side to type'string'
and nothing happened i mean not deleting the element

i have checked sir..no problem in query

it doesnt contain any definition for .item in
if (ro.Item["Resources"] == listBox1.SelectedItem.ToString())
and one more thing
its SqlParameter param = new SqlParameter();
instead of
SqlParameter param = New SqlParameter;

but no error

i have checked

getting error
instead of Tables() its Table[] in DataTable dt = ds.Tables("Resources_Required");
and warning
if (ro["Resources"] == listBox1.SelectedItem.ToString())
"Possible unintended reference comparison,to get a value comparison,cast the left hand side to type'string'

its not working I mean i am not getting any error while running but not deleting the elements too......and one more thing its listBox1.SelectedItems[0] not listBox1.SelectedItem[0] as it is giving error "cannt apply indexing with[] to an expression of type 'object' "

neah not working
no item was deleted

i have even tried before u wote..and this time i am getting an error
cannot find table[0]

no its not working....getting an error "listBox1.SelectedItems[0] does not contain definition of .Text"

u give solution to every problem of mine.thanx
regards

thanx

i got it

i dont get specified date in the text box which i inserted in database.i am always getting current date

But date value gets affected not text.I mean date is always shown in value not in text

got it

got it

how loop will work i mean can u tell the coding for looping items of listbox..i am not able to write

can u explain it more

as i need to add the items through listbox
can't i use like this

string resources =Convert.ToString(listBox1.Items);
cmd.Parameters.Add(new SqlParameter("@Resources", resources));

can u explain it in detail

thanks

yes sir i wont

thanks

thanks

thanks i got it.really thank you very very very very much

on loading form
private void Media_Method_of_Publicity_Load(object sender, EventArgs e)
{


SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Integrated security =SSPI;Initial catalog=PSM");
con.Open();
SqlCommand com = new SqlCommand("select * from Media_Method", con);
SqlDataReader dr = com.ExecuteReader();
DataTable dt = new DataTable();

dt.Load(dr);

dataGridView1.DataSource = dt;
dr.Close();
con.Close();

}
on clicking particular row of data grid view
SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Initial Catalog=PSM;Integrated Security=True");
con.Open();
//SqlCommand com = new SqlCommand("select * from Media_Method", con);
SqlCommand com = new SqlCommand("select * from Media_Method where Media_method_ID =dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()", con);
SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{

txtmediaid.Text = dr[0].ToString();
txtmedianame.Text = dr[1].ToString();
txtaudience.Text = dr[2].ToString();


}
dr.Close();
con.Close();
and here Media_method_ID is field name of SQL
and when i run the application every the error shown is
incorrect syntax near e.RowIndex

just wait i""l provide u

i am getting following error
incorrect syntax near e.RowIndex

the coding which have given me nw.i have alredy dne this.........my question is wat to write in this ??????? in following code
select * from teacher2 Where teacherID=????"
as i am selecting a particular row of dat grid view

the coding which have given me nw.i have alredy dne this.........my question is wat to write in this ??????? in following code
select * from teacher2 Where teacherID=????"
as i am selecting a particular row of dat grid view

its window application using C#.NET and SQL SERVER 2008

i want is on loading form whole data should get displayed in data grid view and i am getting this..............but wen i click one particular row of dat grid view then i should get data for respective selected row in respective text boxes......nw wat coding should i give
m mean select * from teacher where teacher_id=???????????as i m selecting particular row from dat grid view.......

can u explain in detail

I am getting An error
Cannot bind to the new display member
Parameter name:newDisplayMemeber

my question is function getmew is to be written in notepad and save it as .javascript and then how to call it in application

i have too posted this doubt there also

can u tell how to write javascript code......

where to write this code????????????

thank you