当数据源是lable和textbox字段时，如何在表中存储数据 [英] how can store data in table when data source is lable and textbox field

问题描述

大家好

以下是我的商店程序我想创建表格并在表格中插入lable的价值

所以请告诉我这是对的吗？ br />

Hi All
below is my store procedure i want to create table and insert the value from lable in the table
so pls let me know is this right?

CREATE TABLE #tbl_tablenames(
    [tableID]        int IDENTITY(1,1) NOT NULL,	 
    [Scriptid]        [INTEGER]    NULL,
    [ClientTblname]             [varchar](30)       NOT NULL,       
    [IntellectTblname]             [varchar](30)             NOT NULL,       
)
go

CREATE PROCEDURE [dbo].[sp_importStats]
	-- Add the parameters for the stored procedure here
	@lblMySqlTableNameClient.text,
	@lblSqlTableName.text,
	
AS
BEGIN
	
SET NOCOUNT ON;
 INSERT INTO [#tbl_tablenames] ([ClientTblname])([IntellectTblname]) 
 VALUES (@lblMySqlTableNameClient.text,@lblSqlTableName.text,)
END
GO

推荐答案

我做过这和问题解决了

i have done this and problem was solved

use tempdb
go
drop table #TableNamesStore

go
CREATE TABLE #TableNamesStore(
    [tableID]        int IDENTITY(1,1) NOT NULL,	 
    [Scriptid]        [INTEGER]    NULL,
    [ClientTblname]             [varchar](30)       NOT NULL,       
    [IntellectTblname]             [varchar](30)             NOT NULL,       
)
go

CREATE PROCEDURE storetablename
(
	-- Add the parameters for the stored procedure here
	@ClientTblname varchar(30) ,
	@IntellectTblname varchar(30)
)	
AS
BEGIN
	
SET NOCOUNT ON;
 INSERT INTO [#tbl_TableNamesStore] (ClientTblname,IntellectTblname) 
 VALUES (@ClientTblname,@IntellectTblname)
END
GO

这篇关于当数据源是lable和textbox字段时，如何在表中存储数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！