infopath changes workflow status column

Dear All,

I cannot add a new column in existing table.

I have a two tables ['ev_event_how' & 'ev_events_event_how'] has relationship between these table.

Ex:
Table: 'ev_event_how'

UID - Event[PK]

Ex:
Table: 'ev_events_event_how'

UID - Event[FK] - Desc

I want to add a one more column[IsDelete] in both table. But Sql server is not allowing to add the new column, Showing various errors like

1.cannot add a new column-Unable to modify table.Invalid object name 'MSED_Logs.DatabaseLog'

2.TITLE: Microsoft SQL Server Management Studio
------------------------------

User canceled out of save dialog
 (MS Visual Database Tools)

How can I make it add a new column in existing table?

i have created university timetable.

how to display data.??

days show in row wise and period showin column wise

aur every period have particular course..

gridview..detalview or any thing..??

plz reply urgent....

give complete steps

I am attempting to bind data from a dropdown list that was populated from another datasourceID. I've bolded what I believe is relevant to this issue in the code below. But basicly its binding the proper county on the pull down menu but when I hit form submit it dosnt postback that info instead its null.

<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1"
            style="margin-right: 59px"
           CellPadding="4"
            ForeColor="#333333" DefaultMode="Edit" DataKeyNames="UID">
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <EditItemTemplate>
                Edit Item Template<br /><asp:Label ID="uidlabel" runat="server" Text='<%# Bind("uid") %>' /><br />
                last_date ha:
                <asp:TextBox ID="last_dateTextBox" runat="server"
                    Text='<%# Bind("last_date", "{0:d}") %>' AutoPostBack="True"
                    CausesValidation="True" />
                <br />
                first_name:
                <asp:TextBox ID="first_nameTextBox" runat="server"
                Text='<%# Bind("first_name") %>'
                    CausesValidation="True" ontextchanged="first_nameTextBox_TextChanged1" />
                <br />
                last_name:
                <asp:TextBox ID="last_nameTextBox" runat="server"
                    Text='<%# Bind("last_name") %>'
                    AutoPostBack="True"
                    CausesValidation="True" />
                <br />
                mi:
                <asp:TextBox ID="miTextBox" runat="server" Text='<%# Bind("mi") %>'
                    AutoPostBack="True" CausesValidation="True" MaxLength="1" />
                <br />
                home_phone:
                <asp:TextBox ID="home_phoneTextBox" runat="server"
                    Text='<%# Bind("home_phone") %>' MaxLength="9&

 Hi,

I HAVE A DETAILSVIEW WITH A DROPDOWNLIST.

I WOULD LIKE TO BE ABLE TO SELECT A VALUE FROM THIS DROPDOWNLIST AND DEPENDING ON THE SELECTEDVALUE DISPLAY A SPECIFIC CONTROL/HEADER IN ANOTHER COLUMN.

HOW CAN THIS BE ACHEIVED?

Is there a way to format a column with an image?  

i have a dataset and a table into named Students. Students(StudentName, age)

i wanna name colunm to string array. but not use loops (for foreach..). is there any way?

string[] array = this.dataSetZLC.Student.StudentNameColumn...........

 Can someone help me on how to return DataRow's column name? Like:

Dim row as DataRow  = dt.Table(0).Row(0)

MsgBox "Column: " & ColumnName & " Value: " & row("ColumnName")

Where ColumnName is the table's column in the database.

Thanks in advance!

jun2
 

Hi all,

I am having a hard time inserting a null date into a SQL table.  Please be aware that I am using the Microsoft Application Data Blocks and not pure ADO.net.  I find a million examples of how to do this with ADO.net but cannot find anything about this using the MS Data Application Blocks.

Here is my VB.net code:

Save(Session("ref_no"),  txtdischarge_date.Text) 

Sub Save(ByVal ref_no As Integer, discharge_date As Date)

        SqlHelper.ExecuteNonQuery(connString, ref_no, discharge_date), "MyTableInsert")

End Sub

The textbox txtdischarge_date can either be a valid date or blank.  If it contains a valid date then the insert works properly.  But if the textbox  is blank, then I want to insert a null value into my date column.  I cannot get this to work.  I get this error when I run this and txtdischarge_date is blank:

Conversion from string "" to type 'Date' is not valid

Here is the code for my stored procedure, MyTableInsert:

ALTER Procedure MyTableInsert
   (@ref_no int,
    @discharge_date datetime = NULL)

AS
SET NOCOUNT ON
INSERT into MyTable VALUES
   (@ref_no,
    @discharge_date)

Again, I am using the MS data application data blocks.

Thanks,

Bob

Hey, guys! I'm building a web site for a Section 508 workgroup, and I need the site to be 100% accessible (including the administration module I'm making for the team. We're using SharePoint MOSS 2007 and I recommended using infopath to enter data into the site's database (and also to populate downloadable Microsoft Word documents). The customer claimed that InfoPath is not Section 508 compliant, which seemed odd to me because the forms can be modified to anything you want them to be (including 508 compliant).

I even found this guide to making InfoPath accessible:

http://office.microsoft.com/en-us/infopath/HA102146831033.aspx

I'm curious if there are any caveats to making accessible forms in Infopath, or if the information I've gathered is incorrect.

Thanks!

Spaz

Has anyone successfully implemented item-level security in a SharePoint list using column values as the decision criteria? I realize this isn't out of the box functionality and would need to be custom coded.

For example, let's say that we have one document library that stores all of the HR documents about every employee in the company. One of the columns in the properties of the document stores which Office that employee reports to. There are HR staff that support each Office and should only have access to the files of employees who report to the same office that they do.

I know an option would be to create separate library or folder structures for each Office, but I'm curious if anyone has attempted to secure items or documents using properties instead.

Thanks.