Visual Basic

Re: Dynamically adding image to a datagrid column

29-Aug-05 20:59

Hi,

I have a datagrid that is databound. One of the fields is a 'date' field(which comes from database). What I need to do is that if the date is current data , i.e. today's date then I need to display an animated image of 'New' sign next to it and it is anything other than today(which is ofcourse past date Smile | :)

) then I need to display animated 'Old' sign image.

I have the images saved in the same directory as the application. I have also created a template column for the Image and a Itemdatabound sub but I do not know th exact method or syantax to include an image file in the Itemdatabound Event.

Any help anyone please?

thanks a ton!

Aartee.
...HE is watching Us All!

BORN...again!30-Aug-05 17:02

access to another forms objects

30-Aug-05 17:02

Eureka!!! I got it...

Aartee.
...HE is watching Us All!

hakanaktan29-Aug-05 20:30

hakanaktan

29-Aug-05 20:30

Hi,
I have two windows forms.User opens the first form(form1) and clicks "open" button then a new form opens(form2).
He makes a choice in form2 .I need to add some string to listBox that is on form1 when user clicks button on the form2. Both forms are open at this time.
If i use

"Dim myForm As New Form1"

it makes the change i need but it creates a new form1.
would someone send some syntax for that?
Thanx in advance..

--junior coder--

prathiba_naresh29-Aug-05 22:50

prathiba_naresh

29-Aug-05 22:50

You can pass the form1 as reference to form2 and when the user clicks button on form2 set the string in form1's reference.

That is, When displaying form2 from form1 you would say,

Dim form2 as new form2(form1)

In the Form2's constructor(Public Sub New)

say Public Sum New(byref Form1 as form1)

Hope this helps.

hakanaktan29-Aug-05 23:19

hakanaktan

29-Aug-05 23:19

Here is form1 code:

Public myform2 As New form2

I defined form2 as global variable

Here is form2 code when you hit a button:

Dim f1 As New Form1<br />
        f1.Show()<br />
        f1 = Me.Owner<br />
<br />
        f1.textBox1.Text="something else"

But it does not work Confused | :confused:

here is error message:
An unhandled exception of type 'System.NullReferenceException' occurred in TestForms.exe

Additional information: Object reference not set to an instance of an object.

--junior coder--

prathiba_naresh30-Aug-05 0:05

prathiba_naresh

30-Aug-05 0:05

I assume you have a button in form1 to invoke form2.

So put this code in button_click event of the form1 where you call the form2.

Form1 Code
----------
Dim myform2 As New Form2(Me)
myform2.ShowDialog()

In form2

Declare a Variable

Dim prevform As Form1

If you click on the + sign near the Windows Form Designer generated code,You will see the Public Sub New. it should look like this.

Public Sub New(ByRef form1 As Form1)
MyBase.New()

'This call is required by the Windows Form Designer.
InitializeComponent()

prevform = form1

'Add any initialization after the InitializeComponent() call

End Sub

In the Form2 button_click (where you want to call form1, paste this code.

prevform.TextBox1.Text = "something else"
Me.Hide()

This should work fine.

Adding items to DataGrid in runtime

hakanaktan30-Aug-05 4:06

hakanaktan

30-Aug-05 4:06

thanx it works fine.. Big Grin | :-D

--junior coder--

Member 223436029-Aug-05 20:22

Member 2234360

29-Aug-05 20:22

I have one datagrid for fetch and display the values from the table.
I need to adding items to datagrid at runtime using vb.net.
I want the code.

my code is

Dim con As SqlClient.SqlConnection
Dim Cmd As SqlClient.SqlCommand
Dim da As SqlDataAdapter
Dim ds As New DataSet

Dim constring As String = "data source=ccs10; initial catalog=gcis;user id=jpa;password=jpa"
Private Sub Btn_Raise_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_Raise.Click
Dim CoMm As String
con = New SqlClient.SqlConnection(constring)
cmd=new sqlclient.sqlcommend("Select * from Paperrfq")
da = New SqlClient.SqlDataAdapter(cmd)
da.Fill(ds, "paperrfq")
DataGrid1.DataSource = ds.DefaultViewManager

aruljothi

BORN...again!29-Aug-05 21:01

29-Aug-05 21:01

Can you please be more specific on the nature of your problem? Please tell more about your data fields that you need to display. I am saying this because I do this all the time and maybe I can help you.

Aartee.
...HE is watching Us All!

-- modified at 3:02 Tuesday 30th August, 2005

Member 223436029-Aug-05 23:16

Member 2234360

29-Aug-05 23:16

hello mam,
Thanks for ur reply.i am a beginner in dotnet.i wud like to know about the data grid functionality.my requirement is i should be able to view the data in the datagrid from the database as well i want to enter new data in the same data grid to update my database.is this possible in vbdotnet and pls help me in getting things right.
I have more datafields in a table and display that in a datagrid.
Datafields are Empno as integer,empname as string

thank u

aruljothi

BORN...again!30-Aug-05 17:01

30-Aug-05 17:01

Hi ArulJothi,

---my requirement is i should be able to view the data in the datagrid from the database as well i want to enter new data in the same data grid to update my database.is this possible in vbdotnet ---

Yes it is possible to view the data as well as to update it. There are a couple of ways to do it,
1.In your SQL statement write a select stt to display the fields you need in the datagrid, do the rest of databse-connectivity,bindgrid() etc..coding. In your datagrid include a 'Hyperlink' column for 'change/Update Form' and redirect the link to your actual form by providing a 'URL' in the url field of the Property Builder i.e. Propertybuilder-->columns-->hyperlink column-->
HeaderText:Change/Update-->text:Update-->URLField:[your primary key of the form/table]eg:formNo-->URLFormat string:[your original form name not the datagrid one]eg: formname.aspx?formno={0}

this way your datagrid will bring you straight back to the form, you can make changes and save and the changes will be reflected in the datagrid.

2. Add the 'Edit,Update,Cancel' button and write the sub say, updatetable for update and edittabel for edit on the datagrid code behind page, include OnUpdatecommand="updatetable" and Oneditcommand="edittable" in the HTML page. so this will edit the columns and you can make changes to the fields you included in your datagrid(not form) and update it.

I hope this helps .let me know if you need more clarifications on any of the above.

good luck.

Aartee.
...HE is watching Us All!