how to insert function value in coloumn

Amit Kumar

i have created an sql function in database name datainfo and table name as book.

create function[dbo].[book_id](@id int)
return char(12)
as
begin return 'bkooID'+right('00000'+convert(varchar(10),@id),5)
end

i want to insert this value in column book_id using asp.net on button click..
please write sqlcommand for this.

this is my sqlconnection code 
    SqlConnection con;
    SqlCommand cmd;
    string str = ConfigurationManager.ConnectionStrings["connect"].ConnectionString;
 protected void btnSubmit_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(str);
      

 }

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar13y ago
sir i didn't get you ..how can i do this ...
can you write your steps for doing this
0

Manikavelu Velayutham13y ago

Instead of doing like this, you can give the function name in column datatype.

so that it will be automatically inserted in to that column.

Computed Column

CREATE FUNCTION udf_compcol(@contents XML) 
 RETURNS nvarchar(255)
 WITH SCHEMABINDING 
 BEGIN
 RETURN @contents.value('(/item/description/text())[1]', 'nvarchar(255)')
 END 
Go
ALTER TABLE Books
 ADD summary_compcol AS udf_compcol(Contents) PERSISTED
Go
CREATE INDEX ix_Books_summary ON Books(summary_compcol)
Go