|
I have created one procedure:
CREATE PROCEDURE [dbo].[dynamic_insert](@table varchar(50),@parameter nvarchar(4000))
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @opration='insert into '+@table+'(+@testTable+) values(+ @parameter +)'
END My front end code is:
com.Parameters("@table").Value = "order1"
com.Parameters.Add("@parameter", SqlDbType.NVarChar)
com.Parameters("@parameter").Value = c2.cust_id & "," & c2.item_id & "," & c2.cust_items & "," & c2.item_name c2 is my class object.
My problem is when I assign values in parameter field, it takes as string.
So data is not inserted.
example:
c2.cust_id = 1
c2.item_id = 1
c2.cust_items = "cd"
c2.item_name = "pen"
com.Parameters("@parameter").Value ="1,1,cd,pen" It's not possible to insert string.
what i do? is there any another datatype? or another way?
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines] Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
You can't execute dynamic SQL like this. I believe you would need to call the "EXEC" function on the generated SQL. What is the actual SQL statement you want executed? Where does the @testTable parameter come from?
Why are you not just creating a single stored procedure to handle inserts into the table and simply calling that, passing the appropriate parameters as discrete values?
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines] Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
dropdown list, something not right in my code, say for i'm trying to view movies for thrus, but wed page is showing up when I click on thrusday dropdown
here my code behind
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
'Dim ds As DataTable
'ds = GridView1.DataSource
'GridView1.DataSource = ds
PopulateGrid(Convert.ToDateTime(DropDownList1.SelectedValue.ToString()))
|
|
|
|
|
First, please use the <pre> tags for code blocks (using the "code block" formatting option).
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
'Dim ds As DataTable
'ds = GridView1.DataSource
'GridView1.DataSource = ds
PopulateGrid(Convert.ToDateTime(DropDownList1.SelectedValue.ToString())) Is this the complete method? It looks like it might be missing stuff.
Anyway, what does your drop down list of values look like? Remember, VB collections/arrays start counting at 1 not 0 and from your description it sounds like you are off by one on your indexing.
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines] Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
My repeater looks like :
Cat
cat.jpg
Dog
dog.jpg //total 2 results.So repated twice
Cat
cat.jpg
Dog
dog.jpg
Code .aspx page
<asp:repeater id="Rep_First" runat="server" visible="true" onitemdatabound="Rep_First_ItemDataBound" xmlns:asp="#unknown">
<itemtemplate>
<asp:repeater id="Rep_Second" runat="server">
<itemtemplate>
<asp:literal id="litImage" runat="server" text="<%# DataBinder.Eval(Container.DataItem," name")%>"="">
<asp:image id="Img" runat="server">
Code Behind
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Repeater Rep_Sec = (Repeater)e.Item.FindControl("Rep_Second");
if (Rep_Sec != null)
{
Rep_Sec.DataSource =myresultlist;
Rep_Sec.DataBind();
}
What do I do????
|
|
|
|
|
Charmy3 wrote: Rep_Sec.DataSource =myresultlist;
How many records are there in myresultlist ?
|
|
|
|
|
2 records....
And actually when i debugged it....I saw
In ..
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
}
So what happens is...it comes in if loop 2 times....once for Item type and once for Alternating Item type..and thats where it prints twice...Thats what I think
|
|
|
|
|
I am done with Solution.Thank you all.
|
|
|
|
|
Hi guys i am facing a new probs,
I have an excel sheet, i am just uploading all those datas to my dataset...,
In that excel sheet one of the column having the values like:
16093
TNB00075
See in this i can able get this integer value data, but in my for loop i cant able to get this second value,
Whats the wrong this is my sample code:
if (DS_Trade.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < DS_Trade.Tables[0].Rows.Count; i++)
{
if (DS_Trade.Tables[0].Rows[i]["Status"].ToString().ToLower().Trim() == "active")
{
active = 1;
}
else
{
active = 0;
}
Response.Write(DS_Trade.Tables[0].Rows[i]["PAN NO"].ToString().Trim() + "\n");
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
First of all, you can do
foreach (datarow r in ds.tables[0].rows)
{
//what value does DS_Trade.Tables[0].Rows[i]["PAN NO"].ToString() return?
}
I didn't get any requirements for the signature
|
|
|
|
|
|
swetapatel3 wrote: What do I do????
What do you want ? What is your problem ? and one more thing while posting any question please use proper Formatting . Its very difficult to understand .
|
|
|
|
|
Hey I did correct the format..Abhijit Now Reply me please with the solution
|
|
|
|
|
Charmy3 wrote: Hey I did correct the format.
No you didn't. You have deleted the original message and Post it a new one again ! Looks this is your first post in this forum , I will suggest you please don't delete and cross post. Here every one present to give you solution.
For answer , let me check your new post !!
|
|
|
|
|
|
Hi, i need a solution in which i give a specific coordinates and a balloon pop up appears on that very coordinate. i need this in my imagemap server control , where i have given the option search to search a item, if that particular item is present then a pop will appear over it in image map.
“You will never be a leader unless you first learn to follow and be led.”
–Tiorio
"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford
|
|
|
|
|
|
Hi all,
I'm fairly new to web services, so please forgive me if this is common knowledge... I can't seem to find it anywhere.
I have a project requirement in a web service that I am writing, such that if a particular function fails I need to stop/shut down/disable the web service from code. I've searched this forum and the net at length but can't find any information on how this can be done. At this point I am NOT particularly concerned with elegance, just with getting the job done. Elegance is always appreciated, of course!
Thanks in advance for any help you can offer.
|
|
|
|
|
I would make a database table that contains this information. If an error occurs update the table with the error information. At the very beginning of the web service code, add code to check the database to see if the web service can continue. Not necessarily the most elegant but very easy to code and maintain.
I didn't get any requirements for the signature
|
|
|
|
|
I agree that's very simple, but in this case we need to make the web service non-responsive. There will be a pool of servers running this service, and really what I need to do is make the service inavailable to the pool, so our customers don't start getting "gee sorry, I have an error" messages, but rather just roll to the next server in the pool.
Sorry I didn't think to explain that earlier.
|
|
|
|
|
thorsman99 wrote: I agree that's very simple, but in this case we need to make the web service non-responsive. There will be a pool of servers running this service, and really what I need to do is make the service inavailable to the pool, so our customers don't start getting "gee sorry, I have an error" messages, but rather just roll to the next server in the pool.
Well then, I can't help you that. This doesn't sound like something that should be done via code.
I didn't get any requirements for the signature
|
|
|
|
|
Hi all
i have a problem with regular expression,my requrment is
start with I/i then five digit then . and then one digit
for this i have write some expression
var exp = new RegExp("^I|i\[0-9]*\\d{5}.[0-9]$");
but this expression is not wrking, can u help mee
Thanks
|
|
|
|
|
The regular expression would be:
(i|I)\d{5}\.\d
(i|I) -> either a lower case or an upper case i
\d{5} -> five sequential digits
\. -> the decimal point
\d - one digit
so the fully escaped regex on .net would be
var exp = new RegExp("(i|I)\\d{5}\\.\\d");
Note: you could also use the ignore case Regex option flag and just include the i instead of (i|I)
P.S. I would recommend use of the Regex Coach - a nifty little tool for designing and testing regular expressions: http://www.weitz.de/regex-coach/[^]
|
|
|
|
|
Ya It's wrking fine , and thanks a lot.. , i also go with the same url for regular expression , thanks .
|
|
|
|
|
hi
i need to log out when the user close the explorer by click (X)button
ahmed eldeghedy
|
|
|
|