|
If there's a FAQ, this should be on it. The answer is no. You should wrap your databind in a !IsPostback block, so it does not bind on postback, it will get the data source along with the selected index from viewstate.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I have created a custom principal class based on IPrincipal and have exteded it for additional properties and methogs such as .UserName, .UserID to return data and IsInAnyRole to accept a list of possible roles for a user. Is there a way that I can use Declarative security with this for something like...
Public Shared Sub _<br />
[PrincipalPermissionAttribute(SecurityAction.Demand, IsInAnyRole:="Role1,Role2,etc...")] _<br />
PrivateInfo()<br />
<br />
'Print secret data.<br />
Console.WriteLine(ControlChars.CrLf + "You have access to the private data!")<br />
End Sub
The isInAnyRole is not part of the PrincipalPermissionAttribute class though. Is there an easy way to write or extend it so that I can use it with extended methods from my custom principal class?
Thanks in advanvce for any help...
|
|
|
|
|
Dear friends
I am new in vb.net and i try to make a some sample for practice. I am using that code below
Dim cmddelete As New OleDbCommand("Delete from ANABILGI where ADI=@param1, AND SOYADI= @param2, AND BABAADI=@param3", baglan)
cmddelete.Parameters.Add("@param1", txtad.Text)
cmddelete.Parameters.Add("@param2", txtsoyad.Text)
cmddelete.Parameters.Add("@param3", txtbabaad.Text)
baglan.Open()
cmddelete.ExecuteNonQuery()
baglan.Close()
but if i try to run it it was an error (Name 'ExecuteNonQuery' is not declared)
-------------------------------------------------------------------------------------------------
but if i run that code with update statement it is working that code is also below
Dim cmdupdate As New OleDbCommand("Update ANABILGI SET ADI=@adi, SOYADI=@soyadi, BABAADI=@babaadi, ANAADI=@anaadi WHERE ID=@ind", baglan)
cmdupdate.Parameters.Add("@adi", txtad.Text)
cmdupdate.Parameters.Add("@soyadi", txtsoyad.Text)
cmdupdate.Parameters.Add("@soyadi", txtbabaad.Text)
cmdupdate.Parameters.Add("@soyadi", txtanaad.Text)
cmdupdate.Parameters.Add("@ind", DataGrid1.CurrentRowIndex + 1)
baglan.Open()
cmdupdate.ExecuteNonQuery()
baglan.Close()
Getalldataindatagrid()
DataGrid1.Refresh()
End Sub
--------------------------------------------------------------------------------------------------
Thank you for your valuable helps
|
|
|
|
|
The DELETE query should not have any commas.
|
|
|
|
|
Thank you for your help;
I was corrected it by the same way which an other friend help to me about this.But also thank you for your kindly interest..
|
|
|
|
|
can anyone of u tell me how can i get the remote Computer system informtaion
like ( memeory info, machine info , ports info )
|
|
|
|
|
you have to install some component over there . to whom you will query and it will reply you back. like web service. or any component deployed on Transaction server or through remoting.
|
|
|
|
|
Hi,
How to display the images in VB.NETDatagrid
Thanks
|
|
|
|
|
Hello All,
I am not sure if I am repeating the same question asked in this forum before.
Can we dynamically generate the reports, say, like an user selecting the required fields across DB tables (through a front-end), specifying the criteria -us building the SQL query- and fetching the result from the DB.
Any help on this would be appreciated.
Thanks
|
|
|
|
|
Yes, of course we can. You need to provide the user with a list of possible search fields, build your SQL from them, check for injection attacks, and run the query. Which bit are you stuck on ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi
First of all thanks for the reply
i am stuck at building sql query from the fields selected and then passing it on to the reports
Can you please help me out
|
|
|
|
|
Do you know any SQL at all ? I can't give advice that's any better than what google will offer unless I know what's in the tables you're searching.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Yes i do know sql
I will give you a brief description with example
I have two different tables Say StuMaster and StuDetails
In StuMaster i have rollno,name,year
in studetails i have his rollno,addressinfo,marksinfo of eachsubject
Now i need something like selecting
rollno,name,year from master and marks of selected subjects of that year from the details table
So i will select the required subjects from the listbox and those fields are to be displayed onto the report.
|
|
|
|
|
Anonymous wrote:
marksinfo of eachsubject
Does this mean there's a column per subject, or are they all lumped in there ?
You want to select subjects, but that makes no sense, there's no column there to search by subject.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
each subject each column
and its search by column ie subject
|
|
|
|
|
You said : in studetails i have his rollno,addressinfo,marksinfo of eachsubject
Now you say : each subject each column
What does 'each subject each column' mean ? Each subject has it's own column ? So every possible subject has a column, even the ones a student is not taking ? That's *terrible* database design.
So how do you mark that a person didn't take a subjuct, is the column null ?
All you need to do is join on the ID, and check that the subject you want to recieve is not null. But the core problem is that if I understand you correctly, your database is crap. Are you able to change the schema to something reasonable ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
its the example one christy its not the actual one actually my TL asked me to find out solution
so i made up an example for it
|
|
|
|
|
I don't get it - so the example you gave me is NOT the table structure ? What's a TL ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Yes its not the table structure its a temporary one
TL is team leader
|
|
|
|
|
Hi,
I am trying to connect to a database using VB6, ADO and Access 2000. I have a combobox with the names of all the registered DNSs on the computer. When I select a DSN from the combobox I have to retrieve some records from the DB indicated by the chosen DSN. How can I connect to the database using the DSN name?
Thanks very much for your help,
dlarkin77
|
|
|
|
|
I'm making an ASP webpage using VB.NET. I'm creating controls on the fly. When I create my dropdownlists on the fly I am getting an odd behavior. When I change the selected value of one of the controls in the array it changes it for all of them.
I'm currently filling an array of listitems from a database and then using AddRange to add the values to each dropdownlist.
When I attempt to use the SelectedValue property of the dropdownlist to set which value is selected, it effects all of the dropdown lists. I can tell this because every drop down list is set the value the last item should have.
This is the loop I use to fill the listitem array (it's redim-ed to the proper size)
ctr = 0
For Each drddlFill In ds.Tables("dtEmps").Rows
lsiUpline(ctr) = New System.Web.UI.WebControls.ListItem
lsiUpline(ctr).Text = drddlFill("employee_id") & " - " & drddlFill("first_name") & " " & drddlFill("last_name")
lsiUpline(ctr).Value = drddlFill("employee_id")
ctr += 1
Next
Next I fill each drop down list
Row = new TableRow
Cell = new TablecCell
ddlUpline_Array(ctr).Items.AddRange(lsiUpline)
ddlUpline_Array(ctr).SelectedValue = databaseInfo("ID")
Cell.Controls.Add(ddlUpline_Array(ctr))
Row.Cells.Add(Cell)
tblBaseshop.Rows.Add(Row)
databaseInfo is pulling correct information. The rest of the row is filled with information from this so I know it is different for each row.
Every dropdownlist in ddlUpline_Array gets set to the selection of the last it.
Any advice on how to get each ddl set to a different selection? If I do a loop and fill each box from the database each time, the selection will be different for each box, but that is much too time consuming.
Thanks
The wisest of the wise may err. - Aeschylus
|
|
|
|
|
Well I want to do a sort of stat tracker for my first true project in VS.NET. It will be for a wrestling team. 13 players. about 5 or 6 categories. Data entry, Data accessing, Stat sorting..
Im planning on using a VB.NET frontend w/ an Access 2003 backend. I think it should be a fun project and ill be well acquinted with vb.net afterwards.
Your input? Mind Numbing easy project? How many man hours are you estimating? Im thinking until mid September with all of the bugs worked out.
Thanks for your E-ear
._._._._._.-.-.-.-.-._._._._._.-.-.-.-.-._._._._._.-.-.-.-.-
Spimoles.NET
clean and elegant. a beautiful craft
|
|
|
|
|
Does anybody have any idea what this means?
************** Exception Text **************
System.ArgumentException: Invalid parameter used.
at System.Drawing.Bitmap..ctor(String filename)
at Mule.DataManagementTool.frmMain.populateListView()
at Mule.DataManagementTool.frmMain.TreeView1_AfterSelect(Object sender, TreeViewEventArgs e)
at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)
at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)
at System.Windows.Forms.TreeView.WmNotify(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
Thanks
Brad
|
|
|
|
|
You clicked on a TreeView node and the code in the AfterSelect event called a populateListView method, which apparent tried to create a Bitmap object, but with the wrong arguments supplied or a bad filename.
Without seeing the code in that populateListView method, it's pretty difficult to say exactly why it happened.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Okay, Thanks.
I see what I did. I hard coded a non-existent path.
Brad
|
|
|
|