|
hello every one i am trying to make a method which takes vaolues of controls and insert those into database.
I am giving the code.
The error message is ==" memory allocation "
==============code of Function is====================================
string cmdtext = "CALL INSERT_PROCEDURE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
cmd = new OdbcCommand(cmdtext, con);
OdbcParameter p2 = new OdbcParameter("_section", OdbcType.VarChar,50);
p2.Value = @section ;
OdbcParameter p3 = new OdbcParameter("_Broad_Cat", OdbcType.VarChar,50);
p3.Value = @Broad_Cat;
OdbcParameter p4 = new OdbcParameter("_Cat", OdbcType.VarChar,50);
p4.Value = @Cat;
OdbcParameter p5 = new OdbcParameter("_Attribute1", OdbcType.VarChar,50);
p5.Value = @Attribute1;
OdbcParameter p6 = new OdbcParameter("_Attribute2", OdbcType.VarChar,50);
p6.Value = @Attribute2;
OdbcParameter p7 = new OdbcParameter("_Attribute3", OdbcType.VarChar,50);
p7.Value = @Attribute3;
OdbcParameter p8 = new OdbcParameter("_Attribute4", OdbcType.VarChar,50);
p8.Value = @Attribute4;
OdbcParameter p9 = new OdbcParameter("_Attribute5", OdbcType.VarChar,50);
p9.Value = @Attribute5;
OdbcParameter p10 = new OdbcParameter("_Loaction", OdbcType.VarChar,50);
p10.Value = @Location ;
OdbcParameter p11 = new OdbcParameter("_pincode", OdbcType.VarChar,50);
p11.Value = @Pincode;
OdbcParameter p12 = new OdbcParameter("_Locality", OdbcType.VarChar,50);
p12.Value = @Locality ;
OdbcParameter p13 = new OdbcParameter("_Description", OdbcType.VarChar,50);
p13.Value = @Description;
OdbcParameter p14 = new OdbcParameter("_Image", OdbcType.VarChar,50 );
p14.Value = @Image;
OdbcParameter p15 = new OdbcParameter("_Total_Char", OdbcType.VarChar,50);
p15.Value = @Total_Char ;
OdbcParameter p16 = new OdbcParameter("_Extra_Cha", OdbcType.VarChar,50);
p16.Value = @Extra_Char ;
OdbcParameter p17 = new OdbcParameter("_WebPage_Link", OdbcType.VarChar,50);
p17.Value = @Web_Link ;
OdbcParameter p18 = new OdbcParameter("_Email_id", OdbcType.VarChar,50);
p18.Value = @Email_Id;
OdbcParameter p19 = new OdbcParameter("_Total_Cost", OdbcType.VarChar,50);
p19.Value = @Total_Cost;
OdbcParameter p20 = new OdbcParameter("_Duration", OdbcType.VarChar,50);
p20.Value = @Duration;
OdbcParameter p21 = new OdbcParameter("_Status", OdbcType.VarChar,50);
p21.Value = @Status;
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Parameters.Add(p5);
cmd.Parameters.Add(p6);
cmd.Parameters.Add(p7);
cmd.Parameters.Add(p8);
cmd.Parameters.Add(p9);
cmd.Parameters.Add(p10);
cmd.Parameters.Add(p11);
cmd.Parameters.Add(p12);
cmd.Parameters.Add(p13);
cmd.Parameters.Add(p14);
cmd.Parameters.Add(p15);
cmd.Parameters.Add(p16);
cmd.Parameters.Add(p17);
cmd.Parameters.Add(p18);
cmd.Parameters.Add(p19);
cmd.Parameters.Add(p20);
cmd.Parameters.Add(p21);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
con.Close();
======================function is getting call here==============
CodeClass.insert_values(con, cmd, ddlSection.SelectedItem.Text, "employee", null, null, ddlJobType.SelectedItem.Text, ddlIndustry.SelectedItem .Text, null, null, ddlLocation2.SelectedItem.Text, ddlPincode2.SelectedItem.Text, ddlLocality2.SelectedItem .Text, txtDescription.Text, null, txtCalculator.Text, txtExtra.Text, txtweblink.Text, txtEmailId.Text, txtTotalCost.Text, ddlDuration.SelectedItem.Text, "Tempraroy");
|
|
|
|
|
|
This is really, really nasty.
The issue as far as I can see is that you have 21 ? and you're only adding 20 parameters. I'd suggest cleaning this code up.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i have a gridview using edittemplate i put it in a panel and use scroll bars. It doesnot work my gridview is hide when i put it in gridview, i also bring it in front but still hide.
help plz
|
|
|
|
|
Put your gridview inside div and set the overflow property of the div, also set height and width properties of the div.
HTH
|
|
|
|
|
how i set overflow property in div?
|
|
|
|
|
You need to use
overflow:scroll to the container that holds the grid. 
|
|
|
|
|
|
Hi ,
We are facing a problem when I want bind dropdown list in footer row
code is..
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
ds = new DataSet();
ds.Reset();
ad = new SqlDataAdapter("select * from States", con.cn);
ad.Fill(ds, "tmp");
**DropDownList drp=(DropDownList)GridView1.FooterRow.FindControl("DropDownList1");//** In this line We are getting error object reference is no set an instance
drp.DataSource = ds.Tables["tmp"];
drp.DataValueField = "stateid";
drp.DataTextField = "statename";
drp.DataBind();
}
}
|
|
|
|
|
samar123 wrote: **DropDownList drp=(DropDownList)GridView1.FooterRow.FindControl("DropDownList1");//** In this line We are getting error object reference is no set an instance
Have you considered using real variable names, or are you trying to make your code hard to read ? What does your aspx look like ? I would recommend before you ever consider charging anyone for your code, that you learn how to write professional code as it pertains to database access. I'd fire anyone who wrote SQL in the presentation layer. What insanity is it that you want to rebind this control once for every row in your grid ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Dear , it may be some problem in my code , I am beginer in devlopment just try to understand my problem.I want to bind drop downlist in in footer row of gridview thanks for reply........
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
DropDownList drp=(DropDownList)GridView1.FooterRow.FindControl("DropDownList1");//error in this line
drp.DataSource = ds.Tables["tmp"];
drp.DataValueField = "stateid";
drp.DataTextField = "statename";
drp.DataBind();
}
|
|
|
|
|
If you're a beginner, I assume no-one is paying for this code. It's sure not worth any money. So, instead of trying to solve this problem ( and this code is FULL of problems ), why not start slower and work through a book. You won't have to worry about sticking to a specific problem and solving it, until your code is at a professional standard, and someone is paying for it.
There is so much wrong with this code, I wouldn't know where to start.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Dear ,instead of telling my answer you are focusing my question pattern. you should first tell me my answer and realize me what was wrong in my code.I am newly appointed in a company so may be there was many mistakes.
Dear Sir, ignore mistakes and just send me code in which we know my mistakes. my porblem is still same how to to bind a dropdownlist in gridview footer row......
|
|
|
|
|
where is
if(e.Row.RowType == DataControlRowType.DataRow)
{
ds = new DataSet();
ad = new SqlDataAdapter("select * from States", con.cn);
ad.Fill(ds, "tmp");
DropDownList drp=(DropDownList)GridView1.FooterRow.FindControl("DropDownList1");
drp.DataSource = ds.Tables["tmp"];
drp.DataValueField = "stateid";
drp.DataTextField = "statename";
drp.DataBind();
}
Check it ... ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
DropDownList drp=(DropDownList)GridView1.FooterRow.FindControl("DropDownList1");//error in this line
drp.DataSource = ds.Tables["tmp"];
drp.DataValueField = "stateid";
drp.DataTextField = "statename";
drp.DataBind();
}
|
|
|
|
|
Yes.. If your footer contains the control, find only in the footer...
where is if condition before running FindControl. 
|
|
|
|
|
Thanks Dear.........
|
|
|
|
|
Try ! This...
DropDownList ddlResultsFooter = (DropDownList)e.Row.FindControl("ddlResultsFooter");
if(ddlResultsFooter != null)
{
//Bind you drop down here
}
- Happy Coding...
STG, Miami
|
|
|
|
|
Try ! This...
DropDownList ddlResultsFooter = (DropDownList)e.Row.FindControl("ddlResultsFooter");
if(ddlResultsFooter != null)
{
//Bind your drop down here
}
- Happy Coding...http://s.codeproject.com/script/Forums/Images/smiley_smile.gif
STG, Miami
|
|
|
|
|
I have a gridview control, which contains multiple rows. Each row has a link-button and a detailsview control. Using the link-button, i want to show or hide the detailsview control.
Initially all the details view have their css property Display=None set. If the link button in any of the grid-view row is clicked, i want a java-script to make the details -view in that row visible (Display=Block)
So i wrote the following javascript:
<script language="javascript" type="text/javascript">
function ShowReplyBox(PMBox) {
myElement = document.getElementById(PMBox);
if (!myElement)
alert('element not found');
myElement.style.display = "block";
}
function HideReplyBox(PMBox) {
myElement = document.getElementById(PMBox)
if (!myElement)
alert('element not found');
myElement.style.display = "none";
}
</script>
While showing the details-view control, it shows momentarily, and again become invisible automatically ...
What could be the problem ...
Apurv
“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)
“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)
|
|
|
|
|
The script looks fine. I assume your code is calling the show and then the hide script right away.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
do i need to add the return; statement at the end ... ?
Apurv
“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)
“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)
|
|
|
|
|
Depends where you mean. I'm yet to see what code calls these methods, returning a true or false from these methods may stop the other events from triggering, but I can't say, because you've not posted the code that is relevant. your code has no bugs that I can see, it's just being called in ways you don't expect.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Replace your code with this ...
function ShowReplyBox(PMBox) {
var myElement = document.getElementById(PMBox);
if (!myElement){
alert('element not found');
return;
}
if(myElement.style.display != "block")
myElement.style.display = "block";
}
function HideReplyBox(PMBox) {
var myElement = document.getElementById(PMBox);
if (!myElement){
alert('element not found');
return;
}
if(myElement.style.display != "none")
myElement.style.display = "none";
}
|
|
|
|
|
Would setting the display to block if it already is, cause it to disappear ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
