how to set sqlparameter list(of sqlparameter ) to a gridview??
Code:
Dim l As New List(Of System.Data.SqlClient.SqlParameter)
l.Add(New System.Data.SqlClient.SqlParameter("@name", "joy"))
l.Add(New System.Data.SqlClient.SqlParameter("@class", "neel"))
grd1.DataSource = l.ToList
grd1.DataBind()
I am trying to follow this sample of inserting data through gridview rowcommand. But somehow Im missing the sqlparameter add method whilst the namespace was already added.
Code:
//sqlparameter declaration of list type
private List<SqlParameter> insertParameters = new List<SqlParameter>();
mygridview_rowcommand(...){
SqlParameter _prm_guid = new SqlParameter("@pk_guid", SqlDbType.VarChar);
_prm_guid.Direction = ParameterDirection.Input;
_prm_guid.Value = thisguid;
insertParameters.add(?); //error on add()
}
Some other part of the code which related to insertParameters variable it give an error
Code:
for statement cannot operate on variables of type List<System.Data.SqlClient.SqlParameter> because List<System.Data.SqlClient.SqlParameter> does not contain a public definition of GetEnumerator
Am I missing a file reference?
I am trying to set up a GridViewUpdate, I need to find the Parameter and I am having trouble figuring it out.
How would I go about obtaining the value for "@ID" parameter in order for the user to update the required "TAUpdateDate" field?
[Code]....
I've a web page that contains a Customers DDL, and a ClassCode gridview with a Salesman DDL. So far i have manged to populate the Customers DDL as well as binding data to the ClassCode gridview/ Salesman DDL. My next step is depending on which customer is selected(code event below), query the DB to get all relevant ClassCodes/Salesmen and update the gridview and any instances where the classcode doesn't exist for the customer the Salesman DDL will have a default value. Here's my code so far:
Code:
protected void ddlCustomers_SelectedIndexChanged(object sender, EventArgs e)
{
BindData();
DataTable dt = new DataTable();
try
[Code] .....
How to get the ClassCode for that row by getting DataKeys of the GridView, using the RowIndex of the Row. See if you have a SalesMan for the ClassCode. If you do, use FindControl to find the DropDownList in the Row, and set its SelectedValue.
I am an ASP beginner, I have a stored precodure which accepts two input parameters. In my ASP project, I have a button click event
protected void OnAddClick(object sender, EventArgs e)
{
string concept = txtConcept.Text;
string keyword = txtKeyword.Text;
.......
int result = Helper.ConceptInsert(concept,keyword);
}
In my Helper.cs, I have a method as
public static int ConceptInsert(string description, string keyword)
{
int result = -1;
string connString = ConfigurationManager.ConnectionStrings["MySpaceConnectionString"].ConnectionString;
string commString = "exec dbo.Concept_Insert @description";
using (SqlConnection conn = new SqlConnection(connString))
{
using (SqlCommand comm = new SqlCommand(commString, conn))
{
comm.Parameters.Add(new SqlParameter("@description", description));
comm.Parameters.Add(new SqlParameter("@keyword", keyword));
conn.Open();
result = comm.ExecuteNonQuery();
}
}
return result;
}
But when I run the code, error message is always Procedure or function 'Concept_Insert' expects parameter '@keyword', which was not supplied. How can I pass those two parameters together to the stored procedure?
I have a <asp:Parameter Name="Person_ID" Type="String" />. My Updatecommand contains, among other things: Person_ID = @Person_ID. That's all fine.
In my code behind, how to I say that I don't want to specify a value for this parameter, but rather want it to use the default value (which in this case is NULL?)
Or rather than telling it to use the Default value, is it possible to set it to Null? I tried setting the value to Null, but the sql code that got generated was Person_ID = "NULL", which of course, is wrong. How do I get it to generate Person_ID=NULL?
If Request.QueryString("departmentId").ToString() = "0" Then
SqlDataSource1.SelectParameters.Add("departmentId", TypeCode.Int32, 0.ToString())
I want to add a null value instead of 0.string() for the sqlparameter departmentId how do I do this?
I have been getting this error for a long time now.
SqlParameter outparm2 = new SqlParameter("@OrderID", SqlDbType.Int);
outparm2.Direction = ParameterDirection.Output;
while (count < GridView1.Rows.Count)
{
cmd = new SqlCommand("Insert_Orders", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(outparm2);
[code].....
Protected Sub FormView1_ItemUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewUpdateEventArgs) Handles FormView1.ItemUpdating
Dim IsPresCheck As CheckBox = CType(FormView1.FindControl("IsPrestigeChkBx"), CheckBox)
If IsPresCheck.Checked = "True" Then
SqlDataSource1.SelectParameters.Add("IsPrestige", System.TypeCode.Int32, 1.ToString)
Else
SqlDataSource1.SelectParameters.Add("IsPrestige", System.TypeCode.Int32, 0.ToString)
End If
but for some reason it's not seeing the parameter and returning an error
It cant be more simple. However I have tried a lot of examples and none of them have been working.
I have a very simple Excel file. I want to post these data in a gridview, Column A, B and C all placed in the Sheet1 and the file name is Book1.xls.
I am using VS2008 with asp.net 3.5 and enterprise library 4.1. I am getting the following error when I try to connect to database.
"Failed to convert parameter value from a SqlParameter to a String"
Here is my code
[code]....
I want to check if an sqlparameter exists before adding a new one so I don't get the error - @param was supplied multiple times. IS this possible?
View 7 RepliesI got variables to send as parameters to Stored Procedure,
How to send it using SqlParameter[] arrParam?
How to write those variables to the arrParam?
In the app that I'm currently working on, users can upload zip files. I want to restrict the users from uploading exe files (or any potentially virus infected type of files).
I want to list the files inside the zip they are uploading, and check for file extension, and deny the upload if a potentially unsafe file is found. I've been searching on the net, I found examples that use java (like this one), but java is not supported in Visual Studio for a while it seems...
I am using Framework 4.0
I am about to write a method that uses SQLParameter to insert some data into SQL server. However, do I "have" to specify a DBType? If not how is this handled?
Here is an example of the code I intend to write:
[Code]....
Basically, I have a gridview table with a dropdownlist column and I need a way to retrieve the selected item from it. Now I'm using an imagebutton in order to get the selected item from the dropdownlist to pop-up as a message box (as a string). I already know how to get text from a boundfield. However, using the same code to get the dropdown list item won't work. This is a snippet from my code:
ASP code:
Select...
8:00
9:00
10:00
11:00
12:00
1:00
2:00
3:00
4:00
Visual Basic code:
<asp:BoundField DataField="Case#" HeaderText="Case#" ReadOnly="True" />
<asp:TemplateField HeaderText="Surgery Time">
<ItemTemplate>
<asp:DropDownList ID="Time_Slot" runat ="server">
<asp:ListItem Selected="True" Value="0">Select...</asp:ListItem>
<asp:ListItem Value="1">8:00</asp:ListItem>
[CODE]....
I am trying to display a profile page on my website using the SQL Datasource_Selecting and when the page loads I get this error "An SqlParameter with ParameterName '@UserName' is not contained by this SqlParameterCollection."
The code is:
[Code]....
and the sql code is:
[Code]....
I am trying to set the item that is selected from a drop down list based on what it in the database for that particular record. I am filling the dropdown list with a SQL DataSource I have tried a couple of example that I have found for selecting the item in the list but I am always getting the first item in the list as the selected item. This is what I am currently working with:
Code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
Else
Dim ID = New Guid(Request.QueryString("ID"))
[code].....
Nothing I find on the Internet is working.This is the closest I've gotten. It produces an output file without exceptioning but the output file has blank lines. But it's the correct number of blank lines.
Code:
public void WriteCSV<T>(IEnumerable<T> items, string path)
{
Type itemType = typeof(T);
var props = itemType.GetProperties(BindingFlags.Public | BindingFlags.Instance)
.OrderBy(p => p.Name);
[code]...
Creating a list of users with a "Delete" linkbutton next to each". Seems I got it all wrong (again..away from webforms a long time).
Here's what I do:
Building a list of users with delete buttons:
Code:
foreach (var user in users)
{
var usr = user as UserInfo;
var row = new TableRow();
var cell = new TableCell();
[Code] ....
The "Delete""event handler:
Code:
protected void btnRemoveModUser_Click(object sender, EventArgs e)
{
var button = sender as LinkButton;
var userController = new UserController();
var user = userController.GetUser(PortalId, int.Parse(button.CommandArgument));
RemoveUserFromRole(Enums.KnowledgebaseRole.KB_Moderators, user);
}
I got a hunch though it's because of the when/where I'm loading that list of users. I call the function (getting a list of all users, clearing the table and populate it again):
In the page load, if not a postback.
Every time the "Add user" function have been called (that works fine).
Every time the "Delete user" function are called.
The last will not delete the user (still in database) but reload the ^&* form without any users.
I just found that the delete handler does not get called at all, but the button post back the form, so my list of user's don't get loaded.
Is there a way to drag and drop the item in a listbox to reorder the sequence?
View 8 RepliesI have a Google spreadsheet that I am reading data from and I want to load the data into a list object so I can use but I am having some issues.
Google Spreadsheet
-Worksheet name: Charts
-Tab: Color_Summarized
-Column 1: ColorSummary
-Column 2: ChildID
-Column 3: ParentID
sample rows:
Aqua|29|28
Blue|49|23
Yellow|55|28
My results are
Yellow Color_Summarized FH 55 28
How do I need to set it up so it keeps all the data loaded instead of just the last instance? Is there a better way then putting in class?
My code:
Code:
Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Collections.Generic
Imports Google.GData.Spreadsheets
[code]....
This query related to SharePoint Designer / XSLT List Form Webpart Customization in SharePoint designer 2010
I am using SharePoint designer 2010 to design my page.
I am trying to add list and customize it.
Following is customization task.
in my list I have two columns Title and Short Description . when I add list on my test page it show one by one following manner.
[code]
Problem is I want show it following manner .
[code]
How I Customize it ? I tried almost options from ribbon but didn't success.
I'm not able to find the task list widow both in Visual Web Developer 2010 Beta 2 and Visual C# Express 2010 Beta 2. In Express 2008 versions there was the menu "View -> Task list " that i can't find anymore in 2010 versions.
View 5 RepliesI have a class with all different kinds of data members, including a list of strings. When I bind the data to a GridView, I want to be able to separate out the list of strings into different columns in the GridView. These strings are more like flags, there is a max of 3 flags. The list could be empty, if no flags apply, or it could contain only one or two flags. How can I separate out these flags into different GridView columns? Do I need to do it in the OnRowDataBound event?
Current, my aspx code looks something like this. I want to be able to change the ImageUrl of the Image controls based on if the flag is raised or not.
<asp:TemplateField HeaderText="Tax" SortExpression="Tax"> [code]....