Comments by dimpledevani (Top 112 by date)

It depends on your requirements.You can use while loop or try indexing your tables

You can store the install date somewhere in your application's registry or in database and then compare that date every time you lunch your application.If it crosses more than 30 days, then you can get your requirement done.

my 5+

use <> in sql for checking 'not equal to'

you can use the grouping fields to group according name and date .So it wont repeat date

My 5+

Have Column as InsertDate in your table where you are inserting rows

Can you post your code and explain in detail what you performed??

Try the RowDataBound event of SPGridView

Use loop and remove the duplicates

Client needs a proper .net framework to run any application.So installl the missing files/setup for crystal report

You can clear the values as soon as your insert query fires or disabl the button once its clicked.Debug your code and find out

insert cannot be used with where

You can use the key pressed event and find out the ascii value of the character typed and replace it by its corresponding ascii code in capita

Can you Please explain in detail?? What you want and what have you tried??

try changing the datasource to null and then add new values '--SELECT--' ,etc as new datasource

Please explain in detail

well i guess in that case you need to add the code again to those records and then merge them

The code which you have posted in that only in the pageload function write call a proc to retriev the details (select cmd) and show it in a control like gridview

Please explain your query in detail and what is the above code for??

well sorry but as far as i understood the question i thought he needed to reset the value so i gave this solution

you can scan the image and convert it to binary form and save it in your database, n can convert it back to img form while retrieving

Quote.FullAmt can be null,Check that too

try Debugging your code and you will get it

Thats because you are over riding the Parameter field value.For each parameter you should have different ParameterField fields.e.g
pField1.ParameterFieldName = "FromDate"
disVal.Value = frmReport.DTPFrom.Value
pField1.CurrentValues.Add(disVal)
pFields.Add(pField1)

pField2.ParameterFieldName = "FromDate"
disVal.Value = frmReport.DTPFrom.Value
pField2.CurrentValues.Add(disVal)
pFields.Add(pField2)

where have you written this code?? I mean the event??

when you are deleting a row the total number of rows in your datatable also changes so the error is valid as you are in a loop.Try to make a copy of your datatable and in for loop for assigning the max value use one table and delete rows in other table

if you are using web, then you need to use gridview.DataBind() after assigning the DataSource, and by the way why are you using command.ExecuteNonquery()??
You need adapter.selectCommand=command

well you have an option for converting your report in various format, as you know that export option is available for crystal report, so just export it through code and then show it

well i guess your database is having some problem, try opening the database and fire some queries in it, if it works properly then check your code for connectivity

I meant that install the framework having crystal report.
Fo reg: when you install visual studio you get an option to install other features including crystal reports.See that you have installed it

Use summaryFields of Crystal Report

Your Error itself says the solution. Install the required .net framework.

Use google and search for crystal reports.I am sure you will get it

The is a Math class having all the basic mathematical expressions.Search in it

Write a function that returns you the desired text and call the function on the textchanged event or key pressed event to load it in listbox.On mouseclick event of listitem ,copy the text to your textbox

In your report viewer there is an option to enable database logon, just disable it and try

Can you please explain in detail??

It means that your datatable does not have any column named 'Image' ,Check you column names

As far as i know TextChanged Event fires only when you press enter or tab key from keyboard.So after you select an item from history of textbox, try pressing enter and see if fires the event.

If you are using datatable as a datasource to your gridview then use the dataview's sort method and try it

You can directly call the method the way you call it from Class A. e.g : objClassB.MethodA();

In which event are you working??

Thank you very much for replying,But I found the issue and solved it myself.

code:



Protected Overrides Sub CreateChildControls()
Try



Controls.Clear()

lblConfirmation = New Label With
{
.ID = "lblConfirmation",
.EnableViewState = True
}

lblReason = New Label With
{
.ID = "lblreason",
.Text = "Reason"
}

'txtReason = New InputFormTextBox With 'commented for local testing and wrote the below line

txtReason = New TextBox With
{
.ID = "txtReason",
.TextMode = TextBoxMode.MultiLine,
.EnableViewState = False,
.Width = Unit.Percentage(100),
.Height = Unit.Pixel(60),
.Wrap = True
}
end sub


I am creating textboxes in createchildcontrols event and have one button on click event of which I am writing

sReason=txtReason.Text 'sreason is a class variable

txtReason.Text=""


While debugging I can see the value as "" in watch window but in design it still there

It is not necessary, every company or firm have their own way of storing such data

combobox.items.remove(), search about this and you will find it

try to google it, you will get your answer

On selectionChangeCommitted event of first combobox,check if its a,b or c.According to it keep the required elements and remove the unrequired of second combobox

You hav not used isposback method so, your dropdownlist is reloding and bydefalut first item is selected

Reload your dropdownlist on page load

Its ok, Good you found out

on the double click event for your listbox, open a textbox and on the keypress event of textbox for enter key save it in listbox and hide the textbox

It contained the name of user and not its UserID??

Wierd problem.Try assigning those images through code .

Have you debugged on the line objvo.UserId = Convert.ToInt32(UserListBox.SelectedValue.ToString());
and saw if the UserListBox.SelectedValue contains anything

what is data's datatype of your listbox??

msy be your textbox is readonly or disabled

can you explain in detail??

what does the method binddata() do??

datetime

If you are working on web then use FileUpload Control or you must use FileDialog box control to select and specify your required file

If you remove your orderId column it will work fine i guess.And if you remove it dont forget to remove the order by clause

please help me friends

what help do you want??

what problem exactly are you facing??

use the checkedchange event of checkbox

Try using session to store your username and use it on our second form

Create a normal event, in your loop when you are decrementing the value of 'i' , then you can check if its 30 and if yes , you can call the event like you call methods from there

So what is the problem??

I didnt understood anything, Please frame your question properly.

I am sorry if i am wrong but what i understood now is that you want only one item's color to be changed instead of every item you select, so i guess every time when you select an item before changing its color , loop and search if any other item's color has changed, if yes then chage it to default color and then give color to your newly selected item.

is ther proper space in between your where clause and parenthesis following it???

For the print button i think you need to check your connectivity settings of the printer

write your code on event when you select the item from list box

well i guess you try placing your report viewer on a form without any other controls and run your program

Have you placed your viewer on a form which contains some other controls as well???

In crystal reports there is an option of making groups, so make a group of department and followed by groups of columns you want.

ya so when you switch from one form,store your required data in global variables and use it in your other form.If you are making on web then use session to store it

could you explain a little more in detail???

when you ope you first form,then in the load event you can write form2.close() and same for you other forms

have you tried using the text changed event??

On your report right click and goto the page setup and change the orientation and/or size of paper and then preview you report

change your page setup and printer settings

column name of databasefield and field in crystal report should have same name

i am sorry but i didnt get you...

Why have you used a loop?? There is a datasource property of gridview where you can directly assign your datatable

search google and you will get list of links for your help

you have both month and year, so before entering value in your database, compare them with distinct values and if it doesnt match then reset your value

on print command enter your search condition in where clause and fire the query again to get only the required data or you can use the formula fields of crystal reports also...

what do you want exactly ????

What is your exact problem??

Didnt understood your question. Doesnt work means what??

There is no such column in your select query, check your query

Am sorry but i didnt understood your question properly.You can set the checked property to false for checkbox

yes it is possible

At design time, when you preview the data, its a dummy data according to the datatype given by you, at runtime it is necessary that column names should be same as those in database..

you can have validation to check whether a row has values for required columns, if not then goto next row or if it is last row then exit your loop

put your chart on a panel

fire your query every time on button click and update you grid

well you can redirect it back to your desired page after your task complete

I am sorry but i didnt understod your query properly. But i guess after you upload your file,create a hyperlink of it and on click of this hyperlink you can write the download code

well try using cmbtype.SelectedItem.Text to match display member or cmbtype.SelectedItem.Value for value member in your code

well there is an ASCII value for each key, serach the ASCII value n on key press event match it

have you assigned a datasource to the gridview???

wEll your stored procedure whenever will be called will enter same ID and name to 2 tables n update the third 1, Do you want like this?? I mean i think you need to modify ur SP

as far as i know, Gridview is visible only if a datasource is given to it and the datasource should have some data in it